SSR_HE_QUASP_VW

(SQL View)
Index Back

HESA Qualification Setup

HESA Qualification Setup

SELECT INSTITUTION , DEGREE , ACAD_PLAN , SSR_HE_ACAD_PLAN2 , ACAD_SUB_PLAN , EFFDT , SSR_HE_QUALID , SSR_HE_CATEGORY , EFF_STATUS FROM PS_SSR_HE_QUAL_SUP A WHERE A.EFFDT = ( SELECT MAX(A1.EFFDT) FROM PS_SSR_HE_QUAL_SUP A1 WHERE A1.INSTITUTION = A.INSTITUTION AND A1.DEGREE = A.DEGREE AND A1.ACAD_PLAN = A.ACAD_PLAN AND A1.SSR_HE_ACAD_PLAN2 = A.SSR_HE_ACAD_PLAN2 AND A1.ACAD_SUB_PLAN = A.ACAD_SUB_PLAN AND A1.EFFDT <= %CurrentDateIn)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

Default Value: OPR_DEF_TBL_CS.INSTITUTION

Prompt Table: INSTITUTION_TBL

2 DEGREE Character(8) VARCHAR2(8) NOT NULL Degree

Prompt Table: DEGREE_INTRN_VW

3 ACAD_PLAN Character(10) VARCHAR2(10) NOT NULL Academic Plan

Prompt Table: SSR_HE_ACD_PLVW

4 SSR_HE_ACAD_PLAN2 Character(10) VARCHAR2(10) NOT NULL Academic Plan

Prompt Table: SSR_HE_ACD_PLVW

5 ACAD_SUB_PLAN Character(10) VARCHAR2(10) NOT NULL Academic Sub-Plan

Prompt Table: SSR_HE_AC_SPLVW

6 EFFDT Date(10) DATE Effective Date

Default Value: %date

7 SSR_HE_QUALID Character(50) VARCHAR2(50) NOT NULL Qualification ID
8 SSR_HE_CATEGORY Character(30) VARCHAR2(30) NOT NULL HESA Category

Prompt Table: SSR_HE_CATCD_VW

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

Default Value: A