Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target
ACTIVE_JOBS_COUNT	Count of the number of active jobs for this employee.	NUMBER	FUNCTION	MPKFUNC.F_COUNT_ACTIVE_JOBS	NO	NO
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
ADMINISTRATIVE_GROUP	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO
BARGAINING_UNIT_COUNT	Count of bargaining units.	NUMBER	FUNCTION	MPKFUNC.F_COUNT_BARG_UNIT	NO	NO
BENEFIT_CATEGORY	Benefit category to which the employee belongs.	VARCHAR2(63)	PEBEMPL	PEBEMPL_BCAT_CODE	NO	NO
BENEFIT_CATEGORY_DESC	Benefits category description.	VARCHAR2(255)	PTRBCAT	PTRBCAT_DESC	NO	NO
BUDGET_TYPE	Budget type is the expected funding status for the position.	VARCHAR2(63)	NBBPOSN	NBBPOSN_BUDGET_TYPE	NO	NO
BUDGET_TYPE_DESC	Budget type description.	VARCHAR2(255)	FUNCTION	T = TEMPORARY, P = PERMANENT, C = CASUAL AND N = NONE	NO	NO
CAMPUS	Campus associated with this record. Campus for the course section, student course, student, applied for on the admission application, etc.	VARCHAR2(63)	PEBEMPL	PEBEMPL_CAMP_CODE	NO	NO
CAMPUS_DESC	The campus description.	VARCHAR2(255)	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(255)	FUNCTION PTVORGN	F_GET_FINANCE_DESC PTVORGN_DESC	NO NO	NO
CHECK_DIST_ORGANIZATION	The organization code used for document distribution.	VARCHAR2(63)	PEBEMPL	PEBEMPL_ORGN_CODE_DIST	NO	NO
CHECK_DIST_ORGANIZATION_DESC	Check distribution organization description.	VARCHAR2(255)	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(63)	PEBEMPL	PEBEMPL_COLL_CODE	NO	NO
COLLEGE_DESC	The college description.	VARCHAR2(255)	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(63)	NA	NA	NO	NO
CONTRACT_TYPE_DESC	Type of faculty contract description.	VARCHAR2(255)	NA	NA	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
CURRENT_REVIEW_DATE	Date this review type is due for completion.	DATE	PERREVW	PERREVW_REVT_DATE	NO	NO
CURRENT_REVIEW_RATING	A user defined rating system for completed review types.	VARCHAR2(63)	PERREVW	PERREVW_REVT_RATING	NO	NO
CURRENT_REVIEW_TYPE	A code identifying the type of review.	VARCHAR2(63)	PERREVW	PERREVW_REVT_CODE	NO	NO
CURRENT_REVIEW_TYPE_COMP_IND	Code used to identify if this review type has been completed.	VARCHAR2(1)	PERREVW	PERREVW_REVT_COMPLETE	NO	NO
CURRENT_REVIEW_TYPE_DESC	Review type description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
DIRECT_REPORT_COUNT	Count of the distinct number of people in active positions that are direct reports to this supervisor.	NUMBER	FUNCTION	MPKFUNC.F_COUNT_DIRECT_REPORT	NO	NO
DIVISION	District or division associated with an employee.	VARCHAR2(63)	PEBEMPL	PEBEMPL_DICD_CODE	NO	NO
DIVISION_DESC	District or division description.	VARCHAR2(255)	GTVDICD	GTVDICD_DESC	NO	NO
EEO_CATEGORY	Used by institutions of higher education for Equal Employment Opportunity reporting as defined by the federal government.	VARCHAR2(63)	NA	NA	NO	NO
EEO_CATEGORY_DESC	EEO category code description.	VARCHAR2(255)	PTVESKL	PTVESKL_DESC	NO	NO
EEO_SKILL	Used by institutions of higher education for Equal Employment Opportunity skills reporting as defined by the federal government.	VARCHAR2(63)	NTRPCLS	NTRPCLS_ESKL_CODE	NO	NO
EEO_SKILL_DESC	EEO skill description.	VARCHAR2(255)	PTVESKL	PTVESKL_DESC	NO	NO
EFFECTIVE_DATE	Date an Employee Position became effective in the payroll system.	DATE	NBRJOBS	NBRJOBS_EFFECTIVE_DATE	NO	NO
ELECTRONIC_CONSENT_DATE	Identifies the most recent date the electronic consent indicator was updated.	DATE	PEBEMPL	PEBEMPL_EW2_CONSENT_DATE	NO	NO
ELECTRONIC_CONSENT_IND	Indicates the employee has consented to receive their annual earnings 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(63)	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(63)	PEBEMPL	PEBEMPL_ECLS_CODE	NO	NO
EMPLOYEE_CLASS_LONG_DESC	Employee class long description.	VARCHAR2(255)	PTRECLS	PTRECLS_LONG_DESC	NO	NO
EMPLOYEE_CLASS_SHORT_DESC	Employee class short description.	VARCHAR2(255)	PTRECLS	PTRECLS_SHORT_DESC	NO	NO
EMPLOYEE_EARNING_COUNT	Employee earning count.	NUMBER	FUNCTION	MPKFUNC.F_COUNT_EMPL_EARN	NO	NO
EMPLOYEE_GROUP	Sub-category of the employee class.	VARCHAR2(63)	PEBEMPL	PEBEMPL_EGRP_CODE	NO	NO
EMPLOYEE_GROUPING	Statistics Canada grouping code used for statistics Canada reporting for government installations.	VARCHAR2(63)	PEBEMPL	PEBEMPL_STGR_CODE	NO	NO
EMPLOYEE_GROUPING_DESC	Statistics Canada grouping description.	VARCHAR2(255)	PTVSTGR	PTVSTGR_DESC	NO	NO
EMPLOYEE_GROUP_DESC	The description of the employee group.	VARCHAR2(255)	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(255)	CALCULATION	DECODE(PEBEMPL_EMPL_STATUS)	NO	NO
EMPLOYER	User-defined code used as part of the Employee_Position definition. It is often used, for example, as a means to identify different campuses within an institution, or different major functional areas.	VARCHAR2(63)	NBRJOBS	NBRJOBS_EMPR_CODE	NO	NO
EMPLOYER_DESC	Employer description.	VARCHAR2(255)	PTREMPR	PTREMPR_DESC	NO	NO
EMPLOYMENT_CATEGORY	Federal employment reporting categories that identify either the number of month or whether the employment length is full time or part time.	VARCHAR2(63)	NBBPOSN	NBBPOSN_ECIP_CODE	NO	NO
EMPLOYMENT_CATEGORY_DESC	Employment category description	VARCHAR2(255)	PTVECIP	PTVECIP_DESC	NO	NO
EXEMPTION_TYPE	Indicates if employees assigned to this position class are exempt or non-exempt from federal overtime rules and then indicates if that exemption or non-exemption has been overridden for this specific position.	VARCHAR2(63)	NBBPOSN NTRPCLS	NBBPOSN_EXEMPT_IND NTRPCLS_EXEMPT_IND	NO NO	NO
EXEMPTION_TYPE_DESC	Exemption Type description.	VARCHAR2(255)	CALCULATION	DECODE (NBBPOSN_EXEMPT_IND, NTRPCLS_EXEMPT_IND)	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(255)	CALCULATION	DECODE(PEBEMPL_FLSA_IND)	NO	NO
FEDERAL_MEDICAL_DENTAL_IND	Determines where the person is reported for government reporting. Valid values are: Y = report under the Medical/Dental section. N = reported under the Non-medical section. Banner HR default is N.	VARCHAR2(1)	PEBEMPL	PEBEMPL_IPEDS_MED_DENTAL_IND	NO	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	Foreign employee recipient description.	VARCHAR2(255)	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(63)	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(63)	PEBEMPL	PEBEMPL_JBLN_CODE	NO	NO
HIRING_LOCATION_DESC	Hiring location description.	VARCHAR2(255)	PTRJBLN	PTRJBLN_DESC	NO	NO
HOME_ORGANIZATION	Home organization code of the employee.	VARCHAR2(63)	PEBEMPL	PEBEMPL_ORGN_CODE_HOME	NO	NO
HOME_ORGANIZATION_CHART	Home chart of accounts code for the employee.	VARCHAR2(63)	PEBEMPL	PEBEMPL_COAS_CODE_HOME	NO	NO
HOME_ORGANIZATION_CHART_DESC	Home organization chart description.	VARCHAR2(255)	FUNCTION PTVORGN	F_GET_FINANCE_DESC PTVORGN_DESC	NO NO	NO
HOME_ORGANIZATION_DESC	Home organization code description of the employee.	VARCHAR2(255)	FUNCTION PTVORGN	F_GET_FINANCE_DESC PTVORGN_DESC	NO NO	NO
ID	Identification number assigned to a person that is used externally for all communication and correspondence with the person.	VARCHAR2(63)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO	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(63)	PEBEMPL	PEBEMPL_I9_FORM_IND	NO	NO
IMMIGRATION_STATUS_DESC	I9 status description.	VARCHAR2(255)	CALCULATION	DECODE(PEBEMPL_I9_FORM_IND,'R',RECEIVED,N,NOTRECEIVED,'T',TEMPORARY,'E',EXEMPT)	NO	NO
JOB_SUFFIX	Suffix allows users to define a job with more precision. For example, a user could denote daytime faculty with one suffix and evening school with another.	VARCHAR2(63)	NBRJOBS	NBRJOBS_SUFF	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(63)	PEBEMPL	PEBEMPL_LCAT_CODE	NO	NO
LEAVE_CATEGORY_DESC	Leave category description or title.	VARCHAR2(255)	PTVLCAT	PTVLCAT_DESC	NO	NO
LEAVE_COUNT	Count of number of leaves.	NUMBER	FUNCTION	MPKFUNC.F_COUNT_LEAVE	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(63)	PEBEMPL	PEBEMPL_LREA_CODE	NO	NO
LEAVE_OF_ABSENCE_REASON_DESC	Leave of absence description.	VARCHAR2(255)	PTRLREA	PTRLREA_DESC	NO	NO
MULTI_SOURCE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA	NO	NO
MULTI_SOURCE_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA	NO	NO
NAME	Name of the person (last name, first name, middle initial) or organization.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
NEW_EMPLOYEE_IND	Identifies the person as a new employee based on the value in service years. By default, service years that are less than 1.0 are defined as new. However, this default value can be changed in MGRSDAX.	VARCHAR2(1)	FUNCTION	MPKFUNC.F_NEW_EMPLOYEE_IND	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(63)	PEBEMPL	PEBEMPL_NRSI_CODE	NO	NO
NONRESIDENT_SERV_INDUSTRY_DESC	Non-resident service industry description.	VARCHAR2(255)	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	Position.	VARCHAR2(63)	NBRJOBS	NBRJOBS_POSN	NO	NO
POSITION_BEGIN_DATE	Employee_Position begin date. The date the job assignment started.	DATE	NBRBJOB	NBRBJOB_BEGIN_DATE	NO	NO
POSITION_CONTRACT_TYPE	Identifies the type of faculty contract assigned to the person. Included may be full time, adjunct or continuing education only, etc.	VARCHAR2(63)	NBRBJOB	NBRBJOB_CONTRACT_TYPE	NO	NO
POSITION_CONTRACT_TYPE_DESC	Description for the type of employee contract.	VARCHAR2(255)	CALCULATION	DECODE(NBRBJOB_CONTRACT_TYPE, 'P', 'PRIMARY', 'S', 'SECONDARY', 'O', 'OVERLOAD')	NO	NO
POSITION_END_DATE	Date the Employee_Position is scheduled to end. If left blank, the position is indefinite.	DATE	NBRBJOB	NBRBJOB_END_DATE	NO	NO
POSITION_PERSONNEL_DATE	Date the change became effective, regardless of payroll.	DATE	NBRJOBS	NBRJOBS_PERS_CHG_DATE	NO	NO
POSITION_STATUS	Position status.	VARCHAR2(63)	NBRJOBS	NBRJOBS_STATUS	NO	NO
POSITION_STATUS_DESC	Position status description.	VARCHAR2(255)	CALCULATION	DECODE(NBRJOBS_STATUS)	NO	NO
POSITION_TITLE	Employee_Position description. Defaults from the position title if left blank.	VARCHAR2(255)	NBRJOBS	NBRJOBS_DESC	NO	NO
PRIMARY_FUNCTION	Position primary function for the government reporting.	VARCHAR2(63)	PEBEMPL	PEBEMPL_IPEDS_PRIMARY_FUNCTION	NO	NO
PRIMARY_FUNCTION_DESC	Primary function description.	VARCHAR2(255)	FUNCTION	SELECT SUBSTR(VALUE_DESCRIPTION, 1, 255) FROM MGT_VALIDATION WHERE TABLE_NAME = 'PRIMARY_FUNCTION' AND VALUE = A.PRIMARY_FUNCTION	NO	NO
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO
PROFILE_DATE	Profile Date associated with this record.	DATE	FUNCTION	F_PROFILE_DATE	NO	NO
PROFILE_YEAR	Profile year.	NUMBER	NA	NA	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(255)	CALCULATION	DECODE(PEBEMPL_CALIF_PENSION_IND)	NO	NO
REVIEW_COUNT	Count of reviews.	NUMBER	FUNCTION	MPKFUNC.F_COUNT_REVIEW	NO	NO
SENIORITY_DATE	Institution defined date field.	DATE	PEBEMPL	PEBEMPL_SENIORITY_DATE	NO	NO
SERVICE_YEARS	Calculates the length of service in years for active employees based on the difference between today's date and the adjusted service date; for terminated employees based on the difference between termination date and adjusted service date.	NUMBER	FUNCTION	MPKFUNC.F_SERVICE_YEARS	NO	NO
STANDARD_OCCUPATIONAL_CATEGORY	Standard occupational categories defined by the government for federal reporting.	VARCHAR2(63)	NBBPOSN	NBBPOSN_ESOC_CODE	NO	NO
STANDARD_OCCUPATIONAL_CAT_DESC	Occupational category description.	VARCHAR2(255)	PTRESOC	PTRESOC_DESC	NO	NO
SUPERVISOR_ID	Person's identification number used to access the records associated with the person.	VARCHAR2(63)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
SUPERVISOR_IND	Identifies if the person has any direct reports.	VARCHAR2(1)	FUNCTION	MPKFUNC.F_CHECK_SUPERVISOR	NO	NO
SUPERVISOR_JOB_SUFFIX	Suffix associated with the supervisors position.	VARCHAR2(63)	CALCULATION	NVL(NBRJOBS_SUPERVISOR_SUFF, NOKODSF.F_GET_SUPERVISOR)	NO	NO
SUPERVISOR_NAME	Combination of the person's first, middle initial, and last name into one value.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
SUPERVISOR_POSITION	Position number of the employee's supervisor.	VARCHAR2(63)	CALCULATION	NVL(NBRJOBS_SUPERVISOR_POSN, NBBPOSN_POSN_REPORTS)	NO	NO
SUPERVISOR_TITLE	Supervisor's position description.	VARCHAR2(255)	FUNCTION	NOKODSF.F_GET_SUPERVISOR	NO	NO
SUPERVISOR_UID	System generated, unique, internal identification number assigned to this person.	NUMBER	CALCULATION	NVL(NBRJOBS_SUPERVISOR_PIDM, NOKODSF.F_GET_SUPERVISOR)	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(63)	PEBEMPL	PEBEMPL_TREA_CODE	NO	NO
TERMINATION_REASON_DESC	Termination reason description.	VARCHAR2(255)	PTRTREA	PTRTREA_DESC	NO	NO
TIME_SHEET_CHART	Timesheet chart of accounts.	VARCHAR2(63)	NBRJOBS	NBRJOBS_COAS_CODE_TS	NO	NO
TIME_SHEET_CHART_DESC	Chart of accounts description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
TIME_SHEET_ORGANIZATION	Organization to which the time sheet for this position is sent.	VARCHAR2(63)	NBRJOBS	NBRJOBS_ORGN_CODE_TS	NO	NO
TIME_SHEET_ORGANIZATION_DESC	Organization to which this Employee_Position's time sheet is sent.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
USER_ID	The user who last created or updated the employee record.	VARCHAR2(63)	PEBEMPL	PEBEMPL_USER_ID	NO	NO
WORK_PERIOD	Defines the work period.	VARCHAR2(63)	PEBEMPL	PEBEMPL_WKPR_CODE	NO	NO
WORK_PERIOD_DESC	Work period description.	VARCHAR2(255)	PTRWKPR	PTRWKPR_DESC	NO	NO

Ver: 9.2