Skip to main content

Task Dataset Specification

Updated over a month ago

Task Dataset Specification

Task Dataset Specification

Overview

The "Task Dataset Specification" contains the ACM Task information. Its unique key is Task_Key. It references Members by Member_ID. Optionally, it references related Appeals by both Appeal_Key and Appeal_ID. Optionally, it references related Requests by both Request_Key and Request_ID. Additionally, it optionally references related Programs by both Program_ID and Screening_Key.

Key Features

  • Task Creation:\ Stores details related to the initiation of tasks, including the task type, description, initiator, and intended deadlines, ensuring that all relevant information is captured from the start.

  • Task Tracking:\ Enables ongoing monitoring of task progress, status updates, and completion details, helping teams stay informed about current task statuses.

  • Task Logging:\ Maintains a log of all actions taken on tasks, providing a historical audit trail that is essential for review and compliance purposes.

  • Notes Management:\ Allows for the addition and management of notes related to specific tasks, which can include clarifications, updates, or supplementary information important for task execution.

  • Ownership History:\ Tracks changes in task ownership or responsibility, crucial for understanding task progression and personnel involvement over time.

  • Raw Data Storage:\ Contains detailed, unprocessed data related to tasks, facilitating advanced analysis and the potential refinement of task management processes.

This dataset is indispensable for healthcare organizations aiming to streamline task management processes within medical databases, thereby improving workflow efficiency and enhancing the overall quality of healthcare services.

Table Structure

Table Name: Task

Columns

Column Name

Is Nullable

Data Type

Description

Member_ID

YES

STRING

Identifier for the member or individual associated with the task.

Task_Key

YES

STRING

A unique internal identifier of the task.

Task_Type

YES

STRING

Type or category of the task. See Dictionary Task Type table in the Dictionary Dataset Specification.

Task_Type_Description

YES

STRING

Description providing further details about the type of the task. See Dictionary Task Type table in the Dictionary Dataset Specification.

Task_Reason

YES

STRING

Reason or purpose associated with the task. See Dictionary Task Reason table in the Dictionary Dataset Specification.

Task_Reason_Description

YES

STRING

Description providing further details about the reason or purpose of the task. See Dictionary Task Reason table in the Dictionary Dataset Specification.

Priority

YES

STRING

Priority level assigned to the task. See Dictionary Priority table in the Dictionary Dataset Specification.

Priority_Description

YES

STRING

Description providing further details about the priority level of the task. See Dictionary Priority table in the Dictionary Dataset Specification.

Priority_Rank

YES

INT64

Rank assigned to the priority of the task. See Dictionary Priority table in the Dictionary Dataset Specification.

Task_Class

YES

STRING

Class or category of the task. See Dictionary Task Class table in the Dictionary Dataset Specification.

Task_Class_Description

YES

STRING

Description providing further details about the class or category of the task. See Dictionary Task Class table in the Dictionary Dataset Specification.

Program_ID

YES

STRING

Identifier for the program or service associated with the task. Used only in case when the task is related to a Program - it is an external identifier of the Program. See the Program entity for additional information.

Request_ID

YES

STRING

Identifier for the specific request or action associated with the task. Used only in case when the task is related to a Request - it is an external identifier of the Request. See the Request entity for additional information.

Task_Outcome

YES

STRING

Outcome or result associated with the completion of the task. See Dictionary Task Outcome table in the Dictionary Dataset Specification.

Task_Outcome_Description

YES

STRING

Description providing further details about the outcome or result of the task. See Dictionary Task Outcome table in the Dictionary Dataset Specification.

Task_Void_Reason

YES

STRING

Reason for voiding or cancelling the task. See Dictionary Task Void Reason table in the Dictionary Dataset Specification.

Task_Void_Reason_Description

YES

STRING

Description providing further details about the reason for voiding or cancelling the task. See Dictionary Task Void Reason table in the Dictionary Dataset Specification.

Void_Indicator

YES

BOOL

Indicator showing whether the task has been voided or cancelled.

Start_Timestamp

YES

TIMESTAMP

Date and time when the task was started or initiated.

Due_Timestamp

YES

TIMESTAMP

Date and time by which the task is due to be completed.

End_Timestamp

YES

TIMESTAMP

Date and time when the task was completed.

Void_Timestamp

YES

TIMESTAMP

Date and time when the task was voided or cancelled.

Task_ID

YES

STRING

External identifier of the task which can be viewed in ACM UI.

Originator_User_ID

YES

STRING

Identifier for the user who originated the task.

Originator_User_Name

YES

STRING

Name of the user who originated or initiated the task. This value is derived from the Full_Name field in the User table, which contains the full name of the user responsible for creating the task. This field provides clear identification of the individual who initiated the task, allowing for easy tracking and accountability within the system.

Originated_by_Member

YES

BOOL

Member who originated the task.

Void_User_ID

YES

STRING

Identifier for the user who voided or cancelled the task.

Void_User_Name

YES

STRING

Name of the user who voided or cancelled the task. This value is derived from the Full_Name field in the User table, which contains the full name of the user responsible for voiding or cancelling the task.

Owner_ID

YES

STRING

Identifier representing the owner of the task.

Modules

Task

Task Completed User

Task Notes

Task Owner History

Task Due Timestamp History

Task Individual Department Owner History

Task Log

Task Raw

Task Dataset Specification

Task Ownership

Owner_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description:\ Type or role of the owner of the task.

  • If Owner_User_ID is not null, the type is set to 'INDV', indicating an individual owner.

  • If Owner_Department_ID is not null, the type is set to 'DEPT', indicating a departmental owner.

  • Otherwise, the type is set to null.

Owner_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description:\ Name of the owner of the task.

  • If Owner_User_ID is not null, the name is derived from the Full_Name field in the User table associated with the user ID.

  • If Owner_Department_ID is not null, the name is derived from the Department_Name field in the Department table associated with the department ID.

  • Otherwise, the value is set to null.

Owner_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description:\ The unique identifier for the user who owns the task.

Owner_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description:\ The username of the user who owns the task.

Owner_Department_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description:\ The unique identifier for the department to which the task owner belongs.

Owner_Department_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description:\ The name of the department to which the task owner belongs.

Source System

Source_System_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description:\ Identifier for the source system from which the task originated.\ See Dictionary Source System table in the Dictionary Dataset Specification.

