Page Name

Description:

A Board of Governors derived field that identifies a degree-seeking student's first term of enrollment at their native institution as reported on the Courses to Degree table of the HTD submission. For all FTIC (including those that are readmitted), this derived element is based on the minimum enrolled term that is greater than or equal to the student's entry date. For all other students, it is based on the minimum enrolled term that is greater than or equal to the student's recent admit date.

Coding Instructions:

N/A - This is a derived field.

Algorithm:

The minimum TERM_TAKEN (#01051) for each student on the COURSES_TO_DEGREE table is limited to enrollment at the native institution (CRS_SYSTEM #01484 = 'N') and those classes that are Academic Courses (CRS_GROUP #01485 = 'A'). Classes taken as Unclassified (STU_CLASS_LEVEL #01483 = 'N') are excluded. For all first-time in college students (FTIC), including those who have been readmitted (where STU_ENTRY_TYP #01068 and STU_RECENT_ADM_TYP #01413 are both 'B' or 'E'), the first enrolled term is calculated as the minimum enrolled term greater than or equal to the student entry date (STU_ENTRY_DT #01064). For all other students, the first enrolled term is calculated as the minimum enrolled term that is greater than or equal to the student recent admit date (STU_RECENT_ADM_DT #01420).

Usage Type:

DERIVED

Begin Term:

201705

End Term:

Last Modified:

28-AUG-2018

SubmissionAscending	Table Name	Column name	Element ID	Tab column id	Table id	Submission name
Hours to Degree (HTD)	HOURS_TO_DEGREE (HTD)	FIRST_ENRL_TERM	1072	5239	15	Hours to Degree

1 - 1

Submission CodeAscending	Table name	Diagnostic Code	Diagnostic Message	Error Level	Error Description
HTD	HOURS_TO_DEGREE	0861	The derived field, first enrolled term (#10076), should not be missing for first-time in college students (FTIC), defined as those with recent admit types of Beginner - FTIC 'B' or Early Admit, Prior to High School Graduation 'E'.	9	Critical Error: may cause submission to be rejected
HTD	HOURS_TO_DEGREE	6026	A Board of Governors derived field that identifies a degree-seeking student's first term of enrollment at their native institution as reported on the Courses to Degree table of the HTD submission. For all FTIC (including those that are readmitted), this derived element is based on the minimum enrolled term that is greater than or equal to the student's entry date. For all other students, it is based on the minimum enrolled term that is greater than or equal to the student's recent admit date.	1	Generated or Modified during SUDS Edit Process

1 - 2

Physical Description:

VARCHAR2(6)

Short Name:

FRENRLTM

Column Name:

FIRST_ENRL_TERM

Page Name

Associated Submissions, Tables, and Columns

Allowed Values

Edit Values

Prior Database Information:

Element: First Enrl Term - 10076

Page Name

Associated Submissions, Tables, and Columns

Allowed Values

Edit Values

Prior Database Information: