SSR_HE_SPLOF_VW

(SQL View)
 Index Back

HESA Sub Plan Offering Fields

HESA Sub Plan Offering Fields View

SELECT B.INSTITUTION , B.ACAD_PLAN , B.ACAD_SUB_PLAN , B.EFFDT , A.SSR_HE_CRDELID , B.SSR_HE_FIELD , B.SSR_HE_CODE FROM PS_SSR_HE_SPLNOFR A , PS_SSR_HE_SPLNO_FL B WHERE B.INSTITUTION = A.INSTITUTION AND B.ACAD_PLAN = A.ACAD_PLAN AND B.ACAD_SUB_PLAN = A.ACAD_SUB_PLAN AND B.EFFDT = A.EFFDT AND B.ACAD_LOAD_APPR = A.ACAD_LOAD_APPR AND B.SSR_HE_OFSTRM = A.SSR_HE_OFSTRM AND B.SSR_HE_OFSTSESN = A.SSR_HE_OFSTSESN AND B.CAMPUS = A.CAMPUS AND A.SSR_HE_OFSTRM <> ' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
2 ACAD_PLAN Character(10) VARCHAR2(10) NOT NULL Academic Plan
3 ACAD_SUB_PLAN Character(10) VARCHAR2(10) NOT NULL Academic Sub-Plan
4 EFFDT Date(10) DATE NOT NULL Effective Date

Default Value: %date

5 SSR_HE_CRDELID Character(50) VARCHAR2(50) NOT NULL Course Delivery ID
6 SSR_HE_FIELD Character(20) VARCHAR2(20) NOT NULL Field

Prompt Table: SSR_HE_PLNOFLVW

7 SSR_HE_CODE Character(30) VARCHAR2(30) NOT NULL Code

Prompt Table: SSR_HE_CODEVW