UD PeopleSoft Financial System -
Data Dictionary
Last updated for this Record on 6/7/2003.
DEPT_TBL
This is the Department Table, which contains short and long descriptions as of an effective date.
The "Department" chartfield identifies the administrative budget unit controling one or more
Purposes (eg. 02537 = English). Some entries are not actual departments, but are merely nodes
on a tree that organizes departments into a hierarchy for reporting purposes.
|
| 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.
|
| |
|
| .
|
| 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.
|
| |
|
| .
|
| SETID
| SetID
| Example: UOD01
|
| KEY
| Type: character
| Format: uppercase
| Length: 5
| Decimals: 0
|
| |
|
| .
|
| DESCR
| Description
| Example: MATHEMATICAL SCIENCES
|
|
| Type: character
| Format: lowercase
| Length: 30
| Decimals: 0
|
| | Description
|
| |
|
| .
|
| DESCRSHORT
| Short Description
| Example: MATH SCI
|
|
| 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.
|
| BUDGET_DEPTID
| Budget with Department
|
| BUDGET_LVL
| Budget Level
|
| BUDGET_YR_END_DT
| Budget Year End Date
|
| COMPANY
| Company
|
| DEPT_TENURE_FLG
| Can Grant Tenure
|
| DIST_PRORATE_OPTN
| Distribution Prorate Option
|
| FTE_EDIT_INDC
| FTE Edit Indicator
|
| GL_EXPENSE
| GL Account #-Expense
|
| HP_STATS_DEPT_CD
| Stats Can Dept Code
|
| HP_STATS_FACULTY
| Faculty Code
|
| LOCATION
| Location Code
|
| MANAGER_ID
| Manager ID
|
| MANAGER_POSN
| Manager Position
|
| SETID_LOCATION
| Location SetID
|
| TAX_LOCATION_CD
| Tax Location Code
|
| TL_DISTRIB_INFO
| Use TL Distribution?
|
| USE_BUDGETS
| Use Budgeting Feature?
|
| USE_DISTRIBUTION
| Use Paycheck Distribution?
|
| USE_ENCUMBRANCES
| Use Encumbrance Processing?