Adjustments Template CSV file
The fields on the exported Adjustments Template CSV file are populated with the job class information for your property.
Caution: If two or more rows contain the same Start Date, End Date, Reconcile Code ID, Adjustment Type, and Description, the duplicate rows will not be imported. Likewise, if you previously created an adjustment with the same Start Date, End Date, Reconcile Code ID, Adjustment Type, and Description, the duplicate rows will not be imported.
Fields on the Adjustments Template CSV file
Column | Field | Description | Notes |
---|---|---|---|
A |
Start Date |
Date on which the adjustments begins. |
Required. Format: MM/DD/YYYY Default: Year of the working dataset. |
B |
End Date |
Date on which the adjustments ends. |
Required. Format: MM/DD/YYYY Default: Year of the working dataset. |
C |
Reconcile Code ID |
Reconcile code ID configured for the job class. |
Required. Do not edit. If there are multiple reconcile code IDs for a job, the field will contain the first ID associated with the job. |
D |
Job Name |
Name of the job to which the adjustment is applied. |
Format is the full path name of the job. Example: "Resort\Administration and General\Innkeeper". Do not edit. Jobs are sorted alphabetically in the following order: Division, Department, Job. |
E |
Amount |
Amount for the adjustment. The number can be for either dollar values or hours. |
Required. Numeric only. You can enter positive or negative values. |
F |
Adjustment Type (R, H, OT) |
Enter the type of adjustment:
|
Required. Format:
|
G |
Description |
A brief description of the adjustment. This description appears with an asterisk ( * ) in the Adjust Hours and Rates screen. Examples:
|
Required. Although there is a 50-character limit in the corresponding database, Unifocus recommends that you keep this description as short as possible. |
H |
Notes |
A note about the adjustment. |
|
I |
Job Rate Override (Y/N) |
Yes (Y) or No (N)—the amount will override the average rate for the job in the selected date range. Options include:
|
Required. Format:
|