Target Column	Business Name	Business Definition	Database Data Type	Domain Value	Source Name	Source Column
ACTIVITY_DATE	Activity Date	Date when the record was inserted or last modified.	DATE		PEBEMPL	PEBEMPL_ACTIVITY_DATE
ADJUSTED_SERVICE_DATE		Date used to determine years of service for leave accrual if the first hire date and current hire date are not equal.	DATE		PEBEMPL	PEBEMPL_ADJ_SERVICE_DATE
BENEFIT_CATEGORY		Benefit category to which the employee belongs.	VARCHAR2(2)		PEBEMPL	PEBEMPL_BCAT_CODE
BENEFIT_CATEGORY_DESC		Benefits category description.	VARCHAR2(30)		PTRBCAT	PTRBCAT_DESC
CAMPUS		The Campus to which the employee belongs.	VARCHAR2(3)		PEBEMPL	PEBEMPL_CAMP_CODE
CAMPUS_DESC		The Campus description.	VARCHAR2(30)		STVCAMP	STVCAMP_DESC
CHECK_DISTRIBUTION_CHART	Check Distribution Chart	The chart of accounts code to which the employee's documents, such as checks, are distributed.	VARCHAR2(1)		PEBEMPL	PEBEMPL_COAS_CODE_DIST
CHECK_DISTRIBUTION_CHART_DESC	Check Distribution Chart Description	Check distribution chart description.	VARCHAR2(35)		FUNCTION PTVORGN	F_GET_FINANCE_DESC PTVORGN_DESC
CHECK_DIST_ORGANIZATION	Check Distribution Organization	The organization code used for document distribution.	VARCHAR2(6)		PEBEMPL	PEBEMPL_ORGN_CODE_DIST
CHECK_DIST_ORGANIZATION_DESC	Check Distribution Organization Description	Check distribution organization description.	VARCHAR2(35)		FUNCTION PTVORGN	F_GET_FINANCE_DESC PTVORGN_DESC
COLLEGE		The College to which the employee belongs.	VARCHAR2(2)		PEBEMPL	PEBEMPL_COLL_CODE
COLLEGE_DESC		The College description	VARCHAR2(30)		STVCOLL	STVCOLL_DESC
CONTRACT_TYPE		Identifies the type of faculty contract assigned to the person. Included may be full time, adjunct or continuing education only, etc.	VARCHAR2(0)		NBRBJOB	NBRBJOB_CONTRACT_TYPE
CONTRACT_TYPE_DESC		Type of faculty contract description.	VARCHAR2(0)		CALCULATION	DECODE(NBRBJOB_CONTRACT_TYPE, 'P', 'PRIMARY', 'S', 'SECONDARY', 'O', 'OVERLOAD')
CURRENT_DATE		System current date (sysdate) or date the data was extracted.	DATE		NA	SYSDATE
CURRENT_HIRE_DATE		Employees current date of hire. May differ from original date of hire in cases where an employee is re-hired.	DATE		PEBEMPL	PEBEMPL_CURRENT_HIRE_DATE
DIVISION		District or division associated with an employee.	VARCHAR2(3)		PEBEMPL	PEBEMPL_DICD_CODE
DIVISION_DESC		District or division description.	VARCHAR2(30)		GTVDICD	GTVDICD_DESC
DOMAIN_VALUE		Organization-oriented identifier for the record used to determine access authorization. Institution defined.	VARCHAR2(6)		NA	NA
EEO_CATEGORY		Used by institutions of higher education for Equal Employment Opportunity reporting as defined by the federal government.	VARCHAR2(0)		NTRPCLS	NTRPCLS_ESKL_CODE
EEO_CATEGORY_DESC		EEO category code description.	VARCHAR2(0)		NA	NA
EEO_SKILL		Used by institutions of higher education for Equal Employment Opportunity skills reporting as defined by the federal government.	VARCHAR2(0)		PTVESKL	PTVESKL_CODE
EEO_SKILL_DESC		EEO skill description.	VARCHAR2(0)		NA	NA
ELECTRONIC_CONSENT_DATE	Electronic Consent Date	Identifies the most recent date the eectronic consent indicator was updated.	DATE		PEBEMPL	PEBEMPL_EW2_CONSENT_DATE
ELECTRONIC_CONSENT_IND	Electronic Consent Indicator	Indicates the employee has consented to receive their annual earnins statement (W-2, in the United States) electronically.	VARCHAR2(1)		PEBEMPL	PEBEMPL_EW2_CONSENT_IND
ELECTRONIC_CONSENT_USER_ID	Electronic Consent User ID	The unique identification of the user who last updated the electronic consent indicator.	VARCHAR2(30)		PEBEMPL	PEBEMPL_EW2_CONSENT_USER_ID
EMPLOYEE_CLASS		Employee class code. Organizes position information consistent with employee groupings. At the employee level, used to help determine controls for benefits, leave, payroll and self-service rules.	VARCHAR2(2)		PEBEMPL	PEBEMPL_ECLS_CODE
EMPLOYEE_CLASS_LONG_DESC		Employee class long description.	VARCHAR2(30)		PTRECLS	PTRECLS_LONG_DESC
EMPLOYEE_CLASS_SHORT_DESC		Employee Class short description.	VARCHAR2(8)		PTRECLS	PTRECLS_SHORT_DESC
EMPLOYEE_GROUP		Sub-category of the employee class.	VARCHAR2(4)		PEBEMPL	PEBEMPL_EGRP_CODE
EMPLOYEE_GROUPING		Statistics Canada grouping code used for statistics Canada reporting for government installations.	VARCHAR2(2)		PEBEMPL	PEBEMPL_STGR_CODE
EMPLOYEE_GROUPING_DESC		Statistics Canada grouping description.	VARCHAR2(30)		PTVSTGR	PTVSTGR_DESC
EMPLOYEE_GROUP_DESC		Description of the employee group.	VARCHAR2(30)		PTVEGRP	PTVEGRP_DESC
EMPLOYEE_STATUS		Status of the employee (Active, Termed, etc.).	VARCHAR2(1)		PEBEMPL	PEBEMPL_EMPL_STATUS
EMPLOYEE_STATUS_DESC		Employee Status description.	VARCHAR2(30)		CALCULATION	DECODE(PEBEMPL_EMPL_STATUS)
FAIR_LABOR_STANDARDS_TYPE	Fair Labor Standards Type	Indicates the type of fair labor standards overtime compensation to be paid to the employee.	VARCHAR2(1)		PEBEMPL	PEBEMPL_FLSA_IND
FAIR_LABOR_STANDARDS_TYPE_DESC	Fair Labor Standards Type Description	Fair labor standards type description.	VARCHAR2(30)		CALCULATION	DECODE(PEBEMPL_FLSA_IND)
FEDERAL_MEDICAL_DENTAL_IND	Federal Medical Dental Indicator		VARCHAR2(1)
FEDERAL_SOFT_MONEY_IND	Federal Soft Money Indicator	Indicates employee is paid in full from soft money. Va.lid values are: Y = paid with soft money or N = not paid with soft money. Banner HR default is N.	VARCHAR2(1)		PEBEMPL	PEBEMPL_IPEDS_SOFT_MONEY_IND
FIRST_WORK_DATE	First Work Date	The first day that the employee worked.	DATE		PEBEMPL	PEBEMPL_FIRST_WORK_DATE
FOREIGN_INCOME_RECIPIENT_DESC		1042 recipient description.	VARCHAR2(35)		CALCULATION	DECODE(PEBEMPL_1042_RECIPIENT_CD)
FOREIGN_INCOME_RECIPIENT_TYPE		Identifies an employment type for a foreign individual who is receiving employment payments outside their home country. In the US this is a 1042 statement.	VARCHAR2(2)		PEBEMPL	PEBEMPL_1042_RECIPIENT_CD
FULL_OR_PART_TIME_IND		Internal part time/full time indicator, used for EEO reporting.	VARCHAR2(1)		PEBEMPL	PEBEMPL_INTERNAL_FT_PT_IND
HIRING_LOCATION	Hiring Location	The Location to which the employee belongs.	VARCHAR2(6)		PEBEMPL	PEBEMPL_JBLN_CODE
HIRING_LOCATION_DESC	Hiring Location Description	Hiring location description.	VARCHAR2(30)		PTRJBLN	PTRJBLN_DESC
HOME_ORGANIZATION		Home organization code of the employee.	VARCHAR2(6)		PEBEMPL	PEBEMPL_ORGN_CODE_HOME
HOME_ORGANIZATION_CHART		Home chart of accounts code for the employee.	VARCHAR2(1)		PEBEMPL	PEBEMPL_COAS_CODE_HOME
HOME_ORGANIZATION_CHART_DESC		The home Chart of Accounts Code description for the employee.	VARCHAR2(35)		FUNCTION PTVORGN	FOKODSF.F_GET_FINANCE_DESC PTVORGN_DESC
HOME_ORGANIZATION_DESC		Organization to which this Employee_Position's time sheet will be sent.	VARCHAR2(35)		FUNCTION PTVORGN	F_GET_FINANCE_DESC PTVORGN_DESC
IMMIGRATION_DATE		Date immigration information was received. For U.S. clients, this is the date the I-9 form was filed.	DATE		PEBEMPL	PEBEMPL_I9_DATE
IMMIGRATION_EXPIRATION_DATE		Date the immigration information expires. For U.S. clients, this is the date a temporary I-9 form expires.	DATE		PEBEMPL	PEBEMPL_I9_EXPIRE_DATE
IMMIGRATION_STATUS		Indicates whether immigration information has been received. For U.S. clients, this is the I-9 Form status.	VARCHAR2(1)		PEBEMPL	PEBEMPL_I9_FORM_IND
IMMIGRATION_STATUS_DESC		I9 status description.	VARCHAR2(30)		CALCULATION	DECODE(PEBEMPL_I9_FORM_IND,'R',RECEIVED,N,NOTRECEIVED,'T',TEMPORARY,'E',EXEMPT)
LAST_WORK_DATE	Last Work Date	The last day that the employee worked.	DATE		PEBEMPL	PEBEMPL_LAST_WORK_DATE
LEAVE_CATEGORY		Leave category to which the employee belongs.	VARCHAR2(2)		PEBEMPL	PEBEMPL_LCAT_CODE
LEAVE_CATEGORY_DESC		Description or title for the defined Leave Category.	VARCHAR2(30)		PTVLCAT	PTVLCAT_DESC
LEAVE_OF_ABSENCE_BEGIN_DATE		Begin date of a leave of absence for the employee.	DATE		PEBEMPL	PEBEMPL_LOA_BEG_DATE
LEAVE_OF_ABSENCE_END_DATE		Anticipated end date for an employees leave of absence.	DATE		PEBEMPL	PEBEMPL_LOA_END_DATE
LEAVE_OF_ABSENCE_REASON		A code identifying the reason of the leave of absence for the employee.	VARCHAR2(2)		PEBEMPL	PEBEMPL_LREA_CODE
LEAVE_OF_ABSENCE_REASON_DESC		Leave of absence description.	VARCHAR2(30)		PTRLREA	PTRLREA_DESC
MIF_DESC		Institution description 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
NONRESIDENT_DAYS_IN_COUNTRY		Primarily used for Canada T4A-NR reporting. Specifically, the number of days employee worked in Canada.	NUMBER(3)		PEBEMPL	PEBEMPL_DAYS_IN_CANADA
NONRESIDENT_SERVICE_INDUSTRY	Non_Residential Service Industry	Primarily used for Canada T4A-NR reporting. Specifically, displays service Industries represented by non-residents which they report to Revenue Canada.	VARCHAR2(4)		PEBEMPL	PEBEMPL_NRSI_CODE
NONRESIDENT_SERV_INDUSTRY_DESC	Non_Residential Serv Industry Description	Non-resident service industry description.	VARCHAR2(60)		PTVNRSI	PTVNRSI_DESC
ORIGINAL_HIRE_DATE		Date the employee was first hired.	DATE		PEBEMPL	PEBEMPL_FIRST_HIRE_DATE
PERSON_UID		System generated, unique, internal identification number assigned to this person.	NUMBER(8)		PEBEMPL	PEBEMPL_PIDM
POSITION_EMPLOYEE_GROUP		Sub-category of the employee class.	VARCHAR2(4)		PTRECLS	PTRECLS_EGRP_CODE
POSITION_EMPLOYEE_GROUP_DESC		Description of the employee group.	VARCHAR2(30)		PTVEGRP	PTVEGRP_DESC
PRIMARY_FUNCTION	Primary Function		VARCHAR2(3)
PROFILE_DATE		Profile Date associated with this record.	VARCHAR2(0)		FUNCTION	F_PROFILE_DATE
PUBLIC_RETIREMENT_MEMBERSHIP	Public Retirement Membership	Used primarily as to indicate membership in the California Pension plans (STRS/PERS).	VARCHAR2(1)		PEBEMPL	PEBEMPL_CALIF_PENSION_IND
PUBLIC_RETIREMENT_MEMBER_DESC	Public Retirement Member Description	Public retirement membership description.	VARCHAR2(30)		CALCULATION	DECODE(PEBEMPL_CALIF_PENSION_IND)
SENIORITY_DATE		Institution defined date field.	DATE		PEBEMPL	PEBEMPL_SENIORITY_DATE
TERMINATION_DATE		Termination date of the employee.	DATE		PEBEMPL	PEBEMPL_TERM_DATE
TERMINATION_REASON		Code used to identify the reason of termination.	VARCHAR2(2)		PEBEMPL	PEBEMPL_TREA_CODE
TERMINATION_REASON_DESC		Termination reason description.	VARCHAR2(30)		PTRTREA	PTRTREA_DESC
USER_ID	User ID	The user who last created or updated the employee record.	VARCHAR2(30)		PEBEMPL	PEBEMPL_USER_ID
WORK_PERIOD	Work Period	Code that defines the work period.	VARCHAR2(4)		PEBEMPL	PEBEMPL_WKPR_CODE
WORK_PERIOD_DESC	Work Period Description	Work period description.	VARCHAR2(30)		PTRWKPR	PTRWKPR_DESC
ZONE_VALUE		Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)		NA	NA

Ver: