Go To View:  RETURN TO COMPOSITE VIEW 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 Definition Database Data Type Source Name Source Column
ACTIVITY_DATE Date record was inserted or updated DATE

PHRELBD

PHRELBD_ACTIVITY_DATE

CALENDAR_YEAR Pay period calendar year. VARCHAR2(4)

PHRELBD

PHRELBD_YEAR

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 code description or title. VARCHAR2(35)

FUNCTION

GOKODSF.F_GET_DESC

COST_TYPE Type of labor cost. VARCHAR2(2)

PHRELBD

PHRELBD_CTYP_CODE

COST_TYPE_LONG_DESC Cost type long description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

COST_TYPE_SHORT_DESC Cost type short description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

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

NA

SYSDATE

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

NA

NA

EARNINGS Earnings Code. VARCHAR2(3)

PHRELBD

PHRELBD_EARN_CODE

EARNINGS_DESC Earnings code long description. VARCHAR2(30)

PTREARN

PTREARN_LONG_DESC

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

PHRELBD

PHRELBD_ENCD_NUM

ENCUMBRANCE_SEQUENCE Encumbrance sequence number. NUMBER(4)

PHRELBD

PHRELBD_ENCD_SEQ_NUM

EVENT_SEQUENCE_NUMBER Sequence of the pay event. NUMBER(2)

PHRELBD

PHRELBD_SEQ_NO

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 Number of earnings hours associated with the labor distribution. NUMBER(6, 2)

PHRELBD

PHRELBD_HRS

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 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 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 Pay identification number to which this Employee_Position belongs. VARCHAR2(2)

PHRELBD

PHRELBD_PICT_CODE

PAYROLL_IDENTIFIER_DESC Payroll code description or title. VARCHAR2(30)

PTRPICT

PTRPICT_DESC

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

PHRELBD

PHRELBD_PAYNO

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 System generated unique internal identification number assigned to this person. NUMBER(8)

PHRELBD

PHRELBD_PIDM

POSITION Employee Position number. VARCHAR2(6)

PHRELBD

PHRELBD_POSN

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

PHRELBD

PHRELBD_ACCT_CODE

POSITION_ACCOUNT_DESC Position account description. VARCHAR2(35)

FTVACCT

FTVACCT_TITLE

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

FTVACCI

FTVACCI_TITLE

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 descripton. VARCHAR2(35)

FTVACTV

FTVACTV_TITLE

POSITION_BEGIN_DATE Date an Employee_Position became effective in the payroll system. DATE

PHRELBD

PHRELBD_EFFECTIVE_DATE

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

FTVFUND

FTVFUND_TITLE

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

FTVLOCN

FTVLOCN_TITLE

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

FTVORGN

FTVORGN_TITLE

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

FTVPROG

FTVPROG_TITLE

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

PHRELBD

PHRELBD_PROJ_CODE

POSITION_PROJECT_DESC Position project description. VARCHAR2(30)

FTVPROJ

FTVPROJ_DESC

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

NBBPOSN

NBBPOSN_TITLE

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

PHRELBD

PHRELBD_REDISTRIBUTION_AMT

SHIFT_NUMBER Shift Associated with Earnings Code. VARCHAR2(1)

PHRELBD

PHRELBD_SHIFT

SYSTEM_GENERATED_IND Indicates if the pay event was calculated manually or by the system. VARCHAR2(1)

PHRELBD

PHRELBD_GEN_IND

TIMESHEET_CHART_DESC Chart of accounts code description or title. VARCHAR2(35)

FUNCTION

GOKODSF.F_GET_DESC

TIMESHEET_CHART_OF_ACCOUNTS Timesheet Chart of Accounts Code VARCHAR2(1)

PHRELBD

PHRELBD_COAS_CODE_TS

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. VARCHAR2(30)

CALCULATION

DECODE(PHRELBD_TS_ROSTER_IND)

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

PHRELBD

PHRELBD_ORGN_CODE_TS

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

FUNCTION

GOKODSF.F_GET_DESC

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

NA

NA



Ver: 8.0