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