[Home] [Help]
View: IGS_PE_TYP_INSTANCES_SV
Product: | IGS - Student System (Obsolete) |
Description: | New View for securing select privileges on IGS_PE_TYP_INSTANCES_ALL table. |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT TYP.TYPE_INSTANCE_ID
, TYP.PERSON_TYPE_CODE
, TYP.PERSON_ID
, TYP.COURSE_CD
, TYP.CC_VERSION_NUMBER
, TYP.FUNNEL_STATUS
, TYP.ADMISSION_APPL_NUMBER
, TYP.NOMINATED_COURSE_CD
, TYP.NCC_VERSION_NUMBER
, TYP.SEQUENCE_NUMBER
, TYP.START_DATE
, TYP.END_DATE
, TYP.CREATE_METHOD
, TYP.ENDED_BY
, TYP.END_METHOD
, TYP.CREATED_BY
, TYP.CREATION_DATE
, TYP.LAST_UPDATED_BY
, TYP.LAST_UPDATE_DATE
, TYP.LAST_UPDATE_LOGIN
, TYP.ORG_ID
, TYP.EMPLMNT_CATEGORY_CODE
FROM IGS_PE_TYP_INSTANCES_ALL TYP
Columns
Name |
TYPE_INSTANCE_ID |
PERSON_TYPE_CODE |
PERSON_ID |
COURSE_CD |
CC_VERSION_NUMBER |
FUNNEL_STATUS |
ADMISSION_APPL_NUMBER |
NOMINATED_COURSE_CD |
NCC_VERSION_NUMBER |
SEQUENCE_NUMBER |
START_DATE |
END_DATE |
CREATE_METHOD |
ENDED_BY |
END_METHOD |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATE_LOGIN |
ORG_ID |
EMPLMNT_CATEGORY_CODE |