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
HOME_ORGANIZATION_CHART, HOME_ORGANIZATION, PERSON_UID
PERSON_UID, POSITION, JOB_SUFFIX
POSITION, JOB_SUFFIX
CHART_OF_ACCOUNTS, ACCOUNT
CHART_OF_ACCOUNTS, FUND
CHART_OF_ACCOUNTS, LOCATION
CHART_OF_ACCOUNTS, ORGANIZATION_CODE
CHART_OF_ACCOUNTS, PROGRAM
PERSON_UID, CARRIER
CARRIER
CALENDAR_YEAR, PAYROLL_IDENTIFIER, PAYROLL_NUMBER, EVENT_SEQUENCE_NUMBER, PERSON_UID
PERSON_UID, TAX_DEDUCTION
CATEGORY, TRANSACTION_DATE
TAX_DEDUCTION

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

NHRDIST

NHRDIST_ACCT_CODE

ACCOUNT_DESC Account Description Description of the account code. VARCHAR2(255)  

FTVACCT

FTVACCT_TITLE

ACCOUNT_DESC_1 Account Description 1 Hierarchy description or title appropriate for this Level. VARCHAR2(255)  

FUNCTION

FOKODSF.F_GET_ACCT_HIER

ACCOUNT_DESC_2 Account Description 2 Hierarchy description or title appropriate for this Level. VARCHAR2(255)  

FUNCTION

FOKODSF.F_GET_ACCT_HIER

ACCOUNT_DESC_3 Account Description 3 Hierarchy description or title appropriate for this Level. VARCHAR2(255)  

FUNCTION

FOKODSF.F_GET_ACCT_HIER

ACCOUNT_DESC_4 Account Description 4 Hierarchy description or title appropriate for this Level. VARCHAR2(255)  

FUNCTION

FOKODSF.F_GET_ACCT_HIER

ACCOUNT_LEVEL_1 Account Level 1 Defined value representing an account. Accounts are either Assets, Liability, Control, Fund Balance, Revenue, Labor, Expenditure or Transfer. VARCHAR2(63)  

FUNCTION

FOKODSF.F_GET_ACCT_HIER

ACCOUNT_LEVEL_2 Account Level 2 Defined value representing an account. Accounts are either Assets, Liability, Control, Fund Balance, Revenue, Labor, Expenditure or Transfer. VARCHAR2(63)  

FUNCTION

FOKODSF.F_GET_ACCT_HIER

ACCOUNT_LEVEL_3 Account Level 3 Defined value representing an account. Accounts are either Assets, Liability, Control, Fund Balance, Revenue, Labor, Expenditure or Transfer. VARCHAR2(63)  

FUNCTION

FOKODSF.F_GET_ACCT_HIER

ACCOUNT_LEVEL_4 Account Level 4 Defined value representing an account. Accounts are either Assets, Liability, Control, Fund Balance, Revenue, Labor, Expenditure or Transfer. VARCHAR2(63)  

FUNCTION

FOKODSF.F_GET_ACCT_HIER

ACCOUNT_STATUS Account Status Indicates Status of the associated account for this Level of the Hierarchy. VARCHAR2(63)  

FTVACCT

FTVACCT_STATUS_IND

ACCOUNT_STATUS_1 Account Status 1 Indicates Status of the associated account for this Level of the Hierarchy. VARCHAR2(63)  

FUNCTION

FOKODSF.F_GET_ACCT_HIER

ACCOUNT_STATUS_2 Account Status 2 Indicates Status of the associated account for this Level of the Hierarchy. VARCHAR2(63)  

FUNCTION

FOKODSF.F_GET_ACCT_HIER

ACCOUNT_STATUS_3 Account Status 3 Indicates Status of the associated account for this Level of the Hierarchy. VARCHAR2(63)  

FUNCTION

FOKODSF.F_GET_ACCT_HIER

ACCOUNT_STATUS_4 Account Status 4 Indicates Status of the associated account for this Level of the Hierarchy. VARCHAR2(63)  

FUNCTION

FOKODSF.F_GET_ACCT_HIER

ACCOUNT_TYPE_DESC_1 Account Type Description 1 Hierarchy description or title appropriate for this Level. VARCHAR2(255)  

FUNCTION

FOKODSF.F_GET_ACCT_HIER

ACCOUNT_TYPE_DESC_2 Account Type Description 2 Hierarchy description or title appropriate for this Level. VARCHAR2(255)  

FUNCTION

FOKODSF.F_GET_ACCT_HIER

ACCOUNT_TYPE_LEVEL_1 Account Type Level 1 Classifies an account type i.e., asset, revenue, etc. for reporting purposes. VARCHAR2(63)  

FUNCTION

FOKODSF.F_GET_ACCT_HIER

ACCOUNT_TYPE_LEVEL_2 Account Type Level 2 Classifies an account type i.e., asset, revenue, etc. for reporting purposes. VARCHAR2(63)  

FUNCTION

FOKODSF.F_GET_ACCT_HIER

ACCOUNT_TYPE_STATUS_1 Account Type Status 1 Status of the primary account type within this account Hierarchy. VARCHAR2(63)  

FUNCTION

FOKODSF.F_GET_ACCT_HIER

ACCOUNT_TYPE_STATUS_2 Account Type Status 2 Status of the secondary account type within this account Hierarchy. VARCHAR2(63)  

FUNCTION

FOKODSF.F_GET_ACCT_HIER

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

NHRDIST

NHRDIST_ACTV_CODE

ACTIVITY_DESC Activity Description Description of the activity code. VARCHAR2(255)  

FTVACTV

FTVACTV_TITLE

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

FUNCTION

F_GET_FINANCE_STATUS

ADMINISTRATIVE_GROUP Administrative Group Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)  

NA

NA

BENEFIT_DEDUCTION_TYPE Benefit Deduction Type Benefit deduction type. VARCHAR2(63)  

PTRBDCA

PTRBDCA_BDTY_CODE

BENEFIT_DEDUCTION_TYPE_DESC Benefit Deduction Type Description Benefit deduction type description. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

BUDGET_DOCUMENT Budget Document User or system generated document number. VARCHAR2(63)  

NHRDIST

NHRDIST_POSNBUD_DOC_CODE

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

NHRDIST

NHRDIST_OBUD_CODE

BUDGET_IDENTIFIER_DESC Budget Identifier Description Description of the budget. VARCHAR2(255)  

NHRDIST

NHRDIST_OBUD_CODE

BUDGET_PHASE_CODE Budget Phase Code System defined code for the budget phase. VARCHAR2(63)  

NHRDIST

NHRDIST_OBPH_CODE

BUDGET_PHASE_DESC Budget Phase Description Budget phase description. VARCHAR2(255)  

NHRDIST

NHRDIST_OBPH_CODE

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

NHRDIST

NHRDIST_PTOT_STATUS

BUDGET_STATUS_DESC Budget Status Description Position status description. VARCHAR2(255)  

CALCULATION

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

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

PTRBDCA

PTRBDCA_CALC_RULE

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

NHRDIST

NHRDIST_YEAR

CARRIER Carrier Identifies the specific Benefit/deduction. VARCHAR2(63)  

NHRDIST

NHRDIST_BDCA_CODE

CARRIER_LONG_DESC Carrier Long Description Benefit/deduction long description. VARCHAR2(255)  

PTRBDCA

PTRBDCA_LONG_DESC

CARRIER_SHORT_DESC Carrier Short Description Benefit/deduction short description. VARCHAR2(255)  

PTRBDCA

PTRBDCA_SHORT_DESC

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

NHRDIST

NHRDIST_CATEGORY_CODE

CATEGORY_DESC Category Description Need help identifying from form VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

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

NHRDIST

NHRDIST_COAS_CODE

CHART_OF_ACCOUNTS_DESC Chart Of Accounts Description Name of the chart of accounts. VARCHAR2(255)  

FTVCOAS

FTVCOAS_TITLE

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

NHRDIST

NHRDIST_CTYP_CODE

COST_TYPE_DESC Cost Type Description Cost type description. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

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

PDRDEDN

PDRDEDN_OPT_CODE1

COVERAGE_OPTION_DESC Coverage Option Description Description/title for the Plan Code. VARCHAR2(255)  

PDRDEDN

PDRDEDN_OPT_CODE1

DEBIT_CREDIT_IND Debit Credit Indicator 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(63)  

NHRDIST

NHRDIST_DR_CR_IND

DOCUMENT Document User or system generated document number. VARCHAR2(63)  

NHRDIST

NHRDIST_DOC_CODE

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

PTRCALN

PTRCALN_CHECK_DATE

EARNINGS Earnings Earnings Code. VARCHAR2(63)  

NHRDIST

NHRDIST_EARN_CODE

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

PTREARN

PTREARN_LONG_DESC

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

NBRJOBS

NBRJOBS_EMPR_CODE

EMPLOYER_DESC Employer Description Employer_Code description. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

ENCUMBRANCE_ITEM_NUMBER 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  

NHRDIST

NHRDIST_ENCD_ITEM_NUM

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

NHRDIST

NHRDIST_ENCD_NUM

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

NHRDIST

NHRDIST_ENCD_SEQ_NUM

EVENT_SEQUENCE_NUMBER Event Sequence Number Pay Event Identifying Sequence Number. NUMBER  

NHRDIST

NHRDIST_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(63)  

NHRDIST

NHRDIST_ACCT_CODE_EXTERNAL

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

NHRDIST

NHRDIST_FISC_CODE

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

NHRDIST

NHRDIST_FUND_CODE

FUND_DESC Fund Description Description of the fund code. VARCHAR2(255)  

FTVFUND

FTVFUND_TITLE

FUND_DESC_1 Fund Description 1 Hierarchy description or title appropriate for this Level. VARCHAR2(255)  

FUNCTION

FOKODSF.F_GET_FUND_HIER

FUND_DESC_2 Fund Description 2 Hierarchy description or title appropriate for this Level. VARCHAR2(255)  

FUNCTION

FOKODSF.F_GET_FUND_HIER

FUND_DESC_3 Fund Description 3 Hierarchy description or title appropriate for this Level. VARCHAR2(255)  

FUNCTION

FOKODSF.F_GET_FUND_HIER

FUND_DESC_4 Fund Description 4 Hierarchy description or title appropriate for this Level. VARCHAR2(255)  

FUNCTION

FOKODSF.F_GET_FUND_HIER

FUND_DESC_5 Fund Description 5 Hierarchy description or title appropriate for this Level. VARCHAR2(255)  

FUNCTION

FOKODSF.F_GET_FUND_HIER

FUND_LEVEL_1 Fund Level 1 Primary Fund within the fund Hierarchy. VARCHAR2(63)  

FUNCTION

FOKODSF.F_GET_FUND_HIER

FUND_LEVEL_2 Fund Level 2 Level 2 fund within this Fund Hierarchy. VARCHAR2(63)  

FUNCTION

FOKODSF.F_GET_FUND_HIER

FUND_LEVEL_3 Fund Level 3 Level 3 fund within this Fund Hierarchy. VARCHAR2(63)  

FUNCTION

FOKODSF.F_GET_FUND_HIER

FUND_LEVEL_4 Fund Level 4 Level 4 fund within this Fund Hierarchy. VARCHAR2(63)  

FUNCTION

FOKODSF.F_GET_FUND_HIER

FUND_LEVEL_5 Fund Level 5 Level 5 fund within this Fund Hierarchy. VARCHAR2(63)  

FUNCTION

FOKODSF.F_GET_FUND_HIER

FUND_STATUS Fund Status Current Status of the associated Fund . VARCHAR2(63)  

FTVFUND

FTVFUND_STATUS_IND

FUND_STATUS_1 Fund Status 1 Status of the Primary Fund within the fund Hierarchy. VARCHAR2(63)  

FUNCTION

FOKODSF.F_GET_FUND_HIER

FUND_STATUS_2 Fund Status 2 Status of the Level 2 fund within this Fund Hierarchy. VARCHAR2(63)  

FUNCTION

FOKODSF.F_GET_FUND_HIER

FUND_STATUS_3 Fund Status 3 Status of the Level 3 fund within this Fund Hierarchy. VARCHAR2(63)  

FUNCTION

FOKODSF.F_GET_FUND_HIER

FUND_STATUS_4 Fund Status 4 Status of the Level 4 fund within this Fund Hierarchy. VARCHAR2(63)  

FUNCTION

FOKODSF.F_GET_FUND_HIER

FUND_STATUS_5 Fund Status 5 Status of the Level 5 fund within this Fund Hierarchy. VARCHAR2(63)  

FUNCTION

FOKODSF.F_GET_FUND_HIER

FUND_TYPE_DESC_1 Fund Type Description 1 Hierarchy description or title appropriate for this Level. VARCHAR2(255)  

FUNCTION

FOKODSF.F_GET_FUND_HIER

FUND_TYPE_DESC_2 Fund Type Description 2 Hierarchy description or title appropriate for this Level. VARCHAR2(255)  

FUNCTION

FOKODSF.F_GET_FUND_HIER

FUND_TYPE_LEVEL_1 Fund Type Level 1 Primary Fund type within this Fund Hierarchy. VARCHAR2(63)  

FUNCTION

FOKODSF.F_GET_FUND_HIER

FUND_TYPE_LEVEL_2 Fund Type Level 2 Level 2 fund type within this Fund Hierarchy. VARCHAR2(63)  

FUNCTION

FOKODSF.F_GET_FUND_HIER

FUND_TYPE_STATUS_1 Fund Type Status 1 Status of the Primary Fund type within this Fund Hierarchy. VARCHAR2(63)  

FUNCTION

FOKODSF.F_GET_FUND_HIER

FUND_TYPE_STATUS_2 Fund Type Status 2 Status of the Level 2 fund type within this Fund Hierarchy. VARCHAR2(63)  

FUNCTION

FOKODSF.F_GET_FUND_HIER

HOME_ORGANIZATION Home Organization Home organization code of the employee. VARCHAR2(63)  

PEBEMPL

PEBEMPL_ORGN_CODE_HOME

HOME_ORGANIZATION_CHART Home Organization Chart Home chart of accounts code for the employee. VARCHAR2(63)  

PEBEMPL

PEBEMPL_COAS_CODE_HOME

HOME_ORGANIZATION_DESC Home Organization Description The organization to which this Employee_Position's time sheet will be sent. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

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

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

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

NHRDIST

NHRDIST_SUFF

LABOR_DISTRIBUTION_HOURS Labor Distribution Hours Number of Earnings Hours Associated With the Labor Distribution. NUMBER  

NHRDIST

NHRDIST_HRS

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

NHRDIST

NHRDIST_LOCN_CODE

LOCATION_DESC Location Description Description of the location code. VARCHAR2(255)  

FTVLOCN

FTVLOCN_TITLE

LOCATION_DESC_1 Location Description 1 Hierarchy description or title appropriate for this Level. VARCHAR2(255)  

FUNCTION

FOKODSF.F_GET_LOCN_HIER

LOCATION_DESC_2 Location Description 2 Hierarchy description or title appropriate for this Level. VARCHAR2(255)  

FUNCTION

FOKODSF.F_GET_LOCN_HIER

LOCATION_DESC_3 Location Description 3 Hierarchy description or title appropriate for this Level. VARCHAR2(255)  

FUNCTION

FOKODSF.F_GET_LOCN_HIER

LOCATION_DESC_4 Location Description 4 Hierarchy description or title appropriate for this Level. VARCHAR2(255)  

FUNCTION

FOKODSF.F_GET_LOCN_HIER

LOCATION_DESC_5 Location Description 5 Hierarchy description or title appropriate for this Level. VARCHAR2(255)  

FUNCTION

FOKODSF.F_GET_LOCN_HIER

LOCATION_LEVEL_1 Location Level 1 Level 1 location within this location Hierarchy. VARCHAR2(63)  

FUNCTION

FOKODSF.F_GET_LOCN_HIER

LOCATION_LEVEL_2 Location Level 2 Level 2 location within this location Hierarchy. VARCHAR2(63)  

FUNCTION

FOKODSF.F_GET_LOCN_HIER

LOCATION_LEVEL_3 Location Level 3 Level 3 location within this location Hierarchy. VARCHAR2(63)  

FUNCTION

FOKODSF.F_GET_LOCN_HIER

LOCATION_LEVEL_4 Location Level 4 Level 4 location within this location Hierarchy. VARCHAR2(63)  

FUNCTION

FOKODSF.F_GET_LOCN_HIER

LOCATION_LEVEL_5 Location Level 5 Level 5 location within this location Hierarchy. VARCHAR2(63)  

FUNCTION

FOKODSF.F_GET_LOCN_HIER

LOCATION_STATUS Location Status Current Status of the associated location. VARCHAR2(63)  

FTVLOCN

FTVLOCN_STATUS_IND

LOCATION_STATUS_1 Location Status 1 Status of the Level 1 location within this program Hierarchy. VARCHAR2(63)  

FUNCTION

FOKODSF.F_GET_LOCN_HIER

LOCATION_STATUS_2 Location Status 2 Status of the Level 2 location within this location Hierarchy. VARCHAR2(63)  

FUNCTION

