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_GET_ACCT_HIER
ACCOUNT_DESC_2	Hierarchy description or title appropriate for this Level.	VARCHAR2(255)	FUNCTION	FOKODSF.F_GET_ACCT_HIER
ACCOUNT_DESC_3	Hierarchy description or title appropriate for this Level.	VARCHAR2(255)	FUNCTION	FOKODSF.F_GET_ACCT_HIER
ACCOUNT_DESC_4	Hierarchy description or title appropriate for this Level.	VARCHAR2(255)	FUNCTION	FOKODSF.F_GET_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_GET_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_GET_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_GET_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_GET_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_GET_ACCT_HIER
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	Indicates Status of the associated account for this Level of the Hierarchy.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_ACCT_HIER
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	Hierarchy description or title appropriate for this Level.	VARCHAR2(255)	FUNCTION	FOKODSF.F_GET_ACCT_HIER
ACCOUNT_TYPE_DESC_2	Hierarchy description or title appropriate for this Level.	VARCHAR2(255)	FUNCTION	FOKODSF.F_GET_ACCT_HIER
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	Classifies an account type i.e., asset, revenue, etc. for reporting purposes.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_ACCT_HIER
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	Status of the secondary account type within this account Hierarchy.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_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	Administrative-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(63)	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)	PTRBDCA	PTRBDCA_LONG_DESC
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)	FUNCTION	GOKODSF.F_GET_DESC
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	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)	PTREARN	PTREARN_LONG_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	Financial Aid Fund code to be associated with information in this record.	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_GET_FUND_HIER
FUND_DESC_2	Hierarchy description or title appropriate for this Level.	VARCHAR2(255)	FUNCTION	FOKODSF.F_GET_FUND_HIER
FUND_DESC_3	Hierarchy description or title appropriate for this Level.	VARCHAR2(255)	FUNCTION	FOKODSF.F_GET_FUND_HIER
FUND_DESC_4	Hierarchy description or title appropriate for this Level.	VARCHAR2(255)	FUNCTION	FOKODSF.F_GET_FUND_HIER
FUND_DESC_5	Hierarchy description or title appropriate for this Level.	VARCHAR2(255)	FUNCTION	FOKODSF.F_GET_FUND_HIER
FUND_LEVEL_1	Primary Fund within the fund Hierarchy.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_FUND_HIER
FUND_LEVEL_2	Level 2 fund within this Fund Hierarchy.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_FUND_HIER
FUND_LEVEL_3	Level 3 fund within this Fund Hierarchy.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_FUND_HIER
FUND_LEVEL_4	Level 4 fund within this Fund Hierarchy.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_FUND_HIER
FUND_LEVEL_5	Level 5 fund within this Fund Hierarchy.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_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_GET_FUND_HIER
FUND_STATUS_2	Status of the Level 2 fund within this Fund Hierarchy.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_FUND_HIER
FUND_STATUS_3	Status of the Level 3 fund within this Fund Hierarchy.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_FUND_HIER
FUND_STATUS_4	Status of the Level 4 fund within this Fund Hierarchy.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_FUND_HIER
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	Hierarchy description or title appropriate for this Level.	VARCHAR2(255)	FUNCTION	FOKODSF.F_GET_FUND_HIER
FUND_TYPE_DESC_2	Hierarchy description or title appropriate for this Level.	VARCHAR2(255)	FUNCTION	FOKODSF.F_GET_FUND_HIER
FUND_TYPE_LEVEL_1	Primary Fund type within this Fund Hierarchy.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_FUND_HIER
FUND_TYPE_LEVEL_2	Level 2 fund type within this Fund Hierarchy.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_FUND_HIER
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	Status of the Level 2 fund type within this Fund Hierarchy.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_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_GET_LOCN_HIER
LOCATION_DESC_2	Hierarchy description or title appropriate for this Level.	VARCHAR2(255)	FUNCTION	FOKODSF.F_GET_LOCN_HIER
LOCATION_DESC_3	Hierarchy description or title appropriate for this Level.	VARCHAR2(255)	FUNCTION	FOKODSF.F_GET_LOCN_HIER
LOCATION_DESC_4	Hierarchy description or title appropriate for this Level.	VARCHAR2(255)	FUNCTION	FOKODSF.F_GET_LOCN_HIER
LOCATION_DESC_5	Hierarchy description or title appropriate for this Level.	VARCHAR2(255)	FUNCTION	FOKODSF.F_GET_LOCN_HIER
LOCATION_LEVEL_1	Level 1 location within this location Hierarchy.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_LOCN_HIER
LOCATION_LEVEL_2	Level 2 location within this location Hierarchy.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_LOCN_HIER
LOCATION_LEVEL_3	Level 3 location within this location Hierarchy.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_LOCN_HIER
LOCATION_LEVEL_4	Level 4 location within this location Hierarchy.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_LOCN_HIER
LOCATION_LEVEL_5	Level 5 location within this location Hierarchy.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_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_GET_LOCN_HIER
LOCATION_STATUS_2	Status of the Level 2 location within this location Hierarchy.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_LOCN_HIER
LOCATION_STATUS_3	Status of the Level 3 location within this location Hierarchy.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_LOCN_HIER
LOCATION_STATUS_4	Status of the Level 4 location within this location Hierarchy.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_LOCN_HIER
LOCATION_STATUS_5	Status of the Level 5 location within this location Hierarchy.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_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(255)	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_GET_ORGN_HIER
ORGANIZATION_DESC_2	Hierarchy description or title appropriate for this Level.	VARCHAR2(255)	FUNCTION	FOKODSF.F_GET_ORGN_HIER
ORGANIZATION_DESC_3	Hierarchy description or title appropriate for this Level.	VARCHAR2(255)	FUNCTION	FOKODSF.F_GET_ORGN_HIER
ORGANIZATION_DESC_4	Hierarchy description or title appropriate for this Level.	VARCHAR2(255)	FUNCTION	FOKODSF.F_GET_ORGN_HIER
ORGANIZATION_DESC_5	Hierarchy description or title appropriate for this Level.	VARCHAR2(255)	FUNCTION	FOKODSF.F_GET_ORGN_HIER
ORGANIZATION_DESC_6	Hierarchy description or title appropriate for this Level.	VARCHAR2(255)	FUNCTION	FOKODSF.F_GET_ORGN_HIER
ORGANIZATION_DESC_7	Hierarchy description or title appropriate for this Level.	VARCHAR2(255)	FUNCTION	FOKODSF.F_GET_ORGN_HIER
ORGANIZATION_DESC_8	Hierarchy description or title appropriate for this Level.	VARCHAR2(255)	FUNCTION	FOKODSF.F_GET_ORGN_HIER
ORGANIZATION_LEVEL_1	primary organization within the organization Hierarchy.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_ORGN_HIER
ORGANIZATION_LEVEL_2	Level 2 organization within this organization Hierarchy.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_ORGN_HIER
ORGANIZATION_LEVEL_3	Level 3 organization within this organization Hierarchy.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_ORGN_HIER
ORGANIZATION_LEVEL_4	Level 4 organization within this organization Hierarchy.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_ORGN_HIER
ORGANIZATION_LEVEL_5	Level 5 organization within this organization Hierarchy.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_ORGN_HIER
ORGANIZATION_LEVEL_6	Level 6 organization within this organization Hierarchy.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_ORGN_HIER
ORGANIZATION_LEVEL_7	Level 7 organization within this organization Hierarchy.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_ORGN_HIER
ORGANIZATION_LEVEL_8	Level 8 organization within this organization Hierarchy.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_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_GET_ORGN_HIER
ORGANIZATION_STATUS_2	Status of the Level 2 organization within this organization Hierarchy.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_ORGN_HIER
ORGANIZATION_STATUS_3	Status of the Level 3 organization within this organization Hierarchy.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_ORGN_HIER
ORGANIZATION_STATUS_4	Status of the Level 4 organization within this organization Hierarchy.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_ORGN_HIER
ORGANIZATION_STATUS_5	Status of the Level 5 organization within this organization Hierarchy.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_ORGN_HIER
ORGANIZATION_STATUS_6	Status of the Level 6 organization within this organization Hierarchy.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_ORGN_HIER
ORGANIZATION_STATUS_7	Status of the Level 7 organization within this organization Hierarchy.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_ORGN_HIER
ORGANIZATION_STATUS_8	Status of the Level 8 organization within this organization Hierarchy.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_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)	PTRPICT	PTRPICT_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)	PTRECLS	PTRECLS_LONG_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	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
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_GET_PROG_HIER
PROGRAM_DESC_2	Hierarchy description or title appropriate for this Level.	VARCHAR2(255)	FUNCTION	FOKODSF.F_GET_PROG_HIER
PROGRAM_DESC_3	Hierarchy description or title appropriate for this Level.	VARCHAR2(255)	FUNCTION	FOKODSF.F_GET_PROG_HIER
PROGRAM_DESC_4	Hierarchy description or title appropriate for this Level.	VARCHAR2(255)	FUNCTION	FOKODSF.F_GET_PROG_HIER
PROGRAM_DESC_5	Hierarchy description or title appropriate for this Level.	VARCHAR2(255)	FUNCTION	FOKODSF.F_GET_PROG_HIER
PROGRAM_LEVEL_1	primary program within the program Hierarchy.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_PROG_HIER
PROGRAM_LEVEL_2	Level 2 program within this program Hierarchy.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_PROG_HIER
PROGRAM_LEVEL_3	Level 3 program within this program Hierarchy.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_PROG_HIER
PROGRAM_LEVEL_4	Level 4 program within this program Hierarchy.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_PROG_HIER
PROGRAM_LEVEL_5	Level 5 program within this program Hierarchy.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_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_GET_PROG_HIER
PROGRAM_STATUS_2	Status of the Level 2 program within this program Hierarchy.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_PROG_HIER
PROGRAM_STATUS_3	Status of the Level 3 program within this program Hierarchy.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_PROG_HIER
PROGRAM_STATUS_4	Status of the Level 4 program within this program Hierarchy.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_PROG_HIER
PROGRAM_STATUS_5	Status of the Level 5 program within this program Hierarchy.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_PROG_HIER
PROJECT	Work order code used for cost accounting.	VARCHAR2(63)	NHRDIST	NHRDIST_PROJ_CODE
PROJECT_DESC	Description of the project.	VARCHAR2(255)	FUNCTION	FOKODSF.F_GET_FINANCE_DESC
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)	PTRBDCA	PTRBDCA_LONG_DESC
TAX_DEDUCTION_SHORT_DESC	Benefit/deduction short description.	VARCHAR2(255)	PTRBDCA	PTRBDCA_SHORT_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: 9.1