• Elements

  • Element: Non-resident Alien Flag - 02043

Page Name

Non-resident Alien Flag

This expression of Race/Ethnicity under NCES rules is not required until 201005 (Summer 2010 reporting).

SUDS will accept this expression beginning with 200905 (Summer 2009 reporting). Until then load programs on PERSON_DEMO will value '.'.

If the institution chooses to use this expression prior to required date then 'Y' or 'N' should be coded. When this expression is not used, code '.'.



ELEMENT

192001

30-MAR-2009


Associated Submissions, Tables, and Columns

SubmissionAscendingTable NameColumn nameElement IDTab column idTable idSubmission name
Admissions (ADM)PERSON_DEMO (DEMO)NON_RES_ALIEN_FLG53022191Admissions
Admissions (ADM)PERSON_ID_CHGS (IDC)NON_RES_ALIEN_FLG530282148Admissions
College Prep (CP)PERSON_DEMO (DEMO)NON_RES_ALIEN_FLG53022191College Prep
College Prep (CP)PERSON_ID_CHGS (IDC)NON_RES_ALIEN_FLG530282148College Prep
College Prep Completions (CPC)PERSON_DEMO (DEMO)NON_RES_ALIEN_FLG53022191College Prep Completions
College Prep Completions (CPC)PERSON_ID_CHGS (IDC)NON_RES_ALIEN_FLG530282148College Prep Completions
Degrees Awarded (SIFD)PERSON_DEMO (DEMO)NON_RES_ALIEN_FLG53022191Degrees Awarded
Degrees Awarded (SIFD)PERSON_ID_CHGS (IDC)NON_RES_ALIEN_FLG530282148Degrees Awarded
Hours to Degree (HTD)PERSON_DEMO (DEMO)NON_RES_ALIEN_FLG53022191Hours to Degree
Hours to Degree (HTD)PERSON_ID_CHGS (IDC)NON_RES_ALIEN_FLG530282148Hours to Degree
  • 1 - 10

Allowed Values

Excel code
Code
Description
Grouping
'..
MISSING		-
'NNNo
No		-
'YYYes
Yes		-
Download

Edit Values

Submission CodeAscendingTable nameDiagnostic CodeDiagnostic MessageError LevelError Description
ADMPERSON_DEMO0008Missing or Invalid Value9Critical Error: may cause submission to be rejected
ADMPERSON_DEMO4290Frequency of Values for PERSON_DEMO.NON_RES_ALIEN_FLG0Frequency Distribution: not an indication of an error
ADMPERSON_DEMO5316When the NON_RES_ALIEN_FLG equals 'Y' the FEE_CLASS_RES must equal A or T.9Critical Error: may cause submission to be rejected
ADMPERSON_ID_CHGS0005Invalid Value9Critical Error: may cause submission to be rejected
ADMPERSON_ID_CHGS4289Frequency of Values for PERSON_ID_CHGS.NON_RES_ALIEN_FLG0Frequency Distribution: not an indication of an error
EMPLEMPLOYEE_DEMO0008Missing or Invalid Value9Critical Error: may cause submission to be rejected
HTDPERSON_DEMO0008Missing or Invalid Value9Critical Error: may cause submission to be rejected
HTDPERSON_DEMO4290Frequency of Values for PERSON_DEMO.NON_RES_ALIEN_FLG0Frequency Distribution: not an indication of an error
HTDPERSON_ID_CHGS4289Frequency of Values for PERSON_ID_CHGS.NON_RES_ALIEN_FLG0Frequency Distribution: not an indication of an error
IRDPERSON_ID_CHGS4289Frequency of Values for PERSON_ID_CHGS.NON_RES_ALIEN_FLG0Frequency Distribution: not an indication of an error
RETPERSON_DEMO0008Missing or Invalid Value9Critical Error: may cause submission to be rejected
RETPERSON_DEMO4290Frequency of Values for PERSON_DEMO.NON_RES_ALIEN_FLG0Frequency Distribution: not an indication of an error
RETPERSON_ID_CHGS4289Frequency of Values for PERSON_ID_CHGS.NON_RES_ALIEN_FLG0Frequency Distribution: not an indication of an error
SCDEMPLOYEE_DEMO0008Missing or Invalid Value9Critical Error: may cause submission to be rejected
SFAPERSON_DEMO0008Missing or Invalid Value9Critical Error: may cause submission to be rejected
SFAPERSON_DEMO4290Frequency of Values for PERSON_DEMO.NON_RES_ALIEN_FLG0Frequency Distribution: not an indication of an error
SFAPERSON_ID_CHGS4289Frequency of Values for PERSON_ID_CHGS.NON_RES_ALIEN_FLG0Frequency Distribution: not an indication of an error
SIFPERSON_DEMO0008Missing or Invalid Value9Critical Error: may cause submission to be rejected
SIFPERSON_DEMO4290Frequency of Values for PERSON_DEMO.NON_RES_ALIEN_FLG0Frequency Distribution: not an indication of an error
SIFPERSON_DEMO5316When the NON_RES_ALIEN_FLG equals 'Y' the FEE_CLASS_RES must equal A or T.9Critical Error: may cause submission to be rejected
SIFPERSON_ID_CHGS4289Frequency of Values for PERSON_ID_CHGS.NON_RES_ALIEN_FLG0Frequency Distribution: not an indication of an error
SIFDPERSON_DEMO0008Missing or Invalid Value9Critical Error: may cause submission to be rejected
SIFDPERSON_DEMO4290Frequency of Values for PERSON_DEMO.NON_RES_ALIEN_FLG0Frequency Distribution: not an indication of an error
SIFDPERSON_ID_CHGS4289Frequency of Values for PERSON_ID_CHGS.NON_RES_ALIEN_FLG0Frequency Distribution: not an indication of an error
SIFPPERSON_DEMO0008Missing or Invalid Value9Critical Error: may cause submission to be rejected
SIFPPERSON_DEMO4290Frequency of Values for PERSON_DEMO.NON_RES_ALIEN_FLG0Frequency Distribution: not an indication of an error
SIFPPERSON_DEMO5316When the NON_RES_ALIEN_FLG equals 'Y' the FEE_CLASS_RES must equal A or T.9Critical Error: may cause submission to be rejected
SIFPPERSON_ID_CHGS4289Frequency of Values for PERSON_ID_CHGS.NON_RES_ALIEN_FLG0Frequency Distribution: not an indication of an error
TEIPERSON_DEMO0008Missing or Invalid Value9Critical Error: may cause submission to be rejected
TEIPERSON_DEMO4290Frequency of Values for PERSON_DEMO.NON_RES_ALIEN_FLG0Frequency Distribution: not an indication of an error
TEIPERSON_ID_CHGS4289Frequency of Values for PERSON_ID_CHGS.NON_RES_ALIEN_FLG0Frequency Distribution: not an indication of an error
  • 1 - 31

Prior Database Information:

VARCHAR(1)
NR_ALFLG
NON_RES_ALIEN_FLG
Release 2.0