• Elements

  • Element: National Merit Scholar Indicator - 01407

Page Name

A flag to indicate if an undergraduate student has received a National Merit, National Achievement or National Hispanic award.

Valid code required on all undergraduate students. If a student receives multiple awards choose the one with the highest applicable value. The element is not required for unclassifed or graduate students (STU_CLASS_LEVEL 01060=A,B,N) and will not generate an error if it is blank.
If the element is coded for non-required students, it will be edited for a valid code.

Load programs on the ENROLLMENTS table will NULL value when BLANK or '.' AND STU_CLASS_LEVEL (01060 not 'L' or 'U').



ELEMENT

192001

15-SEP-2008


Associated Submissions, Tables, and Columns

SubmissionAscendingTable NameColumn nameElement IDTab column idTable idSubmission name
Degrees Awarded (SIFD)ENROLLMENTS (ENRL)NAT_MERIT_SCH_IND23925978Degrees Awarded
Hours to Degree (HTD)ENROLLMENTS (ENRL)NAT_MERIT_SCH_IND23925978Hours to Degree
Student Financial Aid (SFA)ENROLLMENTS (ENRL)NAT_MERIT_SCH_IND23925978Student Financial Aid
Student Instruction (SIF)ENROLLMENTS (ENRL)NAT_MERIT_SCH_IND23925978Student Instruction
Student Instruction Preliminary (SIFP)ENROLLMENTS (ENRL)NAT_MERIT_SCH_IND23925978Student Instruction Preliminary
  • 1 - 5

Allowed Values

Excel code
Code
Description
Grouping
'..
MISSING		-
'00Not National Merit or Achievement or Hispanic Scholarship Recipient, Finalist or Semi-Finalist
Scholarship Recipient, Finalist or Semi-Finalist
'11National Hispanic Scholar Semi-Finalist
'22National Hispanic Scholar Finalist
'33National Hispanic Scholar Recipient
'44National Achievement Scholar Semi-Finalist
'55National Merit Scholar Semi-Finalist
'66National Achievement Scholar Finalist
'77National Merit Scholar Finalist
'88National Achievement Scholar Recipient
'99National Merit Scholar Recipient
Download

Edit Values

Submission CodeAscendingTable nameDiagnostic CodeDiagnostic MessageError LevelError Description
SFAENROLLMENTS0005Invalid Value9Critical Error: may cause submission to be rejected
SFAENROLLMENTS0658National Merit Scholar Indicator is not numeric and Student Classification Level is L, or U.9Critical Error: may cause submission to be rejected
SFAENROLLMENTS4150Frequency of Values for ENROLLMENTS.NAT_MERIT_SCH_IND0Frequency Distribution: not an indication of an error
SIFENROLLMENTS0005Invalid Value9Critical Error: may cause submission to be rejected
SIFENROLLMENTS0658National Merit Scholar Indicator is not numeric and Student Classification Level is L, or U.9Critical Error: may cause submission to be rejected
SIFENROLLMENTS4150Frequency of Values for ENROLLMENTS.NAT_MERIT_SCH_IND0Frequency Distribution: not an indication of an error
SIFDENROLLMENTS0005Invalid Value9Critical Error: may cause submission to be rejected
SIFDENROLLMENTS0658National Merit Scholar Indicator is not numeric and Student Classification Level is L, or U.9Critical Error: may cause submission to be rejected
SIFDENROLLMENTS4150Frequency of Values for ENROLLMENTS.NAT_MERIT_SCH_IND0Frequency Distribution: not an indication of an error
SIFPENROLLMENTS4150Frequency of Values for ENROLLMENTS.NAT_MERIT_SCH_IND0Frequency Distribution: not an indication of an error
SIFPENROLLMENTS6142NAT_MERIT_SCH_IND is nulled if DEMO_DATA_SOURCE = 'SIFP' 1Generated or Modified during SUDS Edit Process
  • 1 - 11

Prior Database Information:

VARCHAR2(1)
NATMERIT
NAT_MERIT_SCH_IND
Release 2.0