RETURN TO REPORTING VIEW REPORTS LIST
Human Resources Reporting View Reports

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

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

NHRDIST

NHRDIST_ACCT_CODE

ACCOUNT_DESC Description of the account code. VARCHAR2(255)

FTVACCT

FTVACCT_TITLE

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

FUNCTION

FOKODSF.F_CONCAT_ACCT_HIER

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

FUNCTION

FOKODSF.F_CONCAT_ACCT_HIER

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

FUNCTION

FOKODSF.F_CONCAT_ACCT_HIER

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

FUNCTION

FOKODSF.F_CONCAT_ACCT_HIER

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_CONCAT_ACCT_HIER

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_CONCAT_ACCT_HIER

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_CONCAT_ACCT_HIER

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_CONCAT_ACCT_HIER

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

FTVACCT

FTVACCT_STATUS_IND

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

FUNCTION

FOKODSF.F_CONCAT_ACCT_HIER

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

FUNCTION

FOKODSF.F_CONCAT_ACCT_HIER

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

FUNCTION

FOKODSF.F_CONCAT_ACCT_HIER

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

FUNCTION

FOKODSF.F_CONCAT_ACCT_HIER

ACCOUNT_TYPE_DESC_1 Hierarchy description or title appropriate for this Level. VARCHAR2(255)

FUNCTION

FOKODSF.F_CONCAT_ACCT_HIER

ACCOUNT_TYPE_DESC_2 Hierarchy description or title appropriate for this Level. VARCHAR2(255)

FUNCTION

FOKODSF.F_CONCAT_ACCT_HIER

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

FUNCTION

FOKODSF.F_CONCAT_ACCT_HIER

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

FUNCTION

FOKODSF.F_CONCAT_ACCT_HIER

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

FUNCTION

FOKODSF.F_CONCAT_ACCT_HIER

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

FUNCTION

FOKODSF.F_CONCAT_ACCT_HIER

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

NHRDIST

NHRDIST_ACTV_CODE

ACTIVITY_DESC Description of the activity code. VARCHAR2(255)

FTVACTV

FTVACTV_TITLE

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

FUNCTION

F_GET_FINANCE_STATUS

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

PTRBDCA

PTRBDCA_BDTY_CODE

BENEFIT_DEDUCTION_TYPE_DESC Benefit deduction type description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

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

NHRDIST

NHRDIST_OBUD_CODE

BUDGET_IDENTIFIER_DESC Description of the budget. VARCHAR2(255)

NHRDIST

NHRDIST_OBUD_CODE

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

NHRDIST

NHRDIST_OBPH_CODE

BUDGET_PHASE_DESC Budget phase description. VARCHAR2(255)

NHRDIST

NHRDIST_OBPH_CODE

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 Position status description. VARCHAR2(255)

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

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

NHRDIST

NHRDIST_YEAR

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

NHRDIST

NHRDIST_BDCA_CODE

CARRIER_LONG_DESC Benefit/deduction long description. VARCHAR2(255)

NHRDIST

NHRDIST_BDCA_CODE

CARRIER_SHORT_DESC Benefit/deduction short description. VARCHAR2(255)

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

NHRDIST

NHRDIST_CATEGORY_CODE

CATEGORY_DESC Need help identifying from form VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

NHRDIST

NHRDIST_COAS_CODE

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

FTVCOAS

FTVCOAS_TITLE

COST_TYPE Type of labor cost. VARCHAR2(63)

NHRDIST

NHRDIST_CTYP_CODE

COST_TYPE_DESC Cost type description. VARCHAR2(255)

NHRDIST

NHRDIST_CTYP_CODE

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

PDRDEDN

PDRDEDN_OPT_CODE1

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

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

NHRDIST

NHRDIST_DR_CR_IND

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

NHRDIST

NHRDIST_DOC_CODE

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

PTRCALN

PTRCALN_CHECK_DATE

EARNINGS Earnings Code. VARCHAR2(63)

NHRDIST

NHRDIST_EARN_CODE

EARNINGS_DESC Earnings code long description. VARCHAR2(255)

FUNCTION

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

NBRJOBS

NBRJOBS_EMPR_CODE

EMPLOYER_DESC Employer_Code description. VARCHAR2(255)

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

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

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

NHRDIST

NHRDIST_ENCD_SEQ_NUM

EVENT_SEQUENCE_NUMBER Pay Event Identifying Sequence Number. 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. VARCHAR2(63)

NHRDIST

NHRDIST_ACCT_CODE_EXTERNAL

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

NHRDIST

NHRDIST_FISC_CODE

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

NHRDIST

NHRDIST_FUND_CODE

FUND_DESC Description of the fund code. VARCHAR2(255)

FTVFUND

FTVFUND_TITLE

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

FUNCTION

