SSR_HE_QSHEC_VW

(SQL View)
Index Back

HESA Qualification Subject HEC

HESA Qualification Subject HECOS View

SELECT A.INSTITUTION , A.DEGREE , A.ACAD_PLAN , A.SSR_HE_ACAD_PLAN2 , A.ACAD_SUB_PLAN , A.SSR_HE_QUALID , A.EFFDT , B.SSR_HE_HECOS , A.EFF_STATUS , B.SSR_HE_SUBJECT_PER , B.SSR_HE_ITTSUB_FLAG FROM PS_SSR_HE_QUAL_SUP A , PS_SSR_HE_QUAL_HEC B WHERE B.INSTITUTION = A.INSTITUTION AND B.DEGREE = A.DEGREE AND B.ACAD_PLAN = A.ACAD_PLAN AND B.SSR_HE_ACAD_PLAN2 = A.SSR_HE_ACAD_PLAN2 AND B.ACAD_SUB_PLAN = A.ACAD_SUB_PLAN AND B.EFFDT = A.EFFDT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
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 SSR_HE_QUALID Character(50) VARCHAR2(50) NOT NULL Qualification ID
7 EFFDT Date(10) DATE NOT NULL Effective Date

Default Value: %date

8 SSR_HE_HECOS Character(6) VARCHAR2(6) NOT NULL HECOS Field

Prompt Table: SSR_HE_HECOSVW

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

Default Value: A

10 SSR_HE_SUBJECT_PER Number(5,1) DECIMAL(4,1) NOT NULL HESA Subject Percentage
11 SSR_HE_ITTSUB_FLAG Character(1) VARCHAR2(1) NOT NULL ITT Subject Flag

Y/N Table Edit

Default Value: N