[Home] [Help]
View: IGS_PR_ORG_STAT_REF_V
Product: | IGS - Student System (Obsolete) |
Description: | Defines which unit reference codes are included or excluded for a user defined organizational unit statistics type |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT OSR.ROWID
, OSR.STAT_TYPE
, OSR.ORG_UNIT_CD
, OSR.UNIT_REF_CD
, RC.DESCRIPTION
, OSR.INCLUDE_OR_EXCLUDE
, OSR.CREATED_BY
, OSR.CREATION_DATE
, OSR.LAST_UPDATED_BY
, OSR.LAST_UPDATE_DATE
, OSR.LAST_UPDATE_LOGIN
FROM IGS_PR_ORG_STAT_REF OSR
, IGS_GE_REF_CD_TYPE RCT
, IGS_GE_REF_CD RC
WHERE OSR.UNIT_REF_CD=RC.REFERENCE_CD
AND RCT.REFERENCE_CD_TYPE=RC.REFERENCE_CD_TYPE
AND RCT.UNIT_FLAG='Y'
AND RCT.CLOSED_IND='N'
Columns
Name |
ROW_ID |
STAT_TYPE |
ORG_UNIT_CD |
UNIT_REF_CD |
DESCRIPTION |
INCLUDE_OR_EXCLUDE |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATE_LOGIN |