FOKODSF.F_GET_LOCN_HIER

LOCATION_STATUS_3 Location Status 3 Status of the Level 3 location within this location Hierarchy. VARCHAR2(63)  

FUNCTION

FOKODSF.F_GET_LOCN_HIER

LOCATION_STATUS_4 Location Status 4 Status of the Level 4 location within this location Hierarchy. VARCHAR2(63)  

FUNCTION

FOKODSF.F_GET_LOCN_HIER

LOCATION_STATUS_5 Location Status 5 Status of the Level 5 location within this location Hierarchy. VARCHAR2(63)  

FUNCTION

FOKODSF.F_GET_LOCN_HIER

MULTI_SOURCE Multi Source Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(63)  

NA

NA

MULTI_SOURCE_DESC Multi Source Description Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(255)  

NA

NA

NAME Name Combination of the person's first, middle initial, and last name into one value. VARCHAR2(255)  

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

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

CALCULATION

DECODE(NORMAL_BALANCE)

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

NHRDIST

NHRDIST_ORGN_CODE

ORGANIZATION_DESC Organization Description Description of the organization code. VARCHAR2(255)  

FTVORGN

FTVORGN_TITLE

ORGANIZATION_DESC_1 Organization Description 1 Hierarchy description or title appropriate for this Level. VARCHAR2(255)  

FUNCTION

FOKODSF.F_GET_ORGN_HIER

ORGANIZATION_DESC_2 Organization Description 2 Hierarchy description or title appropriate for this Level. VARCHAR2(255)  

FUNCTION

FOKODSF.F_GET_ORGN_HIER

ORGANIZATION_DESC_3 Organization Description 3 Hierarchy description or title appropriate for this Level. VARCHAR2(255)  

FUNCTION

FOKODSF.F_GET_ORGN_HIER

ORGANIZATION_DESC_4 Organization Description 4 Hierarchy description or title appropriate for this Level. VARCHAR2(255)  

FUNCTION

FOKODSF.F_GET_ORGN_HIER

ORGANIZATION_DESC_5 Organization Description 5 Hierarchy description or title appropriate for this Level. VARCHAR2(255)  

FUNCTION

FOKODSF.F_GET_ORGN_HIER

ORGANIZATION_DESC_6 Organization Description 6 Hierarchy description or title appropriate for this Level. VARCHAR2(255)  

FUNCTION

FOKODSF.F_GET_ORGN_HIER

ORGANIZATION_DESC_7 Organization Description 7 Hierarchy description or title appropriate for this Level. VARCHAR2(255)  

FUNCTION

FOKODSF.F_GET_ORGN_HIER

ORGANIZATION_DESC_8 Organization Description 8 Hierarchy description or title appropriate for this Level. VARCHAR2(255)  

FUNCTION

FOKODSF.F_GET_ORGN_HIER

ORGANIZATION_LEVEL_1 Organization Level 1 primary organization within the organization Hierarchy. VARCHAR2(63)  

FUNCTION

FOKODSF.F_GET_ORGN_HIER

ORGANIZATION_LEVEL_2 Organization Level 2 Level 2 organization within this organization Hierarchy. VARCHAR2(63)  

FUNCTION

FOKODSF.F_GET_ORGN_HIER

ORGANIZATION_LEVEL_3 Organization Level 3 Level 3 organization within this organization Hierarchy. VARCHAR2(63)  

FUNCTION

FOKODSF.F_GET_ORGN_HIER

ORGANIZATION_LEVEL_4 Organization Level 4 Level 4 organization within this organization Hierarchy. VARCHAR2(63)  

FUNCTION

FOKODSF.F_GET_ORGN_HIER

ORGANIZATION_LEVEL_5 Organization Level 5 Level 5 organization within this organization Hierarchy. VARCHAR2(63)  

FUNCTION

FOKODSF.F_GET_ORGN_HIER

ORGANIZATION_LEVEL_6 Organization Level 6 Level 6 organization within this organization Hierarchy. VARCHAR2(63)  

FUNCTION

FOKODSF.F_GET_ORGN_HIER

ORGANIZATION_LEVEL_7 Organization Level 7 Level 7 organization within this organization Hierarchy. VARCHAR2(63)  

FUNCTION

FOKODSF.F_GET_ORGN_HIER

ORGANIZATION_LEVEL_8 Organization Level 8 Level 8 organization within this organization Hierarchy. VARCHAR2(63)  

FUNCTION

FOKODSF.F_GET_ORGN_HIER

ORGANIZATION_STATUS Organization Status Current Status of the associated organization. VARCHAR2(63)  

FUNCTION

F_GET_FINANCE_STATUS

ORGANIZATION_STATUS_1 Organization Status 1 Status of the primary organization within the organization Hierarchy. VARCHAR2(63)  

FUNCTION

FOKODSF.F_GET_ORGN_HIER

ORGANIZATION_STATUS_2 Organization Status 2 Status of the Level 2 organization within this organization Hierarchy. VARCHAR2(63)  

FUNCTION

FOKODSF.F_GET_ORGN_HIER

ORGANIZATION_STATUS_3 Organization Status 3 Status of the Level 3 organization within this organization Hierarchy. VARCHAR2(63)  

FUNCTION

FOKODSF.F_GET_ORGN_HIER

ORGANIZATION_STATUS_4 Organization Status 4 Status of the Level 4 organization within this organization Hierarchy. VARCHAR2(63)  

FUNCTION

FOKODSF.F_GET_ORGN_HIER

ORGANIZATION_STATUS_5 Organization Status 5 Status of the Level 5 organization within this organization Hierarchy. VARCHAR2(63)  

FUNCTION

FOKODSF.F_GET_ORGN_HIER

ORGANIZATION_STATUS_6 Organization Status 6 Status of the Level 6 organization within this organization Hierarchy. VARCHAR2(63)  

FUNCTION

FOKODSF.F_GET_ORGN_HIER

ORGANIZATION_STATUS_7 Organization Status 7 Status of the Level 7 organization within this organization Hierarchy. VARCHAR2(63)  

FUNCTION

FOKODSF.F_GET_ORGN_HIER

ORGANIZATION_STATUS_8 Organization Status 8 Status of the Level 8 organization within this organization Hierarchy. VARCHAR2(63)  

FUNCTION

FOKODSF.F_GET_ORGN_HIER

PAYROLL_EVENT_TYPE Payroll Event Type Indicates the type of pay event (Manual, Void, Redistribution, etc.). VARCHAR2(63)  

NHRDIST

NHRDIST_HIST_TYPE_IND

PAYROLL_EVENT_TYPE_DESC Payroll Event Type Description Description of the pay event type. VARCHAR2(255)  

CALCULATION

DECODE(NHRDIST_HIST_TYPE_IND)

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

NHRDIST

NHRDIST_PICT_CODE

PAYROLL_IDENTIFIER_DESC Payroll Identifier Description The description or title of the payroll code. VARCHAR2(255)  

PTRPICT

PTRPICT_DESC

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

NHRDIST

NHRDIST_PAYNO

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

NHRDIST

NHRDIST_PIDM

POSITION Position Employee Position number. VARCHAR2(63)  

NHRDIST

NHRDIST_POSN

POSITION_EMPLOYEE_CLASS Position Employee Class Employee Position Class VARCHAR2(63)  

NHRDIST

NHRDIST_ECLS_CODE

POSITION_EMPLOYEE_CLASS_DESC Position Employee Class Description Employee position class description. VARCHAR2(255)  

PTRECLS

PTRECLS_LONG_DESC

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

NBRJOBS

NBRJOBS_DESC

POSITION_TOTAL_IND Position Total Indicator Indicates if the earnings being processed updates the position total and expended amount. VARCHAR2(63)  

NHRDIST

NHRDIST_EARN_EXPENDS_PTOT_IND

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

NHRDIST

NHRDIST_INTERFACED_IND

PROCESS_GROUP Process Group Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)  

NA

NA

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

NHRDIST

NHRDIST_PROG_CODE

PROGRAM_DESC Program Description Description of the program code. VARCHAR2(255)  

FTVPROG

FTVPROG_TITLE

PROGRAM_DESC_1 Program Description 1 Hierarchy description or title appropriate for this Level. VARCHAR2(255)  

FUNCTION

FOKODSF.F_GET_PROG_HIER

PROGRAM_DESC_2 Program Description 2 Hierarchy description or title appropriate for this Level. VARCHAR2(255)  

FUNCTION

FOKODSF.F_GET_PROG_HIER

PROGRAM_DESC_3 Program Description 3 Hierarchy description or title appropriate for this Level. VARCHAR2(255)  

FUNCTION

FOKODSF.F_GET_PROG_HIER

