UD PeopleSoft Financial System -
Data Dictionary
Last updated for this Record on 6/7/2003.
LEDGER
Contains summarized transaction data by unique chartfield string and accounting period.
|
| 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.
|
| | Lookup values and translations in
GL_ACCOUNT_TBL
|
| .
|
| ACCOUNTING_PERIOD
| Accounting Period
| Example: 001
|
| KEY
| Type: number
| Format: uppercase
| Length: 3
| Decimals: 0
|
| | Represents the time span where the transactions are recorded. Accounting
periods 1-12 correspond to a month and periods 991 and 992 correspond to
year end close periods.
|
| |
|
| .
|
| BUDGET_REF
| Budget Reference
| Example: 1999
|
| KEY
| Type: character
| Format: uppercase
| Length: 8
| Decimals: 0
|
| | The Budget Year (Fiscal).
|
| | Lookup values and translations in
BUD_REF_TBL
|
| .
|
| BUSINESS_UNIT
| Business Unit
| Example: UOD01
|
| KEY
| Type: character
| Format: uppercase
| Length: 5
| Decimals: 0
|
| | Legal entity with a tax ID number. Only one exists at UD at this time
(UOD01)
|
| |
|
| .
|
| CHARTFIELD1
| Purpose
| Example: ENGL110000
|
| KEY
| 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
|
| KEY
| 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
|
| KEY
| 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).
|
| | Lookup values and translations in
CHARTFIELD3_TBL
|
| .
|
| 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.
|
| | Lookup values and translations in
CLASS_CF_TBL
|
| .
|
| DEPTID
| Department
| Example: 02553
|
| KEY
| 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
|
| .
|
| FISCAL_YEAR
| Fiscal Year
| Example: 2004
|
| KEY
| Type: number
| Format: uppercase
| Length: 4
| Decimals: 0
|
| | UD fiscal transaction year. The year runs from 7/1/XX to 6/30/XY..
|
| |
|
| .
|
| FUND_CODE
| Fund Code
| Example: OPBAS
|
| KEY
| 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
|
| .
|
| GL_ADJUST_TYPE
| Adjustment Type
| Example:
|
| KEY
| Type: character
| Format: uppercase
| Length: 4
| Decimals: 0
|
| | Represents type of adjusting entry for year-end closing.
|
| |
|
| .
|
| LEDGER
| Ledger
| Example: ACTUALS
|
| KEY
| Type: character
| Format: uppercase
| Length: 10
| Decimals: 0
|
| | Name of the ledger that the row is attached.
|
| |
|
| .
|
| PROGRAM_CODE
| Program Code
| Example: INST2
|
| KEY
| 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: ARTC37211199000
|
| KEY
| 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.
|
| | Lookup values and translations in
PROJECT_ID_VW
|
| .
|
| STATISTICS_CODE
| Statistics Code
| Example:
|
| KEY
| Type: character
| Format: uppercase
| Length: 3
| Decimals: 0
|
| | Paired with statistical amount to tell you the type of units.
|
| |
|
| .
|
| DTTM_STAMP_SEC
| Last Update DateTime
| Example: 2002-12-10-16.28.52.000000
|
|
| Type: date-time
| Format: seconds
| Length: 26
| Decimals: 0
|
| | Date and time when the ledger chartstring was last posted.
|
| |
|
| .
|
| POSTED_TOTAL_AMT
| Posted Total Amount
| Example: 0.000
|
|
| Type: signed number
| Format: uppercase
| Length: 28
| Decimals: 3
|
| | The sum of all transactions in a single period for a unique chartfield
string.
|
| |
|
| .
Fields deemed insignificant at UD, or of limited use to general campus users.
|
| AFFILIATE
| Affiliate
|
| AFFILIATE_INTRA1
| Fund Affiliate
|
| AFFILIATE_INTRA2
| Operating Unit Affiliate
|
| ALTACCT
| Alternate Account
|
| BASE_CURRENCY
| Base Currency
|
| BOOK_CODE
| Book Code
|
| CURRENCY_CD
| Currency Code
|
| OPERATING_UNIT
| Operating Unit
|
| POSTED_BASE_AMT
| Posted Base Currency Amount
|
| POSTED_TRAN_AMT
| Posted Transaction Amount
|
| PROCESS_INSTANCE
| Process Instance
|
| PRODUCT
| Product