Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


Table of Contents


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

Attribute

Definition

Accommodation

Within this header you will find 8 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 or accommodation type(Object).
Attribute form ID is prefixed by “A-“ for accommodation and “AT-“ in case of Accommodation type.
Accommodation-types are required for analysis of bookings at Accommodation-type.

This indicates what kind of accommodation it is

Note : If for specific work order multiple accommodations (objects) are there then it in linked reservation of work order then in dashboard it will show UNKNOWN

Accommodation Kind

.

For example a villa, camping place, beach lodge or a chalet. 

Accommodation Level 1

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

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

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

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

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

This indicates what type of accommodation it is. For example, "Accommodation", "Implied Accommodation" or "Accommodation Type"

Accommodation : it represents actual accommodation having Exclude availability in BI is not checked.
Implied Accommodation : it represents actual accommodation having Exclude availability in BI is checked.
Accommodation Type : it represents accommodation-type.


Assigned Employee

With in this header you will find 2 attributes to provide information about to employee name or employee group to whom the specific work order is assigned assigned.

Assigned EmployeeThis will give the employee name to whom the specific work order is assigned  assigned.
Assigned Employee groupThis will give the employee group name of the specific employee to whom the work order is assigned.


Created By Employee

With in this header you will find 2 attributes to provide information about to employee name or employee group to whom the specific work order is assigned assigned.

Created By EmployeeThis will give the employee name who created specific work order in system.
Created By Employee GroupThis will give the employee group name who created specific work order in system.


Expected End Date

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

Expected End DateThis will give the expected end date of the created work order.
Expected End Date of WeekName of day for the expected end date e.g Monday,Tuesday etc..
Expected End Date ISO Week

The ISO week in which this date is classified e.g. any number from 1 to 53.

Expected End Date ISO YearThe ISO year in which this date is classified e.g. 2019, 2020.
Expected End Date MonthName of month e.g. January, February etc..
Expected End Date QuarterQuarter of year e.t. Q1, Q2 etc..
Expected End Date YearYear e.g. 2019, 2020 etc..


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 DateThis will give the Expected Start date of the created work order.
Expected Start Date Day of WeekName of day for the Expected Start date e.g Monday,Tuesday etc...
Expected Start Date ISO Year

The ISO week in which this date is classified e.g. any number from 1 to 53.

Expected Start Date MonthThe ISO year in which this date is classified e.g. 2019, 2020.
Expected Start Date QuarterName of month e.g. January, February etc...
Expected Start Date YearQuarter of year e.t. Q1, Q2 etc..
Expected Start Date ISO WeekYear e.g. 2019, 2020 etc..


Invoice Date

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

Invoice DateThis will give the Invoice date of the created work order.
Invoice Date Day of WeekName of day for the invoice date e.g Monday,Tuesday etc...
Invoice Date ISO Week

The ISO week in which this date is classified e.g. any number from 1 to 53.

Invoice Date ISO YearThe ISO year in which this date is classified e.g. 2019, 2020.
Invoice Date MonthName of month e.g. January, February etc...
Invoice Date QuarterQuarter of year e.t. Q1, Q2 etc...
Invoice Date YearYear e.g. 2019, 2020 etc...


Location

With in this header you will find 7 attributes to provide information about Location Hierarchy (Resort names with hierarchy) for particular work order.

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 hierarchy configured in Maxxton Software.

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

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

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

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


Material Supplier

With in this header you will find 2 attributes to provide information about Material supplier and Material Supplier Description.

Material SupplierThis will give the material supplier name for particular work order.
Material Supplier DescriptionThis will give the material supplier description.


Reported Date

With in this header you will find 7 attributes to provide information about reported date for particular work order.

Reported DateThis will give the Reported date of the created work order.
Reported Date Day Of WeekName of day for the Reported date e.g Monday,Tuesday etc...
Reported Date ISO Week

The ISO week in which this date is classified e.g. any number from 1 to 53.

Reported Date ISO YearThe ISO year in which this date is classified e.g. 2019, 2020.
Reported Date MonthName of month e.g. January, February etc...
Reported Date QuarterQuarter of year e.t. Q1, Q2 etc..
Reported Date YearYear e.g. 2019, 2020 etc..


Resolver dates

With in this header you will find 2 attributes to provide information about resolver employee for particular work order.

Resolver EmployeeThis will give the employee name who resolved specific work order in system.
Resolver Employee groupThis will give the employee group name of the specific employee who resolved specific work order.


Solved Date

With in this header you will find 7 attributes to provide information about solved date for particular work order.

Solved DateThis will give the Solved date of the created work order.
Solved Date Day of WeekName of day for the Solved date e.g Monday,Tuesday etc...
Solved Date ISO Week

The ISO week in which this date is classified e.g. any number from 1 to 53.

Solved Date ISO YearThe ISO year in which this date is classified e.g. 2019, 2020.
Solved Date MonthName of month e.g. January, February etc...
Solved Date QuarterQuarter of year e.t. Q1, Q2 etc..
Solved Date YearYear e.g. 2019, 2020 etc...


Work Time Added Date

With in this header you will find 7 attributes to provide information about Work order added time for particular work order

Work Time Added DateThis will give the Work time added date of the created work order
Work Time Added Date Day Of WeekName of day for the Work time added date e.g Monday,Tuesday etc.
Work Time Added Date ISO Week Year

The ISO week in which this date is classified e.g. any number from 1 to 53

Work Time Added Date ISO YearThe ISO year in which this date is classified e.g. 2019, 2020
Work Time Added Date MonthName of month e.g. January, February etc.
Work Time Added Date QuarterQuarter of year e.t. Q1, Q2 etc
Work Time Added Date YearYear e.g. 2019, 2020 etc.


Work order

With in this header you will find 10 attributes to provide information for particular work order.

Reported At Departure

This will give information whether the particular work order is reported at departure of specific reservation.

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

Work order  AreaThis will area name for particular work order.
Work order CategoryThis will give work order category name.
Work order IDThis is the id of created work order.
Work order ItemName of the work order item.
Work order PayerThis will give information for the payer of the specific work order.
Work order PriorityThis will give the priority of particular work order.
Work order ReservationThis will give linked reservation number for particular work order.
Work order StatusThis will give the status of the particular work order.
Work order TypeThis will give type of the work order (work order or Task).


...