Per Diem Batch Processing

Travel, Entertainment and Moving > TEM Batch Processes

Per Diem Batch Processing

The following rules apply regardless of the type of the file that is loaded.

• Per Diem files should only be loaded when a new per diem file has been issued by the federal government. The batch process will prevent duplicate uploads and old records will have the Effective To Date set to end the rate with a date earlier than the new Effective From Date. Parameter DEFAULT_EFFECTIVE_TO_DATE is used when a valid effective to date does not exist.

• Although the federal data includes both Season End Date and Expiration Date, this data is not loaded into the Per Diem tables. Instead, the system assumes that each Season Begin Date is effective unless there is a record with a newer Season Begin Date and the Expiration Date is not used in favor of an Effective To date.

• When loading CONUS data, the system breaks down local_meals value into breakfast, lunch, dinner, and incidentals according to the percentages specified in the Per Diem Meals and Incidentals Breakdown table for the applicable total. If there isn’t a match in the table to the total specified in the CONUS record, the system uses the value specified in your institution’s CONUS_MEAL_BREAKDOWN parameter to obtain the percentages applied to breakfast, lunch and dinner. The remaining amount is entered in the incidentals field.

• When loading OCONUS data the system uses the local_meals value to determine breakfast, lunch and dinner based on the values stored in your institution’s OCONUS_MEALS_BREAKDOWN parameter (for example, B=15;L=25;D=40, which represent the percentages for breakfast, lunch and dinner, respectively). The remaining amount is entered in the incidentals field.

• The country_code is compared to the State Abbreviation in the State Code table:

o If the Country Code is not US, the system loads the OCONUS rate as International trip type.

o If the Country Code is US, the system loads it as either in-state or out-of-state depending on the setting of your institution’s INSTITUTION_STATE parameter.

Description: Description: pencil-small.gif Parameters IN_STATE_TRIP_TYPE_CODE, INTERNATIONAL_TRIP_TYPE_CODE and OUT_OF_STATE_TRIP_TYPE_CODE are used to update the trip type field in the per diem table.