Module: Common
Type: Dimension
BATCH_CD
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| BATCH_CD | VARCHAR2 | 8 | True | Batch Control | |||
| SOURCE_RECORD_ID | VARCHAR2 | 8 | Source Record Id | ||||
| EMAILID | VARCHAR2 | 254 | Email Address | ||||
| F1_BATCH_CTGY_FLG | VARCHAR2 | 38 | Batch Category | ||||
| F1_BATCH_CTRL_TYPE_FLG | VARCHAR2 | 4 | Batch Control Type | ||||
| F1_TIMER_ACTIVE_FLG | VARCHAR2 | 38 | Timer Active | ||||
| LAST_UPDATE_DTTM | TIMESTAMP | 0 | 6 | Last Update Timestamp | |||
| LAST_UPDATE_INST | NUMBER | 10 | 0 | Last Update Instance | |||
| MAX_COMMIT_RECS | NUMBER | 10 | 0 | Maximum Commit Records | |||
| NEXT_BATCH_NBR | NUMBER | 10 | 0 | Next Batch Nbr | |||
| OWNER_FLG | VARCHAR2 | 4 | Owner | ||||
| PGM_TYPE_FLG | VARCHAR2 | 4 | Program Type | ||||
| PROGRAM_NAME | VARCHAR2 | 254 | Program Name | ||||
| TIMER_INTERVAL | NUMBER | 10 | 0 | Timer Interval | |||
| TRC_PGM_END_SW | VARCHAR2 | 38 | Trace Program Exit | ||||
| TRC_PGM_STRT_SW | VARCHAR2 | 38 | Trace Program Start | ||||
| TRC_SQL_SW | VARCHAR2 | 38 | Trace SQL | ||||
| TRC_STD_SW | VARCHAR2 | 38 | Trace Output | ||||
| W$_INSERT_DT | TIMESTAMP | 0 | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 0 | 6 |