| Target Column |
Business Name |
Business Definition |
Database Data Type |
Source Name |
Source Column |
|
ACTIVITY_DATE
|
Activity Date
|
Date record was inserted or updated.
|
DATE
|
PHRELBD
|
PHRELBD_ACTIVITY_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
|
|
CALENDAR_YEAR
|
Calendar Year
|
Pay period calendar year.
|
VARCHAR2(63)
|
PHRELBD
|
PHRELBD_YEAR
|
|
CHART_OF_ACCOUNTS
|
Chart Of Accounts
|
Chart of accounts code as defined on the BANNER Finance system.
|
VARCHAR2(63)
|
PHRELBD
|
PHRELBD_COAS_CODE
|
|
CHART_OF_ACCOUNTS_DESC
|
Chart Of Accounts Description
|
Chart of accounts code description or title.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
COST_TYPE
|
Cost Type
|
Type of labor cost.
|
VARCHAR2(63)
|
PHRELBD
|
PHRELBD_CTYP_CODE
|
|
COST_TYPE_LONG_DESC
|
Cost Type Long Description
|
Cost type long description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
COST_TYPE_SHORT_DESC
|
Cost Type Short Description
|
Cost type short description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
EARNINGS
|
Earnings
|
Earnings Code.
|
VARCHAR2(63)
|
PHRELBD
|
PHRELBD_EARN_CODE
|
|
EARNINGS_DESC
|
Earnings Description
|
Earnings code long description.
|
VARCHAR2(255)
|
PTREARN
|
PTREARN_LONG_DESC
|
|
ENCUMBRANCE_NUMBER
|
Encumbrance Number
|
Unique encumbrance code of a document.
|
VARCHAR2(63)
|
PHRELBD
|
PHRELBD_ENCD_NUM
|
|
ENCUMBRANCE_SEQUENCE
|
Encumbrance Sequence
|
Encumbrance sequence number.
|
NUMBER
|
PHRELBD
|
PHRELBD_ENCD_SEQ_NUM
|
|
EVENT_SEQUENCE_NUMBER
|
Event Sequence Number
|
Sequence of the pay event.
|
NUMBER
|
PHRELBD
|
PHRELBD_SEQ_NO
|
|
EXTERNAL_ACCOUNT
|
External Account
|
Free form Account Number to be used to interface to finance systems when Banner Finance is not present.
|
VARCHAR2(63)
|
PHRELBD
|
PHRELBD_ACCT_CODE_EXTERNAL
|
|
HOURS
|
Hours
|
Number of earnings hours associated with the labor distribution.
|
NUMBER
|
PHRELBD
|
PHRELBD_HRS
|
|
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
|
|
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)
|
PHRELBD
|
PHRELBD_SUFF
|
|
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
|
Combination of the person's first, middle initial, and last name into one value.
|
VARCHAR2(255)
|
FUNCTION
|
MGKFUNC.F_GET_PERSON_INFO
|
|
PAYROLL_IDENTIFIER
|
Payroll Identifier
|
Pay identification number to which this Employee_Position belongs.
|
VARCHAR2(63)
|
PHRELBD
|
PHRELBD_PICT_CODE
|
|
PAYROLL_IDENTIFIER_DESC
|
Payroll Identifier Description
|
Payroll code description or title.
|
VARCHAR2(255)
|
PTRPICT
|
PTRPICT_DESC
|
|
PAYROLL_NUMBER
|
Payroll Number
|
Used to uniquely identify a pay period within a fiscal year.
|
NUMBER
|
PHRELBD
|
PHRELBD_PAYNO
|
|
PERCENT
|
Percent
|
Percent of pay to be applied to this labor distribution. Defines the percentage of the contract value attributed to this accounting distribution.
|
NUMBER
|
PHRELBD
|
PHRELBD_PERCENT
|
|
PERSON_UID
|
Person UID
|
System generated unique internal identification number assigned to this person.
|
NUMBER
|
PHRELBD
|
PHRELBD_PIDM
|
|
POSITION
|
Position
|
Employee Position number.
|
VARCHAR2(63)
|
PHRELBD
|
PHRELBD_POSN
|
|
POSITION_ACCOUNT
|
Position Account
|
Code to which the position account is to be charged.
|
VARCHAR2(63)
|
PHRELBD
|
PHRELBD_ACCT_CODE
|
|
POSITION_ACCOUNT_DESC
|
Position Account Description
|
Position account description.
|
VARCHAR2(255)
|
FTVACCT
|
FTVACCT_TITLE
|
|
POSITION_ACCOUNT_INDEX
|
Position Account INDEX
|
An index code that is used to default the account distribution to which this position should be charged.
|
VARCHAR2(63)
|
PHRELBD
|
PHRELBD_ACCI_CODE
|
|
POSITION_ACCOUNT_INDEX_DESC
|
Position Account INDEX Description
|
Position account index description.
|
VARCHAR2(255)
|
FTVACCI
|
FTVACCI_TITLE
|
|
POSITION_ACTIVITY
|
Position Activity
|
Code that defines the activity to which the position should be charged.
|
VARCHAR2(63)
|
PHRELBD
|
PHRELBD_ACTV_CODE
|
|
POSITION_ACTIVITY_DESC
|
Position Activity Description
|
Position activity descripton.
|
VARCHAR2(255)
|
FTVACTV
|
FTVACTV_TITLE
|
|
POSITION_BEGIN_DATE
|
Position Begin Date
|
Date an Employee_Position became effective in the payroll system.
|
DATE
|
PHRELBD
|
PHRELBD_EFFECTIVE_DATE
|
|
POSITION_FUND
|
Position Fund
|
Code that identifies the fund to which this position should be charged.
|
VARCHAR2(63)
|
PHRELBD
|
PHRELBD_FUND_CODE
|
|
POSITION_FUND_DESC
|
Position Fund Description
|
Position fund description.
|
VARCHAR2(255)
|
FTVFUND
|
FTVFUND_TITLE
|
|
POSITION_LOCATION
|
Position Location
|
Code that identifies the program to which this position should be charged.
|
VARCHAR2(63)
|
PHRELBD
|
PHRELBD_LOCN_CODE
|
|
POSITION_LOCATION_DESC
|
Position Location Description
|
Position location description.
|
VARCHAR2(255)
|
FTVLOCN
|
FTVLOCN_TITLE
|
|
POSITION_ORGANIZATION
|
Position Organization
|
Code that identifies the organization to which this position should be charged.
|
VARCHAR2(63)
|
PHRELBD
|
PHRELBD_ORGN_CODE
|
|
POSITION_ORGANIZATION_DESC
|
Position Organization Description
|
Position organization description.
|
VARCHAR2(255)
|
FTVORGN
|
FTVORGN_TITLE
|
|
POSITION_PROGRAM
|
Position Program
|
Code that identifies the program to which this position should be charged.
|
VARCHAR2(63)
|
PHRELBD
|
PHRELBD_PROG_CODE
|
|
POSITION_PROGRAM_DESC
|
Position Program Description
|
Position program description.
|
VARCHAR2(255)
|
FTVPROG
|
FTVPROG_TITLE
|
|
POSITION_PROJECT
|
Position Project
|
Work order code used within cost accounting module.
|
VARCHAR2(63)
|
PHRELBD
|
PHRELBD_PROJ_CODE
|
|
POSITION_PROJECT_DESC
|
Position Project Description
|
Position project description.
|
VARCHAR2(255)
|
FTVPROJ
|
FTVPROJ_DESC
|
|
POSITION_TITLE
|
Position Title
|
Description of the Employee_Position. Defaults from the position title if left blank.
|
VARCHAR2(255)
|
NBBPOSN
|
NBBPOSN_TITLE
|
|
PROCESS_GROUP
|
Process Group
|
Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|
|
REDISTRIBUTION_AMOUNT
|
Redistribution Amount
|
Amount of redistributed dollars.
|
NUMBER
|
PHRELBD
|
PHRELBD_REDISTRIBUTION_AMT
|
|
SHIFT_NUMBER
|
Shift Number
|
Shift Associated with Earnings Code.
|
VARCHAR2(63)
|
PHRELBD
|
PHRELBD_SHIFT
|
|
SYSTEM_GENERATED_IND
|
System Generated Indicator
|
Indicates if the pay event was calculated manually or by the system.
|
VARCHAR2(1)
|
PHRELBD
|
PHRELBD_GEN_IND
|
|
TIMESHEET_CHART_DESC
|
Timesheet Chart Description
|
Chart of accounts code description or title.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
TIMESHEET_CHART_OF_ACCOUNTS
|
Timesheet Chart Of Accounts
|
Timesheet Chart of Accounts Code.
|
VARCHAR2(63)
|
PHRELBD
|
PHRELBD_COAS_CODE_TS
|
|
TIMESHEET_METHOD
|
Timesheet Method
|
Determines the method by which the timesheet is entered in they system.
|
VARCHAR2(63)
|
PHRELBD
|
PHRELBD_TS_ROSTER_IND
|
|
TIMESHEET_METHOD_DESC
|
Timesheet Method Description
|
Timesheet method description.
|
VARCHAR2(255)
|
CALCULATION
|
DECODE(PHRELBD_TS_ROSTER_IND)
|
|
TIMESHEET_ORGANIZATION
|
Timesheet Organization
|
Organization to which the time sheet for this position is sent.
|
VARCHAR2(63)
|
PHRELBD
|
PHRELBD_ORGN_CODE_TS
|
|
TIMESHEET_ORGANIZATION_DESC
|
Timesheet Organization Description
|
Organization to which this Employee_Position's time sheet is sent.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|