[Home] [Help]
View: IGS_AD_PER_STM_TYP_V
| Product: | IGS - Student System (Obsolete) |
|---|
| Description: | Admission Personal Statements Type view |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT PST.ROWID
, PST.PERSL_STAT_TYPE
, PST.PERSL_STAT_TYPE_DESC
, PST.STEP_CATALOG_CD
, TSC.DESCRIPTION
, PST.CLOSED_IND
, PST.CREATED_BY
, PST.CREATION_DATE
, PST.LAST_UPDATED_BY
, PST.LAST_UPDATE_DATE
, PST.LAST_UPDATE_LOGIN
FROM IGS_AD_PER_STM_TYP PST
, IGS_TR_STEP_CTLG TSC
WHERE PST.STEP_CATALOG_CD = TSC.STEP_CATALOG_CD (+)
AND TSC.S_TRACKING_STEP_TYPE(+) = 'PERSONAL_STATEMENT'
Columns
| Name |
| ROW_ID |
| PERSL_STAT_TYPE |
| PERSL_STAT_TYPE_DESC |
| STEP_CATALOG_CD |
| STEP_CODE_DESCRIPTION |
| CLOSED_IND |
| CREATED_BY |
| CREATION_DATE |
| LAST_UPDATED_BY |
| LAST_UPDATE_DATE |
| LAST_UPDATE_LOGIN |