[Home] [Help]
View: IGS_PE_MATCH_SET_DATA_V
Product: | IGS - Student System (Obsolete) |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT SD.ROWID ROW_ID
, SD.MATCH_SET_DATA_ID
, SD.MATCH_SET_ID
, SD.DATA_ELEMENT
, SD.VALUE
, SD.EXACT_INCLUDE
, SD.PARTIAL_INCLUDE
, SD.DROP_IF_NULL
, LK.MEANING DATA_MEANING
, LK.TAG DATA_ELEMENT_TAG
, SD.CREATED_BY
, SD.CREATION_DATE
, SD.LAST_UPDATED_BY
, SD.LAST_UPDATE_DATE
, SD.LAST_UPDATE_LOGIN
FROM IGS_PE_MTCH_SET_DATA SD
, IGS_LOOKUP_VALUES LK
WHERE SD.DATA_ELEMENT = LK.LOOKUP_CODE
AND LK.LOOKUP_TYPE = 'DUPLICATE_DATA_ELEMENTS'
Columns
Name |
ROW_ID |
MATCH_SET_DATA_ID |
MATCH_SET_ID |
DATA_ELEMENT |
VALUE |
EXACT_INCLUDE |
PARTIAL_INCLUDE |
DROP_IF_NULL |
DATA_MEANING |
DATA_ELEMENT_TAG |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATE_LOGIN |