SSR_HE_CCDEX_VW

(SQL View)
 Index Back

HESA Course_Course Delivery

Contains HESA HESA Course and Course Delivery Extract View

SELECT A.INSTITUTION , A.SSR_HE_RET_NAME , A.SSR_HE_COURSEID , A.SSR_HE_ACTIVE , A.ACAD_PLAN , B.SSR_HE_COUDELID , A.SSR_HE_LEVEL_FLAG FROM %Table(SSR_HE_CRS_EXT) A , %Table(SSR_HE_CDEL_EXT) B WHERE B.INSTITUTION = A.INSTITUTION AND B.SSR_HE_RET_NAME = A.SSR_HE_RET_NAME AND B.SSR_HE_COURSEID = A.SSR_HE_COURSEID AND B.SSR_HE_ACTIVE = A.SSR_HE_ACTIVE AND B.ACAD_PLAN = A.ACAD_PLAN

# 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 SSR_HE_RET_NAME Character(30) VARCHAR2(30) NOT NULL Return Name

Prompt Table: SSR_HE_INST_HER

3 SSR_HE_COURSEID Character(10) VARCHAR2(10) NOT NULL Course ID
4 SSR_HE_ACTIVE Character(1) VARCHAR2(1) NOT NULL Active

Y/N Table Edit

5 ACAD_PLAN Character(10) VARCHAR2(10) NOT NULL Academic Plan
6 SSR_HE_COUDELID Character(50) VARCHAR2(50) NOT NULL Course Delivery ID
7 SSR_HE_LEVEL_FLAG Character(1) VARCHAR2(1) NOT NULL Derived From Flag
P=Academic Plan
S=Academic Sub-Plan