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
|