ColumnName |
Domain |
Datatype |
NULL |
Definition |
USER_COMPANY_ID |
|
VARCHAR2(30) |
NO |
Name: Domain. Description: Alias for database schema that will be updated. |
S_IMPORT_CD |
|
VARCHAR2(1) |
NO |
Name: Import Type. Description: Indicates the type of transaction. The valid values are: A - Add. C - Change. D - Delete. B - Batch |
TIME_STAMP |
|
DATE |
NO |
Name: Time Stamp. Description: A time/date stamp that indicates when the record was originally inserted into table. |
EXTERNAL_USER |
|
VARCHAR2(20) |
NO |
Name: External User. Description: User ID of the non-TC user initiating the insert into the Import table. |
COUNTRY_NAME |
|
VARCHAR2(45) |
NO |
Name: Country. Description: The name of the country for the schedule location. |
STATE_NAME |
|
VARCHAR2(35) |
NO |
Name: State. Description: The name of the state for the schedule location. |
CITY_NAME |
|
VARCHAR2(35) |
NO |
Name: City. Description: The name of the city for the schedule location. |
COUNTY_NAME |
|
VARCHAR2(35) |
NO |
Name: County. Description: The name of the county for the schedule location. |
EFFECTIVE_DT |
|
DATE |
NO |
Name: Effective Date. Description: The date the schedule was effective. |
SEASON_START_DATE |
|
VARCHAR2(5) |
NO |
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 |
|
VARCHAR2(5) |
NO |
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 |
|
NUMBER(15, 5) |
NO |
Name: Lodging Amount. Description: The amount allocated for Lodging for this schedule. (Exclusive of Taxes). |
MEAL_INCIDENTAL_AMT |
|
NUMBER(15, 5) |
NO |
Name: Meal Incidental Amount. Description: The amount allocated for Meals and Incidentals for this schedule. |
S_SOURCE_CD |
|
VARCHAR2(1) |
NO |
Name: Source. Description: Indicates the source of the rate schedules. The valid values are: C – CONUS. O – OCONUS. U - User |
S_LOCATION_TYPE_CD |
|
VARCHAR2(1) |
NO |
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 |
|
NUMBER(15, 5) |
NO |
Name: Proportional Meals. Description: The proportional meal allowance for this schedule. |