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

Banner Operational Data Store
Reporting View Target: PAYROLL_DISTRIBUTION

Description Contains organization payroll distribution information specific to each payroll.
Key & Frequency Multiple rows 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

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

NHRDIST

NHRDIST_ACCT_CODE

NO

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

FTVACCT

FTVACCT_TITLE

NO

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

FUNCTION

FOKODSF.F_GET_ACCT_HIER

NO

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

FUNCTION

FOKODSF.F_GET_ACCT_HIER

NO

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

FUNCTION

FOKODSF.F_GET_ACCT_HIER

NO

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

FUNCTION

FOKODSF.F_GET_ACCT_HIER

NO

NO
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

NO

NO
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

NO

NO
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

NO

NO
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

NO

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

FTVACCT

FTVACCT_STATUS_IND

NO

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

FUNCTION

FOKODSF.F_GET_ACCT_HIER

NO

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

FUNCTION

FOKODSF.F_GET_ACCT_HIER

NO

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

FUNCTION

FOKODSF.F_GET_ACCT_HIER

NO

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

FUNCTION

FOKODSF.F_GET_ACCT_HIER

NO

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

FUNCTION

FOKODSF.F_GET_ACCT_HIER

NO

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

FUNCTION

FOKODSF.F_GET_ACCT_HIER

NO

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

FUNCTION

FOKODSF.F_GET_ACCT_HIER

NO

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

FUNCTION

FOKODSF.F_GET_ACCT_HIER

NO

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

FUNCTION

FOKODSF.F_GET_ACCT_HIER

NO

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

FUNCTION

FOKODSF.F_GET_ACCT_HIER

NO

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

NHRDIST

NHRDIST_ACTV_CODE

NO

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

FTVACTV

FTVACTV_TITLE

NO

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

FUNCTION

F_GET_FINANCE_STATUS

NO

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

NA

NA

NO

NO
BENEFIT_DEDUCTION_TYPE Benefit deduction type. VARCHAR2(63)

PTRBDCA

PTRBDCA_BDTY_CODE

NO

NO
BENEFIT_DEDUCTION_TYPE_DESC Benefit deduction type description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

NO

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

NHRDIST

NHRDIST_POSNBUD_DOC_CODE

NO

NO
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

NO

NO
BUDGET_IDENTIFIER_DESC Description of the budget. VARCHAR2(255)

NHRDIST

NHRDIST_OBUD_CODE

NO

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

NHRDIST

NHRDIST_OBPH_CODE

NO

NO
BUDGET_PHASE_DESC Budget phase description. VARCHAR2(255)

NHRDIST

NHRDIST_OBPH_CODE

NO

NO
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

NO

NO
BUDGET_STATUS_DESC Position status description. VARCHAR2(255)

CALCULATION

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

NO

NO
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

NO

NO
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

NO

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

NHRDIST

NHRDIST_BDCA_CODE

NO

NO
CARRIER_LONG_DESC Benefit/deduction long description. VARCHAR2(255)

PTRBDCA

PTRBDCA_LONG_DESC

NO

NO
CARRIER_SHORT_DESC Benefit/deduction short description. VARCHAR2(255)

PTRBDCA

PTRBDCA_SHORT_DESC

NO

NO
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

NO

NO
CATEGORY_DESC Need help identifying from form. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

NO

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

NHRDIST

NHRDIST_COAS_CODE

NO

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

FTVCOAS

FTVCOAS_TITLE

NO

NO
COST_TYPE Type of labor cost. VARCHAR2(63)

NHRDIST

NHRDIST_CTYP_CODE

NO

NO
COST_TYPE_DESC Cost type description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

NO

NO
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

NO

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

PDRDEDN

PDRDEDN_OPT_CODE1

NO

NO
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

NO

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

NHRDIST

NHRDIST_DOC_CODE

NO

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

PTRCALN

PTRCALN_CHECK_DATE

NO

NO
EARNINGS Earnings Code. VARCHAR2(63)

NHRDIST

NHRDIST_EARN_CODE

NO

NO
EARNINGS_DESC Earnings code long description. VARCHAR2(255)

PTREARN

PTREARN_LONG_DESC

NO

NO
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

NO

NO
EMPLOYER_DESC Employer_Code description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

NO

NO
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

NO

NO
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

NO

NO
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

NO

NO
EVENT_SEQUENCE_NUMBER Pay Event Identifying Sequence Number. NUMBER

