PROG_RSN_MC_VW (SQL View)	Index Back
View to select program reason

PROG_RSN_MC_VW

(SQL View)

View to select program reason

SELECT DISTINCT a.Setid ,b.oprid ,a.prog_action ,a.Prog_Reason ,a.Effdt ,a.Eff_Status ,a.Descr ,a.Descrshort FROM PS_PROG_RSN_TBL A , PS_ADM_ACTION_SCTY B WHERE A. prog_action = B.prog_action

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Default Value: OPR_DEF_TBL_CS.SETID_CAREER
Prompt Table: SETID_TBL

2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

3 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

4 PROG_REASON Character(4) VARCHAR2(4) NOT NULL Action Reason

5 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

6 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive

7 DESCR Character(30) VARCHAR2(30) NOT NULL Description

8 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Default Value: OPR_DEF_TBL_CS.SETID_CAREER Prompt Table: SETID_TBL
2	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
3	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
4	PROG_REASON	Character(4)	VARCHAR2(4) NOT NULL	Action Reason
5	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
6	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive
7	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
8	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description