FOKODSF.F_CONCAT_FUND_HIER

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

FUNCTION

FOKODSF.F_CONCAT_FUND_HIER

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

FUNCTION

FOKODSF.F_CONCAT_FUND_HIER

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

FUNCTION

FOKODSF.F_CONCAT_FUND_HIER

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

FUNCTION

FOKODSF.F_CONCAT_FUND_HIER

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

FUNCTION

FOKODSF.F_CONCAT_FUND_HIER

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

FUNCTION

FOKODSF.F_CONCAT_FUND_HIER

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

FUNCTION

FOKODSF.F_CONCAT_FUND_HIER

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

FUNCTION

FOKODSF.F_CONCAT_FUND_HIER

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

FUNCTION

FOKODSF.F_CONCAT_FUND_HIER

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

FTVFUND

FTVFUND_STATUS_IND

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

FUNCTION

FOKODSF.F_CONCAT_FUND_HIER

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

FUNCTION

FOKODSF.F_CONCAT_FUND_HIER

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

FUNCTION

FOKODSF.F_CONCAT_FUND_HIER

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

FUNCTION

FOKODSF.F_CONCAT_FUND_HIER

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

FUNCTION

FOKODSF.F_CONCAT_FUND_HIER

FUND_TYPE_DESC_1 Hierarchy description or title appropriate for this Level. VARCHAR2(255)

FUNCTION

FOKODSF.F_CONCAT_FUND_HIER

FUND_TYPE_DESC_2 Hierarchy description or title appropriate for this Level. VARCHAR2(255)

FUNCTION

FOKODSF.F_CONCAT_FUND_HIER

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

FUNCTION

FOKODSF.F_CONCAT_FUND_HIER

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

FUNCTION

FOKODSF.F_CONCAT_FUND_HIER

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

FUNCTION

FOKODSF.F_CONCAT_FUND_HIER

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

FUNCTION

FOKODSF.F_CONCAT_FUND_HIER

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

PEBEMPL

PEBEMPL_ORGN_CODE_HOME

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

PEBEMPL

PEBEMPL_COAS_CODE_HOME

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

FUNCTION

GOKODSF.F_GET_DESC

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 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 Number of Earnings Hours Associated With the Labor Distribution. NUMBER

NHRDIST

NHRDIST_HRS

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

NHRDIST

NHRDIST_LOCN_CODE

LOCATION_DESC Description of the location code. VARCHAR2(255)

FTVLOCN

FTVLOCN_TITLE

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

FUNCTION

FOKODSF.F_CONCAT_LOCN_HIER

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

FUNCTION

FOKODSF.F_CONCAT_LOCN_HIER

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

FUNCTION

FOKODSF.F_CONCAT_LOCN_HIER

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

FUNCTION

FOKODSF.F_CONCAT_LOCN_HIER

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

FUNCTION

FOKODSF.F_CONCAT_LOCN_HIER

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

FUNCTION

FOKODSF.F_CONCAT_LOCN_HIER

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

FUNCTION

FOKODSF.F_CONCAT_LOCN_HIER

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

FUNCTION

FOKODSF.F_CONCAT_LOCN_HIER

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

FUNCTION

FOKODSF.F_CONCAT_LOCN_HIER

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

FUNCTION

FOKODSF.F_CONCAT_LOCN_HIER

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

FTVLOCN

FTVLOCN_STATUS_IND

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

FUNCTION

FOKODSF.F_CONCAT_LOCN_HIER

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

FUNCTION

FOKODSF.F_CONCAT_LOCN_HIER

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

FUNCTION

FOKODSF.F_CONCAT_LOCN_HIER

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

FUNCTION

FOKODSF.F_CONCAT_LOCN_HIER

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

FUNCTION

FOKODSF.F_CONCAT_LOCN_HIER

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

NA

NA

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

NA

NA

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

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

CALCULATION

DECODE(NORMAL_BALANCE)

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

NHRDIST

NHRDIST_ORGN_CODE

ORGANIZATION_DESC Description of the organization code. VARCHAR2(255)

FTVORGN

FTVORGN_TITLE

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

FUNCTION

FOKODSF.F_CONCAT_ORGN_HIER

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

FUNCTION

FOKODSF.F_CONCAT_ORGN_HIER

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

FUNCTION

FOKODSF.F_CONCAT_ORGN_HIER

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

FUNCTION

FOKODSF.F_CONCAT_ORGN_HIER

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

FUNCTION

FOKODSF.F_CONCAT_ORGN_HIER

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

FUNCTION

FOKODSF.F_CONCAT_ORGN_HIER

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

FUNCTION

FOKODSF.F_CONCAT_ORGN_HIER

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

FUNCTION

FOKODSF.F_CONCAT_ORGN_HIER

