ADM_ACTION_TBL(SQL Table) |
Index Back |
---|---|
Admissions Actions TableADM_ACTION_TBL is an prompt table. This table lists only the Program Actions that are valid for Admissions. When an Admissions operator prompts on Program Action in the Applicant Program record they will be prompting against this table and see only valid Admissions Actions. |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | 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 |
2 | EFFDT | Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
3 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL |
Description
Default Value: XLAT_MC_VW.XLATLONGNAME |
5 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |