UD PeopleSoft Financial System - Data Dictionary
Last updated for this Record on 6/7/2003.

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".
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.
.
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.
.
SETID SetID Example: UOD01
KEY Type: character Format: uppercase Length: 5 Decimals: 0
The only valid value at UD at this time is "UOD01".
.
DESCR Description Example: DEPARTMENTAL RESEARCH
Type: character Format: lowercase Length: 30 Decimals: 0
Description
.
DESCRSHORT Short Description Example: DEPT RES
Type: character Format: lowercase Length: 10 Decimals: 0
Short Description
.
EFF_STATUS Status as of Effective Date Example: A
Type: character Format: uppercase Length: 1 Decimals: 0
Indicates whether the row of data is active or inactive.
.
Fields deemed insignificant at UD, or of limited use to general campus users.
MANAGER_NAME Manager Name