Target Column	Business Definition	Database Data Type	Source Name	Source Column
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	Campus associated with this record. Campus for the course section, student course, student, applied for on the admission application, etc.	VARCHAR2(3)	PEBEMPL	PEBEMPL_CAMP_CODE
CAMPUS_DESC	The Campus description.	VARCHAR2(30)	STVCAMP	STVCAMP_DESC
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.	VARCHAR2(35)	FUNCTION PTVORGN	F_GET_FINANCE_DESC PTVORGN_DESC
CHECK_DIST_ORGANIZATION	The organization code used for document distribution.	VARCHAR2(6)	PEBEMPL	PEBEMPL_ORGN_CODE_DIST
CHECK_DIST_ORGANIZATION_DESC	Check distribution organization description.	VARCHAR2(35)	FUNCTION PTVORGN	F_GET_FINANCE_DESC PTVORGN_DESC
COLLEGE	First level of the institution organization structure that owns the student or the academic instruction for a student course.	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	Identifies the most recent date the eectronic consent indicator was updated.	DATE	PEBEMPL	PEBEMPL_EW2_CONSENT_DATE
ELECTRONIC_CONSENT_IND	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	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	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.	VARCHAR2(30)	CALCULATION	DECODE(PEBEMPL_FLSA_IND)
FEDERAL_MEDICAL_DENTAL_IND		VARCHAR2(1)
FEDERAL_SOFT_MONEY_IND	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	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	The Location to which the employee belongs.	VARCHAR2(6)	PEBEMPL	PEBEMPL_JBLN_CODE
HIRING_LOCATION_DESC	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	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	PEBEMPL	PEBEMPL_DAYS_IN_CANADA
NONRESIDENT_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-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	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		VARCHAR2(3)
PROFILE_DATE	Profile Date associated with this record.	VARCHAR2(0)	FUNCTION	F_PROFILE_DATE
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 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	The user who last created or updated the employee record.	VARCHAR2(30)	PEBEMPL	PEBEMPL_USER_ID
WORK_PERIOD	Code that defines the work period.	VARCHAR2(4)	PEBEMPL	PEBEMPL_WKPR_CODE
WORK_PERIOD_DESC	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: