• Elements

  • Element: Degree - Highest Level Held - 01112

Page Name

The highest educational degree, certificate or diploma held by the individual.

Student reporting ***********************************************
Valid codes are: G,H,U,A,B,C,D,E,F,L,M,O,P,R,S,V,W,X,N and Z. There is a 5% tolerance allowed for code Z (Not Reported) on the ENROLLMENTS table of SIF and the APPLICANTS_ADMITS table for ADM. The code reported here should be the highest degree, certificate or diploma held by the student at the beginning of the term being reported.

EMPLOYEE_DEMO **********************************************
This element is required on all employees.

Load programs on APPLICANTS_ADMITS, EMPLOYEE_DEMO, and ENROLLMENTS tables will NULL value when 'Z' (not reported).



ELEMENT

192001

13-OCT-2020


Associated Submissions, Tables, and Columns

SubmissionAscendingTable NameColumn nameElement IDTab column idTable idSubmission name
Admissions (ADM)APPLICANTS_ADMITS (ADMA)DEG_HIGHEST_HELD16223053Admissions
Degrees Awarded (SIFD)ENROLLMENTS (ENRL)DEG_HIGHEST_HELD16226378Degrees Awarded
Hours to Degree (HTD)ENROLLMENTS (ENRL)DEG_HIGHEST_HELD16226378Hours to Degree
Hours to Degree (HTD)HOURS_TO_DEGREE (HTD)DEG_HIGHEST_HELD162511715Hours to Degree
Limited Access Programs (LAP)APPLICANTS_ADMITS (ADMA)DEG_HIGHEST_HELD16223053Limited Access Programs
Salary Category Detail (SCD)EMPLOYEE_DEMO (EDEM)DEG_HIGHEST_HELD162167329Salary Category Detail
Student Financial Aid (SFA)ENROLLMENTS (ENRL)DEG_HIGHEST_HELD16226378Student Financial Aid
Student Instruction (SIF)ENROLLMENTS (ENRL)DEG_HIGHEST_HELD16226378Student Instruction
Student Instruction Preliminary (SIFP)ENROLLMENTS (ENRL)DEG_HIGHEST_HELD16226378Student Instruction Preliminary
Teacher Education (TEF)APPLICANTS_ADMITS (ADMA)DEG_HIGHEST_HELD16223053Teacher Education
  • 1 - 10

Allowed Values

Excel code
Code
Description
Grouping
'..
MISSING		-
'AAAssociate in Arts (AA)
Postsecondary Level Undergraduate Degree Codes
'BBBaccalaureate
Postsecondary Level Undergraduate Degree Codes
'CCAssociate in Science (AS)
Postsecondary Level Undergraduate Degree Codes
'DDDoctorate (Was = D Other Doc and H Educ Prior 1994-95)
Postsecondary Level Graduate Degree Codes
'EEAdvanced Masters
Postsecondary Level Graduate Degree Codes
'FFDentistry, DDS or DMD
Postsecondary Level Graduate Degree Codes
'GGGED
High School Level Degree Codes
'HHHigh School Diploma (Was = I and H Prior 1994-95)
High School Level Degree Codes
'JJAssociate Degree (Used When AA/AS Is Not Known)
Postsecondary Level Undergraduate Degree Codes
'LLLaw, LLB or JD
Postsecondary Level Graduate Degree Codes
'MMMasters
Postsecondary Level Graduate Degree Codes
'NNNo Degree
Other
'OOOther
Postsecondary Level Graduate Degree Codes
'PPFirst Professional (Other Than F, L, V, W or X)
Postsecondary Level Graduate Degree Codes
'RREngineer (Was = G Prior to 1994-95)
Postsecondary Level Graduate Degree Codes
'SSSpecialist
Postsecondary Level Graduate Degree Codes
'UUCollege-Ready High School Diploma
High School Level Degree Codes
'VVVeterinary Medicine, DVM
Postsecondary Level Graduate Degree Codes
'WWPharmacy (PharmD)
Postsecondary Level Graduate Degree Codes
'XXMedicine, MD
Postsecondary Level Graduate Degree Codes
'ZZNot Reported (Was = Z and X Prior to 1994-95)
Other
Download

Edit Values

Submission CodeAscendingTable nameDiagnostic CodeDiagnostic MessageError LevelError Description
ADMAPPLICANTS_ADMITS0005Invalid Value9Critical Error: may cause submission to be rejected
ADMAPPLICANTS_ADMITS0007Missing8Allowable Tolerance: a 9-level critical error will be generated if the error occurs at a rate above the allowable level
ADMAPPLICANTS_ADMITS4026Frequency of Values for APPLICANTS_ADMITS.DEG_HIGHEST_HELD0Frequency Distribution: not an indication of an error
ADMAPPLICANTS_ADMITS5807Tolerance exceeded for missing value9Critical Error: may cause submission to be rejected
ADMAPPLICANTS_ADMITS6116DEG_HIGHEST_HELD is nulled if DEG_HIGHEST_HELD= 'Z' 1Generated or Modified during SUDS Edit Process
EMPLEMPLOYEE_DEMO4061Frequency of Values for EMPLOYEE_DEMO.DEG_HIGHEST_HELD0Frequency Distribution: not an indication of an error
EMPLEMPLOYEE_DEMO5415Missing or Invalid9Critical Error: may cause submission to be rejected
EMPLEMPLOYEE_DEMO5418Degree - Highest Level Held (01112) cannot be equal to 'Z' for faculty records.9Critical Error: may cause submission to be rejected
HTDHOURS_TO_DEGREE4137Frequency of Values for HOURS_TO_DEGREE.DEG_HIGHEST_HELD0Frequency Distribution: not an indication of an error
HTDHOURS_TO_DEGREE5364Deg_Highest_Held must match the Deg_Highest_Held reported on Enrollments by SIF/SIFD for the term the degree was reported.9Critical Error: may cause submission to be rejected
SCDEMPLOYEE_DEMO4061Frequency of Values for EMPLOYEE_DEMO.DEG_HIGHEST_HELD0Frequency Distribution: not an indication of an error
SFAENROLLMENTS0005Invalid Value9Critical Error: may cause submission to be rejected
SFAENROLLMENTS6118DEG_HIGHEST_HELD is nulled if DEG_HIGHEST_HELD= 'Z' 1Generated or Modified during SUDS Edit Process
SIFENROLLMENTS0005Invalid Value9Critical Error: may cause submission to be rejected
SIFENROLLMENTS0007Missing8Allowable Tolerance: a 9-level critical error will be generated if the error occurs at a rate above the allowable level
SIFENROLLMENTS4060Frequency of Values for ENROLLMENTS.DEG_HIGHEST_HELD0Frequency Distribution: not an indication of an error
SIFENROLLMENTS5807Tolerance exceeded for missing value9Critical Error: may cause submission to be rejected
SIFENROLLMENTS6118DEG_HIGHEST_HELD is nulled if DEG_HIGHEST_HELD= 'Z' 1Generated or Modified during SUDS Edit Process
SIFINSTRUCTIONAL_ACTIVITY5807Tolerance exceeded for missing value9Critical Error: may cause submission to be rejected
SIFDENROLLMENTS0005Invalid Value9Critical Error: may cause submission to be rejected
SIFDENROLLMENTS6118DEG_HIGHEST_HELD is nulled if DEG_HIGHEST_HELD= 'Z' 1Generated or Modified during SUDS Edit Process
SIFPENROLLMENTS0005Invalid Value9Critical Error: may cause submission to be rejected
SIFPENROLLMENTS0007Missing8Allowable Tolerance: a 9-level critical error will be generated if the error occurs at a rate above the allowable level
SIFPENROLLMENTS4060Frequency of Values for ENROLLMENTS.DEG_HIGHEST_HELD0Frequency Distribution: not an indication of an error
SIFPENROLLMENTS5807Tolerance exceeded for missing value9Critical Error: may cause submission to be rejected
SIFPENROLLMENTS6118DEG_HIGHEST_HELD is nulled if DEG_HIGHEST_HELD= 'Z' 1Generated or Modified during SUDS Edit Process
  • 1 - 26

Prior Database Information:

VARCHAR2(1)
DEGHELD
DEG_HIGHEST_HELD
Release 2.0