SCC_AARCARVWLNG (SQL View)	Index Back
Advisement Report Career View Related Language View of the Advisement Report Career view, which contains the list of careers that use this advisement report type. This is a related language record for SAA_RPT_CAR_TBL.

SCC_AARCARVWLNG

(SQL View)

Advisement Report Career View

Related Language View of the Advisement Report Career view, which contains the list of careers that use this advisement report type. This is a related language record for SAA_RPT_CAR_TBL.

SELECT A.INSTITUTION ,A.TSCRPT_TYPE ,A.CAREER_SEQ_NBR ,A.LANGUAGE_CD ,A.DESCRFORMAL FROM PS_SAA_RPT_CAR_LNG A WHERE A.EFFDT = ( SELECT MAX(A2.EFFDT) FROM PS_SAA_RPT_CAR_LNG A2 WHERE A2.INSTITUTION = A.INSTITUTION AND A2.TSCRPT_TYPE = A.TSCRPT_TYPE AND A2.CAREER_SEQ_NBR = A.CAREER_SEQ_NBR AND A2.LANGUAGE_CD = A.LANGUAGE_CD AND A2.EFFDT <= %CurrentDateIn)

Related Language Record for SCC_AARPTCAR_VW

# 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 TSCRPT_TYPE Character(5) VARCHAR2(5) NOT NULL Transcript Type
Prompt Table: TRANSCRIPT_TYPE

3 CAREER_SEQ_NBR Number(3,0) SMALLINT NOT NULL Career Sequence Number

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

5 DESCRFORMAL Character(50) VARCHAR2(50) NOT NULL Formal Description field

#	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	TSCRPT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Transcript Type Prompt Table: TRANSCRIPT_TYPE
3	CAREER_SEQ_NBR	Number(3,0)	SMALLINT NOT NULL	Career Sequence Number
4	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
5	DESCRFORMAL	Character(50)	VARCHAR2(50) NOT NULL	Formal Description field