• Elements
  • Element: Person Name - Last - 01033

Page Name

The individual's last name or surname.

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

192001

11-SEP-2008


Associated Submissions, Tables, and Columns

SubmissionAscendingTable NameColumn nameElement IDTab column idTable idSubmission name
Admissions (ADM)PERSON_DEMO (DEMO)NAME_LAST3021951Admissions
Admissions (ADM)PERSON_DEMO (DEMO)NAME_LAST_SOUNDEX3021951Admissions
Admissions (ADM)PERSON_ID_CHGS (IDC)NAME_LAST303348Admissions
Admissions (ADM)PERSON_ID_CHGS (IDC)NAME_LAST_SOUNDEX303348Admissions
College Prep (CP)PERSON_DEMO (DEMO)NAME_LAST3021951College Prep
College Prep (CP)PERSON_DEMO (DEMO)NAME_LAST_SOUNDEX3021951College Prep
College Prep (CP)PERSON_ID_CHGS (IDC)NAME_LAST303348College Prep
College Prep (CP)PERSON_ID_CHGS (IDC)NAME_LAST_SOUNDEX303348College Prep
College Prep Completions (CPC)PERSON_DEMO (DEMO)NAME_LAST3021951College Prep Completions
College Prep Completions (CPC)PERSON_DEMO (DEMO)NAME_LAST_SOUNDEX3021951College Prep Completions
  • 1 - 10

Allowed Values

Edit Values

Submission CodeAscendingTable nameDiagnostic CodeDiagnostic MessageError LevelError Description
ADMPERSON_DEMO0573Name missing or contains invalid characters9Critical Error: may cause submission to be rejected
EMPLEMPLOYEE_DEMO0573Name missing or contains invalid characters9Critical Error: may cause submission to be rejected
HTDPERSON_DEMO0573Name missing or contains invalid characters9Critical Error: may cause submission to be rejected
IRDWORKLOAD_PERSON_FUNDING0573Name missing or contains invalid characters9Critical Error: may cause submission to be rejected
RETPERSON_DEMO0573Name missing or contains invalid characters9Critical Error: may cause submission to be rejected
SCDEMPLOYEE_DEMO0573Name missing or contains invalid characters9Critical Error: may cause submission to be rejected
SFAPERSON_DEMO0573Name missing or contains invalid characters9Critical Error: may cause submission to be rejected
SIFPERSON_DEMO0573Name missing or contains invalid characters9Critical Error: may cause submission to be rejected
SIFDPERSON_DEMO0573Name missing or contains invalid characters9Critical Error: may cause submission to be rejected
SIFPPERSON_DEMO0573Name missing or contains invalid characters9Critical Error: may cause submission to be rejected
TEIPERSON_DEMO0573Name missing or contains invalid characters9Critical Error: may cause submission to be rejected
  • 1 - 11

Prior Database Information:

VARCHAR2(22)
LNAME
LAST_NAME