Difference between revisions of "Budget Import"
From sbv.wiki
(Created page with "The budget import adds budget items maintained in the Budget Configuration. Required Columns {| class="wikitable" |- | '''Column Type''' | '''Identifiers''' | '''Notes...") |
m |
||
| (4 intermediate revisions by one user not shown) | |||
| Line 1: | Line 1: | ||
The budget import adds budget items maintained in the [[Budget Configuration]]. | The budget import adds budget items maintained in the [[Budget Configuration]]. | ||
| − | + | An budget import is identified by the sheet name or file name containing the word "Budget". | |
{| class="wikitable" | {| class="wikitable" | ||
|- | |- | ||
| − | + | ! Column Type | |
| − | + | ! Identifiers | |
| − | + | ! Notes | |
| − | + | ! Required | |
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
|- | |- | ||
| − | | | + | | Day Of Week |
| − | Day Of Week | + | | Day Of Week |
| − | + | | All Days, Week Days, Weekend, Sunday, Monday, Tuesday, Wednesday, Thursday, Friday, Saturday | |
| − | | | + | | Yes |
| − | Day Of Week | + | |
| − | + | ||
| − | | | + | |
| − | All Days, | + | |
|- | |- | ||
| − | | | + | | Budget Labor Levels |
| − | Budget Labor Levels | + | | The ID or name of your budget based labor levels |
| − | + | | The labor level ID, labor level description or the scheduler ID. You must provide all the labor levels designated as Budget labor levels. | |
| − | | | + | | Yes |
| − | The ID or name of your budget based labor levels | + | |
| − | + | ||
| − | | | + | |
| − | The labor level ID, labor level description or the scheduler ID. You must provide all the labor levels designated as Budget labor levels. | + | |
|- | |- | ||
| − | | | + | | Shift |
| − | Shift | + | | Shift |
| − | + | | The shift ID or scheduler ID | |
| − | | | + | | Yes |
| − | Shift | + | |
| − | + | ||
| − | | | + | |
| − | The shift ID or scheduler ID | + | |
|- | |- | ||
| − | | | + | | Shift Count |
| − | Shift Count | + | | Shift Count |
| + | | The number of shifts | ||
| + | | Yes | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
|- | |- | ||
| − | | | + | | Sub Shift |
| − | + | | Sub Shift | |
| − | + | | If you want to enforce budgetary levels to a particular schedule within a shift, then you must specify the Sub Shift ID. | |
| − | | | + | | No |
| − | + | ||
| − | + | ||
| − | | | + | |
| − | + | ||
|- | |- | ||
| − | | | + | | Hours |
| − | + | | Hours | |
| − | + | | The number of hours this budget item represents | |
| − | | | + | | No |
| − | + | ||
| − | + | ||
| − | | | + | |
| − | + | ||
|- | |- | ||
| − | | | + | | Build Date |
| − | + | | Build Date | |
| − | + | |The starting date for building schedules that use this budget item. | |
| − | | | + | | No |
| − | + | ||
| − | + | ||
| − | | | + | |
| − | The | + | |
|- | |- | ||
| − | | | + | | Shift Count Overage |
| − | + | | Shift Count Overage | |
| − | + | | The shift count overage allowance | |
| − | | | + | | No |
| − | + | ||
| − | + | ||
| − | | | + | |
| − | + | ||
|- | |- | ||
| − | | | + | | Scheduler Based |
| − | + | | Scheduler or Scheduler Budget | |
| + | | If this budget item is to be used for building schedules then enter Y, Yes, T or True. | ||
| + | | No | ||
| − | | | + | |} |
| − | + | ||
| − | + | == See also == | |
| − | + | ||
| − | + | * [[Import]] | |
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
Latest revision as of 20:48, 27 April 2022
The budget import adds budget items maintained in the Budget Configuration.
An budget import is identified by the sheet name or file name containing the word "Budget".
| Column Type | Identifiers | Notes | Required |
|---|---|---|---|
| Day Of Week | Day Of Week | All Days, Week Days, Weekend, Sunday, Monday, Tuesday, Wednesday, Thursday, Friday, Saturday | Yes |
| Budget Labor Levels | The ID or name of your budget based labor levels | The labor level ID, labor level description or the scheduler ID. You must provide all the labor levels designated as Budget labor levels. | Yes |
| Shift | Shift | The shift ID or scheduler ID | Yes |
| Shift Count | Shift Count | The number of shifts | Yes |
| Sub Shift | Sub Shift | If you want to enforce budgetary levels to a particular schedule within a shift, then you must specify the Sub Shift ID. | No |
| Hours | Hours | The number of hours this budget item represents | No |
| Build Date | Build Date | The starting date for building schedules that use this budget item. | No |
| Shift Count Overage | Shift Count Overage | The shift count overage allowance | No |
| Scheduler Based | Scheduler or Scheduler Budget | If this budget item is to be used for building schedules then enter Y, Yes, T or True. | No |
