Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target
ADMINISTRATIVE_GROUP	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO
CARRIER_ROUTE	Address carrier route.	VARCHAR2(63)	SPRADDR	SPRADDR_CARRIER_ROUTE	NO	NO
CITY	Address, city, town or municipality of employee.	VARCHAR2(63)	SPRADDR	SPRADDR_CITY	NO	NO
CORRECTION_DIGIT	Address correction digit.	NUMBER	SPRADDR	SPRADDR_CORRECTION_DIGIT	NO	NO
COUNTY	County for this address record.	VARCHAR2(63)	SPRADDR	SPRADDR_CNTY_CODE	NO	NO
COUNTY_DESC	Name of the county in the address.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
DELIVERY_POINT	Address delivery point.	NUMBER	SPRADDR	SPRADDR_DELIVERY_POINT	NO	NO
EMPLOYER_CATEGORY	Employer type code (for example, Higher Education, Government, Commercial).	VARCHAR2(63)	APREHIS PPREXPE	APREHIS_JOBC_CODE PPREXPE_EMTY_CODE	NO NO	NO
EMPLOYER_CATEGORY2	A code identifying the job category or employer type.	VARCHAR2(63)	APREHIS	APREHIS_JOBC_CODE2	NO	NO
EMPLOYER_CATEGORY2_DESC	Employer category description.	VARCHAR2(255)	ATVJOBC	ATVJOBC_DESC	NO	NO
EMPLOYER_CATEGORY3	Job category or employer type code.	VARCHAR2(63)	APREHIS	APREHIS_JOBC_CODE3	NO	NO
EMPLOYER_CATEGORY3_DESC	Employer category description.	VARCHAR2(255)	ATVJOBC	ATVJOBC_DESC	NO	NO
EMPLOYER_CATEGORY4	Job category or employer type code.	VARCHAR2(63)	APREHIS	APREHIS_JOBC_CODE4	NO	NO
EMPLOYER_CATEGORY4_DESC	Employer category description.	VARCHAR2(255)	ATVJOBC	ATVJOBC_DESC	NO	NO
EMPLOYER_CATEGORY_DESC	Employer category description.	VARCHAR2(255)	ATVJOBC	ATVJOBC_DESC	NO	NO
EMPLOYER_COMMENT	Free form text comment for this employer.	CLOB	APREHIS	APREHIS_COMMENT	NO	NO
EMPLOYER_ID	Employer's current identification number.	VARCHAR2(63)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
EMPLOYER_INDUSTRIAL_DESC	Standard industry code (sic) description.	VARCHAR2(255)	ATVSICC	ATVSICC_DESC	NO	NO
EMPLOYER_INDUSTRIAL_TYPE	Standard industrial code of the employer.	VARCHAR2(63)	APREHIS	APREHIS_SICC_CODE	NO	NO
EMPLOYER_NAME	Employer's name.	VARCHAR2(255)	APREHIS PPREXPE SPRIDEN	APREHIS_EMPR_NAME PPREXPE_EMPR_NAME SPRIDEN_LAST_NAME	NO NO NO	NO
EMPLOYER_UID	System generated unique internal identification number assigned to this person or organization entity.	NUMBER	APREHIS	APREHIS_EMPR_PIDM	NO	NO
EMPLOYMENT_ORDER	Internal sequence number when available for the order of the positions.	NUMBER	APREHIS	APREHIS_SEQ_NO	NO	NO
EMPLOYMENT_STATUS	Employment status code.	VARCHAR2(63)	APREHIS	APREHIS_EMPS_CODE	NO	NO
EMPLOYMENT_STATUS_ACTIVE_IND	Status active indicator.	VARCHAR2(1)	ATVEMPS	ATVEMPS_ACTIVE_IND	NO	NO
EMPLOYMENT_STATUS_DESC	Employment status code description.	VARCHAR2(255)	ATVEMPS	ATVEMPS_DESC	NO	NO
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	NO	NO
ID_SOURCE	Name of the source system that provided the value in the ID_NUMBER field.	VARCHAR2(10)	CONSTANT CONSTANT	'BAN-ALUMNI' 'BAN-HR'	NO NO	NO
MATCHING_GIFT_COMPANY_ID	Entity's identification number used to access the records associated with the entity.	VARCHAR2(63)	SPRIDEN	SPRIDEN_ID	NO	NO
MATCHING_GIFT_COMPANY_NAME	Organization name.	VARCHAR2(255)	SPRIDEN	SPRIDEN_LAST_NAME	NO	NO
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	NO	NO
MATCHING_GIFT_IND	Whether a related reference has a matching gift associated with it.	VARCHAR2(1)	APREHIS	APREHIS_MG_IND	NO	NO
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)	NO NO	NO
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	NO	NO
MULTI_SOURCE_DESC	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	NO	NO
NAME	Name of the person (last name, first name, middle initial) or organization.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
NATION	Nation/country of employee.	VARCHAR2(63)	PPREXPE SPRADDR	PPREXPE_NATN_CODE SPRADDR_NATN_CODE	NO NO	NO
NATION_DESC	Nation/country description associated with the address.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
PERSON_UID	System generated unique internal identification number assigned to this person.	NUMBER	APREHIS PPREXPE	APREHIS_PIDM PPREXPE_PIDM	NO NO	NO
PHONE_NUMBER_COMBINED	Combination of the area code, phone number and extension of employee.	VARCHAR2(63)	SPRADDR	SPRADDR_CARRIER_ROUTE	NO	NO
POSITION_TITLE	Employee's job title.	VARCHAR2(63)	APREHIS PPREXPE	APREHIS_EMPL_POSITION PPREXPE_POSN_TITLE	NO NO	NO
POSTAL_CODE	Address postal code.	VARCHAR2(63)	SPRADDR	SPRADDR_ZIP	NO	NO
PRIMARY_EMPLOYMENT_IND	Indicates whether the record is the primary employment record.	VARCHAR2(1)	APREHIS	APREHIS_PRIMARY_IND	NO	NO
PROCESS_GROUP	Institution value of the process-oriented identifier for the record used to determine access authorization to this record.	VARCHAR2(255)	NA	NA	NO	NO
REASON_LEFT	Reason the employee left that position.	VARCHAR2(63)	PPREXPE	PPREXPE_REASON_LEFT	NO	NO
START_DATE	Start date during which this experience was obtained.	DATE	APREHIS PPREXPE	APREHIS_FROM_DATE PPREXPE_START_DATE	NO NO	NO
STATE_PROVINCE	State/Province of employee.	VARCHAR2(63)	PPREXPE SPRADDR	PPREXPE_STAT_CODE SPRADDR_STAT_CODE	NO NO	NO
STATE_PROVINCE_DESC	Address state/province.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
STREET_LINE1	First line of employee address.	VARCHAR2(255)	SPRADDR	SPRADDR_STREET_LINE1	NO	NO
STREET_LINE2	Second line of employee address.	VARCHAR2(255)	SPRADDR	SPRADDR_STREET_LINE2	NO	NO
STREET_LINE3	Third line of employee address.	VARCHAR2(255)	SPRADDR	SPRADDR_STREET_LINE3	NO	NO
STREET_LINE4	Fourth line of the address.	VARCHAR2(255)	SPRADDR	SPRADDR_STREET_LINE4	NO	NO
WEEKLY_HOURS	Hours per week for part-time employee used for matching gift qualification.	NUMBER	APREHIS	APREHIS_WKLY_HOURS	NO	NO

Ver: 9.2