Coronavirus Disease 2019 (COVID-19) in Colorado: State & National Resources

Field Definitions


HB1023 Query File Field Definitions
Select File Type: Select Field:

Field # Starting Position Field Name Field Definitions/Descriptions
1 1 Record Type Definition: A flag that indicates which record type is being reported.

Codes/Notes: Enrollment=1, UAF=2, Degrees=3, Financial Aid=4, Student Course=5, Educator Preparation=6



Missing Value: Does not apply; field must be completed.

Edit Specs: File specific value.

Format: Numeric, 1 place integer

Updates:

2 2 Institution Code Definition: The unique code designations for Colorado postsecondary institutions.

Codes/Notes: The number assigned to each higher education institution identifying an institution with a 4-digit institutional code. See Institution Code in Glossary.


Missing Value: Does not apply; field must be completed.

Edit Specs: Error if a value is reported that is not the code assigned to the reporting institution.

Format: Alphanumeric, 4 characters

Updates: July 1987


3 6 Report Term Definition: The enrollment period identified by the term on which the data are based

Codes/Notes: 1 - Summer
2 - Fall
3 - Winter (only for institutions on a quarter system)
4 - Spring
5 - Interim
9 - Total report year (Only used in Financial Aid reporting)

For Education Preparation file: Report period should be by term, beginning with summer and continuing through the following fall and spring terms. Term 9 is not valid for this file. 

For Financial Aid file: Term is 9, FA file is a fiscal year file beginning with Fall data and ending with trailing summer data



Missing Value: Does not apply; field must be completed.

Edit Specs: Error if term value is anything other than 1,2,3,4,5,9

Format: Numeric, 1 place integer (T)

Updates: Expanded to four-digit format, year 2000 file conversions, September 1998.
Simplified text of definition section and removed term & year examples dating back to a previous data element format. Also corrected edit spec section to show that '9' is acceptable. Dec, 2018

4 7 Report Year Definition: The enrollment period identified by the calendar year on which the data are based (YYYY) The year in which the term occurs. When the term code is "9" which signifies the total report year, use 4 digits of the fiscal year of the report period. The fiscal year is derived by the following. If the term is =3, the fiscal year is the same as the report year. If the term is =2, the fiscal year equals the report year + 1.

Codes/Notes:

AY 2018 and FY 2018 matrix Example

Academic

Year

Report Term

Report 

Year

FinAid Fiscal

YEAR

2018 1 2017 2017
2018 2 2017 2018
2018 3 2018 2018
2018 4 2018 2018
2018 5 2018 2018
2019 1 2018 2018


Missing Value: Does not apply; field must be completed.

Edit Specs: Error if year value does not represent current reporting year.

Format: Numeric, 4 place integer (YYYY)

Updates: Expanded to four-digit format, year 2000 file conversions.
Simplified text of definition section and removed term & year examples dating back to a previous data element format. Added AY, term, FY matrix. Corrected Edit Spec section. Dec. 2018

5 11 Student ID Definition: A number that uniquely identifies a student at an institution. Wherever possible, this should be the nine digit social security number assigned to an individual under the Federal Insurance Contribution Act. Social Security rules currently exclude use of numbers that are < 000000100 or >= 800000000

Codes/Notes: If the Student Identification Number is assigned, the number should be used in all future reports by the institution for that student unless corrected or replaced by Social Security Number. Note: Use of an SSN is the only way CCHE can track a student for retention and graduation analyses across institutions. 

If an individual's social security number is not available for use by an institution, the institution may report any student identification number up to 9 characters that is unique for that student. The institution also must report the Student Identification Type as “1,” indicating that this number is not a Social Security Number. 
Hyphens are not entered as part of the identification number.

Missing Value: Does not apply; field must be completed.

Edit Specs: Error if blank. If Student Identification Type is 0 or blank, error if value contains alpha characters or the last 6 digits are all zeroes or is < 000000100 or >= 800000000—This edit to be implemented with submissions for FY04 and modified to 900000000+ (vs 800000000+) December 2011.

Format: Alphanumeric, 9-place integer

Updates: July 1988; edit specs modified July 2003; Dec 2011 - changed upper limit from 800000000;

6 20 Student ID Type Definition: The indicator to classify the Student Identification Number as believed to be either a social security number or a institutional-assigned identification number.

Codes/Notes: 0 – Indicates that the Student Identification Number is believed to be a social security number

1 – Indicates that the Student Identification Number is NOT a social security number.



Missing Value: Blank Not acceptable

Edit Specs: Must be "0" or "1" Error if blank

Format: Numeric, 1 place

Updates: Implemented, FY2004