[Home] [Help]
View: IGS_AD_CAT_ATTR_V
| Product: | IGS - Student System (Obsolete) |
|---|
| Description: | Obsolete |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT CA.ROWID ROW_ID
, CA.CAT_ATTR_ID
, CA.SRC_CAT_ID
, CA.ATTR_NAME
, LK1.MEANING ATTR_NAME_MEANING
, CA.SYS_MANDATORY_IND
, CA.MANDATORY_IND
, CA.INCLUDE_IND
, CA.DISPLAY_SEQUENCE
, CA.CREATED_BY
, CA.CREATION_DATE
, CA.LAST_UPDATED_BY
, CA.LAST_UPDATE_DATE
, CA.LAST_UPDATE_LOGIN
FROM IGS_AD_CAT_ATTR CA
, IGS_LOOKUP_VALUES LK1
WHERE CA.ATTR_NAME = LK1.LOOKUP_CODE
AND LK1.LOOKUP_TYPE = 'CAT_ATTR_NAME'
Columns
| Name |
| ROW_ID |
| CAT_ATTR_ID |
| SRC_CAT_ID |
| ATTR_NAME |
| ATTR_NAME_MEANING |
| SYS_MANDATORY_IND |
| MANDATORY_IND |
| INCLUDE_IND |
| DISPLAY_SEQUENCE |
| CREATED_BY |
| CREATION_DATE |
| LAST_UPDATED_BY |
| LAST_UPDATE_DATE |
| LAST_UPDATE_LOGIN |