Source_System_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description:\ Description providing further details about the source system of the task.\ See Dictionary Source System table in the Dictionary Dataset Specification.

Monitor Rules

Monitor_Rule_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description:\ Name of the monitor rule associated with the task.\ See Dictionary Monitor Rule table in the Dictionary Dataset Specification.

Monitor_Rule_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description:\ Unique key or identifier for any monitoring rule associated with the task.\ See Dictionary Monitor Rule table in the Dictionary Dataset Specification.

Timestamps

Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description:\ Date and time when the task was created.

Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description:\ Date and time when the task was last modified.

Task Completion

Close_Indicator

  • Is Nullable: YES

  • Data Type: BOOL

  • Description:\ Indicates whether the task is closed.

  • If End_Timestamp is null, indicating that the task has not yet been completed, the Close_Indicator is set to false.

  • If End_Timestamp is not null, indicating that the task has been completed and closed, the Close_Indicator is set to true.

Completion_State

  • Is Nullable: YES

  • Data Type: STRING

  • Description:\ State indicating the completion status of the task.

  • If End_Timestamp is null, indicating that the task has not yet been completed, the state is set to 'UNKNOWN'.

  • If End_Timestamp is not null and is less than or equal to Due_Timestamp, indicating timely completion, the state is set to 'TIMELY'.

  • Otherwise, the state is set to 'UNTIMELY'.

Completion_State_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description:\ Description providing further details about the completion status of the task.

  • If End_Timestamp is null, indicating that the task has not yet been completed, the description is set to 'Timeliness Unknown'.

  • If End_Timestamp is not null and is less than or equal to Due_Timestamp, indicating timely completion, the description is set to 'Closed On Or Before Target Date'.

  • Otherwise, the description is set to 'Closed After Target Date'.

Turnaround_Time_Minute

  • Is Nullable: YES

  • Data Type: INT64

  • Description:\ Time taken to complete the task, measured in minutes.

  • If End_Timestamp is null, indicating that the task has not yet been completed, the turnaround time is set to null.

  • Otherwise, the turnaround time is calculated as the difference between Start_Timestamp and End_Timestamp in minutes.

  • If this difference exceeds the maximum allowed value (9999999.99 minutes), the turnaround time is set to null.

Task_Completed_By_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description:\ Identifier for the user who completed the task.

Task_Completed_By_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description:\ Name of the user who completed the task.

Task Notes

Task_Note_Key

  • Is Nullable: YES

  • Data Type: STRING

  • Description:\ A unique identifier assigned to each task note entry in the dataset.

Task_Key

  • Is Nullable: YES

  • Data Type: STRING

  • Description:\ A key linking the task note to the corresponding task in the dataset.

Text

  • Is Nullable: YES

  • Data Type: STRING

  • Description:\ The content or text of the note.

Author_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description:\ Identifier for the user who authored the note.

Author_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description:\ Name of the user who authored the note.

  • This value is derived from the Full_Name field in the User table, which contains the full name of the user responsible for creating the note.

Void_Indicator

  • Is Nullable: YES

  • Data Type: BOOL

  • Description:\ Indicates whether the note has been voided.

Void_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description:\ The timestamp when the note was voided.

Void_Reason

  • Is Nullable: YES

  • Data Type: STRING

  • Description:\ The reason for voiding the note.

Void_Reason_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description:\ A detailed description of the reason for voiding the note.

Void_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description:\ The ID of the user who voided the note.

Void_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description:\ The name of the user who voided the note.

Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description:\ Date and time when the task note was created.

Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description:\ Date and time when the task note was last modified.

Task Owner History

Task_Key

  • Is Nullable: YES

  • Data Type: STRING

  • Description:\ A key linking the task owner history entry to the corresponding task in the dataset.

Task_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description:\ Identifier for the task associated with the owner history entry.

First_Owner_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description:\ Identifier for the first owner of the task based on historical records partitioned for each task in the Task_LOG table, sorted by Last_Modified_Timestamp ascending.

First_Owner_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description:\ Type or role of the first owner of the task based on historical records partitioned for each task in the Task_LOG table, sorted by Last_Modified_Timestamp ascending.

Task Dataset Specification

Owner History

Owner_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description:

  • Name of the first owner of the task.

  • If Owner_User_ID is not null (indicating an individual owner), the name is derived from the Full_Name field in the User table.

  • If Owner_Department_ID is not null (indicating a departmental owner), the name is derived from the Department_Name field in the Department table.

  • Otherwise, the value is set to null.

Owner_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the current owner of the task.

Owner_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type or role of the current owner of the task.

Owner_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description:

  • Name of the current owner of the task.

  • Derived from User.Full_Name or Department.Department_Name based on whether Owner_User_ID or Owner_Department_ID is not null, respectively, in the Task_LOG table.

Previous_Owner_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description:

  • Identifier for the previous owner of the task based on historical records partitioned for each task ID in the Task_LOG table, sorted by Last_Modified_Timestamp ascending.

Previous_Owner_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description:

  • Type or role of the previous owner of the task based on historical records partitioned for each task ID in the Task_LOG table, sorted by Last_Modified_Timestamp ascending.

Previous_Owner_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description:

  • Name of the previous owner of the task.

  • Derived from User.Full_Name or Department.Department_Name based on whether Owner_User_ID or Owner_Department_ID is not null, respectively, in the Task_LOG table.

First

  • Is Nullable: YES

  • Data Type: BOOL

  • Description:

  • Indicates whether the owner history entry is the first one for the task based on historical records partitioned for each task in the Task_LOG table, sorted by Last_Modified_Timestamp ascending.

Latest

  • Is Nullable: YES

  • Data Type: BOOL

  • Description:

  • Indicates whether the owner history entry is the latest one for the task based on historical records partitioned for each task in the Task_LOG table, sorted by Last_Modified_Timestamp ascending.

Effective_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description:

  • Date and time when the owner history entry became effective.

Transaction_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description:

  • Identifier for the user who performed the transaction related to the owner history entry.

Task Due Date History

Task_Key

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique identifier for the task.

First_Due_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The initial timestamp when the task was assigned a due date.

First_Due_Timestamp_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The ID of the user who initially assigned the due date to the task.

First_Due_Timestamp_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name of the user who initially assigned the due date to the task.

Previous_Due_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp of the due date before the current due date.

Due_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The current due date and time for the task.

First

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: An indicator specifying if this is the first ever due date assignment for the task.

Latest

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: An indicator specifying if this is the latest due date assignment for the task.

Effective_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when this record became effective in the history table.

Due_Timestamp_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The ID of the user who last modified the due date of the task.

Due_Timestamp_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name of the user who last modified the due date of the task.

Deleted_Indicator

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: An indicator specifying if this record has been marked as deleted.

Task Individual/Department Owner History

Task_Key

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Key for the task.

Task_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the task.

Original_Owner_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the original owner user.

Original_Owner_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the original owner user.

First_Owner_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the first owner user.

First_Owner_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the first owner user.

Owner_User_Set_Indicator

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicator if the owner user is set.

Owner_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the current owner user.

Owner_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the current owner user.

Previous_Owner_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the previous owner user.

Previous_Owner_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the previous owner user.

First_Owner_Department_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the first owner department.

First_Owner_Department_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the first owner department.

Owner_Department_Set_Indicator

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicator if the owner department is set.

Owner_Department_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the current owner department.

Owner_Department_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the current owner department.

Previous_Owner_Department_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the previous owner department.

Previous_Owner_Department_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the previous owner department.

First

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates if this is the first record.

Latest

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates if this is the latest record.

Effective_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the record became effective.

Transaction_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the user who performed the transaction.

Member Information

Member_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the member or individual associated with the task.

Task_Key

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique identifier assigned to each task in the dataset.

Originator_Member_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the member who originated the task.

Transaction_Actor_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of actor who performed the transaction.

Task Dataset Specification

Parameters

Actor Type (pe)

  • Type: STRING

  • Description: Type of the actor performing the transaction.

Task Type (Task_Type)

  • Type: STRING

  • Description: Type or category of the task.

  • Reference: See Dictionary Task Type table in the Dictionary Dataset Specification.

Task Type Description (Task_Type_Description)

  • Type: STRING

  • Description: Provides further details about the type of the task.

  • Reference: See Dictionary Task Type table in the Dictionary Dataset Specification.

Task Reason (Task_Reason)

  • Type: STRING

  • Description: Reason or purpose associated with the task.

  • Reference: See Dictionary Task Reason table in the Dictionary Dataset Specification.

Task Reason Description (Task_Reason_Description)

  • Type: STRING

  • Description: Provides further details about the reason or purpose of the task.

  • Reference: See Dictionary Task Reason table in the Dictionary Dataset Specification.

Priority (Priority)

  • Type: STRING

  • Description: Priority level assigned to the task.

  • Reference: See Dictionary Priority table in the Dictionary Dataset Specification.

Priority Description (Priority_Description)

  • Type: STRING

  • Description: Provides further details about the priority level of the task.

  • Reference: See Dictionary Priority table in the Dictionary Dataset Specification.

Priority Rank (Priority_Rank)

  • Type: INT64

  • Description: Rank assigned to the priority of the task.

  • Reference: See Dictionary Priority table in the Dictionary Dataset Specification.

Task Class (Task_Class)

  • Type: STRING

  • Description: Class or category of the task.

  • Reference: See Dictionary Task Class table in the Dictionary Dataset Specification.

Task Class Description (Task_Class_Description)

  • Type: STRING

  • Description: Provides further details about the class or category of the task.

  • Reference: See Dictionary Task Class table in the Dictionary Dataset Specification.

Request Key (Request_Key)

  • Type: INT64

  • Description: Key identifying the request associated with the task.

Screening Key (Screening_Key)

  • Type: INT64

  • Description: Key identifying the screening associated with the task.

Program ID (Program_ID)

  • Type: STRING

  • Description: Identifier for the program or service associated with the task.

Request ID (Request_ID)

  • Type: STRING

  • Description: Identifier for the specific request or action associated with the task.

Task Outcome (Task_Outcome)

  • Type: STRING

  • Description: Outcome or result associated with the completion of the task.

  • Reference: See Dictionary Task Outcome table in the Dictionary Dataset Specification.

Task Outcome Description (Task_Outcome_Description)

  • Type: STRING

  • Description: Provides further details about the outcome or result of the task.

  • Reference: See Dictionary Task Outcome table in the Dictionary Dataset Specification.

Task Void Reason (Task_Void_Reason)

  • Type: STRING

  • Description: Reason for voiding or canceling the task.

  • Reference: See Dictionary Task Void Reason table in the Dictionary Dataset Specification.

Task Void Reason Description (Task_Void_Reason_Description)

  • Type: STRING

  • Description: Provides further details about the reason for voiding or canceling the task.

  • Reference: See Dictionary Task Void Reason table in the Dictionary Dataset Specification.

Void Indicator (Void_Indicator)

  • Type: BOOL

  • Description: Indicator showing whether the task has been voided or canceled.

Start Timestamp (Start_Timestamp)

  • Type: TIMESTAMP

  • Description: Date and time when the task was started or initiated.

Due Timestamp (Due_Timestamp)

  • Type: TIMESTAMP

  • Description: Date and time by which the task is due to be completed.

End Timestamp (End_Timestamp)

  • Type: TIMESTAMP

  • Description: Date and time when the task was completed.

Void Timestamp (Void_Timestamp)

  • Type: TIMESTAMP

  • Description: Date and time when the task was voided or canceled.

Task ID (Task_ID)

  • Type: STRING

  • Description: Identifier for the task.

Originator User ID (Originator_User_ID)

  • Type: STRING

  • Description: Identifier for the user who originated the task.

Void User ID (Void_User_ID)

  • Type: STRING

  • Description: Identifier for the user who voided or canceled the task.

Owner User ID (Owner_User_ID)

  • Type: STRING

  • Description: Identifier for the user who owns the task.

Owner Department ID (Owner_Department_ID)

  • Type: STRING

  • Description: Identifier for the department associated with the owner of the task.

Source System ID (Source_System_ID)

  • Type: STRING

  • Description: Identifier for the source system from which the task originated.

  • Reference: See Dictionary Source System table in the Dictionary Dataset Specification.

Source System Description (Source_System_Description)

  • Type: STRING

  • Description: Provides further details about the source system of the task.

  • Reference: See Dictionary Source System table in the Dictionary Dataset Specification.

Monitor Rule Name (Monitor_Rule_Name)

  • Type: STRING

  • Description: Name of the monitor rule associated with the task.

Created Timestamp (Created_Timestamp)

  • Type: TIMESTAMP

  • Description: Date and time when the task log entry was created.

Last Modified Timestamp (Last_Modified_Timestamp)

  • Type: TIMESTAMP

  • Description: Date and time when the task log entry was last modified.

Notes (Notes)

  • Type: ARRAY

  • Description: Additional notes or comments related to the task.

  • Details:

  • Task Note Key (Notes.Task_Note_Key)

    • Type: INT64

    • Description: A unique identifier assigned to each task note entry in the dataset.

  • Text (Notes.Text)

    • Type: STRING

    • Description: The content or text of the note.

  • Author User ID (Notes.Author_User_ID)

    • Type: STRING

    • Description: Identifier for the user who authored the note.

  • Created Timestamp (Notes.Created_Timestamp)

    • Type: TIMESTAMP

    • Description: Date and time when the task note was created.

  • Last Modified Timestamp (Notes.Last_Modified_Timestamp)

    • Type: TIMESTAMP

    • Description: Date and time when the task note was last modified.

Record Last Modified Timestamp (Record_Last_Modified_Timestamp)

  • Type: TIMESTAMP

  • Description: Date and time when the record associated with the task log entry was last modified.

Transaction User ID (Transaction_User_ID)

  • Type: STRING

  • Description: Identifier for the user who performed the transaction related to the task.

Type (Type)

  • Type: STRING

  • Description: Type or category of the record associated with the task log entry.

Tenant (Tenant)

  • Type: STRING

  • Description: Identifier for the tenant or client organization associated with the task.

Active Version (Active_Version)

  • Type: BOOL

  • Description: Indicates the active version or status of the record associated with the task log entry.

Date (Date)

  • Type: DATE

  • Description: Date associated with the task.

Sequence (Sequence)

  • Type: INT64

  • Description: Sequence number or identifier associated with the task.

Source System Name (Source_System_Name)

  • Type: STRING

  • Description: Name of the source system from which the task originated.

Source Timestamp (Source_Timestamp)

  • Type: TIMESTAMP

  • Description: Date and time when the transaction or activity related to the task originated in the source system.

Source File Name (Source_File_Name)

  • Type: STRING

  • Description: Name of the source file from which the transaction or activity related to the task originated.

Deleted Indicator (Deleted_Indicator)

  • Type: BOOL

  • Description: Indicates whether the task record has been deleted.

  • Details: If Deleted_Indicator is set to false, it means the task record is not deleted and should be included in related views. Used as a filter to exclude deleted task records from all related views.

Schema Version (Schema_Version)

  • Type: FLOAT64

  • Description: Version of the schema or data model associated with the task log entry.

Member Partition (Member_Partition)

  • Type: INT64

  • Description: Partition or segment of the member associated with the task.

Action (Action)

  • Type: STRING

  • Description: Action or operation performed as part of the transaction or activity related to the task.

Monitor Rule Key (Monitor_Rule_Key)

  • Type: STRING

  • Description: Key associated with the monitor rule related to the task.

Task Dataset Specification

ES INT64

  • Description: A unique identifier for the monitoring rule, stored as a 64-bit integer.

Table Structure

Member_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the member or individual associated with the task.

Task_Key

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique identifier assigned to each task in the dataset.

Originator_Member_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the member who originated the task.

Transaction_Actor_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of the actor performing the transaction.

Task_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type or category of the task. See Dictionary Task Type table in the Dictionary Dataset Specification.

Task_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description providing further details about the type of the task. See Dictionary Task Type table in the Dictionary Dataset Specification.

Task_Reason

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Reason or purpose associated with the task. See Dictionary Task Reason table in the Dictionary Dataset Specification.

Task_Reason_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description providing further details about the reason or purpose of the task. See Dictionary Task Reason table in the Dictionary Dataset Specification.

Priority

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Priority level assigned to the task. See Dictionary Priority table in the Dictionary Dataset Specification.

Priority_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description providing further details about the priority level of the task. See Dictionary Priority table in the Dictionary Dataset Specification.

Priority_Rank

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Rank assigned to the priority of the task. See Dictionary Priority table in the Dictionary Dataset Specification.

Task_Class

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Class or category of the task. See Dictionary Task Class table in the Dictionary Dataset Specification.

Task_Class_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description providing further details about the class or category of the task. See Dictionary Task Class table in the Dictionary Dataset Specification.

Request_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: An internal identifier of the request associated with the task.

Screening_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Reference to the program screening (see the Program entity) - one of the internal identifiers of the program.

Program_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the program or service associated with the task.

Request_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the specific request or action associated with the task.

Task_Outcome

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Outcome or result associated with the completion of the task. See Dictionary Task Outcome table in the Dictionary Dataset Specification.

Task_Outcome_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description providing further details about the outcome or result of the task. See Dictionary Task Outcome table in the Dictionary Dataset Specification.

Task_Void_Reason

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Reason for voiding or cancelling the task. See Dictionary Task Void Reason table in the Dictionary Dataset Specification.

Task_Void_Reason_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description providing further details about the reason for voiding or cancelling the task. See Dictionary Task Void Reason table in the Dictionary Dataset Specification.

Void_Indicator

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicator showing whether the task has been voided or cancelled.

Start_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Date and time when the task was started or initiated.

Due_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Date and time by which the task is due to be completed.

End_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Date and time when the task was completed.

Void_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Date and time when the task was voided or cancelled.

Task_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the task.

Originator_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the user who originated the task.

Void_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the user who voided or cancelled the task.

Owner_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the user who owns the task.

Owner_Department_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the department associated with the owner of the task.

Source_System_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the source system from which the task originated. See Dictionary Source System table in the Dictionary Dataset Specification.

Source_System_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description providing further details about the source system of the task. See Dictionary Source System table in the Dictionary Dataset Specification.

Monitor_Rule_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the monitor rule associated with the task.

Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Date and time when the task was created.

Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Date and time when the task was last modified.

Notes

  • Is Nullable: NO

  • Data Type: ARRAY

  • Description: Additional notes or comments related to the task. See below for detailed information on each parameter in the Array.

Notes.Task_Note_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: A unique identifier assigned to each task note entry in the dataset.

Notes.Text

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The content or text of the note.

Notes.Author_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the user who authored the note.

Notes.Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Date and time when the task note was created.

Notes.Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Date and time when the task note was last modified.

Record_Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Date and time when the record associated with the task was last modified.

Transaction_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the user who performed the transaction related to the task.

Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type or category of the record associated with the task.

Tenant

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the tenant or client organization associated with the task.

Active_Version

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates the active version or status of the record associated with the task.

Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: Date associated with the task.

Sequence

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Sequence number or identifier associated with the task.

Source_System_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the source system from which the task originated.

Source_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Date and time when the transaction or activity related to the task originated in the source system.

Source_File_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the source file from which the transaction or activity related to the task originated.

Deleted_Indicator

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates whether the task record has been deleted. If Deleted_Indicator is set to false, it means the task record is not deleted.

Task Dataset Specification

Overview

The Task Dataset Specification outlines the structure, fields, and functionalities associated with task management within the Care Intelligence system. This specification ensures that all relevant information is captured, tracked, and maintained for effective task management.

Features

Task Creation

  • Stores details related to the initiation of tasks, including:

  • Task type

  • Description

  • Initiator

  • Intended deadlines

  • Ensures all relevant information is captured from the start.

Task Tracking

  • Enables ongoing monitoring of task progress, including:

  • Status updates

  • Completion details

  • Helps teams stay informed about current task statuses.

Task Logging

  • Maintains a log of all actions taken on tasks.

  • Provides a historical audit trail essential for review and compliance purposes.

Notes Management

  • Allows for the addition and management of notes related to specific tasks.

  • Notes can include:

  • Clarifications

  • Updates

  • Supplementary information important for task execution.

Ownership History

  • Tracks changes in task ownership or responsibility.

  • Crucial for understanding task progression and personnel involvement over time.

Raw Data Storage

  • Contains detailed, unprocessed data related to tasks.

  • Facilitates advanced analysis and potential refinement of task management processes.

Table Content

Task Table

Column Name

Is Nullable

Data Type

Description

Member_ID

YES

STRING

Identifier for the member or individual associated with the task.

Task_Key

YES

STRING

A unique internal identifier of the task.

Task_Type

YES

STRING

Type or category of the task. See Dictionary Task Type table in the Dictionary Dataset Specification.

Task_Type_Description

YES

STRING

Description providing further details about the type of the task. See Dictionary Task Type table in the Dictionary Dataset Specification.

Task_Reason

YES

STRING

Reason or purpose associated with the task. See Dictionary Task Reason table in the Dictionary Dataset Specification.

Task_Reason_Description

YES

STRING

Description providing further details about the reason or purpose of the task. See Dictionary Task Reason table in the Dictionary Dataset Specification.

Priority

YES

STRING

Priority level assigned to the task. See Dictionary Priority table in the Dictionary Dataset Specification.

Priority_Description

YES

STRING

Description providing further details about the priority level of the task. See Dictionary Priority table in the Dictionary Dataset Specification.

Priority_Rank

YES

INT64

Rank assigned to the priority of the task. See Dictionary Priority table in the Dictionary Dataset Specification.

Task_Class

YES

STRING

Class or category of the task. See Dictionary Task Class table in the Dictionary Dataset Specification.

Task_Class_Description

YES

STRING

Description providing further details about the class or category of the task. See Dictionary Task Class table in the Dictionary Dataset Specification.

Program_ID

YES

STRING

Identifier for the program or service associated with the task. Used only in case when the task is related to a Program - it is an external identifier of the Program. See the Program entity for additional information.

Request_ID

YES

STRING

Identifier for the specific request or action associated with the task. Used only in case when the task is related to a Request - it is an external identifier of the Request. See the Request entity for additional information.

Task_Outcome

YES

STRING

Outcome or result associated with the completion of the task. See Dictionary Task Outcome table in the Dictionary Dataset Specification.

Task_Outcome_Description

YES

STRING

Description providing further details about the outcome or result of the task. See Dictionary Task Outcome table in the Dictionary Dataset Specification.

Task_Void_Reason

YES

STRING

Reason for voiding or cancelling the task. See Dictionary Task Void Reason table in the Dictionary Dataset Specification.

Task_Void_Reason_Description

YES

STRING

Description providing further details about the reason for voiding or cancelling the task. See Dictionary Task Void Reason table in the Dictionary Dataset Specification.

Void_Indicator

YES

BOOL

Indicator showing whether the task has been voided or cancelled.

Start_Timestamp

YES

TIMESTAMP

Date and time when the task was started or initiated.

Due_Timestamp

YES

TIMESTAMP

Date and time by which the task is due to be completed.

End_Timestamp

YES

TIMESTAMP

Date and time when the task was completed.

Void_Timestamp

YES

TIMESTAMP

Date and time when the task was voided or cancelled.

Task_ID

YES

STRING

External identifier of the task which can be viewed in ACM UI.

Originator_User_ID

YES

STRING

Identifier for the user who originated the task.

Originator_User_Name

YES

STRING

Name of the user who originated or initiated the task. This value is derived from the Full_Name field in the User table, which contains the full name of the user responsible for creating the task. This field provides clear identification of the individual who initiated the task, allowing for easy tracking and accountability within the system.

Originated_by_Member

YES

BOOL

Member who originated the task.

Void_User_ID

YES

STRING

Identifier for the user who voided or cancelled the task.

Void_User_Name

YES

STRING

Name of the user who voided or cancelled the task. This value is derived from the Full_Name field in the User table, which contains the full name of the user responsible for voiding or cancelling the task.

Owner_ID

YES

STRING

Identifier representing the owner of the task. This value is derived from the Owner_User_ID field.

Task Dataset Specification

Task Table

