Imported Data
The application requires the absolute path and filename for the CSV (comma-separated values) file to import or export. This file must be located on the same machine as the Job Scheduler or on a shared network path that the Job Scheduler can access.
You cannot configure which columns are used to import data.
This table describes the required file structure for importing plan data:
| Field Name | Field Type | Description | Mandatory /Optional |
|---|---|---|---|
| FC_NAME | VARCHAR(40) | Plan name. | Mandatory |
| SKDGRP_NAME | STRING | Root location of plan to export. | Mandatory |
| FCTP_DATE | TIMESTAMP | Time period date. The date format must be: MM/dd/yyyy . asked Hoan if this is start of time period, but he didn't know | Mandatory |
| FCTP_NAME | VARCHAR(40) | Time Period Name (for example, Week1 2005, Week25 2005). | Mandatory |
| FCIT_SALES | DECIMAL(20, 8) | Sales for this time period and location. | Mandatory |
| FCIT_AHR | DECIMAL(10, 12) | Average Hourly Rate for this time period and location. | Mandatory |
| FCIT_HOURS | DECIMAL(18, 8) | Labor hours for this time period and location. | Mandatory |
| FCIT_MIN_HOURS | DECIMAL(12, 2) | Minimum labor hours for this time period and location. | Mandatory |
| FCIT_HOL_HOURS | DECIMAL(18, 8) | Estimated holiday hours for this time period and location. | Optional |
| FCIT_VAC_HOURS | DECIMAL(18, 8) | Estimated vacation hours for this time period and location. | Optional |
| FICT_OTHER_HOURS | DECIMAL(18, 8) | Estimated other hours for this time period and location. | Optional |
| FCIT_PROD_HOURS | DECIMAL(18, 8) | Productive hours for this time period and location. | Optional |
| FICT_SALES_TRD | DECIMAL(20, 8) | Actual and forecasted sales for this time period and location. | Optional |
| FCIT_PYRLL_TRD | DECIMAL(19, 8) | Actual and forecasted payroll. for this time period and location | Optional |
| FCIT_STF_REQ_HRS | DECIMAL(18, 8) | Staffing requirement hours for this time period and location. | Optional |
| FCIT_PR_FACTOR | DECIMAL(18, 8) | Variable coefficient for this time period and location. | Optional |
| FCIT_VAR_HRS | DECIMAL(18, 8) | Variable hours for this time period and location. | Optional |
| FCIT_EVT_HRS | DECIMAL(18, 8) | Event hours for this time period and location. | Optional |
| FCIT_VOL_DRV_HRS | DECIMAL(18, 8) | Volume-driven hours for this time period and location. | Optional |
| FCIT_SCH_FACTOR | DECIMAL(9, 8) | Scheduling factor for this time period and location. | Optional |
| FCIT_SCH_HRS | DECIMAL(18, 8) | Schedule hours for this time period and location. | Optional |
| FCIT_ITEM1... FCIT_ITEM20 | DECIMAL(18, 8) | User-defined fields. | Optional |