UD PeopleSoft Financial System -
Data Dictionary
Last updated for this Record on 6/7/2003.
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.
|
| 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.
|
| |
|
| .
|
| EMPLID
| EmplID
| Example: 31660
|
| KEY
| Type: character
| Format: UPPERCASE
| Length: 11
| Decimals: 0
|
| | Employee ID from HR system.
|
| |
|
| .
|
| 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
|
| .
|
| 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
|
| .
|
| LASTUPDDTTM
| Last Update Date/Time
| Example: 01/27/2003 4:26:33PM
|
|
| Type: date-time
| Format: seconds
| Length: 26
| Decimals: 0
|
| | Last date/time the row has been updated. Equivalent to legacy Data
Warehouse last_update.
|
| |
|
| .
|
| LASTUPDOPRID
| Last Update User ID
| Example: rylee
|
|
| Type: character
| Format: lowercase
| Length: 30
| Decimals: 0
|
| | Logon of person who last udpdated the row.
|
| |
|
| .
|
| PERCENTAGE
| Percentage
| Example: 40.00
|
|
| Type: signed number
| Format: UPPERCASE
| Length: 7
| 2Decimals: 2
|
| |
|
| .
|
| 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
|
|
| 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.
|
| |
|
| .
|
| SEQUENCE_NBR_6
| Sequence
| Example: 2
|
|
| Type: number
| Format: UPPERCASE
| Length: 6
| Decimals: 0
|
| | Rows are numbered as they are added. First row would have sequence of 1,
second = 2, etc. Note that rows may not be in sequence if rows deleted.
(e.g. sequences for a specific employee id could be 1 and 7. Rows 2-6 were
|
| |
|
| .
|
| SPEEDTYPE_KEY
| SpeedType Key
| Example: SPEEDTYP_TBL
|
|
| Type: character
| Format: UPPERCASE
| Length: 10
| Decimals: 0
|
| | Provides default values for several chartfields. Expedites filling in forms
with default values by entering this one field instead of each one
separately.
|
| |
|
| .