SSR_HEIMS_CRCMV

(SQL View)
Index Back

Course on Campus

Course on Campus view(HEIMS)

SELECT INSTITUTION , ACAD_PROG , ACAD_PLAN , LOCATION ,SSR_CRICOS_CD , SSR_TYP_OF_CAMPUS , SSR_OFFSH_CRSE_MOD , SSR_OFFSH_DEL_CODE FROM %Table(SSR_HEIMS_CR_CM) A WHERE %EffdtCheck(SSR_HEIMS_CR_CM B, A, %CURRENTDATEIN) AND EFF_STATUS = 'A'

# 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 ACAD_PROG Character(5) VARCHAR2(5) NOT NULL Academic Program

Prompt Table: ACAD_PROG_TBL

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

Prompt Table: ACAD_PLAN_TBL

4 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

Prompt Table: SSR_HEIMS_LOCVW

5 SSR_CRICOS_CD Character(10) VARCHAR2(10) NOT NULL CRICOS Code - AUS

Default Value: SSR_ACD_PRG_AUS.SSR_CRICOS_CD

6 SSR_TYP_OF_CAMPUS Character(2) VARCHAR2(2) NOT NULL Type of Campus (HEIMS)
01=Stand-alone arrangement
02=Partnership arrangement

Default Value: 00

7 SSR_OFFSH_CRSE_MOD Character(2) VARCHAR2(2) NOT NULL Offshore Course Mode (HEIMS)
01=Internal
02=External with face-to-face
03=External with no face-to-face
04=Multi-modal

Default Value: 00

8 SSR_OFFSH_DEL_CODE Character(2) VARCHAR2(2) NOT NULL Offshore Delivery Code(HEIMS)
01=Delivered partially offshore
02=Delivered fully offshore

Default Value: 00