Target Column	Business Name	Business Definition	Database Data Type	Domain Value	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(2)		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 2 Description	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 3 Description	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 4 Description	Employer category description.	VARCHAR2(60)		ATVJOBC	ATVJOBC_DESC
EMPLOYER_CATEGORY_DESC	Employer Category Description	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	Employer Industrial Description	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(8)		APREHIS	APREHIS_EMPR_PIDM
EMPLOYMENT_ORDER		Internal sequence number when available for the order of the positions.	NUMBER(5)		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(8)		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(5, 2)		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: