Go To View:  RETURN TO BANNER COMP META DATA REPORTS LIST
Human Resources Composite View Reports

SGHE Banner Operational Data Store
Composite View Target: AP_PAYROLL_LABOR_DIST_OVERRIDE

Description Contains labor distribution override information pertaining to specic pay periods.
Key & Frequency One row per calendar year per payroll identifier per payroll number per system generated indicator per person per event sequence number per position per job suffix per position begin date per earnings per shift number.

Target Column Business Name Business Definition Database Data Type Domain Value Source Name Source Column
ACTIVITY_DATE Activity Date Date record was inserted or updated DATE  

PHRELBD

PHRELBD_ACTIVITY_DATE

CALENDAR_YEAR Calendar Year Pay period calendar year. VARCHAR2(4)  

PHRELBD

PHRELBD_YEAR

CHART_OF_ACCOUNTS Chart Of Accounts Chart of accounts code as defined on the BANNER Finance system. VARCHAR2(1)  

PHRELBD

PHRELBD_COAS_CODE

CHART_OF_ACCOUNTS_DESC Chart Of Accounts Description Chart of accounts code description or title. VARCHAR2(35)  

FUNCTION

GOKODSF.F_GET_DESC

COST_TYPE Cost Type Type of labor cost. VARCHAR2(2)  

PHRELBD

PHRELBD_CTYP_CODE

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

FUNCTION

GOKODSF.F_GET_DESC

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

FUNCTION

GOKODSF.F_GET_DESC

CURRENT_DATE Current Date System current date (sysdate) or date the data was extracted. DATE  

NA

SYSDATE

DOMAIN_VALUE Domain Value Domain column for future use, not currently populated. VARCHAR2(6)  

NA

NA

EARNINGS Earnings Earnings Code. VARCHAR2(3)  

PHRELBD

PHRELBD_EARN_CODE

EARNINGS_DESC Earnings Description Earnings code long description. VARCHAR2(30)  

PTREARN

PTREARN_LONG_DESC

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

PHRELBD

PHRELBD_ENCD_NUM

ENCUMBRANCE_SEQUENCE Encumbrance Sequence Encumbrance sequence number. NUMBER(4)  

PHRELBD

PHRELBD_ENCD_SEQ_NUM

EVENT_SEQUENCE_NUMBER Event Sequence Number Sequence of the pay event. NUMBER(2)  

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(60)  

PHRELBD

PHRELBD_ACCT_CODE_EXTERNAL

HOURS Hours Number of earnings hours associated with the labor distribution. NUMBER(6, 2)  

PHRELBD

PHRELBD_HRS

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(2)  

PHRELBD

PHRELBD_SUFF

MIF_DESC MIF Description The institution description for the record when the optional multi-institution facility feature has been installed and applied for this table/column. VARCHAR2(30)  

NA

NA

MIF_VALUE MIF Value The institution value for the record when the optional multi-institution facility feature has been installed and applied for this table/column. VARCHAR2(6)  

NA

NA

PAYROLL_IDENTIFIER Payroll Identifier Pay identification number to which this Employee_Position belongs. VARCHAR2(2)  

PHRELBD

PHRELBD_PICT_CODE

PAYROLL_IDENTIFIER_DESC Payroll Identifier Description Payroll code description or title. VARCHAR2(30)  

PTRPICT

PTRPICT_DESC

PAYROLL_NUMBER Payroll Number Used to uniquely identify a pay period within a fiscal year. NUMBER(3)  

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(5, 2)  

PHRELBD

PHRELBD_PERCENT

PERSON_UID Person UID System generated unique internal identification number assigned to this person. NUMBER(8)  

PHRELBD

PHRELBD_PIDM

POSITION Position Employee Position number. VARCHAR2(6)  

PHRELBD

PHRELBD_POSN

POSITION_ACCOUNT Position Account Code to which the position account is to be charged. VARCHAR2(6)  

PHRELBD

PHRELBD_ACCT_CODE

POSITION_ACCOUNT_DESC Position Account Description Position account description. VARCHAR2(35)  

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(6)  

PHRELBD

PHRELBD_ACCI_CODE

POSITION_ACCOUNT_INDEX_DESC Position Account INDEX Description Position account index description. VARCHAR2(35)  

FTVACCI

FTVACCI_TITLE

POSITION_ACTIVITY Position Activity Code that defines the activity to which the position should be charged. VARCHAR2(6)  

PHRELBD

PHRELBD_ACTV_CODE

POSITION_ACTIVITY_DESC Position Activity Description Position activity descripton. VARCHAR2(35)  

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(6)  

PHRELBD

PHRELBD_FUND_CODE

POSITION_FUND_DESC Position Fund Description Position fund description. VARCHAR2(35)  

FTVFUND

FTVFUND_TITLE

POSITION_LOCATION Position Location Code that identifies the program to which this position should be charged. VARCHAR2(6)  

PHRELBD

PHRELBD_LOCN_CODE

POSITION_LOCATION_DESC Position Location Description Position location description. VARCHAR2(35)  

FTVLOCN

FTVLOCN_TITLE

POSITION_ORGANIZATION Position Organization Code that identifies the organization to which this position should be charged. VARCHAR2(6)  

PHRELBD

PHRELBD_ORGN_CODE

POSITION_ORGANIZATION_DESC Position Organization Description Position organization description. VARCHAR2(35)  

FTVORGN

FTVORGN_TITLE

POSITION_PROGRAM Position Program Code that identifies the program to which this position should be charged. VARCHAR2(6)  

PHRELBD

PHRELBD_PROG_CODE

POSITION_PROGRAM_DESC Position Program Description Position program description. VARCHAR2(35)  

FTVPROG

FTVPROG_TITLE

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

PHRELBD

PHRELBD_PROJ_CODE

POSITION_PROJECT_DESC Position Project Description Position project description. VARCHAR2(30)  

FTVPROJ

FTVPROJ_DESC

POSITION_TITLE Position Title Description of the Employee_Position. Defaults from the position title if left blank. VARCHAR2(30)  

NBBPOSN

NBBPOSN_TITLE

REDISTRIBUTION_AMOUNT Redistribution Amount Amount of redistributed dollars. NUMBER(11, 2)  

PHRELBD

PHRELBD_REDISTRIBUTION_AMT

SHIFT_NUMBER Shift Number Shift Associated with Earnings Code. VARCHAR2(1)  

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(35)  

FUNCTION

GOKODSF.F_GET_DESC

TIMESHEET_CHART_OF_ACCOUNTS Timesheet Chart Of Accounts Timesheet Chart of Accounts Code VARCHAR2(1)  

PHRELBD

PHRELBD_COAS_CODE_TS

TIMESHEET_METHOD Timesheet Method Determines the method by which the timesheet is entered in they system. VARCHAR2(1)  

PHRELBD

PHRELBD_TS_ROSTER_IND

TIMESHEET_METHOD_DESC Timesheet Method Description Timesheet method description. VARCHAR2(12)  

CALCULATION

DECODE(PHRELBD_TS_ROSTER_IND)

TIMESHEET_ORGANIZATION Timesheet Organization Organization to which the time sheet for this position is sent. VARCHAR2(6)  

PHRELBD

PHRELBD_ORGN_CODE_TS

TIMESHEET_ORGANIZATION_DESC Timesheet Organization Description Organization to which this Employee_Position's time sheet is sent. VARCHAR2(35)  

FUNCTION

GOKODSF.F_GET_DESC

ZONE_VALUE Zone Value Zone column for future use, not currently populated. VARCHAR2(6)  

NA

NA



Ver: