• Elements
  • Element: Person Id Valid - 02017

Page Name

Indicates whether the student/applicant's identification number conforms to the Social Security Number format.

Code 'Y' if PERSON_ID conforms to the to the Social Security Number format based on the following logic. This value does not mean that the university has specifically validated this number with the Social Security Administration.

Code 'N' if PERSON_ID does not conform to the to the Social Security Number format based on the following logic. This value does not mean that the university has specifically validated this number with the Social Security Administration.

We expect a Y/N for each record. In the rare case that you cannot assign a Y/N, then report missing ('.'). We will set a tolerance that is triggered if missing reaches 0.5% of the records for any submission.

Whether a number conforms to the standard Social Security Number format is based on the following rules:
Valid numbers must be exactly nine digits long and contain only numbers.
Valid numbers will not begin with the number 9.
Valid numbers will not begin with the numbers 000 or 666 in positions 1 - 3.
Valid numbers will not use the number 00 in positions 4 - 5.
Valid numbers will not use the number 0000 in positions 6 - 9
Valid numbers will not be any of 111111111, 222222222, 333333333, 444444444, 555555555, 666666666, 777777777, 888888888, 078051120, 219099999, or 123456789




ELEMENT

192001

10-JUN-2022


Associated Submissions, Tables, and Columns

Allowed Values

'..
MISSING
-
'NNNo
No
-
'YYYes
Yes
-

Edit Values

Submission CodeAscending
Table name
Diagnostic Code
Diagnostic Message
Error Level
Error Description
ADMPERSON_DEMO0005Invalid Value9Critical Error: may cause submission to be rejected
ADMPERSON_DEMO0782PID_VALID_SSN must equal 'N' when PERSON_ID_ENC is not numeric.9Critical Error: may cause submission to be rejected
ADMPERSON_DEMO4269Frequency of Values for PERSON_DEMO.PID_VALID_SSN0Frequency Distribution: not an indication of an error
ADMPERSON_DEMO5319More than 5% of students that are not Non-resident aliens have a PID_VALID_SSN value of N9Critical Error: may cause submission to be rejected
ADMPERSON_ID_CHGS0005Invalid Value9Critical Error: may cause submission to be rejected
ADMPERSON_ID_CHGS0878PERSON ID VALID (#02017) must equal `Y' unless PERSON_ID (#01029) equals University Identifier (#01095) or PERSON_ID (#01029) equals University Row Identifier (#02002).XFatal Error: must be resolved, an explanation is not acceptable
ADMPERSON_ID_CHGS4268Frequency of Values for PERSON_ID_CHGS.PID_VALID_SSN0Frequency Distribution: not an indication of an error
HTDPERSON_DEMO0005Invalid Value9Critical Error: may cause submission to be rejected
HTDPERSON_DEMO4269Frequency of Values for PERSON_DEMO.PID_VALID_SSN0Frequency Distribution: not an indication of an error
HTDPERSON_DEMO5319More than 5% of students that are not Non-resident aliens have a PID_VALID_SSN value of N9Critical Error: may cause submission to be rejected
HTDPERSON_ID_CHGS0005Invalid Value9Critical Error: may cause submission to be rejected
HTDPERSON_ID_CHGS0878PERSON ID VALID (#02017) must equal `Y' unless PERSON_ID (#01029) equals University Identifier (#01095) or PERSON_ID (#01029) equals University Row Identifier (#02002).XFatal Error: must be resolved, an explanation is not acceptable
HTDPERSON_ID_CHGS4268Frequency of Values for PERSON_ID_CHGS.PID_VALID_SSN0Frequency Distribution: not an indication of an error
IRDPERSON_ID_CHGS0005Invalid Value9Critical Error: may cause submission to be rejected
IRDPERSON_ID_CHGS4268Frequency of Values for PERSON_ID_CHGS.PID_VALID_SSN0Frequency Distribution: not an indication of an error
RETPERSON_DEMO0005Invalid Value9Critical Error: may cause submission to be rejected
RETPERSON_DEMO4269Frequency of Values for PERSON_DEMO.PID_VALID_SSN0Frequency Distribution: not an indication of an error
RETPERSON_ID_CHGS0005Invalid Value9Critical Error: may cause submission to be rejected
RETPERSON_ID_CHGS0878PERSON ID VALID (#02017) must equal `Y' unless PERSON_ID (#01029) equals University Identifier (#01095) or PERSON_ID (#01029) equals University Row Identifier (#02002).XFatal Error: must be resolved, an explanation is not acceptable
RETPERSON_ID_CHGS4268Frequency of Values for PERSON_ID_CHGS.PID_VALID_SSN0Frequency Distribution: not an indication of an error
SFAPERSON_DEMO0005Invalid Value9Critical Error: may cause submission to be rejected
SFAPERSON_DEMO4269Frequency of Values for PERSON_DEMO.PID_VALID_SSN0Frequency Distribution: not an indication of an error
SFAPERSON_DEMO5296More than 5% of Non-resident alien students have a PID_VALID_SSN value of N.9Critical Error: may cause submission to be rejected
SFAPERSON_ID_CHGS0005Invalid Value9Critical Error: may cause submission to be rejected
SFAPERSON_ID_CHGS0878PERSON ID VALID (#02017) must equal `Y' unless PERSON_ID (#01029) equals University Identifier (#01095) or PERSON_ID (#01029) equals University Row Identifier (#02002).XFatal Error: must be resolved, an explanation is not acceptable
SFAPERSON_ID_CHGS4268Frequency of Values for PERSON_ID_CHGS.PID_VALID_SSN0Frequency Distribution: not an indication of an error
SIFPERSON_DEMO0005Invalid Value9Critical Error: may cause submission to be rejected
SIFPERSON_DEMO0782PID_VALID_SSN must equal 'N' when PERSON_ID_ENC is not numeric.9Critical Error: may cause submission to be rejected
SIFPERSON_DEMO4269Frequency of Values for PERSON_DEMO.PID_VALID_SSN0Frequency Distribution: not an indication of an error
SIFPERSON_DEMO5319More than 5% of students that are not Non-resident aliens have a PID_VALID_SSN value of N9Critical Error: may cause submission to be rejected
SIFPERSON_ID_CHGS0005Invalid Value9Critical Error: may cause submission to be rejected
SIFPERSON_ID_CHGS0878PERSON ID VALID (#02017) must equal `Y' unless PERSON_ID (#01029) equals University Identifier (#01095) or PERSON_ID (#01029) equals University Row Identifier (#02002).XFatal Error: must be resolved, an explanation is not acceptable
SIFPERSON_ID_CHGS4268Frequency of Values for PERSON_ID_CHGS.PID_VALID_SSN0Frequency Distribution: not an indication of an error
SIFDPERSON_DEMO0005Invalid Value9Critical Error: may cause submission to be rejected
SIFDPERSON_DEMO4269Frequency of Values for PERSON_DEMO.PID_VALID_SSN0Frequency Distribution: not an indication of an error
SIFDPERSON_DEMO5319More than 5% of students that are not Non-resident aliens have a PID_VALID_SSN value of N9Critical Error: may cause submission to be rejected
SIFDPERSON_ID_CHGS0878PERSON ID VALID (#02017) must equal `Y' unless PERSON_ID (#01029) equals University Identifier (#01095) or PERSON_ID (#01029) equals University Row Identifier (#02002).XFatal Error: must be resolved, an explanation is not acceptable
SIFDPERSON_ID_CHGS4268Frequency of Values for PERSON_ID_CHGS.PID_VALID_SSN0Frequency Distribution: not an indication of an error
SIFPPERSON_DEMO0005Invalid Value9Critical Error: may cause submission to be rejected
SIFPPERSON_DEMO0782PID_VALID_SSN must equal 'N' when PERSON_ID_ENC is not numeric.9Critical Error: may cause submission to be rejected
SIFPPERSON_DEMO4269Frequency of Values for PERSON_DEMO.PID_VALID_SSN0Frequency Distribution: not an indication of an error
SIFPPERSON_DEMO5319More than 5% of students that are not Non-resident aliens have a PID_VALID_SSN value of N9Critical Error: may cause submission to be rejected
SIFPPERSON_ID_CHGS0005Invalid Value9Critical Error: may cause submission to be rejected
SIFPPERSON_ID_CHGS0878PERSON ID VALID (#02017) must equal `Y' unless PERSON_ID (#01029) equals University Identifier (#01095) or PERSON_ID (#01029) equals University Row Identifier (#02002).XFatal Error: must be resolved, an explanation is not acceptable
SIFPPERSON_ID_CHGS4268Frequency of Values for PERSON_ID_CHGS.PID_VALID_SSN0Frequency Distribution: not an indication of an error
TEIPERSON_DEMO0005Invalid Value9Critical Error: may cause submission to be rejected
TEIPERSON_DEMO4269Frequency of Values for PERSON_DEMO.PID_VALID_SSN0Frequency Distribution: not an indication of an error
TEIPERSON_DEMO5319More than 5% of students that are not Non-resident aliens have a PID_VALID_SSN value of N9Critical Error: may cause submission to be rejected
TEIPERSON_ID_CHGS0005Invalid Value9Critical Error: may cause submission to be rejected
TEIPERSON_ID_CHGS4268Frequency of Values for PERSON_ID_CHGS.PID_VALID_SSN0Frequency Distribution: not an indication of an error
  • 1 - 50

Prior Database Information:

VARCHAR2(1)
PIDVALID
PID_VALID_SSN