• Elements
  • Element: Department Identifier - 01796

Page Name

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.


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.




ELEMENT

201300

30-JUL-2013


Allowed Values

Edit Values

Submission CodeAscending
Table name
Diagnostic Code
Diagnostic Message
Error Level
Error Description
EMPLEMPLOYEE_DATA0007Missing9Critical Error: may cause submission to be rejected
IRDWORKLOAD_ACTIVITIES0007Missing9Critical Error: may cause submission to be rejected
IRDWORKLOAD_ACTIVITY_SUMMARY4227Frequency of Values for WORKLOAD_ACTIVITY_SUMMARY.DEPT_ID0Frequency Distribution: not an indication of an error
IRDWORKLOAD_PERSON_FUNDING0007Missing9Critical Error: may cause submission to be rejected
OBOPERATING_BUDGET0007Missing9Critical Error: may cause submission to be rejected
OBOPERATING_BUDGET5224dept_id/univ_bud_id on OB file must have matching dept_id/univ_bud_id number on the UNIV_DEPT_MASTER file9Critical Error: may cause submission to be rejected
SCDEMPLOYEE_DATA0007Missing9Critical Error: may cause submission to be rejected
SCDEMPLOYEE_VACANTS0007Missing9Critical Error: may cause submission to be rejected
SCDEMPLOYEE_VACANTS6047DEPT_ID is nulled if EMPLOYEE_VACANTS.PAY_PLAN_NBR IN ('98', '99')1Generated or Modified during SUDS Edit Process
  • 1 - 9

Prior Database Information:

VARCHAR2(10)
DEPTID
DEPT_ID