Versions Compared

Key

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

...

Column Name

Description

event

This is the event that identifies how the data in the row was generated. This will be TaskStatusChange_v2 for Business Status changes.

servicerequest_id

This is the hub’s unique identifier for the service request. This will be a GUID.

servicerequest_identifiers_intake_id

It can be passed with client's "Referral ID" to link up their Referral ID to the CIE Hub.  The advantage to this is that the client may want this on their reporting side to easily match up the referrals and person’s to resources that are generated in the CIE Hub.

patient_identifiers_clientid

This is the service request client id that was supplied in the identifiers field when the service request was submitted to the CIE Hub.

patient_id

The hub’s unique id of the patient/community member.

patient_identifiers_clientid

This is the patients client id that was supplied in the patient identifiers field when the service request was supplied.

audit_businessStatusOriginal

The business status of the service request that was previous value before the status change.

audit_businessStatusChangedTo

The business status of the service request that was changed to.

audit_recorded

The date time the status was changed.

task_reason

This will contain the reason for the status change. When the service request is closed this will be the close reason.

...

View file
nameServiceRequest_Status_Changes-Table 1_2.csv