PROGRAM_DESC_4 Program Description 4 Hierarchy description or title appropriate for this Level. VARCHAR2(255)  

FUNCTION

FOKODSF.F_GET_PROG_HIER

PROGRAM_DESC_5 Program Description 5 Hierarchy description or title appropriate for this Level. VARCHAR2(255)  

FUNCTION

FOKODSF.F_GET_PROG_HIER

PROGRAM_LEVEL_1 Program Level 1 primary program within the program Hierarchy. VARCHAR2(63)  

FUNCTION

FOKODSF.F_GET_PROG_HIER

PROGRAM_LEVEL_2 Program Level 2 Level 2 program within this program Hierarchy. VARCHAR2(63)  

FUNCTION

FOKODSF.F_GET_PROG_HIER

PROGRAM_LEVEL_3 Program Level 3 Level 3 program within this program Hierarchy. VARCHAR2(63)  

FUNCTION

FOKODSF.F_GET_PROG_HIER

PROGRAM_LEVEL_4 Program Level 4 Level 4 program within this program Hierarchy. VARCHAR2(63)  

FUNCTION

FOKODSF.F_GET_PROG_HIER

PROGRAM_LEVEL_5 Program Level 5 Level 5 program within this program Hierarchy. VARCHAR2(63)  

FUNCTION

FOKODSF.F_GET_PROG_HIER

PROGRAM_STATUS Program Status Current Status of the associated program. VARCHAR2(63)  

FTVPROG

FTVPROG_STATUS_IND

PROGRAM_STATUS_1 Program Status 1 Status of the primary program within the program Hierarchy. VARCHAR2(63)  

FUNCTION

FOKODSF.F_GET_PROG_HIER

PROGRAM_STATUS_2 Program Status 2 Status of the Level 2 program within this program Hierarchy. VARCHAR2(63)  

FUNCTION

FOKODSF.F_GET_PROG_HIER

PROGRAM_STATUS_3 Program Status 3 Status of the Level 3 program within this program Hierarchy. VARCHAR2(63)  

FUNCTION

FOKODSF.F_GET_PROG_HIER

PROGRAM_STATUS_4 Program Status 4 Status of the Level 4 program within this program Hierarchy. VARCHAR2(63)  

FUNCTION

FOKODSF.F_GET_PROG_HIER

PROGRAM_STATUS_5 Program Status 5 Status of the Level 5 program within this program Hierarchy. VARCHAR2(63)  

FUNCTION

FOKODSF.F_GET_PROG_HIER

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

NHRDIST

NHRDIST_PROJ_CODE

PROJECT_DESC Project Description Description of the project. VARCHAR2(255)  

FUNCTION

FOKODSF.F_GET_FINANCE_DESC

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

NHRDIST

NHRDIST_RUCL_CODE

RULE_CLASS_DESC Rule Class Description Unique title assigned to a rule class. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

SOURCE 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(63)  

NHRDIST

NHRDIST_SOURCE

SOURCE_DESC Source Description Description of the source. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

TAX_DEDUCTION Tax Deduction Identifies the specific Benefit/deduction. VARCHAR2(63)  

PDRDEDN

PDRDEDN_BDCA_CODE

TAX_DEDUCTION_LONG_DESC Tax Deduction Long Description Benefit/deduction long description. VARCHAR2(255)  

PTRBDCA

PTRBDCA_LONG_DESC

TAX_DEDUCTION_SHORT_DESC Tax Deduction Short Description Benefit/deduction short description. VARCHAR2(255)  

PTRBDCA

PTRBDCA_SHORT_DESC

TIME_SHEET_CHART Time Sheet Chart Timesheet chart of accounts. VARCHAR2(63)  

NBRJOBS

NBRJOBS_COAS_CODE_TS

TIME_SHEET_ORGANIZATION Time Sheet Organization Organization to which the time sheet for this position is sent. VARCHAR2(63)  

NBRJOBS

NBRJOBS_ORGN_CODE_TS

TIME_SHEET_ORGANIZATION_DESC Time Sheet Organization Description Organization to which this Employee_Position's time sheet is sent. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

TRANSACTION_AMOUNT 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  

NHRDIST

NHRDIST_AMT

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

NHRDIST

NHRDIST_TRANS_DATE

TRANSACTION_NUMBER Transaction Number Unique transaction number generated by the payroll process. NUMBER  

NHRDIST

NHRDIST_TNUM



Ver: 9.0