SSR_PRGRSNDTLVW (SQL View)	Index Back
Program Reason Detail View Program Action Reason Consumption Action mapping view

SSR_PRGRSNDTLVW

(SQL View)

Program Reason Detail View

Program Action Reason Consumption Action mapping view

SELECT B.INSTITUTION , B.SSR_PROCESS_NAME , B.PROG_ACTION , B.PROG_REASON , B.SSR_CNSMPTN_ACTION , B.SSR_RS_STATUS , B.SSR_ACTNRSN_ALL FROM %Table(SSR_PRGRSN_HDR) A , %Table(SSR_PRGRSN_DTL) B WHERE %EffdtCheck(SSR_PRGRSN_HDR A1, A,%CurrentDateIn) AND A.EFF_STATUS = 'A' AND B.INSTITUTION = A.INSTITUTION AND B.SSR_PROCESS_NAME = A.SSR_PROCESS_NAME AND B.EFFDT = A.EFFDT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

2 SSR_PROCESS_NAME Character(2) VARCHAR2(2) NOT NULL Field contains process names as translate values that use program action setup
RC=Research Consumption

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
Prompt Table: PROG_ACTN_SCTY

4 PROG_REASON Character(4) VARCHAR2(4) NOT NULL Action Reason
Prompt Table: PROG_RSN_TBL

5 SSR_CNSMPTN_ACTION Character(1) VARCHAR2(1) NOT NULL Consumption Action
N=Do Nothing
R=Resume Consumption
S=Suspend Consumption

6 SSR_RS_STATUS Character(12) VARCHAR2(12) NOT NULL Status associated within the status group code.
Prompt Table: SSR_RS_CSTAT_VW

7 SSR_ACTNRSN_ALL Character(1) VARCHAR2(1) NOT NULL Checkbox to Indicate that consumption action should be applied to all Action Reasons

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Academic Institution
2	SSR_PROCESS_NAME	Character(2)	VARCHAR2(2) NOT NULL	Field contains process names as translate values that use program action setup RC=Research Consumption
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 Prompt Table: PROG_ACTN_SCTY
4	PROG_REASON	Character(4)	VARCHAR2(4) NOT NULL	Action Reason Prompt Table: PROG_RSN_TBL
5	SSR_CNSMPTN_ACTION	Character(1)	VARCHAR2(1) NOT NULL	Consumption Action N=Do Nothing R=Resume Consumption S=Suspend Consumption
6	SSR_RS_STATUS	Character(12)	VARCHAR2(12) NOT NULL	Status associated within the status group code. Prompt Table: SSR_RS_CSTAT_VW
7	SSR_ACTNRSN_ALL	Character(1)	VARCHAR2(1) NOT NULL	Checkbox to Indicate that consumption action should be applied to all Action Reasons