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

Ver: