SSR_PROG_TBLVW (SQL View)	Index Back
Active Program Description This view will display the latest effective dated row less than or equal to today that is active. This is used for showing the correct related display descriptions on the student milestone page.

SSR_PROG_TBLVW

(SQL View)

Active Program Description

This view will display the latest effective dated row less than or equal to today that is active. This is used for showing the correct related display descriptions on the student milestone page.

SELECT A.INSTITUTION , A.ACAD_PROG , A.EFFDT , A.EFF_STATUS , A.DESCR , A.DESCRSHORT FROM PS_ACAD_PROG_TBL A WHERE A.EFFDT = ( SELECT MAX(A1.EFFDT) FROM PS_ACAD_PROG_TBL A1 WHERE A1.INSTITUTION = A.INSTITUTION AND A1.ACAD_PROG = A.ACAD_PROG AND A1.EFFDT <= %CurrentDateIn AND A1.EFF_STATUS = 'A')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
Prompt Table: INSTITUTION_TBL

2 ACAD_PROG Character(5) VARCHAR2(5) NOT NULL Academic Program
Prompt Table: ACAD_PROG_TBL

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

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

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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Academic Institution Prompt Table: INSTITUTION_TBL
2	ACAD_PROG	Character(5)	VARCHAR2(5) NOT NULL	Academic Program Prompt Table: ACAD_PROG_TBL
3	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
4	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive
5	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
6	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description