Page Name

Description:

A code by which the high school, if in Florida, can be identified for those students who at their first entry to the institution were coming from a high school. The code is that used by ACT/ETS/CEEB.

Coding Instructions:

This element is required only if
1) Student's Date of Entry (01064) is more recent than 197309
2) Type of Student at Date of Entry (01068) is B,H or E.

Code the appropriate high school code from those listed in the table values section. Code 'XXXXXX' may be used for students who received a GED degree which was not associated with a particular high school. If the student received a GED degree from a Florida institution which appears in the table values section, use the code designated for that institution. Code '999999' or '.' for students who graduated from a Florida high school not listed in the table values or if the school from which the student graduated is unknown.

Load programs on APPLICANTS_ADMITS and ENROLLMENTS tables will NULL values '999999' or '.'.

Algorithm:

Usage Type:

ELEMENT

Begin Term:

192001

End Term:

Last Modified:

10-SEP-2008

SubmissionAscending	Table Name	Column name	Element ID	Tab column id	Table id	Submission name
Admissions (ADM)	APPLICANTS_ADMITS (ADMA)	HS_ETS_CD	57	2311	3	Admissions
Degrees Awarded (SIFD)	ENROLLMENTS (ENRL)	HS_ETS_CD	57	2603	8	Degrees Awarded
Hours to Degree (HTD)	ENROLLMENTS (ENRL)	HS_ETS_CD	57	2603	8	Hours to Degree
Limited Access Programs (LAP)	APPLICANTS_ADMITS (ADMA)	HS_ETS_CD	57	2311	3	Limited Access Programs
Student Financial Aid (SFA)	ENROLLMENTS (ENRL)	HS_ETS_CD	57	2603	8	Student Financial Aid
Student Instruction (SIF)	ENROLLMENTS (ENRL)	HS_ETS_CD	57	2603	8	Student Instruction
Student Instruction Preliminary (SIFP)	ENROLLMENTS (ENRL)	HS_ETS_CD	57	2603	8	Student Instruction Preliminary
Teacher Education (TEF)	APPLICANTS_ADMITS (ADMA)	HS_ETS_CD	57	2311	3	Teacher Education

1 - 8

Submission CodeAscending	Table name	Diagnostic Code	Diagnostic Message	Error Level	Error Description
ADM	APPLICANTS_ADMITS	0021	For Student Type 'B', 'H' OR 'E' and High School Code = 'XXXXXX', then Highest Degree Held must be 'G'(GED) OR 'N'(No Degree)	9	Critical Error: may cause submission to be rejected
ADM	APPLICANTS_ADMITS	0162	If Student Type 'B', 'H','E' or 'F', then High School Code cannot be '.'	9	Critical Error: may cause submission to be rejected
ADM	APPLICANTS_ADMITS	0700	Invalid Value (TERM_END is ignored for submissions 200905 and later)	9	Critical Error: may cause submission to be rejected
ADM	APPLICANTS_ADMITS	4210	Frequency of Values for APPLICANTS_ADMITS.HS_ETS_CD	0	Frequency Distribution: not an indication of an error
SFA	ENROLLMENTS	0162	If Student Type 'B', 'H','E' or 'F', then High School Code cannot be '.'	9	Critical Error: may cause submission to be rejected
SFA	ENROLLMENTS	0700	Invalid Value (TERM_END is ignored for submissions 200905 and later)	9	Critical Error: may cause submission to be rejected
SFA	ENROLLMENTS	0706	When HS_ETS_CD is missing the LAST_SECONDARY_DT must be missing	9	Critical Error: may cause submission to be rejected
SFA	ENROLLMENTS	4253	Frequency of Values for ENROLLMENTS.HS_TES_CD	0	Frequency Distribution: not an indication of an error
SIF	ENROLLMENTS	0162	If Student Type 'B', 'H','E' or 'F', then High School Code cannot be '.'	9	Critical Error: may cause submission to be rejected
SIF	ENROLLMENTS	0700	Invalid Value (TERM_END is ignored for submissions 200905 and later)	9	Critical Error: may cause submission to be rejected
SIF	ENROLLMENTS	0706	When HS_ETS_CD is missing the LAST_SECONDARY_DT must be missing	9	Critical Error: may cause submission to be rejected
SIF	ENROLLMENTS	4253	Frequency of Values for ENROLLMENTS.HS_TES_CD	0	Frequency Distribution: not an indication of an error
SIFD	ENROLLMENTS	0162	If Student Type 'B', 'H','E' or 'F', then High School Code cannot be '.'	9	Critical Error: may cause submission to be rejected
SIFD	ENROLLMENTS	0700	Invalid Value (TERM_END is ignored for submissions 200905 and later)	9	Critical Error: may cause submission to be rejected
SIFD	ENROLLMENTS	0706	When HS_ETS_CD is missing the LAST_SECONDARY_DT must be missing	9	Critical Error: may cause submission to be rejected
SIFD	ENROLLMENTS	4253	Frequency of Values for ENROLLMENTS.HS_TES_CD	0	Frequency Distribution: not an indication of an error
SIFP	ENROLLMENTS	0162	If Student Type 'B', 'H','E' or 'F', then High School Code cannot be '.'	9	Critical Error: may cause submission to be rejected
SIFP	ENROLLMENTS	0700	Invalid Value (TERM_END is ignored for submissions 200905 and later)	9	Critical Error: may cause submission to be rejected
SIFP	ENROLLMENTS	0706	When HS_ETS_CD is missing the LAST_SECONDARY_DT must be missing	9	Critical Error: may cause submission to be rejected
SIFP	ENROLLMENTS	4253	Frequency of Values for ENROLLMENTS.HS_TES_CD	0	Frequency Distribution: not an indication of an error

1 - 20

Physical Description:

VARCHAR2(6)

Short Name:

HSCODE

Column Name:

HIGH_SCHOOL_CODE

Page Name

Associated Submissions, Tables, and Columns

Allowed High Schools

Edit Values

Prior Database Information:

Element: High School Code - 01069

Page Name

Associated Submissions, Tables, and Columns

Allowed High Schools

Edit Values

Prior Database Information: