ADM_APPL_DEP_PR

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Default Value: ADM_APPL_DEP.EMPLID
2	ADM_APPL_NBR	Character(8)	VARCHAR2(8) NOT NULL	Application Nbr Default Value: ADM_APPL_DEP.ADM_APPL_NBR
3	APPL_DEP_NBR	Number(3,0)	SMALLINT NOT NULL	Application Deposit Nbr Default Value: ADM_APPL_DEP.APPL_DEP_NBR
4	ACAD_PROG	Character(5)	VARCHAR2(5) NOT NULL	Academic Program
5	PREV_STATUS	Character(4)	VARCHAR2(4) NOT NULL	Previous Status
6	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
7	PROG_ACTION	Character(4)	VARCHAR2(4) NOT NULL	Program Action ACTV=Activate ADMT=Admit ADRV=Admission Revocation APPL=Application COMP=Completion of Program COND=Conditional Admit DATA=Data Change DDEF=Defer Decision DEFR=Defer Enrollment DEIN=Intention to Matriculate DENY=Deny DISC=Discontinuation DISM=Dismissal LEAV=Leave of Absence MATR=Matriculation PLNC=Plan Change PRGC=Program Change RADM=Readmit RAPP=Readmit Application RECN=Reconsideration REVK=Revoke Degree RLOA=Return from Leave of Absence SPND=Suspension TRAN=Transfer to Other Career VDIS=Voluntarily Discontinued WADM=Administrative Withdrawal WAIT=Waitlist WAOF=Waitlist Offer WAPP=Applicant Withdrawal
8	PROG_REASON	Character(4)	VARCHAR2(4) NOT NULL	Action Reason
9	CREATE_STUDENT	Character(1)	VARCHAR2(1) NOT NULL	Create Student