| Target Column |
Business Name |
Business Definition |
Database Data Type |
Source Name |
Source Column |
|
ADMINISTRATIVE_GROUP
|
Administrative Group
|
Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|
|
CARRIER_ROUTE
|
Carrier Route
|
Address carrier route.
|
VARCHAR2(63)
|
SPRADDR
|
SPRADDR_CARRIER_ROUTE
|
|
CITY
|
City
|
Address, city, town or municipality of employee.
|
VARCHAR2(63)
|
SPRADDR
|
SPRADDR_CITY
|
|
CORRECTION_DIGIT
|
Correction Digit
|
Address correction digit.
|
NUMBER
|
SPRADDR
|
SPRADDR_CORRECTION_DIGIT
|
|
COUNTY
|
County
|
County for this address record.
|
VARCHAR2(63)
|
SPRADDR
|
SPRADDR_CNTY_CODE
|
|
COUNTY_DESC
|
County Description
|
Name of the county in the address.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
DELIVERY_POINT
|
Delivery Point
|
Address delivery point.
|
NUMBER
|
SPRADDR
|
SPRADDR_DELIVERY_POINT
|
|
EMPLOYER_CATEGORY
|
Employer Category
|
Employer type code (for example, Higher Education, Government, Commercial).
|
VARCHAR2(63)
|
APREHIS PPREXPE
|
APREHIS_JOBC_CODE PPREXPE_EMTY_CODE
|
|
EMPLOYER_CATEGORY2
|
Employer Category 2
|
A code identifying the job category or employer type.
|
VARCHAR2(63)
|
APREHIS
|
APREHIS_JOBC_CODE2
|
|
EMPLOYER_CATEGORY2_DESC
|
Employer Category 2 Description
|
Employer category description.
|
VARCHAR2(255)
|
ATVJOBC
|
ATVJOBC_DESC
|
|
EMPLOYER_CATEGORY3
|
Employer Category 3
|
Job category or employer type code.
|
VARCHAR2(63)
|
APREHIS
|
APREHIS_JOBC_CODE3
|
|
EMPLOYER_CATEGORY3_DESC
|
Employer Category 3 Description
|
Employer category description.
|
VARCHAR2(255)
|
ATVJOBC
|
ATVJOBC_DESC
|
|
EMPLOYER_CATEGORY4
|
Employer Category 4
|
Job category or employer type code.
|
VARCHAR2(63)
|
APREHIS
|
APREHIS_JOBC_CODE4
|
|
EMPLOYER_CATEGORY4_DESC
|
Employer Category 4 Description
|
Employer category description.
|
VARCHAR2(255)
|
ATVJOBC
|
ATVJOBC_DESC
|
|
EMPLOYER_CATEGORY_DESC
|
Employer Category Description
|
Employer category description.
|
VARCHAR2(255)
|
ATVJOBC
|
ATVJOBC_DESC
|
|
EMPLOYER_COMMENT
|
Employer Comment
|
Free form text comment for this employer.
|
CLOB
|
APREHIS
|
APREHIS_COMMENT
|
|
EMPLOYER_ID
|
Employer ID
|
Employer's current identification number.
|
VARCHAR2(63)
|
FUNCTION
|
MGKFUNC.F_GET_PERSON_INFO
|
|
EMPLOYER_INDUSTRIAL_DESC
|
Employer Industrial Description
|
Standard industry code (sic) description.
|
VARCHAR2(255)
|
ATVSICC
|
ATVSICC_DESC
|
|
EMPLOYER_INDUSTRIAL_TYPE
|
Employer Industrial Type
|
Standard industrial code of the employer.
|
VARCHAR2(63)
|
APREHIS
|
APREHIS_SICC_CODE
|
|
EMPLOYER_NAME
|
Employer Name
|
Employer's name.
|
VARCHAR2(255)
|
APREHIS PPREXPE SPRIDEN
|
APREHIS_EMPR_NAME PPREXPE_EMPR_NAME SPRIDEN_LAST_NAME
|
|
EMPLOYER_UID
|
Employer UID
|
System generated unique internal identification number assigned to this person or organization entity.
|
NUMBER
|
APREHIS
|
APREHIS_EMPR_PIDM
|
|
EMPLOYMENT_ORDER
|
Employment Order
|
Internal sequence number when available for the order of the positions.
|
NUMBER
|
APREHIS
|
APREHIS_SEQ_NO
|
|
EMPLOYMENT_STATUS
|
Employment Status
|
Employment status code.
|
VARCHAR2(63)
|
APREHIS
|
APREHIS_EMPS_CODE
|
|
EMPLOYMENT_STATUS_ACTIVE_IND
|
Employment Status Active Indicator
|
Status active indicator.
|
VARCHAR2(1)
|
ATVEMPS
|
ATVEMPS_ACTIVE_IND
|
|
EMPLOYMENT_STATUS_DESC
|
Employment Status Description
|
Employment status code description.
|
VARCHAR2(255)
|
ATVEMPS
|
ATVEMPS_DESC
|
|
ID
|
ID
|
Identification number assigned to a person that is used externally for all communication and correspondence with the person.
|
VARCHAR2(63)
|
FUNCTION
|
MGKFUNC.F_GET_PERSON_INFO
|
|
ID_SOURCE
|
ID Source
|
Name of the source system that provided the value in the ID_NUMBER field.
|
VARCHAR2(10)
|
CONSTANT CONSTANT
|
'BAN-ALUMNI' 'BAN-HR'
|
|
MATCHING_GIFT_COMPANY_ID
|
Matching Gift Company ID
|
Entity's identification number used to access the records associated with the entity.
|
VARCHAR2(63)
|
SPRIDEN
|
SPRIDEN_ID
|
|
MATCHING_GIFT_COMPANY_NAME
|
Matching Gift Company Name
|
Organization name.
|
VARCHAR2(255)
|
SPRIDEN
|
SPRIDEN_LAST_NAME
|
|
MATCHING_GIFT_COMPANY_UID
|
Matching Gift Company UID
|
Internal identification number for the matching gift company associated with the organization. The identification number may be the same identification number or the parent identification number.
|
NUMBER
|
AOBORGN
|
AOBORGN_MG_PIDM
|
|
MATCHING_GIFT_IND
|
Matching Gift Indicator
|
Whether a related reference has a matching gift associated with it.
|
VARCHAR2(1)
|
APREHIS
|
APREHIS_MG_IND
|
|
MONTHS_IN_POSITION
|
Months IN Position
|
Years and months the person was in the previous employment position. Calculated using the position start and end dates.
|
NUMBER
|
CALCULATION CALCULATION
|
MONTHS_BETWEEN(NVL(APREHIS_TO_DATE,SYSDATE),APREHIS_FROM_DATE) MONTHS_BETWEEN(PPREXPE_END_DATE, PPREXPE_START_DATE)
|
|
MULTI_SOURCE
|
Multi Source
|
Institution value for the record when the optional multi-institution facility feature has been installed and applied for this table/column.
|
VARCHAR2(63)
|
NA
|
NA
|
|
MULTI_SOURCE_DESC
|
Multi Source Description
|
Institution description for the record when the optional multi-institution facility feature has been installed and applied for this table/column.
|
VARCHAR2(255)
|
NA
|
NA
|
|
NAME
|
Name
|
Name of the person (last name, first name, middle initial) or organization.
|
VARCHAR2(255)
|
FUNCTION
|
MGKFUNC.F_GET_PERSON_INFO
|
|
NATION
|
Nation
|
Nation/country of employee.
|
VARCHAR2(63)
|
PPREXPE SPRADDR
|
PPREXPE_NATN_CODE SPRADDR_NATN_CODE
|
|
NATION_DESC
|
Nation Description
|
Nation/country description associated with the address.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
PERSON_UID
|
Person UID
|
System generated unique internal identification number assigned to this person.
|
NUMBER
|
APREHIS PPREXPE
|
APREHIS_PIDM PPREXPE_PIDM
|
|
PHONE_NUMBER_COMBINED
|
Phone Number Combined
|
Combination of the area code, phone number and extension of employee.
|
VARCHAR2(63)
|
SPRADDR
|
SPRADDR_CARRIER_ROUTE
|
|
POSITION_TITLE
|
Position Title
|
Employee's job title.
|
VARCHAR2(255)
|
APREHIS PPREXPE
|
APREHIS_EMPL_POSITION PPREXPE_POSN_TITLE
|
|
POSTAL_CODE
|
Postal Code
|
Address postal code.
|
VARCHAR2(63)
|
SPRADDR
|
SPRADDR_ZIP
|
|
PRIMARY_EMPLOYMENT_IND
|
Primary Employment Indicator
|
Indicates whether the record is the primary employment record.
|
VARCHAR2(1)
|
APREHIS
|
APREHIS_PRIMARY_IND
|
|
PROCESS_GROUP
|
Process Group
|
Institution value of the process-oriented identifier for the record used to determine access authorization to this record.
|
VARCHAR2(255)
|
NA
|
NA
|
|
REASON_LEFT
|
Reason Left
|
Reason the employee left that position.
|
VARCHAR2(63)
|
PPREXPE
|
PPREXPE_REASON_LEFT
|
|
START_DATE
|
Start Date
|
Start date during which this experience was obtained.
|
DATE
|
APREHIS PPREXPE
|
APREHIS_FROM_DATE PPREXPE_START_DATE
|
|
STATE_PROVINCE
|
State Province
|
State/Province of employee.
|
VARCHAR2(63)
|
PPREXPE SPRADDR
|
PPREXPE_STAT_CODE SPRADDR_STAT_CODE
|
|
STATE_PROVINCE_DESC
|
State Province Description
|
Address state/province.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
STREET_LINE1
|
Street Line 1
|
First line of employee address.
|
VARCHAR2(255)
|
SPRADDR
|
SPRADDR_STREET_LINE1
|
|
STREET_LINE2
|
Street Line 2
|
Second line of employee address.
|
VARCHAR2(255)
|
SPRADDR
|
SPRADDR_STREET_LINE2
|
|
STREET_LINE3
|
Street Line 3
|
Third line of employee address.
|
VARCHAR2(255)
|
SPRADDR
|
SPRADDR_STREET_LINE3
|
|
STREET_LINE4
|
Street Line 4
|
Fourth line of the address.
|
VARCHAR2(255)
|
SPRADDR
|
SPRADDR_STREET_LINE4
|
|
WEEKLY_HOURS
|
Weekly Hours
|
Hours per week for part-time employee used for matching gift qualification.
|
NUMBER
|
APREHIS
|
APREHIS_WKLY_HOURS
|