nhsd_mhs011socpercircumstances_table - isaric4c/wiki GitHub Wiki
| [1] Database Table Field Name | [2] Field Data Type | [3] Variable Availability Date Range | [4] Field Length or Format | [5] Range of Values | [6] Completeness | [7] Constraints | [8] Representation of Missing Data | [9] Field Description | [10] Field Group | [11] Notes |
|---|---|---|---|---|---|---|---|---|---|---|
| MONTH_ID | INTEGER | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
| FILE_TYPE | TEXT | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
| SOCPERCIRCUMSTANCE | INTEGER | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
| SOCPERCIRCUMSTANCERECDATE | TEXT | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
| RECORDNUMBER | INTEGER | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
| MHS011UNIQID | INTEGER | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
| ORGIDPROV | TEXT | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
| UNIQMHSDSPERSID | INTEGER | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
| BSPUNIQID | INTEGER | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
| IC_UNIQUE_RECORD | TEXT | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |