eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: IGS_AD_PRCS_CAT_STEP_V

Product:	IGS - Student System (Obsolete)
Description:
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT APCS.ROW_ID ROW_ID
, APCS.ADMISSION_CAT ADMISSION_CAT
, APCS.S_ADMISSION_PROCESS_TYPE S_ADMISSION_PROCESS_TYPE
, APCS.S_ADMISSION_STEP_TYPE S_ADMISSION_STEP_TYPE
, NULL S_TRACKING_TYPE
, NULL S_TRK_MEANING
, NULL DESCRIPTION
, LKUPV1.MEANING MEANING
, APCS.STEP_GROUP_TYPE STEP_GROUP_TYPE
, LKUPV1.STEP_TYPE_RESTRICTION_NUM_IND STEP_TYPE_RESTRICTION_NUM_IND
, LKUPV1.CLOSED_IND CLOSED_IND
, APCS.MANDATORY_STEP_IND MANDATORY_STEP_IND
, APCS.STEP_TYPE_RESTRICTION_NUM STEP_TYPE_RESTRICTION_NUM
, APCS.STEP_ORDER_NUM STEP_ORDER_NUM
, APCS.CREATED_BY CREATED_BY
, APCS.CREATION_DATE CREATION_DATE
, APCS.LAST_UPDATED_BY LAST_UPDATED_BY
, APCS.LAST_UPDATE_DATE LAST_UPDATE_DATE
, APCS.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_AD_PRCS_CAT_STEP APCS
, IGS_LOOKUPS_VIEW LKUPV1
WHERE LKUPV1.LOOKUP_TYPE = 'ADMISSION_STEP_TYPE'
AND APCS.S_ADMISSION_STEP_TYPE = LKUPV1.LOOKUP_CODE
AND APCS.STEP_GROUP_TYPE = LKUPV1.STEP_GROUP_TYPE
AND APCS.STEP_GROUP_TYPE <> 'TRACK' UNION SELECT APCS.ROW_ID ROW_ID
, APCS.ADMISSION_CAT ADMISSION_CAT
, APCS.S_ADMISSION_PROCESS_TYPE S_ADMISSION_PROCESS_TYPE
, APCS.S_ADMISSION_STEP_TYPE S_ADMISSION_STEP_TYPE
, TRT.S_TRACKING_TYPE S_TRACKING_TYPE
, LKUPV2.MEANING S_TRK_MEANING
, TRT.DESCRIPTION DESCRIPTION
, NULL MEANING
, 'TRACK' STEP_GROUP_TYPE
, 'N' STEP_TYPE_RESTRICTION_NUM_IND
, TRT.CLOSED_IND CLOSED_IND
, APCS.MANDATORY_STEP_IND MANDATORY_STEP_IND
, APCS.STEP_TYPE_RESTRICTION_NUM STEP_TYPE_RESTRICTION_NUM
, APCS.STEP_ORDER_NUM STEP_ORDER_NUM
, APCS.CREATED_BY CREATED_BY
, APCS.CREATION_DATE CREATION_DATE
, APCS.LAST_UPDATED_BY LAST_UPDATED_BY
, APCS.LAST_UPDATE_DATE LAST_UPDATE_DATE
, APCS.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_AD_PRCS_CAT_STEP APCS
, IGS_TR_TYPE TRT
, IGS_LOOKUP_VALUES LKUPV2
WHERE APCS.S_ADMISSION_STEP_TYPE = TRT.TRACKING_TYPE
AND TRT.S_TRACKING_TYPE = LKUPV2.LOOKUP_CODE
AND LKUPV2.LOOKUP_TYPE = 'TRACKING_TYPE'
AND APCS.STEP_GROUP_TYPE = 'TRACK'

Columns

Name
ROW_ID
ADMISSION_CAT
S_ADMISSION_PROCESS_TYPE
S_ADMISSION_STEP_TYPE
S_TRACKING_TYPE
S_TRK_MEANING
DESCRIPTION
MEANING
STEP_GROUP_TYPE
STEP_TYPE_RESTRICTION_NUM_IND
CLOSED_IND
MANDATORY_STEP_IND
STEP_TYPE_RESTRICTION_NUM
STEP_ORDER_NUM
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN