nhsd_iapt_header_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
HEADER_ID	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
FILE_TYPE	TEXT	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
END_PROCESSING_DATE	TEXT	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
COMPLETION_TIME	TEXT	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
START_DATE	TEXT	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
END_DATE	TEXT	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
TOTAL_RECORDS	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
BSP_UNIQUE_ID	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
ORGCODEPROVIDER	TEXT	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
MONTH_ID	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]
QUARTER_ID	INTEGER	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]	[Replace]