FieldTypeDescriptionExample
DATEDATEDate2021-01-15
HOURVARCHAR(5)Hour14:00
AIRPORTVARCHAR(50)IATA airport codeATL
AIRPORT_NAMEVARCHAR(50)Airport nameHartsfield Atlanta Innternational
CITYVARCHAR(50)City nameAtlanta
STATEVARCHAR(2)State codeGA
CHECKPOINTVARCHAR(50)Security checkpointNew T North Checkpoint
PMISNUMBER(10,0)Number of Passengers from TSA’s Performance Management Information System (PMIS)456
FILENAMEVARCHAR(100)Raw input file name. It could be “ESTIMATE” or “FILL”, which means the data is estimated based on some other data.tsa-throughput-january-10-2021-to-january-16-2021.pdf