PER_DIEM_SCHEDULE_CD |
ColumnName | PER_DIEM_SCHEDULE_CD |
Definition | Name: Per Diem Schedule. Description: The identifier for the schedule. |
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: M and IE Amount. Description: The amount allocated for Meals and Incidentals for this schedule. |
MODIFIED_BY |
ColumnName | MODIFIED_BY |
Definition | Name: Modified By. Description: The User ID of the person who last modified this record. |
ROWVERSION |
ColumnName | ROWVERSION |
Definition | Name: Row Version. Description: The number of times this record has been updated. |
TIME_STAMP |
ColumnName | TIME_STAMP |
Definition | Name: Time Stamp. Description: Date and time the record was last modified. |
S_LOCATION_TYPE_CD |
ColumnName | S_LOCATION_TYPE_CD |
Definition | Name: . 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 | Proportional Meals Amount. The proportional meal allowance for this schedule. |
S_SCHEDULE_SOURCE_CD |
ColumnName | S_SCHEDULE_SOURCE_CD |
Definition | Name: Source. Description: Indicates the source of the rate schedules. The valid values are: C – CONUS. O – OCONUS. U – User |
S_MEALS_SOURCE_CD |
ColumnName | S_MEALS_SOURCE_CD |
Definition | Name: Meal Source. Description: Indicates the source of the meals and incidental amounts. The valid values are: C – CONUS. O – OCONUS. U - User |
OVERRIDE_COUNTRY_NAME |
ColumnName | OVERRIDE_COUNTRY_NAME |
Definition | Name: Override Country Name. Description: If a value exists in this column it will replace the Country name on the expense report/authorization. |
OVERRIDE_STATE_NAME |
ColumnName | OVERRIDE_STATE_NAME |
Definition | Name: Override State Name. Description: If a value exists in this column it will replace the State name on the expense report/authorization. |
OVERRIDE_CITY_NAME |
ColumnName | OVERRIDE_CITY_NAME |
Definition | Name: Override City Name. Description: If a value exists in this column it will replace the City name on the expense report/authorization. |
OVERRIDE_COUNTY_NAME |
ColumnName | OVERRIDE_COUNTY_NAME |
Definition | Name: Override Country Name. Description: If a value exists in this column it will replace the County name on the expense report/authorization. |
TERMINATE_DT |
ColumnName | TERMINATE_DT |
Definition | Name: Terminate Date. Description: The date this record is to be considered terminated. |