UD PeopleSoft Financial System -
Data DictionaryLast updated for this Record on 1/16/2004.

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

ACCOUNT

Account

Example: 141000

KEY

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.

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

KEY

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.

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.

Identifies the transaction in different ways depending on the value of
TRANS_SOURCE. For example, if TRANS_SOURCE is "PAY", then JRNL_LN_REF
contains the EmployeeID. If TRANS_SOURCE is "000", this field would contain
the WebForm Request ID.

.

LEDGER

Ledger

Example: ACTUALS

Type: character

Format: uppercase

Length: 10

Decimals: 0

Name of the ledger that the row is attached.

.

SOURCE

Transaction Source

Example: EXT

Type: character

Format: uppercase

Length: 3

0Decimals: 0

Transaction Source: the subsystem where the tranaction originates. NOT the
same as CHARTFIELD2-SOURCE. Equivalent to Legacy Data Warehouse
_code.