SGSS_main_table - isaric4c/wiki GitHub Wiki
| [1] Database Table Field Name | [2] Field Data Type | [3] Field Length or Format | [4] Range of Values | [5] Constraints | [6] Representation of Missing Data | [7] Field Description | [8] Sensitive Field | [9] Identifiable Field | [10] Field_Group | [11] Notes |
|---|---|---|---|---|---|---|---|---|---|---|
| STUDY_ID | TEXT | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
| CDR_SPECIMEN_REQUEST_SK | INTEGER | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
| ORGANISM_SPECIES_NAME | TEXT | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
| SPECIMEN_DATE | TEXT | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
| LAB_REPORT_DATE | TEXT | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
| PATIENT_POSTCODE | TEXT | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
| ETHNICITY_DESCRIPTION | TEXT | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
| AGE_IN_YEARS | REAL | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
| PATIENT_SEX | TEXT | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
| COUNTY_DESCRIPTION | TEXT | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
| ODS_LOCATION_CODE | TEXT | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
| LOWER_SUPER_OUTPUT_AREA_CODE | TEXT | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
| POSTCODE_SOURCE | TEXT | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
| REPORTING_LAB_ID | INTEGER | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
| REPORTING_LAB | TEXT | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
| PCDS | TEXT | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
| PCDS_SECTOR | TEXT | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
| LATITUDE | REAL | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
| LONGITUDE | REAL | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
| MPS_TRACE_SUCCESSFUL | TEXT | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
| EPCC_DATE_RECEIVED | DATE | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |
| EPCC_DATE_INSERTED | TIMESTAMP | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] | [Replace] |