S_WI_STU_WIR_STATUS_C (ver 21.4.2)
This table is an extension of the [S_WI_STU_WIR_C] table. This table provides details about the updated dates and it's field name and position or number in [S_WI_STU_IMM_X] table
Column Name | Version | Data Type | Description |
|---|---|---|---|
| S_WI_STU_WIR_Status_CID | 21.4.2 | Number(10,0) | Foriegn Key |
| REPORTING_GROUP | 21.4.2 | Varchar2(10) | Reporting group can be any one of the following value DTaP, Tdap, Td, Polio, HepB, MMR & Varicella |
INSERT_STATUS | 21.4.2 | Varchar2(10) | Insert status can be ADDED, INSERTED or DUPLICATE |
| INSERTED_FIELD_NAME | 21.4.2 | Varchar2(30) | The field in which the downloaded date is inserted |
| DATE_ORDINAL | 21.4.2 | Number(10,0) | Inserted date field's number or position |
| DATE_PROCESSED | 21.4.2 | Date | Processed Date |