View: IGS_HE_ST_PROG

View Text

SELECT A.ROWID ROW_ID
, A.HESA_ST_PROG_ID
, A.COURSE_CD
, A.VERSION_NUMBER
, A.TEACHER_TRAIN_PROG_ID
, A.ITT_PHASE
, A.BILINGUAL_ITT_MARKER
, A.TEACHING_QUAL_SOUGHT_SECTOR
, A.TEACHING_QUAL_SOUGHT_SUBJ1
, A.TEACHING_QUAL_SOUGHT_SUBJ2
, A.TEACHING_QUAL_SOUGHT_SUBJ3
, A.LOCATION_OF_STUDY
, A.OTHER_INST_PROV_TEACHING1
, A.OTHER_INST_PROV_TEACHING2
, A.PROP_TEACHING_IN_WELSH
, A.PROP_NOT_TAUGHT
, A.CREDIT_TRANSFER_SCHEME
, A.RETURN_TYPE
, A.DEFAULT_AWARD
, A.PROGRAM_CALC
, A.LEVEL_APPLICABLE_TO_FUNDING
, A.FRANCHISING_ACTIVITY
, A.NHS_FUNDING_SOURCE
, A.FE_PROGRAM_MARKER
, A.FEE_BAND
, A.FUNDABILITY
, A.FTE_INTENSITY
, A.TEACH_PERIOD_START_DT
, A.TEACH_PERIOD_END_DT
, A.CREATION_DATE
, A.CREATED_BY
, A.LAST_UPDATE_DATE
, A.LAST_UPDATED_BY
, A.LAST_UPDATE_LOGIN
, A.IMPLIED_FUND_RATE
, A.GOV_INITIATIVES_CD
, A.UNITS_FOR_QUAL
, A.DISADV_UPLIFT_ELIG_CD
, A.FRANCH_PARTNER_CD
, A.FRANCH_OUT_ARR_CD
, A.EXCLUDE_FLAG
FROM IGS_HE_ST_PROG_ALL A
WHERE NVL (ORG_ID
, NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)

Columns