Budget Import - Revision history

Srooley at 20:48, 27 April 2022

2022-04-27T20:48:43Z

Stage at 03:30, 2 May 2016

2016-05-02T03:30:28Z

Stage at 03:28, 2 May 2016

2016-05-02T03:28:25Z

Stage at 03:20, 2 May 2016

2016-05-02T03:20:44Z

Stage at 17:05, 6 June 2015

2015-06-06T17:05:10Z

Stage: Created page with "The budget import adds budget items maintained in the Budget Configuration. Required Columns {| class="wikitable" |- | '''Column Type''' | '''Identifiers''' | '''Notes..."

2015-05-08T19:23:10Z

Created page with "The budget import adds budget items maintained in the Budget Configuration. Required Columns {| class="wikitable" |- | '''Column Type''' | '''Identifiers''' | '''Notes..."

New page

The budget import adds budget items maintained in the [[Budget Configuration]].

Required Columns

{| class="wikitable"
|-
|
'''Column Type'''

|
'''Identifiers'''

|
'''Notes'''

|-
|
Day Of Week

|
Day Of Week

|
All Days, Weekdays, Weekend, Sunday, Monday, Tuesday, Wednesday, Thursday, Friday, Saturday

|-
|
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.

|-
|
Shift

|
Shift

|
The shift ID or scheduler ID

|-
|
Shift Count

|
Shift Count

|
The number of shifts

|}

Optional Columns

{| class="wikitable"
|-
|
'''Column Type'''

|
'''Identifiers'''

|
'''Notes'''

|-
|
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.

|-
|
Hours

|
Hours

|
The number of hours this budget item represents

|-
|
Build Date

|
Build Date

|
The starting date for building schedules that use this budget item.

|-
|
Shift Count Overage

|
Shift Count Overage

|
The shift count overage allowance

|-
|
Scheduler Based

|
Scheduler or Scheduler Budget

|
If this budget item is to be used for building schedules then enter Y, Yes, T or True.

|}

← Older revision		Revision as of 03:30, 2 May 2016
Line 1:		Line 1:
−	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".	+	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"

← Older revision		Revision as of 03:28, 2 May 2016
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"

← Older revision		Revision as of 03:20, 2 May 2016
Line 63:		Line 63:

	\|}		\|}
		+
		+	== See also ==
		+
		+	* [[Import]]

@@ Line 13: / Line 13: @@
 | Day Of Week
 | Day Of Week
-| All Days, Weekdays, Weekend, Sunday, Monday, Tuesday, Wednesday, Thursday, Friday, Saturday
+| All Days, Week Days, Weekend, Sunday, Monday, Tuesday, Wednesday, Thursday, Friday, Saturday
 | Yes

@@ Line 1: / Line 1: @@
 The budget import adds budget items maintained in the [[Budget Configuration]].
 {| class="wikitable"
 |-
+! Column Type
-'''Column Type'''
+! Identifiers
+! Notes
+! Required
-'''Identifiers'''
-−
-−
-'''Notes'''
 |-
 | Day Of Week
-Day Of Week
+| Day Of Week
 | All Days, Weekdays, Weekend, Sunday, Monday, Tuesday, Wednesday, Thursday, Friday, Saturday
+| Yes
 Day Of Week
-−
-−
 All Days, Weekdays, Weekend, Sunday, Monday, Tuesday, Wednesday, Thursday, Friday, Saturday
 |-
 | 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
 |-
+| Sub Shift
-'''Column Type'''
+| 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
-'''Identifiers'''
-−
-−
-'''Notes'''
 |-
+| Hours
-Sub Shift
+| Hours
+| The number of hours this budget item represents
+| No
-Sub Shift
-−
-−
-If you want to enforce budgetary levels to a particular schedule within a shift, then you must specify the Sub Shift ID.
 |-
+| Build Date
-Hours
+| Build Date
+|The starting date for building schedules that use this budget item.
+| No
-Hours
-−
-−
-The number of hours this budget item represents
 |-
+| Shift Count Overage
-Build Date
+| Shift Count Overage
+| The shift count overage allowance
+| No
-Build Date
-−
-−
-The starting date for building schedules that use this budget item.
 |-
 | Scheduler Based
-Shift Count Overage
+| Scheduler or Scheduler Budget
 | If this budget item is to be used for building schedules then enter Y, Yes, T or True.
+| No
-Shift Count Overage
-−
-−
-The shift count overage allowance
-−
-|-
-−
 Scheduler Based
-−
-−
 Scheduler or Scheduler Budget
-−
-−
 If this budget item is to be used for building schedules then enter Y, Yes, T or True.
 |}