ADMIT_LVL_TBL (SQL Table)	Index Back
Admit Level Table This table associates all of the Admissions Admit levels with a numeric used for establishing a hierarchy for adding financial aid application records to the database. An example is: load all records with an admit level of 3 (Applied) or higher.

ADMIT_LVL_TBL

(SQL Table)

Admit Level Table

This table associates all of the Admissions Admit levels with a numeric used for establishing a hierarchy for adding financial aid application records to the database. An example is: load all records with an admit level of 3 (Applied) or higher.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROG_STATUS Character(4) VARCHAR2(4) NOT NULL Academic Program Status
AC=Active in Program
AD=Admitted
AP=Applicant
CM=Completed Program
CN=Cancelled
DC=Discontinued
DE=Deceased
DM=Dismissed
LA=Leave of Absence
PM=Prematriculant
SP=Suspended
WT=Waitlisted

2 ADMIT_LVL Character(1) VARCHAR2(1) NOT NULL Student's Admit Lvl
0=0 - Student Not Found
1=1 - Has Not Applied
2=2 - Inactive
3=3 - Applied/Pending
4=4 - Admitted
5=5 - Accepted/Continuing

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROG_STATUS	Character(4)	VARCHAR2(4) NOT NULL	Academic Program Status AC=Active in Program AD=Admitted AP=Applicant CM=Completed Program CN=Cancelled DC=Discontinued DE=Deceased DM=Dismissed LA=Leave of Absence PM=Prematriculant SP=Suspended WT=Waitlisted
2	ADMIT_LVL	Character(1)	VARCHAR2(1) NOT NULL	Student's Admit Lvl 0=0 - Student Not Found 1=1 - Has Not Applied 2=2 - Inactive 3=3 - Applied/Pending 4=4 - Admitted 5=5 - Accepted/Continuing