SS_AA_ADVIS_VW (SQL View)	Index Back
OprID Inst / Transcript Typ VW Transcript types for advisor self service, degree progress report.

SS_AA_ADVIS_VW

(SQL View)

OprID Inst / Transcript Typ VW

Transcript types for advisor self service, degree progress report.

SELECT A.INSTITUTION ,A.TSCRPT_TYPE ,A.EFFDT ,A.DESCR ,A.SS_ADVIS_AVAIL_TP FROM PS_TRANSCRIPT_TYPE A WHERE A.SS_ADVIS_AVAIL_TP = 'Y' AND A.TRANSCRIPT_LEVEL >= '80' AND A.EFFDT = ( SELECT MAX(A1.EFFDT) FROM PS_TRANSCRIPT_TYPE A1 WHERE A1.INSTITUTION = A.INSTITUTION AND A1.TSCRPT_TYPE = A.TSCRPT_TYPE AND A1.EFFDT <= %CurrentDateIn)

Related Language Record: SS_AA_ADVIS_LNG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 TSCRPT_TYPE Character(5) VARCHAR2(5) NOT NULL Transcript Type

3 EFFDT Date(10) DATE Effective Date

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

5 SS_ADVIS_AVAIL_TP Character(1) VARCHAR2(1) NOT NULL Checkbox variable for a view to retrieve valid transcript types for advisor self-service applications.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Academic Institution Prompt Table: SCRTY_TBL_INST
2	TSCRPT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Transcript Type
3	EFFDT	Date(10)	DATE	Effective Date
4	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
5	SS_ADVIS_AVAIL_TP	Character(1)	VARCHAR2(1) NOT NULL	Checkbox variable for a view to retrieve valid transcript types for advisor self-service applications.