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

Allowed Values

Edit Values

Submission CodeAscending
Table name
Diagnostic Code
Diagnostic Message
Error Level
Error 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