Columns

  • Owner_User_ID

  • Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier for the user who owns the task. If this field is not null, the value is derived from the Owner_User_ID field. If Owner_User_ID is null, then the value is derived from the Owner_Department_ID field. This allows for identification of both individual users and departments that own tasks.

  • Owner_Type

  • Nullable: YES

  • Data Type: STRING

  • Description: Type or role of the owner of the task.

    • If Owner_User_ID is not null, the type is set to 'INDV', indicating an individual owner.

    • If Owner_Department_ID is not null, the type is set to 'DEPT', indicating a departmental owner.

    • Otherwise, the type is set to null.

  • Owner_Name

  • Nullable: YES

  • Data Type: STRING

  • Description: Name of the owner of the task.

    • If Owner_User_ID is not null, the name is derived from the Full_Name field in the User table associated with the user ID.

    • If Owner_Department_ID is not null, the name is derived from the Department_Name field in the Department table associated with the department ID.

    • Otherwise, the value is set to null.

  • Owner_User_Name

  • Nullable: YES

  • Data Type: STRING

  • Description: The username of the user who owns the task.

  • Owner_Department_ID

  • Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier for the department to which the task owner belongs.

  • Owner_Department_Name

  • Nullable: YES

  • Data Type: STRING

  • Description: The name of the department to which the task owner belongs.

  • Source_System_ID

  • Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the source system from which the task originated. See Dictionary Source System table in the Dictionary Dataset Specification.

  • Source_System_Description

  • Nullable: YES

  • Data Type: STRING

  • Description: Description providing further details about the source system of the task. See Dictionary Source System table in the Dictionary Dataset Specification.

  • Monitor_Rule_Name

  • Nullable: YES

  • Data Type: STRING

  • Description: Name of the monitor rule associated with the task. See Dictionary Monitor Rule table in the Dictionary Dataset Specification.

  • Created_Timestamp

  • Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Date and time when the task was created.

  • Last_Modified_Timestamp

  • Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Date and time when the task was last modified.

  • Close_Indicator

  • Nullable: YES

  • Data Type: BOOL

  • Description: Indicates whether the task is closed.

    • If End_Timestamp is null, indicating that the task has not yet been completed, the Close_Indicator is set to false.

    • If End_Timestamp is not null, indicating that the task has been completed and closed, the Close_Indicator is set to true.

  • Completion_State

  • Nullable: YES

  • Data Type: STRING

  • Description: State indicating the completion status of the task.

    • If End_Timestamp is null, indicating that the task has not yet been completed, the state is set to 'UNKNOWN'.

    • If End_Timestamp is not null and is less than or equal to Due_Timestamp, indicating timely completion, the state is set to 'TIMELY'.

    • Otherwise, the state is set to 'UNTIMELY'.

  • Completion_State_Description

  • Nullable: YES

  • Data Type: STRING

  • Description: Description providing further details about the completion status of the task.

    • If End_Timestamp is null, indicating that the task has not yet been completed, the description is set to 'Timeliness Unknown'.

    • If End_Timestamp is not null and is less than or equal to Due_Timestamp, indicating timely completion, the description is set to 'Closed On Or Before Target Date'.

    • Otherwise, the description is set to 'Closed After Target Date'.

  • Turnaround_Time_Minute

  • Nullable: YES

  • Data Type: INT64

  • Description: Time taken to complete the task, measured in minutes.

    • If End_Timestamp is null, indicating that the task has not yet been completed, the turnaround time is set to null.

    • Otherwise, the turnaround time is calculated as the difference between the Start_Timestamp and End_Timestamp in minutes.

    • If this difference exceeds the maximum allowed value (9999999.99 minutes), the turnaround time is set to null.

  • Task_Completed_By_User_ID

  • Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the user who completed the task.

  • Task_Completed_By_User_Name

  • Nullable: YES

  • Data Type: STRING

  • Description: Name of the user who completed the task.

  • Monitor_Rule_Key

  • Nullable: YES

  • Data Type: INT64

  • Description: Unique key or identifier for any monitoring rule associated with the task. See Dictionary Monitor Rule table in the Dictionary Dataset Specification.

Task Note Table

Columns

  • Task_Note_Key

  • Nullable: YES

  • Data Type: STRING

  • Description: A unique identifier assigned to each task note entry in the dataset.

  • Task_Key

  • Nullable: YES

  • Data Type: STRING

  • Description: A key linking the task note to the corresponding task in the dataset.

  • Text

  • Nullable: YES

  • Data Type: STRING

  • Description: The content or text of the note.

  • Author_User_ID

  • Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the user who authored the note.

  • Author_User_Name

  • Nullable: YES

  • Data Type: STRING

  • Description: Name of the user who authored the note. This value is derived from the Full_Name field in the User table, which contains the full name of the user responsible for creating the note.

  • Void_Indicator

  • Nullable: YES

  • Data Type: BOOL

  • Description: Indicates whether the note has been voided.

  • Void_Timestamp

  • Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when the note was voided.

  • Void_Reason

  • Nullable: YES

  • Data Type: STRING

  • Description: The reason for voiding the note.

  • Void_Reason_Description

  • Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of the reason for voiding the note.

  • Void_User_ID

  • Nullable: YES

  • Data Type: STRING

  • Description: The ID of the user who voided the note.

  • Void_User_Name

  • Nullable: YES

  • Data Type: STRING

  • Description: The name of the user who voided the note.

  • Created_Timestamp

  • Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Date and time when the task note was created.

  • Last_Modified_Timestamp

  • Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Date and time when the task note was last modified.

Task Owner History Table

Columns

  • Task_Key

  • Nullable: YES

  • Data Type: STRING

  • Description: A key linking the task owner history entry to the corresponding task in the dataset.

Task Dataset Specification

Owner History Fields

ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the task associated with the owner history entry.

First_Owner_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the first owner of the task based on historical records partitioned for each task in the Task_LOG table, sorted by Last_Modified_Timestamp ascending.

First_Owner_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type or role of the first owner of the task based on historical records partitioned for each task in the Task_LOG table, sorted by Last_Modified_Timestamp ascending.

First_Owner_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description:

  • Name of the first owner of the task.

  • If Owner_User_ID is not null, indicating an individual owner, the name is derived from the Full_Name field in the User table.

  • If Owner_Department_ID is not null, indicating a departmental owner, the name is derived from the Department_Name field in the Department table.

  • Otherwise, the value is set to null.

Owner_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the current owner of the task.

Owner_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type or role of the current owner of the task.

Owner_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description:

  • Name of the current owner of the task.

  • Derived from User.Full_Name or Department.Department_Name based on whether Owner_User_ID or Owner_Department_ID is not null, respectively, in the Task_LOG table.

Previous_Owner_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the previous owner of the task based on historical records partitioned for each task ID in the Task_LOG table, sorted by Last_Modified_Timestamp ascending.

Previous_Owner_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type or role of the previous owner of the task based on historical records partitioned for each task ID in the Task_LOG table, sorted by Last_Modified_Timestamp ascending.

Previous_Owner_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description:

  • Name of the previous owner of the task.

  • Derived from User.Full_Name or Department.Department_Name based on whether Owner_User_ID or Owner_Department_ID is not null, respectively, in the Task_LOG table.

First

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates whether the owner history entry is the first one for the task based on historical records partitioned for each task in the Task_LOG table, sorted by Last_Modified_Timestamp ascending.

Latest

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates whether the owner history entry is the latest one for the task based on historical records partitioned for each task in the Task_LOG table, sorted by Last_Modified_Timestamp ascending.

Effective_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Date and time when the owner history entry became effective.

Transaction_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the user who performed the transaction related to the owner history entry.

Task Fields

Task_Key

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique identifier for the task.

First_Due_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The initial timestamp when the task was assigned a due date.

First_Due_Timestamp_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The ID of the user who initially assigned the due date to the task.

First_Due_Timestamp_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name of the user who initially assigned the due date to the task.

Previous_Due_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp of the due date before the current due date.

Due_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The current due date and time for the task.

First

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: An indicator specifying if this is the first ever due date assignment for the task.

Latest

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: An indicator specifying if this is the latest due date assignment for the task.

Effective_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when this record became effective in the history table.

Due_Timestamp_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The ID of the user who last modified the due date of the task.

Due_Timestamp_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name of the user who last modified the due date of the task.

Deleted_Indicator

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: An indicator specifying if this record has been marked as deleted.

Task Individual Department Owner History Fields

Task_Key

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Key for the task.

Task_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the task.

Original_Owner_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the original owner user.

Original_Owner_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the original owner user.

First_Owner_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the first owner user.

First_Owner_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the first owner user.

Owner_User_Set_Indicator

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicator if the owner user is set.

Owner_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the current owner user.

Owner_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the current owner user.

Previous_Owner_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the previous owner user.

Previous_Owner_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the previous owner user.

First_Owner_Department_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the first owner department.

First_Owner_Department_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the first owner department.

Owner_Department_Set_Indicator

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicator if the owner department is set.

Owner_Department_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the current owner department.

Owner_Department_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the current owner department.

Task Dataset Specification

Task Individual Department Owner History

Previous Owner Department ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the previous owner department.

Previous Owner Department Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the previous owner department.

First

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates if this is the first record.

Latest

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates if this is the latest record.

Effective Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the record became effective.

Transaction User ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the user who performed the transaction.

Table Content

Member ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the member or individual associated with the task.

Task Key

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique identifier assigned to each task in the dataset.

Originator Member ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the member who originated the task.

Transaction Actor Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of the actor performing the transaction.

Task Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type or category of the task. See Dictionary Task Type table in the Dictionary Dataset Specification.

Task Type Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description providing further details about the type of the task. See Dictionary Task Type table in the Dictionary Dataset Specification.

Task Reason

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Reason or purpose associated with the task. See Dictionary Task Reason table in the Dictionary Dataset Specification.

Task Reason Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description providing further details about the reason or purpose of the task. See Dictionary Task Reason table in the Dictionary Dataset Specification.

Priority

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Priority level assigned to the task. See Dictionary Priority table in the Dictionary Dataset Specification.

Priority Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description providing further details about the priority level of the task. See Dictionary Priority table in the Dictionary Dataset Specification.

Priority Rank

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Rank assigned to the priority of the task. See Dictionary Priority table in the Dictionary Dataset Specification.

Task Class

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Class or category of the task. See Dictionary Task Class table in the Dictionary Dataset Specification.

Task Class Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description providing further details about the class or category of the task. See Dictionary Task Class table in the Dictionary Dataset Specification.

Request Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Key identifying the request associated with the task.

Screening Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Key identifying the screening associated with the task.

Program ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the program or service associated with the task.

Request ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the specific request or action associated with the task.

Task Outcome

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Outcome or result associated with the completion of the task. See Dictionary Task Outcome table in the Dictionary Dataset Specification.

Task Outcome Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description providing further details about the outcome or result of the task. See Dictionary Task Outcome table in the Dictionary Dataset Specification.

Task Void Reason

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Reason for voiding or cancelling the task. See Dictionary Task Void Reason table in the Dictionary Dataset Specification.

Task Void Reason Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description providing further details about the reason for voiding or cancelling the task. See Dictionary Task Void Reason table in the Dictionary Dataset Specification.

Void Indicator

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicator showing whether the task has been voided or cancelled.

Start Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Date and time when the task was started or initiated.

Due Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Date and time by which the task is due to be completed.

End Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Date and time when the task was completed.

Void Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Date and time when the task was voided or cancelled.

Task ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the task.

Originator User ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the user who originated the task.

Void User ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the user who voided or cancelled the task.

Owner User ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the user who owns the task.

Owner Department ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the department associated with the owner of the task.

Source System ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the source system from which the task originated. See Dictionary Source System table in the Dictionary Dataset Specification.

Source System Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description providing further details about the source system of the task. See Dictionary Source System table in the Dictionary Dataset Specification.

Monitor Rule Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the monitor rule associated with the task.

Created Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Date and time when the task log entry was created.

Last Modified Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Date and time when the task log entry was last modified.

Notes

  • Is Nullable: NO

  • Data Type: ARRAY

  • Description: Additional notes or comments related to the task.

Notes Parameters

  • Notes.Task_Note_Key:

  • Is Nullable: YES

  • Data Type: INT64

  • Description: A unique identifier assigned to each task note entry in the dataset.

  • Notes.Text:

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The content or text of the note.

  • Notes.Author_User_ID:

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the user who authored the note.

  • Notes.Created_Timestamp:

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Date and time when the task note was created.

  • Notes.Last_Modified_Timestamp:

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Date and time when the task note was last modified.

Task Dataset Specification

Table Content

Record_Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Date and time when the record associated with the task log entry was last modified.

Transaction_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the user who performed the transaction related to the task.

Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type or category of the record associated with the task log entry.

Tenant

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the tenant or client organization associated with the task.

Active_Version

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates the active version or status of the record associated with the task log entry.

Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: Date associated with the task.

Sequence

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Sequence number or identifier associated with the task.

Source_System_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the source system from which the task originated.

Source_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Date and time when the transaction or activity related to the task originated in the source system.

Source_File_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the source file from which the transaction or activity related to the task originated.

