Page Name

Legal date of birth.

For student reporting, code 9999-99-99 if the birth date is unknown. Required for reporting employees and OPS on SCD and EMPL.

Load programs on EMPLOYEE_DEMO will NULL value 9999-99-99.




ELEMENT

192001

09-SEP-2008


Associated Submissions, Tables, and Columns

SubmissionAscendingTable NameColumn nameElement IDTab column idTable idSubmission name
Admissions (ADM)PERSON_DEMO (DEMO)BIRTH_DT2628101Admissions
Admissions (ADM)PERSON_DEMO (DEMO)BIRTH_YYYYMM_DT2628101Admissions
Admissions (ADM)PERSON_DEMO (DEMO)DT_BIRTH_YYYYMMDD2628101Admissions
Admissions (ADM)PERSON_ID_CHGS (IDC)BIRTH_DT26281748Admissions
Admissions (ADM)PERSON_ID_CHGS (IDC)BIRTH_YYYYMM_DT26281748Admissions
Admissions (ADM)PERSON_ID_CHGS (IDC)DT_BIRTH_YYYYMMDD26281748Admissions
College Prep (CP)PERSON_DEMO (DEMO)BIRTH_DT2628101College Prep
College Prep (CP)PERSON_DEMO (DEMO)BIRTH_YYYYMM_DT2628101College Prep
College Prep (CP)PERSON_DEMO (DEMO)DT_BIRTH_YYYYMMDD2628101College Prep
College Prep (CP)PERSON_ID_CHGS (IDC)BIRTH_DT26281748College Prep
  • 1 - 10

Allowed Values

Edit Values

