[Home] [Help]
View: IGS_SV_EV_UPD_BLK_V
Product: | IGS - Student System (Obsolete) |
Description: | View for use on XML batch for add dummy block |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT PERS.BATCH_ID BATCH_ID
, PERS.PERSON_ID PERSON_ID
, PERS.PRINT_FORM PRINT_FORM
, BAT.SEVIS_USER_ID PDSO_SEVIS_ID
, PERS.SEVIS_USER_ID SEVIS_USER_ID
, PERS.RECORD_NUMBER RECORD_NUMBER
, LTRIM(TO_CHAR(SUBSTR(PERS.PERSON_ID
, 1
, 10)
, '0000000000')) PERSON_NUMBER
, LTRIM(TO_CHAR(SUBSTR(PERS.PERSON_ID
, 1
, 14)
, '00000000000000')) PERSON_ID_LONG
, PERS.REPRINT_RSN_CODE REPRINT_REASON
, DECODE(PERS.REPRINT_RSN_CODE
, '05'
, NULL
, PERS.REPRINT_REMARKS) REPRINT_REMARKS
, DECODE(PERS.REPRINT_RSN_CODE
, '05'
, PERS.REPRINT_REMARKS
, NULL) OTHER_REMARKS
FROM IGS_SV_BATCHES BAT
, IGS_SV_PERSONS PERS
WHERE BAT.BATCH_TYPE = 'E'
AND BAT.BATCH_ID = PERS.BATCH_ID
AND PERS.RECORD_STATUS = 'C'
Columns
Name |
BATCH_ID |
PERSON_ID |
PRINT_FORM |
PDSO_SEVIS_ID |
SEVIS_USER_ID |
RECORD_NUMBER |
PERSON_NUMBER |
PERSON_ID_LONG |
REPRINT_REASON |
REPRINT_REMARKS |
OTHER_REMARKS |