FileSpecRules:201209EMSASDegreeCompletion
Item_Number Item_Name Collection_Rule_ID Severity Business_Rule Short_Title General_Message Detailed_Message
005 EMSAS File Type EMC00501 E FILETYPE must match '05' FILETYPE must match '05' The EMSAS File Type identifies the data contained within the file. For this collection, the EMSAS File Type must be '05' to identify the file as completion data.
005 EMSAS File Type EMC00502 E Field exceeds its maximum length Field exceeds its maximum length Field exceeds its maximum length. The {0} field exceeds its maximum allowable length of {1} character(s).
005 EMSAS File Type EMC00503 E Some fields supply data that is essential for the analysis of student data. The value of that field must be explicit. There are no default values. One or more required fields are missing Some fields supply data that is essential for the analysis of data. A value must be provided. There are no default values. The record is missing the field {0}.
005 EMSAS File Type EMC00504 E There must be at least one student record There are no student records There must be at least one student record.
010 FICE College Code EMC01001 E The FICECODE must match one of the valid values associated with the submitting orgainzation in the EMSAS_. Unexpected FICECODE The FICE College Code identifies the campus the student is attending. Only codes that are expected for your institution or system will be accepted. The accepted code(s) identifying your campus(es) is/are: {X},{Y},{Z}
015 Academic Term EMC01501 E ACTERM must be either '11', '21', '31', or '41' Invalid ACTERM ACTERM must be either '11' '21' '31' or '41'
020 Calendar Year EMC02001 W IF ACTERM is 11 or 21 then CALYEAR must match the current year-1. If ACTERM is 31 or 41 then CALYEAR must equal current year. Invalid CALYEAR CALYEAR must match the calendar year corresponding to the term type for this collection cycle. CALYEAR should be current year-1 for summer (ACTERM=11) and fall (ACTERM=21) and current year for winter (ACTERM=31) and spring (ACTERM=41). For example fall 20
025 SSN or Student ID (Primary) EMC02501 E If SSTAT1='1', SOCSEC1 must be a valid SSN according to SSA specifications. http://ssa-custhelp.ssa.gov/app/answers/detail/a_id/425/~/invalid-or-impossible-social-security-numbers Invalid SSN SSN is invalid.
030 Most Recent Social Security Number Status EMC03001 E Must be in code set: (EMSAS_Social_Security_Status_1_Codes). Invalid SSTAT1 code If the student's SOCSEC1 is believed to be a valid SSN, SSTAT1 should be '1'. If an alternate ID is used in SOCSEC1, then SSTAT1 should be '2'.
035 SSN or Student ID (Secondary) EMC03501 W If SSTAT2='1' then SOCSEC2 should match '000000000' Unexpected value for SOCSEC2 When SSTAT2 is reported as '1', that means the student is not believed to have previously used a different SSN than currently reported in SOCSEC1. It could also mean your institution has never previously identified the student using a bad SSN. In either c
035 SSN or Student ID (Secondary) EMC03502 W If SSTAT2='2' then SOCSEC2 should not match '000000000' Unexpected value for SOCSEC2 When SSTAT2 is reported as '2', that means the student is believed to have previously used a different SSN than currently reported in SOCSEC1. It could also mean your institution previously identified the student using a bad SSN. In either case, it is gen
040 Second Most Recent Social Security Number Status EMC04001 E Must be in code set: (EMSAS_Social_Security_Status_2_Codes). Invalid SSTAT2 code If the student's SOCSEC2 does not represent the second most recent SSN assigned to the student, SSTAT2 should be '1'. Please also use '1' if SOCSEC2 is zero-filled. If the SOCSEC2 does represent the student's second most recent SSN, then SSTAT2 should be
050 Gender EMC05001 E Must be in code set: (EMSAS_Gender) Invalid GENDER code GENDER must be 'M','F', or 'U'.
050 Gender EMC05002 W Percentage of records with GENDER='F' should not change by more than 10 percentage points from one Fall to the next. So, for example, if 50 percent of records submitted by School X last year had GENDER='F', we would not expect that percentage to be more t Unusual year-to-year change in GENDER distribution While some fluctuation in the male-female ratio is expected, deviations of 10 percentage points or more are unlikely and may indicate an underlying problem with the data.
055 Race / Ethnicity EMC05501 W Must be in code set: (EMSAS_Race_Codes). Invalid RACE code This field has been deprecated and replaced with RACEA-RACEH and therefore should be normally coded as 99 or a value which is found in the DHE Race Table. Variables RACEA-RACEH should contain at least one Y. Reported value of {1} should be coded as 99
060 Highest Degree Held EMC06001 E Must be in code set: (EMSAS_Degree Level) Invalid HIDEGREE code The Highest Degree Held must be one of the codes listed in the EMSAS Manual. Use '98' if it is not known whether the student already holds a degree.
065 Degree Level Sought EMC06501 E Must be in code set: (EMSAS_Degree Level) but excludes 98 and 99 Invalid DEGREEC code The Degree Level Sought must be one of the codes listed in the EMSAS Manual but may not be '99' or '98'.
065 Degree Level Sought EMC06502 E If submitting institution is a two-year college, only DEGREESTs in ('70','11','20','21','24','31','32','33','34','23','98','22') are valid Invalid DEGREEC code The Degree Level Sought must be one of the codes listed in the EMSAS Manual that correspond to undergraduate students. Use '98' if the student is non-degree-seeking or degree level sought is unknown.
070 First Major Field of Study CIP Code EMC07001 E Must be in one of the following tables/lists: (EMSAS_CIP2010), (EMSAS_CIP2000), ('900000','999999') Invalid PROGONE code The First Major Field of Study CIP Code must be a valid CIP code. If the student's major is undeclared, use '900000'
075 First Major Field of Study Option Code EMC07501 W Value should be coded as 9999 or be found in Program Option Code Table Unexpected PGONEOP value This field has been deprecated and therefore should be normally coded as 9999 or a value which is found in the DHE Program Inventory Option Code Table. Reported value of {1} should be coded as 9999
080 Second Major Field of Study CIP Code EMC08001 W Should be in one of the following tables/lists: (EMSAS_CIP2010), (EMSAS_CIP2000), ('900000','999999') Invalid PROGTWO code The Second Major Field of Study CIP Code should be a valid CIP code. If the student's major is undeclared, use '900000'
085 Second Major Field of Study Option Code EMC08501 W Value should be coded as 9999 or be found in Program Option Code Table Unexpected PGTWOOP value This field has been deprecated and therefore should be normally coded as 9999 or a value which is found in the DHE Program Inventory Option Code Table. Reported value of {1} should be coded as 9999
090 Student's Last Name EMC09001 W Should not start with a space (' ') or contain two consecutive spaces (' ') Unexpected LASTNAME Please verify the reported Last Name does not contain a typographical error.
095 Student's First Name EMC09501 W Should not start with a space (' ') or contain two consecutive spaces (' ') Unexpected FIRSTNAM Please verify the reported First Name does not contain a typographical error.
110 Date of Birth EMC11001 E DOBIRTH must either be a valid date (formatted as YYYYMMDD) or match '99999999' Invalid DOBIRTH The date of birth reported is invalid. Please supply a valid date if possible (YYYYMMDD format). If date of birth is not available, please use '99999999'
110 Date of Birth EMC11002 W DOBIRTH should not typically imply the student's age is under 13 or over 100 at time of enrollment. Unexpected DOBIRTH The date of birth reported is unexpected. Please verify the data. Based on reported date of birth, student appears to be {1} years old.
115 MOSIS ID EMC11501 W If field contains a value, the value should be found in the SID Master system Unexpected MOSIS ID The reported MOSIS ID could not be verified.
120 Hispanic / Latino Race / Ethnicity EMC12001 E Among the fields RACEA, RACEB, RACEC, RACED, RACEE, RACEF, RACEG, and RACEH, at least one must contain the value 'Y' No RACE provided At least one race field should contain a 'Y'. If race is unknown, please mark 'Y' in RACEH.
120 Hispanic / Latino Race / Ethnicity EMC12002 E Must be in code set: (Yes/No) Invalid RACEA Please use 'Y' or 'N' to indicate whether student is Hispanic / Latino. No other values are accepted for this field, and a response must be provided.
125 Non-Resident Alien Race / Ethnicity EMC12501 E Must be in code set: (Yes/No) Invalid RACEB Please use 'Y' or 'N' to indicate whether student is Non-Resident Alien. No other values are accepted for this field, and a response must be provided.
130 American Indian / Alaska Native Race / Ethnicity EMC13001 E Must be in code set: (Yes/No) Invalid RACEC Please use 'Y' or 'N' to indicate whether student is American Indian / Alaska Native. No other values are accepted for this field, and a response must be provided.
135 Asian Race / Ethnicity EMC13501 E Must be in code set: (Yes/No) Invalid RACED Please use 'Y' or 'N' to indicate whether student is Asian. No other values are accepted for this field, and a response must be provided.
140 Black / African American Race / Ethnicity EMC14001 E Must be in code set: (Yes/No) Invalid RACEE Please use 'Y' or 'N' to indicate whether student is Black / African American. No other values are accepted for this field, and a response must be provided.
145 Native Hawaiian / Other Pacific Islander Race / Ethnicity EMC14501 E Must be in code set: (Yes/No) Invalid RACEF Please use 'Y' or 'N' to indicate whether student is Native Hawaiian / Other Pacific Islander. No other values are accepted for this field, and a response must be provided.
150 White / Caucasian Race / Ethnicity EMC15001 E Must be in code set: (Yes/No) Invalid RACEG Please use 'Y' or 'N' to indicate whether student is White / Caucasian. No other values are accepted for this field, and a response must be provided.
155 Other / Unknown Race / Ethnicity EMC15501 E Must be in code set: (Yes/No) Invalid RACEH Please use 'Y' or 'N' to indicate whether student's race is Unknown or Other. No other values are accepted for this field, and a response must be provided.