CSV file contents

The CSV file for importing a schedule has the characteristics shown in the table.

The CSV file must include an action either ADD, UPDATE or DELETE, followed by the other required and optional fields as shown in the table.

Field Name Type Required? Size Description

Action

 Yes

ADD, UPDATE, DELETE

One action only must be specified for each file.

Schedule Profile Name

(ASSP_NAME)

 Varchar2 Yes 40 Name of the profile; must be unique.

Schedule Profile Description

(ASSP_DESC)

 Varchar2 No 60 Description of the profile.

Staffing Requirement Generation Option

(ASSRGO_ID)

 Integer No 2

If the Staffing Requirement Generation Option field is used in the file, the value must one of these:

2: Minimum requirements from location information.

3: Calculate requirements from forecast.

4: Load existing requirements.

Blank: System supplies "1" in the field, Minimum requirements from location information.

Schedule Length

(ASSP_SCHEDULE_LENGTH)

 Integer No 1

Length for the schedule generation. Must be in multiples of 7. If it is not a multiple of 7, the record is skipped.

Profile used for Batch schedule generation?

(ASSP_USE_FOR_BATCH)

 Boolean Required for ADD action If this option is set to N, the schedule profile is excluded when the batch scheduling task runs.

Enforce Schedule Crossover

(ASSP_SCHEDULE_CROSSOVER)

 Boolean No

Enable this option if the schedule is required to be used after midnight of last day current schedule and first day of the next schedule period.

Both schedule week workload requirements are required.

Team(s)

(WBT_NAME)

 Varchar2 Required for ADD action Name of the team to be associated with the schedule profile and for selection of Auto-Assignment group.

Auto Assign Group(s)

(ASG_NAME)

 Varchar2 Required for ADD action

Auto-Assignment group or groups to be used for the profile.

Auto Assign Group Weight

(ASSPG_GROUP_WEIGHT)

 Integer Required for ADD action

If multiple groups are used, specify the priority, or "weight." Values are 1-10.
Simple Scheduling (ASSP_SIMPLE_SCHEDULING) Char No 1 Use this option to enable or disable Simple Scheduling for a schedule profile. Set this option to Y to enable Simple Scheduling and N to disable it.