Go To View:  RETURN TO COMPOSITE VIEW REPORTS LIST
Human Resources Composite View Reports

SGHE Banner Operational Data Store
Composite View Target: AN_PAYROLL_DISTRIBUTION

Description Contains organization payroll distribution information specific to each payroll.

Target Column Business Definition Database Data Type Source Name Source Column
ACCOUNT Account code. Only filled if Finance System is present. VARCHAR2(6)

NHRDIST

NHRDIST_ACCT_CODE

ACTIVITY Activity code. Only filled if Finance System is present. VARCHAR2(6)

NHRDIST

NHRDIST_ACTV_CODE

ACTIVITY_DESC Description of the activity code. VARCHAR2(35)

FUNCTION

GOKODSF.F_BUILD_DYNAMIC_FINANCE_DESC

ACTIVITY_STATUS Status of the associated activity for this Level of the Hierarchy. VARCHAR2(1)

FUNCTION

GOKODSF.F_BUILD_DYNAMIC_FINANCE_STATUS

BUDGET_DOCUMENT User or system generated document number. VARCHAR2(8)

NHRDIST

NHRDIST_POSNBUD_DOC_CODE

BUDGET_IDENTIFIER User-defined unique identification of the budget. Generally Fiscal year for which the budget is being prepared. VARCHAR2(6)

NHRDIST

NHRDIST_OBUD_CODE

BUDGET_IDENTIFIER_DESC Description of the budget. VARCHAR2(35)

NHRDIST

NHRDIST_OBUD_CODE

BUDGET_PHASE_CODE System defined code for the budget phase. VARCHAR2(6)

NHRDIST

NHRDIST_OBPH_CODE

BUDGET_PHASE_DESC Budget phase description. VARCHAR2(35)

NHRDIST

NHRDIST_OBPH_CODE

BUDGET_STATUS Identifies the current status of the Position Total record. Valid values are active, working, transferred or closed. VARCHAR2(1)

NHRDIST

NHRDIST_PTOT_STATUS

BUDGET_STATUS_DESC Position status description. VARCHAR2(30)

CALCULATION

DECODE(NBRPTOT_STATUS,'A',APPROVED,'C',CLOSED,'T',TRANSFERRED,'W',WORKING)

CALENDAR_YEAR Pay Period Year for Expenditure Interface transactions. This will be null for all transactions other than Expenditure type transactions. VARCHAR2(4)

NHRDIST

NHRDIST_YEAR

CARRIER Identifies the specific Benefit/deduction. VARCHAR2(3)

NHRDIST

NHRDIST_BDCA_CODE

CARRIER_LONG_DESC Identifies the long description for the specific Benefit/deduction. VARCHAR2(30)

PTRBDCA

PTRBDCA_LONG_DESC

CARRIER_SHORT_DESC Identifies the short description for the specific Benefit/deduction. VARCHAR2(8)

PTRBDCA

PTRBDCA_SHORT_DESC

CATEGORY An internal code which identifies the type of Finance Interface transaction (Earnings, Employee deductions, Net Pay, Budget Adjustment, Encumbrance, etc.) VARCHAR2(1)

NHRDIST

NHRDIST_CATEGORY_CODE

CATEGORY_DESC Need help identifying from form VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

CHART_OF_ACCOUNTS Chart of Accounts Code. Only filled if Finance System is present. VARCHAR2(1)

NHRDIST

NHRDIST_COAS_CODE

CHART_OF_ACCOUNTS_DESC Name of the chart of accounts. VARCHAR2(35)

FTVCOAS

FTVCOAS_TITLE

COST_TYPE Type of labor cost. VARCHAR2(2)

NHRDIST

NHRDIST_CTYP_CODE

COST_TYPE_DESC Cost type description. VARCHAR2(35)

FUNCTION

GOKODSF.F_GET_DESC

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

NA

SYSDATE

DEBIT_CREDIT_IND Debit/Credit indicator. This column can have a value of D, C, + or - depending on the particular transaction and whether that transaction represents a negative amount or not. VARCHAR2(1)

NHRDIST

NHRDIST_DR_CR_IND

DOCUMENT User or system generated document number. VARCHAR2(8)

NHRDIST

NHRDIST_DOC_CODE

DOCUMENT_DATE The date that will appear on the pay document. DATE

PTRCALN

PTRCALN_CHECK_DATE

DOMAIN_VALUE The institution value of the organization-oriented identifier for the record used to determine access authorization to this record. VARCHAR2(6)

NA

NA

EARNINGS Earnings Code. VARCHAR2(3)

NHRDIST

NHRDIST_EARN_CODE

EARNINGS_DESC Earnings code long description. VARCHAR2(30)

PTREARN

PTREARN_LONG_DESC

ENCUMBRANCE_ITEM_NUMBER Used with BANNER FINANCE to identify the line item on the encumbrance document posted from BANNER HR. Item 0 is salary, 1 is standard fringe, 2 is residual fringe. NUMBER(4)

NHRDIST

NHRDIST_ENCD_ITEM_NUM

ENCUMBRANCE_NUMBER Used with BANNER FINANCE to identify the encumbrance document posted from BANNER HR for a given fiscal year. VARCHAR2(8)

NHRDIST

NHRDIST_ENCD_NUM

