[Home] [Help]
View: IGS_PR_INST_STA_REF_V
| Product: | IGS - Student System (Obsolete) |
|---|
| Description: | This view is used define the details of what a particular user defined institution statistic type includes and is used for. |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT ISR.ROWID
, ISR.STAT_TYPE
, ISR.UNIT_REF_CD
, RC.DESCRIPTION
, ISR.INCLUDE_OR_EXCLUDE
, ISR.REFERENCE_CD_TYPE
, ISR.CREATED_BY
, ISR.CREATION_DATE
, ISR.LAST_UPDATED_BY
, ISR.LAST_UPDATE_DATE
, ISR.LAST_UPDATE_LOGIN
FROM IGS_PR_INST_STA_REF ISR
, IGS_GE_REF_CD_TYPE RCT
, IGS_GE_REF_CD RC
WHERE ISR.UNIT_REF_CD = RC.REFERENCE_CD
AND ISR.REFERENCE_CD_TYPE = RC.REFERENCE_CD_TYPE
AND RC.REFERENCE_CD_TYPE = RCT.REFERENCE_CD_TYPE
AND NVL(RCT.CLOSED_IND
, 'N') = 'N'
AND ( RCT.UNIT_FLAG = 'Y' OR RCT.UNIT_SECTION_FLAG = 'Y' OR RCT.UNIT_SECTION_OCCURRENCE_FLAG = 'Y' )
AND RCT.S_REFERENCE_CD_TYPE = 'STATS'
Columns
| Name |
| ROW_ID |
| STAT_TYPE |
| UNIT_REF_CD |
| DESCRIPTION |
| INCLUDE_OR_EXCLUDE |
| REFERENCE_CD_TYPE |
| CREATED_BY |
| CREATION_DATE |
| LAST_UPDATED_BY |
| LAST_UPDATE_DATE |
| LAST_UPDATE_LOGIN |