View: IGS_HE_POOUS

View Text

SELECT A.ROWID ROW_ID
, A.HESA_POOUS_ID HESA_POOUS_ID
, A.COURSE_CD COURSE_CD
, A.CRV_VERSION_NUMBER CRV_VERSION_NUMBER
, A.CAL_TYPE CAL_TYPE
, A.LOCATION_CD LOCATION_CD
, A.ATTENDANCE_MODE ATTENDANCE_MODE
, A.ATTENDANCE_TYPE ATTENDANCE_TYPE
, A.UNIT_SET_CD UNIT_SET_CD
, A.US_VERSION_NUMBER US_VERSION_NUMBER
, A.LOCATION_OF_STUDY LOCATION_OF_STUDY
, A.MODE_OF_STUDY MODE_OF_STUDY
, A.UFI_PLACE UFI_PLACE
, A.FRANCHISING_ACTIVITY FRANCHISING_ACTIVITY
, A.TYPE_OF_YEAR TYPE_OF_YEAR
, A.LENG_CURRENT_YEAR LENG_CURRENT_YEAR
, A.GRADING_SCHEMA_CD GRADING_SCHEMA_CD
, A.GS_VERSION_NUMBER GS_VERSION_NUMBER
, A.CREDIT_VALUE_YOP1 CREDIT_VALUE_YOP1
, A.LEVEL_CREDIT1 LEVEL_CREDIT1
, A.CREDIT_VALUE_YOP2 CREDIT_VALUE_YOP2
, A.LEVEL_CREDIT2 LEVEL_CREDIT2
, A. FTE_INTENSITY FTE_INTENSITY
, A.FTE_CALC_TYPE FTE_CALC_TYPE
, A.TEACH_PERIOD_START_DT TEACH_PERIOD_START_DT
, A.TEACH_PERIOD_END_DT TEACH_PERIOD_END_DT
, A.OTHER_INSTIT_TEACH1 OTHER_INSTIT_TEACH1
, A.OTHER_INSTIT_TEACH2 OTHER_INSTIT_TEACH2
, A.PROP_NOT_TAUGHT PROP_NOT_TAUGHT
, A.FUNDABILITY_CD FUNDABILITY_CD
, A.FEE_BAND FEE_BAND
, A.FUNDING_SOURCE FUNDING_SOURCE
, A.LEVEL_APPLICABLE_TO_FUNDING LEVEL_APPLICABLE_TO_FUNDING
, A.CREATED_BY CREATED_BY
, A.CREATION_DATE CREATION_DATE
, A.LAST_UPDATED_BY LAST_UPDATED_BY
, A.LAST_UPDATE_DATE LAST_UPDATE_DATE
, A.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, A.CREDIT_VALUE_YOP3 CREDIT_VALUE_YOP3
, A.LEVEL_CREDIT3 LEVEL_CREDIT3
, A.CREDIT_VALUE_YOP4 CREDIT_VALUE_YOP4
, A.LEVEL_CREDIT4 LEVEL_CREDIT4
FROM IGS_HE_POOUS_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