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

UOD_OBLIG_DTL

Provides details (Purpose, Account, Amount, and other chartfields) of each Obligation/Encumbrance, both salary and non-salary, in the parent record UOD_OBLIG_HDR. Salaries are automatically encumbered and disencumbered by the Labor Allocation Module (LAM) and Payroll process. Non-salary items are manually encumbered and disencumbered.
This record is a child of UOD_OBLIG_HDR.

EFFDT Effective Date Example: 01/01/1951
KEY Type: date Format: uppercase Length: 10 Decimals: 0
The date on which this row of data takes effect.
.
SETID SetID Example: UOD01
KEY Type: character Format: uppercase Length: 5 Decimals: 0
The only valid value at UD at this time is "UOD01".
.
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
.
AMOUNT Amount Example:
Type: signed number Format: uppercase Length: 28 Decimals: 3
A transaction amount. Equivalent to legacy Data Warehouse TRAN_AMT.
.
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).
.
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
.
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
.
ORIG_AMOUNT Original Amount Example: 55000.00
Type: signed number Format: uppercase Length: 28 Decimals: 3
The original amount entered as the obligation.
.
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: DBIO42211501000
char character 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.
.
REMAINING_AMOUNT Remaining Amount Example: 10000.00
Type: signed number Format: uppercase Length: 28 Decimals: 3
The amount still encumbered in UD obligations.
.
SEQUENCE_NBR_6 Sequence Example: 2
Type: number Format: uppercase Length: 6 Decimals: 0
Counts number of rows associated with an Encumberance ID. Starts at 1 and counts up.
.
UOD_ENC_ID Encumbrance ID Example: Pencils
Type: character Format: uppercase Length: 10 Decimals: 0
Unique idenifier of the specific encumberance.
.