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

SGHE Banner Operational Data Store
Reporting View Target: PAYROLL_DISTRIBUTION

Description Contains organization payroll distribution information specific to each payroll.
Key & Frequency One row per payroll identifier per calendar year per payroll number per event sequence number per person per transaction number.
Recommended Search Columns PERSON_UID, CARRIER
CARRIER, STATUS
CALENDAR_YEAR, PAYROLL_IDENTIFIER, PAYROLL_NUMBER, EVENT_SEQUENCE_NUMBER, PERSON_UID
CHART_OF_ACCOUNTS, ACCOUNT
CHART_OF_ACCOUNTS, ORGANIZATION_CODE
CHART_OF_ACCOUNTS, FUND
PERSON_UID, TAX_DEDUCTION
CATEGORY, TRANSACTION_DATE
POSITION
TAX_DEDUCTION, STATUS
CHART_OF_ACCOUNTS, PROGRAM
HOME_ORGANIZATION_CHART, HOME_ORGANIZATION, PERSON_UID
PERSON_UID, POSITION, JOB_SUFFIX
POSITION, JOB_SUFFIX
CHART_OF_ACCOUNTS, LOCATION

ODS Column ODS Business Definition ODS Calculation Formula ODS Data Type Banner Source Name Banner Source Column Banner Form Name
ACCOUNT Account code. Only filled if Finance System is present.    

NHRDIST

NHRDIST_ACCT_CODE

 
ACCOUNT_DESC Description of the account code.    

FTVACCT

FTVACCT_TITLE

 
ACCOUNT_DESC_1 Hierarchy description or title appropriate for this Level.    

FUNCTION

FOKODSF.F_GET_ACCT_HIER

 
ACCOUNT_DESC_2 Hierarchy description or title appropriate for this Level.    

FUNCTION

FOKODSF.F_GET_ACCT_HIER

 
ACCOUNT_DESC_3 Hierarchy description or title appropriate for this Level.    

FUNCTION

FOKODSF.F_GET_ACCT_HIER

 
ACCOUNT_DESC_4 Hierarchy description or title appropriate for this Level.    

FUNCTION

FOKODSF.F_GET_ACCT_HIER

 
ACCOUNT_LEVEL_1 Defined value representing an account. Accounts are either Assets, Liability, Control, Fund Balance, Revenue, Labor, Expenditure or Transfer.    

FUNCTION

FOKODSF.F_GET_ACCT_HIER

 
ACCOUNT_LEVEL_2 Defined value representing an account. Accounts are either Assets, Liability, Control, Fund Balance, Revenue, Labor, Expenditure or Transfer.    

FUNCTION

FOKODSF.F_GET_ACCT_HIER

 
ACCOUNT_LEVEL_3 Defined value representing an account. Accounts are either Assets, Liability, Control, Fund Balance, Revenue, Labor, Expenditure or Transfer.    

FUNCTION

FOKODSF.F_GET_ACCT_HIER

 
ACCOUNT_LEVEL_4 Defined value representing an account. Accounts are either Assets, Liability, Control, Fund Balance, Revenue, Labor, Expenditure or Transfer.    

FUNCTION

FOKODSF.F_GET_ACCT_HIER

 
ACCOUNT_STATUS Indicates Status of the associated account for this Level of the Hierarchy.    

FTVACCT

FTVACCT_STATUS_IND

 
ACCOUNT_STATUS_1 Indicates Status of the associated account for this Level of the Hierarchy.    

FUNCTION

FOKODSF.F_GET_ACCT_HIER

 
ACCOUNT_STATUS_2 Indicates Status of the associated account for this Level of the Hierarchy.    

FUNCTION

FOKODSF.F_GET_ACCT_HIER

 
ACCOUNT_STATUS_3 Indicates Status of the associated account for this Level of the Hierarchy.    

FUNCTION

FOKODSF.F_GET_ACCT_HIER

 
ACCOUNT_STATUS_4 Indicates Status of the associated account for this Level of the Hierarchy.    

