Go To View:  RETURN TO BANNER ODS META DATA REPORTS LIST
Human Resources Reporting View Reports

Banner Operational Data Store
Reporting View Target: LABOR_COST_DISTRIBUTION

Description Contains all labor distribution information pertaining to an employee's positions.
Key & Frequency One row per person per position per job suffix per effective date.
Recommended Search Columns PERSON_UID, POSITION, JOB_SUFFIX
POSITION, JOB_SUFFIX

Target Column Business Name Business Definition Database Data Type Source Name Source Column
ACCOUNT_INDEX Account INDEX Account Index is used as a short cut method to the data entry of an accounting distribution. It may contain any or all of the account distribution columns. VARCHAR2(6)

NBRJLBD

NBRJLBD_ACCI_CODE

ACCOUNT_INDEX_DESC Account INDEX Description An index code that is used to default the account distribution to which this position should be charged. VARCHAR2(255)

FTVACCI

FTVACCI_TITLE

ADMINISTRATIVE_GROUP Administrative Group Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

ASSIGNMENT_ACCOUNT Assignment Account Account code. Must exist in corresponding finance system. VARCHAR2(63)

NBRJLBD

NBRJLBD_ACCT_CODE

ASSIGNMENT_ACCOUNT_DESC Assignment Account Description Assignment account description. VARCHAR2(255)

FTVACCT

FTVACCT_TITLE

ASSIGNMENT_ACTIVITY Assignment Activity Activity code. VARCHAR2(63)

NBRJLBD

NBRJLBD_ACTV_CODE

ASSIGNMENT_ACTIVITY_DESC Assignment Activity Description Assignment activity description. VARCHAR2(255)

FTVACTV

FTVACTV_TITLE

ASSIGNMENT_FUND Assignment Fund Fund code. Requires corresponding finance system to be installed. VARCHAR2(63)

NBRJLBD

NBRJLBD_FUND_CODE

ASSIGNMENT_FUND_DESC Assignment Fund Description Assignment fund description. VARCHAR2(255)

FTVFUND

FTVFUND_TITLE

ASSIGNMENT_LOCATION Assignment Location Location code. Requires corresponding finance system to be installed. VARCHAR2(63)

NBRJLBD

NBRJLBD_LOCN_CODE

ASSIGNMENT_LOCATION_DESC Assignment Location Description Assignment location description. VARCHAR2(255)

FTVLOCN

FTVLOCN_TITLE

ASSIGNMENT_ORGANIZATION Assignment Organization Organization code. Requires corresponding finance system to be installed. VARCHAR2(63)

NBRJLBD

NBRJLBD_ORGN_CODE

ASSIGNMENT_ORGANIZATION_DESC Assignment Organization Description Assignment organization description. VARCHAR2(255)

FTVORGN

FTVORGN_TITLE

ASSIGNMENT_PROGRAM Assignment Program Program code. Requires corresponding finance system to be installed. VARCHAR2(63)

NBRJLBD

NBRJLBD_PROG_CODE

ASSIGNMENT_PROGRAM_DESC Assignment Program Description Assignment program description. VARCHAR2(255)

FTVPROG

FTVPROG_TITLE

ASSIGNMENT_PROJECT_DESC Assignment Project Description Assignment project description. VARCHAR2(255)

FTVPROJ

FTVPROJ_DESC

CHANGE_INDICATOR Change Indicator Specifies if the record is active or to be deleted. VARCHAR2(1)

NBRJLBD

NBRJLBD_CHANGE_IND

CHART_OF_ACCOUNTS Chart Of Accounts Identifies the chart from other charts in a multi-chart environment. VARCHAR2(1)

NBRJLBD

NBRJLBD_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 Cost type within the corresponding finance cost accounting module. VARCHAR2(2)

NBRJLBD

NBRJLBD_CTYP_CODE

COST_TYPE_LONG_DESC Cost Type Long Description Cost type long description. VARCHAR2(255)

FTVCTYP

FTVCTYP_SHORT_DESC

COST_TYPE_SHORT_DESC Cost Type Short Description Cost type short description. VARCHAR2(255)