Deleted_Indicator

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates whether the task record has been deleted. If Deleted_Indicator is set to false, it means the task record is not deleted and should be included in related views. Used as a filter to exclude deleted task records from all related views.

Schema_Version

  • Is Nullable: YES

  • Data Type: FLOAT64

  • Description: Version of the schema or data model associated with the task log entry.

Member_Partition

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Partition or segment of the member associated with the task.

Action

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Action or operation performed as part of the transaction or activity related to the task.

Monitor_Rule_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: A unique identifier for the monitoring rule, stored as a 64-bit integer.

Member_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the member or individual associated with the task.

Task_Key

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique identifier assigned to each task in the dataset.

Originator_Member_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the member who originated the task.

Transaction_Actor_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of the actor performing the transaction.

Task_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type or category of the task. See Dictionary Task Type table in the Dictionary Dataset Specification.

Task_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description providing further details about the type of the task. See Dictionary Task Type table in the Dictionary Dataset Specification.

Task_Reason

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Reason or purpose associated with the task. See Dictionary Task Reason table in the Dictionary Dataset Specification.

Task_Reason_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description providing further details about the reason or purpose of the task. See Dictionary Task Reason table in the Dictionary Dataset Specification.

Priority

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Priority level assigned to the task. See Dictionary Priority table in the Dictionary Dataset Specification.

Priority_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description providing further details about the priority level of the task. See Dictionary Priority table in the Dictionary Dataset Specification.

Priority_Rank

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Rank assigned to the priority of the task. See Dictionary Priority table in the Dictionary Dataset Specification.

Task_Class

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Class or category of the task. See Dictionary Task Class table in the Dictionary Dataset Specification.

Task_Class_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description providing further details about the class or category of the task. See Dictionary Task Class table in the Dictionary Dataset Specification.

Request_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: An internal identifier of the request associated with the task.

Screening_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Reference to the program screening (see the Program entity) - one of the internal identifiers of the program.

Program_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the program or service associated with the task.

Request_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the specific request or action associated with the task.

Task_Outcome

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Outcome or result associated with the completion of the task. See Dictionary Task Outcome table in the Dictionary Dataset Specification.

Task_Outcome_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description providing further details about the outcome or result of the task. See Dictionary Task Outcome table in the Dictionary Dataset Specification.

Task_Void_Reason

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Reason for voiding or cancelling the task. See Dictionary Task Void Reason table in the Dictionary Dataset Specification.

Task_Void_Reason_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description providing further details about the reason for voiding or cancelling the task. See Dictionary Task Void Reason table in the Dictionary Dataset Specification.

Void_Indicator

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicator showing whether the task has been voided or cancelled.

Start_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Date and time when the task was started or initiated.

Due_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Date and time by which the task is due to be completed.

End_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Date and time when the task was completed.

Void_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Date and time when the task was voided or cancelled.

Task_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the task.

Originator_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the user who originated the task.

Void_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the user who voided or cancelled the task.

Owner_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the user who owns the task.

Owner_Department_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the department associated with the owner of the task.

Source_System_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the source system from which the task originated.

Task Dataset Specification

Overview

This document specifies the structure and details of the task dataset used in Care Intelligence systems. Each field is described with its name, data type, and whether it is required, along with detailed explanations where applicable.

Fields

Source_System_Name

  • Required: YES

  • Type: STRING

  • Description: Name of the source system from which the task originated.

  • Reference: See Dictionary Source System table in the Dictionary Dataset Specification.

Source_System_Description

  • Required: YES

  • Type: STRING

  • Description: Description providing further details about the source system of the task.

  • Reference: See Dictionary Source System table in the Dictionary Dataset Specification.

Monitor_Rule_Name

  • Required: YES

  • Type: STRING

  • Description: Name of the monitor rule associated with the task.

Created_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Date and time when the task was created.

Last_Modified_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Date and time when the task was last modified.

Notes

  • Required: NO

  • Type: ARRAY

  • Description: Additional notes or comments related to the task.

  • Details:

  • Notes.Task_Note_Key

    • Required: YES

    • Type: INT64

    • Description: A unique identifier assigned to each task note entry in the dataset.

  • Notes.Text

    • Required: YES

    • Type: STRING

    • Description: The content or text of the note.

  • Notes.Author_User_ID

    • Required: YES

    • Type: STRING

    • Description: Identifier for the user who authored the note.

  • Notes.Created_Timestamp

    • Required: YES

    • Type: TIMESTAMP

    • Description: Date and time when the task note was created.

  • Notes.Last_Modified_Timestamp

    • Required: YES

    • Type: TIMESTAMP

    • Description: Date and time when the task note was last modified.

Record_Last_Modified_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Date and time when the record associated with the task was last modified.

Transaction_User_ID

  • Required: YES

  • Type: STRING

  • Description: Identifier for the user who performed the transaction related to the task.

Type

  • Required: YES

  • Type: STRING

  • Description: Type or category of the record associated with the task.

Tenant

  • Required: YES

  • Type: STRING

  • Description: Identifier for the tenant or client organization associated with the task.

Active_Version

  • Required: YES

  • Type: BOOL

  • Description: Indicates the active version or status of the record associated with the task.

Date

  • Required: YES

  • Type: DATE

  • Description: Date associated with the task.

Sequence

  • Required: YES

  • Type: INT64

  • Description: Sequence number or identifier associated with the task.

Source_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Date and time when the transaction or activity related to the task originated in the source system.

Source_File_Name

  • Required: YES

  • Type: STRING

  • Description: Name of the source file from which the transaction or activity related to the task originated.

Deleted_Indicator

  • Required: YES

  • Type: BOOL

  • Description: Indicates whether the task record has been deleted.

  • Details:

  • If Deleted_Indicator is set to false, it means the task record is not deleted and should be included in related views.

  • Used as a filter to exclude deleted task records from all related views.

Schema_Version

  • Required: YES

  • Type: FLOAT64

  • Description: Version of the schema or data model associated with the task.

Member_Partition

  • Required: YES

  • Type: INT64

  • Description: Partition or segment of the member associated with the task.

Monitor_Rule_Key

  • Required: YES

  • Type: INT64

  • Description: A unique identifier for the monitoring rule, stored as a 64-bit integer.

Related Articles
Provider Dataset Specification
Letter Dataset Specification
Interaction Topic Dataset Specification
Program Dataset Specification
Members Dataset Specification
Did this answer your question?