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

LEDGER_BUDG

Contains summarized budget data by unique chartfield string and accounting period.
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_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 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
.
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 budget chartstring was last modified.
.
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
.
LEDGER Ledger Example: ACTUALS
Type: character Format: uppercase Length: 10 Decimals: 0
Name of the ledger that the row is attached.
.
POSTED_TOTAL_AMT Posted Total Amount Example: 00.000
Type: signed number Format: uppercase Length: 28 Decimals: 3
The sum of all transactions in a single period for a unique 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 among an initial list of 3 dozen.
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
.
STATISTICS_CODE Statistics Code Example:
Type: character Format: uppercase Length: 3 Decimals: 0
Paired with statistical amount to tell you the type of units.
.
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
BUDGET_PERIOD Budget Period
CURRENCY_CD Currency Code
GL_ADJUST_TYPE Adjustment Type
OPERATING_UNIT Operating Unit
POSTED_BASE_AMT Posted Base Currency Amount
POSTED_TRAN_AMT Posted Transaction Amount
PROCESS_INSTANCE Process Instance
PRODUCT Product
SCENARIO Scenario