UD PeopleSoft Financial System
Data Dictionary

Last updated on 3/29/2005.

This is not an exhaustive list of Records and Fields, but contains those most useful to back-office users of
queries and other aspects of the UD Financial System. It does include a number of Records not available in the
report instance to most campus users of the system.

You can follow links among the definitions of individual Records and their Fields, or you can
print the dictionary in pdf-format (134 pages), or download the
Access database from which it was generated.

Accounts Payable

DISTRIB_LINE (Not available in the report instance to most campus users)

Contains the accounting distribution (chartfields) entries when an AP voucher is saved. Monetary amount
includes freight or discounts prorated to each distribution line.
This record is a child of VOUCHER_LINE.

PAYMENT_TBL (Not available in the report instance to most campus users)

This record is populated after the AP vouchers are posted. These entries are the complete AP sub-system
entries including AP offset, charges and cash entries. This record contains detailed AP voucher
information before it is summarized in the General Ledger.

This is the main AP voucher table, it contains invoice number, invoice date, vendor, gross amount,
Further details are in this record's child: PYMNT_VCHR_XREF.
Further details are in this record's child: VOUCHER_LINE.

VOUCHER_LINE (Not available in the report instance to most campus users)

Contains detailed information for each AP voucher, such as description of goods/services, quantity, unit
price, purchase order ID.
This record is a child of VOUCHER.
Further details are in this record's child: DISTRIB_LINE.

Attributes provide a method for tagging chartfields with additional qualities not inherent in the
chartfield itself. Can be used as criteria or grouping in another way than lists and trees, but often
toward the same end. For example, the Purposes that are given a certain TRUSTSORT attribute here are
grouped together for reporting to Board of Trustees.

This is the Purpose Table, which contains short and long descriptions as of an effective date. The
"Purpose" chartfield identifies discrete blocks of money used to make expenditures, collect revenues, or
track assets and liabilities (eg. PLSC11). Relates to the legacy 11-digit "account code".

This is the Source Table, which contains short and long descriptions as of an effective date. The
"Source" chartfield is the source of funds. Will be used for Contracts & Grants and capital projects (eg.
33041101: Office of Education).

This is the Userfield Table, which tags transactions with a code that each UDFS user can interpret as
(s)he finds useful (eg. USER_001 might mean "Paris" to one user or department, but mean "Fall lecture
series" to another).

This is the Class Table, which contains short and long descriptions as of an effective date. "Class"
chartfield: identifies the faculty member or the staff position to which salary items apply. Descriptions
are not meaningful. Class relates to the legacy "line number".

This is the Department Table, which contains short and long descriptions as of an effective date. The
"Department" chartfield identifies the administrative budget unit controling one or more Purposes (eg.
02537 = English). Some entries are not actual departments, but are merely nodes on a tree that
organizes departments into a hierarchy for reporting purposes.

This is the Fund Table, which contains short and long descriptions as of an effective date. The "Fund"
chartfield identifies the fund type to which a certain Purpose belongs. Implies a set of accounting rules
that pertain to those Purposes (eg. OPBAS: Basic Operating). Corresponds to first two segments of the
legacy Account Code (01-1-...).

This is the Account Table, which contains short and long descriptions as of an effective date. The
"Account" chartfield classifies transactions as a particular category of expenditure, revenue, asset,
liability or net assets. (eg. 141000: Office Supplies). Corresponds to the legacy "Object code".

This is the Program Table, which contains short and long descriptions as of an effective date. The
"Program" chartfield characterizes a transaction as to the major University function to which it pertains
(eg. INST1 = Instruction). Corresponds to the legacy "function code".

This is the Project Table, which contains short and long descriptions as of an effective date. The
"Project" Chartfield identifies contract and grant activities and facilities projects with a specific
beginning and end date (eg. ARTC37211199000). Subdivides activity within a particular "Purpose" (eg.
ARTC372111) by adding designators for fiscal year, building, or other coded details.

This is the Speedtype Table, which contains short and long descriptions as of an effective date. The
"Speedtype" provides default values for several chartfields. Expedites filling in forms with default
values by entering this one field instead of each one separately.

General Ledger

HR_ACCTG_LINE (Not available in the report instance to most campus users)

Contains the detailed Payroll transactions.

JRNL_HEADER (Not available in the report instance to most campus users)

Contains summary information about Journals.
Further details are in this record's child: JRNL_LN.

Grants

Award Attributes:: Descriptive header information for each proposal once a Purpose and Project-ID(s) have
been assigned. Includes awards in "pre-award" status, through "awarded", "closed", etc. Similar to
Proposal Attributes, but data continues to be updated across the life of the award; whereas Proposal
Attributes are static as of the award date.

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.

Enumerates Obligations (Encumbrances), both salary and non-salary. Salaries are automatically encumbered
and disencumbered by the Labor Allocation Module (LAM) and Payroll process. Non-salary items are manually
encumbered and disencumbered. Each Obligation may be divided into multiple details, each with their own
Chartfields and amounts in the child table, UOD_OBLIG_DTL.
Further details are in this record's child: UOD_OBLIG_DTL.

UD Reporting

Contains summary amounts for activity during each Accounting Period (starting, monthly, and year-end
adjustment periods) for each Chartfield-String. Also has starting balances, year-to-date budget changes,
and other information to assess financial situation of that Chartfield-String as of the specified
Accounting Period.

Contains individual transactions, identified by their Chartfield-Strings, date, and the vehicle that
caused them (eg. which Purchase Order ID, Journal ID, Voucher ID, etc.). Equivalent to the DataWarehouse
table GA-TRANSACTIONS. This Record's data is compiled from multiple other Records, which are indicated
in UOD_trans_derivation.xls

UD Security

Contains row level security controls. For each user, there is at least one entry here that specifies a
certain degree of access. That access can be applied to one or more Purposes (Chartfield1) by appearing
in the child Record (UOD_ROW_SEC_LN) in conjunction with those Purposes.
Further details are in this record's child: UOD_ROW_SEC_LN.

Contains the attachment between a user's degree of row level security access (from the parent
UOD_ROW_SEC_HDR) and one or more Purposes to which that security applies.
This record is a child of UOD_ROW_SEC_HDR.