Exported 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.
The table below describes the default file structure for exporting plan data:
For the order of columns see relevant Mapping Definitions page, which you display using the following menu path:
| Field Name | Field Type | Description | Default Column in the BUDGET EXPORT Mapping | Default Column in the BOTTOM UP BUDGET EXPORT Mapping |
|---|---|---|---|---|
| WBIEXP_STATUS | STRING | Plan status | yes | yes |
| WBIEXP_MSG | STRING | Any messages in the Messages column on the Worksheet. | yes | yes |
| FC_NAME | VARCHAR(40) | Plan name. | yes | yes |
| SKDGRP_NAME | STRING | Root location of plan to export. | yes | yes |
| FCTP_DATE | TIMESTAMP | Time period date. The date format must be: MM/dd/yyyy. | yes | yes |
| FCTP_NAME | VARCHAR(40) | Time Period Name (for example, Week1 2005, Week25 2005). | yes | yes |
| FCIT_SALES | DECIMAL(20, 8) | Sales for this time period and location. | yes | yes |
| FCIT_AHR | DECIMAL(10, 12) | Average Hourly Rate for this time period and location. | yes | yes |
| FCIT_STF_REQ_HRS | DECIMAL(18, 8) | Staffing requirement hours for this time period and location. | no | yes |
| FCIT_HOURS | DECIMAL(18, 8) | Labor hours for this time period and location. | yes | yes |
| FCIT_MIN_HOURS | DECIMAL(12, 2) | Minimum labor hours for this time period and location. | yes | yes |
| FCIT_HOL_HOURS | DECIMAL(18, 8) | Estimated holiday hours for this time period and location. | yes | yes |
| FCIT_VAC_HOURS | DECIMAL(18, 8) | Estimated vacation hours for this time period and location. | yes | yes |
| FICT_OTHER_HOURS | DECIMAL(18, 8) | Estimated other hours for this time period and location. | yes | yes |
| FCIT_PROD_HOURS | DECIMAL(18, 8) | Productive hours for this time period and location. | yes | no |
| FICT_SALES_TRD | DECIMAL(20, 8) | Forecasted sales trend for this time period and location. | yes | no |
| FCIT_PYRLL_TRD | DECIMAL(19, 8) | Actual and forecasted payroll. for this time period and location | yes | no |
| FCIT_PR_FACTOR | DECIMAL(18, 8) | Variable coefficient for this time period and location. | no | yes |
| FCIT_VAR_HRS | DECIMAL(18, 8) | Variable hours for this time period and location. | no | yes |
| FCIT_EVT_HRS | DECIMAL(18, 8) | Event hours for this time period and location. | no | yes |
| FCIT_VOL_DRV_HRS | DECIMAL(18, 8) | Volume-driven hours for this time period and location. | no | yes |
| FCIT_SCH_FACTOR | DECIMAL(9, 8) | Scheduling factor for this time period and location. | no | yes |
| FCIT_SCH_HRS | DECIMAL(18, 8) | Schedule hours for this time period and location. | no | yes |
| FCIT_MAX_HOURS | DECIMAL(12, 2) | Maximum labor hours for this time period and location. | no | yes |
| FCIT_PAYROLL | DECIMAL(19, 8) | Payroll from the budget for this time period and location. | yes | yes |
| FCIT_PAYROLL_PCT | DECIMAL(15, 2) | Payroll percent for this time period and location. | yes | yes |
| FCIT_SPH | DECIMAL(12, 2) | Sales per hour for this time period and location. | yes | yes |
| SKDGRP_ID | DECIMAL(22, 0) | Schedule group ID column in the database. | yes | no |
| FCIT_ITEM1... FCIT_ITEM20 | DECIMAL(18, 8) | User-defined fields. | yes | yes |