ENCUMBRANCE_SEQ_NUMBER Used with BANNER FINANCE to identify the sequence number on the encumbrance document posted from BANNER HR. NUMBER(4)

NHRDIST

NHRDIST_ENCD_SEQ_NUM

EVENT_SEQUENCE_NUMBER Pay Event Identifying Sequence Number. NUMBER(2)

NHRDIST

NHRDIST_SEQ_NO

EXTERNAL_ACCOUNT Free form Account Number to be used to interface to finance systems when Banner Finance is not present. VARCHAR2(60)

NHRDIST

NHRDIST_ACCT_CODE_EXTERNAL

FISCAL_YEAR The Fiscal Year to which this interface transaction will be posted. VARCHAR2(4)

NHRDIST

NHRDIST_FISC_CODE

FUND Fund code. Only filled if Finance System is present. VARCHAR2(6)

NHRDIST

NHRDIST_FUND_CODE

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)

NHRDIST

NHRDIST_SUFF

LABOR_DISTRIBUTION_HOURS Number of Earnings Hours Associated With the Labor Distribution. NUMBER(6, 2)

NHRDIST

NHRDIST_HRS

LOCATION Location code. Only filled if Finance System is present. VARCHAR2(6)

NHRDIST

NHRDIST_LOCN_CODE

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

ORGANIZATION_CODE Organization code. Only filled if Finance System is present. VARCHAR2(6)

NHRDIST

NHRDIST_ORGN_CODE

PAYROLL_EVENT_TYPE Indicates the type of pay event (Manual, Void, Redistribution, etc.). VARCHAR2(1)

NHRDIST

NHRDIST_HIST_TYPE_IND

PAYROLL_EVENT_TYPE_DESC Description of the pay event type. VARCHAR2(30)

CALCULATION

DECODE(NHRDIST_HIST_TYPE_IND)

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

NHRDIST

NHRDIST_PICT_CODE

PAYROLL_IDENTIFIER_DESC The description or title of the payroll code. VARCHAR2(30)

PTRPICT

PTRPICT_DESC

PAYROLL_PERIOD_NUMBER The Pay Number is used to uniquely identify a pay period within a fiscal year. NUMBER(3)

NHRDIST

NHRDIST_PAYNO

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

NHRDIST

NHRDIST_PIDM

POSITION Employee Position number. VARCHAR2(6)

NHRDIST

NHRDIST_POSN

POSITION_EMPLOYEE_CLASS Employee Position Class VARCHAR2(2)

NHRDIST

NHRDIST_ECLS_CODE

POSITION_EMPLOYEE_CLASS_DESC Employee position class description. VARCHAR2(30)

PTRECLS

PTRECLS_LONG_DESC

POSITION_TOTAL_IND Indicates if the earnings being processed updates the position total and expended amount. VARCHAR2(1)

NHRDIST

NHRDIST_EARN_EXPENDS_PTOT_IND

POSTING_STATUS Indicates the status of the transaction in the accounting feed process as ready to feed or transaction has been fed. VARCHAR2(1)

NHRDIST

NHRDIST_INTERFACED_IND

PROGRAM Program code. Only filled if Finance System is present. VARCHAR2(6)

NHRDIST

NHRDIST_PROG_CODE

PROJECT Work order code used for cost accounting. VARCHAR2(8)

NHRDIST

NHRDIST_PROJ_CODE

PROJECT_DESC Description of the project. VARCHAR2(35)

FUNCTION

FOKODSF.F_GET_FINANCE_DESC

RULE_CLASS The Finance System Rule Class code to be applied to this interface transaction. VARCHAR2(4)

NHRDIST

NHRDIST_RUCL_CODE

RULE_CLASS_DESC Unique title assigned to a rule class. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

SOURCE Helps to tie the transaction back to its source. Different values are stored here depending on the transaction (For earnings: Earn Code, for Benefits/Deductions: Deduction/Benefit code, for budget: Position ID, etc.) VARCHAR2(10)

NHRDIST

NHRDIST_SOURCE

SOURCE_DESC Description of the source. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

TAX_DEDUCTION Identifies the specific Benefit/deduction. VARCHAR2(3)

PDRDEDN

PDRDEDN_BDCA_CODE

TAX_DEDUCTION_LONG_DESC Identifies the long description for the specific Benefit/deduction. VARCHAR2(30)

PTRBDCA

PTRBDCA_LONG_DESC

TAX_DEDUCTION_SHORT_DESC Identifies the short description for the specific Benefit/deduction. VARCHAR2(8)

PTRBDCA

PTRBDCA_SHORT_DESC

TRANSACTION_AMOUNT The absolute dollar amount of the transaction associated with this specific account distribution. The DEBIT_CREDIT_IND is used when representing negative transactions. NUMBER(11, 2)

NHRDIST

NHRDIST_AMT

TRANSACTION_DATE The transaction date used to post this entry through into the finance system. DATE

NHRDIST

NHRDIST_TRANS_DATE

TRANSACTION_NUMBER Unique transaction number generated by the payroll process. NUMBER(15)

NHRDIST

NHRDIST_TNUM

ZONE_VALUE The institution value of the process-oriented identifier for the record used to determine access authorization to this record. VARCHAR2(6)

NA

NA



Ver: 8.0