UD PeopleSoft Financial System - Data Dictionary
Last updated for this Record on 6/7/2003.

HR_ACCTG_LINE

Contains the detailed Payroll transactions.
ACCOUNT Account Example: 141000
Type: character Format: uppercase Length: 10 Decimals: 0
Chartfield which characterizes the type of transaction as part of the transaction string. It identifies the type of revenue, expense, liability or asset. Corresponds to the legacy 3-digit Object Code.
Lookup values and translations in GL_ACCOUNT_TBL
.
ACCOUNTING_DT Accounting Date Example: 2003-07/31
Type: date Format: uppercase Length: 10 Decimals: 0
The date the transaction is recorded in the ledger.
.
ACCOUNTING_PERIOD Accounting Period Example: 001
Type: number Format: uppercase Length: 3 Decimals: 0
Represents the time span where the transactions are recorded. Accounting periods 1-12 correspond to a month and periods 991 and 992 correspond to year end close periods.
.
BUDGET_REF Budget Reference Example: 1999
Type: character Format: uppercase Length: 8 Decimals: 0
The Budget Year (Fiscal).
Lookup values and translations in BUD_REF_TBL
.
BUSINESS_UNIT Business Unit Example: UOD01
Type: character Format: uppercase Length: 5 Decimals: 0
Legal entity with a tax ID number. Only one exists at UD at this time (UOD01)
.
CHARTFIELD1 Purpose Example: ENGL110000
Type: character Format: uppercase Length: 10 Decimals: 0
Purpose chartfield. Replaces legacy 11 digit account code.
Lookup values and translations in CHARTFIELD1_TBL
.
CHARTFIELD2 Source Example: 3300003000
Type: character Format: uppercase Length: 10 Decimals: 0
Source chartfield which tags and tracks contract and grant agency information, and capital projects.
Lookup values and translations in CHARTFIELD2_TBL
.
CHARTFIELD3 UD Chartfield Example: 0000000001
Type: character Format: uppercase Length: 10 Decimals: 0
The Chartfield which tags transactions with a code that each UDFS user can interpret as (s)he finds useful (eg. USRVAL1 might mean "Paris" to one user or department, but mean "Fall lecture series" to another).
Lookup values and translations in CHARTFIELD3_TBL
.
CLASS_FLD Class Field Example: 001
Type: character Format: uppercase Length: 5 Decimals: 0
The Chartfield which identifies the faculty member or the staff position to which salary items apply. Corresponds to the legacy line number.
Lookup values and translations in CLASS_CF_TBL
.
DEPTID Department 0255 3 Example: 02553
Type: character Format: uppercase Length: 10 Decimals: 0
Identifies the administrative budget unit controling one or more Purposes. Some entries are not actual departments, but are merely nodes on a tree that organizes departments into a hierarchy for reporting purposes.
Lookup values and translations in DEPT_TBL
.
FISCAL_YEAR Fiscal Year Example: 2004
Type: number Format: uppercase Length: 4 Decimals: 0
UD fiscal transaction year. The year runs from 7/1/XX to 6/30/XY..
.
FUND_CODE Fund Code Example: OPBAS
Type: character Format: uppercase Length: 5 Decimals: 0
Each Fund represents a self-balancing entity that produces balance sheets. Loosely corresponds to Legacy Data Warehouse ACCT_TYPE.
Lookup values and translations in FUND_TBL
.
JOURNAL_DATE Journal Date Example: 2003-07-31
Type: date uppe uppercase Format: uppercase Length: 10 Decimals: 0
Date the journal is entered.
.
JOURNAL_ID Journal ID Example: 0000000001
Type: character Format: uppercase Length: 10 Decimals: 0
Identifies and individual journal.
.
JOURNAL_LINE GL Journal Line Number Example:
Type: number Format: uppercase Length: 9 Decimals: 0
Sequencial number of lines in journal.
.
JRNL_LINE_STATUS Journal Line Status Example: P
Type: character Format: number Length: 1 Decimals: 0
Shows whether the journal has errors, has been posted, is valild, a model journal, or not been edited.
.
LEDGER Ledger Example: ACTUALS
Type: character Format: uppercase Length: 10 Decimals: 0
Name of the ledger that the row is attached.
.
LINE_DESCR Journal Line Description Example:
Type: character Format: lowercase Length: 30 Decimals: 0
Use undetermined at this time
.
MONETARY_AMOUNT Monetary Amount Example: 0.000
Type: signed number Format: uppercase Length: 28 Decimals: 3
The total dollar amount for a chartfield string.
.
PROGRAM_CODE Program Code Example: INST2
Type: character Format: uppercase Length: 5 Decimals: 0
Identifies the major University function to which a transaction pertains
Lookup values and translations in PROGRAM_TBL
.
PROJECT_ID Project Example: ARTC37211199000
Type: character Format: uppercase Length: 15 Decimals: 0
Chartfield which identifies contract and grant activities and facilities projects (eg. ARTC37211199000). Adds designators to a "Purpose" (eg. ARTC372111) indicating fiscal year, building, or other coded details.
Lookup values and translations in PROJECT_ID_VW
.
Fields deemed insignificant at UD, or of limited use to general campus users.
AFFILIATE Affiliate
AFFILIATE_INTRA1 Fund Affiliate
AFFILIATE_INTRA2 Operating Unit Affiliate
ALTACCT Alternate Account
APPL_JRNL_ID Journal Template
AUDIT_ACTN Action
BUDGET_DT Budget Date
BUDGET_LINE_STATUS Budget Checking Line Status
BUSINESS_UNIT_GL General Ledger Unit
CURRENCY_CD Currency Code
FOREIGN_AMOUNT Foreign Amount
FOREIGN_CURRENCY Foreign Currency Code
GL_DISTRIB_STATUS Distribution Status
IN_PROCESS_FLG In Process
JOURNAL_LINE_DATE Journal Line Date
JRNL_LN_REF Journal Line Reference
KK_AMOUNT_TYPE Commitment Control Amount Type
LEDGER_GROUP Ledger Group
LINE_NBR Line Number
OPEN_ITEM_STATUS Open Item Status
OPERATING_UNIT Operating Unit
PROCESS_INSTANCE Process Instance
PRODUCT Product
RATE_DIV Rate Divisor
RATE_MULT Rate Multiplier
RT_TYPE Rate Type
RUN_DT Run Date
SEQNUM Sequence number
STATISTIC_AMOUNT Statistic Amount
STATISTICS_CODE Statistics Code
USE_DISTRIBUTION Use Paycheck Distribution?