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

LEDGER

Contains summarized transaction data by unique chartfield string and accounting period.
ACCOUNT Account Example: 141000
KEY 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_PERIOD Accounting Period Example: 001
KEY 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
KEY 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
KEY 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
KEY 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
KEY 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
KEY 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
KEY 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 Example: 02553
KEY 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
KEY 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
KEY 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
.
GL_ADJUST_TYPE Adjustment Type Example:
KEY Type: character Format: uppercase Length: 4 Decimals: 0
Represents type of adjusting entry for year-end closing.
.
LEDGER Ledger Example: ACTUALS
KEY Type: character Format: uppercase Length: 10 Decimals: 0
Name of the ledger that the row is attached.
.
PROGRAM_CODE Program Code Example: INST2
KEY Type: character Format: uppercase Length: 5 Decimals: 0
Identifies the major University function to which a transaction pertains among an initial list of 3 dozen.
Lookup values and translations in PROGRAM_TBL
.
PROJECT_ID Project Example: ARTC37211199000
KEY 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
.
STATISTICS_CODE Statistics Code Example:
KEY Type: character Format: uppercase Length: 3 Decimals: 0
Paired with statistical amount to tell you the type of units.
.
DTTM_STAMP_SEC Last Update DateTime Example: 2002-12-10-16.28.52.000000
Type: date-time Format: seconds Length: 26 Decimals: 0
Date and time when the ledger chartstring was last posted.
.
POSTED_TOTAL_AMT Posted Total Amount Example: 0.000
Type: signed number Format: uppercase Length: 28 Decimals: 3
The sum of all transactions in a single period for a unique chartfield string.
.
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
BASE_CURRENCY Base Currency
BOOK_CODE Book Code
CURRENCY_CD Currency Code
OPERATING_UNIT Operating Unit
POSTED_BASE_AMT Posted Base Currency Amount
POSTED_TRAN_AMT Posted Transaction Amount
PROCESS_INSTANCE Process Instance
PRODUCT Product