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