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