/
MyForce Glossary: Data model

MyForce Glossary: Data model

How to read this article:

Use the tree to find the Object you are looking for and then review it to

 

Work Order

Field

Definition

Relates to

MS Review

Field

Definition

Relates to

MS Review

24-Hour Shift

If this box is checked, this indicates the Shift was over a 24-hour period

 

 

Actual Duration

Is the total duration between the Start and End Time

 

 

Actual End

The Actual End is set from 3 scenarios:

  1. Defaults to the Scheduled End time of related Service Appointments when a Work Order is Created.

  2. A single Resource Service Appointment: Set from the Service Appointment Actual End Time

  3. A multi-resource Service Appointment: Set from the latest Service Appointment Actual End Timeof all related Service Appointments.

 

 

Actual Start

The Actual Start is set from 3 scenarios:

  1. Defaults to the Scheduled End time of related Service Appointments when a Work Order is Created.

  2. A single Resource Service Appointment: Set from the Service Appointment Actual Start Time

  3. A multi-resource Service Appointment: Set from the Earliest Service Appointment Actual Start Timeof all related Service Appointments.

 

 

Address

The main Address at which the Work Order is Scheduled.

 

 

Approval Status

The Approval Status is set from 3 scenarios:

  1. Defaults to the Scheduled End time of related Service Appointments when a Work Order is Created.

  2. A single Resource Service Appointment: Set from the Service Appointment Actual Start Time

  3. A multi-resource Service Appointment: Set from the Earliest Service Appointment Actual Start Timeof all related Service Appointments.

 

 

Batch

The Batch lookup field on the WorkOrder connects to the Batch record of the Billing Period that the WorkOrder was completed or approved within.

 

 

Cancellation Reason

Legacy system field defining the reason for a cancellation.

 

 

Client Count

Represents the Number of Clients link to a Work Order through the COUNT of all related Child Work Orders. Child Work Orders are only Counted IF their Status is not equal to:
- Deleted
- Client Cancelled (48 hrs+)
- Client Cancelled (48hrs+ - short staff notice)
MySupports Cancelled

 

 

Client Record & Documents

This field is formula that creates a hyperlink to the Clients record i the MyForce Support Worker Portal.

 

 

Contact

The Client in which services are being delivered to. Contact will be blank if the Work Order is a group shift with many Clients.

 

 

Delivery Mode

The method of which services are being delivered. In example, Face-to-Face or Phone etc..

 

 

Duration

The total time elapsed with the Start Time and End Time as ‘Scheduled’.

 

 

End Date

Indicates the date in which the Work Order is expected to End. This also includes a time-based value.

 

 

External Id

Legacy system record Id.

 

 

Filled by NTL during paid hours

This indicated the WorkOrder was not delivered by a Casual Support Worker and a TimeSheetEntry is not required.

 

 

Fortnight

This represents the Billing and Pay period fortnight for which the Work Order was Completed or Apporoved.

 

 

Goal

A link to the Goal records that the Work Order and the delivery of services relate to.

 

 

Is From WOM

Indicated this Work Order was created from the Maica Work Order Management Wizard.

 

 

Is SIL

Indicated this Work Order is related to SIL Services.

 

 

Minor Pays

A Finance concept that indicates the

 

 

Parent Work Order

This will be blank for all Single-Participant Work Orders. In the case of Multi-participant Work Orders, each Child Work Order will reference their related Parent Work Order in this field.

 

 

Pay Period Ending

Indicated the pay and billing period of which this Work Order is scheduled to be completed in.

 

 

Remote/Work From Home

Indicated if this Work Order was completely remotely.

 

 

Required Service Resources

Similar to Client Count, this field is the COUNT of all related Service Appointments to the Work Order which indicates how many Support Workers as required to deliver the services.

Service Appointments are only Counted IF their Status is not equal to:

  • Deleted

  • Client Cancelled (48 hrs+)

  • Client Cancelled (48hrs+ - short staff notice)

MySupports Cancelled

 

 

Service Agreement

A lookup to the Service Agreement in which the Work Order is related to.

 

 

Service Type

A multi-select picklist field that indicated what type/s of Services are being delivered as part of this Work Order.

 

 

Start Date

Indicates the date in which the Work Order is expected to Start. This also includes a time-based value.

 

 

Status

Indicated the Status of the Work Order that stems from the Status of its related Service Appointments.

 

 

Supplier

 

 

 

Support Coordinator Group

This field is used for Sharing rules that enable access records to users in the related Public Group.

 

 

WOLI Actual Times Total

This is the SUM of the Duration of all Time-Based WorkOrderLineItems related to the WorkOrder Where the WorkOrderLineItem Status is not equal to:
- Not Billed
- Deleted

 

 

Work Type Name

 

 

 

Work Type Text

 

 

 

Related content

Time Sheet Entry & Invoice Line Item Data Flow
Time Sheet Entry & Invoice Line Item Data Flow
More like this
DCR - Time Sheet Entry & Invoice Line Item Data Flow
DCR - Time Sheet Entry & Invoice Line Item Data Flow
More like this
CCS - Time Sheet Entry & Invoice Line Item Data Flow
CCS - Time Sheet Entry & Invoice Line Item Data Flow
More like this
Work Order - Scheduling
Work Order - Scheduling
More like this
Work Orders - Clients
Work Orders - Clients
More like this
WOLI & TSE Updates
WOLI & TSE Updates
More like this