[Home] [Help]
View: IGS_SS_EN_POST_ADREQ_V
| Product: | IGS - Student System (Obsolete) |
|---|
| Description: | Selects all the Post Admission requirements for a particular Term Calendar |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT TS.ROWID ROW_ID
, TS.DESCRIPTION TRACKING_TYPE
, TS.COMPLETION_DT START_DT
, LK1.MEANING COMPLETED
, LK2.MEANING BYPASSED
, AT.PERSON_ID PERSON_ID
, AT.COURSE_CD COURSE_CD
, TS.CREATED_BY
, TS.CREATION_DATE
, TS.LAST_UPDATED_BY
, TS.LAST_UPDATE_DATE
, TS.LAST_UPDATE_LOGIN
FROM IGS_TR_STEP TS
, IGS_TR_TYPE TT
, IGS_TR_ITEM TI
, IGS_AD_APLINS_ADMREQ AT
, IGS_LOOKUPS_VIEW LK1
, IGS_LOOKUPS_VIEW LK2
WHERE TS.TRACKING_ID = TI.TRACKING_ID
AND TI.TRACKING_ID = AT.TRACKING_ID
AND TT.TRACKING_TYPE = TI.TRACKING_TYPE
AND TT.S_TRACKING_TYPE = 'POST_ADMISSION'
AND LK1.LOOKUP_CODE = TS.STEP_COMPLETION_IND
AND LK1.LOOKUP_TYPE = 'VS_AS_YN'
AND LK2.LOOKUP_CODE = TS.BY_PASS_IND
AND LK2.LOOKUP_TYPE = 'VS_AS_YN'
Columns
| Name |
| ROW_ID |
| TRACKING_TYPE |
| START_DT |
| COMPLETED |
| BYPASSED |
| PERSON_ID |
| COURSE_CD |
| CREATED_BY |
| CREATION_DATE |
| LAST_UPDATED_BY |
| LAST_UPDATE_DATE |
| LAST_UPDATE_LOGIN |