Submission CodeAscendingTable nameDiagnostic CodeDiagnostic MessageError LevelError Description
ADMPERSON_DEMO0295Birthdate is in the future9Critical Error: may cause submission to be rejected
ADMPERSON_DEMO0444Age is 14 or 155Warning: possible error that should be checked
ADMPERSON_DEMO06443rd digit of birth yr = 3rd digit of term yr 9Critical Error: may cause submission to be rejected
ADMPERSON_DEMO0645The Student's or Employee's Age is less than 149Critical Error: may cause submission to be rejected
ADMPERSON_DEMO0646The Individual's Age is over 805Warning: possible error that should be checked
ADMPERSON_DEMO1004Column should contain only numbers, is too short, or is null9Critical Error: may cause submission to be rejected
ADMPERSON_DEMO4062Frequency of Values for PERSON_DEMO.DT_BIRTH_YYYYMMDD0Frequency Distribution: not an indication of an error
ADMPERSON_ID_CHGS4063Frequency of Values for PERSON_ID_CHGS.DT_BIRTH_YYYYMMDD0Frequency Distribution: not an indication of an error
HTDPERSON_DEMO0295Birthdate is in the future9Critical Error: may cause submission to be rejected
HTDPERSON_DEMO0444Age is 14 or 155Warning: possible error that should be checked
HTDPERSON_DEMO06443rd digit of birth yr = 3rd digit of term yr 9Critical Error: may cause submission to be rejected
HTDPERSON_DEMO0645The Student's or Employee's Age is less than 149Critical Error: may cause submission to be rejected
HTDPERSON_DEMO0646The Individual's Age is over 805Warning: possible error that should be checked
HTDPERSON_DEMO1004Column should contain only numbers, is too short, or is null9Critical Error: may cause submission to be rejected
HTDPERSON_DEMO4062Frequency of Values for PERSON_DEMO.DT_BIRTH_YYYYMMDD0Frequency Distribution: not an indication of an error
HTDPERSON_ID_CHGS4063Frequency of Values for PERSON_ID_CHGS.DT_BIRTH_YYYYMMDD0Frequency Distribution: not an indication of an error
IRDPERSON_ID_CHGS4063Frequency of Values for PERSON_ID_CHGS.DT_BIRTH_YYYYMMDD0Frequency Distribution: not an indication of an error
RETPERSON_DEMO0295Birthdate is in the future9Critical Error: may cause submission to be rejected
RETPERSON_DEMO0444Age is 14 or 155Warning: possible error that should be checked
RETPERSON_DEMO06443rd digit of birth yr = 3rd digit of term yr 9Critical Error: may cause submission to be rejected
RETPERSON_DEMO0645The Student's or Employee's Age is less than 149Critical Error: may cause submission to be rejected
RETPERSON_DEMO0646The Individual's Age is over 805Warning: possible error that should be checked
RETPERSON_DEMO1004Column should contain only numbers, is too short, or is null9Critical Error: may cause submission to be rejected
RETPERSON_DEMO4062Frequency of Values for PERSON_DEMO.DT_BIRTH_YYYYMMDD0Frequency Distribution: not an indication of an error
RETPERSON_ID_CHGS4063Frequency of Values for PERSON_ID_CHGS.DT_BIRTH_YYYYMMDD0Frequency Distribution: not an indication of an error
SFAPERSON_DEMO0295Birthdate is in the future9Critical Error: may cause submission to be rejected
SFAPERSON_DEMO0444Age is 14 or 155Warning: possible error that should be checked
SFAPERSON_DEMO0645The Student's or Employee's Age is less than 149Critical Error: may cause submission to be rejected
SFAPERSON_DEMO0646The Individual's Age is over 805Warning: possible error that should be checked
SFAPERSON_DEMO1004Column should contain only numbers, is too short, or is null9Critical Error: may cause submission to be rejected
SFAPERSON_DEMO4062Frequency of Values for PERSON_DEMO.DT_BIRTH_YYYYMMDD0Frequency Distribution: not an indication of an error
SFAPERSON_ID_CHGS4063Frequency of Values for PERSON_ID_CHGS.DT_BIRTH_YYYYMMDD0Frequency Distribution: not an indication of an error
SIFPERSON_DEMO0295Birthdate is in the future9Critical Error: may cause submission to be rejected
SIFPERSON_DEMO0444Age is 14 or 155Warning: possible error that should be checked
SIFPERSON_DEMO06443rd digit of birth yr = 3rd digit of term yr 9Critical Error: may cause submission to be rejected
SIFPERSON_DEMO0645The Student's or Employee's Age is less than 149Critical Error: may cause submission to be rejected
SIFPERSON_DEMO0646The Individual's Age is over 805Warning: possible error that should be checked
SIFPERSON_DEMO1004Column should contain only numbers, is too short, or is null9Critical Error: may cause submission to be rejected
SIFPERSON_DEMO4062Frequency of Values for PERSON_DEMO.DT_BIRTH_YYYYMMDD0Frequency Distribution: not an indication of an error
SIFPERSON_ID_CHGS4063Frequency of Values for PERSON_ID_CHGS.DT_BIRTH_YYYYMMDD0Frequency Distribution: not an indication of an error
SIFDPERSON_DEMO0295Birthdate is in the future9Critical Error: may cause submission to be rejected
SIFDPERSON_DEMO0444Age is 14 or 155Warning: possible error that should be checked
SIFDPERSON_DEMO06443rd digit of birth yr = 3rd digit of term yr 9Critical Error: may cause submission to be rejected
SIFDPERSON_DEMO0645The Student's or Employee's Age is less than 149Critical Error: may cause submission to be rejected
SIFDPERSON_DEMO0646The Individual's Age is over 805Warning: possible error that should be checked
SIFDPERSON_DEMO1004Column should contain only numbers, is too short, or is null9Critical Error: may cause submission to be rejected
SIFDPERSON_DEMO4062Frequency of Values for PERSON_DEMO.DT_BIRTH_YYYYMMDD0Frequency Distribution: not an indication of an error
SIFPPERSON_DEMO0295Birthdate is in the future9Critical Error: may cause submission to be rejected
SIFPPERSON_DEMO0444Age is 14 or 155Warning: possible error that should be checked
SIFPPERSON_DEMO06443rd digit of birth yr = 3rd digit of term yr 9Critical Error: may cause submission to be rejected
  • 1 - 50

Prior Database Information:

DATE
DTBIRTH
DATE_OF_BIRTH