2.4 Workorder dataset


Grain (level of Detail): This data set can provide information per work order id.

Attribute

Definition

Accommodation

Within this header, you will find 6 attributes to provide information about the accommodation on different levels of detail. This is based on the tree structure in Maxxton Software

Accommodation

It represents actual accommodation (Object).
Attribute form ID is prefixed by “A-“ for accommodation and “AT-“ in case of Accommodation type.
Accommodation types are required for the analysis of bookings at Accommodation-type.

Note : If multiple accommodations are associated with a work order, then the value of an attribute Accommodation will be shown as Unknown,

Accommodation Level 1

It shows the level of Accommodation type in the hierarchy configured in Maxxton Software under Location.

Level 1 is the highest level while level 5 is the lowest level in the hierarchy.

If fewer than 5 levels are configured in Maxxton Software, then the value of the remaining levels from the lowest level will be repeated.

e.g. If  there are only 2 levels of accommodation types configured in Maxxton Software, then values in 2nd level will be repeated for levels 3,4 & 5.

Accommodation Level 2
Accommodation Level 3
Accommodation Level 4
Accommodation Level 5

Assigned Employee


Assigned EmployeeEmployee to whom the specific work order is assigned.
Assigned Employee groupEmployee group of assigned employee

Created By Employee


Created By EmployeeAn employee who created the workorder
Created By Employee GroupEmployee group of the employee who created the workorder

Expected End Date


Expected End DateExpected end date of the workorder.
Expected End Date of WeekThe day of the week the workorder is expected to end
Expected End Date ISO Week

The ISO week in which this date is classified

Expected End Date ISO YearThe ISO year in which this date is classified
Expected End Date MonthThe month the workorder is expected to end
Expected End Date QuarterThe quarter the workorder is expected to end
Expected End Date YearThe year the workorder is expected to end

Expected Start Date

With in this header you will find 7 attributes to provide information about the expected start date of the work order

Expected Start DateThe expected Start date of the workorder.
Expected Start Date Day of WeekThe day of the week the workorder is expected to start
Expected Start Date ISO Year

The ISO week in which this date is classified

Expected Start Date MonthThe ISO year in which this date is classified
Expected Start Date QuarterThe month the workorder is expected to start
Expected Start Date YearThe quarter the workorder is expected to start
Expected Start Date ISO WeekThe year the workorder is expected to start

Invoice Date


Invoice DateInvoice date of the work order
Invoice Date Day of Week

The day of the week the workorder is invoiced

Invoice Date ISO Week

The ISO week in which this date is classified

Invoice Date ISO YearThe ISO year in which this date is classified
Invoice Date MonthThe month the workorder is invoiced
Invoice Date QuarterThe quarter the workorder is invoiced
Invoice Date YearThe year the workorder is invoiced

Location


Location CountryThis will give the country name of the Location (Resort) for which the work order is created.
Location Level 1

It shows level of resorts in the hierarchy configured in Maxxton Software.

Level 1 is the highest level while level 5 is the lowest level in the hierarchy.

If less than 5 levels are configured in Maxxton Software, then the value of the remaining levels from the lowest level will be repeated.

e.g. If  there are only 2 levels of resorts configured in Maxxton Software, then values in 2nd level will be repeated for levels 3,4 & 5.

Location Level 2
Location Level 3
Location Level 4
Location Level 5

Material Supplier


Material SupplierMaterial supplier name
Material Supplier DescriptionMaterial supplier description

Reported Date


Reported DateReported date of the workorder
Reported Date Day Of WeekThe day of the week the workorder is reported
Reported Date ISO Week

The ISO week in which this date is classified

Reported Date ISO YearThe ISO year in which this date is classified
Reported Date MonthThe month the workorder is reported
Reported Date QuarterThe quarter the workorder is reported
Reported Date YearThe year the workorder is reported

Resolver dates


Resolver EmployeeAn employee who resolved specific workorder
Resolver Employee groupEmployee group of Resolver Employee

Solved Date


Solved DateSolved date of the workorder
Solved Date Day of WeekThe day of the week the workorder is solved
Solved Date ISO Week

The ISO week in which this date is classified

Solved Date ISO YearThe ISO year in which this date is classified
Solved Date MonthThe month the workorder is solved
Solved Date QuarterThe quarter the workorder is solved
Solved Date YearThe year the workorder is solved

Work Time Added Date


Work Time Added DateWork time added date of the work order
Work Time Added Date Day Of WeekThe day of the week the workorder time is added
Work Time Added Date ISO Week Year

The ISO week in which this date is classified

Work Time Added Date ISO YearThe ISO year in which this date is classified
Work Time Added Date MonthThe month the workorder time is added
Work Time Added Date QuarterThe quarter the workorder time is added
Work Time Added Date YearThe year the workorder time is added

Work order


Reported At Departure

Whether the particular work order is reported at the departure of a specific reservation.

For this, it will check whether the check box reported at departure is checked or not for a particular work order.

Work order  AreaArea for particular workorder
Work order CategoryCategory of workorder
Work order IDId of work order
Work order ItemWorkorder item
Work order Payera payer of the specific workorder
Work order PriorityPriority of particular workorder
Work order ReservationReservation for workorder
Work order StatusStatus of the workorder
Work order TypeType of the workorder e.g. workorder or Task

Metrics

Definition

Number of work order

Number of workorders

Price

Price of workorder.

Purchase Price

Purchase price of material which is used in a particular work order

Trip Charge

Trip charge amount of particular work order.

Work Time

Work time required by an assigned employee to solve particular work order