Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target
ADDRESS_TYPE_DESC	Address type description.	VARCHAR2(30)	STVATYP	STVATYP_DESC	NO	NO
CURRENT_DATE	System current date (sysdate) or date the data was extracted.	DATE	NA	SYSDATE	NO	NO
DOMAIN_VALUE	Organization-oriented identifier for the record used to determine access authorization. Institution defined.	VARCHAR2(6)	NA	NA	NO	NO
EMPLOYEE_ADDRESS_SEQ_NUMBER	Sequence used to identify different addresses within the same address type.	NUMBER	APREHIS	APREHIS_ATYP_SEQNO	NO	NO
EMPLOYEE_ADDRESS_TYPE	Type of address for this address record. Examples, may be address types of mailing, temporary summer, billing and permanent.	VARCHAR2(2)	APREHIS	APREHIS_ATYP_CODE	NO	NO
EMPLOYER_CATEGORY	Identifies the employer type (for example, Higher Education, Government, Commercial).	VARCHAR2(3)	APREHIS	APREHIS_JOBC_CODE	NO	NO
EMPLOYER_CATEGORY2	A code identifying the job category or employer type.	VARCHAR2(3)	APREHIS	APREHIS_JOBC_CODE2	NO	NO
EMPLOYER_CATEGORY2_DESC	Employer category description.	VARCHAR2(60)	ATVJOBC	ATVJOBC_DESC	NO	NO
EMPLOYER_CATEGORY3	A code identifying the job category or employer type.	VARCHAR2(3)	APREHIS	APREHIS_JOBC_CODE3	NO	NO
EMPLOYER_CATEGORY3_DESC	Employer category description.	VARCHAR2(60)	ATVJOBC	ATVJOBC_DESC	NO	NO
EMPLOYER_CATEGORY4	A code identifying the job category or employer type.	VARCHAR2(3)	APREHIS	APREHIS_JOBC_CODE4	NO	NO
EMPLOYER_CATEGORY4_DESC	Employer category description.	VARCHAR2(60)	ATVJOBC	ATVJOBC_DESC	NO	NO
EMPLOYER_CATEGORY_DESC	Employer category description.	VARCHAR2(60)	ATVJOBC	ATVJOBC_DESC	NO	NO
EMPLOYER_COMMENT	Free form text comment for this employer.	CLOB	FUNCTION	GOKODSF.F_TRIM_LONGS	NO	NO
EMPLOYER_INDUSTRIAL_DESC	Standard industry code (sic) description.	VARCHAR2(60)	ATVSICC	ATVSICC_DESC	NO	NO
EMPLOYER_INDUSTRIAL_TYPE	Standard industrial code of the employer.	VARCHAR2(4)	AOBORGN APREHIS	AOBORGN_SICC_CODE APREHIS_SICC_CODE	NO NO	NO
EMPLOYER_NAME	The name of the previous or current employer at which this experience was obtained.	VARCHAR2(60)	APREHIS	APREHIS_EMPR_NAME	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(1)	APREHIS	APREHIS_EMPS_CODE	NO	NO
EMPLOYMENT_STATUS_ACTIVE_IND	Status active indicator.	VARCHAR2(1)	CALCULATION	NVL(ATVEMPS_ACTIVE_IND,'N')	NO	NO
EMPLOYMENT_STATUS_DESC	Employment status code description.	VARCHAR2(30)	ATVEMPS	ATVEMPS_DESC	NO	NO
END_DATE	End date for the period of time during which this experience was obtained.	DATE	APREHIS	APREHIS_TO_DATE	NO	NO
MATCHING_GIFT_IND	Whether a related reference has a matching gift associated with it.	VARCHAR2(1)	APREHIS	APREHIS_MG_IND	NO	NO
MIF_DESC	Institution description for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(30)	NA	NA	NO	NO
MIF_VALUE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(6)	NA	NA	NO	NO
MONTHS_IN_POSITION	Years and months the person was in this previous employment position. Calculated by using the position start and end dates.	NUMBER	CALCULATION	MONTHS_BETWEEN(NVL(APREHIS_TO_DATE,SYSDATE),APREHIS_FROM_DATE)	NO	NO
PERSON_UID	System generated, unique, internal identification number assigned to the person.	NUMBER	APREHIS	APREHIS_PIDM	NO	NO
POSITION_TITLE	Title of the position occupied while obtain this experience.	VARCHAR2(60)	APREHIS	APREHIS_EMPL_POSITION	NO	NO
PRIMARY_EMPLOYMENT_IND	Indicates whether the record is the primary employment record.	VARCHAR2(1)				NO
START_DATE	Starting date of the period of time during which this experience was obtained.	DATE	APREHIS	APREHIS_FROM_DATE	NO	NO
WEEKLY_HOURS	Hours per week for parttime employee used for matching gift qualification.	NUMBER	APREHIS	APREHIS_WKLY_HOURS	NO	NO
ZONE_VALUE	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)	NA	NA	NO	NO

Ver: