• 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

Allowed Values

'..
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

Edit Values

Submission CodeAscending
Table name
Diagnostic Code
Diagnostic Message
Error Level
Error 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