FUNCTION

FOKODSF.F_GET_ACCT_HIER

 
ACCOUNT_TYPE_DESC_1 Hierarchy description or title appropriate for this Level.    

FUNCTION

FOKODSF.F_GET_ACCT_HIER

 
ACCOUNT_TYPE_DESC_2 Hierarchy description or title appropriate for this Level.    

FUNCTION

FOKODSF.F_GET_ACCT_HIER

 
ACCOUNT_TYPE_LEVEL_1 Classifies an account type i.e., asset, revenue, etc. for reporting purposes.    

FUNCTION

FOKODSF.F_GET_ACCT_HIER

 
ACCOUNT_TYPE_LEVEL_2 Classifies an account type i.e., asset, revenue, etc. for reporting purposes.    

FUNCTION

FOKODSF.F_GET_ACCT_HIER

 
ACCOUNT_TYPE_STATUS_1 Status of the primary account type within this account Hierarchy.    

FUNCTION

FOKODSF.F_GET_ACCT_HIER

 
ACCOUNT_TYPE_STATUS_2 Status of the secondary account type within this account Hierarchy.    

FUNCTION

FOKODSF.F_GET_ACCT_HIER

 
ACTIVITY Activity code. Only filled if Finance System is present.    

NHRDIST

NHRDIST_ACTV_CODE

 
ACTIVITY_DESC Description of the activity code.    

FTVACTV

FTVACTV_TITLE

 
ACTIVITY_STATUS Status of the associated activity for this Level of the Hierarchy.    

FUNCTION

F_GET_FINANCE_STATUS

 
ADMINISTRATIVE_GROUP Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.    

NA

NA

 
BENEFIT_DEDUCTION_TYPE Benefit deduction type.    

PTRBDCA

PTRBDCA_BDTY_CODE

 
BENEFIT_DEDUCTION_TYPE_DESC Benefit deduction type description.    

FUNCTION

GOKODSF.F_GET_DESC

 
BUDGET_DOCUMENT User or system generated document number.    

NHRDIST

NHRDIST_POSNBUD_DOC_CODE

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

NHRDIST

NHRDIST_OBUD_CODE

 
BUDGET_IDENTIFIER_DESC Description of the budget.    

NHRDIST

NHRDIST_OBUD_CODE

 
BUDGET_PHASE_CODE System defined code for the budget phase.    

NHRDIST

NHRDIST_OBPH_CODE

 
BUDGET_PHASE_DESC Budget phase description.    

NHRDIST

NHRDIST_OBPH_CODE

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

NHRDIST

NHRDIST_PTOT_STATUS

 
BUDGET_STATUS_DESC Position status description.    

CALCULATION

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

 
CALCULATION_RULE Defines how a benefit/deduction is processed by the system. The Calc Rule selected also determines how the Deduction Form and the Deduction Set-up Form function.    

PTRBDCA

PTRBDCA_CALC_RULE

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

NHRDIST

NHRDIST_YEAR

 
CARRIER Identifies the specific Benefit/deduction.    

NHRDIST

NHRDIST_BDCA_CODE

 
CARRIER_LONG_DESC Benefit/deduction long description.    

PTRBDCA

PTRBDCA_LONG_DESC

 
CARRIER_SHORT_DESC Benefit/deduction short description.    

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

NHRDIST

NHRDIST_CATEGORY_CODE

 
CATEGORY_DESC Need help identifying from form    

FUNCTION

GOKODSF.F_GET_DESC

 
CHART_OF_ACCOUNTS Chart of Accounts Code. Only filled if Finance System is present.    

NHRDIST

NHRDIST_COAS_CODE

 
CHART_OF_ACCOUNTS_DESC Name of the chart of accounts.    

FTVCOAS

FTVCOAS_TITLE

 
COST_TYPE Type of labor cost.    

NHRDIST

NHRDIST_CTYP_CODE

 
COST_TYPE_DESC Cost type description.    

FUNCTION

GOKODSF.F_GET_DESC

 
COVERAGE_OPTION First option code for the benefit/deduction code. The use of this field is determined by the calculation rule assigned to the benefit/ deduction.    

PDRDEDN

PDRDEDN_OPT_CODE1

 
COVERAGE_OPTION_DESC Description/title for the Plan Code.    

PDRDEDN

PDRDEDN_OPT_CODE1

 
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.    

NHRDIST

NHRDIST_DR_CR_IND

 
DOCUMENT User or system generated document number.    

NHRDIST

NHRDIST_DOC_CODE

 
DOCUMENT_DATE The date that will appear on the pay document.    

PTRCALN

PTRCALN_CHECK_DATE

 
EARNINGS Earnings Code.    

NHRDIST

NHRDIST_EARN_CODE

 
EARNINGS_DESC Earnings code long description.    

PTREARN

PTREARN_LONG_DESC

 
EMPLOYER User-defined code used as part of the Employee_Position definition. It is often used, for example, as a means to identify different campuses within an institution, or different major functional areas.    

NBRJOBS

NBRJOBS_EMPR_CODE

 
EMPLOYER_DESC Employer_Code description.    

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.    

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.    

NHRDIST

NHRDIST_ENCD_NUM

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

NHRDIST

NHRDIST_ENCD_SEQ_NUM

 
EVENT_SEQUENCE_NUMBER Pay Event Identifying Sequence Number.    

NHRDIST

NHRDIST_SEQ_NO

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

NHRDIST

NHRDIST_ACCT_CODE_EXTERNAL

 
FISCAL_YEAR The Fiscal Year to which this interface transaction will be posted.    

NHRDIST

NHRDIST_FISC_CODE

 
FUND Fund code. Only filled if Finance System is present.    

NHRDIST

NHRDIST_FUND_CODE

 
FUND_DESC Description of the fund code.    

FTVFUND

FTVFUND_TITLE

 
FUND_DESC_1 Hierarchy description or title appropriate for this Level.    

FUNCTION

FOKODSF.F_GET_FUND_HIER

 
FUND_DESC_2 Hierarchy description or title appropriate for this Level.    

FUNCTION

FOKODSF.F_GET_FUND_HIER

 
FUND_DESC_3 Hierarchy description or title appropriate for this Level.    

FUNCTION

FOKODSF.F_GET_FUND_HIER

 
FUND_DESC_4 Hierarchy description or title appropriate for this Level.    

FUNCTION

FOKODSF.F_GET_FUND_HIER

 
FUND_DESC_5 Hierarchy description or title appropriate for this Level.    

FUNCTION

FOKODSF.F_GET_FUND_HIER

 
FUND_LEVEL_1 Primary Fund within the fund Hierarchy.    

FUNCTION

FOKODSF.F_GET_FUND_HIER

 
FUND_LEVEL_2 Level 2 fund within this Fund Hierarchy.    

FUNCTION

FOKODSF.F_GET_FUND_HIER

 
FUND_LEVEL_3 Level 3 fund within this Fund Hierarchy.    

FUNCTION

FOKODSF.F_GET_FUND_HIER

 
FUND_LEVEL_4 Level 4 fund within this Fund Hierarchy.    

FUNCTION

FOKODSF.F_GET_FUND_HIER

 
FUND_LEVEL_5 Level 5 fund within this Fund Hierarchy.    

FUNCTION

FOKODSF.F_GET_FUND_HIER

 
FUND_STATUS Current Status of the associated Fund .    

FTVFUND

FTVFUND_STATUS_IND

 
FUND_STATUS_1 Status of the Primary Fund within the fund Hierarchy.    

FUNCTION

FOKODSF.F_GET_FUND_HIER

 
FUND_STATUS_2 Status of the Level 2 fund within this Fund Hierarchy.    

FUNCTION

FOKODSF.F_GET_FUND_HIER

 
FUND_STATUS_3 Status of the Level 3 fund within this Fund Hierarchy.    

FUNCTION

FOKODSF.F_GET_FUND_HIER

 
FUND_STATUS_4 Status of the Level 4 fund within this Fund Hierarchy.    

FUNCTION

FOKODSF.F_GET_FUND_HIER

 
FUND_STATUS_5 Status of the Level 5 fund within this Fund Hierarchy.    

FUNCTION

FOKODSF.F_GET_FUND_HIER

 
FUND_TYPE_DESC_1 Hierarchy description or title appropriate for this Level.    

FUNCTION

FOKODSF.F_GET_FUND_HIER

 
FUND_TYPE_DESC_2 Hierarchy description or title appropriate for this Level.    

FUNCTION

FOKODSF.F_GET_FUND_HIER

 
FUND_TYPE_LEVEL_1 Primary Fund type within this Fund Hierarchy.    

FUNCTION

FOKODSF.F_GET_FUND_HIER

 
FUND_TYPE_LEVEL_2 Level 2 fund type within this Fund Hierarchy.    

FUNCTION

FOKODSF.F_GET_FUND_HIER

 
FUND_TYPE_STATUS_1 Status of the Primary Fund type within this Fund Hierarchy.    

FUNCTION

FOKODSF.F_GET_FUND_HIER

 
FUND_TYPE_STATUS_2 Status of the Level 2 fund type within this Fund Hierarchy.    

FUNCTION

FOKODSF.F_GET_FUND_HIER

 
HOME_ORGANIZATION Home organization code of the employee.    

PEBEMPL

PEBEMPL_ORGN_CODE_HOME

 
HOME_ORGANIZATION_CHART Home chart of accounts code for the employee.    

PEBEMPL

PEBEMPL_COAS_CODE_HOME

 
HOME_ORGANIZATION_DESC The organization to which this Employee_Position's time sheet will be sent.    

FUNCTION

GOKODSF.F_GET_DESC

 
ID Identification number assigned to a person that is used externally for all communication and correspondence with the person.    

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

 
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.    

NHRDIST

NHRDIST_SUFF

 
LABOR_DISTRIBUTION_HOURS Number of Earnings Hours Associated With the Labor Distribution.    

NHRDIST

NHRDIST_HRS

 
LOCATION Location code. Only filled if Finance System is present.    

NHRDIST

NHRDIST_LOCN_CODE

 
LOCATION_DESC Description of the location code.    

FTVLOCN

FTVLOCN_TITLE

 
LOCATION_DESC_1 Hierarchy description or title appropriate for this Level.    

FUNCTION

FOKODSF.F_GET_LOCN_HIER

 
LOCATION_DESC_2 Hierarchy description or title appropriate for this Level.    

FUNCTION

FOKODSF.F_GET_LOCN_HIER

 
LOCATION_DESC_3 Hierarchy description or title appropriate for this Level.    

FUNCTION

FOKODSF.F_GET_LOCN_HIER

 
LOCATION_DESC_4 Hierarchy description or title appropriate for this Level.    

FUNCTION

FOKODSF.F_GET_LOCN_HIER

 
LOCATION_DESC_5 Hierarchy description or title appropriate for this Level.    

FUNCTION

FOKODSF.F_GET_LOCN_HIER

 
LOCATION_LEVEL_1 Level 1 location within this location Hierarchy.    

FUNCTION

FOKODSF.F_GET_LOCN_HIER

 
LOCATION_LEVEL_2 Level 2 location within this location Hierarchy.    

FUNCTION

FOKODSF.F_GET_LOCN_HIER

 
LOCATION_LEVEL_3 Level 3 location within this location Hierarchy.    

FUNCTION

FOKODSF.F_GET_LOCN_HIER

 
LOCATION_LEVEL_4 Level 4 location within this location Hierarchy.    

FUNCTION

FOKODSF.F_GET_LOCN_HIER

 
LOCATION_LEVEL_5 Level 5 location within this location Hierarchy.    

FUNCTION

FOKODSF.F_GET_LOCN_HIER

 
LOCATION_STATUS Current Status of the associated location.    

FTVLOCN

FTVLOCN_STATUS_IND

 
LOCATION_STATUS_1 Status of the Level 1 location within this program Hierarchy.    

FUNCTION

FOKODSF.F_GET_LOCN_HIER

 
LOCATION_STATUS_2 Status of the Level 2 location within this location Hierarchy.    

FUNCTION

FOKODSF.F_GET_LOCN_HIER

 
LOCATION_STATUS_3 Status of the Level 3 location within this location Hierarchy.    

FUNCTION

FOKODSF.F_GET_LOCN_HIER

 
LOCATION_STATUS_4 Status of the Level 4 location within this location Hierarchy.    

FUNCTION

FOKODSF.F_GET_LOCN_HIER

 
LOCATION_STATUS_5 Status of the Level 5 location within this location Hierarchy.    

FUNCTION

FOKODSF.F_GET_LOCN_HIER

 
MULTI_SOURCE Institution value for the record when the optional multi-institution facility feature has been applied.    

NA

NA

 
MULTI_SOURCE_DESC Institution description when the optional multi-institution facility feature has been applied.    

NA

NA

 
NAME Combination of the person's first, middle initial, and last name into one value.    

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

 
NORMALIZED_TRANSACTION_AMOUNT The normalized dollar amount of the transaction associated with this specific account distribution. Negative transactions are represented in the format (-1000).    

CALCULATION

DECODE(NORMAL_BALANCE)

 
ORGANIZATION_CODE Organization code. Only filled if Finance System is present.    

NHRDIST

NHRDIST_ORGN_CODE

 
ORGANIZATION_DESC Description of the organization code.    

FTVORGN

FTVORGN_TITLE

 
ORGANIZATION_DESC_1 Hierarchy description or title appropriate for this Level.    

FUNCTION

FOKODSF.F_GET_ORGN_HIER

 
ORGANIZATION_DESC_2 Hierarchy description or title appropriate for this Level.    

FUNCTION

FOKODSF.F_GET_ORGN_HIER

 
ORGANIZATION_DESC_3 Hierarchy description or title appropriate for this Level.    

FUNCTION

FOKODSF.F_GET_ORGN_HIER

 
ORGANIZATION_DESC_4 Hierarchy description or title appropriate for this Level.    

FUNCTION

FOKODSF.F_GET_ORGN_HIER

 
ORGANIZATION_DESC_5 Hierarchy description or title appropriate for this Level.    

FUNCTION

FOKODSF.F_GET_ORGN_HIER

 
ORGANIZATION_DESC_6 Hierarchy description or title appropriate for this Level.    

FUNCTION

FOKODSF.F_GET_ORGN_HIER

 
ORGANIZATION_DESC_7 Hierarchy description or title appropriate for this Level.    

FUNCTION

FOKODSF.F_GET_ORGN_HIER

 
ORGANIZATION_DESC_8 Hierarchy description or title appropriate for this Level.    

FUNCTION

FOKODSF.F_GET_ORGN_HIER

 
ORGANIZATION_LEVEL_1 primary organization within the organization Hierarchy.    

FUNCTION

FOKODSF.F_GET_ORGN_HIER

 
ORGANIZATION_LEVEL_2 Level 2 organization within this organization Hierarchy.    

FUNCTION

FOKODSF.F_GET_ORGN_HIER

 
ORGANIZATION_LEVEL_3 Level 3 organization within this organization Hierarchy.    

FUNCTION

FOKODSF.F_GET_ORGN_HIER

 
ORGANIZATION_LEVEL_4 Level 4 organization within this organization Hierarchy.    

FUNCTION

FOKODSF.F_GET_ORGN_HIER

 
ORGANIZATION_LEVEL_5 Level 5 organization within this organization Hierarchy.    

FUNCTION

FOKODSF.F_GET_ORGN_HIER

 
ORGANIZATION_LEVEL_6 Level 6 organization within this organization Hierarchy.    

FUNCTION

FOKODSF.F_GET_ORGN_HIER

 
ORGANIZATION_LEVEL_7 Level 7 organization within this organization Hierarchy.    

FUNCTION

FOKODSF.F_GET_ORGN_HIER

 
ORGANIZATION_LEVEL_8 Level 8 organization within this organization Hierarchy.    

FUNCTION

FOKODSF.F_GET_ORGN_HIER

 
ORGANIZATION_STATUS Current Status of the associated organization.    

FUNCTION

F_GET_FINANCE_STATUS

 
ORGANIZATION_STATUS_1 Status of the primary organization within the organization Hierarchy.    

FUNCTION

FOKODSF.F_GET_ORGN_HIER

 
ORGANIZATION_STATUS_2 Status of the Level 2 organization within this organization Hierarchy.    

FUNCTION

FOKODSF.F_GET_ORGN_HIER

 
ORGANIZATION_STATUS_3 Status of the Level 3 organization within this organization Hierarchy.    

FUNCTION

FOKODSF.F_GET_ORGN_HIER

 
ORGANIZATION_STATUS_4 Status of the Level 4 organization within this organization Hierarchy.    

FUNCTION

FOKODSF.F_GET_ORGN_HIER

 
ORGANIZATION_STATUS_5 Status of the Level 5 organization within this organization Hierarchy.    

FUNCTION

FOKODSF.F_GET_ORGN_HIER

 
ORGANIZATION_STATUS_6 Status of the Level 6 organization within this organization Hierarchy.    

FUNCTION

FOKODSF.F_GET_ORGN_HIER

 
ORGANIZATION_STATUS_7 Status of the Level 7 organization within this organization Hierarchy.    

FUNCTION

FOKODSF.F_GET_ORGN_HIER

 
ORGANIZATION_STATUS_8 Status of the Level 8 organization within this organization Hierarchy.    

FUNCTION

FOKODSF.F_GET_ORGN_HIER

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

NHRDIST

NHRDIST_HIST_TYPE_IND

 
PAYROLL_EVENT_TYPE_DESC Description of the pay event type.    

CALCULATION

DECODE(NHRDIST_HIST_TYPE_IND)

 
PAYROLL_IDENTIFIER Pay identification number to which this Employee_Position belongs.    

NHRDIST

NHRDIST_PICT_CODE

 
PAYROLL_IDENTIFIER_DESC The description or title of the payroll code.    

PTRPICT

PTRPICT_DESC

 
PAYROLL_NUMBER The Pay Number is used to uniquely identify a pay period within a fiscal year.    

NHRDIST

NHRDIST_PAYNO

 
PERSON_UID System generated unique internal identification number assigned to this person.    

NHRDIST

NHRDIST_PIDM

 
POSITION Employee Position number.    

NHRDIST

NHRDIST_POSN

 
POSITION_EMPLOYEE_CLASS Employee Position Class    

NHRDIST

NHRDIST_ECLS_CODE

 
POSITION_EMPLOYEE_CLASS_DESC Employee position class description.    

PTRECLS

PTRECLS_LONG_DESC

 
POSITION_TITLE Description of the Employee_Position. Defaults from the position title if left blank.    

NBRJOBS

NBRJOBS_DESC

 
POSITION_TOTAL_IND Indicates if the earnings being processed updates the position total and expended amount.    

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.    

NHRDIST

NHRDIST_INTERFACED_IND

 
PROCESS_GROUP Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.    

NA

NA

 
PROGRAM Program code. Only filled if Finance System is present.    

NHRDIST

NHRDIST_PROG_CODE

 
PROGRAM_DESC Description of the program code.    

FTVPROG

FTVPROG_TITLE

 
PROGRAM_DESC_1 Hierarchy description or title appropriate for this Level.    

FUNCTION

FOKODSF.F_GET_PROG_HIER

 
PROGRAM_DESC_2 Hierarchy description or title appropriate for this Level.    

FUNCTION

FOKODSF.F_GET_PROG_HIER

 
PROGRAM_DESC_3 Hierarchy description or title appropriate for this Level.    

FUNCTION

FOKODSF.F_GET_PROG_HIER

 
PROGRAM_DESC_4 Hierarchy description or title appropriate for this Level.    

FUNCTION

FOKODSF.F_GET_PROG_HIER

 
PROGRAM_DESC_5 Hierarchy description or title appropriate for this Level.    

FUNCTION

FOKODSF.F_GET_PROG_HIER

 
PROGRAM_LEVEL_1 primary program within the program Hierarchy.    

FUNCTION

FOKODSF.F_GET_PROG_HIER

 
PROGRAM_LEVEL_2 Level 2 program within this program Hierarchy.    

FUNCTION

FOKODSF.F_GET_PROG_HIER

 
PROGRAM_LEVEL_3 Level 3 program within this program Hierarchy.    

FUNCTION

FOKODSF.F_GET_PROG_HIER

 
PROGRAM_LEVEL_4 Level 4 program within this program Hierarchy.    

FUNCTION

FOKODSF.F_GET_PROG_HIER

 
PROGRAM_LEVEL_5 Level 5 program within this program Hierarchy.    

FUNCTION

FOKODSF.F_GET_PROG_HIER

 
PROGRAM_STATUS Current Status of the associated program.    

FTVPROG

FTVPROG_STATUS_IND

 
PROGRAM_STATUS_1 Status of the primary program within the program Hierarchy.    

FUNCTION

FOKODSF.F_GET_PROG_HIER

 
PROGRAM_STATUS_2 Status of the Level 2 program within this program Hierarchy.    

FUNCTION

FOKODSF.F_GET_PROG_HIER

 
PROGRAM_STATUS_3 Status of the Level 3 program within this program Hierarchy.    

FUNCTION

FOKODSF.F_GET_PROG_HIER

 
PROGRAM_STATUS_4 Status of the Level 4 program within this program Hierarchy.    

FUNCTION

FOKODSF.F_GET_PROG_HIER

 
PROGRAM_STATUS_5 Status of the Level 5 program within this program Hierarchy.    

FUNCTION

FOKODSF.F_GET_PROG_HIER

 
PROJECT Work order code used for cost accounting.    

NHRDIST

NHRDIST_PROJ_CODE

 
PROJECT_DESC Description of the project.    

FUNCTION

FOKODSF.F_GET_FINANCE_DESC

 
RULE_CLASS The Finance System Rule Class code to be applied to this interface transaction.    

NHRDIST

NHRDIST_RUCL_CODE

 
RULE_CLASS_DESC Unique title assigned to a rule class.    

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

NHRDIST

NHRDIST_SOURCE

 
SOURCE_DESC Description of the source.    

FUNCTION

GOKODSF.F_GET_DESC

 
TAX_DEDUCTION Identifies the specific Benefit/deduction.    

PDRDEDN

PDRDEDN_BDCA_CODE

 
TAX_DEDUCTION_LONG_DESC Benefit/deduction long description.    

PTRBDCA

PTRBDCA_LONG_DESC

 
TAX_DEDUCTION_SHORT_DESC Benefit/deduction short description.    

PTRBDCA

PTRBDCA_SHORT_DESC

 
TIME_SHEET_CHART Timesheet chart of accounts.    

NBRJOBS

NBRJOBS_COAS_CODE_TS

 
TIME_SHEET_ORGANIZATION Organization to which the time sheet for this position is sent.    

NBRJOBS

NBRJOBS_ORGN_CODE_TS

 
TIME_SHEET_ORGANIZATION_DESC Organization to which this Employee_Position's time sheet is sent.    

FUNCTION

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

NHRDIST

NHRDIST_AMT

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

NHRDIST

NHRDIST_TRANS_DATE

 
TRANSACTION_NUMBER Unique transaction number generated by the payroll process.    

NHRDIST

NHRDIST_TNUM

 


Ver: 8.3