ORGANIZATION_LEVEL_1 primary organization within the organization Hierarchy. VARCHAR2(63)

FUNCTION

FOKODSF.F_CONCAT_ORGN_HIER

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

FUNCTION

FOKODSF.F_CONCAT_ORGN_HIER

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

FUNCTION

FOKODSF.F_CONCAT_ORGN_HIER

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

FUNCTION

FOKODSF.F_CONCAT_ORGN_HIER

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

FUNCTION

FOKODSF.F_CONCAT_ORGN_HIER

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

FUNCTION

FOKODSF.F_CONCAT_ORGN_HIER

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

FUNCTION

FOKODSF.F_CONCAT_ORGN_HIER

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

FUNCTION

FOKODSF.F_CONCAT_ORGN_HIER

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

FUNCTION

F_GET_FINANCE_STATUS

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

FUNCTION

FOKODSF.F_CONCAT_ORGN_HIER

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

FUNCTION

FOKODSF.F_CONCAT_ORGN_HIER

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

FUNCTION

FOKODSF.F_CONCAT_ORGN_HIER

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

FUNCTION

FOKODSF.F_CONCAT_ORGN_HIER

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

FUNCTION

FOKODSF.F_CONCAT_ORGN_HIER

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

FUNCTION

FOKODSF.F_CONCAT_ORGN_HIER

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

FUNCTION

FOKODSF.F_CONCAT_ORGN_HIER

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

FUNCTION

FOKODSF.F_CONCAT_ORGN_HIER

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

NHRDIST

NHRDIST_HIST_TYPE_IND

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

CALCULATION

DECODE(NHRDIST_HIST_TYPE_IND)

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

NHRDIST

NHRDIST_PICT_CODE

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

FUNCTION

GOKODSF.F_GET_DESC

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

NHRDIST

NHRDIST_PAYNO

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

NHRDIST

NHRDIST_PIDM

POSITION Employee Position number. VARCHAR2(63)

NHRDIST

NHRDIST_POSN

POSITION_EMPLOYEE_CLASS Employee Position Class VARCHAR2(63)

NHRDIST

NHRDIST_ECLS_CODE

POSITION_EMPLOYEE_CLASS_DESC Employee position class description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

NBRJOBS

NBRJOBS_DESC

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

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

NHRDIST

NHRDIST_INTERFACED_IND

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

NA

NA

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

NHRDIST

NHRDIST_PROG_CODE

PROGRAM_DESC Description of the program code. VARCHAR2(255)

FTVPROG

FTVPROG_TITLE

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

FUNCTION

FOKODSF.F_CONCAT_PROG_HIER

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

FUNCTION

FOKODSF.F_CONCAT_PROG_HIER

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

FUNCTION

FOKODSF.F_CONCAT_PROG_HIER

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

FUNCTION

FOKODSF.F_CONCAT_PROG_HIER

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

FUNCTION

FOKODSF.F_CONCAT_PROG_HIER

PROGRAM_LEVEL_1 primary program within the program Hierarchy. VARCHAR2(63)

FUNCTION

FOKODSF.F_CONCAT_PROG_HIER

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

FUNCTION

FOKODSF.F_CONCAT_PROG_HIER

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

FUNCTION

FOKODSF.F_CONCAT_PROG_HIER

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

FUNCTION

FOKODSF.F_CONCAT_PROG_HIER

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

FUNCTION

FOKODSF.F_CONCAT_PROG_HIER

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

FTVPROG

FTVPROG_STATUS_IND

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

FUNCTION

FOKODSF.F_CONCAT_PROG_HIER

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

FUNCTION

FOKODSF.F_CONCAT_PROG_HIER

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

FUNCTION

FOKODSF.F_CONCAT_PROG_HIER

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

FUNCTION

FOKODSF.F_CONCAT_PROG_HIER

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

FUNCTION

FOKODSF.F_CONCAT_PROG_HIER

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

NHRDIST

NHRDIST_PROJ_CODE

PROJECT_DESC Description of the project. VARCHAR2(255)

NHRDIST

NHRDIST_PROJ_CODE

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

NHRDIST

NHRDIST_RUCL_CODE

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

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

NHRDIST

NHRDIST_SOURCE

SOURCE_DESC Description of the source. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

PDRDEDN

PDRDEDN_BDCA_CODE

TAX_DEDUCTION_LONG_DESC Benefit/deduction long description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

TAX_DEDUCTION_SHORT_DESC Benefit/deduction short description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

TIME_SHEET_CHART Timesheet chart of accounts. VARCHAR2(63)

NBRJOBS

NBRJOBS_COAS_CODE_TS

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 Organization to which this Employee_Position's time sheet is sent. VARCHAR2(255)

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

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

NHRDIST

NHRDIST_TNUM



Ver: 3.1