UD PeopleSoft Financial System
Data Dictionary

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)

Contains the AP payment information including check, ACH, manual payments, payment date, remit vendor. This is like an AP check register.

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

This record is the bridge between the VOUCHER table and the PAYMENT_TBL. It contains the payment due dates.
This record is a child of VOUCHER.

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

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

Contains all the vendor information, including name(s), tax ID number, class of vendor, but not the addresses.
Further details are in this record's child: VENDOR_ADDR.

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

Contains all the vendor addresses.
This record is a child of VENDOR.

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

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.

Chartfields

ACCT_TYPE_TBL

Account Type: characterizes an account, transaction or balance broadly as Expense, Revenue, Asset, Liability, or Equity.

BUD_REF_TBL

Budget Years: 4-digit fiscal years. Each fiscal year begins July 1, ends June 30, and is named for the calendar year of the latter.

CF_ATTRIB_TBL

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.

CF_ATTRIB_VALUE

Key sets comprised of (a Chartfield, an attribute, and a value) join here to yield a Description.

CHARTFIELD1_TBL

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

CHARTFIELD2_TBL

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

CHARTFIELD3_TBL

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

CLASS_CF_TBL

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

DEPT_TBL

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.

FUND_TBL

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

GL_ACCOUNT_TBL

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

PROGRAM_TBL

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

PROJECT_ID_VW

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.

SPEEDTYP_TBL

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.

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

Contains detailed information for transactions on each journal as each component is assigned to one or more chartfield strings.
This record is a child of JRNL_HEADER.

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

Contains summarized transaction data by unique chartfield string and accounting period.

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

Contains summarized budget data by unique chartfield string and accounting period.

SOURCE_TBL

"Transaction Source": characterizes the origin or type of a transaction. Mimics the legacy "tran-code". Not to be confused with "Source" (Chartfield2)

Grants

UOD_AWD_ATRB_VW

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.

UOD_PRJ_VW

Project: F&A (facilities & administration) rates associated with each project. Useful for analyzing the overhead earned through the project.

UOD_PROJ_RES_VW

Project Resources: Individual expense transactions associated with each project. "Analysis Type" is an essential field when querying this view and interpretting the various costs that are returned.

UOD_PRP_ATRB_VW

Proposal Attributes: Descriptive header information for each proposal at the Pre-award stage. Shows the status (eg. draft, pending, awarded, withdrawn,...)

UOD_PRP_BUD_VW

Proposal Budget: Specifies budgeted amounts for each item of each project within the proposal. Budgets are as stated in the proposal and do not reflect changes made after awarded.

LAM/Obligations

UOD_LBR_DST_DTL

Identifies each component of an employee's salary as a percentage of the entire salary.
This record is a child of UOD_LBR_DST_HDR.

UOD_LBR_DST_HDR

Labor Distributions (LAM) for each employee are given effective dates for Active/Inactive status in this Record.
Further details are in this record's child: UOD_LBR_DST_DTL.

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.

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.

Purchasing

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

This is the main Purchase Order record. It contains information common to the entire PO, such as the PO status, PO date, vendor, buyer.
Further details are in this record's child: PO_LINE.

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

Contains the long description (254 maximum characters) of the goods/services in a PO.
This record is a child of PO_HDR.
Further details are in this record's child: PO_LINE_DISTRIB.

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

Contains the accounting distribution (chartfields) entries when a PO is saved.
This record is a child of PO_LINE.

UD Reporting

UOD_BALANCES

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.

UOD_TRANS_DTL

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

UOD_APPROVE_VW

Indicates the Purposes (Chartfield1) for which a user has approval authority.

UOD_ROW_SEC_HDR

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.

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.