NHRDIST

NHRDIST_SEQ_NO

NO

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

NO

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

NHRDIST

NHRDIST_FISC_CODE

NO

NO
FUND Financial Aid Fund code to be associated with information in this record. VARCHAR2(63)

NHRDIST

NHRDIST_FUND_CODE

NO

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

FTVFUND

FTVFUND_TITLE

NO

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

FUNCTION

FOKODSF.F_GET_FUND_HIER

NO

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

FUNCTION

FOKODSF.F_GET_FUND_HIER

NO

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

FUNCTION

FOKODSF.F_GET_FUND_HIER

NO

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

FUNCTION

FOKODSF.F_GET_FUND_HIER

NO

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

FUNCTION

FOKODSF.F_GET_FUND_HIER

NO

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

FUNCTION

FOKODSF.F_GET_FUND_HIER

NO

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

FUNCTION

FOKODSF.F_GET_FUND_HIER

NO

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

FUNCTION

FOKODSF.F_GET_FUND_HIER

NO

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

FUNCTION

FOKODSF.F_GET_FUND_HIER

NO

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

FUNCTION

FOKODSF.F_GET_FUND_HIER

NO

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

FTVFUND

FTVFUND_STATUS_IND

NO

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

FUNCTION

FOKODSF.F_GET_FUND_HIER

NO

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

FUNCTION

FOKODSF.F_GET_FUND_HIER

NO

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

FUNCTION

FOKODSF.F_GET_FUND_HIER

NO

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

FUNCTION

FOKODSF.F_GET_FUND_HIER

NO

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

FUNCTION

FOKODSF.F_GET_FUND_HIER

NO

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

FUNCTION

FOKODSF.F_GET_FUND_HIER

NO

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

FUNCTION

FOKODSF.F_GET_FUND_HIER

NO

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

FUNCTION

FOKODSF.F_GET_FUND_HIER

NO

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

FUNCTION

FOKODSF.F_GET_FUND_HIER

NO

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

FUNCTION

FOKODSF.F_GET_FUND_HIER

NO

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

FUNCTION

FOKODSF.F_GET_FUND_HIER

NO

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

PEBEMPL

PEBEMPL_ORGN_CODE_HOME

NO

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

PEBEMPL

PEBEMPL_COAS_CODE_HOME

NO

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

FUNCTION

GOKODSF.F_GET_DESC

NO

NO
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

NO

NO
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

NO

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

NHRDIST

NHRDIST_HRS

NO

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

NHRDIST

NHRDIST_LOCN_CODE

NO

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

FTVLOCN

FTVLOCN_TITLE

NO

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

FUNCTION

FOKODSF.F_GET_LOCN_HIER

NO

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

FUNCTION

FOKODSF.F_GET_LOCN_HIER

NO

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

FUNCTION

FOKODSF.F_GET_LOCN_HIER

NO

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

FUNCTION

FOKODSF.F_GET_LOCN_HIER

NO

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

FUNCTION

FOKODSF.F_GET_LOCN_HIER

NO

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

FUNCTION

FOKODSF.F_GET_LOCN_HIER

NO

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

FUNCTION

FOKODSF.F_GET_LOCN_HIER

NO

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

FUNCTION

FOKODSF.F_GET_LOCN_HIER

NO

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

FUNCTION

FOKODSF.F_GET_LOCN_HIER

NO

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

FUNCTION

FOKODSF.F_GET_LOCN_HIER

NO

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

FTVLOCN

FTVLOCN_STATUS_IND

NO

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

FUNCTION

FOKODSF.F_GET_LOCN_HIER

NO

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

FUNCTION

FOKODSF.F_GET_LOCN_HIER

NO

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

FUNCTION

FOKODSF.F_GET_LOCN_HIER

NO

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

FUNCTION

FOKODSF.F_GET_LOCN_HIER

NO

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

FUNCTION

FOKODSF.F_GET_LOCN_HIER

NO

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

NA

NA

NO

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

NA

NA

NO

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

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

NO

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

NO

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

NHRDIST

NHRDIST_ORGN_CODE

NO

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

FTVORGN

FTVORGN_TITLE

NO

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

NO

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

NO

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

NO

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

NO

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

NO

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

NO

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

NO

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

NO

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

NO

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

NO

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

NO

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

NO

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

NO

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

NO

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

