Page Name

Description:

A code which may be used by the universities to group Account Numbers or records. Codes 01-20 are reserved: 01-07 are reserved to identify the Medical/Health colleges for UF,USF and FSU; 08 is reserved to code records related to Broward County activities at FIU and FAU; 10 is reserved to code records related to IFAS at UF.

Coding Instructions:

College is optional.
- Codes 01-07 may only be used by USF, UF, FSU, UCF or FIU.
- Only FAU and FIU may code '08' for Broward County.
- Only UF may use '10' for IFAS.

For OB, the value must be coded '00' if no code is used.
For the SIF a value of '00' will be generated if this field is left blank.

Algorithm:

Usage Type:

ELEMENT

Begin Term:

192001

End Term:

Last Modified:

22-AUG-2011

SubmissionAscending	Table Name	Column name	Element ID	Tab column id	Table id	Submission name
Expenditure Analysis (EA)	EXPENDITURE_ANALYSIS_EXTRACT (EAE)	COLLEGE	173	643	43	Expenditure Analysis
Instruction & Research (IRD)	WORKLOAD_ACTIVITIES (WKA)	COLLEGE	173	1591	28	Instruction & Research
Student Instruction (SIF)	COURSES_TAKEN (COUR)	COLLEGE	173	73	9	Student Instruction
Student Instruction Preliminary (SIFP)	COURSES_TAKEN (COUR)	COLLEGE	173	73	9	Student Instruction Preliminary

1 - 4

Excel code	Code	Description	Grouping
'.	.	MISSING	-
'01	01	Medical (Medical & Health)
'02	02	Nursing (Medical & Health)
'03	03	Pharmacy (Medical & Health)
'04	04	Health Related Professions (Medical & Health)
'05	05	Dentistry (Health)
'06	06	Veterinary Medicine (Health)
'07	07	Public Health (Medical)
'08	08	Broward County Activities (FAU and FIU only)	For non-medical/health center codes
'10	10	IFAS (UF)	For non-medical/health center codes

Download

1 - 10

Submission CodeAscending	Table name	Diagnostic Code	Diagnostic Message	Error Level	Error Description
IRD	WORKLOAD_ACTIVITIES	0793	When BE_CD_EMPL OR BE_CD_ACT equals '4' the COLLEGE must not be missing or equal '00'.	9	Critical Error: may cause submission to be rejected
IRD	WORKLOAD_ACTIVITIES	0880	College = 9 or between 11 and 20 is invalid	9	Critical Error: may cause submission to be rejected
IRD	WORKLOAD_ACTIVITIES	0881	College invalid or invalid for university. Codes 01 through 07 may only be used by UF, FSU, USF, UCF, and FIU. Code 10 may only be used by UF. Code 08 may only be used by FIU or FAU. Code 11 may only be used by FSU.	9	Critical Error: may cause submission to be rejected
IRD	WORKLOAD_ACTIVITIES	4214	Frequency of Values for WORKLOAD_ACTIVITIES.COLLEGE	0	Frequency Distribution: not an indication of an error
IRD	WORKLOAD_ACTIVITY_SUMMARY	0880	College = 9 or between 11 and 20 is invalid	9	Critical Error: may cause submission to be rejected
IRD	WORKLOAD_ACTIVITY_SUMMARY	4217	Frequency of Values for WORKLOAD_ACTIVITY_SUMMARY.COLLEGE	0	Frequency Distribution: not an indication of an error
SIF	COURSES_TAKEN	0880	College = 9 or between 11 and 20 is invalid	9	Critical Error: may cause submission to be rejected
SIF	COURSES_TAKEN	0881	College invalid or invalid for university. Codes 01 through 07 may only be used by UF, FSU, USF, UCF, and FIU. Code 10 may only be used by UF. Code 08 may only be used by FIU or FAU. Code 11 may only be used by FSU.	9	Critical Error: may cause submission to be rejected
SIF	COURSES_TAKEN	4242	Frequency of Values for COURSES_TAKEN.COLLEGE	0	Frequency Distribution: not an indication of an error
SIFP	COURSES_TAKEN	4242	Frequency of Values for COURSES_TAKEN.COLLEGE	0	Frequency Distribution: not an indication of an error
SIFP	COURSES_TAKEN	6155	COLLEGE is nulled if DEMO_DATA_SOURCE = 'SIFP'	1	Generated or Modified during SUDS Edit Process

1 - 11

Physical Description:

VARCHAR2(2)

Short Name:

COLLEGE

Column Name:

COLLEGE_ACTIVITY

Page Name

Associated Submissions, Tables, and Columns

Allowed Values

Edit Values

Prior Database Information:

Element: College (Subcomponent) - 01507

Page Name

Associated Submissions, Tables, and Columns

Allowed Values

Edit Values

Prior Database Information: