Relational File Format


The ALLHIST Relational file is delimited by " " a single space.

  1. OCALLHIST.ZIP includes 1 file: OCALLHIST.TXT

  2. CONUSALLHISTYYYY.ZIP includes 2 files: (Effective 10/1/2009)

    E_CONUSALLHISTYYYY.TXT Includes per diem rates for all cities, towns, counties, DOD Installations, and GSA Defined Per Diem Locations
    CONUSALLHISTYYYY.TXT
    Includes per diem rates for all Ccounties, DOD Installations, and GSA Defined Per Diem Locations

FILE STRUCTURE:

FIELD FORMAT
State/Country Code X(3)
State/Country Name X(42)
CONUS/OCONUS Indicator X(1)
City X(20)
County X(32)
Time Zone >9
Linked To State X(3)
Linked Location X(42)
DOD Indicator yes/no
Effective Date mm/dd/yyyy
Expiration Date mm/dd/yyyy
Seasonal Start Date mm/DD
Seasonal End Date mm/DD
Lodging Rate >>9
Meals & Incidentals (M&IE) Rate >>9
No Government Meals Rate
(Meals Rate Only. The $3 Incidentals rate is excluded)
>>9
Proportional Meals Rate >>9
Incidental Rate >>9
Footnote Number >>9
Footnote Rate >>9
Maximum Per Diem >>9