NO

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

NO

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

FUNCTION

F_GET_FINANCE_STATUS

NO

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

NO

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

NO

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

NO

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

NO

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

NO

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

NO

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

NO

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

NO

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

NHRDIST

NHRDIST_HIST_TYPE_IND

NO

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

CALCULATION

DECODE(NHRDIST_HIST_TYPE_IND)

NO

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

NHRDIST

NHRDIST_PICT_CODE

NO

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

PTRPICT

PTRPICT_DESC

NO

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

NHRDIST

NHRDIST_PAYNO

NO

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

NHRDIST

NHRDIST_PIDM

NO

NO
POSITION Employee Position number. VARCHAR2(63)

NHRDIST

NHRDIST_POSN

NO

NO
POSITION_EMPLOYEE_CLASS Employee Position Class. VARCHAR2(63)

NHRDIST

NHRDIST_ECLS_CODE

NO

NO
POSITION_EMPLOYEE_CLASS_DESC Employee position class description. VARCHAR2(255)

PTRECLS

PTRECLS_LONG_DESC

NO

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

NBRJOBS

NBRJOBS_DESC

NO

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

NHRDIST

NHRDIST_EARN_EXPENDS_PTOT_IND

NO

NO
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

NO

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

NA

NA

NO

NO
PROGRAM Student's program, curriculum or course of study. This may be Data Not Available when program codes have not been defined by the institution. The alternate curriculum identification is by a combination of college, degree and major codes. VARCHAR2(63)

NHRDIST

NHRDIST_PROG_CODE

NO

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

FTVPROG

FTVPROG_TITLE

NO

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

FUNCTION

FOKODSF.F_GET_PROG_HIER

NO

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

FUNCTION

FOKODSF.F_GET_PROG_HIER

NO

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

FUNCTION

FOKODSF.F_GET_PROG_HIER

NO

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

FUNCTION

FOKODSF.F_GET_PROG_HIER

NO

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

FUNCTION

FOKODSF.F_GET_PROG_HIER

NO

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

FUNCTION

FOKODSF.F_GET_PROG_HIER

NO

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

FUNCTION

FOKODSF.F_GET_PROG_HIER

NO

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

FUNCTION

FOKODSF.F_GET_PROG_HIER

NO

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

FUNCTION

FOKODSF.F_GET_PROG_HIER

NO

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

FUNCTION

FOKODSF.F_GET_PROG_HIER

NO

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

FTVPROG

FTVPROG_STATUS_IND

NO

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

FUNCTION

FOKODSF.F_GET_PROG_HIER

NO

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

FUNCTION

FOKODSF.F_GET_PROG_HIER

NO

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

FUNCTION

FOKODSF.F_GET_PROG_HIER

NO

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

FUNCTION

FOKODSF.F_GET_PROG_HIER

NO

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

FUNCTION

FOKODSF.F_GET_PROG_HIER

NO

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

NHRDIST

NHRDIST_PROJ_CODE

NO

NO
PROJECT_DESC Description of the project. VARCHAR2(255)

FUNCTION

FOKODSF.F_GET_FINANCE_DESC

NO

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

NHRDIST

NHRDIST_RUCL_CODE

NO

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

FUNCTION

GOKODSF.F_GET_DESC

NO

NO
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

NO

NO
SOURCE_DESC Description of the source. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

NO

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

PDRDEDN

PDRDEDN_BDCA_CODE

NO

NO
TAX_DEDUCTION_LONG_DESC Benefit/deduction long description. VARCHAR2(255)

PTRBDCA

PTRBDCA_LONG_DESC

NO

NO
TAX_DEDUCTION_SHORT_DESC Benefit/deduction short description. VARCHAR2(255)

PTRBDCA

PTRBDCA_SHORT_DESC

NO

NO
TIME_SHEET_CHART Timesheet chart of accounts. VARCHAR2(63)

NBRJOBS

NBRJOBS_COAS_CODE_TS

NO

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

NBRJOBS

NBRJOBS_ORGN_CODE_TS

NO

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

FUNCTION

GOKODSF.F_GET_DESC

NO

NO
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

NO

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

NHRDIST

NHRDIST_TRANS_DATE

NO

NO
TRANSACTION_NUMBER Unique transaction number generated by the payroll process. NUMBER

NHRDIST

NHRDIST_TNUM

NO

NO


Ver: 9.2