• Elements

  • Element: Person Name - Middle - 01094

Page Name

The individuals middle name.

In the event a student has more than one middle name, we will require just the first one. These submissions do not require a PERSON_DEMO table record unless a change is being made to a particular demographic element. SUDS will attempt to match the PERSON_ID submitted on all tables of these submissions to PERSON_DEMO information previously submitted according to the following scheme: HTD -- SIF CPC -- SIF LAP -- SIF then ADM TEF -- SIF SFA -- SIF SIFD -- SIF RET -- SIF



ELEMENT

201405

26-AUG-2015


Associated Submissions, Tables, and Columns

SubmissionAscendingTable NameColumn nameElement IDTab column idTable idSubmission name
Admissions (ADM)PERSON_DEMO (DEMO)NAME_MIDDLE104051001Admissions
Admissions (ADM)PERSON_DEMO (DEMO)NAME_MID_SOUNDEX104051001Admissions
Admissions (ADM)PERSON_ID_CHGS (IDC)NAME_MIDDLE1040510348Admissions
Admissions (ADM)PERSON_ID_CHGS (IDC)NAME_MID_SOUNDEX1040510348Admissions
College Prep (CP)PERSON_DEMO (DEMO)NAME_MIDDLE104051001College Prep
College Prep (CP)PERSON_DEMO (DEMO)NAME_MID_SOUNDEX104051001College Prep
College Prep (CP)PERSON_ID_CHGS (IDC)NAME_MIDDLE1040510348College Prep
College Prep (CP)PERSON_ID_CHGS (IDC)NAME_MID_SOUNDEX1040510348College Prep
College Prep Completions (CPC)PERSON_DEMO (DEMO)NAME_MIDDLE104051001College Prep Completions
College Prep Completions (CPC)PERSON_DEMO (DEMO)NAME_MID_SOUNDEX104051001College Prep Completions
  • 1 - 10

Allowed Values

Edit Values

Submission CodeAscendingTable nameDiagnostic CodeDiagnostic MessageError LevelError Description
ADMPERSON_DEMO0423Suffix, Name_Mi or Name_Middle contains invalid characters.9Critical Error: may cause submission to be rejected
ADMPERSON_ID_CHGS0423Suffix, Name_Mi or Name_Middle contains invalid characters.9Critical Error: may cause submission to be rejected
HTDPERSON_DEMO0423Suffix, Name_Mi or Name_Middle contains invalid characters.9Critical Error: may cause submission to be rejected
HTDPERSON_ID_CHGS0423Suffix, Name_Mi or Name_Middle contains invalid characters.9Critical Error: may cause submission to be rejected
IRDPERSON_ID_CHGS0423Suffix, Name_Mi or Name_Middle contains invalid characters.9Critical Error: may cause submission to be rejected
RETPERSON_DEMO0423Suffix, Name_Mi or Name_Middle contains invalid characters.9Critical Error: may cause submission to be rejected
RETPERSON_ID_CHGS0423Suffix, Name_Mi or Name_Middle contains invalid characters.9Critical Error: may cause submission to be rejected
SFAPERSON_DEMO0423Suffix, Name_Mi or Name_Middle contains invalid characters.9Critical Error: may cause submission to be rejected
SFAPERSON_ID_CHGS0423Suffix, Name_Mi or Name_Middle contains invalid characters.9Critical Error: may cause submission to be rejected
SIFPERSON_DEMO0423Suffix, Name_Mi or Name_Middle contains invalid characters.9Critical Error: may cause submission to be rejected
SIFPERSON_ID_CHGS0423Suffix, Name_Mi or Name_Middle contains invalid characters.9Critical Error: may cause submission to be rejected
SIFDPERSON_DEMO0423Suffix, Name_Mi or Name_Middle contains invalid characters.9Critical Error: may cause submission to be rejected
SIFDPERSON_ID_CHGS0423Suffix, Name_Mi or Name_Middle contains invalid characters.9Critical Error: may cause submission to be rejected
SIFPPERSON_DEMO0423Suffix, Name_Mi or Name_Middle contains invalid characters.9Critical Error: may cause submission to be rejected
SIFPPERSON_ID_CHGS0423Suffix, Name_Mi or Name_Middle contains invalid characters.9Critical Error: may cause submission to be rejected
TEIPERSON_DEMO0423Suffix, Name_Mi or Name_Middle contains invalid characters.9Critical Error: may cause submission to be rejected
TEIPERSON_ID_CHGS0423Suffix, Name_Mi or Name_Middle contains invalid characters.9Critical Error: may cause submission to be rejected
  • 1 - 17

Prior Database Information:

VARCHAR(14)
MNAME
NAME_MIDDLE
Release 2.0