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 Employee | Employee to whom the specific work order is assigned. | | Assigned Employee group | Employee group of assigned employee |
|
Created By Employee |
| Created By Employee | An employee who created the workorder | | Created By Employee Group | Employee group of the employee who created the workorder |
|
Expected End Date |
| Expected End Date | Expected end date of the workorder. | | Expected End Date of Week | The 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 Year | The ISO year in which this date is classified | | Expected End Date Month | The month the workorder is expected to end | | Expected End Date Quarter | The quarter the workorder is expected to end | | Expected End Date Year | The 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 Date | The expected Start date of the workorder. | | Expected Start Date Day of Week | The 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 Month | The ISO year in which this date is classified | | Expected Start Date Quarter | The month the workorder is expected to start | | Expected Start Date Year | The quarter the workorder is expected to start | | Expected Start Date ISO Week | The year the workorder is expected to start |
|
Invoice Date |
| Invoice Date | Invoice 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 Year | The ISO year in which this date is classified | | Invoice Date Month | The month the workorder is invoiced | | Invoice Date Quarter | The quarter the workorder is invoiced | | Invoice Date Year | The year the workorder is invoiced |
|
Location |
| Location Country | This 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 Supplier | Material supplier name | | Material Supplier Description | Material supplier description |
|
Reported Date |
| Reported Date | Reported date of the workorder | | Reported Date Day Of Week | The day of the week the workorder is reported | | Reported Date ISO Week | The ISO week in which this date is classified | | Reported Date ISO Year | The ISO year in which this date is classified | | Reported Date Month | The month the workorder is reported | | Reported Date Quarter | The quarter the workorder is reported | | Reported Date Year | The year the workorder is reported |
|
Resolver dates |
| Resolver Employee | An employee who resolved specific workorder | | Resolver Employee group | Employee group of Resolver Employee |
|
Solved Date |
| Solved Date | Solved date of the workorder | | Solved Date Day of Week | The day of the week the workorder is solved | | Solved Date ISO Week | The ISO week in which this date is classified | | Solved Date ISO Year | The ISO year in which this date is classified | | Solved Date Month | The month the workorder is solved | | Solved Date Quarter | The quarter the workorder is solved | | Solved Date Year | The year the workorder is solved |
|
Work Time Added Date |
| Work Time Added Date | Work time added date of the work order | | Work Time Added Date Day Of Week | The 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 Year | The ISO year in which this date is classified | | Work Time Added Date Month | The month the workorder time is added | | Work Time Added Date Quarter | The quarter the workorder time is added | | Work Time Added Date Year | The 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 Area | Area for particular workorder | | Work order Category | Category of workorder | | Work order ID | Id of work order | | Work order Item | Workorder item | | Work order Payer | a payer of the specific workorder | | Work order Priority | Priority of particular workorder | | Work order Reservation | Reservation for workorder | | Work order Status | Status of the workorder | | Work order Type | Type 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 |