SSR_BR_PRRSN_VW

(SQL View)

SELECT A.PROG_ACTION , A.PROG_REASON FROM PS_PROG_RSN_TBL A WHERE SETID = 'PSNLD' AND EFFDT <= ( SELECT MAX(A1.EFFDT) FROM PS_PROG_RSN_TBL A1 WHERE A1.SETID = 'PSNLD' AND A1.PROG_ACTION = A.PROG_ACTION AND A1.PROG_REASON = A.PROG_REASON AND A1.EFFDT <= %CurrentDateIn AND A1.EFF_STATUS = 'A') AND A.EFF_STATUS = 'A'

# 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 SSR_BR_PR_RSN_ENR Character(4) VARCHAR2(4) NOT NULL Action Reason

#	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	SSR_BR_PR_RSN_ENR	Character(4)	VARCHAR2(4) NOT NULL	Action Reason