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

Ver: 8.3