• Elements
  • Element: Person Identification Number - 01029

Page Name

A nine digit number assigned to an individual for identification purposes.

New Student/Applicant
- If the new student/applicant's identification number conforms to the Social Security Number format, then the number can be used as the PERSON_ID (#01029) and the PID_VALID_SSN (#02017) should be coded 'Y'. See the PID_VALID_SSN element for more information about how the validity of SSNs is determined.
- If the new student/applicant¿s identification number does not conform to the Social Security Number format, then the non-conforming number should not be used as the PERSON_ID (#01029). Instead, the UNIV_ID (#01095) should be used (translated into a nine-digit alphanumeric string with no more than two alpha characters) and the PID_VALID_SSN (#02017) should be coded 'N'. If your institution assigns each student with a distinct University Row Identifier (#02002) that serves as a unique student id across all submissions, then ROWID may be used instead of the UNIVID.

Note: Most international students are eligible to apply for a Social Security Number if they are employed or are receiving financial aid. International students who are not eligible for a Social Security Number might have an Individual Taxpayer Identification Numbers (ITIN) from the Internal Revenue Service. However, the ITIN should not be used as the PERSON_ID because the ITIN is not a permanent identification number and students can receive multiple ITINs over the years.

Returning Student/Applicant
- We expect returning students/applicants to have the same PERSON_ID that was reported previously. However, if the returning student/applicant, who previously had been assigned a PERSON_ID where PID_VALID_SSN='N', has recently provided a different ID number that does conform to the Social Security Number format, then the newly conforming ID number should be reported as the PERSON_ID moving forward and PID_VALID_SSN should be coded 'Y'. See the *important* note below about providing PERSON_ID_CHGS records.

*IMPORTANT NOTES*
ID Changes: If you have previously reported an individual under a different PERSON_ID on any submission, then you will need to use the new PERSON_ID on all tables for the current submission and submit a PERSON_ID_CHGS record in the current submission with both the old and new PERSON_IDs. This is required for SUDS to create accurate SYSID.

When you submit a PERSON_ID_CHGS record the following diagnostic edit will ensure that you are not reporting a new temporary PERSON_ID to replace the previous temporary PERSON_ID: ¿PERSON ID VALID (#02017) must equal `Y' unless PERSON_ID (#1029) equals University Identifier (#1095) or PERSON_ID (#1029) equals University Row Identifier (#02002).

Grandfathered Records: We are not requiring ID changes for returning students/applicants who previously had been assigned a PERSON_ID where PID_VALID_SSN='N' and the PERSON_ID does not match the UNIV_ID (#1095) or the ROWID (#02002).




ELEMENT

192001

10-JUN-2022


Allowed Values

Edit Values

Submission CodeAscending
Table name
Diagnostic Code
Diagnostic Message
Error Level
Error Description
ADMAPPLICANTS_ADMITS5220A matching Person_Demo row in the current submission could not be foundXFatal Error: must be resolved, an explanation is not acceptable
ADMPERSON_DEMO0493At least one of the race flags or the non-resident alien flag must = Y (excluding the NO_RACE_REPORT_FLG for EMPL and SCD)9Critical Error: may cause submission to be rejected
ADMPERSON_DEMO0830The Person Identification Number (01029) cannot contain more than two alpha characters.9Critical Error: may cause submission to be rejected
ADMPERSON_DEMO0877PERSON_ID cannot equal 000000000, 111111111, 222222222, 333333333, 444444444, 555555555, 666666666, 777777777, 888888888, 999999999, or 123456789.9Critical Error: may cause submission to be rejected
ADMPERSON_DEMO5310No matching record(s) in primary child tableXFatal Error: must be resolved, an explanation is not acceptable
ADMPERSON_ID_CHGS0837The Person Identification Number (01029) cannot contain more than two alpha characters.9Critical Error: may cause submission to be rejected
ADMPERSON_ID_CHGS5203PERSON_ID_NEW but a matching person demographic row already exists at this institution for the ID reported9Critical Error: may cause submission to be rejected
ADMPERSON_ID_CHGS5295The PERSON_ID_NEW in the PERSON_ID_CHGS table must have matching PERSON_ID in the PERSON_DEMO tableXFatal Error: must be resolved, an explanation is not acceptable
HTDHOURS_TO_DEGREE5310No matching record(s) in primary child tableXFatal Error: must be resolved, an explanation is not acceptable
HTDHOURS_TO_DEGREE5403A matching Person Demographic row could not be found or was too oldXFatal Error: must be resolved, an explanation is not acceptable
HTDPERSON_DEMO0493At least one of the race flags or the non-resident alien flag must = Y (excluding the NO_RACE_REPORT_FLG for EMPL and SCD)9Critical Error: may cause submission to be rejected
HTDPERSON_DEMO0830The Person Identification Number (01029) cannot contain more than two alpha characters.9Critical Error: may cause submission to be rejected
HTDPERSON_DEMO0877PERSON_ID cannot equal 000000000, 111111111, 222222222, 333333333, 444444444, 555555555, 666666666, 777777777, 888888888, 999999999, or 123456789.9Critical Error: may cause submission to be rejected
HTDPERSON_DEMO5202Demographic info identical to existing and demographic table not required. Row will not be saved in production database.5Warning: possible error that should be checked
HTDPERSON_DEMO5310No matching record(s) in primary child tableXFatal Error: must be resolved, an explanation is not acceptable
HTDPERSON_ID_CHGS0837The Person Identification Number (01029) cannot contain more than two alpha characters.9Critical Error: may cause submission to be rejected
HTDPERSON_ID_CHGS5203PERSON_ID_NEW but a matching person demographic row already exists at this institution for the ID reported9Critical Error: may cause submission to be rejected
HTDPERSON_ID_CHGS5295The PERSON_ID_NEW in the PERSON_ID_CHGS table must have matching PERSON_ID in the PERSON_DEMO tableXFatal Error: must be resolved, an explanation is not acceptable
IRDPERSON_ID_CHGS0837The Person Identification Number (01029) cannot contain more than two alpha characters.9Critical Error: may cause submission to be rejected
IRDPERSON_ID_CHGS5203PERSON_ID_NEW but a matching person demographic row already exists at this institution for the ID reported9Critical Error: may cause submission to be rejected
IRDPERSON_ID_CHGS5295The PERSON_ID_NEW in the PERSON_ID_CHGS table must have matching PERSON_ID in the PERSON_DEMO tableXFatal Error: must be resolved, an explanation is not acceptable
RETPERSON_DEMO0493At least one of the race flags or the non-resident alien flag must = Y (excluding the NO_RACE_REPORT_FLG for EMPL and SCD)9Critical Error: may cause submission to be rejected
RETPERSON_DEMO0830The Person Identification Number (01029) cannot contain more than two alpha characters.9Critical Error: may cause submission to be rejected
RETPERSON_DEMO0877PERSON_ID cannot equal 000000000, 111111111, 222222222, 333333333, 444444444, 555555555, 666666666, 777777777, 888888888, 999999999, or 123456789.9Critical Error: may cause submission to be rejected
RETPERSON_DEMO5202Demographic info identical to existing and demographic table not required. Row will not be saved in production database.5Warning: possible error that should be checked
RETPERSON_ID_CHGS0837The Person Identification Number (01029) cannot contain more than two alpha characters.9Critical Error: may cause submission to be rejected
RETPERSON_ID_CHGS5203PERSON_ID_NEW but a matching person demographic row already exists at this institution for the ID reported9Critical Error: may cause submission to be rejected
RETPERSON_ID_CHGS5295The PERSON_ID_NEW in the PERSON_ID_CHGS table must have matching PERSON_ID in the PERSON_DEMO tableXFatal Error: must be resolved, an explanation is not acceptable
RETRET_COHORT_CHGS5346A matching RETENTION_COHORTS row could not be found for this person_id in the specified cohort_year, cohort_typ_old, and srk_flg_old.XFatal Error: must be resolved, an explanation is not acceptable
SFAENROLLMENTS5201A matching Person Demographic row could not be found or was too oldXFatal Error: must be resolved, an explanation is not acceptable
SFAFINANCIAL_AID_AWARDS5413This record has a Personal Identification Number (01029) on the Financial Aid Award table that does not have a matching Personal Identification Number (01029) on the Financial Aid Demo table.XFatal Error: must be resolved, an explanation is not acceptable
SFAFINANCIAL_AID_DEMO4307Frequency of Values for FINANCIAL_AID_DEMO.REPT_TIME_FRAME0Frequency Distribution: not an indication of an error
SFAFINANCIAL_AID_DEMO5361All students received at least one award. Please verify that all ISIRs have been reported.9Critical Error: may cause submission to be rejected
SFAFINANCIAL_AID_DEMO5403A matching Person Demographic row could not be found or was too oldXFatal Error: must be resolved, an explanation is not acceptable
SFAPERSON_DEMO0493At least one of the race flags or the non-resident alien flag must = Y (excluding the NO_RACE_REPORT_FLG for EMPL and SCD)9Critical Error: may cause submission to be rejected
SFAPERSON_DEMO0830The Person Identification Number (01029) cannot contain more than two alpha characters.9Critical Error: may cause submission to be rejected
SFAPERSON_DEMO0877PERSON_ID cannot equal 000000000, 111111111, 222222222, 333333333, 444444444, 555555555, 666666666, 777777777, 888888888, 999999999, or 123456789.9Critical Error: may cause submission to be rejected
SFAPERSON_DEMO5202Demographic info identical to existing and demographic table not required. Row will not be saved in production database.5Warning: possible error that should be checked
SFAPERSON_DEMO5310No matching record(s) in primary child tableXFatal Error: must be resolved, an explanation is not acceptable
SFAPERSON_ID_CHGS0837The Person Identification Number (01029) cannot contain more than two alpha characters.9Critical Error: may cause submission to be rejected
SFAPERSON_ID_CHGS5203PERSON_ID_NEW but a matching person demographic row already exists at this institution for the ID reported9Critical Error: may cause submission to be rejected
SFAPERSON_ID_CHGS5295The PERSON_ID_NEW in the PERSON_ID_CHGS table must have matching PERSON_ID in the PERSON_DEMO tableXFatal Error: must be resolved, an explanation is not acceptable
SIFENROLLMENTS5220A matching Person_Demo row in the current submission could not be foundXFatal Error: must be resolved, an explanation is not acceptable
SIFPERSON_DEMO0493At least one of the race flags or the non-resident alien flag must = Y (excluding the NO_RACE_REPORT_FLG for EMPL and SCD)9Critical Error: may cause submission to be rejected
SIFPERSON_DEMO0830The Person Identification Number (01029) cannot contain more than two alpha characters.9Critical Error: may cause submission to be rejected
SIFPERSON_DEMO0877PERSON_ID cannot equal 000000000, 111111111, 222222222, 333333333, 444444444, 555555555, 666666666, 777777777, 888888888, 999999999, or 123456789.9Critical Error: may cause submission to be rejected
SIFPERSON_DEMO5310No matching record(s) in primary child tableXFatal Error: must be resolved, an explanation is not acceptable
SIFPERSON_DEMO5337Student was reported on SIFP but not reported on SIF5Warning: possible error that should be checked
SIFPERSON_ID_CHGS0837The Person Identification Number (01029) cannot contain more than two alpha characters.9Critical Error: may cause submission to be rejected
SIFPERSON_ID_CHGS5203PERSON_ID_NEW but a matching person demographic row already exists at this institution for the ID reported9Critical Error: may cause submission to be rejected
  • 1 - 50

Prior Database Information:

VARCHAR2(9)
SSN
PERSON_ID_NUMBER