IMPORT_PER_DIEM 
Default Table Name  IMPORT_PER_DIEM 
Definition 
 Name: Import Per Diem Data.     Description: This staging table contains Per Diem data that will be imported to Deltek Time and Expense if validations are passed.
 

IMPORT_PER_DIEM Attributes 
Attribute/Logical Rolename  Domain  Datatype  NULL  Definition 
USER_COMPANY_ID    VARCHAR(30)  NO 
Name: Domain. Description: Alias for database schema that will be updated.
 
S_IMPORT_CD    VARCHAR(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    VARCHAR(20)  NO 
Name: External User. Description: User ID of the non-TC user initiating the insert into the Import table. 
 
COUNTRY_NAME    VARCHAR(45)  NO 
Name: Country. Description: The name of the country for the schedule location.
 
STATE_NAME    VARCHAR(35)  NO 
Name: State. Description: The name of the state for the schedule location.
 
CITY_NAME    VARCHAR(35)  NO 
Name: City. Description: The name of the city for the schedule location.
 
COUNTY_NAME    VARCHAR(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    VARCHAR(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    VARCHAR(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    NUMERIC(15, 5)  NO 
Name: Lodging Amount. Description: The amount allocated for Lodging for this schedule. (Exclusive of Taxes).
 
MEAL_INCIDENTAL_AMT    NUMERIC(15, 5)  NO 
Name: Meal Incidental Amount. Description: The amount allocated for Meals and Incidentals for this schedule. 
 
S_SOURCE_CD    VARCHAR(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    VARCHAR(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    NUMERIC(15, 5)  NO 
Name: Proportional Meals. Description: The proportional meal allowance for this schedule.
 

IMPORT_PER_DIEM Keys 
Key Name  Key Type  Keys 

IMPORT_PER_DIEM Relationships 
Parent Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype 
Child Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype