SUDS Data Dictionary
APEX_PUBLIC_USER
Elements
Element: Account/Department Number, Activity - 01506
Page Name
Description:
The smallest unit of operation for which separate financial records are maintained. Activity Department/Account Number is the number used by the institution for accounting purposes to identify the department offering the activity.
Coding Instructions:
Account/Department Number as it appears in the Chart of Accounts for institutional accounting.
Algorithm:
Usage Type:
ELEMENT
Begin Term:
201300
End Term:
Last Modified:
12-AUG-2013
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
Expenditure Analysis (EA)
EXPENDITURE_ANALYSIS_EXTRACT (EAE)
DEPT_ID_ACT
582
645
43
Expenditure Analysis
Instruction & Research (IRD)
WORKLOAD_ACTIVITIES (WKA)
DEPT_ID_ACT
582
1601
28
Instruction & Research
1 - 2
Allowed Values
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
0007
Missing
9
Critical Error: may cause submission to be rejected
1 - 1
Prior Database Information:
Physical Description:
VARCHAR2(10)
Short Name:
ACTACCT
Column Name:
ACC_DEPT_NBR_ACT
---
Sign Out
Search
Search