FTVCTYP

FTVCTYP_SHORT_DESC

EFFECTIVE_DATE Effective Date Date that the job labor distribution record becomes effective in the payroll system. DATE

NBRJLBD

NBRJLBD_EFFECTIVE_DATE

EFFECTIVE_END_DATE Effective End Date End effective date. DATE

FUNCTION

NOKODSF.F_GET_END_NBRJLBD_DATE

EFFECTIVE_START_DATE Effective Start Date Start effective date. DATE

NBRJLBD

NBRJLBD_EFFECTIVE_DATE

ENCUMBRANCE_NUMBER Encumbrance Number Unique encumbrance code of a document. VARCHAR2(8)

NBRJLBD

NBRJLBD_ENCD_NUM

ENCUMBRANCE_SEQUENCE Encumbrance Sequence Encumbrance sequence number. NUMBER

NBRJLBD

NBRJLBD_ENCD_SEQ_NUM

ENCUMB_LAST_CALCULATION_DATE Encumb Last Calculation Date Date the last encumbrance calculation was run. DATE

NBRJLBD

NBRJLBD_ENC_LAST_CALC_DATE

ENCUMB_LAST_RECAST_DATE Encumb Last Recast Date Last recasting to encumber salaries and fringes DATE

NBRJLBD

NBRJLBD_ENC_LAST_RECAST_DATE

ENCUMB_OVERRIDE_END_DATE Encumb Override End Date End date used to calculate future fiscal year encumbrances for a labor distribution. DATE

NBRJLBD

NBRJLBD_ENC_OVERRIDE_END_DATE

EXTERNAL_ACCOUNT External Account System account distribution code to which this position should be charged. VARCHAR2(60)

NBRJLBD

NBRJLBD_ACCT_CODE_EXTERNAL

FRINGE_ACCOUNT Fringe Account Fringe Account. VARCHAR2(63)

NBRJLBD

NBRJLBD_ACCT_CODE_FRINGE

FRINGE_ACCOUNT_DESC Fringe Account Description Fringe account description. VARCHAR2(255)

FTVACCT

FTVACCT_TITLE

FRINGE_ACTIVITY Fringe Activity Fringe Activity code. VARCHAR2(63)

NBRJLBD

NBRJLBD_ACTV_CODE_FRINGE

FRINGE_ACTIVITY_DESC Fringe Activity Description Fringe activity description. VARCHAR2(255)

FTVACTV

FTVACTV_TITLE

FRINGE_ENCUMBRANCE Fringe Encumbrance Amount of fringe benefits encumbered to this labor distribution for the active fiscal year. NUMBER

NBRJLBD

NBRJLBD_FRINGE_ENCUMBRANCE

FRINGE_ENCUMBRANCE_RESID_AMT Fringe Encumbrance Resid Amount Fringe encumbrance residual amount assigned to this externally funded labor distribution. NUMBER

NBRJLBD

NBRJLBD_FRINGE_RESIDUAL

FRINGE_ENCUMBRANCE_TO_POST Fringe Encumbrance To Post Amount of encumbrance that is posted to the finance system. NUMBER

NBRJLBD

NBRJLBD_FRINGE_ENC_TO_POST

FRINGE_ENCUMB_RESID_TO_POST Fringe Encumb Resid To Post Amount of fringe encumbrance residual to post to this externally funded labor distribution. NUMBER

NBRJLBD

NBRJLBD_FRINGE_RES_TO_POST

FRINGE_FUND Fringe Fund Fringe fund code. Requires corresponding finance system to be installed. VARCHAR2(63)

NBRJLBD

NBRJLBD_FUND_CODE_FRINGE

FRINGE_FUND_DESC Fringe Fund Description Fringe fund description. VARCHAR2(255)

FTVFUND

FTVFUND_TITLE

FRINGE_LOCATION Fringe Location Fringe location code. Requires corresponding finance system to be installed. VARCHAR2(63)

NBRJLBD

NBRJLBD_LOCN_CODE_FRINGE

FRINGE_LOCATION_DESC Fringe Location Description Fringe location description. VARCHAR2(255)

