Target Column	Business Name	Business Definition	Database Data Type	Source Name	Source Column
ACTIVE_JOBS_COUNT	Active Jobs Count	Count of the number of active jobs for this employee.	NUMBER	FUNCTION	MPKFUNC.F_COUNT_ACTIVE_JOBS
ACTIVITY_DATE	Activity Date	Date when the record was inserted or last modified.	DATE	PEBEMPL	PEBEMPL_ACTIVITY_DATE
ADJUSTED_SERVICE_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
ADMINISTRATIVE_GROUP	Administrative Group	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
BARGAINING_UNIT_COUNT	Bargaining Unit Count	Count of bargaining units.	NUMBER	FUNCTION	MPKFUNC.F_COUNT_BARG_UNIT
BENEFIT_CATEGORY	Benefit Category	Benefit category to which the employee belongs.	VARCHAR2(63)	PEBEMPL	PEBEMPL_BCAT_CODE
BENEFIT_CATEGORY_DESC	Benefit Category Description	Benefits category description.	VARCHAR2(255)	PTRBCAT	PTRBCAT_DESC
BUDGET_TYPE	Budget Type	Budget type is the expected funding status for the position.	VARCHAR2(63)	NBBPOSN	NBBPOSN_BUDGET_TYPE
BUDGET_TYPE_DESC	Budget Type Description	Budget type description.	VARCHAR2(255)	FUNCTION	T = TEMPORARY, P = PERMANENT, C = CASUAL AND N = NONE
CAMPUS	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
CAMPUS_DESC	Campus Description	The campus description.	VARCHAR2(255)	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(255)	FUNCTION PTVORGN	F_GET_FINANCE_DESC PTVORGN_DESC
CHECK_DIST_ORGANIZATION	Check Distributijon Organization	The organization code used for document distribution.	VARCHAR2(63)	PEBEMPL	PEBEMPL_ORGN_CODE_DIST
CHECK_DIST_ORGANIZATION_DESC	Check Distribution Organization Description	Check distribution organization description.	VARCHAR2(255)	FUNCTION PTVORGN	F_GET_FINANCE_DESC PTVORGN_DESC
COLLEGE	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
COLLEGE_DESC	College Description	The college description.	VARCHAR2(255)	STVCOLL	STVCOLL_DESC
CONTRACT_TYPE	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
CONTRACT_TYPE_DESC	Contract Type Description	Type of faculty contract description.	VARCHAR2(255)	NA	NA
CURRENT_HIRE_DATE	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
CURRENT_REVIEW_DATE	Current Review Date	Date this review type is due for completion.	DATE	PERREVW	PERREVW_REVT_DATE
CURRENT_REVIEW_RATING	Current Review Rating	A user defined rating system for completed review types.	VARCHAR2(63)	PERREVW	PERREVW_REVT_RATING
CURRENT_REVIEW_TYPE	Current Review Type	A code identifying the type of review.	VARCHAR2(63)	PERREVW	PERREVW_REVT_CODE
CURRENT_REVIEW_TYPE_COMP_IND	Current Review Type Comp Indicator	Code used to identify if this review type has been completed.	VARCHAR2(1)	PERREVW	PERREVW_REVT_COMPLETE
CURRENT_REVIEW_TYPE_DESC	Current Review Type Description	Review type description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
DIRECT_REPORT_COUNT	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
DIVISION	Division	District or division associated with an employee.	VARCHAR2(63)	PEBEMPL	PEBEMPL_DICD_CODE
DIVISION_DESC	Division Description	District or division description.	VARCHAR2(255)	GTVDICD	GTVDICD_DESC
EEO_CATEGORY	Eeo Category	Used by institutions of higher education for Equal Employment Opportunity reporting as defined by the federal government.	VARCHAR2(63)	NA	NA
EEO_CATEGORY_DESC	Eeo Category Description	EEO category code description.	VARCHAR2(255)	PTVESKL	PTVESKL_DESC
EEO_SKILL	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
EEO_SKILL_DESC	Eeo Skill Description	EEO skill description.	VARCHAR2(255)	PTVESKL	PTVESKL_DESC
EFFECTIVE_DATE	Effective Date	Date an Employee Position became effective in the payroll system.	DATE	NBRJOBS	NBRJOBS_EFFECTIVE_DATE
ELECTRONIC_CONSENT_DATE	Electronic Consent Date	Identifies the most recent date the electronic 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 earnings statement (W-2, in the United States) electronically.	VARCHAR2(1)	PEBEMPL	PEBEMPL_EW2_CONSENT_IND
ELECTRONIC_CONSENT_USER_ID	Electronic Consent User Identifier	The unique identification of the user who last updated the electronic consent indicator.	VARCHAR2(63)	PEBEMPL	PEBEMPL_EW2_CONSENT_USER_ID
EMPLOYEE_CLASS	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
EMPLOYEE_CLASS_LONG_DESC	Employee Class Long Description	Employee class long description.	VARCHAR2(255)	PTRECLS	PTRECLS_LONG_DESC
EMPLOYEE_CLASS_SHORT_DESC	Employee Class Short Description	Employee class short description.	VARCHAR2(255)	PTRECLS	PTRECLS_SHORT_DESC
EMPLOYEE_EARNING_COUNT	Employee Earning Count	Employee earning count.	NUMBER	FUNCTION	MPKFUNC.F_COUNT_EMPL_EARN
EMPLOYEE_GROUP	Employee Group	Sub-category of the employee class.	VARCHAR2(63)	PEBEMPL	PEBEMPL_EGRP_CODE
EMPLOYEE_GROUPING	Employee Grouping	Statistics Canada grouping code used for statistics Canada reporting for government installations.	VARCHAR2(63)	PEBEMPL	PEBEMPL_STGR_CODE
EMPLOYEE_GROUPING_DESC	Employee Grouping Description	Statistics Canada grouping description.	VARCHAR2(255)	PTVSTGR	PTVSTGR_DESC
EMPLOYEE_GROUP_DESC	Employee Group Description	The description of the employee group.	VARCHAR2(255)	PTVEGRP	PTVEGRP_DESC
EMPLOYEE_STATUS	Employee Status	Status of the employee (Active, Termed, etc.).	VARCHAR2(1)	PEBEMPL	PEBEMPL_EMPL_STATUS
EMPLOYEE_STATUS_DESC	Employee Status Description	Employee status description.	VARCHAR2(255)	CALCULATION	DECODE(PEBEMPL_EMPL_STATUS)
EMPLOYER	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
EMPLOYER_DESC	Employer Description	Employer description.	VARCHAR2(255)	PTREMPR	PTREMPR_DESC
EMPLOYMENT_CATEGORY	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
EMPLOYMENT_CATEGORY_DESC	Employment Category Description	Employment category description	VARCHAR2(255)	PTVECIP	PTVECIP_DESC
EXEMPTION_TYPE	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
EXEMPTION_TYPE_DESC	Exemption Type description.	Exemption Type description.	VARCHAR2(255)	CALCULATION	DECODE (NBBPOSN_EXEMPT_IND, NTRPCLS_EXEMPT_IND)
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(255)	CALCULATION	DECODE(PEBEMPL_FLSA_IND)
FEDERAL_MEDICAL_DENTAL_IND	Federal Medical Dental Indicator	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
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	Foreign Income Recipient Description	Foreign employee recipient description.	VARCHAR2(255)	CALCULATION	DECODE(PEBEMPL_1042_RECIPIENT_CD)
FOREIGN_INCOME_RECIPIENT_TYPE	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
FULL_OR_PART_TIME_IND	Full Or Part Time Indicator	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(63)	PEBEMPL	PEBEMPL_JBLN_CODE
HIRING_LOCATION_DESC	Hiring Location Description	Hiring location description.	VARCHAR2(255)	PTRJBLN	PTRJBLN_DESC
HOME_ORGANIZATION	Home Organization	Home organization code of the employee.	VARCHAR2(63)	PEBEMPL	PEBEMPL_ORGN_CODE_HOME
HOME_ORGANIZATION_CHART	Home Organization Chart	Home chart of accounts code for the employee.	VARCHAR2(63)	PEBEMPL	PEBEMPL_COAS_CODE_HOME
HOME_ORGANIZATION_CHART_DESC	Home Organization Chart Description	Home organization chart description.	VARCHAR2(255)	FUNCTION PTVORGN	F_GET_FINANCE_DESC PTVORGN_DESC
HOME_ORGANIZATION_DESC	Home Organization Description	Home organization code description of the employee.	VARCHAR2(255)	FUNCTION PTVORGN	F_GET_FINANCE_DESC PTVORGN_DESC
ID	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
IMMIGRATION_DATE	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	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	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
IMMIGRATION_STATUS_DESC	Immigration Status Description	I9 status description.	VARCHAR2(255)	CALCULATION	DECODE(PEBEMPL_I9_FORM_IND,'R',RECEIVED,N,NOTRECEIVED,'T',TEMPORARY,'E',EXEMPT)
JOB_SUFFIX	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
LAST_WORK_DATE	Last Work Date	The last day that the employee worked.	DATE	PEBEMPL	PEBEMPL_LAST_WORK_DATE
LEAVE_CATEGORY	Leave Category	Leave category to which the employee belongs.	VARCHAR2(63)	PEBEMPL	PEBEMPL_LCAT_CODE
LEAVE_CATEGORY_DESC	Leave Category Description	Leave category description or title.	VARCHAR2(255)	PTVLCAT	PTVLCAT_DESC
LEAVE_COUNT	Leave Count	Count of number of leaves.	NUMBER	FUNCTION	MPKFUNC.F_COUNT_LEAVE
LEAVE_OF_ABSENCE_BEGIN_DATE	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	Leave Of Absence End Date	Anticipated end date for an employees leave of absence.	DATE	PEBEMPL	PEBEMPL_LOA_END_DATE
LEAVE_OF_ABSENCE_REASON	Leave Of Absence Reason	A code identifying the reason of the leave of absence for the employee.	VARCHAR2(63)	PEBEMPL	PEBEMPL_LREA_CODE
LEAVE_OF_ABSENCE_REASON_DESC	Leave Of Absence Reason Description	Leave of absence description.	VARCHAR2(255)	PTRLREA	PTRLREA_DESC
MULTI_SOURCE	Multi Source	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA
MULTI_SOURCE_DESC	Multi Source Description	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA
NAME	Name	Name of the person (last name, first name, middle initial) or organization.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
NEW_EMPLOYEE_IND	New Employee Indicator	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
NONRESIDENT_DAYS_IN_COUNTRY	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	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
NONRESIDENT_SERV_INDUSTRY_DESC	Non-resident Service Industry Description	Non-resident service industry description.	VARCHAR2(255)	PTVNRSI	PTVNRSI_DESC
ORIGINAL_HIRE_DATE	Original Hire Date	Date the employee was first hired.	DATE	PEBEMPL	PEBEMPL_FIRST_HIRE_DATE
PERSON_UID	Person UID	System generated, unique, internal identification number assigned to this person.	NUMBER	PEBEMPL	PEBEMPL_PIDM
POSITION	Position	Position.	VARCHAR2(63)	NBRJOBS	NBRJOBS_POSN
POSITION_BEGIN_DATE	Position Begin Date	Employee_Position begin date. The date the job assignment started.	DATE	NBRBJOB	NBRBJOB_BEGIN_DATE
POSITION_CONTRACT_TYPE	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
POSITION_CONTRACT_TYPE_DESC	Position Contract Type Description	Description for the type of employee contract.	VARCHAR2(255)	CALCULATION	DECODE(NBRBJOB_CONTRACT_TYPE, 'P', 'PRIMARY', 'S', 'SECONDARY', 'O', 'OVERLOAD')
POSITION_END_DATE	Position End Date	Date the Employee_Position is scheduled to end. If left blank, the position is indefinite.	DATE	NBRBJOB	NBRBJOB_END_DATE
POSITION_PERSONNEL_DATE	Position Personnel Date	Date the change became effective, regardless of payroll.	DATE	NBRJOBS	NBRJOBS_PERS_CHG_DATE
POSITION_STATUS	Position Status	Position status.	VARCHAR2(63)	NBRJOBS	NBRJOBS_STATUS
POSITION_STATUS_DESC	Position Status Description	Position status description.	VARCHAR2(255)	CALCULATION	DECODE(NBRJOBS_STATUS)
POSITION_TITLE	Position Title	Employee_Position description. Defaults from the position title if left blank.	VARCHAR2(255)	NBRJOBS	NBRJOBS_DESC
PRIMARY_FUNCTION	Primary Function	Position primary function for the government reporting.	VARCHAR2(63)	PEBEMPL	PEBEMPL_IPEDS_PRIMARY_FUNCTION
PRIMARY_FUNCTION_DESC	Primary Function Description	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
PROCESS_GROUP	Process Group	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
PROFILE_DATE	Profile Date	Profile Date associated with this record.	DATE	FUNCTION	F_PROFILE_DATE
PROFILE_YEAR	Profile Year	Profile year.	NUMBER	NA	NA
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 Membership Description	Public retirement membership description.	VARCHAR2(255)	CALCULATION	DECODE(PEBEMPL_CALIF_PENSION_IND)
REVIEW_COUNT	Review Count	Count of reviews.	NUMBER	FUNCTION	MPKFUNC.F_COUNT_REVIEW
SENIORITY_DATE	Seniority Date	Institution defined date field.	DATE	PEBEMPL	PEBEMPL_SENIORITY_DATE
SERVICE_YEARS	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
STANDARD_OCCUPATIONAL_CATEGORY	Standard Occupational Category	Standard occupational categories defined by the government for federal reporting.	VARCHAR2(63)	NBBPOSN	NBBPOSN_ESOC_CODE
STANDARD_OCCUPATIONAL_CAT_DESC	Standard Occupational Cat Description	Occupational category description.	VARCHAR2(255)	PTRESOC	PTRESOC_DESC
SUPERVISOR_ID	Supervisor ID	Person's identification number used to access the records associated with the person.	VARCHAR2(63)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
SUPERVISOR_IND	Supervisor Indicator	Identifies if the person has any direct reports.	VARCHAR2(1)	FUNCTION	MPKFUNC.F_CHECK_SUPERVISOR
SUPERVISOR_JOB_SUFFIX	Supervisor Job Suffix	Suffix associated with the supervisors position.	VARCHAR2(63)	CALCULATION	NVL(NBRJOBS_SUPERVISOR_SUFF, NOKODSF.F_GET_SUPERVISOR)
SUPERVISOR_NAME	Supervisor Name	Combination of the person's first, middle initial, and last name into one value.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
SUPERVISOR_POSITION	Supervisor Position	Position number of the employee's supervisor.	VARCHAR2(63)	CALCULATION	NVL(NBRJOBS_SUPERVISOR_POSN, NBBPOSN_POSN_REPORTS)
SUPERVISOR_TITLE	Supervisor Title	Supervisor's position description.	VARCHAR2(255)	FUNCTION	NOKODSF.F_GET_SUPERVISOR
SUPERVISOR_UID	Supervisor UID	System generated, unique, internal identification number assigned to this person.	NUMBER	CALCULATION	NVL(NBRJOBS_SUPERVISOR_PIDM, NOKODSF.F_GET_SUPERVISOR)
TERMINATION_DATE	Termination Date	Termination date of the employee.	DATE	PEBEMPL	PEBEMPL_TERM_DATE
TERMINATION_REASON	Termination Reason	Code used to identify the reason of termination.	VARCHAR2(63)	PEBEMPL	PEBEMPL_TREA_CODE
TERMINATION_REASON_DESC	Termination Reason Description	Termination reason description.	VARCHAR2(255)	PTRTREA	PTRTREA_DESC
TIME_SHEET_CHART	Time Sheet Chart	Timesheet chart of accounts.	VARCHAR2(63)	NBRJOBS	NBRJOBS_COAS_CODE_TS
TIME_SHEET_CHART_DESC	Chart of Accounts Description	Chart of accounts description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
TIME_SHEET_ORGANIZATION	Time Sheet Organization	Organization to which the time sheet for this position is sent.	VARCHAR2(63)	NBRJOBS	NBRJOBS_ORGN_CODE_TS
TIME_SHEET_ORGANIZATION_DESC	Time Sheet Organization Description	Organization to which this Employee_Position's time sheet is sent.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
USER_ID	User ID	The user who last created or updated the employee record.	VARCHAR2(63)	PEBEMPL	PEBEMPL_USER_ID
WORK_PERIOD	Work Period	Defines the work period.	VARCHAR2(63)	PEBEMPL	PEBEMPL_WKPR_CODE
WORK_PERIOD_DESC	Work Period Description	Work period description.	VARCHAR2(255)	PTRWKPR	PTRWKPR_DESC

Ver: 9.2