RETURN TO COMPOSITE VIEW REPORTS LIST
Human Resources Composite View Reports

SGHE Operational Data Store
Composite View Target: AN_PAYROLL_DISTRIBUTION

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)

FTVACTV

FTVACTV_TITLE

ACTIVITY_STATUS Status of the associated activity for this Level of the Hierarchy. VARCHAR2(1)    
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(30)

NHRDIST

NHRDIST_BDCA_CODE

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

NHRDIST

NHRDIST_CTYP_CODE

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

FUNCTION

GOKODSF.F_GET_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)

FUNCTION

GOKODSF.F_GET_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)

FUNCTION

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

NHRDIST

NHRDIST_PROJ_CODE

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

PDRDEDN

PDRDEDN_BDCA_CODE

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: 3.1