S_WI_STU_WIR_C (ver 21.4.2)
This table is an extension of the [Students] table. This table contains the students Immunisation details that are downloaded from the Wisconsin Immunisation Registry (WIR).
Column Name | Version | Data Type | Description |
|---|---|---|---|
StudentsDCID | 21.4.2 | Number(10,0) | Primary Key. |
| ADMINISTERED_DATE | 21.4.2 | Date | Administered Date |
| VACCINE | 21.4.2 | Varchar2(100) | Vaccine |
| CVX_CODE | 21.4.2 | Varchar2(50) | CVX Code |
| CPT_CODE | 21.4.2 | Varchar2(50) | CPT Code |
| TRADE_NAME | 21.4.2 | Varchar2(50) | Trade Name |
| DOWNLOADED_DATE | 21.4.2 | Date | Downloaded Date |