Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target
ACTIVITY_DATE	Date when the record was inserted or last modified.	DATE	PEBEMPL	PEBEMPL_ACTIVITY_DATE	NO	NO
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	NO	NO
BENEFIT_CATEGORY	Benefit category to which the employee belongs.	VARCHAR2(2)	PEBEMPL	PEBEMPL_BCAT_CODE	NO	NO
BENEFIT_CATEGORY_DESC	Benefits category description.	VARCHAR2(30)	PTRBCAT	PTRBCAT_DESC	NO	NO
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	NO	NO
CAMPUS_DESC	The Campus description.	VARCHAR2(30)	STVCAMP	STVCAMP_DESC	NO	NO
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	NO	NO
CHECK_DISTRIBUTION_CHART_DESC	Check distribution chart description.	VARCHAR2(35)	FUNCTION PTVORGN	F_GET_FINANCE_DESC PTVORGN_DESC	NO NO	NO
CHECK_DIST_ORGANIZATION	The organization code used for document distribution.	VARCHAR2(6)	PEBEMPL	PEBEMPL_ORGN_CODE_DIST	NO	NO
CHECK_DIST_ORGANIZATION_DESC	Check distribution organization description.	VARCHAR2(35)	FUNCTION PTVORGN	F_GET_FINANCE_DESC PTVORGN_DESC	NO NO	NO
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	NO	NO
COLLEGE_DESC	The College description.	VARCHAR2(30)	STVCOLL	STVCOLL_DESC	NO	NO
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	NO	NO
CONTRACT_TYPE_DESC	Type of faculty contract description.	VARCHAR2(0)	CALCULATION	DECODE(NBRBJOB_CONTRACT_TYPE, 'P', 'PRIMARY', 'S', 'SECONDARY', 'O', 'OVERLOAD')	NO	NO
CURRENT_DATE	System current date (sysdate) or date the data was extracted.	DATE	NA	SYSDATE	NO	NO
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	NO	NO
DIVISION	District or division associated with an employee.	VARCHAR2(3)	PEBEMPL	PEBEMPL_DICD_CODE	NO	NO
DIVISION_DESC	District or division description.	VARCHAR2(30)	GTVDICD	GTVDICD_DESC	NO	NO
DOMAIN_VALUE	Organization-oriented identifier for the record used to determine access authorization. Institution defined.	VARCHAR2(6)	NA	NA	NO	NO
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	NO	NO
EEO_CATEGORY_DESC	EEO category code description.	VARCHAR2(0)	NA	NA	NO	NO
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	NO	NO
EEO_SKILL_DESC	EEO skill description.	VARCHAR2(0)	NA	NA	NO	NO
ELECTRONIC_CONSENT_DATE	Identifies the most recent date the eectronic consent indicator was updated.	DATE	PEBEMPL	PEBEMPL_EW2_CONSENT_DATE	NO	NO
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	NO	NO
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	NO	NO
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	NO	NO
EMPLOYEE_CLASS_LONG_DESC	Employee class long description.	VARCHAR2(30)	PTRECLS	PTRECLS_LONG_DESC	NO	NO
EMPLOYEE_CLASS_SHORT_DESC	Employee Class short description.	VARCHAR2(8)	PTRECLS	PTRECLS_SHORT_DESC	NO	NO
EMPLOYEE_GROUP	Sub-category of the employee class.	VARCHAR2(4)	PEBEMPL	PEBEMPL_EGRP_CODE	NO	NO
EMPLOYEE_GROUPING	Statistics Canada grouping code used for statistics Canada reporting for government installations.	VARCHAR2(2)	PEBEMPL	PEBEMPL_STGR_CODE	NO	NO
EMPLOYEE_GROUPING_DESC	Statistics Canada grouping description.	VARCHAR2(30)	PTVSTGR	PTVSTGR_DESC	NO	NO
EMPLOYEE_GROUP_DESC	Description of the employee group.	VARCHAR2(30)	PTVEGRP	PTVEGRP_DESC	NO	NO
EMPLOYEE_STATUS	Status of the employee (Active, Termed, etc.).	VARCHAR2(1)	PEBEMPL	PEBEMPL_EMPL_STATUS	NO	NO
EMPLOYEE_STATUS_DESC	Employee Status description.	VARCHAR2(30)	CALCULATION	DECODE(PEBEMPL_EMPL_STATUS)	NO	NO
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	NO	NO
FAIR_LABOR_STANDARDS_TYPE_DESC	Fair labor standards type description.	VARCHAR2(30)	CALCULATION	DECODE(PEBEMPL_FLSA_IND)	NO	NO
FEDERAL_MEDICAL_DENTAL_IND		VARCHAR2(1)				NO
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	NO	NO
FIRST_WORK_DATE	The first day that the employee worked.	DATE	PEBEMPL	PEBEMPL_FIRST_WORK_DATE	NO	NO
FOREIGN_INCOME_RECIPIENT_DESC	1042 recipient description.	VARCHAR2(35)	CALCULATION	DECODE(PEBEMPL_1042_RECIPIENT_CD)	NO	NO
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	NO	NO
FULL_OR_PART_TIME_IND	Internal part time/full time indicator, used for EEO reporting.	VARCHAR2(1)	PEBEMPL	PEBEMPL_INTERNAL_FT_PT_IND	NO	NO
HIRING_LOCATION	The Location to which the employee belongs.	VARCHAR2(6)	PEBEMPL	PEBEMPL_JBLN_CODE	NO	NO
HIRING_LOCATION_DESC	Hiring location description.	VARCHAR2(30)	PTRJBLN	PTRJBLN_DESC	NO	NO
HOME_ORGANIZATION	Home organization code of the employee.	VARCHAR2(6)	PEBEMPL	PEBEMPL_ORGN_CODE_HOME	NO	NO
HOME_ORGANIZATION_CHART	Home chart of accounts code for the employee.	VARCHAR2(1)	PEBEMPL	PEBEMPL_COAS_CODE_HOME	NO	NO
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	NO NO	NO
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	NO NO	NO
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	NO	NO
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	NO	NO
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	NO	NO
IMMIGRATION_STATUS_DESC	I9 status description.	VARCHAR2(30)	CALCULATION	DECODE(PEBEMPL_I9_FORM_IND,'R',RECEIVED,N,NOTRECEIVED,'T',TEMPORARY,'E',EXEMPT)	NO	NO
LAST_WORK_DATE	The last day that the employee worked.	DATE	PEBEMPL	PEBEMPL_LAST_WORK_DATE	NO	NO
LEAVE_CATEGORY	Leave category to which the employee belongs.	VARCHAR2(2)	PEBEMPL	PEBEMPL_LCAT_CODE	NO	NO
LEAVE_CATEGORY_DESC	Description or title for the defined Leave Category.	VARCHAR2(30)	PTVLCAT	PTVLCAT_DESC	NO	NO
LEAVE_OF_ABSENCE_BEGIN_DATE	Begin date of a leave of absence for the employee.	DATE	PEBEMPL	PEBEMPL_LOA_BEG_DATE	NO	NO
LEAVE_OF_ABSENCE_END_DATE	Anticipated end date for an employees leave of absence.	DATE	PEBEMPL	PEBEMPL_LOA_END_DATE	NO	NO
LEAVE_OF_ABSENCE_REASON	A code identifying the reason of the leave of absence for the employee.	VARCHAR2(2)	PEBEMPL	PEBEMPL_LREA_CODE	NO	NO
LEAVE_OF_ABSENCE_REASON_DESC	Leave of absence description.	VARCHAR2(30)	PTRLREA	PTRLREA_DESC	NO	NO
MIF_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(30)	NA	NA	NO	NO
MIF_VALUE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(6)	NA	NA	NO	NO
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	NO	NO
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	NO	NO
NONRESIDENT_SERV_INDUSTRY_DESC	Non-resident service industry description.	VARCHAR2(60)	PTVNRSI	PTVNRSI_DESC	NO	NO
ORIGINAL_HIRE_DATE	Date the employee was first hired.	DATE	PEBEMPL	PEBEMPL_FIRST_HIRE_DATE	NO	NO
PERSON_UID	System generated, unique, internal identification number assigned to this person.	NUMBER	PEBEMPL	PEBEMPL_PIDM	NO	NO
POSITION_EMPLOYEE_GROUP	Sub-category of the employee class.	VARCHAR2(4)	PTRECLS	PTRECLS_EGRP_CODE	NO	NO
POSITION_EMPLOYEE_GROUP_DESC	Description of the employee group.	VARCHAR2(30)	PTVEGRP	PTVEGRP_DESC	NO	NO
PRIMARY_FUNCTION		VARCHAR2(3)				NO
PROFILE_DATE	Profile Date associated with this record.	VARCHAR2(0)	FUNCTION	F_PROFILE_DATE	NO	NO
PUBLIC_RETIREMENT_MEMBERSHIP	Used primarily as to indicate membership in the California Pension plans (STRS/PERS).	VARCHAR2(1)	PEBEMPL	PEBEMPL_CALIF_PENSION_IND	NO	NO
PUBLIC_RETIREMENT_MEMBER_DESC	Public retirement membership description.	VARCHAR2(30)	CALCULATION	DECODE(PEBEMPL_CALIF_PENSION_IND)	NO	NO
SENIORITY_DATE	Institution defined date field.	DATE	PEBEMPL	PEBEMPL_SENIORITY_DATE	NO	NO
TERMINATION_DATE	Termination date of the employee.	DATE	PEBEMPL	PEBEMPL_TERM_DATE	NO	NO
TERMINATION_REASON	Code used to identify the reason of termination.	VARCHAR2(2)	PEBEMPL	PEBEMPL_TREA_CODE	NO	NO
TERMINATION_REASON_DESC	Termination reason description.	VARCHAR2(30)	PTRTREA	PTRTREA_DESC	NO	NO
USER_ID	The user who last created or updated the employee record.	VARCHAR2(30)	PEBEMPL	PEBEMPL_USER_ID	NO	NO
WORK_PERIOD	Code that defines the work period.	VARCHAR2(4)	PEBEMPL	PEBEMPL_WKPR_CODE	NO	NO
WORK_PERIOD_DESC	Work period description.	VARCHAR2(30)	PTRWKPR	PTRWKPR_DESC	NO	NO
ZONE_VALUE	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)	NA	NA	NO	NO

Ver: