Page Name

Description:

The primary identifier that is used within a university to identify a student or an employee. This identifier should be consistent throughout the tenure of a student across time.

Coding Instructions:

For all submissions, report the primary identifier that is used to identify a person at your institution. A person should only ever have one UNIV_ID at an institution.

Algorithm:

Usage Type:

ELEMENT

Begin Term:

201405

End Term:

Last Modified:

20-JUN-2022

SubmissionAscending	Table Name	Column name	Element ID	Tab column id	Table id	Submission name
Admissions (ADM)	APPLICANTS_ADMITS (ADMA)	UNIV_ID	1042	5366	3	Admissions
Admissions (ADM)	PERSON_DEMO (DEMO)	UNIV_ID	1042	5112	1	Admissions
Admissions (ADM)	PERSON_ID_CHGS (IDC)	UNIV_ID	1042	5113	48	Admissions
Admissions (ADM)	TESTS_REQS (TSTR)	UNIV_ID	1042	5390	5	Admissions
College Prep (CP)	PERSON_DEMO (DEMO)	UNIV_ID	1042	5112	1	College Prep
College Prep (CP)	PERSON_ID_CHGS (IDC)	UNIV_ID	1042	5113	48	College Prep
College Prep Completions (CPC)	PERSON_DEMO (DEMO)	UNIV_ID	1042	5112	1	College Prep Completions
College Prep Completions (CPC)	PERSON_ID_CHGS (IDC)	UNIV_ID	1042	5113	48	College Prep Completions
Degrees Awarded (SIFD)	DEGREES_AWARDED (DEG)	UNIV_ID	1042	5462	14	Degrees Awarded
Degrees Awarded (SIFD)	ENROLLMENTS (ENRL)	UNIV_ID	1042	5452	8	Degrees Awarded

1 - 10

Submission CodeAscending	Table name	Diagnostic Code	Diagnostic Message	Error Level	Error Description
ADM	APPLICANTS_ADMITS	0007	Missing	X	Fatal Error: must be resolved, an explanation is not acceptable
ADM	APPLICANTS_ADMITS	5407	This record has a University Identifier (01095) that does not have a matching University Identifier in this submission's PERSON_DEMO table.	X	Fatal Error: must be resolved, an explanation is not acceptable
ADM	PERSON_DEMO	0007	Missing	X	Fatal Error: must be resolved, an explanation is not acceptable
ADM	PERSON_DEMO	5408	This record has a University Identifier (01095) on the PERSON_DEMO table that does not have a matching University Identifier in the submission's child table(s).	X	Fatal Error: must be resolved, an explanation is not acceptable
ADM	PERSON_ID_CHGS	0007	Missing	X	Fatal Error: must be resolved, an explanation is not acceptable
ADM	TESTS_REQS	0007	Missing	X	Fatal Error: must be resolved, an explanation is not acceptable
ADM	TESTS_REQS	5407	This record has a University Identifier (01095) that does not have a matching University Identifier in this submission's PERSON_DEMO table.	X	Fatal Error: must be resolved, an explanation is not acceptable
EMPL	EMPLOYEE_DATA	0007	Missing	X	Fatal Error: must be resolved, an explanation is not acceptable
EMPL	EMPLOYEE_DEMO	0007	Missing	X	Fatal Error: must be resolved, an explanation is not acceptable
EMPL	EMPLOYEE_DEMO	5411	This record has a University Identifier (01095) on the submission's parent/child table that does not have a matching University Identifier in the submission's respective parent/child table(s).	X	Fatal Error: must be resolved, an explanation is not acceptable
HTD	COURSES_TO_DEGREE	0007	Missing	X	Fatal Error: must be resolved, an explanation is not acceptable
HTD	COURSES_TO_DEGREE	5411	This record has a University Identifier (01095) on the submission's parent/child table that does not have a matching University Identifier in the submission's respective parent/child table(s).	X	Fatal Error: must be resolved, an explanation is not acceptable
HTD	HOURS_TO_DEGREE	0007	Missing	X	Fatal Error: must be resolved, an explanation is not acceptable
HTD	HOURS_TO_DEGREE	5411	This record has a University Identifier (01095) on the submission's parent/child table that does not have a matching University Identifier in the submission's respective parent/child table(s).	X	Fatal Error: must be resolved, an explanation is not acceptable
HTD	PERSON_DEMO	0007	Missing	X	Fatal Error: must be resolved, an explanation is not acceptable
HTD	PERSON_DEMO	5408	This record has a University Identifier (01095) on the PERSON_DEMO table that does not have a matching University Identifier in the submission's child table(s).	X	Fatal Error: must be resolved, an explanation is not acceptable
HTD	PERSON_ID_CHGS	0007	Missing	X	Fatal Error: must be resolved, an explanation is not acceptable
IRD	PERSON_ID_CHGS	0007	Missing	X	Fatal Error: must be resolved, an explanation is not acceptable
IRD	WORKLOAD_ACTIVITIES	0007	Missing	X	Fatal Error: must be resolved, an explanation is not acceptable
IRD	WORKLOAD_PERSON_FUNDING	0007	Missing	X	Fatal Error: must be resolved, an explanation is not acceptable
IRD	WORKLOAD_PERSON_FUNDING	5410	This record has a University Identifier (01095) and Demo Time Frame (02041) on WORKLOAD_PERSON_FUNDING that does not have a matching University Identifier and Demo Time Frame in this submission's WORKLOAD_ACTIVITIES table.	X	Fatal Error: must be resolved, an explanation is not acceptable
RET	PERSON_DEMO	0007	Missing	X	Fatal Error: must be resolved, an explanation is not acceptable
RET	PERSON_ID_CHGS	0007	Missing	X	Fatal Error: must be resolved, an explanation is not acceptable
RET	RET_COHORT_CHGS	0007	Missing	X	Fatal Error: must be resolved, an explanation is not acceptable
SCD	EMPLOYEE_DATA	0007	Missing	X	Fatal Error: must be resolved, an explanation is not acceptable
SCD	EMPLOYEE_DEMO	0007	Missing	X	Fatal Error: must be resolved, an explanation is not acceptable
SCD	EMPLOYEE_DEMO	5411	This record has a University Identifier (01095) on the submission's parent/child table that does not have a matching University Identifier in the submission's respective parent/child table(s).	X	Fatal Error: must be resolved, an explanation is not acceptable
SFA	FINANCIAL_AID_AWARDS	5411	This record has a University Identifier (01095) on the submission's parent/child table that does not have a matching University Identifier in the submission's respective parent/child table(s).	X	Fatal Error: must be resolved, an explanation is not acceptable
SFA	PERSON_DEMO	0007	Missing	X	Fatal Error: must be resolved, an explanation is not acceptable
SFA	PERSON_DEMO	5408	This record has a University Identifier (01095) on the PERSON_DEMO table that does not have a matching University Identifier in the submission's child table(s).	X	Fatal Error: must be resolved, an explanation is not acceptable
SFA	PERSON_ID_CHGS	0007	Missing	X	Fatal Error: must be resolved, an explanation is not acceptable
SIF	COURSES_TAKEN	0007	Missing	X	Fatal Error: must be resolved, an explanation is not acceptable
SIF	COURSES_TAKEN	5407	This record has a University Identifier (01095) that does not have a matching University Identifier in this submission's PERSON_DEMO table.	X	Fatal Error: must be resolved, an explanation is not acceptable
SIF	COURSES_TAKEN	5411	This record has a University Identifier (01095) on the submission's parent/child table that does not have a matching University Identifier in the submission's respective parent/child table(s).	X	Fatal Error: must be resolved, an explanation is not acceptable
SIF	ENROLLMENTS	0007	Missing	X	Fatal Error: must be resolved, an explanation is not acceptable
SIF	ENROLLMENTS	5407	This record has a University Identifier (01095) that does not have a matching University Identifier in this submission's PERSON_DEMO table.	X	Fatal Error: must be resolved, an explanation is not acceptable
SIF	FEE_WAIVERS	0007	Missing	X	Fatal Error: must be resolved, an explanation is not acceptable
SIF	FEE_WAIVERS	5407	This record has a University Identifier (01095) that does not have a matching University Identifier in this submission's PERSON_DEMO table.	X	Fatal Error: must be resolved, an explanation is not acceptable
SIF	FEE_WAIVERS	5411	This record has a University Identifier (01095) on the submission's parent/child table that does not have a matching University Identifier in the submission's respective parent/child table(s).	X	Fatal Error: must be resolved, an explanation is not acceptable
SIF	PERSON_DEMO	0007	Missing	X	Fatal Error: must be resolved, an explanation is not acceptable
SIF	PERSON_DEMO	5408	This record has a University Identifier (01095) on the PERSON_DEMO table that does not have a matching University Identifier in the submission's child table(s).	X	Fatal Error: must be resolved, an explanation is not acceptable
SIF	PERSON_ID_CHGS	0007	Missing	X	Fatal Error: must be resolved, an explanation is not acceptable
SIF	TEST_CREDITS	0007	Missing	X	Fatal Error: must be resolved, an explanation is not acceptable
SIF	TEST_CREDITS	5407	This record has a University Identifier (01095) that does not have a matching University Identifier in this submission's PERSON_DEMO table.	X	Fatal Error: must be resolved, an explanation is not acceptable
SIF	TEST_CREDITS	5411	This record has a University Identifier (01095) on the submission's parent/child table that does not have a matching University Identifier in the submission's respective parent/child table(s).	X	Fatal Error: must be resolved, an explanation is not acceptable
SIFD	DEGREES_AWARDED	0007	Missing	X	Fatal Error: must be resolved, an explanation is not acceptable
SIFD	ENROLLMENTS	0007	Missing	X	Fatal Error: must be resolved, an explanation is not acceptable
SIFD	ENROLLMENTS	5411	This record has a University Identifier (01095) on the submission's parent/child table that does not have a matching University Identifier in the submission's respective parent/child table(s).	X	Fatal Error: must be resolved, an explanation is not acceptable
SIFD	PERSON_DEMO	0007	Missing	X	Fatal Error: must be resolved, an explanation is not acceptable
SIFD	PERSON_DEMO	5408	This record has a University Identifier (01095) on the PERSON_DEMO table that does not have a matching University Identifier in the submission's child table(s).	X	Fatal Error: must be resolved, an explanation is not acceptable

1 - 50

Physical Description:

VARCHAR(15)

Short Name:

UNIV_ID

Column Name:

UNIV_ID

Page Name

Associated Submissions, Tables, and Columns

Allowed Values

Edit Values

Prior Database Information:

Element: University Identifier - 01095

Page Name

Associated Submissions, Tables, and Columns

Allowed Values

Edit Values

Prior Database Information: