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.
|
| |
|
| .