Schedule Hours of Operation Import Interface field specifications
This table lists the field-column specifications of the Schedule Hours of Operation Import. Fields with the asterisk symbol (*) are required.
| Col. | Field Name | Type | Size/Format | Description |
|---|---|---|---|---|
| 1/A | Action* | The operation performed upon import. Specify ADD, UPDATE, or DELETE. You cannot update or delete an HOP set record if the HOP set is assigned to a team. | ||
| 2/B | Hours of Operation Set Name* | Varchar | 40 | The name of the HOP set record. |
| 3/C | Hours of Operation Set Description | Varchar | 100 | The description of the HOP set. |
| 4/D | Day Entries* | Varchar | 500/HH:MM | Defines the operating hours for each day. Specify the values in this field using this format: DAY~OPEN~CLOSE|DAY~OPEN~CLOSE. Use| to separate multiple entries.
For example: 2 ~ 0900 ~ 1700| 3 ~ 0900 ~ 1700| 4 ~ 0900 ~ 1700| 5 ~ 0900 ~ 1700|6 ~ 0900 ~ 1700. This defines the operating hours as Monday to Friday from 9:00 AM to 5:00 PM, with Saturday and Sunday closed. |
| 5/E-9/I | SCHEDULE_HOURS_OF_OPERATION_Flags1...5 | Char | 1 | Five one-character flags for general use |
| 10/J | SCHEDULE_HOURS_OF_OPERATION_UDF1 | Varchar | 40 | Schedule Hours of Operation UDF 1. |
| 11/K | SCHEDULE_HOURS_OF_OPERATION_UDF2 | Varchar | 40 | Schedule Hours of Operation UDF 2. |
| 12/L | SCHEDULE_HOURS_OF_OPERATION_UDF3 | Varchar | 40 | Schedule Hours of Operation UDF 3. |
| 13/M | SCHEDULE_HOURS_OF_OPERATION_UDF4 | Varchar | 40 | Schedule Hours of Operation UDF 4. |
| 14/N | SCHEDULE_HOURS_OF_OPERATION_UDF5 | Varchar | 40 | Schedule Hours of Operation UDF 5. |
| 15/O | SCHEDULE_HRSOP_DAY_Flags1...5 | Varchar | 200 | Five 200-character Schedule Hours of Operation flags for general use. |
| 16/P | SCHEDULE_HRSOP_DAY_UDF1...5 | Varchar | 500 | Five 500-character Schedule Hours of Operation user-defined fields. |