Page Name

Description:

The smallest unit of operation for which separate financial records are maintained. Department ID is the number used by the institution for accounting purposes to identify the department:
-offering the course. (INSTRUCTIONAL_ACTIVITY)
-from which the employee is compensated. ( WORKLOAD_PERSON_FUNDING, OPERATING_BUDGET, and OPS records on EMPLOYEE_DATA)
-offering the activity. ( WORKLOAD_ACTIVITIES and EXPENDITURE_ANALYSIS_EXTRACT from IRD )
-from which funds and person years are budgeted (in appropriated budget entities) (OPERATING_BUDGET and EXPENDITURE_ANALYSIS_EXTRACT for OB)
-from which the employment resource is funded ( salaried employees on EMPLOYEE_DATA )

DEPT_ID and UNIV_BUD_ID on these tables are used in conjunction with the UNIV_DEPT_MASTER table to provide titles on reports.

Coding Instructions:

Department Identifier should be justified and zero filled in coordination with the UNIV_DEPT_MASTER records.

Use within UNIV_DEPT_MASTER:
To facilitate titling on reports you should submit title records with the 10 digits of DEPT_ID (01796) + 10 digits of University Budget Identifier (01798), if used, including trailing zeroes, and a title.

Algorithm:

Usage Type:

ELEMENT

Begin Term:

201300

End Term:

Last Modified:

30-JUL-2013

SubmissionAscending	Table Name	Column name	Element ID	Tab column id	Table id	Submission name
Instruction & Research (IRD)	WORKLOAD_ACTIVITIES (WKA)	DEPT_ID	579	1585	28	Instruction & Research
Instruction & Research (IRD)	WORKLOAD_ACTIVITIES (WKA)	DEPT_ID_TITLE	579	1585	28	Instruction & Research
Instruction & Research (IRD)	WORKLOAD_PERSON_FUNDING (WKPF)	DEPT_ID	579	1473	26	Instruction & Research
Instruction & Research (IRD)	WORKLOAD_PERSON_FUNDING (WKPF)	DEPT_ID_TITLE	579	1473	26	Instruction & Research
Operating Budget (OB)	OPERATING_BUDGET (OB)	DEPT_ID	579	1943	32	Operating Budget
Operating Budget (OB)	OPERATING_BUDGET (OB)	DEPT_ID_TITLE	579	1943	32	Operating Budget
Operating Budget (OB)	UNIV_DEPT_MASTER (ACCT)	DEPT_ID	579	17	47	Operating Budget
Operating Budget (OB)	UNIV_DEPT_MASTER (ACCT)	DEPT_ID	579	13	47	Operating Budget
Operating Budget (OB)	UNIV_DEPT_MASTER (ACCT)	DEPT_ID_TITLE	579	13	47	Operating Budget
Operating Budget (OB)	UNIV_DEPT_MASTER (ACCT)	DEPT_ID_TITLE	579	17	47	Operating Budget

1 - 10

Submission CodeAscending	Table name	Diagnostic Code	Diagnostic Message	Error Level	Error Description
EMPL	EMPLOYEE_DATA	0007	Missing	9	Critical Error: may cause submission to be rejected
IRD	WORKLOAD_ACTIVITIES	0007	Missing	9	Critical Error: may cause submission to be rejected
IRD	WORKLOAD_ACTIVITY_SUMMARY	4227	Frequency of Values for WORKLOAD_ACTIVITY_SUMMARY.DEPT_ID	0	Frequency Distribution: not an indication of an error
IRD	WORKLOAD_PERSON_FUNDING	0007	Missing	9	Critical Error: may cause submission to be rejected
OB	OPERATING_BUDGET	0007	Missing	9	Critical Error: may cause submission to be rejected
OB	OPERATING_BUDGET	5224	dept_id/univ_bud_id on OB file must have matching dept_id/univ_bud_id number on the UNIV_DEPT_MASTER file	9	Critical Error: may cause submission to be rejected
SCD	EMPLOYEE_DATA	0007	Missing	9	Critical Error: may cause submission to be rejected
SCD	EMPLOYEE_VACANTS	0007	Missing	9	Critical Error: may cause submission to be rejected
SCD	EMPLOYEE_VACANTS	6047	DEPT_ID is nulled if EMPLOYEE_VACANTS.PAY_PLAN_NBR IN ('98', '99')	1	Generated or Modified during SUDS Edit Process

1 - 9

Physical Description:

VARCHAR2(10)

Short Name:

DEPTID

Column Name:

DEPT_ID

Page Name

Associated Submissions, Tables, and Columns

Allowed Values

Edit Values

Prior Database Information:

Element: Department Identifier - 01796

Page Name

Associated Submissions, Tables, and Columns

Allowed Values

Edit Values

Prior Database Information: