SUDS Data Dictionary
APEX_PUBLIC_USER
Elements
Element: Program Component-Employee/Department - 01518
Page Name
Description:
A further refinement or breakdown of Budget Entity and a classification of the programmatic objectives of a post secondary institution as it applies to the department from which the employee is paid.
Coding Instructions:
Algorithm:
The following guidelines should be used to determine program component, SUS:
PROG_COMP
BE_CD
PCS_DEPT_ID
000000
N/A
Not 1, 4, 5, 7
Not Coded
010000
I&R
1, 4, 5, 7
11, 22, 32, 35, 40, 44, 46, 95
020000
IRC
1, 4, 5, 7
21
030000
Radio
1, 7
34
040000
Library
1, 4, 7
41, 43
050000
Museums & Galleries
1, 7
42
070000
ADSS
1, 4, 5, 7
61
08000
PO&M
1, 4, 5, 7
01, 02, 03, 05
090000
Stu Svcs
1, 7
51, 58, 86, 97
120000
Allied Clinics
4
31
130000
Ag Extension
5
33
Usage Type:
ELEMENT
Begin Term:
192001
End Term:
Last Modified:
08-OCT-2019
Associated Submissions, Tables, and Columns
Go
Actions
Submission
Ascending
Table Name
Column name
Element ID
Tab column id
Table id
Submission name
Submission
Ascending
Table Name
Column name
Element ID
Tab column id
Table id
Submission name
Instruction & Research (IRD)
WORKLOAD_PERSON_FUNDING (WKPF)
DEPT_EMP_PROG_COMP
184
1491
26
Instruction & Research
1 - 1
Allowed Values
Excel code
Code
Description
Grouping
'.
.
MISSING
-
'000000
000000
Not Applicable (Not valid for E&G and Special Units)
'010000
010000
Instruction & Research
'020000
020000
Institutes & Research Centers
'030000
030000
Radio/TV
'040000
040000
Library/AV
'050000
050000
Museums & Galleries
'060000
060000
Academic Infrastructure Support Organizations
-
'070000
070000
Administrative Direction and Support Services
'080000
080000
Physical Plant Management
'090000
090000
Student Services
'120000
120000
Allied Clinics
'130000
130000
Agricultural Extension Services
Download
1 - 13
Edit Values
Go
Actions
Submission Code
Ascending
Table name
Diagnostic Code
Diagnostic Message
Error Level
Error Description
Submission Code
Ascending
Table name
Diagnostic Code
Diagnostic Message
Error Level
Error Description
IRD
WORKLOAD_PERSON_FUNDING
0214
Pay Plan not equal to 98 or 99 and Program Component is invalid for Budget Entity
9
Critical Error: may cause submission to be rejected
IRD
WORKLOAD_PERSON_FUNDING
4179
Frequency of Values for WORKLOAD_PERSON_FUNDING.DEPT_EMP_PROG_COMP
0
Frequency Distribution: not an indication of an error
1 - 2
Prior Database Information:
Physical Description:
VARCHAR2(6)
Short Name:
PCEMP
Column Name:
PROG_COMP_EMP_DEPT
---
Sign Out
Search
Search