SS_TSCRPT_STLNG (SQL View)	Index Back
OprID Inst / Transcript Typ VW Transcript types for student self service, unofficial transcript report.

SS_TSCRPT_STLNG

(SQL View)

OprID Inst / Transcript Typ VW

Transcript types for student self service, unofficial transcript report.

SELECT B.INSTITUTION , B.TSCRPT_TYPE , B.LANGUAGE_CD , B.EFFDT , B.DESCR , A.SS_STDNT_AVAIL_TP FROM PS_TRANSCRIPT_TYPE A , PS_TRANSCRIPT_LANG B WHERE A.SS_STDNT_AVAIL_TP = 'Y' AND A.TRANSCRIPT_LEVEL < '80' AND A.TRANSCRIPT_LEVEL >= '40' 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) AND B.INSTITUTION = A.INSTITUTION AND B.TSCRPT_TYPE = A.TSCRPT_TYPE AND B.EFFDT = A.EFFDT

Related Language Record for SSR_SCRTY_TSVW3 SSR_SCRTY_TSVW5 SS_TSCRPT_ST_VW

# 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
Prompt Table: TRANSCRIPT_TYPE

3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

4 EFFDT Date(10) DATE Effective Date

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

6 SS_STDNT_AVAIL_TP Character(1) VARCHAR2(1) NOT NULL Checkbox variable for a view to retrieve valid transcript types for student 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 Prompt Table: TRANSCRIPT_TYPE
3	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
4	EFFDT	Date(10)	DATE	Effective Date
5	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
6	SS_STDNT_AVAIL_TP	Character(1)	VARCHAR2(1) NOT NULL	Checkbox variable for a view to retrieve valid transcript types for student self-service applications.