FTVLOCN

FTVLOCN_TITLE

FRINGE_ORGANIZATION Fringe Organization Fringe organization code. Requires corresponding finance system to be installed. VARCHAR2(63)

NBRJLBD

NBRJLBD_ORGN_CODE_FRINGE

FRINGE_ORGANIZATION_DESC Fringe Organization Description Fringe organization description. VARCHAR2(255)

FTVORGN

FTVORGN_TITLE

FRINGE_PROGRAM Fringe Program Fringe program code. Requires corresponding finance system to be installed. VARCHAR2(63)

NBRJLBD

NBRJLBD_PROG_CODE_FRINGE

FRINGE_PROGRAM_DESC Fringe Program Description Fringe program description. VARCHAR2(255)

FTVPROG

FTVPROG_TITLE

FUTURE_FRINGE_ENCUMB Future Fringe Encumb Amount of fringe benefits encumbered to a labor distribution for future fiscal years. NUMBER

NBRJLBD

NBRJLBD_FUTURE_FRINGE_ENC

FUTURE_FRINGE_ENCUMB_TO_POST Future Fringe Encumb To Post Amount of future fringe benefit encumbrance that will be posted to finance system for specified labor distribution. NUMBER

NBRJLBD

NBRJLBD_FUTURE_FRG_ENC_TO_POST

FUTURE_FRINGE_RESIDUAL Future Fringe Residual Amount of fringe encumbrance residual assigned to a labor distribution for future fiscal years. NUMBER

NBRJLBD

NBRJLBD_FUTURE_FRINGE_RESIDUAL

FUTURE_FRINGE_RESIDUAL_TO_POST Future Fringe Residual To Post Amount of future fringe encumbrance residual that will be posted to finance system for specified externally funded labor distribution. NUMBER

NBRJLBD

NBRJLBD_FUTURE_FRG_RES_TO_POST

FUTURE_SALARY_ENCUMB Future Salary Encumb Amount of salary encumbered to a labor distribution for future fiscal years. NUMBER

NBRJLBD

NBRJLBD_FUTURE_SALARY_ENC

FUTURE_SALARY_ENCUMB_TO_POST Future Salary Encumb To Post Amount of salary encumbrance that will be posted to the finance system. NUMBER

NBRJLBD

NBRJLBD_FUTURE_SAL_ENC_TO_POST

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 an Employee_Position with more precision. For example, a user could denote daytime faculty with one suffix and evening school with another. VARCHAR2(63)

NBRJLBD

NBRJLBD_SUFF

LABOR_COST_DIST_ACTIVITY_DATE Labor Cost Dist Activity Date Date information for this record in the table was entered or last updated. DATE

NBRJLBD

NBRJLBD_ACTIVITY_DATE

LABOR_COST_DIST_DATA_ORIGIN Labor Cost Dist Data Origin Source system that created or updated the data. VARCHAR2(63)

NBRJLBD

NBRJLBD_DATA_ORIGIN

LABOR_COST_DIST_USER_ID Labor Cost Dist User ID Unique identification code of the user who entered or last touched the record. VARCHAR2(63)

NBRJLBD

NBRJLBD_USER_ID

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

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

NBRJLBD

NBRJLBD_PERCENT

PERSON_UID Person UID System generated, unique, internal identification number assigned to this person. NUMBER

NBRJLBD

NBRJLBD_PIDM

POSITION Position Position number for this employee position. VARCHAR2(63)

NBRJLBD

NBRJLBD_POSN

PROCESS_GROUP Process Group Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

PROJECT Project Work order code used within cost accounting module. VARCHAR2(8)

NBRJLBD

NBRJLBD_PROJ_CODE

SALARY_ENCUMBRANCE Salary Encumbrance Amount encumbered to this labor distribution for the active fiscal year. NUMBER

NBRJLBD

NBRJLBD_SALARY_ENCUMBRANCE

SALARY_ENCUMBRANCE_TO_POST Salary Encumbrance To Post Amount of encumbrance posted to the finance system. NUMBER

NBRJLBD

NBRJLBD_SALARY_ENC_TO_POST



Ver: 9.2