USER_COMPANY_ID 
ColumnName  USER_COMPANY_ID 
Definition 
Name: Domain. Description: Alias for database schema that will be updated.
 

S_IMPORT_CD 
ColumnName  S_IMPORT_CD 
Definition 
Name: Import Type. Description: Indicates the type of transaction. The valid values are: A - Add. C - Change. D - Delete. B - Batch 
 

TIME_STAMP 
ColumnName  TIME_STAMP 
Definition 
Name: Time Stamp. Description: A time/date stamp that indicates when the record was originally inserted into table.
 

EXTERNAL_USER 
ColumnName  EXTERNAL_USER 
Definition 
Name: External User. Description: User ID of the non-TC user initiating the insert into the Import table. 
 

COUNTRY_NAME 
ColumnName  COUNTRY_NAME 
Definition 
Name: Country. Description: The name of the country for the schedule location.
 

STATE_NAME 
ColumnName  STATE_NAME 
Definition 
Name: State. Description: The name of the state for the schedule location.
 

CITY_NAME 
ColumnName  CITY_NAME 
Definition 
Name: City. Description: The name of the city for the schedule location.
 

COUNTY_NAME 
ColumnName  COUNTY_NAME 
Definition 
Name: County. Description: The name of the county for the schedule location.
 

EFFECTIVE_DT 
ColumnName  EFFECTIVE_DT 
Definition 
Name: Effective Date. Description: The date the schedule was effective.
 

SEASON_START_DATE 
ColumnName  SEASON_START_DATE 
Definition 
Name: Season Start MM/DD. Description: The month and date that the schedule starts. Format must e MM/DD. For non-seasonal schedules then this field should be 01/01.
 

SEASON_END_DATE 
ColumnName  SEASON_END_DATE 
Definition 
Name: Season End MM/DD. Description: The month and date that the schedule ends. Format must e MM/DD. For non-seasonal schedules then this field should be 12/31.
 

LODGING_AMT 
ColumnName  LODGING_AMT 
Definition 
Name: Lodging Amount. Description: The amount allocated for Lodging for this schedule. (Exclusive of Taxes).
 

MEAL_INCIDENTAL_AMT 
ColumnName  MEAL_INCIDENTAL_AMT 
Definition 
Name: Meal Incidental Amount. Description: The amount allocated for Meals and Incidentals for this schedule. 
 

S_SOURCE_CD 
ColumnName  S_SOURCE_CD 
Definition 
Name: Source. Description: Indicates the source of the rate schedules. The valid values are: C – CONUS. O – OCONUS. U - User
 

S_LOCATION_TYPE_CD 
ColumnName  S_LOCATION_TYPE_CD 
Definition 
Name: Location Type. Description: Indicates the type of location the schedule is. The valid values are: C – Civilian. M – Military. B - Both. U - User
 

PROPORTIONAL_MEALS_AMT 
ColumnName  PROPORTIONAL_MEALS_AMT 
Definition 
Name: Proportional Meals. Description: The proportional meal allowance for this schedule.