• 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

SubmissionAscendingTable NameColumn nameElement IDTab column idTable idSubmission name
Admissions (ADM)PERSON_DEMO (DEMO)PID_VALID_SSN49728111Admissions
Admissions (ADM)PERSON_ID_CHGS (IDC)PID_VALID_SSN497282248Admissions
College Prep (CP)PERSON_DEMO (DEMO)PID_VALID_SSN49728111College Prep
College Prep (CP)PERSON_ID_CHGS (IDC)PID_VALID_SSN497282248College Prep
College Prep Completions (CPC)PERSON_DEMO (DEMO)PID_VALID_SSN49728111College Prep Completions
College Prep Completions (CPC)PERSON_ID_CHGS (IDC)PID_VALID_SSN497282248College Prep Completions
Degrees Awarded (SIFD)PERSON_DEMO (DEMO)PID_VALID_SSN49728111Degrees Awarded
Degrees Awarded (SIFD)PERSON_ID_CHGS (IDC)PID_VALID_SSN497282248Degrees Awarded
Hours to Degree (HTD)PERSON_DEMO (DEMO)PID_VALID_SSN49728111Hours to Degree
Hours to Degree (HTD)PERSON_ID_CHGS (IDC)PID_VALID_SSN497282248Hours to Degree
  • 1 - 10

Allowed Values

Excel code
Code
Description
Grouping
'..
MISSING		-
'NNNo
No		-
'YYYes
Yes		-
Download

Edit Values

Submission CodeAscendingTable nameDiagnostic CodeDiagnostic MessageError LevelError 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
Release 2.0