SUDS Data Dictionary
APEX_PUBLIC_USER
Elements
Element: Program Component - Activity - 01508
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 activity in which the employee is engaged.
Coding Instructions:
This value is validated against Activity Budget Entity (01505).
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_ACTIVITIES (WKA)
PROG_COMP_ACT
174
1593
28
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_ACTIVITIES
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_ACTIVITIES
4176
Frequency of Values for WORKLOAD_ACTIVITIES.PROG_COMP_ACT
0
Frequency Distribution: not an indication of an error
IRD
WORKLOAD_ACTIVITY_SUMMARY
4175
Frequency of Values for WORKLOAD_ACTIVITY_SUMMARY.PROG_COMP_ACT
0
Frequency Distribution: not an indication of an error
1 - 3
Prior Database Information:
Physical Description:
VARCHAR2(6)
Short Name:
PCACT
Column Name:
PROG_COMP_ACT
---
Sign Out
Search
Search