BATCH_IDIT_BATCH_ID_VW(SQL View) |
Index Back |
|---|---|
ITAM: View of BATCH_IDsITAM: View of valid BATCH_IDs eligible to be selected in the IT_PLOAD_RUN run control page. |
| SELECT DISTINCT(BATCH_ID) FROM %Table(IT_DISCO_HW_PRE) UNION SELECT DISTINCT(B.BATCH_ID) FROM %Table(IT_DISCO_HW_ER2) B WHERE NOT EXISTS( SELECT 'X' FROM %Table(IT_DISCO_HW_PRE) C WHERE B.BATCH_ID = C.BATCH_ID) UNION SELECT DISTINCT(D.BATCH_ID) FROM %Table(IT_DISCO_SW_ER2) D WHERE NOT EXISTS( SELECT 'X' FROM %Table(IT_DISCO_HW_ER2) E WHERE D.BATCH_ID = E.BATCH_ID) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BATCH_ID |
Character(18) | VARCHAR2(18) NOT NULL | Batch ID |