Page Name

Description:

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

Coding Instructions:

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).

Algorithm:

Usage Type:

ELEMENT

Begin Term:

192001

End Term:

Last Modified:

10-JUN-2022

SubmissionAscending	Table Name	Column name	Element ID	Tab column id	Table id	Submission name
Admissions (ADM)	ADMISSION_EXCEPTIONS (ADME)	PERSON_ID	29	2377	4	Admissions
Admissions (ADM)	ADMISSION_EXCEPTIONS (ADME)	PERSON_ID_ENC	29	2377	4	Admissions
Admissions (ADM)	ADMISSION_EXCEPTIONS (ADME)	PERSON_ID_NEW	29	2377	4	Admissions
Admissions (ADM)	APPLICANTS_ADMITS (ADMA)	PERSON_ID	29	2275	3	Admissions
Admissions (ADM)	APPLICANTS_ADMITS (ADMA)	PERSON_ID_ENC	29	2275	3	Admissions
Admissions (ADM)	APPLICANTS_ADMITS (ADMA)	PERSON_ID_NEW	29	2275	3	Admissions
Admissions (ADM)	COLLEGE_PREP (PREP)	PERSON_ID	29	2523	7	Admissions
Admissions (ADM)	COLLEGE_PREP (PREP)	PERSON_ID_ENC	29	2523	7	Admissions
Admissions (ADM)	COLLEGE_PREP (PREP)	PERSON_ID_NEW	29	2523	7	Admissions
Admissions (ADM)	PERSON_DEMO (DEMO)	PERSON_ID	29	2189	1	Admissions

1 - 10

Submission CodeAscending	Table name	Diagnostic Code	Diagnostic Message	Error Level	Error Description
ADM	APPLICANTS_ADMITS	5220	A matching Person_Demo row in the current submission could not be found	X	Fatal Error: must be resolved, an explanation is not acceptable
ADM	PERSON_DEMO	0493	At least one of the race flags or the non-resident alien flag must = Y (excluding the NO_RACE_REPORT_FLG for EMPL and SCD)	9	Critical Error: may cause submission to be rejected
ADM	PERSON_DEMO	0830	The Person Identification Number (01029) cannot contain more than two alpha characters.	9	Critical Error: may cause submission to be rejected
ADM	PERSON_DEMO	0877	PERSON_ID cannot equal 000000000, 111111111, 222222222, 333333333, 444444444, 555555555, 666666666, 777777777, 888888888, 999999999, or 123456789.	9	Critical Error: may cause submission to be rejected
ADM	PERSON_DEMO	5310	No matching record(s) in primary child table	X	Fatal Error: must be resolved, an explanation is not acceptable
ADM	PERSON_ID_CHGS	0837	The Person Identification Number (01029) cannot contain more than two alpha characters.	9	Critical Error: may cause submission to be rejected
ADM	PERSON_ID_CHGS	5203	PERSON_ID_NEW but a matching person demographic row already exists at this institution for the ID reported	9	Critical Error: may cause submission to be rejected
ADM	PERSON_ID_CHGS	5295	The PERSON_ID_NEW in the PERSON_ID_CHGS table must have matching PERSON_ID in the PERSON_DEMO table	X	Fatal Error: must be resolved, an explanation is not acceptable
HTD	HOURS_TO_DEGREE	5310	No matching record(s) in primary child table	X	Fatal Error: must be resolved, an explanation is not acceptable
HTD	HOURS_TO_DEGREE	5403	A matching Person Demographic row could not be found or was too old	X	Fatal Error: must be resolved, an explanation is not acceptable
HTD	PERSON_DEMO	0493	At least one of the race flags or the non-resident alien flag must = Y (excluding the NO_RACE_REPORT_FLG for EMPL and SCD)	9	Critical Error: may cause submission to be rejected
HTD	PERSON_DEMO	0830	The Person Identification Number (01029) cannot contain more than two alpha characters.	9	Critical Error: may cause submission to be rejected
HTD	PERSON_DEMO	0877	PERSON_ID cannot equal 000000000, 111111111, 222222222, 333333333, 444444444, 555555555, 666666666, 777777777, 888888888, 999999999, or 123456789.	9	Critical Error: may cause submission to be rejected
HTD	PERSON_DEMO	5202	Demographic info identical to existing and demographic table not required. Row will not be saved in production database.	5	Warning: possible error that should be checked
HTD	PERSON_DEMO	5310	No matching record(s) in primary child table	X	Fatal Error: must be resolved, an explanation is not acceptable
HTD	PERSON_ID_CHGS	0837	The Person Identification Number (01029) cannot contain more than two alpha characters.	9	Critical Error: may cause submission to be rejected
HTD	PERSON_ID_CHGS	5203	PERSON_ID_NEW but a matching person demographic row already exists at this institution for the ID reported	9	Critical Error: may cause submission to be rejected
HTD	PERSON_ID_CHGS	5295	The PERSON_ID_NEW in the PERSON_ID_CHGS table must have matching PERSON_ID in the PERSON_DEMO table	X	Fatal Error: must be resolved, an explanation is not acceptable
IRD	PERSON_ID_CHGS	0837	The Person Identification Number (01029) cannot contain more than two alpha characters.	9	Critical Error: may cause submission to be rejected
IRD	PERSON_ID_CHGS	5203	PERSON_ID_NEW but a matching person demographic row already exists at this institution for the ID reported	9	Critical Error: may cause submission to be rejected
IRD	PERSON_ID_CHGS	5295	The PERSON_ID_NEW in the PERSON_ID_CHGS table must have matching PERSON_ID in the PERSON_DEMO table	X	Fatal Error: must be resolved, an explanation is not acceptable
RET	PERSON_DEMO	0493	At least one of the race flags or the non-resident alien flag must = Y (excluding the NO_RACE_REPORT_FLG for EMPL and SCD)	9	Critical Error: may cause submission to be rejected
RET	PERSON_DEMO	0830	The Person Identification Number (01029) cannot contain more than two alpha characters.	9	Critical Error: may cause submission to be rejected
RET	PERSON_DEMO	0877	PERSON_ID cannot equal 000000000, 111111111, 222222222, 333333333, 444444444, 555555555, 666666666, 777777777, 888888888, 999999999, or 123456789.	9	Critical Error: may cause submission to be rejected
RET	PERSON_DEMO	5202	Demographic info identical to existing and demographic table not required. Row will not be saved in production database.	5	Warning: possible error that should be checked
RET	PERSON_ID_CHGS	0837	The Person Identification Number (01029) cannot contain more than two alpha characters.	9	Critical Error: may cause submission to be rejected
RET	PERSON_ID_CHGS	5203	PERSON_ID_NEW but a matching person demographic row already exists at this institution for the ID reported	9	Critical Error: may cause submission to be rejected
RET	PERSON_ID_CHGS	5295	The PERSON_ID_NEW in the PERSON_ID_CHGS table must have matching PERSON_ID in the PERSON_DEMO table	X	Fatal Error: must be resolved, an explanation is not acceptable
RET	RET_COHORT_CHGS	5346	A matching RETENTION_COHORTS row could not be found for this person_id in the specified cohort_year, cohort_typ_old, and srk_flg_old.	X	Fatal Error: must be resolved, an explanation is not acceptable
SFA	ENROLLMENTS	5201	A matching Person Demographic row could not be found or was too old	X	Fatal Error: must be resolved, an explanation is not acceptable
SFA	FINANCIAL_AID_AWARDS	5413	This 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.	X	Fatal Error: must be resolved, an explanation is not acceptable
SFA	FINANCIAL_AID_DEMO	4307	Frequency of Values for FINANCIAL_AID_DEMO.REPT_TIME_FRAME	0	Frequency Distribution: not an indication of an error
SFA	FINANCIAL_AID_DEMO	5361	All students received at least one award. Please verify that all ISIRs have been reported.	9	Critical Error: may cause submission to be rejected
SFA	FINANCIAL_AID_DEMO	5403	A matching Person Demographic row could not be found or was too old	X	Fatal Error: must be resolved, an explanation is not acceptable
SFA	PERSON_DEMO	0493	At least one of the race flags or the non-resident alien flag must = Y (excluding the NO_RACE_REPORT_FLG for EMPL and SCD)	9	Critical Error: may cause submission to be rejected
SFA	PERSON_DEMO	0830	The Person Identification Number (01029) cannot contain more than two alpha characters.	9	Critical Error: may cause submission to be rejected
SFA	PERSON_DEMO	0877	PERSON_ID cannot equal 000000000, 111111111, 222222222, 333333333, 444444444, 555555555, 666666666, 777777777, 888888888, 999999999, or 123456789.	9	Critical Error: may cause submission to be rejected
SFA	PERSON_DEMO	5202	Demographic info identical to existing and demographic table not required. Row will not be saved in production database.	5	Warning: possible error that should be checked
SFA	PERSON_DEMO	5310	No matching record(s) in primary child table	X	Fatal Error: must be resolved, an explanation is not acceptable
SFA	PERSON_ID_CHGS	0837	The Person Identification Number (01029) cannot contain more than two alpha characters.	9	Critical Error: may cause submission to be rejected
SFA	PERSON_ID_CHGS	5203	PERSON_ID_NEW but a matching person demographic row already exists at this institution for the ID reported	9	Critical Error: may cause submission to be rejected
SFA	PERSON_ID_CHGS	5295	The PERSON_ID_NEW in the PERSON_ID_CHGS table must have matching PERSON_ID in the PERSON_DEMO table	X	Fatal Error: must be resolved, an explanation is not acceptable
SIF	ENROLLMENTS	5220	A matching Person_Demo row in the current submission could not be found	X	Fatal Error: must be resolved, an explanation is not acceptable
SIF	PERSON_DEMO	0493	At least one of the race flags or the non-resident alien flag must = Y (excluding the NO_RACE_REPORT_FLG for EMPL and SCD)	9	Critical Error: may cause submission to be rejected
SIF	PERSON_DEMO	0830	The Person Identification Number (01029) cannot contain more than two alpha characters.	9	Critical Error: may cause submission to be rejected
SIF	PERSON_DEMO	0877	PERSON_ID cannot equal 000000000, 111111111, 222222222, 333333333, 444444444, 555555555, 666666666, 777777777, 888888888, 999999999, or 123456789.	9	Critical Error: may cause submission to be rejected
SIF	PERSON_DEMO	5310	No matching record(s) in primary child table	X	Fatal Error: must be resolved, an explanation is not acceptable
SIF	PERSON_DEMO	5337	Student was reported on SIFP but not reported on SIF	5	Warning: possible error that should be checked
SIF	PERSON_ID_CHGS	0837	The Person Identification Number (01029) cannot contain more than two alpha characters.	9	Critical Error: may cause submission to be rejected
SIF	PERSON_ID_CHGS	5203	PERSON_ID_NEW but a matching person demographic row already exists at this institution for the ID reported	9	Critical Error: may cause submission to be rejected

1 - 50

Physical Description:

VARCHAR2(9)

Short Name:

SSN

Column Name:

PERSON_ID_NUMBER

Page Name

Associated Submissions, Tables, and Columns

Allowed Values

Edit Values

Prior Database Information:

Element: Person Identification Number - 01029

Page Name

Associated Submissions, Tables, and Columns

Allowed Values

Edit Values

Prior Database Information: