Skip to main content

Assessment Dataset Specification

Assessment Dataset Specification

Assessment Dataset Specification

The "Assessment Dataset Specification" is meticulously designed to manage and track patient assessments within healthcare systems, adhering to industry standards for accuracy, privacy, and clinical compliance. This dataset supports the documentation and analysis of clinical evaluations, patient responses, and scoring mechanisms that aid in care planning, diagnosis, and treatment tracking. The tables ensure that assessments are structured, responses are documented consistently, and related actions are triggered based on predefined workflows and clinical requirements.

Key Tables

Assessment Response

Stores detailed records of patient responses to specific assessment questions, capturing critical data points used for clinical evaluation and treatment decisions.

Assessment Response Additional Actions

Contains information on additional actions triggered based on the responses, such as follow-up assessments, referrals, or interventions, ensuring that care is delivered promptly.

Assessment Response Auto Workflows

Tracks automated workflows that are triggered by specific assessment responses, streamlining follow-up actions and care pathways based on predefined criteria.

Assessment Response Notes

Captures notes related to assessment responses, providing additional context or observations that aid in clinical decision-making.

Links responses to their respective scores, helping healthcare providers quickly assess and quantify patient conditions or progress.

Assessment Response Question Selected Response Child Assessment Response Question Keys

Tracks child questions triggered based on selected responses, allowing for dynamic assessments that adapt to patient needs.

Assessment Response Score Matched Evaluation Child Assessment Response Questions

Documents the relationship between child assessment questions and corresponding scores, ensuring comprehensive evaluation.

Assessment Response Score Parent Assessment Response Questions

Links parent assessment questions to related scores, helping to contextualize the scoring process and improve the accuracy of patient assessments.

Assessment Response Question

Captures detailed information about each question in an assessment, ensuring consistency and standardization across patient evaluations.

Assessment Template

Assessment Template

Houses predefined templates for assessments, standardizing the structure, format, and content of various assessments used within the healthcare organization.

Assessment Template Block Question Response Auto Workflows

Tracks automatic workflows initiated based on specific responses within template blocks, enabling efficient care management and follow-up actions.

Assessment Template Block Question Response Child Template Question Keys

Links template block questions to corresponding child questions, supporting dynamic and adaptable assessments.

Assessment Template Block Question Response Notifications

Manages notifications triggered by responses to template block questions, ensuring that relevant stakeholders are alerted to critical patient data or actions required.

Assessment Template Block Question Response Problems

Tracks clinical problems or issues identified based on responses to template block questions, facilitating timely intervention.

Assessment Template Block Question Response Tasks

Stores tasks that are generated from responses, ensuring that care teams are assigned necessary follow-up actions.

Assessment Template Block Question Responses

Stores responses specifically related to questions within assessment template blocks, ensuring comprehensive data capture.

Assessment Template Block Details

Contains metadata and structural details for each assessment template block, supporting the organization and segmentation of assessments.

Assessment Template Block Questions

Documents the questions within specific blocks of the assessment templates, providing logical groupings for related queries.

Assessment Template Block Scores

Tracks scoring information related to specific assessment template blocks, helping to evaluate patient conditions in a structured manner.

Assessment Template Blocks

Represents different sections of the assessment templates, allowing for modular and organized assessments.

Assessment Template Display Hierarchy

Defines the hierarchical structure for displaying assessment templates, ensuring clarity and usability.

Assessment Template Block Score Evaluation Auto Workflows

Tracks automated workflows triggered by score evaluations within template blocks, ensuring timely follow-up actions.

Assessment Template Block Score Evaluation Notifications

Manages notifications triggered by score evaluations within template blocks, alerting relevant stakeholders to critical patient data.

Assessment Template Block Score Evaluation Problems

Tracks clinical problems identified during score evaluations within template blocks, supporting timely intervention.

Assessment Template Block Score Evaluation Tasks

Stores tasks generated from score evaluations, ensuring that care teams are assigned necessary follow-up actions.

Assessment Template Block Score Evaluations

Documents the evaluations of scores within template blocks, providing structured data for clinical analysis.

Assessment Template Block Score Parent Questions

Links parent questions to score evaluations within template blocks, helping to contextualize scoring processes.

Assessment Template Tags

Stores tags associated with assessment templates, supporting categorization and retrieval of templates.

Assessment Template Type Programs

Defines programs associated with specific assessment template types, ensuring alignment with organizational goals.

Assessment Template Types

Categorizes different types of assessment templates, supporting diverse clinical and operational needs.

Assessment Response Score

Assessment Response Score

Tracks scores associated with assessment responses, providing a quantitative measure of patient conditions or progress.

Logs

Assessment Response Log

Captures logs related to assessment responses, providing a historical record for auditing and analysis.

Assessment Response Question Log

Documents logs related to assessment response questions, ensuring traceability and consistency.

Assessment Response Score Log

Tracks logs related to assessment response scores, supporting historical analysis and compliance.

Assessment Template Block Log

Stores logs related to assessment template blocks, providing a record of changes and updates.

Assessment Template Log

Captures logs related to assessment templates, ensuring traceability and version control.

Raw Data

Assessment Response Raw

Stores raw data related to assessment responses, providing unprocessed information for analysis.

Assessment Response Question Raw

Captures raw data related to assessment response questions, supporting detailed analysis and reporting.

Assessment Response Score Raw

Tracks raw data related to assessment response scores, ensuring comprehensive data capture.

Assessment Template Block Raw

Stores raw data related to assessment template blocks, providing foundational information for processing.

Assessment Template Raw

Captures raw data related to assessment templates, supporting detailed analysis and customization.

Assessment Dataset Specification

Assessment Template Features

Assessment Template Block Score Evaluation

  • Auto Workflows: Initiates workflows based on the evaluation of scores within template blocks, ensuring automated follow-up actions when certain criteria are met.

  • Notifications: Tracks notifications triggered by the evaluation of scores within template blocks, ensuring prompt communication to care teams or patients.

  • Problems: Documents clinical problems identified through the evaluation of block scores, enabling healthcare providers to act quickly on critical patient data.

  • Tasks: Captures tasks initiated by block score evaluations, ensuring that necessary follow-up actions are assigned and tracked.

  • Evaluations: Contains overall evaluations of scores within template blocks, providing a holistic view of patient assessments.

  • Parent Questions: Links parent questions to scores within template blocks, enabling a structured assessment of patient responses and conditions.

Assessment Template Metadata

  • Tags: Stores metadata tags associated with assessment templates, helping healthcare providers categorize and retrieve relevant templates quickly.

  • Type Programs: Links assessment templates to specific healthcare programs, ensuring that relevant assessments are available for targeted care initiatives.

  • Types: Categorizes assessment templates by type, enabling healthcare organizations to standardize assessments for different clinical purposes or patient groups.

Assessment Response Features

  • Score: Records the calculated scores from patient responses, providing quantitative data used to assess health conditions, monitor progress, and support clinical decision-making.

  • Template Block: Documents the sections or blocks of the assessment template, helping to structure the assessment and organize related questions and scores.

  • Notification: Manages notifications triggered by various assessment activities, ensuring that relevant stakeholders (e.g., healthcare providers, patients) are alerted to important updates or follow-ups.

  • Notes: Allows clinicians to document additional notes or observations during the assessment process, providing a qualitative complement to structured data.

  • Response Log: Tracks any updates or changes made to assessment responses, ensuring a complete audit trail for regulatory compliance and data integrity.

  • Response Question Log: Maintains a history of modifications to assessment questions, ensuring that all changes are properly documented and can be reviewed if needed.

  • Response Score Log: Logs changes to assessment scores, ensuring transparency and accountability in the scoring process.

  • Template Block Log: Records changes made to assessment template blocks, ensuring that updates to assessment structures are traceable.

  • Template Log: Maintains a detailed record of updates or changes to assessment templates, ensuring compliance with healthcare standards for version control and template management.

Raw Data Features

  • Response Raw: Contains unprocessed data related to patient responses, providing a comprehensive source for in-depth analysis, audits, or research.

  • Response Question Raw: Stores raw data related to assessment questions, ensuring that original question formats and content are preserved for analysis and validation.

  • Response Score Raw: Contains raw, unprocessed scoring data, providing a foundational dataset for detailed reporting and evaluation.

  • Template Block Raw: Captures unprocessed data related to assessment template blocks, allowing for granular analysis and review of assessment structures.

  • Template Raw: Stores unprocessed data related to assessment templates, ensuring that the complete structure and content of assessments can be analyzed in their original form.

Dataset Overview

This dataset plays a critical role in supporting healthcare organizations with structured, data-driven assessment processes. By capturing detailed patient responses, scores, workflows, and actions, the dataset enables effective care planning, outcome monitoring, and compliance with healthcare regulations, ensuring the delivery of high-quality patient care.

Table Specification

Table: Assessment_Response

Column Name

Is Nullable

Data Type

Description

Assessment_Response_Key

YES

STRING

Unique identifier for a specific assessment response.

Assessment_Response_ID

YES

STRING

System-generated ID for the assessment response.

Member_ID

YES

STRING

Unique identifier for the member/patient.

Assessment_Version_Key

YES

INT64

Unique identifier for the specific version of the assessment.

Assessment_ID

YES

STRING

System-generated ID for the assessment.

Assessment_Version_Custom_Code

YES

STRING

Custom code assigned to the assessment version.

Assessment_Custom_Code

YES

STRING

Custom code assigned to the assessment.

Assessment_Version_Name

YES

STRING

Name of the specific version of the assessment.

Assessment_Name

YES

STRING

Name of the assessment.

Assessment_Correlation_ID

YES

STRING

Correlation ID for linking related assessments.

Assessment_Version_Number

YES

INT64

Version number of the assessment.

Assessment_Reference

YES

STRING

Reference information for the assessment.

Assessment_Type

YES

STRING

Type or category of the assessment.

Assessment_Type_Description

YES

STRING

Detailed description of the assessment type.

Domain

YES

STRING

The domain or area of healthcare the assessment belongs to.

Program_

YES

STRING

Program-specific identifier or metadata related to the assessment.

Assessment Dataset Specification

Screening Key

  • Column Name: Screening_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for the program screening.

Assessment Response

Program Information

  • Column Name: Program_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: System-generated ID for the program.

  • Column Name: Program

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the program.

  • Column Name: Program_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Detailed description of the program.

Request Information

  • Column Name: Request_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for the assessment request.

  • Column Name: Request_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: System-generated ID for the request.

Digital Assessment

  • Column Name: Digital

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Boolean indicating if the assessment is digital or not.

Status Information

  • Column Name: Status

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Current status of the assessment response.

  • Column Name: Status_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Detailed description of the status.

Source Information

  • Column Name: Source

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Source of the assessment response.

  • Column Name: Source_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Detailed description of the source.

Timestamps

  • Column Name: Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp of when the assessment response was created.

  • Column Name: Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp of when the assessment response was last modified.

User Information

  • Column Name: Answered_By_Member

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Member who answered the assessment.

  • Column Name: Last_Answered_By_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the person who last answered or modified the assessment.

  • Column Name: Last_Answered_By_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the person who last answered or modified the assessment.

Response Indicators

  • Column Name: First

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Boolean indicating if this is the first response for this assessment.

  • Column Name: Latest

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Boolean indicating if this is the latest response for this assessment.

  • Column Name: First_Completed

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Boolean indicating if this is the first completed response for this assessment.

  • Column Name: Latest_Completed

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Boolean indicating if this is the latest completed response for this assessment.

Assessment Response Additional Actions

  • Column Name: Assessment_Response_Key

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique key identifying the associated assessment response.

  • Column Name: Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The code representing the specific additional action to be taken in relation to the response.

  • Column Name: Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of the additional action related to the assessment response.

Assessment Response Auto Workflows

  • Column Name: Assessment_Response_Key

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique key identifying the associated assessment response.

  • Column Name: Rule

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The rule or criteria that triggers the automatic workflow for the assessment response.

  • Column Name: Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp indicating when the auto workflow was created for the assessment response.

Assessment Response Notes

  • Column Name: Note_Key

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique identifier for the note entry.

  • Column Name: Assessment_Response_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier of the assessment response this note is associated with.

  • Column Name: Text

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The content of the note.

  • Column Name: Author_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The user ID of the person who authored the note.

  • Column Name: Author_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name of the person who authored the note.

  • Column Name: Void_Indicator

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: An indicator showing whether the note has been voided or nullified.

  • Column Name: Void_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when the note was voided, if applicable.

  • Column Name: Void_Reason

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The reason code for voiding the note, if applicable.

  • Column Name: Void_Reason_Description

  • Is Nullable: YES

  • Data Type: STRING

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

  • Column Name: Void_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The user ID of the person who voided the note, if applicable.

  • Column Name: Void_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name of the person who voided the note, if applicable.

  • Column Name: Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when the note was created.

  • Column Name: Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when the note was last modified.

  • Column Name: Assessment_Response_Question_Key

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for the specific question within the assessment response.

  • Column Name: Related_Assessment_Response_Score_Key

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the score that is related to the specific assessment response question.

Assessment Response Question Selected Response Child Assessment Response Question Keys

  • Column Name: Assessment_Response_Question_Key

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for the specific question within the assessment response.

  • Column Name: Selected_Response_Template_Key

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the template of the selected response associated with the assessment question.

  • Column Name: Child_Assessment_Response_Question_Key

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the child assessment response question related to the selected response of the parent question.

Assessment Response Score Matched Evaluation Child Assessment Response Questions

  • Column Name: Assessment_Response_Score_Key

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for the specific score within the assessment response.

  • Column Name: Matched_Evaluation_Template_Evaluation_Key

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the matched evaluation template associated with the assessment response score.

Assessment Dataset Specification

ed_Evaluation_Child_Assessment_Response_Questions

Columns

  • Child_Assessment_Response_Question_Key

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the child assessment response question related to the matched evaluation.

Assessment_Response_Score_Matched_Evaluation_Child_Assessment_Response_Questions

Columns

  • Child_Assessment_Response_Question_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the child assessment response question in the matched evaluation process.

Assessment_Response_Score_Parent_Assessment_Response_Questions

Columns

  • Assessment_Response_Score_Key

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for the specific score within the assessment response.

  • Parent_Assessment_Response_Question_Key

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for the parent assessment response question associated with the score.

  • Parent_Assessment_Response_Question_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the parent assessment response question within the system.

  • Parent_Assessment_Response_Formula_Parameter

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Parameter used in the formula associated with the parent assessment response question.

Assessment_Response_Question

Columns

  • Assessment_Response_Question_Key

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique identifier for the specific assessment response question.

  • Assessment_Response_Question_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier of the question within the response, enabling tracking of individual question responses.

  • Assessment_Response_Key

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Key linking to the parent assessment response.

  • Assessment_Response_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier of the response this question is associated with.

  • Member_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for the member who provided the response.

  • Assessment_Version_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Key referring to the specific version of the assessment.

  • Template_Question_Key

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Key linking to the template question within the assessment.

  • Question_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the question being responded to, ensuring consistency in question tracking.

  • Question_Version_Custom_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A custom code representing the specific version of the question, used for additional customization or tracking.

  • Block_Version_Custom_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A custom code representing the version of the block to which the question belongs.

  • Assessment_Version_Custom_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A custom code representing the version of the assessment.

  • Response_Version_Custom_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A custom code assigned to the version of the response for tracking changes or updates.

  • Block_Version_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Key for the version of the block to which this question belongs, ensuring accurate versioning.

  • Block_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the block that contains this question.

  • Block_Version_Number

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Version number of the block containing the question, used to track block updates.

  • Assessment_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the assessment this question belongs to.

  • Assessment_Version_Number

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Version number of the assessment, ensuring accuracy in assessment version tracking.

  • Question_Reference

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Reference code for the question, used for additional context or documentation purposes.

  • Question

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Text of the question being answered, providing the exact prompt posed to the respondent.

  • Question_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of question (e.g., multiple-choice, open-ended), categorizing the question format.

  • Question_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the question type, explaining the format and requirements of the question.

  • Question_Version_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name assigned to the question version, if applicable, for version control purposes.

  • Question_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the question as listed in the template, providing clarity on question identity.

  • Position

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Position of the question within the assessment, indicating its sequence order.

  • Parent_Assessment_Response_Question_Key

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Key for the parent question, if this is a sub-question, facilitating hierarchical question structures.

  • Parent_Assessment_Response_Question_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the parent question, if applicable, allowing linkage to related questions.

  • Parent_Assessment_Response_Score_Key

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique key of the parent question's score, used to link this question's response to a higher-level scoring element in the assessment.

  • Child_Question_Indicator

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicator specifying if this question is a child of another question.

  • Answered

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates whether the question has been answered (TRUE) or left unanswered (FALSE).

  • Required

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates if answering the question is mandatory (TRUE) or optional (FALSE).

  • Source

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Source from which the question or response was obtained, such as system or manual entry.

  • Source_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Detailed description of the source, providing context for how the question or response was obtained.

Assessment Dataset Specification

Assessment Response Question

Selected Response Template Key

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Key of the selected response from the template, linking to a predefined response.

Selected Response Weight

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Weight of the selected response, often used in scoring or evaluations.

Selected Response Position

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Position of the selected response in the list of possible answers, aiding in answer order tracking.

Selected Response Value Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Code representing the selected response value, allowing for standardized response identification.

Response Value

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The value provided in response to the question, representing the respondent's answer.

Response Value String

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Text value provided as a response, if applicable, allowing for open-ended answers.

Response Value Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: Date value provided as a response, if applicable, for date-specific questions.

Response Value Number

  • Is Nullable: YES

  • Data Type: NUMERIC

  • Description: Numeric value provided as a response, if applicable, for questions requiring numerical answers.

Answered By User ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier of the user who answered the question.

Answered By User Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the user who answered the question.

Answered By Member

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Name of the member who answered the question.

First

  • Is Nullable: YES

  • Data Type: STRING

  • Description: First assessment question response irrespective of status for a member/question combination.

Latest

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Latest assessment question response irrespective of status for a member/question combination.

Created Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the response question entry was created, marking the initial record creation.

Last Modified Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the response question entry was last modified, indicating the most recent update.

Assessment Template

Assessment Version Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for a specific version of an assessment template.

Assessment ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: System-generated ID for the assessment.

Assessment Version Custom Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Custom code assigned to the assessment version.

Assessment Custom Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Custom code assigned to the assessment for easy reference.

Assessment Correlation ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Correlation ID for linking related assessments.

Assessment Version Number

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Version number of the assessment template.

Assessment Version Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the specific version of the assessment template.

Assessment Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the assessment.

Assessment Alias

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Alternative name or shorthand for the assessment.

Assessment Reference

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Reference information or citation for the assessment.

Status

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Current status of the assessment template.

Status Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Detailed description of the status.

Location Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for the location associated with the assessment.

Location Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the location associated with the assessment.

Location Path

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Hierarchical path of the location within the organization structure.

Logic Applied

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates whether logic rules are applied to this assessment template.

Scoring Applied

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates whether scoring is applied to this assessment template.

Published

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates whether the assessment template has been published.

Created User ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the person who created the assessment template.

Created User Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the person who created the assessment template.

Created Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp of when the assessment template was created.

Modified User ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the person who last modified the assessment template.

Modified User Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the person who last modified the assessment template.

Last Modified Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp of when the assessment template was last modified.

Latest

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates whether this is the latest version of the assessment template.

Latest Published

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates whether this is the latest published version of the assessment template.

Assessment Template Block Question Response Auto Workflows

Block Version Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for the version of the block associated with the question response.

Template Question Key

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for the template question within the block.

Response Template Key

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for the response template associated with the question.

Auto Workflow Key

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique key identifying the automatic workflow triggered by the question response.

Rule Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Code of the rule applied in the auto workflow associated with the response.

Rule Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the rule applied in the automatic workflow.

Assessment Dataset Specification

Assessment Template Block Question Response Child Template Question Keys

Column Name

Is Nullable

Data Type

Description

Block_Version_Key

YES

INT64

Unique identifier for the version of the block associated with the question response.

Template_Question_Key

YES

STRING

Unique identifier for the template question within the block.

Response_Template_Key

YES

STRING

Unique identifier for the response template associated with the parent question.

Child_Template_Question_Key

YES

STRING

Unique identifier for the child template question triggered by the parent question response.

Assessment Template Block Question Response Notifications

Column Name

Is Nullable

Data Type

Description

Block_Version_Key

YES

INT64

Unique identifier for the version of the block associated with the question response.

Template_Question_Key

YES

STRING

Unique identifier for the template question within the block.

Response_Template_Key

YES

STRING

Unique identifier for the response template associated with the parent question.

Notification_Key

YES

STRING

Unique identifier for the notification triggered by the question response.

Urgent

YES

BOOL

Indicates whether the notification is marked as urgent.

Text

YES

STRING

The text content of the notification associated with the question response.

Title

YES

STRING

The title of the notification associated with the question response.

Assessment Template Block Question Response Problems

Column Name

Is Nullable

Data Type

Description

Block_Version_Key

YES

INT64

Unique identifier for the version of the block associated with the question response.

Template_Question_Key

YES

STRING

Unique identifier for the template question within the block.

Response_Template_Key

YES

STRING

Unique identifier for the response template associated with the question.

Problem

YES

STRING

Identifies the problem encountered in the question response.

Problem_Description

YES

STRING

A detailed description of the problem encountered during the question response process.

Assessment Template Block Question Response Tasks

Column Name

Is Nullable

Data Type

Description

Block_Version_Key

YES

INT64

Identifies the version of the block that contains the question response task.

Template_Question_Key

YES

STRING

Unique identifier for the template question related to the task.

Response_Template_Key

YES

STRING

Unique identifier for the response template associated with the task.

Task_Key

YES

STRING

Unique identifier for the specific task linked to the question response.

Task_Priority

YES

STRING

Specifies the priority level of the task, indicating its importance.

Task_Priority_Description

YES

STRING

Describes the priority level of the task in more detail.

Task_Reason

YES

STRING

Provides the reason for creating or assigning the task.

Task_Reason_Description

YES

STRING

Describes the reason for the task in more detail.

Task_Type

YES

STRING

Specifies the type of task that is required as part of the question response.

Task_Type_Description

YES

STRING

Provides a detailed description of the task type.

Additional_Action

YES

STRING

Indicates any additional actions that need to be performed as part of the task.

Additional_Action_Description

YES

STRING

Describes the additional actions in more detail.

Assessment Template Block Question Responses

Column Name

Is Nullable

Data Type

Description

Block_Version_Key

YES

INT64

Unique identifier for the version of the block containing the question responses.

Template_Question_Key

YES

STRING

Unique identifier for the template question related to the responses.

Response_Template_Key

YES

STRING

Unique identifier for the specific response template associated with the question.

Position

YES

INT64

Specifies the position or order of the response within the set of possible responses.

Value

YES

STRING

The value of the response provided for the associated question.

Value_Code

YES

STRING

The code associated with the response value, used for categorization or analysis purposes.

Weight

YES

INT64

The weight or score assigned to the response, which may impact overall scoring or evaluation outcomes.

Response_Custom_Code

YES

STRING

Custom code associated with the response.

Assessment Template Block Details

Column Name

Is Nullable

Data Type

Description

Block_Version_Key

YES

INT64

A unique key representing the specific version of the assessment block.

Block_ID

YES

STRING

The unique identifier for the assessment block.

Assessment Dataset Specification

Assessment Template Block Details

Block_Correlation_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: An identifier used to correlate related blocks within the assessment for tracking and analysis.

Block_Version_Number

  • Is Nullable: YES

  • Data Type: INT64

  • Description: The version number of the assessment block, indicating updates or revisions.

Block_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name of the assessment block, providing a descriptive label for the block's content or purpose.

Block_Reference

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Reference information related to the assessment block, aiding in contextual understanding.

Status

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The current status of the assessment block, such as 'Active' or 'Inactive'.

Block_Version_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name assigned to the specific version of the block, if applicable.

Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier of the user who last modified the assessment block.

Modified_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the user who last modified the assessment block, offering traceability.

Status_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of the current status of the assessment block, clarifying its usage state.

Location_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: A key representing the specific location associated with the assessment block, useful for organizational purposes.

Location_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name of the location where the block is used or stored, such as a department or facility.

Location_Path

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The hierarchical path or structure of the location, providing a clear view of its placement within the system.

Block_Reusable

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates whether the block can be reused in different assessments, enhancing flexibility.

Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier of the user who originally created the assessment block.

Created_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name of the user who created the assessment block, offering traceability for the initial setup.

Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when the assessment block was first created, marking its entry into the system.

Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp of the last modification made to the assessment block, indicating recent updates.

Assessment Template Block Questions

Block_Version_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: A unique key representing the version of the assessment block containing the questions. This key is used to track changes and updates to the block over time.

Block_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier for the assessment block.

Block_Correlation_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: An identifier used to correlate related blocks within the assessment, facilitating grouping and analysis of similar blocks.

Block_Version_Number

  • Is Nullable: YES

  • Data Type: INT64

  • Description: The version number of the assessment block, indicating the iteration of the block for version control purposes.

Block_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name of the assessment block that contains the questions, providing a descriptive label for the block's content.

Block_Reference

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Reference information related to the assessment block, providing additional context or linkage to other documentation.

Status

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The current status of the assessment block, such as 'Active', 'Inactive', or 'Archived'.

Status_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of the status of the assessment block, explaining its current state and usage.

Block_Version_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name assigned to the specific version of the block, providing a descriptive label for the version.

Question_Version_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name assigned to the specific version of the question within the block, providing clarity on the question's iteration.

Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier of the user who last modified the assessment block or its questions.

Modified_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the user who last modified the assessment block or its questions, ensuring traceability of changes.

Location_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: A key representing the location associated with the block, useful for organizational purposes.

Location_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name of the location where the block is used or stored, such as a department or facility.

Location_Path

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The hierarchical path or structure of the location, providing context on its placement within the system.

Block_Reusable

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates whether the block can be reused in other assessments (TRUE) or is unique to a specific assessment (FALSE).

Template_Question_Key

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique key representing the template question within the block, used for identification and tracking.

Question_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier for the question within the block, ensuring consistency across assessments.

Question_Version_Custom_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Custom code assigned to the question version.

Question_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name of the question as it appears in the template block, providing a clear prompt for respondents.

Assessment Dataset Specification

Assessment Template Block Questions

Question_Reference

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A reference used to identify the question within the block, such as a code or label for cross-referencing.

Question_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The type of the question (e.g., multiple choice, free text), indicating the expected response format.

Question_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of the question type, explaining how respondents should provide their answers.

Question_Position

  • Is Nullable: YES

  • Data Type: INT64

  • Description: The position of the question within the block, indicating its sequence in the assessment.

Question_Required

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates whether answering the question is mandatory (TRUE) or optional (FALSE).

Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier of the user who created the question, providing accountability for content creation.

Created_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name of the user who created the question, offering transparency in authorship.

Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when the question was created, marking its entry into the system.

Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp of the last modification made to the question, indicating recent updates or changes.

Assessment Template Block Scores

Block_Version_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: A unique key representing the version of the assessment block that includes the scores. This key is used to track changes and updates to the block over time.

Block_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier for the assessment block.

Block_Correlation_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: An identifier used to correlate related blocks within the assessment, facilitating grouping and analysis of similar blocks.

Block_Version_Number

  • Is Nullable: YES

  • Data Type: INT64

  • Description: The version number of the assessment block, indicating the iteration of the block for version control purposes.

Block_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name of the assessment block containing the scores, providing a descriptive label for the block's content.

Block_Reference

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Reference information related to the assessment block, providing additional context or linkage to other documentation.

Status

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The current status of the assessment block, such as 'Active', 'Inactive', or 'Archived'.

Status_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of the status of the assessment block, explaining its current state and usage.

Block_Version_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name assigned to the specific version of the block, providing a descriptive label for the version.

Score_Version_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name assigned to the specific version of the score within the block, aiding in version control and identification.

Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier of the user who last modified the assessment block or its scores, ensuring accountability and traceability.

Modified_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name of the user who last modified the assessment block or its scores, offering transparency in changes made.

Location_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: A key representing the location associated with the block, useful for organizational purposes.

Location_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name of the location where the block is used or stored, such as a department or facility.

Location_Path

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The hierarchical path or structure of the location, providing context on its placement within the system.

Block_Reusable

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates whether the block can be reused in other assessments (TRUE) or is unique to a specific assessment (FALSE).

Template_Score_Key

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique key representing the template score within the block, used for identification and tracking.

Score_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier for the score in the template block, ensuring consistency across assessments.

Score_Version_Custom_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Custom code assigned to the score version.

Score_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name of the score used in the block, providing a clear label for the scoring metric.

Score_Position

  • Is Nullable: YES

  • Data Type: INT64

  • Description: The position or order of the score within the block.

Score_Reference

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Reference information for the score within the block, such as a code or label for cross-referencing.

Formula

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The formula used to calculate the score, detailing the computation method applied.

Formula_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of how the score formula is applied, explaining the logic and parameters involved.

Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier of the user who created the score in the block, providing accountability for content creation.

Created_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name of the user who created the score in the block, offering transparency in authorship.

Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when the score was created, marking its entry into the system.

Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp of the last modification made to the score in the block, indicating recent updates or changes.

Assessment Dataset Specification

Assessment Template Blocks

Block_Version_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: A unique key representing the version of the assessment block.

Assessment_Version_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: A key representing the version of the overall assessment template to which the block belongs.

Block_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier for the assessment block.

Block_Correlation_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: An identifier used to correlate related blocks within the assessment.

Block_Version_Number

  • Is Nullable: YES

  • Data Type: INT64

  • Description: The version number of the assessment block.

Block_Position

  • Is Nullable: YES

  • Data Type: INT64

  • Description: The position of the block within the overall assessment template structure.

Assessment Template Display Hierarchy

Assessment_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the assessment.

Assessment_Custom_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Custom code for the assessment.

Assessment_Version_Number

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Version number of the assessment.

Assessment_Version_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Key for the assessment version.

Assessment_Reference

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Reference information for the assessment.

Assessment_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the assessment.

Assessment_Alias

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Alias for the assessment.

Assessment_Status

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Status of the assessment.

Assessment_Status_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the assessment status.

Assessment_Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the user who created the assessment.

Assessment_Created_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the user who created the assessment.

Assessment_Scoring_Applied

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates if scoring is applied to the assessment.

Assessment_Published

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates if the assessment is published.

Assessment_Types

  • Is Nullable: NO

  • Data Type: ARRAY

  • Description: Types of the assessment.

Assessment_Types.Programs

  • Is Nullable: NO

  • Data Type: ARRAY

  • Description: Programs associated with the assessment types.

Assessment_Types.Programs.Code

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Code for the program associated with the assessment type.

Assessment_Types.Programs.Description

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Description of the program associated with the assessment type.

Assessment_Types.Code

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Code for the assessment type.

Assessment_Types.Description

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Description of the assessment type.

Assessment_Types.Domain

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Domain of the assessment type.

Assessment_Types.Configs

  • Is Nullable: NO

  • Data Type: ARRAY

  • Description: Configurations for the assessment types.

Assessment_Types.Configs.Config_Key

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Key for the configuration.

Assessment_Types.Configs.Config_Code

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Code for the configuration.

Assessment_Types.Configs.Config_Description

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Description of the configuration.

Assessment_Types.Configs.Config_Values

  • Is Nullable: NO

  • Data Type: ARRAY

  • Description: Values for the configuration.

Assessment_Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the assessment was created.

Assessment_Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the assessment was last modified.

Assessment_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the user who modified the assessment.

Assessment_Modified_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the user who modified the assessment.

Block_Position

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Position of the block in the assessment.

Block_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the block.

Block_Version_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Key for the block version.

Block_Version_Number

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Version number of the block.

Block_Reference

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Reference information related to the assessment block, aiding in contextual understanding.

Block_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the block.

Block_Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the user who created the block.

Block_Created_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the user who created the block.

Block_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the user who modified the block.

Block_Modified_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the user who modified the block.

Block_Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the block was created.

Block_Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the block was last modified.

Item_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of the item.

Position_Path

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Path of the position.

Question_Path

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Path of the question.

Parent_Question_Item_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of the parent question item.

Parent_Template_Question_Key

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Key for the parent template question.

Parent_Question_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the parent question.

Assessment Dataset Specification

Assessment Template Display Hierarchy

Parent Template Score Key

  • Required: YES

  • Type: STRING

  • Description: Key for the parent template score.

Parent Score Name

  • Required: YES

  • Type: STRING

  • Description: Name of the parent score.

Template Question Key

  • Required: YES

  • Type: STRING

  • Description: Key for the template question.

Question Position

  • Required: YES

  • Type: INT64

  • Description: Position of the question.

Question Name

  • Required: YES

  • Type: STRING

  • Description: Name of the question.

Question Type

  • Required: YES

  • Type: STRING

  • Description: Type of the question.

Question Type Description

  • Required: YES

  • Type: STRING

  • Description: Description of the question type.

Question Reference

  • Required: YES

  • Type: STRING

  • Description: Reference for the question.

Question ID

  • Required: YES

  • Type: STRING

  • Description: Identifier for the question.

Question Custom Code

  • Required: YES

  • Type: STRING

  • Description: Custom code for the question.

Question Required

  • Required: YES

  • Type: BOOL

  • Description: Indicates if the question is required.

Response Template Key

  • Required: YES

  • Type: STRING

  • Description: Key for the response template.

Response Position

  • Required: YES

  • Type: INT64

  • Description: Position of the response.

Response Value

  • Required: YES

  • Type: STRING

  • Description: Value of the response.

Response Weight

  • Required: YES

  • Type: INT64

  • Description: Weight of the response.

Response Custom Code

  • Required: YES

  • Type: STRING

  • Description: Custom code for the response.

Template Score Key

  • Required: YES

  • Type: STRING

  • Description: Key for the template score.

Score Position

  • Required: YES

  • Type: INT64

  • Description: Position of the score.

Score Name

  • Required: YES

  • Type: STRING

  • Description: Name of the score.

Score Reference

  • Required: YES

  • Type: STRING

  • Description: Reference for the score.

Score ID

  • Required: YES

  • Type: STRING

  • Description: Identifier for the score.

Score Custom Code

  • Required: YES

  • Type: STRING

  • Description: Custom code for the score.

Score Formula

  • Required: YES

  • Type: STRING

  • Description: Formula for the score.

Score Formula Description

  • Required: YES

  • Type: STRING

  • Description: Description of the score formula.

Score Parent Questions

  • Required: NO

  • Type: ARRAY

  • Description: Parent questions for the score.

Score Parent Questions Template Question Key

  • Required: NO

  • Type: STRING

  • Description: Key for the template question of the parent question.

Score Parent Questions Question ID

  • Required: NO

  • Type: STRING

  • Description: Identifier for the parent question.

Score Parent Questions Question Custom Code

  • Required: NO

  • Type: STRING

  • Description: Custom code for the parent question.

Score Parent Questions Version Number

  • Required: NO

  • Type: INT64

  • Description: Version number of the parent question.

Score Parent Questions Formula Parameter

  • Required: NO

  • Type: STRING

  • Description: Formula parameter for the parent question.

Score Parent Questions Created Timestamp

  • Required: NO

  • Type: TIMESTAMP

  • Description: Timestamp when the parent question was created.

Score Parent Questions Last Modified Timestamp

  • Required: NO

  • Type: TIMESTAMP

  • Description: Timestamp when the parent question was last modified.

Template Evaluation Key

  • Required: YES

  • Type: STRING

  • Description: Key for the template evaluation.

Evaluation Custom Code

  • Required: YES

  • Type: STRING

  • Description: Custom code for the evaluation.

Evaluation Position

  • Required: YES

  • Type: INT64

  • Description: Position of the evaluation.

Evaluation Minimum Value

  • Required: YES

  • Type: NUMERIC

  • Description: Minimum value for the evaluation.

Evaluation Maximum Value

  • Required: YES

  • Type: NUMERIC

  • Description: Maximum value for the evaluation.

Evaluation Description

  • Required: YES

  • Type: STRING

  • Description: Description of the evaluation.

Child Template Question Keys

  • Required: NO

  • Type: ARRAY

  • Description: Child template question keys for the evaluation.

Child Template Question Key

  • Required: NO

  • Type: STRING

  • Description: Key for the child template question of the evaluation.

Problems

  • Required: NO

  • Type: ARRAY

  • Description: Problems associated with the evaluation.

Problems Code

  • Required: NO

  • Type: STRING

  • Description: Code for the problem associated with the evaluation.

Problems Description

  • Required: NO

  • Type: STRING

  • Description: Description of the problem associated with the evaluation.

Tasks

  • Required: NO

  • Type: ARRAY

  • Description: Tasks associated with the evaluation.

Tasks Key

  • Required: NO

  • Type: STRING

  • Description: Key for the task associated with the evaluation.

Tasks Priority

  • Required: NO

  • Type: STRING

  • Description: Priority of the task associated with the evaluation.

Tasks Priority Description

  • Required: NO

  • Type: STRING

  • Description: Description of the task priority.

Tasks Reason

  • Required: NO

  • Type: STRING

  • Description: Reason for the task associated with the evaluation.

Tasks Reason Description

  • Required: NO

  • Type: STRING

  • Description: Description of the task reason.

Tasks Type

  • Required: NO

  • Type: STRING

  • Description: Type of the task associated with the evaluation.

Tasks Type Description

  • Required: NO

  • Type: STRING

  • Description: Description of the task type.

Tasks Additional Action

  • Required: NO

  • Type: STRING

  • Description: Additional action for the task associated with the evaluation.

Tasks Additional Action Description

  • Required: NO

  • Type: STRING

  • Description: Description of the additional action.

Notifications

  • Required: NO

  • Type: ARRAY

  • Description: Notifications associated with the evaluation.

Notifications Key

  • Required: NO

  • Type: STRING

  • Description: Key for the notification associated with the evaluation.

Notifications Urgent

  • Required: NO

  • Type: BOOL

  • Description: Indicates if the notification is urgent.

Assessment Dataset Specification

Assessment Template Display Hierarchy

Notifications

  • Text: Text of the notification.

  • Title: Title of the notification.

Auto Workflows

  • Auto_Workflows: Automated workflows associated with the evaluation.

  • Key: Key for the automated workflow.

  • Rule_Code: Code for the rule of the automated workflow.

  • Rule_Name: Name of the rule of the automated workflow.

Assessment Template Block Score Evaluation Auto Workflows

Table Structure

Column Name

Is Nullable

Data Type

Description

Block_Version_Key

YES

INT64

Unique identifier for the version of the block containing the score evaluation and related workflows.

Template_Score_Key

YES

STRING

Unique identifier for the template score associated with the evaluation.

Template_Evaluation_Key

YES

STRING

Unique identifier for the specific template evaluation linked to the score.

Auto_Workflow_Key

YES

STRING

Unique identifier for the automated workflow triggered by the evaluation.

Rule_Code

YES

STRING

Code representing the rule that governs the automated workflow.

Rule_Name

YES

STRING

Name of the rule associated with the automated workflow.

Assessment Template Block Score Evaluation Notifications

Table Structure

Column Name

Is Nullable

Data Type

Description

Block_Version_Key

YES

INT64

Unique identifier for the version of the block containing the score evaluation and related notifications.

Template_Score_Key

YES

STRING

Unique identifier for the template score associated with the evaluation.

Template_Evaluation_Key

YES

STRING

Unique identifier for the specific template evaluation linked to the score.

Notification_Key

YES

STRING

Unique identifier for the notification generated from the evaluation.

Urgent

YES

BOOL

Indicates whether the notification is marked as urgent.

Text

YES

STRING

The content or body of the notification message.

Title

YES

STRING

The title or subject of the notification.

Assessment Template Block Score Evaluation Problems

Table Structure

Column Name

Is Nullable

Data Type

Description

Block_Version_Key

YES

INT64

Unique identifier for the version of the block containing the score evaluation and related problems.

Template_Score_Key

YES

STRING

Unique identifier for the template score associated with the evaluation.

Template_Evaluation_Key

YES

STRING

Unique identifier for the specific template evaluation linked to the score.

Problem

YES

STRING

The specific issue or problem identified during the evaluation.

Problem_Description

YES

STRING

Detailed description of the identified problem.

Assessment Template Block Score Evaluation Tasks

Table Structure

Column Name

Is Nullable

Data Type

Description

Block_Version_Key

YES

INT64

Unique identifier for the version of the block containing the score evaluation and related tasks.

Template_Score_Key

YES

STRING

Unique identifier for the template score associated with the evaluation task.

Template_Evaluation_Key

YES

STRING

Unique identifier for the template evaluation linked to the score evaluation task.

Task_Key

YES

STRING

Unique identifier for the task related to the score evaluation.

Task_Priority

YES

STRING

Priority level assigned to the task within the score evaluation.

Task_Priority_Description

YES

STRING

Description providing details about the assigned priority for the task.

Task_Reason

YES

STRING

Reason for the task being created or assigned during the score evaluation process.

Task_Reason_Description

YES

STRING

Additional description of the reason for the task within the score evaluation.

Task_Type

YES

STRING

Type of task assigned during the score evaluation.

Task_Type_Description

YES

STRING

Detailed description of the type of task.

Additional_Action

YES

STRING

Additional actions that are associated with the task in the score evaluation.

Additional_Action_Description

YES

STRING

Detailed description of the additional actions to be taken for the task in the score evaluation.

Assessment Template Block Score Evaluations

Table Structure

Column Name

Is Nullable

Data Type

Description

Block_Version_Key

YES

INT64

Unique identifier for the version of the block that includes the score evaluation.

Template_Score_Key

YES

STRING

Unique identifier for the template score used in the evaluation process.

Template_Evaluation_Key

YES

STRING

Unique identifier for the template evaluation within the block score.

Assessment Dataset Specification

Assessment Template Block Score Evaluations

Columns

  • k_Score_Evaluations Position

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Position or order of the evaluation within the block.

  • Assessment_Template_Block_Score_Evaluations Minimum_Value

  • Is Nullable: YES

  • Data Type: NUMERIC

  • Description: The minimum value that can be assigned or used in this evaluation.

  • Assessment_Template_Block_Score_Evaluations Maximum_Value

  • Is Nullable: YES

  • Data Type: NUMERIC

  • Description: The maximum value that can be assigned or used in this evaluation.

  • Assessment_Template_Block_Score_Evaluations Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the evaluation, providing additional context or details.

Assessment Template Block Score Parent Questions

Columns

  • Block_Version_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for the version of the block that includes the parent question.

  • Template_Score_Key

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for the template score associated with the parent question.

  • Parent_Template_Question_Key

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for the parent template question.

  • Parent_Question_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the parent question within the assessment.

  • Parent_Block_Version_Number

  • Is Nullable: YES

  • Data Type: INT64

  • Description: The version number of the parent block containing the question.

  • Parent_Formula_Parameter

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The formula parameter associated with the parent question in the scoring block.

  • Parent_Block_Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the parent block was created.

  • Parent_Block_Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp of the last modification to the parent block.

Assessment Template Tags

Columns

  • Assessment_Tag_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: A unique key representing the specific tag within the assessment template.

  • Assessment_Version_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: A key representing the version of the assessment template to which the tag is associated.

  • Tag_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name of the tag used to categorize or describe aspects of the assessment template.

Assessment Template Type Programs

Columns

  • Assessment_Version_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: A unique key identifying the version of the assessment template associated with this program.

  • Assessment_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The type of assessment template used in the program.

  • Program

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The specific program associated with the assessment template type.

  • Program_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A description providing more details about the program linked to the assessment template type.

Assessment Template Types

Columns

  • Assessment_Version_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: A unique key identifying the version of the assessment template.

  • Assessment_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The type of the assessment template, which defines its purpose and structure.

  • Assessment_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description providing more information about the assessment type.

  • Domain

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The domain or category to which the assessment type belongs, such as healthcare, education, etc.

Assessment Response Score

Columns

  • Assessment_Response_Score_Key

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique identifier for the assessment response score.

  • Assessment_Response_Score_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier for the score in the assessment response.

  • Assessment_Response_Key

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique key referencing the parent assessment response.

  • Assessment_Response_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier for the assessment response.

  • Member_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier for the member associated with the assessment response.

  • Score_Version_Custom_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A custom code representing the version of the score in the assessment, used for tracking updates and customizations.

  • Block_Version_Custom_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A custom code for the version of the block associated with this score, used for customizations and tracking.

  • Assessment_Version_Custom_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A custom code for the version of the assessment, used for additional tracking or customization.

  • Matched_Evaluation_Version_Custom_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A custom code representing the matched evaluation version for additional tracking or customization.

  • Template_Score_Key

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A key referencing the template score in the assessment.

  • Assessment_Version_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: A key representing the version of the assessment used.

  • Assessment_Version_Number

  • Is Nullable: YES

  • Data Type: INT64

  • Description: The version number of the assessment.

  • Score_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier for the score within the assessment.

  • Block_Version_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: A key referencing the version of the block used in the assessment template.

  • Block_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier for the block within the assessment.

  • Block_Version_Number

  • Is Nullable: YES

  • Data Type: INT64

  • Description: The version number of the block used in the assessment.

  • Score_Reference

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A reference code or identifier associated with the score.

  • Assessment_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier for the assessment.

  • Score_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name of the score in the assessment.

  • Score_Version_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name of the score version in the assessment.

Assessment Dataset Specification

Assessment Response Score

Matched Evaluation Template Evaluation Key

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A key referencing the template evaluation used for this score.

Matched Evaluation Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A description of the matched evaluation criteria for this score.

Matched Evaluation Minimum Value

  • Is Nullable: YES

  • Data Type: NUMERIC

  • Description: The minimum value for the evaluation criteria.

Matched Evaluation Maximum Value

  • Is Nullable: YES

  • Data Type: NUMERIC

  • Description: The maximum value for the evaluation criteria.

Matched Evaluation Position

  • Is Nullable: YES

  • Data Type: INT64

  • Description: The position of the matched evaluation within the assessment.

Formula

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The formula used to calculate the score.

Formula Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A description of the formula applied to calculate the score.

Total Score

  • Is Nullable: YES

  • Data Type: NUMERIC

  • Description: The total score derived from the assessment.

First

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates if this is the first assessment score response irrespective of status for a member/score combination.

Latest

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates if this is the latest assessment score response irrespective of status for a member/score combination.

Created Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the score was created.

Last Modified Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the score was last modified.

Assessment Template Block

Version Key

  • Is Nullable: NO

  • Data Type: INT64

  • Description: Unique identifier for the version of the block within the assessment template.

Block ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier assigned to the block for reference within and outside the system.

Correlation ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier used to link this block with other related entities or processes within the system.

Version Number

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Version number of the block, indicating its revision within the template.

Reference

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Additional reference information associated with the block for more detailed identification or notes.

Block Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name of the block, providing a descriptive label for easier identification.

Status

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Current status of the block within the template, such as 'Active', 'Inactive', or 'Pending Review'.

Status Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description providing more details on the status, explaining what each status entails for the block.

Location Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Key identifier for the location associated with this block.

Location Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the location associated with the block.

Location Path

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Path describing where the block is stored or how it is categorized within the organizational structure.

Created User ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the creator of the block. Useful for audit trails and managing permissions.

Reusable

  • Is Nullable: NO

  • Data Type: BOOL

  • Description: Indicates whether the block can be reused in multiple templates or sections within the system.

Created Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp marking when the block was originally created.

Last Modified Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp of the most recent modification made to the block.

Questions

  • Is Nullable: YES

  • Data Type: ARRAY

  • Description: List of questions included within the block.

Questions Template Question Key

  • Is Nullable: NO

  • Data Type: INT64

  • Description: Unique identifier for the question within the template.

Questions Position

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Position of the question within the block.

Questions Question

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The text of the question.

Questions Question Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The type of question, such as 'Multiple Choice' or 'Free Text'.

Questions Question Type Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the question type, providing additional details.

Questions Reference

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Reference information for the question, used for linking to other records or providing context.

Questions Question ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for the question.

Questions Required

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates whether the question is required to be answered.

Questions Version Number

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Version number of the question, indicating its revision within the block.

Questions Created Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the question was created.

Questions Last Modified Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the question was last modified.

Questions Responses

  • Is Nullable: YES

  • Data Type: ARRAY

  • Description: List of possible responses for the question.

Responses Template Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for the response within the template.

Responses Position

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Position of the response within the list of possible responses.

Responses Value

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The value or text of the response.

Responses Value Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Code representing the value of the response, used for standardized categorization.

Responses Weight

  • Is Nullable: YES

  • Data Type: INT64

  • Description: The weight assigned to the response, indicating its importance or relevance within the assessment.

Responses Created Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the response was created.

Responses Last Modified Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the response was last modified.

Responses Child Template Question Key

  • Is Nullable: YES

  • Data Type: ARRAY

  • Description: List of keys identifying the child template questions related to this response.

Responses Problems

  • Is Nullable: YES

  • Data Type: ARRAY

  • Description: List of problems associated with the response.

Problems Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for the problem.

Problems Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Code representing the problem.

Problems Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the problem.

Problems Created Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the problem was created.

Assessment Dataset Specification

ems.Last_Modified_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp when the problem was last modified.

Questions.Responses.Tasks

Questions.Responses.Tasks

  • Required: YES

  • Type: ARRAY

  • Description: List of tasks associated with the response.

Questions.Responses.Tasks.Key

  • Required: YES

  • Type: INT64

  • Description: Unique identifier for the task.

Questions.Responses.Tasks.Data

  • Required: YES

  • Type: STRING

  • Description: Data or description associated with the task.

Questions.Responses.Tasks.Additional_Action

  • Required: YES

  • Type: STRING

  • Description: Additional action to be taken as part of the task.

Questions.Responses.Tasks.Additional_Action_Description

  • Required: YES

  • Type: STRING

  • Description: Description of the additional action.

Questions.Responses.Tasks.Created_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp when the task was created.

Questions.Responses.Tasks.Last_Modified_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp when the task was last modified.

Questions.Responses.Notifications

Questions.Responses.Notifications

  • Required: YES

  • Type: ARRAY

  • Description: List of notifications associated with the response.

Questions.Responses.Notifications.Key

  • Required: YES

  • Type: INT64

  • Description: Unique identifier for the notification.

Questions.Responses.Notifications.Data

  • Required: YES

  • Type: STRING

  • Description: Data or description associated with the notification.

Questions.Responses.Notifications.Created_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp when the notification was created.

Questions.Responses.Notifications.Last_Modified_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp when the notification was last modified.

Questions.Responses.Auto_Workflows

Questions.Responses.Auto_Workflows

  • Required: YES

  • Type: ARRAY

  • Description: List of automatic workflows triggered by the response.

Questions.Responses.Auto_Workflows.Key

  • Required: YES

  • Type: INT64

  • Description: Unique identifier for the workflow.

Questions.Responses.Auto_Workflows.Data

  • Required: YES

  • Type: STRING

  • Description: Data or description associated with the workflow.

Questions.Responses.Auto_Workflows.Created_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp when the workflow was created.

Questions.Responses.Auto_Workflows.Last_Modified_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp when the workflow was last modified.

Assessment_Template_Block Scores

Scores

  • Required: YES

  • Type: ARRAY

  • Description: List of scores associated with the block.

Scores.Template_Score_Key

  • Required: NO

  • Type: INT64

  • Description: Unique identifier for the score within the template.

Scores.Score_Name

  • Required: YES

  • Type: STRING

  • Description: Name of the score.

Scores.Reference

  • Required: YES

  • Type: STRING

  • Description: Additional reference information associated with the score.

Scores.Score_ID

  • Required: YES

  • Type: STRING

  • Description: Unique identifier for the score.

Scores.Version_Number

  • Required: YES

  • Type: INT64

  • Description: Version number of the score.

Scores.Formula

  • Required: YES

  • Type: STRING

  • Description: Formula used to calculate the score.

Scores.Formula_Description

  • Required: YES

  • Type: STRING

  • Description: Description of the formula used for the score.

Scores.Created_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp when the score was created.

Scores.Last_Modified_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp when the score was last modified.

Scores.BMI

Scores.BMI

  • Required: YES

  • Type: STRUCT

  • Description: Body Mass Index (BMI) calculation details.

Scores.BMI.Key

  • Required: YES

  • Type: INT64

  • Description: Unique identifier for the BMI calculation within the template.

Scores.BMI.Height_Template_Question_Key

  • Required: YES

  • Type: INT64

  • Description: Identifier for the height question used in the BMI calculation.

Scores.BMI.Weight_Template_Question_Key

  • Required: YES

  • Type: INT64

  • Description: Identifier for the weight question used in the BMI calculation.

Scores.BMI.Created_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp when the BMI calculation details were created.

Scores.BMI.Last_Modified_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp when the BMI calculation details were last modified.

Scores.Parent_Template_Question_Keys

  • Required: YES

  • Type: ARRAY

  • Description: List of keys identifying the parent template questions related to the score.

Scores.Evaluations

Scores.Evaluations

  • Required: YES

  • Type: ARRAY

  • Description: List of evaluations associated with the score.

Scores.Evaluations.Template_Evaluation_Key

  • Required: YES

  • Type: INT64

  • Description: Unique identifier for the evaluation within the template.

Scores.Evaluations.Position

  • Required: YES

  • Type: INT64

  • Description: Position of the evaluation within the list of evaluations.

Scores.Evaluations.Minimum_Value

  • Required: YES

  • Type: NUMERIC

  • Description: Minimum value for the evaluation.

Scores.Evaluations.Maximum_Value

  • Required: YES

  • Type: NUMERIC

  • Description: Maximum value for the evaluation.

Scores.Evaluations.Description

  • Required: YES

  • Type: STRING

  • Description: Description of the evaluation.

Scores.Evaluations.Created_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp when the evaluation was created.

Scores.Evaluations.Last_Modified_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp when the evaluation was last modified.

Scores.Evaluations.Child_Template_Question_Keys

  • Required: YES

  • Type: ARRAY

  • Description: List of keys identifying the child template questions related to the evaluation.

Scores.Evaluations.Problems

Scores.Evaluations.Problems

  • Required: YES

  • Type: ARRAY

  • Description: List of problems associated with the evaluation.

Scores.Evaluations.Problems.Key

  • Required: YES

  • Type: INT64

  • Description: Unique identifier for the problem.

Scores.Evaluations.Problems.Code

  • Required: YES

  • Type: STRING

  • Description: Code representing the problem.

Scores.Evaluations.Problems.Description

  • Required: YES

  • Type: STRING

  • Description: Description of the problem.

Scores.Evaluations.Problems.Created_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp when the problem was created.

Scores.Evaluations.Problems.Last_Modified_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp when the problem was last modified.

Scores.Evaluations.Tasks

Scores.Evaluations.Tasks

  • Required: YES

  • Type: ARRAY

  • Description: List of tasks associated with the evaluation.

Scores.Evaluations.Tasks.Key

  • Required: YES

  • Type: INT64

  • Description: Unique identifier for the task.

Scores.Evaluations.Tasks.Data

  • Required: YES

  • Type: STRING

  • Description: Data or description associated with the task.

Scores.Evaluations.Tasks.Additional_Action

  • Required: YES

  • Type: STRING

  • Description: Additional action to be taken as part of the task.

Scores.Evaluations.Tasks.Additional_Action_Description

  • Required: YES

  • Type: STRING

  • Description: Description of the additional action.

Scores.Evaluations.Tasks.Created_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp when the task was created.

Scores.Evaluations.Tasks.Last_Modified_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp when the task was last modified.

Scores.Evaluations.Notifications

Scores.Evaluations.Notifications

  • Required: YES

  • Type: ARRAY

  • Description: List of notifications associated with the evaluation.

Scores.Evaluations.Notifications.Key

  • Required: YES

  • Type: INT64

  • Description: Unique identifier for the notification.

Scores.Evaluations.Notifications.Data

  • Required: YES

  • Type: STRING

  • Description: Data or description associated with the notification.

Scores.Evaluations.Notifications.Created_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp when the notification was created.

Scores.Evaluations.Notifications.Last_Modified_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp when the notification was last modified.

Scores.Evaluations.Auto_Workflows

Scores.Evaluations.Auto_Workflows

  • Required: YES

  • Type: ARRAY

  • Description: List of automatic workflows triggered by the evaluation.

Scores.Evaluations.Auto_Workflows.Key

  • Required: YES

  • Type: INT64

  • Description: Unique identifier for the workflow.

Scores.Evaluations.Auto_Workflows.Data

  • Required: YES

  • Type: STRING

  • Description: Data or description associated with the workflow.

Scores.Evaluations.Auto_Workflows.Created_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp when the workflow was created.

Scores.Evaluations.Auto_Workflows.Last_Modified_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp when the workflow was last modified.

Assessment Dataset Specification

Scores.Evaluations.Auto_Workflows

Data

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Data or description associated with the workflow.

Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the workflow was created.

Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the workflow was last modified.

Assessment_Template_Block

Record_Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The timestamp indicating the last time the record was modified.

Transaction_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The user ID of the person who performed the transaction.

Record_Last_Modified_Timestamp

  • Is Nullable: NO

  • Data Type: TIMESTAMP

  • Description: The timestamp indicating the last time the record was modified.

Transaction_User_ID

  • Is Nullable: NO

  • Data Type: STRING

  • Description: The user ID of the person who performed the transaction.

Type

  • Is Nullable: NO

  • Data Type: STRING

  • Description: The type of the assessment template block.

Tenant

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Unique identifier for the tenant.

Active_Version

  • Is Nullable: NO

  • Data Type: BOOL

  • Description: Indicator if this is the active version of the template block.

Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: The date associated with the template block.

Sequence

  • Is Nullable: NO

  • Data Type: INT64

  • Description: The sequence number of the template block.

Source_System_Name

  • Is Nullable: NO

  • Data Type: STRING

  • Description: The name of the source system from which the data originated.

Source_File_Name

  • Is Nullable: NO

  • Data Type: STRING

  • Description: The name of the source file from which the data was imported.

Source_Timestamp

  • Is Nullable: NO

  • Data Type: TIMESTAMP

  • Description: The timestamp of when the source file was created or last modified.

Schema_Version

  • Is Nullable: YES

  • Data Type: NUMERIC

  • Description: The version of the schema used for the template block.

Deleted_Indicator

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicator if the template block has been deleted.

Notification

Notification_Key

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Unique identifier for the notification.

Member_ID

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Unique identifier for the member associated with the notification.

Title

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Title of the notification.

Text

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Text content of the notification.

Source

  • Is Nullable: YES

  • Data Type: STRUCT

  • Description: Source information of the notification.

Source_Type_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for the type of source.

Source_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of the source.

Source_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the source type.

Assessment_Response_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for the assessment response.

Target

  • Is Nullable: YES

  • Data Type: STRUCT

  • Description: Target information of the notification.

Target_Type_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for the type of target.

Target_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of the target.

Target_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the target type.

Program_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Code of the program associated with the notification.

Program_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for the program.

Screening_Request_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for the screening request.

Request_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for the request.

Request_Key

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Key for the request associated with the notification.

Owner_Department_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for the department owning the notification.

Owner_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for the user owning the notification.

Urgent

  • Is Nullable: NO

  • Data Type: BOOL

  • Description: Indicator if the notification is urgent.

Hidden

  • Is Nullable: NO

  • Data Type: BOOL

  • Description: Indicator if the notification is hidden.

Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the notification was created.

Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the notification was last modified.

Notification_Task

  • Is Nullable: YES

  • Data Type: STRUCT

  • Description: Task information associated with the notification.

Key

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for the notification task.

Task_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for the task.

Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the notification task was created.

Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the notification task was last modified.

Record_Last_Modified_Timestamp

  • Is Nullable: NO

  • Data Type: TIMESTAMP

  • Description: Timestamp when the record was last modified.

Transaction_User_ID

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Unique identifier for the user who performed the transaction.

Deleted_Indicator

  • Is Nullable: NO

  • Data Type: BOOL

  • Description: Indicator if the notification has been deleted.

Assessment_notes

Member_ID

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Unique identifier for the member associated with the note.

Note_Key

  • Is Nullable: NO

  • Data Type: INTEGER

  • Description: Unique identifier for the note.

Text

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Text content of the note.

Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of the note.

Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the note type.

Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the note was created.

Author_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for the user who authored the note.

Void_Indicator

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicator if the note has been voided.

Void_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the note was voided.

Void_Reason

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Reason for voiding the note.

Void_Reason_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the reason for voiding the note.

Void_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for the user who voided the note.

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of entity related to the note.

  • Is Nullable: YES

  • Data Type: INTEGER

  • Description: Unique identifier for the related entity.

Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the note was initially created.

Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the note was last modified.

Record_Last_Modified_Timestamp

  • Is Nullable: NO

  • Data Type: TIMESTAMP

  • Description: Timestamp when the record was last modified.

Assessment Dataset Specification

Assessment Notes

Transaction_User_ID

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Unique identifier for the user who performed the transaction.

Deleted_Indicator

  • Is Nullable: NO

  • Data Type: BOOL

  • Description: Indicator if the note has been deleted.

Assessment Response Log

Assessment_Response_Key

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Key for the assessment response.

Assessment_Response_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the assessment response.

Member_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the member.

Program_Screening_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Key for the program screening.

Program

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the program.

Program_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the program.

Request_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Key for the request.

Digital

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates if the response is digital.

Status

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Status of the assessment response.

Status_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the status.

Source

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Source of the assessment response.

Source_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the source.

Assessment_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of the assessment.

Assessment_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the assessment type.

Domain

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Domain of the assessment.

Template

  • Is Nullable: YES

  • Data Type: STRUCT

  • Description: Template used for the assessment.

Template.Version_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Key for the template version.

Template.Correlation_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Correlation ID for the template.

Template.Assessment_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the template assessment.

Template.Assessment_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the template assessment.

Template.Reference

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Reference for the template.

Template.Version_Number

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Version number of the template.

Template.Assessment_Custom_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Custom code for the template assessment.

Auto_Workflows

  • Is Nullable: NO

  • Data Type: ARRAY

  • Description: Automated workflows associated with the assessment.

Auto_Workflows.Created_Timestamp

  • Is Nullable: NO

  • Data Type: TIMESTAMP

  • Description: Timestamp when the automated workflow was created.

Auto_Workflows.Rule

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Rule for the automated workflow.

Additional_Actions

  • Is Nullable: NO

  • Data Type: ARRAY

  • Description: Additional actions associated with the assessment.

Additional_Actions.Code

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Code for the additional action.

Additional_Actions.Description

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Description of the additional action.

Answered_By_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the user who answered the assessment.

Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the assessment response was created.

Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the assessment response was last modified.

Record_Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the record was last modified in the system.

Transaction_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

Deleted_Indicator

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicator if the record is deleted.

Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of the assessment response.

Tenant

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the tenant or client.

Active_Version

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates the active version of the record.

Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: Date of the assessment response.

Sequence

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Sequence number of the assessment response.

Source_System_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the source system.

Source_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp from the source system.

Source_File_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the source file.

Schema_Version

  • Is Nullable: YES

  • Data Type: FLOAT64

  • Description: Version of the schema.

Member_Partition

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Partition for the member data.

_updated

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicator if the record is updated.

Action

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Action performed in the assessment response.

Program_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the program.

Request_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the request.

Answered_By_Member_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the member who answered the assessment.

Transaction_Actor_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of the actor performing the transaction.

Assessment Response Question Log

Assessment_Response_Question_Key

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for the assessment response question.

Assessment_Response_Key

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for the assessment response associated with the question.

Assessment_Response_Question_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the assessment response question.

Template

  • Is Nullable: YES

  • Data Type: STRUCT

  • Description: Template information for the assessment response question.

Template.Assessment_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for the assessment template.

Template.Version_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Key representing the version of the template.

Template.Version_Number

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Numeric value indicating the version number of the template.

Template.Template_Question_Key

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Key representing the specific question within the template.

Template.Question_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for the question.

Template.Block_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the block within the template.

Template.Block_Custom_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Custom code associated with the block.

Template.Assessment_Custom_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Custom code associated with the assessment.

Assessment Dataset Specification

Template

Template.Block_Version_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Key representing the version of the block.

Template.Block_Version_Number

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Numeric value indicating the version number of the block.

Template.Question_Reference

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Reference information for the question.

Template.Question_Custom_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Custom code associated with the question.

Assessment_Response_Question_log

Member_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for the member.

Position

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Position of the question within the assessment.

  • Is Nullable: NO

  • Data Type: ARRAY

  • Description: Array of keys related to the assessment response scores.

Child_Question_Indicator

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicator if the question is a child question.

Parent_Assessment_Response_Question_Key

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Key of the parent assessment response question, if applicable.

Question_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of the question.

Question_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the question type.

Question

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The text of the question.

Response_Value

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The response value provided for the question.

Response_Value_String

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The response value provided as a string.

Response_Value_Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: The response value provided as a date.

Response_Value_Number

  • Is Nullable: YES

  • Data Type: NUMERIC

  • Description: The response value provided as a number.

Answered

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates if the question was answered.

Required

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates if the question is required.

Answered_By_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier of the user who answered the question.

Source

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Source of the question.

Source_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the source of the question.

Selected_Responses

  • Is Nullable: NO

  • Data Type: ARRAY

  • Description: Array of selected responses for the question.

Selected_Responses.Position

  • Is Nullable: NO

  • Data Type: INT64

  • Description: The position of the selected response, indicating its order in the sequence of possible responses.

Selected_Responses.Weight

  • Is Nullable: NO

  • Data Type: INT64

  • Description: The weight assigned to the selected response, representing its importance or impact within the assessment.

Selected_Responses.Response_Template_Key

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Unique key identifying the template response associated with the question.

Selected_Responses.Value

  • Is Nullable: NO

  • Data Type: STRING

  • Description: The actual value of the selected response provided in the assessment.

Selected_Responses.Value_Code

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Code representing the value of the response, used for standardized categorization.

Selected_Responses.Child_Assessment_Response_Question_Keys

  • Is Nullable: NO

  • Data Type: ARRAY

  • Description: List of keys identifying the child assessment response questions related to this response for further clarification.

Selected_Responses.Response_Custom_Code

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Custom code associated with the selected response.

Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the assessment response question was created.

Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the assessment response question was last modified.

Record_Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the record was last modified.

Transaction_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

Deleted_Indicator

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicator whether the assessment response question is deleted.

Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of the assessment response question log entry.

Tenant

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Tenant associated with the assessment response question log entry.

Active_Version

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates if the assessment response question is the active version.

Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: Date associated with the assessment response question log entry.

Sequence

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Sequence number of the assessment response question log entry.

Source_System_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the source system from where the assessment response question originated.

Source_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the data was sourced.

Source_File_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the source file from where the assessment response question data was sourced.

Schema_Version

  • Is Nullable: YES

  • Data Type: FLOAT64

  • Description: Version of the schema used for the assessment response question log entry.

Member_Partition

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Partition number for the member associated with the assessment response question.

_updated

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Timestamp indicating the last update of the assessment response question log entry.

Action

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Action associated with the assessment response question log entry.

Parent_Assessment_Response_Score_Key

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Key for the parent assessment response score.

Parent_Assessment_Response_Score_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the parent assessment response score.

Answered_By_Member_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the member who answered the question.

Transaction_Actor_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of the actor performing the transaction.

Assessment_Response_Score_log

Assessment_Response_Score_Key

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for the assessment response score.

Assessment_Response_Key

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for the assessment response.

Assessment Dataset Specification

Assessment Response Score Log

Assessment Response Score ID

  • Type: STRING

  • Description: Identifier for the assessment response score.

Template

  • Type: STRUCT

  • Description: Template information for the assessment response score.

Template Fields

  • Assessment_ID

  • Type: STRING

  • Description: Unique identifier for the assessment associated with the response score.

  • Version_Key

  • Type: INT64

  • Description: Key representing the version of the assessment template used in the scoring.

  • Version_Number

  • Type: INT64

  • Description: Version number of the assessment, indicating the specific iteration of the assessment template.

  • Template_Score_Key

  • Type: STRING

  • Description: Unique key linking the score to a specific template, ensuring consistency in score tracking.

  • Score_ID

  • Type: STRING

  • Description: Identifier for the score associated with the assessment, used for reference and tracking.

  • Block_Version_Key

  • Type: INT64

  • Description: Key representing the version of the block in which the score resides, ensuring accuracy in grouping.

  • Block_ID

  • Type: STRING

  • Description: Unique identifier for the block of questions or responses related to this score.

  • Block_Version_Number

  • Type: INT64

  • Description: Version number of the block, indicating any updates or revisions made to this group of questions.

  • Score_Custom_Code

  • Type: STRING

  • Description: Custom code associated with the score.

  • Block_Custom_Code

  • Type: STRING

  • Description: Custom code associated with the block.

  • Assessment_Custom_Code

  • Type: STRING

  • Description: Custom code associated with the assessment.

  • Score_Reference

  • Type: STRING

  • Description: Reference information for the score, providing additional context or details related to the score.

Member ID

  • Type: STRING

  • Description: Unique identifier for the member.

Score Name

  • Type: STRING

  • Description: Name of the score.

Matched Evaluation

  • Type: STRING

  • Description: A textual description of the evaluation criteria or score definition.

Matched Evaluation Fields

  • Description

  • Type: NUMERIC

  • Description: The minimum value allowed for the evaluation, defining the lower bound of the score range.

  • Minimum_Value

  • Type: NUMERIC

  • Description: The maximum value allowed for the evaluation, defining the upper bound of the score range.

  • Maximum_Value

  • Type: ARRAY

  • Description: An array of child assessment response questions, each identified by a key and ID, indicating related sub-questions.

  • Child_Assessment_Response_Questions

  • Type: ARRAY

  • Description: The position of this evaluation in relation to other evaluations or scoring elements.

  • Fields:

    • Key

    • Type: STRING

    • Description: Key for the maximum value of the matched evaluation.

    • ID

    • Type: STRING

    • Description: Identifier for the maximum value of the matched evaluation.

  • Position

  • Type: STRING

  • Description: A unique key linking this evaluation to the template for tracking and reference purposes.

  • Evaluation_Custom_Code

  • Type: STRING

  • Description: Custom code associated with the matched evaluation.

  • Template_Evaluation_Key

  • Type: STRING

  • Description: A textual description of the evaluation criteria or score definition.

Formula

  • Type: STRING

  • Description: Formula used to calculate the score.

Formula Description

  • Type: STRING

  • Description: Description of the formula used for the score.

Parent Assessment Response Questions

  • Type: ARRAY

  • Description: Array of parent assessment response questions related to the score.

Parent Assessment Response Questions Fields

  • Key

  • Type: STRING

  • Description: A unique key used to identify each parent assessment response question within the dataset.

  • ID

  • Type: STRING

  • Description: The identifier for the parent assessment response question, used for reference and tracking.

  • Formula_Parameter

  • Type: STRING

  • Description: Represents a formula or parameter associated with the parent assessment response question, if applicable.

Total Score

  • Type: NUMERIC

  • Description: Total score calculated.

Timestamps

  • Created_Timestamp

  • Type: TIMESTAMP

  • Description: Timestamp when the assessment response score was created.

  • Last_Modified_Timestamp

  • Type: TIMESTAMP

  • Description: Timestamp when the assessment response score was last modified.

  • Record_Last_Modified_Timestamp

  • Type: TIMESTAMP

  • Description: Timestamp when the record was last modified.

Transaction User ID

  • Type: STRING

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

Deleted Indicator

  • Type: BOOL

  • Description: Indicator whether the assessment response score is deleted.

Type

  • Type: STRING

  • Description: Type of the assessment response score log entry.

Tenant

  • Type: STRING

  • Description: Tenant associated with the assessment response score log entry.

Active Version

  • Type: BOOL

  • Description: Indicates if the assessment response score is the active version.

Date

  • Type: DATE

  • Description: Date associated with the assessment response score log entry.

Sequence

  • Type: INT64

  • Description: Sequence number of the assessment response score log entry.

Source System Name

  • Type: STRING

  • Description: Name of the source system from where the assessment response score originated.

Source Timestamp

  • Type: TIMESTAMP

  • Description: Timestamp when the data was sourced.

Source File Name

  • Type: STRING

  • Description: Name of the source file from where the assessment response score data was sourced.

Schema Version

  • Type: FLOAT64

  • Description: Version of the schema used for the assessment response score log entry.

Member Partition

  • Type: INT64

  • Description: Partition number for the member associated with the assessment response score.

Updated

  • Type: STRING

  • Description: Timestamp indicating the last update of the record.

Action

  • Type: STRING

  • Description: Action taken on the assessment response score log entry.

Assessment Dataset Specification

Transaction Actor Type

  • Column Name: Transaction_Actor_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of the actor performing the transaction.

Assessment Template Block Log

General Attributes

  • Version Key

  • Column Name: Version_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for a specific version of an assessment template block.

  • Block ID

  • Column Name: Block_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: System-generated ID for the block.

  • Block Custom Code

  • Column Name: Block_Custom_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Custom code assigned to the block for easy reference.

  • Correlation ID

  • Column Name: Correlation_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Correlation ID for linking related blocks.

  • Version Number

  • Column Name: Version_Number

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Version number of the block.

  • Reference

  • Column Name: Reference

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Reference information or citation for the block.

  • Block Name

  • Column Name: Block_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the block.

  • Status

  • Column Name: Status

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Current status of the block.

  • Status Description

  • Column Name: Status_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Detailed description of the status.

Location Details

  • Location Key

  • Column Name: Location_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for the location associated with the block.

  • Location Name

  • Column Name: Location_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the location associated with the block.

  • Location Path

  • Column Name: Location_Path

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Hierarchical path of the location within the organization structure.

Creation and Modification Details

  • Created User ID

  • Column Name: Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the person who created the block.

  • Reusable

  • Column Name: Reusable

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates whether the block is reusable in other templates.

  • Created Timestamp

  • Column Name: Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp of when the block was created.

  • Last Modified Timestamp

  • Column Name: Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp of when the block was last modified.

Questions

General Attributes

  • Questions

  • Column Name: Questions

  • Is Nullable: NO

  • Data Type: ARRAY

  • Description: Collection of questions within the block.

  • Template Question Key

  • Column Name: Questions.Template_Question_Key

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Unique identifier for a specific question within the template.

  • Position

  • Column Name: Questions.Position

  • Is Nullable: NO

  • Data Type: INT64

  • Description: Position or order of the question within the block.

  • Question

  • Column Name: Questions.Question

  • Is Nullable: NO

  • Data Type: STRING

  • Description: The actual question text.

  • Question Type

  • Column Name: Questions.Question_Type

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Type or category of the question.

  • Question Type Description

  • Column Name: Questions.Question_Type_Description

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Detailed description of the question type.

  • Reference

  • Column Name: Questions.Reference

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Reference information or citation for the question.

  • Question ID

  • Column Name: Questions.Question_ID

  • Is Nullable: NO

  • Data Type: STRING

  • Description: System-generated ID for the question.

  • Question Custom Code

  • Column Name: Questions.Question_Custom_Code

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Custom code assigned to the question for easy reference.

  • Required

  • Column Name: Questions.Required

  • Is Nullable: NO

  • Data Type: BOOL

  • Description: Indicates whether the question is mandatory.

Responses

General Attributes

  • Responses

  • Column Name: Questions.Responses

  • Is Nullable: NO

  • Data Type: ARRAY

  • Description: Collection of possible responses for the question.

  • Response Template Key

  • Column Name: Questions.Responses.Response_Template_Key

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Unique identifier for a specific response template.

  • Position

  • Column Name: Questions.Responses.Position

  • Is Nullable: NO

  • Data Type: INT64

  • Description: Position or order of the response option.

  • Value

  • Column Name: Questions.Responses.Value

  • Is Nullable: NO

  • Data Type: STRING

  • Description: The actual response value or text.

  • Value Code

  • Column Name: Questions.Responses.Value_Code

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Code associated with the response value.

  • Weight

  • Column Name: Questions.Responses.Weight

  • Is Nullable: NO

  • Data Type: INT64

  • Description: Numerical weight assigned to the response.

  • Response Custom Code

  • Column Name: Questions.Responses.Response_Custom_Code

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Custom code assigned to the response for easy reference.

Child Template Question Keys

  • Child Template Question Keys

  • Column Name: Questions.Responses.Child_Template_Question_Keys

  • Is Nullable: NO

  • Data Type: ARRAY

  • Description: List of question keys that are triggered by this response.

Problems

  • Problems

  • Column Name: Questions.Responses.Problems

  • Is Nullable: NO

  • Data Type: ARRAY

  • Description: Collection of potential problems associated with this response.

  • Code

  • Column Name: Questions.Responses.Problems.Code

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Code or identifier for a specific problem.

  • Description

  • Column Name: Questions.Responses.Problems.Description

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Detailed description of the problem.

Tasks

  • Tasks

  • Column Name: Questions.Responses.Tasks

  • Is Nullable: NO

  • Data Type: ARRAY

  • Description: Collection of tasks associated with this response.

  • Key

  • Column Name: Questions.Responses.Tasks.Key

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Unique identifier for a specific task.

  • Priority

  • Column Name: Questions.Responses.Tasks.Priority

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Priority level of the task.

  • Priority Description

  • Column Name: Questions.Responses.Tasks.Priority_Description

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Description of the priority level.

  • Reason

  • Column Name: Questions.Responses.Tasks.Reason

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Reason for assigning the task.

  • Reason Description

  • Column Name: Questions.Responses.Tasks.Reason_Description

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Detailed description of the reason.

  • Type

  • Column Name: Questions.Responses.Tasks.Type

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Type or category of the task.

  • Type Description

  • Column Name: Questions.Responses.Tasks.Type_Description

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Description of the task type.

  • Additional Action

  • Column Name: Questions.Responses.Tasks.Additional_Action

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Any additional action required for the task.

  • Additional Action Description

  • Column Name: Questions.Responses.Tasks.Additional_Action_Description

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Detailed description of the additional action.

Notifications

  • Notifications

  • Column Name: Questions.Responses.Notifications

  • Is Nullable: NO

  • Data Type: ARRAY

  • Description: Collection of notifications associated with this response.

  • Key

  • Column Name: Questions.Responses.Notifications.Key

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Unique identifier for a specific notification.

  • Urgent

  • Column Name: Questions.Responses.Notifications.Urgent

  • Is Nullable: NO

  • Data Type: BOOL

  • Description: Indicates whether the notification is urgent.

  • Text

  • Column Name: Questions.Responses.Notifications.Text

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Content of the notification message.

  • Title

  • Column Name: Questions.Responses.Notifications.Title

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Title or subject of the notification.

Assessment Dataset Specification

Workflows

Auto Workflows

  • Key: Unique identifier for a specific workflow.

  • Rule_Code: Code representing the rule that triggers the workflow.

  • Rule_Name: Name of the rule that triggers the workflow.

Scores

General Information

  • Template_Score_Key: Unique identifier for a specific score within the template.

  • Score_Name: Name of the score.

  • Reference: Reference information or citation for the score.

  • Score_ID: System-generated ID for the score.

  • Score_Custom_Code: Custom code assigned to the score for easy reference.

  • Formula: Mathematical or logical expression used to calculate the score.

  • Formula_Description: Detailed explanation of how the formula works.

Parent Questions

  • Template_Question_Key: Unique identifier for a parent question.

  • Question_ID: System-generated ID for the parent question.

  • Question_Custom_Code: Custom code assigned to the parent question.

  • Version_Number: Version number of the parent question.

  • Formula_Parameter: Parameter used in the score formula related to this question.

  • Created_Timestamp: Timestamp of when the parent question was created.

  • Last_Modified_Timestamp: Timestamp of when the parent question was last modified.

Evaluations

  • Template_Evaluation_Key: Unique identifier for a specific evaluation.

  • Evaluation_Custom_Code: Custom code assigned to the evaluation.

  • Position: Position or order of the evaluation.

  • Minimum_Value: Minimum value for this evaluation range.

  • Maximum_Value: Maximum value for this evaluation range.

  • Description: Description of what this evaluation range represents.

  • Child_Template_Question_Keys: List of question keys relevant to this evaluation.

Problems

  • Code: Code or identifier for a specific problem.

  • Description: Detailed description of the problem.

Tasks

  • Key: Unique identifier for a specific task.

  • Priority: Priority level of the task.

  • Priority_Description: Description of the priority level.

  • Reason: Reason for assigning the task.

  • Reason_Description: Detailed description of the reason.

  • Type: Type or category of the task.

  • Type_Description: Description of the task type.

  • Additional_Action: Any additional action required for the task.

  • Additional_Action_Description: Detailed description of the additional action.

Notifications

  • Key: Unique identifier for a specific notification.

  • Urgent: Indicates whether the notification is urgent.

  • Text: Content of the notification message.

  • Title: Title or subject of the notification.

Auto Workflows

  • Key: Unique identifier for a specific workflow.

  • Rule_Code: Code representing the rule that triggers the workflow.

  • Rule_Name: Name of the rule that triggers the workflow.

Assessment Dataset Specification

Assessment Template Block Log

Columns and Descriptions

  • Record_Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp of when the record was last modified.

  • Transaction_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the person who performed the transaction.

  • Deleted_Indicator

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates whether the record has been marked as deleted.

  • Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type or category of the record.

  • Tenant

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the tenant or organization.

  • Active_Version

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates whether this is the active version of the block.

  • Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: Date of the record.

  • Sequence

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Sequence number for ordering.

  • Source_System_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the source system.

  • Source_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp from the source system.

  • Source_File_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the source file.

  • Schema_Version

  • Is Nullable: YES

  • Data Type: FLOAT64

  • Description: Version of the schema used.

  • _updated

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Timestamp of the last update.

  • Action

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Action performed on the record (e.g., insert, update, delete).

  • Transaction_Actor_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of the actor performing the transaction.

Assessment Template Log

Columns and Descriptions

  • Version_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for the version of the assessment template.

  • Assessment_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for the assessment.

  • Assessment_Custom_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Custom code associated with the assessment.

  • Correlation_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier used to correlate the assessment template with other related records.

  • Version_Number

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Number representing the version of the assessment template.

  • Reference

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Reference information associated with the assessment template.

  • Assessment_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the assessment.

  • Assessment_Alias

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Alias of the assessment.

  • Status

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Status of the assessment template.

  • Status_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the assessment template's status.

  • Location_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for the location associated with the assessment template.

  • Location_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the location associated with the assessment template.

  • Location_Path

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Path indicating the location hierarchy.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier of the user who created the assessment template.

  • Logic_Applied

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates if logic has been applied to the assessment template.

  • Scoring_Applied

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates if scoring has been applied to the assessment template.

  • Published

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates if the assessment template has been published.

  • Tags

  • Is Nullable: NO

  • Data Type: ARRAY

  • Description: Array of tags associated with the assessment template.

  • Tags.Key

    • Is Nullable: NO

    • Data Type: INT64

    • Description: Unique identifier for the tag.

  • Tags.Name

    • Is Nullable: NO

    • Data Type: STRING

    • Description: Name of the tag.

  • Types

  • Is Nullable: NO

  • Data Type: ARRAY

  • Description: Array of types associated with the assessment template.

  • Types.Programs

    • Is Nullable: NO

    • Data Type: ARRAY

    • Description: Array of programs associated with the type.

  • Types.Code

    • Is Nullable: NO

    • Data Type: STRING

    • Description: Code representing the type.

  • Types.Description

    • Is Nullable: NO

    • Data Type: STRING

    • Description: Description of the type.

  • Types.Domain

    • Is Nullable: NO

    • Data Type: STRING

    • Description: Domain associated with the type.

  • Types.Configs

    • Is Nullable: NO

    • Data Type: ARRAY

    • Description: A collection or array of configuration settings for different types within the system.

    • Types.Configs.Config_Key

    • Is Nullable: NO

    • Data Type: STRING

    • Description: A unique identifier for each configuration setting, used to reference specific configurations.

    • Types.Configs.Config_Code

    • Is Nullable: NO

    • Data Type: STRING

    • Description: A short code or abbreviation representing the configuration, often used for quick reference or in system processes.

    • Types.Configs.Config_Description

    • Is Nullable: NO

    • Data Type: STRING

    • Description: A detailed explanation or description of what the configuration setting does or represents.

    • Types.Configs.Config_Values

    • Is Nullable: NO

    • Data Type: ARRAY

    • Description: The possible values or options that can be set for this particular configuration.

  • Blocks

  • Is Nullable: NO

  • Data Type: ARRAY

  • Description: Array of blocks associated with the assessment template.

  • Blocks.Position

    • Is Nullable: NO

    • Data Type: INT64

    • Description: Position of the block within the assessment template.

  • Blocks.Version_Key

    • Is Nullable: NO

    • Data Type: INT64

    • Description: Unique identifier for the version of the block.

  • Blocks.Block_ID

    • Is Nullable: NO

    • Data Type: STRING

    • Description: Identifier for the block.

  • Blocks.Correlation_ID

    • Is Nullable: NO

    • Data Type: STRING

    • Description: Identifier used to correlate the block with other related records.

  • Blocks.Version_Number

    • Is Nullable: NO

    • Data Type: INT64

    • Description: Version number of the block.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the assessment template was created.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the assessment template was last modified.

  • Record_Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the record was last modified.

  • Transaction_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Deleted_Indicator

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicator whether the assessment template is deleted.

  • Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of the assessment template log entry.

  • Tenant

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Tenant associated with the assessment template log entry.

  • Active_Version

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates if the assessment template is the active version.

  • Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: Date associated with the assessment template log entry.

  • Sequence

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Sequence number of the assessment template log entry.

  • Source_System_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the source system.

Assessment Dataset Specification

Assessment Template Log

Columns

  • Name (YES, STRING): Name of the source system from where the assessment template data originated.

  • Source_Timestamp (YES, TIMESTAMP): Timestamp when the data was sourced.

  • Source_File_Name (YES, STRING): Name of the source file from where the assessment template data was sourced.

  • Schema_Version (YES, FLOAT64): Version of the schema used for the assessment template log entry.

  • _updated (YES, STRING): Timestamp indicating the last update of the record.

  • Action (YES, STRING): Action taken on the assessment template log entry.

  • Transaction_Actor_Type (YES, STRING): Type of the actor performing the transaction.

Assessment Response Raw

Columns

  • Assessment_Response_Key (YES, STRING): Unique identifier for the assessment response.

  • Assessment_Response_ID (YES, STRING): Identifier for the assessment response.

  • Assessment_Custom_Code (YES, STRING): Custom code associated with the assessment.

  • Member_ID (YES, STRING): Unique identifier for the member associated with the assessment response.

  • Program_Screening_Key (YES, INT64): Key for the program screening associated with the assessment response.

  • Program (YES, STRING): Name of the program associated with the assessment response.

  • Program_Description (YES, STRING): Description of the program associated with the assessment response.

  • Request_Key (YES, INT64): Key for the request associated with the assessment response.

  • Digital (YES, BOOL): Indicates if the assessment response is digital.

  • Status (YES, STRING): Status of the assessment response.

  • Status_Description (YES, STRING): Description of the status of the assessment response.

  • Source (YES, STRING): Source of the assessment response.

  • Source_Description (YES, STRING): Description of the source of the assessment response.

  • Assessment_Type (YES, STRING): Type of the assessment.

  • Assessment_Type_Description (YES, STRING): Description of the assessment type.

  • Domain (YES, STRING): Domain associated with the assessment response.

  • Template (YES, STRUCT): Template information for the assessment response.

  • Template.Version_Key (YES, INT64): A unique key representing the version of the assessment response template.

  • Template.Correlation_ID (YES, STRING): A correlation ID that links the assessment response to related data or processes.

  • Template.Assessment_ID (YES, STRING): A unique identifier for the specific assessment instance.

  • Template.Assessment_Name (YES, STRING): The name or title of the assessment conducted.

  • Template.Assessment_Custom_Code (YES, STRING): Custom code associated with the assessment.

  • Template.Reference (YES, STRING): A reference field used to provide additional context or linking information.

  • Template.Version_Number (YES, INT64): The version number of the assessment, indicating updates or revisions made.

  • Template.Assessment_Custom_Code (YES, STRING): Custom code associated with the assessment.

  • Auto_Workflows (NO, ARRAY): Array of automatic workflows associated with the assessment response.

  • Auto_Workflows.Created_Timestamp (NO, TIMESTAMP): Timestamp when the automatic workflow was created.

  • Auto_Workflows.Rule (NO, STRING): Rule associated with the automatic workflow.

  • Additional_Actions (NO, ARRAY): Array of additional actions associated with the assessment response.

  • Additional_Actions.Code (NO, STRING): Code representing the additional action.

  • Additional_Actions.Description (NO, STRING): Description of the additional action.

  • Answered_By_User_ID (YES, STRING): Identifier of the user who answered the assessment response.

  • Created_Timestamp (YES, TIMESTAMP): Timestamp when the assessment response was created.

  • Last_Modified_Timestamp (YES, TIMESTAMP): Timestamp when the assessment response was last modified.

  • Record_Last_Modified_Timestamp (YES, TIMESTAMP): Timestamp when the record was last modified.

  • Transaction_User_ID (YES, STRING): Identifier of the user who performed the transaction.

  • Deleted_Indicator (YES, BOOL): Indicator whether the assessment response is deleted.

  • Type (YES, STRING): Type of the assessment response.

  • Tenant (YES, STRING): Tenant associated with the assessment response.

  • Active_Version (YES, BOOL): Indicates if the assessment response is the active version.

  • Date (YES, DATE): Date associated with the assessment response.

  • Sequence (YES, INT64): Sequence number of the assessment response.

  • Source_System_Name (YES, STRING): Name of the source system from where the assessment response data originated.

  • Source_Timestamp (YES, TIMESTAMP): Timestamp when the data was sourced.

  • Source_File_Name (YES, STRING): Name of the source file from where the assessment response data was sourced.

  • Schema_Version (YES, FLOAT64): Version of the schema used for the assessment response.

  • Member_Partition (YES, INT64): Partition identifier for the member.

  • _updated (YES, STRING): Timestamp indicating the last update of the record.

  • Program_ID (YES, STRING): Identifier for the program.

  • Request_ID (YES, STRING): Identifier for the request.

  • Answered_By_Member_ID (YES, STRING): Identifier for the member who answered the assessment.

  • Transaction_Actor_Type (YES, STRING): Type of the actor performing the transaction.

Assessment Dataset Specification

Assessment Response Question

Fields

  • Assessment_Response_Question_Key

  • Type: STRING

  • Required: YES

  • Description: Unique identifier for the assessment response question.

  • Assessment_Response_Key

  • Type: STRING

  • Required: YES

  • Description: Unique identifier for the assessment response.

  • Assessment_Response_Question_ID

  • Type: STRING

  • Required: YES

  • Description: Identifier for the assessment response question.

  • Template

  • Type: STRUCT

  • Required: YES

  • Description: Template information for the assessment response question.

Template Fields

  • Template.Assessment_ID

  • Type: STRING

  • Required: YES

  • Description: Unique identifier for the assessment linked to the response question.

  • Template.Version_Key

  • Type: INT64

  • Required: YES

  • Description: Unique key representing the version of the assessment template.

  • Template.Version_Number

  • Type: INT64

  • Required: YES

  • Description: The version number of the assessment, indicating which iteration of the template is used.

  • Template.Template_Question_Key

  • Type: STRING

  • Required: YES

  • Description: Unique key identifying the specific question within the template.

  • Template.Question_ID

  • Type: STRING

  • Required: YES

  • Description: Unique identifier for the question in the assessment.

  • Template.Block_ID

  • Type: STRING

  • Required: YES

  • Description: Unique identifier for the block in which this question resides, representing a group of related questions.

  • Template.Block_Custom_Code

  • Type: STRING

  • Required: YES

  • Description: Custom code associated with the block.

  • Template.Assessment_Custom_Code

  • Type: STRING

  • Required: YES

  • Description: Custom code associated with the assessment.

  • Template.Block_Version_Key

  • Type: INT64

  • Required: YES

  • Description: Unique key representing the version of the block.

  • Template.Block_Version_Number

  • Type: INT64

  • Required: YES

  • Description: The version number of the block, indicating updates or changes to the block.

  • Template.Question_Reference

  • Type: STRING

  • Required: YES

  • Description: Reference information for the question, providing additional context or details related to the question.

  • Template.Question_Custom_Code

  • Type: STRING

  • Required: YES

  • Description: Custom code associated with the question.

Additional Fields

  • Member_ID

  • Type: STRING

  • Required: YES

  • Description: Unique identifier for the member associated with the assessment response question.

  • Position

  • Type: INT64

  • Required: YES

  • Description: Position of the question within the assessment response.

  • Related_Assessment_Response_Score_Keys

  • Type: ARRAY

  • Required: NO

  • Description: Array of keys for the related assessment response scores.

  • Child_Question_Indicator

  • Type: BOOL

  • Required: YES

  • Description: Indicator if the question is a child question. The default value is false.

  • Parent_Assessment_Response_Question_Key

  • Type: STRING

  • Required: YES

  • Description: Key for the parent assessment response question.

  • Question_Type

  • Type: STRING

  • Required: YES

  • Description: Type of the question.

  • Question_Type_Description

  • Type: STRING

  • Required: YES

  • Description: Description of the question type.

  • Question

  • Type: STRING

  • Required: YES

  • Description: Text of the question.

  • Response_Value

  • Type: STRING

  • Required: YES

  • Description: Value of the response.

  • Response_Value_String

  • Type: STRING

  • Required: YES

  • Description: String representation of the response value.

  • Response_Value_Date

  • Type: DATE

  • Required: YES

  • Description: Date representation of the response value.

  • Response_Value_Number

  • Type: NUMERIC

  • Required: YES

  • Description: Numeric representation of the response value.

  • Answered

  • Type: BOOL

  • Required: YES

  • Description: Indicator if the question was answered. The default value is false.

  • Required

  • Type: BOOL

  • Required: YES

  • Description: Indicator if the question is required. The default value is false.

  • Answered_By_User_ID

  • Type: STRING

  • Required: YES

  • Description: Identifier of the user who answered the question.

  • Source

  • Type: STRING

  • Required: YES

  • Description: Source of the question.

  • Source_Description

  • Type: STRING

  • Required: YES

  • Description: Description of the source of the question.

Selected Responses

  • Selected_Responses

  • Type: ARRAY

  • Required: NO

  • Description: Array of selected responses for the question.

Selected Responses Fields

  • Selected_Responses.Position

  • Type: INT64

  • Required: NO

  • Description: The position of the selected response in the sequence of available responses for the question.

  • Selected_Responses.Weight

  • Type: INT64

  • Required: NO

  • Description: The weight assigned to the selected response, representing its importance or influence in the assessment scoring.

  • Selected_Responses.Response_Template_Key

  • Type: STRING

  • Required: NO

  • Description: Unique key linking the selected response to the response template for consistent reference across assessments.

  • Selected_Responses.Value

  • Type: STRING

  • Required: NO

  • Description: The actual value provided in response to the question, as recorded in the assessment.

  • Selected_Responses.Value_Code

  • Type: STRING

  • Required: NO

  • Description: The code representing the response value, used for standardized tracking and categorization of responses.

  • Selected_Responses.Child_Assessment_Response_Question_Keys

  • Type: ARRAY

  • Required: NO

  • Description: An array of keys linking to related child questions, indicating any dependent or follow-up questions triggered by this response.

  • Selected_Responses.Response_Custom_Code

  • Type: STRING

  • Required: NO

  • Description: Custom code associated with the selected response.

Timestamps and Metadata

  • Created_Timestamp

  • Type: TIMESTAMP

  • Required: YES

  • Description: Timestamp when the assessment response question was created.

  • Last_Modified_Timestamp

  • Type: TIMESTAMP

  • Required: YES

  • Description: Timestamp when the assessment response question was last modified.

  • Record_Last_Modified_Timestamp

  • Type: TIMESTAMP

  • Required: YES

  • Description: Timestamp when the record was last modified.

  • Transaction_User_ID

  • Type: STRING

  • Required: YES

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

  • Deleted_Indicator

  • Type: BOOL

  • Required: YES

  • Description: Indicator whether the assessment response question is deleted.

Additional Metadata

  • Type

  • Type: STRING

  • Required: YES

  • Description: Type of the assessment response question.

  • Tenant

  • Type: STRING

  • Required: YES

  • Description: Tenant associated with the assessment response question.

  • Active_Version

  • Type: BOOL

  • Required: YES

  • Description: Indicates if the assessment response question is the active version.

  • Date

  • Type: DATE

  • Required: YES

  • Description: Date associated with the assessment response question.

  • Sequence

  • Type: INT64

  • Required: YES

  • Description: Sequence number of the assessment response question.

  • Source_System_Name

  • Type: STRING

  • Required: YES

  • Description: Name of the source system from where the assessment response question data originated.

Assessment Dataset Specification

Assessment Response Question Raw

Columns and Descriptions

  • Source_Timestamp

  • Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the data was sourced.

  • Source_File_Name

  • Nullable: YES

  • Data Type: STRING

  • Description: Name of the source file from where the assessment response question data was sourced.

  • Schema_Version

  • Nullable: YES

  • Data Type: FLOAT64

  • Description: Version of the schema used for the assessment response question.

  • Member_Partition

  • Nullable: YES

  • Data Type: INT64

  • Description: Partition identifier for the member.

  • _updated

  • Nullable: YES

  • Data Type: STRING

  • Description: Timestamp indicating the last update of the record.

  • Parent_Assessment_Response_Score_Key

  • Nullable: YES

  • Data Type: STRING

  • Description: Key for the parent assessment response score.

  • Parent_Assessment_Response_Score_ID

  • Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the parent assessment response score.

  • Answered_By_Member_ID

  • Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the member who answered the question.

  • Transaction_Actor_Type

  • Nullable: YES

  • Data Type: STRING

  • Description: Type of the actor performing the transaction.

Assessment Response Score Raw

Columns and Descriptions

  • Assessment_Response_Score_Key

  • Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for the assessment response score.

  • Assessment_Response_Key

  • Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for the assessment response.

  • Assessment_Response_Score_ID

  • Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the assessment response score.

  • Template

  • Nullable: YES

  • Data Type: STRUCT

  • Description: Template information for the assessment response score.

Template Fields

  • Assessment_ID

  • Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for the assessment associated with the response score.

  • Version_Key

  • Nullable: YES

  • Data Type: INT64

  • Description: Key representing the version of the assessment being used.

  • Version_Number

  • Nullable: YES

  • Data Type: INT64

  • Description: Version number of the assessment, used to track updates and changes over time.

  • Template_Score_Key

  • Nullable: YES

  • Data Type: STRING

  • Description: Unique key identifying the specific template score used in the assessment.

  • Score_Custom_Code

  • Nullable: YES

  • Data Type: STRING

  • Description: Custom code associated with the score.

  • Score_ID

  • Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the score within the assessment template.

  • Block_Version_Key

  • Nullable: YES

  • Data Type: INT64

  • Description: Key representing the version of the block containing the score.

  • Block_ID

  • Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for the block within the assessment structure.

  • Block_Custom_Code

  • Nullable: YES

  • Data Type: STRING

  • Description: Custom code associated with the block.

  • Assessment_Custom_Code

  • Nullable: YES

  • Data Type: STRING

  • Description: Custom code associated with the assessment.

  • Block_Version_Number

  • Nullable: YES

  • Data Type: INT64

  • Description: Version number of the block, indicating any updates or changes to the block.

  • Score_Reference

  • Nullable: YES

  • Data Type: STRING

  • Description: Reference to the specific score or calculation used within the assessment, providing context or details.

Additional Fields

  • Member_ID

  • Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for the member associated with the assessment response score.

  • Score_Name

  • Nullable: YES

  • Data Type: STRING

  • Description: Name of the score.

  • Matched_Evaluation

  • Nullable: YES

  • Data Type: STRUCT

  • Description: Information about the matched evaluation for the score.

Matched Evaluation Fields

  • Description

  • Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of the matched evaluation used in the assessment response score.

  • Minimum_Value

  • Nullable: YES

  • Data Type: NUMERIC

  • Description: The minimum value allowed or expected for this evaluation.

  • Maximum_Value

  • Nullable: YES

  • Data Type: NUMERIC

  • Description: The maximum value allowed or expected for this evaluation.

  • Child_Assessment_Response_Questions

  • Nullable: YES

  • Data Type: ARRAY

  • Description: The position of this evaluation in relation to other evaluations or scoring elements.

Child Assessment Response Questions Fields

  • Key

  • Nullable: YES

  • Data Type: STRING

  • Description: Key for the maximum value of the matched evaluation.

  • ID

  • Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the maximum value of the matched evaluation.

  • Position

  • Nullable: YES

  • Data Type: INT64

  • Description: The position or order in which this evaluation appears within the assessment.

  • Evaluation_Custom_Code

  • Nullable: YES

  • Data Type: STRING

  • Description: Custom code associated with the matched evaluation.

  • Template_Evaluation_Key

  • Nullable: YES

  • Data Type: STRING

  • Description: The unique key identifying the evaluation template used in this assessment response.

Formula Fields

  • Formula

  • Nullable: YES

  • Data Type: STRING

  • Description: Formula used to calculate the score.

  • Formula_Description

  • Nullable: YES

  • Data Type: STRING

  • Description: Description of the formula used for the score calculation.

Parent Assessment Response Questions

  • Parent_Assessment_Response_Questions

  • Nullable: NO

  • Data Type: ARRAY

  • Description: Array of parent assessment response questions related to the score.

Parent Assessment Response Questions Fields

  • Key

  • Nullable: NO

  • Data Type: STRING

  • Description: A unique identifier key for the parent assessment response question.

  • ID

  • Nullable: NO

  • Data Type: STRING

  • Description: The ID associated with the parent assessment response question.

  • Formula_Parameter

  • Nullable: NO

  • Data Type: STRING

  • Description: A parameter used in the formula or calculation related to the parent assessment response question.

Timestamps and Metadata

  • Total_Score

  • Nullable: YES

  • Data Type: FLOAT64

  • Description: Total score calculated for the assessment response.

  • Created_Timestamp

  • Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the assessment response score was created.

  • Last_Modified_Timestamp

  • Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the assessment response score was last modified.

  • Record_Last_Modified_Timestamp

  • Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the record was last modified.

  • Transaction_User_ID

  • Nullable: YES

  • Data Type: STRING

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

  • Deleted_Indicator

  • Nullable: YES

  • Data Type: BOOL

  • Description: Indicator whether the assessment response score was deleted.

Assessment Dataset Specification

Assessment Response Score

Columns and Descriptions

  • Assessment_Response_Score_raw Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of the assessment response score.

  • Assessment_Response_Score_raw Tenant

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Tenant associated with the assessment response score.

  • Assessment_Response_Score_raw Active_Version

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates if the assessment response score is the active version.

  • Assessment_Response_Score_raw Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: Date associated with the assessment response score.

  • Assessment_Response_Score_raw Sequence

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Sequence number of the assessment response score.

  • Assessment_Response_Score_raw Source_System_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the source system from where the assessment response score data originated.

  • Assessment_Response_Score_raw Source_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the data was sourced.

  • Assessment_Response_Score_raw Source_File_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the source file from where the assessment response score data was sourced.

  • Assessment_Response_Score_raw Schema_Version

  • Is Nullable: YES

  • Data Type: FLOAT64

  • Description: Version of the schema used for the assessment response score.

  • Assessment_Response_Score_raw Member_Partition

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Partition identifier for the member.

  • Assessment_Response_Score_raw _updated

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Timestamp indicating the last update of the record.

  • Assessment_Response_Score_raw Transaction_Actor_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of the actor performing the transaction.

Assessment Template Block

Columns and Descriptions

  • Assessment_Template_Block_raw Version_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for the version of the assessment template block.

  • Assessment_Template_Block_raw Block_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for the block.

  • Block_Custom_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Custom code associated with the block.

  • Assessment_Template_Block_raw Correlation_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Correlation identifier for the block.

  • Assessment_Template_Block_raw Version_Number

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Version number of the block.

  • Assessment_Template_Block_raw Reference

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Reference information for the block.

  • Assessment_Template_Block_raw Block_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the block.

  • Assessment_Template_Block_raw Status

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Status of the block.

  • Assessment_Template_Block_raw Status_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the block status.

  • Assessment_Template_Block_raw Location_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for the location associated with the block.

  • Assessment_Template_Block_raw Location_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the location associated with the block.

  • Assessment_Template_Block_raw Location_Path

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Path of the location associated with the block.

  • Assessment_Template_Block_raw Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier of the user who created the block.

  • Assessment_Template_Block_raw Reusable

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates whether the block is reusable.

  • Assessment_Template_Block_raw Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the block was created.

  • Assessment_Template_Block_raw Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the block was last modified.

Questions

Columns and Descriptions

  • Questions.Template_Question_Key

  • Is Nullable: NO

  • Data Type: INT64

  • Description: Unique identifier for the template question.

  • Questions.Position

  • Is Nullable: NO

  • Data Type: INT64

  • Description: Position of the question within the block.

  • Questions.Question

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Text of the question.

  • Questions.Question_Type

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Type of the question.

  • Questions.Question_Type_Description

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Description of the question type.

  • Questions.Reference

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Reference information for the question.

  • Questions.Question_ID

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Unique identifier for the question.

  • Questions.Responses.Response_Custom_Code

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Custom code associated with the response.

  • Questions.Required

  • Is Nullable: NO

  • Data Type: BOOL

  • Description: Indicates whether the question is required.

  • Questions.Version_Number

  • Is Nullable: NO

  • Data Type: INT64

  • Description: Version number of the question.

  • Questions.Created_Timestamp

  • Is Nullable: NO

  • Data Type: TIMESTAMP

  • Description: Timestamp when the question was created.

  • Questions.Last_Modified_Timestamp

  • Is Nullable: NO

  • Data Type: TIMESTAMP

  • Description: Timestamp when the question was last modified.

Responses

Columns and Descriptions

  • Questions.Responses.Response_Template_Key

  • Is Nullable: NO

  • Data Type: INT64

  • Description: Unique identifier for the response template.

  • Questions.Responses.Position

  • Is Nullable: NO

  • Data Type: INT64

  • Description: Position of the response within the question.

  • Questions.Responses.Value

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Value of the response.

  • Questions.Responses.Value_Code

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Code representing the value of the response.

  • Questions.Responses.Weight

  • Is Nullable: NO

  • Data Type: INT64

  • Description: Weight assigned to the response.

  • Questions.Responses.Created_Timestamp

  • Is Nullable: NO

  • Data Type: TIMESTAMP

  • Description: Timestamp when the response was created.

  • Questions.Responses.Last_Modified_Timestamp

  • Is Nullable: NO

  • Data Type: TIMESTAMP

  • Description: Timestamp when the response was last modified.

Problems

Columns and Descriptions

  • Questions.Responses.Problems.Code

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Code representing the problem.

  • Questions.Responses.Problems.Description

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Description of the problem.

  • Questions.Responses.Problems.Created_Timestamp

  • Is Nullable: NO

  • Data Type: TIMESTAMP

  • Description: Timestamp when the problem was created.

  • Questions.Responses.Problems.Last_Modified_Timestamp

  • Is Nullable: NO

  • Data Type: TIMESTAMP

  • Description: Timestamp when the problem was last modified.

Tasks

Columns and Descriptions

  • Questions.Responses.TasksKey

  • Is Nullable: NO

  • Data Type: INT64

  • Description: Unique identifier for the task.

  • Questions.Responses.TasksData

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Data associated with the task.

  • Questions.Responses.TasksAdditional_Action

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Additional action associated with the task.

  • Questions.Responses.TasksAdditional_Action_Description

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Description of the additional action.

  • Questions.Responses.TasksCreated_Timestamp

  • Is Nullable: NO

  • Data Type: TIMESTAMP

  • Description: Timestamp when the task was created.

  • Questions.Responses.TasksLast_Modified_Timestamp

  • Is Nullable: NO

  • Data Type: TIMESTAMP

  • Description: Timestamp when the task was last modified.

Notifications

Columns and Descriptions

  • Questions.Responses.Notifications.Key

  • Is Nullable: NO

  • Data Type: INT64

  • Description: Unique identifier for the notification.

  • Questions.Responses.Notifications.Data

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Data associated with the notification.

Assessment Dataset Specification

Notifications

Created Timestamp

  • Field Name: Created_Timestamp

  • Type: NO TIMESTAMP

  • Description: Timestamp when the notification was created.

Last Modified Timestamp

  • Field Name: Last_Modified_Timestamp

  • Type: NO TIMESTAMP

  • Description: Timestamp when the notification was last modified.

Auto Workflows

Auto Workflows Array

  • Field Name: Auto_Workflows

  • Type: NO ARRAY

  • Description: Array of automated workflows associated with the response.

Workflow Key

  • Field Name: Key

  • Type: NO INT64

  • Description: Unique identifier for the automated workflow.

Workflow Data

  • Field Name: Data

  • Type: NO STRING

  • Description: Data associated with the automated workflow.

Created Timestamp

  • Field Name: Created_Timestamp

  • Type: NO TIMESTAMP

  • Description: Timestamp when the automated workflow was created.

Last Modified Timestamp

  • Field Name: Last_Modified_Timestamp

  • Type: NO TIMESTAMP

  • Description: Timestamp when the automated workflow was last modified.

Assessment Template Block Raw

Scores

Scores Array

  • Field Name: Scores

  • Type: NO ARRAY

  • Description: A collection of scoring information for the assessment template.

Template Score Key

  • Field Name: Template_Score_Key

  • Type: NO STRING

  • Description: Unique identifier for a specific score within the template.

Score Name

  • Field Name: Score_Name

  • Type: NO STRING

  • Description: The name or label given to the score.

Reference

  • Field Name: Reference

  • Type: NO STRING

  • Description: A reference or citation related to the score.

Score ID

  • Field Name: Score_ID

  • Type: NO STRING

  • Description: An identifier for the score, possibly used in the system.

Score Custom Code

  • Field Name: Score_Custom_Code

  • Type: NO STRING

  • Description: A custom code assigned to the score for easy reference.

Formula

  • Field Name: Formula

  • Type: NO STRING

  • Description: The mathematical or logical expression used to calculate the score.

Formula Description

  • Field Name: Formula_Description

  • Type: NO STRING

  • Description: A detailed explanation of how the formula works or what it represents.

Parent Questions

Parent Questions Array

  • Field Name: Parent_Questions

  • Type: NO ARRAY

  • Description: A collection of questions that contribute to or influence the score.

Template Question Key

  • Field Name: Template_Question_Key

  • Type: NO STRING

  • Description: Unique identifier for a specific question within the template.

Question ID

  • Field Name: Question_ID

  • Type: NO STRING

  • Description: An identifier for the question, possibly used in the system.

Question Custom Code

  • Field Name: Question_Custom_Code

  • Type: NO STRING

  • Description: A custom code assigned to the question for easy reference.

Version Number

  • Field Name: Version_Number

  • Type: NO INT64

  • Description: The version number of the question, indicating revisions or updates.

Formula Parameter

  • Field Name: Formula_Parameter

  • Type: NO STRING

  • Description: The parameter used in the score formula related to this question.

Created Timestamp

  • Field Name: Created_Timestamp

  • Type: NO TIMESTAMP

  • Description: Timestamp indicating when the question was created.

Last Modified Timestamp

  • Field Name: Last_Modified_Timestamp

  • Type: NO TIMESTAMP

  • Description: Timestamp indicating when the question was last modified.

Evaluations

Evaluations Array

  • Field Name: Evaluations

  • Type: NO ARRAY

  • Description: A collection of evaluation criteria for the score.

Template Evaluation Key

  • Field Name: Template_Evaluation_Key

  • Type: NO STRING

  • Description: Unique identifier for a specific evaluation within the template.

Evaluation Custom Code

  • Field Name: Evaluation_Custom_Code

  • Type: NO STRING

  • Description: A custom code assigned to the evaluation for easy reference.

Position

  • Field Name: Position

  • Type: NO INT64

  • Description: The position or order of the evaluation in the list.

Minimum Value

  • Field Name: Minimum_Value

  • Type: NO NUMERIC

  • Description: The lowest possible value for this evaluation range.

Maximum Value

  • Field Name: Maximum_Value

  • Type: NO NUMERIC

  • Description: The highest possible value for this evaluation range.

Description

  • Field Name: Description

  • Type: NO STRING

  • Description: A detailed explanation of what this evaluation range represents.

Child Template Question Keys

  • Field Name: Child_Template_Question_Keys

  • Type: NO ARRAY

  • Description: A list of question keys that are relevant to this evaluation.

Problems

Problems Array

  • Field Name: Problems

  • Type: NO ARRAY

  • Description: A collection of potential problems associated with this evaluation range.

Problem Code

  • Field Name: Code

  • Type: NO STRING

  • Description: A code or identifier for a specific problem.

Problem Description

  • Field Name: Description

  • Type: NO STRING

  • Description: A detailed explanation of the problem.

Tasks

Tasks Array

  • Field Name: Tasks

  • Type: NO ARRAY

  • Description: A collection of tasks associated with this evaluation range.

Task Key

  • Field Name: Key

  • Type: NO STRING

  • Description: Unique identifier for a specific task.

Priority

  • Field Name: Priority

  • Type: NO STRING

  • Description: The priority level assigned to the task.

Priority Description

  • Field Name: Priority_Description

  • Type: NO STRING

  • Description: A description of what the priority level means.

Reason

  • Field Name: Reason

  • Type: NO STRING

  • Description: The reason for assigning this task.

Reason Description

  • Field Name: Reason_Description

  • Type: NO STRING

  • Description: A detailed explanation of the reason for the task.

Type

  • Field Name: Type

  • Type: NO STRING

  • Description: The type or category of the task.

Type Description

  • Field Name: Type_Description

  • Type: NO STRING

  • Description: A description of what the task type means.

Additional Action

  • Field Name: Additional_Action

  • Type: NO STRING

  • Description: Any additional action required for the task.

Additional Action Description

  • Field Name: Additional_Action_Description

  • Type: NO STRING

  • Description: A detailed explanation of the additional action.

Notifications

Notifications Array

  • Field Name: Notifications

  • Type: NO ARRAY

  • Description: A collection of notifications associated with this evaluation range.

Notification Key

  • Field Name: Key

  • Type: NO STRING

  • Description: Unique identifier for a specific notification.

Urgent

  • Field Name: Urgent

  • Type: NO BOOL

  • Description: A boolean indicating if the notification is urgent.

Text

  • Field Name: Text

  • Type: NO STRING

  • Description: The content of the notification message.

Title

  • Field Name: Title

  • Type: NO STRING

  • Description: The title or subject of the notification.

Auto Workflows

Auto Workflows Array

  • Field Name: Auto_Workflows

  • Type: NO ARRAY

  • Description: A collection of automated workflows associated with this evaluation range.

Workflow Key

  • Field Name: Key

  • Type: NO STRING

  • Description: Unique identifier for a specific workflow.

Rule Code

  • Field Name: Rule_Code

  • Type: NO STRING

  • Description: A code representing the rule that triggers the workflow.

Rule Name

  • Field Name: Rule_Name

  • Type: NO STRING

  • Description: The name of the rule that triggers the workflow.

Position

  • Field Name: Position

  • Type: NO STRING

  • Description: The position or order of the score within the block or template.

Record Last Modified Timestamp

  • Field Name: Record_Last_Modified_Timestamp

  • Type: YES TIMESTAMP

  • Description: Timestamp when the record was last modified.

Transaction User ID

  • Field Name: Transaction_User_ID

  • Type: YES STRING

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

Deleted Indicator

  • Field Name: Deleted_Indicator

  • Type: YES BOOL

  • Description: Indicator whether the block is deleted.

Type

  • Field Name: Type

  • Type: YES STRING

  • Description: Type of the block.

Tenant

  • Field Name: Tenant

  • Type: YES STRING

  • Description: Tenant associated with the block.

Active Version

  • Field Name: Active_Version

  • Type: YES BOOL

  • Description: Indicates if the block is the active version.

Assessment Dataset Specification

Assessment Template Block

Columns and Descriptions

  • Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: Date associated with the block.

  • Sequence

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Sequence number of the block.

  • Source_System_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the source system from where the block data originated.

  • Source_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the data was sourced.

  • Source_File_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the source file from where the block data was sourced.

  • Schema_Version

  • Is Nullable: YES

  • Data Type: FLOAT64

  • Description: Version of the schema used for the block.

  • _updated

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Timestamp indicating the last update of the record.

  • Transaction_Actor_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of the actor performing the transaction.

Assessment Template

Columns and Descriptions

  • Version_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for the version of the assessment template.

  • Assessment_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for the assessment.

  • Assessment_Custom_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Custom code associated with the assessment.

  • Correlation_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Correlation identifier for the assessment.

  • Version_Number

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Version number of the assessment.

  • Reference

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Reference information for the assessment.

  • Assessment_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the assessment.

  • Assessment_Alias

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Alias of the assessment.

  • Status

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Status of the assessment.

  • Status_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the assessment status.

  • Location_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for the location associated with the assessment.

  • Location_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the location associated with the assessment.

  • Location_Path

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Path of the location associated with the assessment.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier of the user who created the assessment.

  • Logic_Applied

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates whether logic is applied in the assessment.

  • Scoring_Applied

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates whether scoring is applied in the assessment.

  • Published

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates whether the assessment is published.

  • Tags

  • Is Nullable: NO

  • Data Type: ARRAY

  • Description: Array of tags associated with the assessment.

  • Tags.Key

    • Is Nullable: NO

    • Data Type: INT64

    • Description: Unique identifier for the tag.

  • Tags.Name

    • Is Nullable: NO

    • Data Type: STRING

    • Description: Name of the tag.

  • Types.Configs

  • Is Nullable: NO

  • Data Type: ARRAY

  • Description: A collection or array of configuration settings for different types within the system.

  • Types.Configs.Config_Key

    • Is Nullable: NO

    • Data Type: STRING

    • Description: A unique identifier for each configuration setting, used to reference specific configurations.

  • Types.Configs.Config_Code

    • Is Nullable: NO

    • Data Type: STRING

    • Description: A short code or abbreviation representing the configuration, often used for quick reference or in system processes.

  • Types.Configs.Config_Description

    • Is Nullable: NO

    • Data Type: STRING

    • Description: A detailed explanation or description of what the configuration setting does or represents.

  • Types.Configs.Config_Values

    • Is Nullable: NO

    • Data Type: ARRAY

    • Description: The possible values or options that can be set for this particular configuration.

  • Blocks

  • Is Nullable: NO

  • Data Type: ARRAY

  • Description: Array of blocks associated with the assessment.

  • Blocks.Position

    • Is Nullable: NO

    • Data Type: INT64

    • Description: Position of the block within the assessment.

  • Blocks.Version_Key

    • Is Nullable: NO

    • Data Type: INT64

    • Description: Unique identifier for the version of the block.

  • Blocks.Block_ID

    • Is Nullable: NO

    • Data Type: STRING

    • Description: Unique identifier for the block.

  • Blocks.Correlation_ID

    • Is Nullable: NO

    • Data Type: STRING

    • Description: Correlation identifier for the block.

  • Blocks.Version_Number

    • Is Nullable: NO

    • Data Type: INT64

    • Description: Version number of the block.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the assessment was created.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the assessment was last modified.

  • Record_Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the record was last modified.

  • Transaction_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Deleted_Indicator

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicator whether the assessment is deleted.

  • Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of the assessment.

  • Tenant

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Tenant associated with the assessment.

  • Active_Version

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates if the assessment is the active version.

  • Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: Date associated with the assessment.

  • Sequence

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Sequence number associated with the assessment.

  • Source_System_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the source system.

  • Source_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp of the source system.

  • Source_File_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the source file.

  • Schema_Version

  • Is Nullable: YES

  • Data Type: FLOAT64

  • Description: Version of the schema.

  • _updated

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Timestamp of the last update.

  • Transaction_Actor_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of the actor performing the transaction.

Assessment Response

Features and Descriptions

  • Assessment Response

  • Stores detailed records of patient responses to specific assessment questions, capturing critical data points used for clinical evaluation and treatment decisions.

  • Assessment Response Additional Actions

  • Contains information on additional actions triggered based on the responses, such as follow-up assessments, referrals, or interventions, ensuring that care is delivered promptly.

  • Assessment Response Auto Workflows

  • Tracks automated workflows that are triggered by specific assessment responses, streamlining follow-up actions and care pathways based on predefined criteria.

  • Assessment Response Question Related Assessment Response Score Keys

  • Links responses to their respective scores, helping healthcare providers quickly assess and quantify patient conditions or progress.

  • Assessment Response Question Selected Response Child Assessment Response Question

  • Captures selected responses and their relationships to child assessment questions, enabling deeper analysis and follow-up actions.

Assessment Dataset Specification

Keys

  • Tracks child questions triggered based on selected responses, allowing for dynamic assessments that adapt to patient needs.

Assessment Response Score

Matched Evaluation Child Assessment Response Questions

  • Documents the relationship between child assessment questions and corresponding scores, ensuring comprehensive evaluation.

Parent Assessment Response Questions

  • Links parent assessment questions to related scores, helping to contextualize the scoring process and improve the accuracy of patient assessments.

Assessment Response Question

  • Captures detailed information about each question in an assessment, ensuring consistency and standardization across patient evaluations.

Assessment Template

Assessment Template Block Question Response Auto Workflows

  • Tracks automatic workflows initiated based on specific responses within template blocks, enabling efficient care management and follow-up actions.

Assessment Template Block Question Response Child Template Question Keys

  • Links template block questions to corresponding child questions, supporting dynamic and adaptable assessments.

Assessment Template Block Question Response Notifications

  • Manages notifications triggered by responses to template block questions, ensuring that relevant stakeholders are alerted to critical patient data or actions required.

Assessment Template Block Question Response Problems

  • Tracks clinical problems or issues identified based on responses to template block questions, facilitating timely intervention.

Assessment Template Block Question Response Tasks

  • Stores tasks that are generated from responses, ensuring that care teams are assigned necessary follow-up actions.

Assessment Template Block Question Responses

  • Stores responses specifically related to questions within assessment template blocks, ensuring comprehensive data capture.

Assessment Template Block Details

  • Contains metadata and structural details for each assessment template block, supporting the organization and segmentation of assessments.

Assessment Template Block Questions

  • Documents the questions within specific blocks of the assessment templates, providing logical groupings for related queries.

Assessment Template Block Scores

  • Tracks scoring information related to specific assessment template blocks, helping to evaluate patient conditions in a structured manner.

Assessment Template Blocks

  • Represents different sections or blocks within an assessment template, each containing related questions and scoring mechanisms.

Assessment Template Block Score Evaluation Auto Workflows

  • Initiates workflows based on the evaluation of scores within template blocks, ensuring automated follow-up actions when certain criteria are met.

Assessment Template Block Score Evaluation Notifications

  • Tracks notifications triggered by the evaluation of scores within template blocks, ensuring prompt communication to care teams or patients.

Assessment Template Block Score Evaluation Problems

  • Documents clinical problems identified through the evaluation of block scores, enabling healthcare providers to act quickly on critical patient data.

Assessment Template Block Score Evaluation Tasks

  • Captures tasks initiated by block score evaluations, ensuring that necessary follow-up actions are assigned and tracked.

Assessment Template Block Score Evaluations

  • Contains overall evaluations of scores within template blocks, providing a holistic view of patient assessments.

Assessment Template Block Score Parent Questions

  • Links parent questions to scores within template blocks, enabling a structured assessment of patient responses and conditions.

Assessment Template Tags

  • Stores metadata tags associated with assessment templates, helping healthcare providers categorize and retrieve relevant templates quickly.

Assessment Template Type Programs

  • Links assessment templates to specific healthcare programs, ensuring that relevant assessments are available for targeted care initiatives.

Assessment Template Types

  • Categorizes assessment templates by type, enabling healthcare organizations to standardize assessments for different clinical purposes or patient groups.

Assessment Response Score

  • Records the calculated scores from patient responses, providing quantitative data used to assess health conditions, monitor progress, and support clinical decision-making.

Assessment Template Block

  • Documents the sections or blocks of the assessment template, helping to structure the assessment and organize related questions and scores.

Notification

  • Manages notifications triggered by various assessment activities, ensuring that relevant stakeholders (e.g., healthcare providers, patients) are alerted to important updates or follow-ups.

Assessment Notes

  • Allows clinicians to document additional notes or observations during the assessment process, providing a qualitative complement to structured data.

Assessment Response Log

  • Tracks any updates or changes made to assessment responses, ensuring a complete audit trail for regulatory compliance and data integrity.

Assessment Response Question Log

  • Maintains a history of modifications to assessment questions, ensuring that all changes are properly documented and can be reviewed if needed.

Assessment Response Score Log

  • Logs changes to assessment scores, ensuring transparency and accountability in the scoring process.

Assessment Template Block Log

  • Records changes made to assessment template blocks, ensuring that updates to assessment structures are traceable.

Assessment Template Log

  • Maintains a detailed record of updates or changes to assessment templates, ensuring compliance with healthcare standards for version control and template management.

Assessment Response Raw

  • Contains unprocessed data related to patient responses, supporting further analysis and processing.

Assessment Dataset Specification

Overview

The assessment dataset provides a comprehensive source for in-depth analysis, audits, or research. It includes various raw data components to ensure the integrity and granularity of assessment-related information.

Key Components

  • Assessment Response Question Raw: Stores raw data related to assessment questions, ensuring that original question formats and content are preserved for analysis and validation.

  • Assessment Response Score Raw: Contains raw, unprocessed scoring data, providing a foundational dataset for detailed reporting and evaluation.

  • Assessment Template Block Raw: Captures unprocessed data related to assessment template blocks, allowing for granular analysis and review of assessment structures.

  • Assessment Template Raw: Stores unprocessed data related to assessment templates, ensuring that the complete structure and content of assessments can be analyzed in their original form.

Table Specifications

Assessment_Response

Column Name

Is Nullable

Data Type

Description

Assessment_Response_Key

YES

STRING

Unique identifier for a specific assessment response.

Assessment_Response_ID

YES

STRING

System-generated ID for the assessment response.

Member_ID

YES

STRING

Unique identifier for the member/patient.

Assessment_Version_Key

YES

INT64

Unique identifier for the specific version of the assessment.

Assessment_ID

YES

STRING

System-generated ID for the assessment.

Assessment_Version_Custom_Code

YES

STRING

Custom code assigned to the assessment version.

Assessment_Custom_Code

YES

STRING

Custom code assigned to the assessment.

Assessment_Version_Name

YES

STRING

Name of the specific version of the assessment.

Assessment_Name

YES

STRING

Name of the assessment.

Assessment_Correlation_ID

YES

STRING

Correlation ID for linking related assessments.

Assessment_Version_Number

YES

INT64

Version number of the assessment.

Assessment_Reference

YES

STRING

Reference information for the assessment.

Assessment_Type

YES

STRING

Type or category of the assessment.

Assessment_Type_Description

YES

STRING

Detailed description of the assessment type.

Domain

YES

STRING

The domain or area of healthcare the assessment belongs to.

Program_Screening_Key

YES

INT64

Unique identifier for the program screening.

Program_ID

YES

STRING

System-generated ID for the program.

Program

YES

STRING

Name of the program.

Program_Description

YES

STRING

Detailed description of the program.

Request_Key

YES

INT64

Unique identifier for the assessment request.

Request_ID

YES

STRING

System-generated ID for the request.

Digital

YES

BOOL

Boolean indicating if the assessment is digital or not.

Status

YES

STRING

Current status of the assessment response.

Status_Description

YES

STRING

Detailed description of the status.

Source

YES

STRING

Source of the assessment response.

Source_Description

YES

STRING

Detailed description of the source.

Created_Timestamp

YES

TIMESTAMP

Timestamp of when the assessment response was created.

Answered_By_Member

YES

STRING

Member who answered the assessment.

Last_Answered_By_User_ID

YES

STRING

User ID of the person who last answered or modified the assessment.

Last_Answered_By_User_Name

YES

STRING

Name of the person who last answered or modified the assessment.

Last_Modified_Timestamp

YES

TIMESTAMP

Timestamp of when the assessment response was last modified.

First

YES

BOOL

Boolean indicating if this is the first response for this assessment.

Latest

YES

BOOL

Boolean indicating if this is the latest response for this assessment.

First_Completed

YES

BOOL

Boolean indicating if this is the first completed response for this assessment.

Latest_Completed

YES

BOOL

Boolean indicating if this is the latest completed response for this assessment.

Assessment_Response_Additional_Actions

Column Name

Is Nullable

Data Type

Description

Assessment_Response_Key

YES

STRING

The unique key identifying the associated assessment response.

Code

YES

STRING

The code representing the specific additional action to be taken in relation to the response.

Description

YES

STRING

A detailed description of the additional action related to the assessment response.

Assessment_Response_Auto_Workflows

Column Name

Is Nullable

Data Type

Description

Assessment_Response_Key

YES

STRING

The unique key identifying the associated assessment response.

Rule

YES

STRING

The rule or criteria that triggers the automatic workflow for the assessment response.

Created_Timestamp

YES

TIMESTAMP

The timestamp indicating when the auto workflow was created for the assessment response.

Assessment_Response_Notes

Column Name

Is Nullable

Data Type

Description

Note_Key

YES

STRING

A unique identifier for the note entry.

Assessment_Response_ID

YES

STRING

System-generated ID for the assessment response.

Assessment Dataset Specification

Assessment Response Notes

Columns

  • RING

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier of the assessment response this note is associated with.

  • Text

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The content of the note.

  • Author_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The user ID of the person who authored the note.

  • Author_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name of the person who authored the note.

  • Void_Indicator

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: An indicator showing whether the note has been voided or nullified.

  • Void_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when the note was voided, if applicable.

  • Void_Reason

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The reason code for voiding the note, if applicable.

  • 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 user ID of the person who voided the note, if applicable.

  • Void_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name of the person who voided the note, if applicable.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when the note was created.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when the note was last modified.

Columns

  • Assessment_Response_Question_Key

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for the specific question within the assessment response.

  • Related_Assessment_Response_Score_Key

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the score that is related to the specific assessment response question.

Assessment Response Question Selected Response Child Assessment Response Question Keys

Columns

  • Assessment_Response_Question_Key

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for the specific question within the assessment response.

  • Selected_Response_Template_Key

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the template of the selected response associated with the assessment question.

  • Child_Assessment_Response_Question_Key

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the child assessment response question related to the selected response of the parent question.

Assessment Response Score Matched Evaluation Child Assessment Response Questions

Columns

  • Assessment_Response_Score_Key

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for the specific score within the assessment response.

  • Matched_Evaluation_Template_Evaluation_Key

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the matched evaluation template associated with the assessment response score.

  • Child_Assessment_Response_Question_Key

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the child assessment response question related to the matched evaluation.

  • Child_Assessment_Response_Question_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the child assessment response question in the matched evaluation process.

Assessment Response Score Parent Assessment Response Questions

Columns

  • Assessment_Response_Score_Key

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for the specific score within the assessment response.

  • Parent_Assessment_Response_Question_Key

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for the parent assessment response question associated with the score.

  • Parent_Assessment_Response_Question_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the parent assessment response question within the system.

  • Parent_Assessment_Response_Formula_Parameter

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Parameter used in the formula associated with the parent assessment response question.

Assessment Response Question

Columns

  • Assessment_Response_Question_Key

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique identifier for the specific assessment response question.

  • Assessment_Response_Question_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier of the question within the response, enabling tracking of individual question responses.

  • Assessment_Response_Key

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Key linking to the parent assessment response.

  • Assessment_Response_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier of the response this question is associated with.

  • Member_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for the member who provided the response.

  • Assessment_Version_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Key referring to the specific version of the assessment.

  • Template_Question_Key

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Key linking to the template question within the assessment.

  • Question_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the question being responded to, ensuring consistency in question tracking.

  • Question_Version_Custom_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A custom code representing the specific version of the question, used for additional customization or tracking.

Assessment Dataset Specification

Assessment_Response_Question Fields

Block_Version_Custom_Code

  • Required: YES

  • Type: STRING

  • Description: A custom code representing the version of the block to which the question belongs.

Assessment_Version_Custom_Code

  • Required: YES

  • Type: STRING

  • Description: A custom code representing the version of the assessment.

Response_Version_Custom_Code

  • Required: YES

  • Type: STRING

  • Description: A custom code assigned to the version of the response for tracking changes or updates.

Block_Version_Key

  • Required: YES

  • Type: INT64

  • Description: Key for the version of the block to which this question belongs, ensuring accurate versioning.

Block_ID

  • Required: YES

  • Type: STRING

  • Description: Identifier for the block that contains this question.

Block_Version_Number

  • Required: YES

  • Type: INT64

  • Description: Version number of the block containing the question, used to track block updates.

Assessment_ID

  • Required: YES

  • Type: STRING

  • Description: Identifier for the assessment this question belongs to.

Assessment_Version_Number

  • Required: YES

  • Type: INT64

  • Description: Version number of the assessment, ensuring accuracy in assessment version tracking.

Question_Reference

  • Required: YES

  • Type: STRING

  • Description: Reference code for the question, used for additional context or documentation purposes.

Question

  • Required: YES

  • Type: STRING

  • Description: Text of the question being answered, providing the exact prompt posed to the respondent.

Question_Type

  • Required: YES

  • Type: STRING

  • Description: Type of question (e.g., multiple-choice, open-ended), categorizing the question format.

Question_Type_Description

  • Required: YES

  • Type: STRING

  • Description: Description of the question type, explaining the format and requirements of the question.

Question_Version_Name

  • Required: YES

  • Type: STRING

  • Description: Name assigned to the question version, if applicable, for version control purposes.

Question_Name

  • Required: YES

  • Type: STRING

  • Description: Name of the question as listed in the template, providing clarity on question identity.

Position

  • Required: YES

  • Type: INT64

  • Description: Position of the question within the assessment, indicating its sequence order.

Parent_Assessment_Response_Question_Key

  • Required: YES

  • Type: STRING

  • Description: Key for the parent question, if this is a sub-question, facilitating hierarchical question structures.

Parent_Assessment_Response_Question_ID

  • Required: YES

  • Type: STRING

  • Description: Identifier for the parent question, if applicable, allowing linkage to related questions.

Parent_Assessment_Response_Score_Key

  • Required: YES

  • Type: STRING

  • Description: The unique key of the parent question's score, used to link this question's response to a higher-level scoring element in the assessment.

Child_Question_Indicator

  • Required: YES

  • Type: BOOL

  • Description: Indicator specifying if this question is a child of another question.

Answered

  • Required: YES

  • Type: BOOL

  • Description: Indicates whether the question has been answered (TRUE) or left unanswered (FALSE).

Required

  • Required: YES

  • Type: BOOL

  • Description: Indicates if answering the question is mandatory (TRUE) or optional (FALSE).

Source

  • Required: YES

  • Type: STRING

  • Description: Source from which the question or response was obtained, such as system or manual entry.

Source_Description

  • Required: YES

  • Type: STRING

  • Description: Detailed description of the source, providing context for how or where the response was obtained.

Selected_Response_Template_Key

  • Required: YES

  • Type: STRING

  • Description: Key of the selected response from the template, linking to a predefined response.

Selected_Response_Weight

  • Required: YES

  • Type: INT64

  • Description: Weight of the selected response, often used in scoring or evaluations.

Selected_Response_Position

  • Required: YES

  • Type: INT64

  • Description: Position of the selected response in the list of possible answers, aiding in answer order tracking.

Selected_Response_Value_Code

  • Required: YES

  • Type: STRING

  • Description: Code representing the selected response value, allowing for standardized response identification.

Response_Value

  • Required: YES

  • Type: STRING

  • Description: The value provided in response to the question, representing the respondent's answer.

Response_Value_String

  • Required: YES

  • Type: STRING

  • Description: Text value provided as a response, if applicable, allowing for open-ended answers.

Response_Value_Date

  • Required: YES

  • Type: DATE

  • Description: Date value provided as a response, if applicable, for date-specific questions.

Response_Value_Number

  • Required: YES

  • Type: NUMERIC

  • Description: Numeric value provided as a response, if applicable, for questions requiring numerical answers.

Answered_By_User_ID

  • Required: YES

  • Type: STRING

  • Description: Identifier of the user who answered the question.

Answered_By_User_Name

  • Required: YES

  • Type: STRING

  • Description: Name of the user who answered the question.

Answered_By_Member

  • Required: YES

  • Type: BOOL

  • Description: Name of the member who answered the question.

First

  • Required: YES

  • Type: STRING

  • Description: First assessment question response irrespective of status for a member/question combination.

Latest

  • Required: YES

  • Type: STRING

  • Description: Latest assessment question response irrespective of status for a member/question combination.

Created_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp when the response question entry was created, marking the initial record creation.

Last_Modified_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp when the response question entry was last modified, marking updates to the record.

Assessment Dataset Specification

Assessment Template

Table Content

Table Name

Column Name

Is Nullable

Data Type

Description

Assessment_Template

Assessment_Version_Key

YES

INT64

Unique identifier for a specific version of an assessment template.

Assessment_Template

Assessment_ID

YES

STRING

System-generated ID for the assessment.

Assessment_Template

Assessment_Version_Custom_Code

YES

STRING

Custom code assigned to the assessment version.

Assessment_Template

Assessment_Custom_Code

YES

STRING

Custom code assigned to the assessment for easy reference.

Assessment_Template

Assessment_Correlation_ID

YES

STRING

Correlation ID for linking related assessments.

Assessment_Template

Assessment_Version_Number

YES

INT64

Version number of the assessment template.

Assessment_Template

Assessment_Version_Name

YES

STRING

Name of the specific version of the assessment template.

Assessment_Template

Assessment_Name

YES

STRING

Name of the assessment.

Assessment_Template

Assessment_Alias

YES

STRING

Alternative name or shorthand for the assessment.

Assessment_Template

Assessment_Reference

YES

STRING

Reference information or citation for the assessment.

Assessment_Template

Status

YES

STRING

Current status of the assessment template.

Assessment_Template

Status_Description

YES

STRING

Detailed description of the status.

Assessment_Template

Location_Key

YES

INT64

Unique identifier for the location associated with the assessment.

Assessment_Template

Location_Name

YES

STRING

Name of the location associated with the assessment.

Assessment_Template

Location_Path

YES

STRING

Hierarchical path of the location within the organization structure.

Assessment_Template

Logic_Applied

YES

BOOL

Indicates whether logic rules are applied to this assessment template.

Assessment_Template

Scoring_Applied

YES

BOOL

Indicates whether scoring is applied to this assessment template.

Assessment_Template

Published

YES

BOOL

Indicates whether the assessment template has been published.

Assessment_Template

Created_User_ID

YES

STRING

User ID of the person who created the assessment template.

Assessment_Template

Created_User_Name

YES

STRING

Name of the person who created the assessment template.

Assessment_Template

Created_Timestamp

YES

TIMESTAMP

Timestamp of when the assessment template was created.

Assessment_Template

Modified_User_ID

YES

STRING

User ID of the person who last modified the assessment template.

Assessment_Template

Modified_User_Name

YES

STRING

Name of the person who last modified the assessment template.

Assessment_Template

Last_Modified_Timestamp

YES

TIMESTAMP

Timestamp of when the assessment template was last modified.

Assessment_Template

Latest

YES

BOOL

Indicates whether this is the latest version of the assessment template.

Assessment_Template

Latest_Published

YES

BOOL

Indicates whether this is the latest published version of the assessment template.

Assessment Template Block Question Response Auto Workflows

Table Content

Table Name

Column Name

Is Nullable

Data Type

Description

Assessment_Template_Block_Question_Response_Auto_Workflows

Block_Version_Key

YES

INT64

Unique identifier for the version of the block associated with the question response.

Assessment_Template_Block_Question_Response_Auto_Workflows

Template_Question_Key

YES

STRING

Unique identifier for the template question within the block.

Assessment_Template_Block_Question_Response_Auto_Workflows

Response_Template_Key

YES

STRING

Unique identifier for the response template associated with the question.

Assessment_Template_Block_Question_Response_Auto_Workflows

Auto_Workflow_Key

YES

STRING

Unique key identifying the automatic workflow triggered by the question response.

Assessment_Template_Block_Question_Response_Auto_Workflows

Rule_Code

YES

STRING

Code of the rule applied in the auto workflow associated with the response.

Assessment_Template_Block_Question_Response_Auto_Workflows

Rule_Name

YES

STRING

Name of the rule applied in the automatic workflow.

Assessment Template Block Question Response Child Template Question Keys

Table Content

Table Name

Column Name

Is Nullable

Data Type

Description

Assessment_Template_Block_Question_Response_Child_Template_Question_Keys

Block_Version_Key

YES

INT64

Unique identifier for the version of the block associated with the question response.

Assessment_Template_Block_Question_Response_Child_Template_Question_Keys

Template_Question_Key

YES

STRING

Unique identifier for the template question within the block.

Assessment_Template_Block_Question_Response_Child_Template_Question_Keys

Response_Template_Key

YES

STRING

Unique identifier for the response template associated with the parent question.

Assessment_Template_Block_Question_Response_Child_Template_Question_Keys

Child_Template_Question_Key

YES

STRING

Unique identifier for the child template question triggered by the parent question response.

Assessment Template Block Question Response Notifications

Table Content

Table Name

Column Name

Is Nullable

Data Type

Description

Assessment_Template_Block_Question_Response_Notifications

Block_Version_Key

YES

INT64

Unique identifier for the version of the block associated with the question response.

Assessment_Template_Block_Question_Response_Notifications

Template_Question_Key

YES

STRING

Unique identifier for the template question within the block.

Assessment_Template_Block_Question_Response_Notifications

Response_Template_Key

YES

STRING

Unique identifier for the response template associated with the parent question.

Assessment_Template_Block_Question_Response_Notifications

Notification_Key

YES

STRING

Unique identifier for the notification triggered by the question response.

Assessment Dataset Specification

Question Response Notifications

Column Name

Is Nullable

Data Type

Description

Urgent

YES

BOOL

Indicates whether the notification is marked as urgent.

Text

YES

STRING

The text content of the notification associated with the question response.

Title

YES

STRING

The title of the notification associated with the question response.

Assessment Template Block Question Response Problems

Column Name

Is Nullable

Data Type

Description

Block_Version_Key

YES

INT64

Unique identifier for the version of the block associated with the question response.

Template_Question_Key

YES

STRING

Unique identifier for the template question within the block.

Response_Template_Key

YES

STRING

Unique identifier for the response template associated with the question.

Problem

YES

STRING

Identifies the problem encountered in the question response.

Problem_Description

YES

STRING

A detailed description of the problem encountered during the question response process.

Assessment Template Block Question Response Tasks

Column Name

Is Nullable

Data Type

Description

Block_Version_Key

YES

INT64

Identifies the version of the block that contains the question response task.

Template_Question_Key

YES

STRING

Unique identifier for the template question related to the task.

Response_Template_Key

YES

STRING

Unique identifier for the response template associated with the task.

Task_Key

YES

STRING

Unique identifier for the specific task linked to the question response.

Task_Priority

YES

STRING

Specifies the priority level of the task, indicating its importance.

Task_Priority_Description

YES

STRING

Describes the priority level of the task in more detail.

Task_Reason

YES

STRING

Provides the reason for creating or assigning the task.

Task_Reason_Description

YES

STRING

Describes the reason for the task in more detail.

Task_Type

YES

STRING

Specifies the type of task that is required as part of the question response.

Task_Type_Description

YES

STRING

Provides a detailed description of the task type.

Additional_Action

YES

STRING

Indicates any additional actions that need to be performed as part of the task.

Additional_Action_Description

YES

STRING

Describes the additional actions in more detail.

Assessment Template Block Question Responses

Column Name

Is Nullable

Data Type

Description

Block_Version_Key

YES

INT64

Unique identifier for the version of the block containing the question responses.

Template_Question_Key

YES

STRING

Unique identifier for the template question related to the responses.

Response_Template_Key

YES

STRING

Unique identifier for the specific response template associated with the question.

Position

YES

INT64

Specifies the position or order of the response within the set of possible responses.

Value

YES

STRING

The value of the response provided for the associated question.

Value_Code

YES

STRING

The code associated with the response value, used for categorization or analysis purposes.

Weight

YES

INT64

The weight or score assigned to the response, which may impact overall scoring or evaluation outcomes.

Response_Custom_Code

YES

STRING

Custom code associated with the response.

Assessment Template Block Details

Column Name

Is Nullable

Data Type

Description

Block_Version_Key

YES

INT64

A unique key representing the specific version of the assessment block.

Block_ID

YES

STRING

The unique identifier for the assessment block.

Block_Correlation_ID

YES

STRING

An identifier used to correlate related blocks within the assessment for tracking and analysis.

Block_Version_Number

YES

INT64

The version number of the assessment block, indicating updates or revisions.

Block_Name

YES

STRING

The name of the assessment block, providing a descriptive label for the block's content or purpose.

Block_Reference

YES

STRING

Reference information related to the assessment block, aiding in contextual understanding.

Status

YES

STRING

The current status of the assessment block, such as 'Active' or 'Inactive'.

Block_Version_Name

YES

STRING

The name assigned to the specific version of the block, if applicable.

Assessment Dataset Specification

Assessment Template Block Details

Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier of the user who last modified the assessment block.

Modified_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the user who last modified the assessment block, offering traceability.

Status_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of the current status of the assessment block, clarifying its usage state.

Location_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: A key representing the specific location associated with the assessment block, useful for organizational purposes.

Location_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name of the location where the block is used or stored, such as a department or facility.

Location_Path

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The hierarchical path or structure of the location, providing a clear view of its placement within the system.

Block_Reusable

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates whether the block can be reused in different assessments, enhancing flexibility.

Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier of the user who originally created the assessment block.

Created_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name of the user who created the assessment block, offering traceability for the initial setup.

Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when the assessment block was first created, marking its entry into the system.

Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp of the last modification made to the assessment block, indicating recent updates.

Assessment Template Block Questions

Block_Version_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: A unique key representing the version of the assessment block containing the questions. This key is used to track changes and updates to the block over time.

Block_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier for the assessment block.

Block_Correlation_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: An identifier used to correlate related blocks within the assessment, facilitating grouping and analysis of similar blocks.

Block_Version_Number

  • Is Nullable: YES

  • Data Type: INT64

  • Description: The version number of the assessment block, indicating the iteration of the block for version control purposes.

Block_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name of the assessment block that contains the questions, providing a descriptive label for the block's content.

Block_Reference

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Reference information related to the assessment block, providing additional context or linkage to other documentation.

Status

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The current status of the assessment block, such as 'Active', 'Inactive', or 'Archived'.

Status_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of the status of the assessment block, explaining its current state and usage.

Block_Version_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name assigned to the specific version of the block, providing a descriptive label for the version.

Question_Version_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name assigned to the specific version of the question within the block, providing clarity on the question's iteration.

Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier of the user who last modified the assessment block or its questions.

Modified_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the user who last modified the assessment block or its questions, ensuring traceability of changes.

Location_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: A key representing the location associated with the block, useful for organizational purposes.

Location_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name of the location where the block is used or stored, such as a department or facility.

Location_Path

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The hierarchical path or structure of the location, providing context on its placement within the system.

Block_Reusable

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates whether the block can be reused in other assessments (TRUE) or is unique to a specific assessment (FALSE).

Template_Question_Key

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique key representing the template question within the block, used for identification and tracking.

Question_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier for the question within the block, ensuring consistency across assessments.

Question_Version_Custom_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Custom code assigned to the question version.

Question_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name of the question as it appears in the template block, providing a clear prompt for respondents.

Question_Reference

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A reference used to identify the question within the block, such as a code or label for cross-referencing.

Question_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The type of the question (e.g., multiple choice, free text), indicating the expected response format.

Question_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of the question type, explaining how respondents should provide their answers.

Assessment Dataset Specification

Assessment Template Block Questions

Question_Position

  • Is Nullable: YES

  • Data Type: INT64

  • Description: The position of the question within the block, indicating its sequence in the assessment.

Question_Required

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates whether answering the question is mandatory (TRUE) or optional (FALSE).

Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier of the user who created the question, providing accountability for content creation.

Created_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name of the user who created the question, offering transparency in authorship.

Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when the question was created, marking its entry into the system.

Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp of the last modification made to the question, indicating recent updates or changes.

Assessment Template Block Scores

Block_Version_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: A unique key representing the version of the assessment block that includes the scores. This key is used to track changes and updates to the block over time.

Block_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier for the assessment block.

Block_Correlation_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: An identifier used to correlate related blocks within the assessment, facilitating grouping and analysis of similar blocks.

Block_Version_Number

  • Is Nullable: YES

  • Data Type: INT64

  • Description: The version number of the assessment block, indicating the iteration of the block for version control purposes.

Block_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name of the assessment block containing the scores, providing a descriptive label for the block's content.

Block_Reference

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Reference information related to the assessment block, providing additional context or linkage to other documentation.

Status

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The current status of the assessment block, such as Active, Inactive, or Archived.

Status_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of the status of the assessment block, explaining its current state and usage.

Block_Version_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name assigned to the specific version of the block, providing a descriptive label for the version.

Score_Version_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name assigned to the specific version of the score within the block, aiding in version control and identification.

Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier of the user who last modified the assessment block or its scores, ensuring accountability and traceability.

Modified_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name of the user who last modified the assessment block or its scores, offering transparency in changes made.

Location_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: A key representing the location associated with the block, useful for organizational purposes.

Location_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name of the location where the block is used or stored, such as a department or facility.

Location_Path

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The hierarchical path or structure of the location, providing context on its placement within the system.

Block_Reusable

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates whether the block can be reused in other assessments (TRUE) or is unique to a specific assessment (FALSE).

Template_Score_Key

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique key representing the template score within the block, used for identification and tracking.

Score_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier for the score in the template block, ensuring consistency across assessments.

Score_Version_Custom_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Custom code assigned to the score version.

Score_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name of the score used in the block, providing a clear label for the scoring metric.

Score_Position

  • Is Nullable: YES

  • Data Type: INT64

  • Description: The position or order of the score within the block.

Score_Reference

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Reference information for the score within the block, such as a code or label for cross-referencing.

Formula

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The formula used to calculate the score, detailing the computation method applied.

Formula_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description of how the score formula is applied, explaining the logic and parameters involved.

Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier of the user who created the score in the block, providing accountability for content creation.

Created_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name of the user who created the score in the block, offering transparency in authorship.

Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when the score was created, marking its entry into the system.

Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp of the last modification made to the score in the block, indicating recent updates or changes.

Assessment Dataset Specification

Blocks

Block_Version_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: A unique key representing the version of the assessment block.

Assessment_Template_Blocks

Assessment_Version_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: A key representing the version of the overall assessment template to which the block belongs.

Block_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier for the assessment block.

Block_Correlation_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: An identifier used to correlate related blocks within the assessment.

Block_Version_Number

  • Is Nullable: YES

  • Data Type: INT64

  • Description: The version number of the assessment block.

Block_Position

  • Is Nullable: YES

  • Data Type: INT64

  • Description: The position of the block within the overall assessment template structure.

Assessment_Template_Display_Hierarchy

Assessment_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the assessment.

Assessment_Custom_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Custom code for the assessment.

Assessment_Version_Number

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Version number of the assessment.

Assessment_Version_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Key for the assessment version.

Assessment_Reference

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Reference information for the assessment.

Assessment_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the assessment.

Assessment_Alias

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Alias for the assessment.

Assessment_Status

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Status of the assessment.

Assessment_Status_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the assessment status.

Assessment_Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the user who created the assessment.

Assessment_Created_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the user who created the assessment.

Assessment_Scoring_Applied

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates if scoring is applied to the assessment.

Assessment_Published

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates if the assessment is published.

Assessment_Types

  • Is Nullable: NO

  • Data Type: ARRAY

  • Description: Types of the assessment.

Assessment_Types.Programs

  • Is Nullable: NO

  • Data Type: ARRAY

  • Description: Programs associated with the assessment types.

Assessment_Types.Programs.Code

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Code for the program associated with the assessment type.

Assessment_Types.Programs.Description

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Description of the program associated with the assessment type.

Assessment_Types.Code

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Code for the assessment type.

Assessment_Types.Description

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Description of the assessment type.

Assessment_Types.Domain

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Domain of the assessment type.

Assessment_Types.Configs

  • Is Nullable: NO

  • Data Type: ARRAY

  • Description: Configurations for the assessment types.

Assessment_Types.Configs.Config_Key

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Key for the configuration.

Assessment_Types.Configs.Config_Code

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Code for the configuration.

Assessment_Types.Configs.Config_Description

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Description of the configuration.

Assessment_Types.Configs.Config_Values

  • Is Nullable: NO

  • Data Type: ARRAY

  • Description: Values for the configuration.

Assessment_Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the assessment was created.

Assessment_Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the assessment was last modified.

Assessment_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the user who modified the assessment.

Assessment_Modified_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the user who modified the assessment.

Block_Position

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Position of the block in the assessment.

Block_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the block.

Block_Version_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Key for the block version.

Block_Version_Number

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Version number of the block.

Block_Reference

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Reference information related to the assessment block, aiding in contextual understanding.

Block_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the block.

Block_Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the user who created the block.

Block_Created_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the user who created the block.

Block_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the user who modified the block.

Block_Modified_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the user who modified the block.

Block_Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the block was created.

Block_Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the block was last modified.

Assessment Dataset Specification

Assessment Template Display Hierarchy

Item Type

  • Field Name: Item_Type

  • Required: YES

  • Type: STRING

  • Description: Type of the item.

Position Path

  • Field Name: Position_Path

  • Required: YES

  • Type: STRING

  • Description: Path of the position.

Question Path

  • Field Name: Question_Path

  • Required: YES

  • Type: STRING

  • Description: Path of the question.

Parent Question Item Type

  • Field Name: Parent_Question_Item_Type

  • Required: YES

  • Type: STRING

  • Description: Type of the parent question item.

Parent Template Question Key

  • Field Name: Parent_Template_Question_Key

  • Required: YES

  • Type: STRING

  • Description: Key for the parent template question.

Parent Question Name

  • Field Name: Parent_Question_Name

  • Required: YES

  • Type: STRING

  • Description: Name of the parent question.

Parent Template Score Key

  • Field Name: Parent_Template_Score_Key

  • Required: YES

  • Type: STRING

  • Description: Key for the parent template score.

Parent Score Name

  • Field Name: Parent_Score_Name

  • Required: YES

  • Type: STRING

  • Description: Name of the parent score.

Template Question Key

  • Field Name: Template_Question_Key

  • Required: YES

  • Type: STRING

  • Description: Key for the template question.

Question Position

  • Field Name: Question_Position

  • Required: YES

  • Type: INT64

  • Description: Position of the question.

Question Name

  • Field Name: Question_Name

  • Required: YES

  • Type: STRING

  • Description: Name of the question.

Question Type

  • Field Name: Question_Type

  • Required: YES

  • Type: STRING

  • Description: Type of the question.

Question Type Description

  • Field Name: Question_Type_Description

  • Required: YES

  • Type: STRING

  • Description: Description of the question type.

Question Reference

  • Field Name: Question_Reference

  • Required: YES

  • Type: STRING

  • Description: Reference for the question.

Question ID

  • Field Name: Question_ID

  • Required: YES

  • Type: STRING

  • Description: Identifier for the question.

Question Custom Code

  • Field Name: Question_Custom_Code

  • Required: YES

  • Type: STRING

  • Description: Custom code for the question.

Question Required

  • Field Name: Question_Required

  • Required: YES

  • Type: BOOL

  • Description: Indicates if the question is required.

Response Template Key

  • Field Name: Response_Template_Key

  • Required: YES

  • Type: STRING

  • Description: Key for the response template.

Response Position

  • Field Name: Response_Position

  • Required: YES

  • Type: INT64

  • Description: Position of the response.

Response Value

  • Field Name: Response_Value

  • Required: YES

  • Type: STRING

  • Description: Value of the response.

Response Weight

  • Field Name: Response_Weight

  • Required: YES

  • Type: INT64

  • Description: Weight of the response.

Response Custom Code

  • Field Name: Response_Custom_Code

  • Required: YES

  • Type: STRING

  • Description: Custom code for the response.

Template Score Key

  • Field Name: Template_Score_Key

  • Required: YES

  • Type: STRING

  • Description: Key for the template score.

Score Position

  • Field Name: Score_Position

  • Required: YES

  • Type: INT64

  • Description: Position of the score.

Score Name

  • Field Name: Score_Name

  • Required: YES

  • Type: STRING

  • Description: Name of the score.

Score Reference

  • Field Name: Score_Reference

  • Required: YES

  • Type: STRING

  • Description: Reference for the score.

Score ID

  • Field Name: Score_ID

  • Required: YES

  • Type: STRING

  • Description: Identifier for the score.

Score Custom Code

  • Field Name: Score_Custom_Code

  • Required: YES

  • Type: STRING

  • Description: Custom code for the score.

Score Formula

  • Field Name: Score_Formula

  • Required: YES

  • Type: STRING

  • Description: Formula for the score.

Score Formula Description

  • Field Name: Score_Formula_Description

  • Required: YES

  • Type: STRING

  • Description: Description of the score formula.

Score Parent Questions

  • Field Name: Score_Parent_Questions

  • Required: NO

  • Type: ARRAY

  • Description: Parent questions for the score.

Score Parent Questions Template Question Key

  • Field Name: Score_Parent_Questions.Template_Question_Key

  • Required: NO

  • Type: STRING

  • Description: Key for the template question of the parent question.

Score Parent Questions Question ID

  • Field Name: Score_Parent_Questions.Question_ID

  • Required: NO

  • Type: STRING

  • Description: Identifier for the parent question.

Score Parent Questions Question Custom Code

  • Field Name: Score_Parent_Questions.Question_Custom_Code

  • Required: NO

  • Type: STRING

  • Description: Custom code for the parent question.

Score Parent Questions Version Number

  • Field Name: Score_Parent_Questions.Version_Number

  • Required: NO

  • Type: INT64

  • Description: Version number of the parent question.

Score Parent Questions Formula Parameter

  • Field Name: Score_Parent_Questions.Formula_Parameter

  • Required: NO

  • Type: STRING

  • Description: Formula parameter for the parent question.

Score Parent Questions Created Timestamp

  • Field Name: Score_Parent_Questions.Created_Timestamp

  • Required: NO

  • Type: TIMESTAMP

  • Description: Timestamp when the parent question was created.

Score Parent Questions Last Modified Timestamp

  • Field Name: Score_Parent_Questions.Last_Modified_Timestamp

  • Required: NO

  • Type: TIMESTAMP

  • Description: Timestamp when the parent question was last modified.

Template Evaluation Key

  • Field Name: Template_Evaluation_Key

  • Required: YES

  • Type: STRING

  • Description: Key for the template evaluation.

Evaluation Custom Code

  • Field Name: Evaluation_Custom_Code

  • Required: YES

  • Type: STRING

  • Description: Custom code for the evaluation.

Evaluation Position

  • Field Name: Evaluation_Position

  • Required: YES

  • Type: INT64

  • Description: Position of the evaluation.

Evaluation Minimum Value

  • Field Name: Evaluation_Minimum_Value

  • Required: YES

  • Type: NUMERIC

  • Description: Minimum value for the evaluation.

Evaluation Maximum Value

  • Field Name: Evaluation_Maximum_Value

  • Required: YES

  • Type: NUMERIC

  • Description: Maximum value for the evaluation.

Evaluation Description

  • Field Name: Evaluation_Description

  • Required: YES

  • Type: STRING

  • Description: Description of the evaluation.

Child Template Question Keys

  • Field Name: Child_Template_Question_Keys

  • Required: NO

  • Type: ARRAY

  • Description: Child template question keys for the evaluation.

Child Template Question Key

  • Field Name: Child_Template_Question_Keys.Child_Template_Question_Key

  • Required: NO

  • Type: STRING

  • Description: Key for the child template question of the evaluation.

Problems

  • Field Name: Problems

  • Required: NO

  • Type: ARRAY

  • Description: Problems associated with the evaluation.

Problem Code

  • Field Name: Problems.Code

  • Required: NO

  • Type: STRING

  • Description: Code for the problem associated with the evaluation.

Problem Description

  • Field Name: Problems.Description

  • Required: NO

  • Type: STRING

  • Description: Description of the problem associated with the evaluation.

Tasks

  • Field Name: Tasks

  • Required: NO

  • Type: ARRAY

  • Description: Tasks associated with the evaluation.

Task Key

  • Field Name: Tasks.Key

  • Required: NO

  • Type: STRING

  • Description: Key for the task associated with the evaluation.

Task Priority

  • Field Name: Tasks.Priority

  • Required: NO

  • Type: STRING

  • Description: Priority of the task associated with the evaluation.

Assessment Dataset Specification

Assessment Template Display Hierarchy

Tasks

  • Tasks.Priority_Description

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Description of the task priority.

  • Tasks.Reason

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Reason for the task associated with the evaluation.

  • Tasks.Reason_Description

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Description of the task reason.

  • Tasks.Type

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Type of the task associated with the evaluation.

  • Tasks.Type_Description

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Description of the task type.

  • Tasks.Additional_Action

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Additional action for the task associated with the evaluation.

  • Tasks.Additional_Action_Description

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Description of the additional action.

Notifications

  • Notifications

  • Is Nullable: NO

  • Data Type: ARRAY

  • Description: Notifications associated with the evaluation.

  • Notifications.Key

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Key for the notification associated with the evaluation.

  • Notifications.Urgent

  • Is Nullable: NO

  • Data Type: BOOL

  • Description: Indicates if the notification is urgent.

  • Notifications.Text

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Text of the notification.

  • Notifications.Title

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Title of the notification.

Auto Workflows

  • Auto_Workflows

  • Is Nullable: NO

  • Data Type: ARRAY

  • Description: Automated workflows associated with the evaluation.

  • Auto_Workflows.Key

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Key for the automated workflow.

  • Auto_Workflows.Rule_Code

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Code for the rule of the automated workflow.

  • Auto_Workflows.Rule_Name

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Name of the rule of the automated workflow.

Assessment Template Block Score Evaluation Auto Workflows

Table Content

  • Block_Version_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for the version of the block containing the score evaluation and related workflows.

  • Template_Score_Key

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for the template score associated with the evaluation.

  • Template_Evaluation_Key

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for the specific template evaluation linked to the score.

  • Auto_Workflow_Key

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for the automated workflow triggered by the evaluation.

  • Rule_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Code representing the rule that governs the automated workflow.

  • Rule_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the rule associated with the automated workflow.

Assessment Template Block Score Evaluation Notifications

Table Content

  • Block_Version_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for the version of the block containing the score evaluation and related notifications.

  • Template_Score_Key

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for the template score associated with the evaluation.

  • Template_Evaluation_Key

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for the specific template evaluation linked to the score.

  • Notification_Key

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for the notification generated from the evaluation.

  • Urgent

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates whether the notification is marked as urgent.

  • Text

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The content or body of the notification message.

  • Title

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The title or subject of the notification.

Assessment Template Block Score Evaluation Problems

Table Content

  • Block_Version_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for the version of the block containing the score evaluation and related problems.

  • Template_Score_Key

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for the template score associated with the evaluation.

  • Template_Evaluation_Key

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for the specific template evaluation linked to the score.

  • Problem

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The specific issue or problem identified during the evaluation.

  • Problem_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Detailed description of the identified problem.

Assessment Template Block Score Evaluation Tasks

Table Content

  • Block_Version_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for the version of the block containing the score evaluation and related tasks.

  • Template_Score_Key

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for the template score associated with the evaluation task.

  • Template_Evaluation_Key

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for the template evaluation linked to the score evaluation task.

  • Task_Key

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for the task related to the score evaluation.

Assessment Dataset Specification

Assessment Template Block Score Evaluation Tasks

Task Priority

  • Column Name: Task_Priority

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Priority level assigned to the task within the score evaluation.

Task Priority Description

  • Column Name: Task_Priority_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description providing details about the assigned priority for the task.

Task Reason

  • Column Name: Task_Reason

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Reason for the task being created or assigned during the score evaluation process.

Task Reason Description

  • Column Name: Task_Reason_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Additional description of the reason for the task within the score evaluation.

Task Type

  • Column Name: Task_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of task assigned during the score evaluation.

Task Type Description

  • Column Name: Task_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Detailed description of the type of task.

Additional Action

  • Column Name: Additional_Action

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Additional actions that are associated with the task in the score evaluation.

Additional Action Description

  • Column Name: Additional_Action_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Detailed description of the additional actions to be taken for the task in the score evaluation.

Assessment Template Block Score Evaluations

Block Version Key

  • Column Name: Block_Version_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for the version of the block that includes the score evaluation.

Template Score Key

  • Column Name: Template_Score_Key

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for the template score used in the evaluation process.

Template Evaluation Key

  • Column Name: Template_Evaluation_Key

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for the template evaluation within the block score.

Position

  • Column Name: Position

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Position or order of the evaluation within the block.

Minimum Value

  • Column Name: Minimum_Value

  • Is Nullable: YES

  • Data Type: NUMERIC

  • Description: The minimum value that can be assigned or used in this evaluation.

Maximum Value

  • Column Name: Maximum_Value

  • Is Nullable: YES

  • Data Type: NUMERIC

  • Description: The maximum value that can be assigned or used in this evaluation.

Description

  • Column Name: Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the evaluation, providing additional context or details.

Assessment Template Block Score Parent Questions

Block Version Key

  • Column Name: Block_Version_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for the version of the block that includes the parent question.

Template Score Key

  • Column Name: Template_Score_Key

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for the template score associated with the parent question.

Parent Template Question Key

  • Column Name: Parent_Template_Question_Key

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for the parent template question.

Parent Question ID

  • Column Name: Parent_Question_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the parent question within the assessment.

Parent Block Version Number

  • Column Name: Parent_Block_Version_Number

  • Is Nullable: YES

  • Data Type: INT64

  • Description: The version number of the parent block containing the question.

Parent Formula Parameter

  • Column Name: Parent_Formula_Parameter

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The formula parameter associated with the parent question in the scoring block.

Parent Block Created Timestamp

  • Column Name: Parent_Block_Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the parent block was created.

Parent Block Last Modified Timestamp

  • Column Name: Parent_Block_Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp of the last modification to the parent block.

Assessment Template Tags

Assessment Tag Key

  • Column Name: Assessment_Tag_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: A unique key representing the specific tag within the assessment template.

Assessment Version Key

  • Column Name: Assessment_Version_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: A key representing the version of the assessment template to which the tag is associated.

Tag Name

  • Column Name: Tag_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name of the tag used to categorize or describe aspects of the assessment template.

Assessment Template Type Programs

Assessment Version Key

  • Column Name: Assessment_Version_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: A unique key identifying the version of the assessment template associated with this program.

Assessment Type

  • Column Name: Assessment_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The type of assessment template used in the program.

Program

  • Column Name: Program

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The specific program associated with the assessment template type.

Program Description

  • Column Name: Program_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A description providing more details about the program linked to the assessment template type.

Assessment Template Types

Assessment Version Key

  • Column Name: Assessment_Version_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: A unique key identifying the version of the assessment template.

Assessment Type

  • Column Name: Assessment_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The type of the assessment template, which defines its purpose and structure.

Assessment Type Description

  • Column Name: Assessment_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A detailed description providing more information about the assessment type.

Domain

  • Column Name: Domain

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The domain or category to which the assessment type belongs, such as healthcare, education, etc.

Assessment Response Score

Assessment Response Score Key

  • Column Name: Assessment_Response_Score_Key

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique identifier for the assessment response score.

Assessment Response Score ID

  • Column Name: Assessment_Response_Score_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the assessment response score.

Assessment Dataset Specification

Assessment Response Score

Columns and Descriptions

  • Assessment_Response_Key

  • Data Type: STRING

  • Description: The unique key referencing the parent assessment response.

  • Assessment_Response_ID

  • Data Type: STRING

  • Description: The unique identifier for the assessment response.

  • Member_ID

  • Data Type: STRING

  • Description: The unique identifier for the member associated with the assessment response.

  • Score_Version_Custom_Code

  • Data Type: STRING

  • Description: A custom code representing the version of the score in the assessment, used for tracking updates and customizations.

  • Block_Version_Custom_Code

  • Data Type: STRING

  • Description: A custom code for the version of the block associated with this score, used for customizations and tracking.

  • Assessment_Version_Custom_Code

  • Data Type: STRING

  • Description: A custom code for the version of the assessment, used for additional tracking or customization.

  • Matched_Evaluation_Version_Custom_Code

  • Data Type: STRING

  • Description: A custom code representing the matched evaluation version for additional tracking or customization.

  • Template_Score_Key

  • Data Type: STRING

  • Description: A key referencing the template score in the assessment.

  • Assessment_Version_Key

  • Data Type: INT64

  • Description: A key representing the version of the assessment used.

  • Assessment_Version_Number

  • Data Type: INT64

  • Description: The version number of the assessment.

  • Score_ID

  • Data Type: STRING

  • Description: The unique identifier for the score within the assessment.

  • Block_Version_Key

  • Data Type: INT64

  • Description: A key referencing the version of the block used in the assessment template.

  • Block_ID

  • Data Type: STRING

  • Description: The unique identifier for the block within the assessment.

  • Block_Version_Number

  • Data Type: INT64

  • Description: The version number of the block used in the assessment.

  • Score_Reference

  • Data Type: STRING

  • Description: A reference code or identifier associated with the score.

  • Assessment_ID

  • Data Type: STRING

  • Description: The unique identifier for the assessment.

  • Score_Name

  • Data Type: STRING

  • Description: The name of the score in the assessment.

  • Score_Version_Name

  • Data Type: STRING

  • Description: The name of the score version in the assessment.

  • Matched_Evaluation_Template_Evaluation_Key

  • Data Type: STRING

  • Description: A key referencing the template evaluation used for this score.

  • Matched_Evaluation_Description

  • Data Type: STRING

  • Description: A description of the matched evaluation criteria for this score.

  • Matched_Evaluation_Minimum_Value

  • Data Type: NUMERIC

  • Description: The minimum value for the evaluation criteria.

  • Matched_Evaluation_Maximum_Value

  • Data Type: NUMERIC

  • Description: The maximum value for the evaluation criteria.

  • Matched_Evaluation_Position

  • Data Type: INT64

  • Description: The position of the matched evaluation within the assessment.

  • Formula

  • Data Type: STRING

  • Description: The formula used to calculate the score.

  • Formula_Description

  • Data Type: STRING

  • Description: A description of the formula applied to calculate the score.

  • Total_Score

  • Data Type: NUMERIC

  • Description: The total score derived from the assessment.

  • First

  • Data Type: BOOL

  • Description: Indicates if this is the first assessment score response irrespective of status for a member/score combination.

  • Latest

  • Data Type: BOOL

  • Description: Indicates if this is the latest assessment score response irrespective of status for a member/score combination.

  • Created_Timestamp

  • Data Type: TIMESTAMP

  • Description: The date and time when the score was created.

  • Last_Modified_Timestamp

  • Data Type: TIMESTAMP

  • Description: The date and time when the score was last modified.

Assessment Template Block

Columns and Descriptions

  • Version_Key

  • Data Type: INT64

  • Nullable: NO

  • Description: Unique identifier for the version of the block within the assessment template.

  • Block_ID

  • Data Type: STRING

  • Nullable: YES

  • Description: Unique identifier assigned to the block for reference within and outside the system.

  • Correlation_ID

  • Data Type: STRING

  • Nullable: YES

  • Description: Identifier used to link this block with other related entities or processes within the system.

  • Version_Number

  • Data Type: INT64

  • Nullable: YES

  • Description: Version number of the block, indicating its revision within the template.

  • Reference

  • Data Type: STRING

  • Nullable: YES

  • Description: Additional reference information associated with the block for more detailed identification or notes.

  • Block_Name

  • Data Type: STRING

  • Nullable: YES

  • Description: The name of the block, providing a descriptive label for easier identification.

  • Status

  • Data Type: STRING

  • Nullable: YES

  • Description: Current status of the block within the template, such as 'Active', 'Inactive', or 'Pending Review'.

  • Status_Description

  • Data Type: STRING

  • Nullable: YES

  • Description: Description providing more details on the status, explaining what each status entails for the block.

  • Location_Key

  • Data Type: INT64

  • Nullable: YES

  • Description: Key identifier for the location associated with this block.

  • Location_Name

  • Data Type: STRING

  • Nullable: YES

  • Description: Name of the location associated with the block.

  • Location_Path

  • Data Type: STRING

  • Nullable: YES

  • Description: Path describing where the block is stored or how it is categorized within the organizational structure.

  • Created_User_ID

  • Data Type: STRING

  • Nullable: YES

  • Description: User ID of the creator of the block. Useful for audit trails and managing permissions.

  • Reusable

  • Data Type: STRING

  • Nullable: YES

  • Description: Indicates whether the block can be reused in other templates or processes.

Assessment Dataset Specification

Assessment Template Block

General Properties

  • e

  • Type: BOOL

  • Description: Indicates whether the block can be reused in multiple templates or sections within the system.

  • Created_Timestamp

  • Type: TIMESTAMP

  • Description: Timestamp marking when the block was originally created.

  • Last_Modified_Timestamp

  • Type: TIMESTAMP

  • Description: Timestamp of the most recent modification made to the block.

Questions

  • Questions

  • Type: ARRAY

  • Description: List of questions included within the block.

Question Properties

  • Template_Question_Key

  • Type: INT64

  • Description: Unique identifier for the question within the template.

  • Position

  • Type: INT64

  • Description: Position of the question within the block.

  • Question

  • Type: STRING

  • Description: The text of the question.

  • Question_Type

  • Type: STRING

  • Description: The type of question, such as 'Multiple Choice' or 'Free Text'.

  • Question_Type_Description

  • Type: STRING

  • Description: Description of the question type, providing additional details.

  • Reference

  • Type: STRING

  • Description: Reference information for the question, used for linking to other records or providing context.

  • Question_ID

  • Type: STRING

  • Description: Unique identifier for the question.

  • Required

  • Type: BOOL

  • Description: Indicates whether the question is required to be answered.

  • Version_Number

  • Type: INT64

  • Description: Version number of the question, indicating its revision within the block.

  • Created_Timestamp

  • Type: TIMESTAMP

  • Description: Timestamp when the question was created.

  • Last_Modified_Timestamp

  • Type: TIMESTAMP

  • Description: Timestamp when the question was last modified.

Responses

  • Responses

  • Type: ARRAY

  • Description: List of possible responses for the question.

Response Properties

  • Response_Template_Key

  • Type: INT64

  • Description: Unique identifier for the response within the template.

  • Position

  • Type: INT64

  • Description: Position of the response within the list of possible responses.

  • Value

  • Type: STRING

  • Description: The value or text of the response.

  • Value_Code

  • Type: STRING

  • Description: Code representing the value of the response, used for standardized categorization.

  • Weight

  • Type: INT64

  • Description: The weight assigned to the response, indicating its importance or relevance within the assessment.

  • Created_Timestamp

  • Type: TIMESTAMP

  • Description: Timestamp when the response was created.

  • Last_Modified_Timestamp

  • Type: TIMESTAMP

  • Description: Timestamp when the response was last modified.

Child Template Questions

  • Child_Template_Question_Key

  • Type: ARRAY

  • Description: List of keys identifying the child template questions related to this response.

Problems

  • Problems

  • Type: ARRAY

  • Description: List of problems associated with the response.

Problem Properties

  • Key

  • Type: INT64

  • Description: Unique identifier for the problem.

  • Code

  • Type: STRING

  • Description: Code representing the problem.

  • Description

  • Type: STRING

  • Description: Description of the problem.

  • Created_Timestamp

  • Type: TIMESTAMP

  • Description: Timestamp when the problem was created.

  • Last_Modified_Timestamp

  • Type: TIMESTAMP

  • Description: Timestamp when the problem was last modified.

Tasks

  • Tasks

  • Type: ARRAY

  • Description: List of tasks associated with the response.

Task Properties

  • Key

  • Type: INT64

  • Description: Unique identifier for the task.

  • Data

  • Type: STRING

  • Description: Data or description associated with the task.

  • Additional_Action

  • Type: STRING

  • Description: Additional action to be taken as part of the task.

  • Additional_Action_Description

  • Type: STRING

  • Description: Description of the additional action.

  • Created_Timestamp

  • Type: TIMESTAMP

  • Description: Timestamp when the task was created.

  • Last_Modified_Timestamp

  • Type: TIMESTAMP

  • Description: Timestamp when the task was last modified.

Notifications

  • Notifications

  • Type: ARRAY

  • Description: List of notifications associated with the response.

Notification Properties

  • Key

  • Type: INT64

  • Description: Unique identifier for the notification.

  • Data

  • Type: STRING

  • Description: Data or description associated with the notification.

  • Created_Timestamp

  • Type: TIMESTAMP

  • Description: Timestamp when the notification was created.

  • Last_Modified_Timestamp

  • Type: TIMESTAMP

  • Description: Timestamp when the notification was last modified.

Auto Workflows

  • Auto_Workflows

  • Type: ARRAY

  • Description: List of automatic workflows triggered by the response.

Workflow Properties

  • Key

  • Type: INT64

  • Description: Unique identifier for the workflow.

  • Data

  • Type: STRING

  • Description: Data or description associated with the workflow.

  • Created_Timestamp

  • Type: TIMESTAMP

  • Description: Timestamp when the workflow was created.

  • Last_Modified_Timestamp

  • Type: TIMESTAMP

  • Description: Timestamp when the workflow was last modified.

Scores

  • Scores

  • Type: ARRAY

  • Description: List of scores associated with the block.

Score Properties

  • Template_Score_Key

  • Type: INT64

  • Description: Unique identifier for the score within the template.

  • Score_Name

  • Type: STRING

  • Description: Name of the score.

  • Reference

  • Type: STRING

  • Description: Additional reference information associated with the score.

  • Score_ID

  • Type: STRING

  • Description: Unique identifier for the score.

  • Version_Number

  • Type: INT64

  • Description: Version number of the score.

  • Formula

  • Type: STRING

  • Description: Formula used to calculate the score.

  • Formula_Description

  • Type: STRING

  • Description: Description of the formula used for the score.

  • Created_Timestamp

  • Type: TIMESTAMP

  • Description: Timestamp when the score was created.

  • Last_Modified_Timestamp

  • Type: TIMESTAMP

  • Description: Timestamp when the score was last modified.

Assessment Dataset Specification

Scores

Body Mass Index (BMI) Calculation Details

  • Scores.BMI.Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for the BMI calculation within the template.

  • Scores.BMI.Height_Template_Question_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Identifier for the height question used in the BMI calculation.

  • Scores.BMI.Weight_Template_Question_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Identifier for the weight question used in the BMI calculation.

  • Scores.BMI.Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the BMI calculation details were created.

  • Scores.BMI.Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the BMI calculation details were last modified.

Parent Template Questions

  • Scores.Parent_Template_Question_Keys

  • Is Nullable: YES

  • Data Type: ARRAY

  • Description: List of keys identifying the parent template questions related to the score.

Evaluations

  • Scores.Evaluations

  • Is Nullable: YES

  • Data Type: ARRAY

  • Description: List of evaluations associated with the score.

Evaluation Attributes

  • Scores.Evaluations.Template_Evaluation_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for the evaluation within the template.

  • Scores.Evaluations.Position

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Position of the evaluation within the list of evaluations.

  • Scores.Evaluations.Minimum_Value

  • Is Nullable: YES

  • Data Type: NUMERIC

  • Description: Minimum value for the evaluation.

  • Scores.Evaluations.Maximum_Value

  • Is Nullable: YES

  • Data Type: NUMERIC

  • Description: Maximum value for the evaluation.

  • Scores.Evaluations.Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the evaluation.

  • Scores.Evaluations.Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the evaluation was created.

  • Scores.Evaluations.Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the evaluation was last modified.

  • Scores.Evaluations.Child_Template_Question_Keys

  • Is Nullable: YES

  • Data Type: ARRAY

  • Description: List of keys identifying the child template questions related to the evaluation.

Problems

  • Scores.Evaluations.Problems

  • Is Nullable: YES

  • Data Type: ARRAY

  • Description: List of problems associated with the evaluation.

Problem Attributes

  • Scores.Evaluations.Problems.Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for the problem.

  • Scores.Evaluations.Problems.Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Code representing the problem.

  • Scores.Evaluations.Problems.Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the problem.

  • Scores.Evaluations.Problems.Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the problem was created.

  • Scores.Evaluations.Problems.Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the problem was last modified.

Tasks

  • Scores.Evaluations.Tasks

  • Is Nullable: YES

  • Data Type: ARRAY

  • Description: List of tasks associated with the evaluation.

Task Attributes

  • Scores.Evaluations.Tasks.Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for the task.

  • Scores.Evaluations.Tasks.Data

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Data or description associated with the task.

  • Scores.Evaluations.Tasks.Additional_Action

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Additional action to be taken as part of the task.

  • Scores.Evaluations.Tasks.Additional_Action_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the additional action.

  • Scores.Evaluations.Tasks.Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the task was created.

  • Scores.Evaluations.Tasks.Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the task was last modified.

Notifications

  • Scores.Evaluations.Notifications

  • Is Nullable: YES

  • Data Type: ARRAY

  • Description: List of notifications associated with the evaluation.

Notification Attributes

  • Scores.Evaluations.Notifications.Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for the notification.

  • Scores.Evaluations.Notifications.Data

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Data or description associated with the notification.

  • Scores.Evaluations.Notifications.Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the notification was created.

  • Scores.Evaluations.Notifications.Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the notification was last modified.

Auto Workflows

  • Scores.Evaluations.Auto_Workflows

  • Is Nullable: YES

  • Data Type: ARRAY

  • Description: List of automatic workflows triggered by the evaluation.

Workflow Attributes

  • Scores.Evaluations.Auto_Workflows.Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for the workflow.

  • Scores.Evaluations.Auto_Workflows.Data

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Data or description associated with the workflow.

  • Scores.Evaluations.Auto_Workflows.Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the workflow was created.

  • Scores.Evaluations.Auto_Workflows.Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the workflow was last modified.

Assessment Template Block

Attributes

  • Record_Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The timestamp indicating the last time the record was modified.

  • Transaction_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The user ID of the person who performed the transaction.

  • Type

  • Is Nullable: NO

  • Data Type: STRING

  • Description: The type of the assessment template block.

  • Tenant

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Unique identifier for the tenant.

  • Active_Version

  • Is Nullable: NO

  • Data Type: BOOL

  • Description: Indicator if this is the active version of the template block.

  • Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: The date associated with the template block.

  • Sequence

  • Is Nullable: NO

  • Data Type: INT64

  • Description: The sequence number of the template block.

  • Source_System_Name

  • Is Nullable: NO

  • Data Type: STRING

  • Description: The name of the source system from which the data originated.

  • Source_File_Name

  • Is Nullable: NO

  • Data Type: STRING

  • Description: The name of the source file from which the data was imported.

  • Source_Timestamp

  • Is Nullable: NO

  • Data Type: TIMESTAMP

  • Description: The timestamp of when the source file was created or last modified.

  • Schema_Version

  • Is Nullable: YES

  • Data Type: NUMERIC

  • Description: The version of the schema used for the template block.

  • Deleted_Indicator

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicator if the template block has been deleted.

Assessment Dataset Specification

Notification Table

Columns

  • Notification_ID

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Unique identifier for the notification.

  • Member_ID

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Unique identifier for the member associated with the notification.

  • Title

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Title of the notification.

  • Text

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Text content of the notification.

  • Source

  • Is Nullable: YES

  • Data Type: STRUCT

  • Description: Source information of the notification.

Source Subfields

  • Source_Type_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for the type of source.

  • Source_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of the source.

  • Source_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the source type.

  • Assessment_Response_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for the assessment response.

  • Target

  • Is Nullable: YES

  • Data Type: STRUCT

  • Description: Target information of the notification.

Target Subfields

  • Target_Type_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for the type of target.

  • Target_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of the target.

  • Target_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the target type.

  • Program_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Code of the program associated with the notification.

  • Program_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for the program.

  • Screening_Request_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for the screening request.

  • Request_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for the request.

  • Request_Key

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Key for the request associated with the notification.

  • Owner_Department_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for the department owning the notification.

  • Owner_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for the user owning the notification.

  • Urgent

  • Is Nullable: NO

  • Data Type: BOOL

  • Description: Indicator if the notification is urgent.

  • Hidden

  • Is Nullable: NO

  • Data Type: BOOL

  • Description: Indicator if the notification is hidden.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the notification was created.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the notification was last modified.

  • Notification_Task

  • Is Nullable: YES

  • Data Type: STRUCT

  • Description: Task information associated with the notification.

Notification_Task Subfields

  • Key

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for the notification task.

  • Task_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for the task.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the notification task was created.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the notification task was last modified.

  • Record_Last_Modified_Timestamp

  • Is Nullable: NO

  • Data Type: TIMESTAMP

  • Description: Timestamp when the record was last modified.

  • Transaction_User_ID

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Unique identifier for the user who performed the transaction.

  • Deleted_Indicator

  • Is Nullable: NO

  • Data Type: BOOL

  • Description: Indicator if the notification has been deleted.

Assessment Notes Table

Columns

  • Member_ID

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Unique identifier for the member associated with the note.

  • Note_Key

  • Is Nullable: NO

  • Data Type: INTEGER

  • Description: Unique identifier for the note.

  • Text

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Text content of the note.

  • Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of the note.

  • Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the note type.

  • Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the note was created.

  • Author_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for the user who authored the note.

  • Void_Indicator

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicator if the note has been voided.

  • Void_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the note was voided.

  • Void_Reason

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Reason for voiding the note.

  • Void_Reason_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the reason for voiding the note.

  • Void_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for the user who voided the note.

  • Related_Entity_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of entity related to the note.

  • Related_Entity_Key

  • Is Nullable: YES

  • Data Type: INTEGER

  • Description: Unique identifier for the related entity.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the note was initially created.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the note was last modified.

  • Record_Last_Modified_Timestamp

  • Is Nullable: NO

  • Data Type: TIMESTAMP

  • Description: Timestamp when the record was last modified.

  • Transaction_User_ID

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Unique identifier for the user who performed the transaction.

  • Deleted_Indicator

  • Is Nullable: NO

  • Data Type: BOOL

  • Description: Indicator if the note has been deleted.

Assessment Response Log Table

Columns

  • Assessment_Response_Key

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Key for the assessment response.

  • Assessment_Response_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the assessment response.

  • Member_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the member.

  • Program_Screening_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Key for the program screening.

  • Program

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the program.

  • Program_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the program.

  • Request_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Key for the request.

  • Digital

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates if the response is digital.

  • Status

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Status of the assessment response.

  • Status_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the status.

  • Source

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Source of the assessment response.

  • Source_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the source.

Assessment Dataset Specification

Assessment Response Log

Columns

  • Assessment_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of the assessment.

  • Assessment_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the assessment type.

  • Domain

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Domain of the assessment.

  • Template

  • Is Nullable: YES

  • Data Type: STRUCT

  • Description: Template used for the assessment.

  • Template.Version_Key

    • Is Nullable: YES

    • Data Type: INT64

    • Description: Key for the template version.

  • Template.Correlation_ID

    • Is Nullable: YES

    • Data Type: STRING

    • Description: Correlation ID for the template.

  • Template.Assessment_ID

    • Is Nullable: YES

    • Data Type: STRING

    • Description: Identifier for the template assessment.

  • Template.Assessment_Name

    • Is Nullable: YES

    • Data Type: STRING

    • Description: Name of the template assessment.

  • Template.Reference

    • Is Nullable: YES

    • Data Type: STRING

    • Description: Reference for the template.

  • Template.Version_Number

    • Is Nullable: YES

    • Data Type: INT64

    • Description: Version number of the template.

  • Template.Assessment_Custom_Code

    • Is Nullable: YES

    • Data Type: STRING

    • Description: Custom code for the template assessment.

  • Auto_Workflows

  • Is Nullable: NO

  • Data Type: ARRAY

  • Description: Automated workflows associated with the assessment.

  • Auto_Workflows.Created_Timestamp

    • Is Nullable: NO

    • Data Type: TIMESTAMP

    • Description: Timestamp when the automated workflow was created.

  • Auto_Workflows.Rule

    • Is Nullable: NO

    • Data Type: STRING

    • Description: Rule for the automated workflow.

  • Additional_Actions

  • Is Nullable: NO

  • Data Type: ARRAY

  • Description: Additional actions associated with the assessment.

  • Additional_Actions.Code

    • Is Nullable: NO

    • Data Type: STRING

    • Description: Code for the additional action.

  • Additional_Actions.Description

    • Is Nullable: NO

    • Data Type: STRING

    • Description: Description of the additional action.

  • Answered_By_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the user who answered the assessment.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the assessment response was created.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the assessment response was last modified.

  • Record_Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the record was last modified in the system.

  • Transaction_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Deleted_Indicator

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicator if the record is deleted.

  • Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of the assessment response.

  • Tenant

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the tenant or client.

  • Active_Version

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates the active version of the record.

  • Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: Date of the assessment response.

  • Sequence

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Sequence number of the assessment response.

  • Source_System_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the source system.

  • Source_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp from the source system.

  • Source_File_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the source file.

  • Schema_Version

  • Is Nullable: YES

  • Data Type: FLOAT64

  • Description: Version of the schema.

  • Member_Partition

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Partition for the member data.

  • _updated

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicator if the record is updated.

  • Action

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Action performed in the assessment response.

  • Program_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the program.

  • Request_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the request.

  • Answered_By_Member_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the member who answered the assessment.

  • Transaction_Actor_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of the actor performing the transaction.

Assessment Response Question Log

Columns

  • Assessment_Response_Question_Key

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for the assessment response question.

  • Assessment_Response_Key

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for the assessment response associated with the question.

  • Assessment_Response_Question_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the assessment response question.

  • Template

  • Is Nullable: YES

  • Data Type: STRUCT

  • Description: Template information for the assessment response question.

  • Template.Assessment_ID

    • Is Nullable: YES

    • Data Type: STRING

    • Description: Unique identifier for the assessment template.

  • Template.Version_Key

    • Is Nullable: YES

    • Data Type: INT64

    • Description: Key representing the version of the template.

  • Template.Version_Number

    • Is Nullable: YES

    • Data Type: INT64

    • Description: Numeric value indicating the version number of the template.

  • Template.Template_Question_Key

    • Is Nullable: YES

    • Data Type: STRING

    • Description: Key representing the specific question within the template.

  • Template.Question_ID

    • Is Nullable: YES

    • Data Type: STRING

    • Description: Unique identifier for the question.

  • Template.Block_ID

    • Is Nullable: YES

    • Data Type: STRING

    • Description: Identifier for the block within the template.

  • Template.Block_Custom_Code

    • Is Nullable: YES

    • Data Type: STRING

    • Description: Custom code associated with the block.

  • Template.Assessment_Custom_Code

    • Is Nullable: YES

    • Data Type: STRING

    • Description: Custom code associated with the assessment.

  • Template.Block_Version_Key

    • Is Nullable: YES

    • Data Type: INT64

    • Description: Key representing the version of the block.

  • Template.Block_Version_Number

    • Is Nullable: YES

    • Data Type: INT64

    • Description: Numeric value indicating the version number of the block.

  • Template.Question_Reference

    • Is Nullable: YES

    • Data Type: STRING

    • Description: Reference information for the question.

  • Template.Question_Custom_Code

    • Is Nullable: YES

    • Data Type: STRING

    • Description: Custom code associated with the question.

  • Member_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for the member.

  • Position

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Position of the question within the assessment response.

Assessment Dataset Specification

Assessment_Response_Question_log

  • Is Nullable: NO

  • Data Type: ARRAY

  • Description: Array of keys related to the assessment response scores.

Child_Question_Indicator

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicator if the question is a child question.

Parent_Assessment_Response_Question_Key

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Key of the parent assessment response question, if applicable.

Question_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of the question.

Question_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the question type.

Question

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The text of the question.

Response_Value

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The response value provided for the question.

Response_Value_String

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The response value provided as a string.

Response_Value_Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: The response value provided as a date.

Response_Value_Number

  • Is Nullable: YES

  • Data Type: NUMERIC

  • Description: The response value provided as a number.

Answered

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates if the question was answered.

Required

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates if the question is required.

Answered_By_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier of the user who answered the question.

Source

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Source of the question.

Source_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the source of the question.

Selected_Responses

  • Is Nullable: NO

  • Data Type: ARRAY

  • Description: Array of selected responses for the question.

Selected_Responses.Position

  • Is Nullable: NO

  • Data Type: INT64

  • Description: The position of the selected response, indicating its order in the sequence of possible responses.

Selected_Responses.Weight

  • Is Nullable: NO

  • Data Type: INT64

  • Description: The weight assigned to the selected response, representing its importance or impact within the assessment.

Selected_Responses.Response_Template_Key

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Unique key identifying the template response associated with the question.

Selected_Responses.Value

  • Is Nullable: NO

  • Data Type: STRING

  • Description: The actual value of the selected response provided in the assessment.

Selected_Responses.Value_Code

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Code representing the value of the response, used for standardized categorization.

Selected_Responses.Child_Assessment_Response_Question_Keys

  • Is Nullable: NO

  • Data Type: ARRAY

  • Description: List of keys identifying the child assessment response questions related to this response for further clarification.

Selected_Responses.Response_Custom_Code

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Custom code associated with the selected response.

Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the assessment response question was created.

Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the assessment response question was last modified.

Record_Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the record was last modified.

Transaction_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

Deleted_Indicator

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicator whether the assessment response question is deleted.

Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of the assessment response question log entry.

Tenant

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Tenant associated with the assessment response question log entry.

Active_Version

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates if the assessment response question is the active version.

Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: Date associated with the assessment response question log entry.

Sequence

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Sequence number of the assessment response question log entry.

Source_System_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the source system from where the assessment response question originated.

Source_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the data was sourced.

Source_File_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the source file from where the assessment response question data was sourced.

Schema_Version

  • Is Nullable: YES

  • Data Type: FLOAT64

  • Description: Version of the schema used for the assessment response question log entry.

Member_Partition

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Partition number for the member associated with the assessment response question.

_updated

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Timestamp indicating the last update of the assessment response question log entry.

Action

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Action associated with the assessment response question log entry.

Parent_Assessment_Response_Score_Key

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Key for the parent assessment response score.

Parent_Assessment_Response_Score_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the parent assessment response score.

Answered_By_Member_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the member who answered the question.

Transaction_Actor_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of the actor performing the transaction.

Assessment_Response_Score_log

Assessment_Response_Score_Key

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for the assessment response score.

Assessment Dataset Specification

Assessment Response Score Log

Response Key

  • Type: STRING

  • Required: YES

  • Description: Unique identifier for the assessment response associated with the score.

Assessment Response Score ID

  • Type: STRING

  • Required: YES

  • Description: Identifier for the assessment response score.

Template

  • Type: STRUCT

  • Required: YES

  • Description: Template information for the assessment response score.

Template.Assessment ID

  • Type: STRING

  • Required: YES

  • Description: Unique identifier for the assessment associated with the response score.

Template.Version Key

  • Type: INT64

  • Required: YES

  • Description: Key representing the version of the assessment template used in the scoring.

Template.Version Number

  • Type: INT64

  • Required: YES

  • Description: Version number of the assessment, indicating the specific iteration of the assessment template.

Template.Template Score Key

  • Type: STRING

  • Required: YES

  • Description: Unique key linking the score to a specific template, ensuring consistency in score tracking.

Template.Score ID

  • Type: STRING

  • Required: YES

  • Description: Identifier for the score associated with the assessment, used for reference and tracking.

Template.Block Version Key

  • Type: INT64

  • Required: YES

  • Description: Key representing the version of the block in which the score resides, ensuring accuracy in grouping.

Template.Block ID

  • Type: STRING

  • Required: YES

  • Description: Unique identifier for the block of questions or responses related to this score.

Template.Block Version Number

  • Type: INT64

  • Required: YES

  • Description: Version number of the block, indicating any updates or revisions made to this group of questions.

Template.Score Custom Code

  • Type: STRING

  • Required: YES

  • Description: Custom code associated with the score.

Template.Block Custom Code

  • Type: STRING

  • Required: YES

  • Description: Custom code associated with the block.

Template.Assessment Custom Code

  • Type: STRING

  • Required: YES

  • Description: Custom code associated with the assessment.

Template.Score Reference

  • Type: STRING

  • Required: YES

  • Description: Reference information for the score, providing additional context or details related to the score.

Member ID

  • Type: STRING

  • Required: YES

  • Description: Unique identifier for the member.

Score Name

  • Type: STRING

  • Required: YES

  • Description: Name of the score.

Matched Evaluation

  • Type: STRING

  • Required: YES

  • Description: A textual description of the evaluation criteria or score definition.

Matched Evaluation.Description

  • Type: NUMERIC

  • Required: YES

  • Description: The minimum value allowed for the evaluation, defining the lower bound of the score range.

Matched Evaluation.Minimum Value

  • Type: NUMERIC

  • Required: YES

  • Description: The maximum value allowed for the evaluation, defining the upper bound of the score range.

Matched Evaluation.Maximum Value

  • Type: ARRAY

  • Required: YES

  • Description: An array of child assessment response questions, each identified by a key and ID, indicating related sub-questions.

Matched Evaluation.Child Assessment Response Questions

  • Type: ARRAY

  • Required: YES

  • Description: The position of this evaluation in relation to other evaluations or scoring elements.

Matched Evaluation.Child Assessment Response Questions.Key

  • Type: STRING

  • Required: YES

  • Description: Key for the maximum value of the matched evaluation.

Matched Evaluation.Child Assessment Response Questions.ID

  • Type: STRING

  • Required: YES

  • Description: Identifier for the maximum value of the matched evaluation.

Matched Evaluation.Position

  • Type: STRING

  • Required: YES

  • Description: A unique key linking this evaluation to the template for tracking and reference purposes.

Matched Evaluation.Evaluation Custom Code

  • Type: STRING

  • Required: YES

  • Description: Custom code associated with the matched evaluation.

Matched Evaluation.Template Evaluation Key

  • Type: STRING

  • Required: YES

  • Description: A textual description of the evaluation criteria or score definition.

Formula

  • Type: STRING

  • Required: YES

  • Description: Formula used to calculate the score.

Formula Description

  • Type: STRING

  • Required: YES

  • Description: Description of the formula used for the score.

Parent Assessment Response Questions

  • Type: ARRAY

  • Required: NO

  • Description: Array of parent assessment response questions related to the score.

Parent Assessment Response Questions.Key

  • Type: STRING

  • Required: NO

  • Description: A unique key used to identify each parent assessment response question within the dataset.

Parent Assessment Response Questions.ID

  • Type: STRING

  • Required: NO

  • Description: The identifier for the parent assessment response question, used for reference and tracking.

Parent Assessment Response Questions.Formula Parameter

  • Type: STRING

  • Required: NO

  • Description: Represents a formula or parameter associated with the parent assessment response question, if applicable.

Total Score

  • Type: NUMERIC

  • Required: YES

  • Description: Total score calculated.

Created Timestamp

  • Type: TIMESTAMP

  • Required: YES

  • Description: Timestamp when the assessment response score was created.

Last Modified Timestamp

  • Type: TIMESTAMP

  • Required: YES

  • Description: Timestamp when the assessment response score was last modified.

Record Last Modified Timestamp

  • Type: TIMESTAMP

  • Required: YES

  • Description: Timestamp when the record was last modified.

Transaction User ID

  • Type: STRING

  • Required: YES

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

Deleted Indicator

  • Type: BOOL

  • Required: YES

  • Description: Indicator whether the assessment response score is deleted.

Type

  • Type: STRING

  • Required: YES

  • Description: Type of the assessment response score log entry.

Tenant

  • Type: STRING

  • Required: YES

  • Description: Tenant associated with the assessment response score log entry.

Active Version

  • Type: BOOL

  • Required: YES

  • Description: Indicates if the assessment response score is the active version.

Date

  • Type: DATE

  • Required: YES

  • Description: Date associated with the assessment response score log entry.

Sequence

  • Type: INT64

  • Required: YES

  • Description: Sequence number of the assessment response score log entry.

Source System Name

  • Type: STRING

  • Required: YES

  • Description: Name of the source system from where the assessment response score originated.

Source Timestamp

  • Type: TIMESTAMP

  • Required: YES

  • Description: Timestamp when the data was sourced.

Source File Name

  • Type: STRING

  • Required: YES

  • Description: Name of the source file from which the assessment response score originated.

Assessment Dataset Specification

Assessment Response Score Log

Table Structure

Table Name

Column Name

Is Nullable

Data Type

Description

Assessment_Response_Score_log

Schema_Version

YES

FLOAT64

Version of the schema used for the assessment response score log entry.

Assessment_Response_Score_log

Member_Partition

YES

INT64

Partition number for the member associated with the assessment response score.

Assessment_Response_Score_log

_updated

YES

STRING

Timestamp indicating the last update of the record.

Assessment_Response_Score_log

Action

YES

STRING

Action taken on the assessment response score log entry.

Assessment_Response_Score_log

Transaction_Actor_Type

YES

STRING

Type of the actor performing the transaction.

Assessment Template Block Log

Table Structure

Table Name

Column Name

Is Nullable

Data Type

Description

Assessment_Template_Block_log

Version_Key

YES

INT64

Unique identifier for a specific version of an assessment template block.

Assessment_Template_Block_log

Block_ID

YES

STRING

System-generated ID for the block.

Assessment_Template_Block_log

Block_Custom_Code

YES

STRING

Custom code assigned to the block for easy reference.

Assessment_Template_Block_log

Correlation_ID

YES

STRING

Correlation ID for linking related blocks.

Assessment_Template_Block_log

Version_Number

YES

INT64

Version number of the block.

Assessment_Template_Block_log

Reference

YES

STRING

Reference information or citation for the block.

Assessment_Template_Block_log

Block_Name

YES

STRING

Name of the block.

Assessment_Template_Block_log

Status

YES

STRING

Current status of the block.

Assessment_Template_Block_log

Status_Description

YES

STRING

Detailed description of the status.

Assessment_Template_Block_log

Location_Key

YES

INT64

Unique identifier for the location associated with the block.

Assessment_Template_Block_log

Location_Name

YES

STRING

Name of the location associated with the block.

Assessment_Template_Block_log

Location_Path

YES

STRING

Hierarchical path of the location within the organization structure.

Assessment_Template_Block_log

Created_User_ID

YES

STRING

User ID of the person who created the block.

Assessment_Template_Block_log

Reusable

YES

BOOL

Indicates whether the block is reusable in other templates.

Assessment_Template_Block_log

Created_Timestamp

YES

TIMESTAMP

Timestamp of when the block was created.

Assessment_Template_Block_log

Last_Modified_Timestamp

YES

TIMESTAMP

Timestamp of when the block was last modified.

Assessment_Template_Block_log

Questions

NO

ARRAY

Collection of questions within the block.

Questions Structure

Column Name

Is Nullable

Data Type

Description

Questions.Template_Question_Key

NO

STRING

Unique identifier for a specific question within the template.

Questions.Position

NO

INT64

Position or order of the question within the block.

Questions.Question

NO

STRING

The actual question text.

Questions.Question_Type

NO

STRING

Type or category of the question.

Questions.Question_Type_Description

NO

STRING

Detailed description of the question type.

Questions.Reference

NO

STRING

Reference information or citation for the question.

Questions.Question_ID

NO

STRING

System-generated ID for the question.

Questions.Question_Custom_Code

NO

STRING

Custom code assigned to the question for easy reference.

Questions.Required

NO

BOOL

Indicates whether the question is mandatory.

Questions.Responses

NO

ARRAY

Collection of possible responses for the question.

Responses Structure

Column Name

Is Nullable

Data Type

Description

Questions.Responses.Response_Template_Key

NO

STRING

Unique identifier for a specific response template.

Questions.Responses.Position

NO

INT64

Position or order of the response option.

Questions.Responses.Value

NO

STRING

The actual response value or text.

Questions.Responses.Value_Code

NO

STRING

Code associated with the response value.

Questions.Responses.Weight

NO

INT64

Numerical weight assigned to the response.

Questions.Responses.Response_Custom_Code

NO

STRING

Custom code assigned to the response for easy reference.

Questions.Responses.Child_Template_Question_Keys

NO

ARRAY

List of question keys that are triggered by this response.

Questions.Responses.Problems

NO

ARRAY

Collection of potential problems associated with this response.

Problems Structure

Column Name

Is Nullable

Data Type

Description

Questions.Responses.Problems.Code

NO

STRING

Code or identifier for a specific problem.

Questions.Responses.Problems.Description

NO

STRING

Detailed description of the problem.

Tasks Structure

Column Name

Is Nullable

Data Type

Description

Questions.Responses.Tasks.Key

NO

STRING

Unique identifier for a specific task.

Questions.Responses.Tasks.Priority

NO

STRING

Priority level of the task.

Questions.Responses.Tasks.Priority_Description

NO

STRING

Description of the priority level.

Questions.Responses.Tasks.Reason

NO

STRING

Reason for assigning the task.

Questions.Responses.Tasks.Reason_Description

NO

STRING

Detailed description of the reason.

Assessment Dataset Specification

Assessment Template Block Log

Questions.Responses.Tasks

  • Type

  • Required: NO

  • Data Type: STRING

  • Description: Type or category of the task.

  • Type_Description

  • Required: NO

  • Data Type: STRING

  • Description: Description of the task type.

  • Additional_Action

  • Required: NO

  • Data Type: STRING

  • Description: Any additional action required for the task.

  • Additional_Action_Description

  • Required: NO

  • Data Type: STRING

  • Description: Detailed description of the additional action.

Questions.Responses.Notifications

  • Notifications

  • Required: NO

  • Data Type: ARRAY

  • Description: Collection of notifications associated with this response.

  • Key

  • Required: NO

  • Data Type: STRING

  • Description: Unique identifier for a specific notification.

  • Urgent

  • Required: NO

  • Data Type: BOOL

  • Description: Indicates whether the notification is urgent.

  • Text

  • Required: NO

  • Data Type: STRING

  • Description: Content of the notification message.

  • Title

  • Required: NO

  • Data Type: STRING

  • Description: Title or subject of the notification.

Questions.Responses.Auto_Workflows

  • Auto_Workflows

  • Required: NO

  • Data Type: ARRAY

  • Description: Collection of automated workflows associated with this response.

  • Key

  • Required: NO

  • Data Type: STRING

  • Description: Unique identifier for a specific workflow.

  • Rule_Code

  • Required: NO

  • Data Type: STRING

  • Description: Code representing the rule that triggers the workflow.

  • Rule_Name

  • Required: NO

  • Data Type: STRING

  • Description: Name of the rule that triggers the workflow.

Scores

General Information

  • Scores

  • Required: NO

  • Data Type: ARRAY

  • Description: Collection of scores associated with the block.

  • Template_Score_Key

  • Required: NO

  • Data Type: STRING

  • Description: Unique identifier for a specific score within the template.

  • Score_Name

  • Required: NO

  • Data Type: STRING

  • Description: Name of the score.

  • Reference

  • Required: NO

  • Data Type: STRING

  • Description: Reference information or citation for the score.

  • Score_ID

  • Required: NO

  • Data Type: STRING

  • Description: System-generated ID for the score.

  • Score_Custom_Code

  • Required: NO

  • Data Type: STRING

  • Description: Custom code assigned to the score for easy reference.

  • Formula

  • Required: NO

  • Data Type: STRING

  • Description: Mathematical or logical expression used to calculate the score.

  • Formula_Description

  • Required: NO

  • Data Type: STRING

  • Description: Detailed explanation of how the formula works.

Parent Questions

  • Parent_Questions

  • Required: NO

  • Data Type: ARRAY

  • Description: Collection of questions that contribute to the score.

  • Template_Question_Key

  • Required: NO

  • Data Type: STRING

  • Description: Unique identifier for a parent question.

  • Question_ID

  • Required: NO

  • Data Type: STRING

  • Description: System-generated ID for the parent question.

  • Question_Custom_Code

  • Required: NO

  • Data Type: STRING

  • Description: Custom code assigned to the parent question.

  • Version_Number

  • Required: NO

  • Data Type: INT64

  • Description: Version number of the parent question.

  • Formula_Parameter

  • Required: NO

  • Data Type: STRING

  • Description: Parameter used in the score formula related to this question.

  • Created_Timestamp

  • Required: NO

  • Data Type: TIMESTAMP

  • Description: Timestamp of when the parent question was created.

  • Last_Modified_Timestamp

  • Required: NO

  • Data Type: TIMESTAMP

  • Description: Timestamp of when the parent question was last modified.

Evaluations

  • Evaluations

  • Required: NO

  • Data Type: ARRAY

  • Description: Collection of evaluations for the score.

  • Template_Evaluation_Key

  • Required: NO

  • Data Type: STRING

  • Description: Unique identifier for a specific evaluation.

  • Evaluation_Custom_Code

  • Required: NO

  • Data Type: STRING

  • Description: Custom code assigned to the evaluation.

  • Position

  • Required: NO

  • Data Type: INT64

  • Description: Position or order of the evaluation.

  • Minimum_Value

  • Required: NO

  • Data Type: NUMERIC

  • Description: Minimum value for this evaluation range.

  • Maximum_Value

  • Required: NO

  • Data Type: NUMERIC

  • Description: Maximum value for this evaluation range.

  • Description

  • Required: NO

  • Data Type: STRING

  • Description: Description of what this evaluation range represents.

  • Child_Template_Question_Keys

  • Required: NO

  • Data Type: ARRAY

  • Description: List of question keys relevant to this evaluation.

Problems

  • Problems

  • Required: NO

  • Data Type: ARRAY

  • Description: Collection of potential problems associated with this evaluation.

  • Code

  • Required: NO

  • Data Type: STRING

  • Description: Code or identifier for a specific problem.

  • Description

  • Required: NO

  • Data Type: STRING

  • Description: Detailed description of the problem.

Tasks

  • Tasks

  • Required: NO

  • Data Type: ARRAY

  • Description: Collection of tasks associated with this evaluation.

  • Key

  • Required: NO

  • Data Type: STRING

  • Description: Unique identifier for a specific task.

  • Priority

  • Required: NO

  • Data Type: STRING

  • Description: Priority level of the task.

  • Priority_Description

  • Required: NO

  • Data Type: STRING

  • Description: Description of the priority level.

  • Reason

  • Required: NO

  • Data Type: STRING

  • Description: Reason for assigning the task.

  • Reason_Description

  • Required: NO

  • Data Type: STRING

  • Description: Detailed explanation of the reason for assigning the task.

Assessment Dataset Specification

Assessment Template Block Log

Scores

Evaluations

  • Tasks.Type

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Type or category of the task.

  • Tasks.Type_Description

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Description of the task type.

  • Tasks.Additional_Action

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Any additional action required for the task.

  • Tasks.Additional_Action_Description

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Detailed description of the additional action.

  • Notifications

  • Is Nullable: NO

  • Data Type: ARRAY

  • Description: Collection of notifications associated with this evaluation.

  • Notifications.Key

    • Is Nullable: NO

    • Data Type: STRING

    • Description: Unique identifier for a specific notification.

  • Notifications.Urgent

    • Is Nullable: NO

    • Data Type: BOOL

    • Description: Indicates whether the notification is urgent.

  • Notifications.Text

    • Is Nullable: NO

    • Data Type: STRING

    • Description: Content of the notification message.

  • Notifications.Title

    • Is Nullable: NO

    • Data Type: STRING

    • Description: Title or subject of the notification.

  • Auto_Workflows

  • Is Nullable: NO

  • Data Type: ARRAY

  • Description: Collection of automated workflows associated with this evaluation.

  • Auto_Workflows.Key

    • Is Nullable: NO

    • Data Type: STRING

    • Description: Unique identifier for a specific workflow.

  • Auto_Workflows.Rule_Code

    • Is Nullable: NO

    • Data Type: STRING

    • Description: Code representing the rule that triggers the workflow.

  • Auto_Workflows.Rule_Name

    • Is Nullable: NO

    • Data Type: STRING

    • Description: Name of the rule that triggers the workflow.

Position

  • Scores.Position

  • Is Nullable: NO

  • Data Type: STRING

  • Description: The position or order of the score within the block or template.

Record Metadata

  • Record_Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp of when the record was last modified.

  • Transaction_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the person who performed the transaction.

  • Deleted_Indicator

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates whether the record has been marked as deleted.

  • Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type or category of the record.

  • Tenant

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the tenant or organization.

  • Active_Version

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates whether this is the active version of the block.

  • Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: Date of the record.

  • Sequence

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Sequence number for ordering.

  • Source_System_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the source system.

  • Source_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp from the source system.

  • Source_File_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the source file.

  • Schema_Version

  • Is Nullable: YES

  • Data Type: FLOAT64

  • Description: Version of the schema used.

  • _updated

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Timestamp of the last update.

  • Action

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Action performed on the record (e.g., insert, update, delete).

  • Transaction_Actor_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of the actor performing the transaction.

Assessment Template Log

General Information

  • Version_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for the version of the assessment template.

  • Assessment_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for the assessment.

  • Assessment_Custom_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Custom code associated with the assessment.

  • Correlation_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier used to correlate the assessment template with other related records.

  • Version_Number

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Number representing the version of the assessment template.

  • Reference

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Reference information associated with the assessment template.

  • Assessment_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the assessment.

  • Assessment_Alias

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Alias of the assessment.

Status Information

  • Status

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Status of the assessment template.

  • Status_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the assessment template's status.

Location Information

  • Location_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for the location associated with the assessment template.

  • Location_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the location associated with the assessment template.

  • Location_Path

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Path indicating the location hierarchy.

User and Logic Information

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier of the user who created the assessment template.

  • Logic_Applied

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates if logic has been applied to the assessment template.

  • Scoring_Applied

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates if scoring has been applied to the assessment template.

  • Published

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates if the assessment template has been published.

Tags

  • Tags

  • Is Nullable: NO

  • Data Type: ARRAY

  • Description: Array of tags associated with the assessment template.

  • Tags.Key

    • Is Nullable: NO

    • Data Type: INT64

    • Description: Unique identifier for the tag.

  • Tags.Name

    • Is Nullable: NO

    • Data Type: STRING

    • Description: Name of the tag.

Types

  • Types

  • Is Nullable: NO

  • Data Type: ARRAY

  • Description: Array of types associated with the assessment template.

  • Types.Programs

    • Is Nullable: NO

    • Data Type: ARRAY

    • Description: Array of programs associated with the type.

Assessment Dataset Specification

Types

Code

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Code representing the type.

Description

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Description of the type.

Domain

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Domain associated with the type.

Configs

  • Is Nullable: NO

  • Data Type: ARRAY

  • Description: A collection or array of configuration settings for different types within the system.

Config_Key

  • Is Nullable: NO

  • Data Type: STRING

  • Description: A unique identifier for each configuration setting, used to reference specific configurations.

Config_Code

  • Is Nullable: NO

  • Data Type: STRING

  • Description: A short code or abbreviation representing the configuration, often used for quick reference or in system processes.

Config_Description

  • Is Nullable: NO

  • Data Type: STRING

  • Description: A detailed explanation or description of what the configuration setting does or represents.

Config_Values

  • Is Nullable: NO

  • Data Type: ARRAY

  • Description: The possible values or options that can be set for this particular configuration.

Assessment_Template_log

Blocks

  • Is Nullable: NO

  • Data Type: ARRAY

  • Description: Array of blocks associated with the assessment template.

Position

  • Is Nullable: NO

  • Data Type: INT64

  • Description: Position of the block within the assessment template.

Version_Key

  • Is Nullable: NO

  • Data Type: INT64

  • Description: Unique identifier for the version of the block.

Block_ID

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Identifier for the block.

Correlation_ID

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Identifier used to correlate the block with other related records.

Version_Number

  • Is Nullable: NO

  • Data Type: INT64

  • Description: Version number of the block.

Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the assessment template was created.

Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the assessment template was last modified.

Record_Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the record was last modified.

Transaction_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

Deleted_Indicator

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicator whether the assessment template is deleted.

Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of the assessment template log entry.

Tenant

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Tenant associated with the assessment template log entry.

Active_Version

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates if the assessment template is the active version.

Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: Date associated with the assessment template log entry.

Sequence

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Sequence number of the assessment template log entry.

Source_System_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the source system from where the assessment template data originated.

Source_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the data was sourced.

Source_File_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the source file from where the assessment template data was sourced.

Schema_Version

  • Is Nullable: YES

  • Data Type: FLOAT64

  • Description: Version of the schema used for the assessment template log entry.

_updated

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Timestamp indicating the last update of the record.

Action

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Action taken on the assessment template log entry.

Transaction_Actor_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of the actor performing the transaction.

Assessment_Response_raw

Assessment_Response_Key

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for the assessment response.

Assessment_Response_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the assessment response.

Assessment_Custom_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Custom code associated with the assessment.

Member_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for the member associated with the assessment response.

Program_Screening_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Key for the program screening associated with the assessment response.

Program

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the program associated with the assessment response.

Program_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the program associated with the assessment response.

Request_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Key for the request associated with the assessment response.

Digital

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates if the assessment response is digital.

Status

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Status of the assessment response.

Status_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the status of the assessment response.

Source

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Source of the assessment response.

Source_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the source of the assessment response.

Assessment_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of the assessment.

Assessment_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the assessment type.

Domain

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Domain associated with the assessment response.

Template

  • Is Nullable: YES

  • Data Type: STRUCT

  • Description: Template information for the assessment response.

Template.Version_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: A unique key representing the version of the assessment response template.

Template.Correlation_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A correlation ID that links the assessment response to related data or processes.

Template.Assessment_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique identifier for the specific assessment instance.

Template.Assessment_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name or title of the assessment conducted.

Template.Assessment_Custom_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Custom code associated with the assessment.

Template.Reference

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A reference field used to provide additional context or information.

Assessment Dataset Specification

Assessment Response Raw

Fields

  • Template.Version_Number

  • Nullable: YES

  • Data Type: INT64

  • Description: The version number of the assessment, indicating updates or revisions made.

  • Template.Assessment_Custom_Code

  • Nullable: YES

  • Data Type: STRING

  • Description: Custom code associated with the assessment.

  • Auto_Workflows

  • Nullable: NO

  • Data Type: ARRAY

  • Description: Array of automatic workflows associated with the assessment response.

  • Auto_Workflows.Created_Timestamp

    • Nullable: NO

    • Data Type: TIMESTAMP

    • Description: Timestamp when the automatic workflow was created.

  • Auto_Workflows.Rule

    • Nullable: NO

    • Data Type: STRING

    • Description: Rule associated with the automatic workflow.

  • Additional_Actions

  • Nullable: NO

  • Data Type: ARRAY

  • Description: Array of additional actions associated with the assessment response.

  • Additional_Actions.Code

    • Nullable: NO

    • Data Type: STRING

    • Description: Code representing the additional action.

  • Additional_Actions.Description

    • Nullable: NO

    • Data Type: STRING

    • Description: Description of the additional action.

  • Answered_By_User_ID

  • Nullable: YES

  • Data Type: STRING

  • Description: Identifier of the user who answered the assessment response.

  • Created_Timestamp

  • Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the assessment response was created.

  • Last_Modified_Timestamp

  • Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the assessment response was last modified.

  • Record_Last_Modified_Timestamp

  • Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the record was last modified.

  • Transaction_User_ID

  • Nullable: YES

  • Data Type: STRING

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

  • Deleted_Indicator

  • Nullable: YES

  • Data Type: BOOL

  • Description: Indicator whether the assessment response is deleted.

  • Type

  • Nullable: YES

  • Data Type: STRING

  • Description: Type of the assessment response.

  • Tenant

  • Nullable: YES

  • Data Type: STRING

  • Description: Tenant associated with the assessment response.

  • Active_Version

  • Nullable: YES

  • Data Type: BOOL

  • Description: Indicates if the assessment response is the active version.

  • Date

  • Nullable: YES

  • Data Type: DATE

  • Description: Date associated with the assessment response.

  • Sequence

  • Nullable: YES

  • Data Type: INT64

  • Description: Sequence number of the assessment response.

  • Source_System_Name

  • Nullable: YES

  • Data Type: STRING

  • Description: Name of the source system from where the assessment response data originated.

  • Source_Timestamp

  • Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the data was sourced.

  • Source_File_Name

  • Nullable: YES

  • Data Type: STRING

  • Description: Name of the source file from where the assessment response data was sourced.

  • Schema_Version

  • Nullable: YES

  • Data Type: FLOAT64

  • Description: Version of the schema used for the assessment response.

  • Member_Partition

  • Nullable: YES

  • Data Type: INT64

  • Description: Partition identifier for the member.

  • _updated

  • Nullable: YES

  • Data Type: STRING

  • Description: Timestamp indicating the last update of the record.

  • Program_ID

  • Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the program.

  • Request_ID

  • Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the request.

  • Answered_By_Member_ID

  • Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the member who answered the assessment.

  • Transaction_Actor_Type

  • Nullable: YES

  • Data Type: STRING

  • Description: Type of the actor performing the transaction.

Assessment Response Question Raw

Fields

  • Assessment_Response_Question_Key

  • Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for the assessment response question.

  • Assessment_Response_Key

  • Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for the assessment response.

  • Assessment_Response_Question_ID

  • Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the assessment response question.

  • Template

  • Nullable: YES

  • Data Type: STRUCT

  • Description: Template information for the assessment response question.

  • Template.Assessment_ID

    • Nullable: YES

    • Data Type: STRING

    • Description: Unique identifier for the assessment linked to the response question.

  • Template.Version_Key

    • Nullable: YES

    • Data Type: INT64

    • Description: Unique key representing the version of the assessment template.

  • Template.Version_Number

    • Nullable: YES

    • Data Type: INT64

    • Description: The version number of the assessment, indicating which iteration of the template is used.

  • Template.Template_Question_Key

    • Nullable: YES

    • Data Type: STRING

    • Description: Unique key identifying the specific question within the template.

  • Template.Question_ID

    • Nullable: YES

    • Data Type: STRING

    • Description: Unique identifier for the question in the assessment.

  • Template.Block_ID

    • Nullable: YES

    • Data Type: STRING

    • Description: Unique identifier for the block in which this question resides, representing a group of related questions.

  • Template.Block_Custom_Code

    • Nullable: YES

    • Data Type: STRING

    • Description: Custom code associated with the block.

  • Template.Assessment_Custom_Code

    • Nullable: YES

    • Data Type: STRING

    • Description: Custom code associated with the assessment.

  • Template.Block_Version_Key

    • Nullable: YES

    • Data Type: INT64

    • Description: Unique key representing the version of the block.

  • Template.Block_Version_Number

    • Nullable: YES

    • Data Type: INT64

    • Description: The version number of the block, indicating updates or changes to the block.

  • Template.Question_Reference

    • Nullable: YES

    • Data Type: STRING

    • Description: Reference information for the question, providing additional context or details related to the question.

  • Template.Question_Custom_Code

    • Nullable: YES

    • Data Type: STRING

    • Description: Custom code associated with the question.

  • Member_ID

  • Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for the member associated with the assessment response question.

  • Position

  • Nullable: YES

  • Data Type: INT64

  • Description: Position of the question within the assessment response.

  • Related_Assessment_Response_Score_Keys

  • Nullable: NO

  • Data Type: ARRAY

  • Description: Array of keys for the related assessment response scores.

  • Child_Question_Indicator

  • Nullable: YES

  • Data Type: BOOL

  • Description: Indicator if the question is a child question. The default value is false.

  • Parent_Assessment_Response_Question_Key

  • Nullable: YES

  • Data Type: STRING

  • Description: Key for the parent assessment response question.

Assessment Dataset Specification

Assessment Response Question Raw

Fields

  • Question_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of the question.

  • Question_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the question type.

  • Question

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Text of the question.

  • Response_Value

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Value of the response.

  • Response_Value_String

  • Is Nullable: YES

  • Data Type: STRING

  • Description: String representation of the response value.

  • Response_Value_Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: Date representation of the response value.

  • Response_Value_Number

  • Is Nullable: YES

  • Data Type: NUMERIC

  • Description: Numeric representation of the response value.

  • Answered

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicator if the question was answered. The default value is false.

  • Required

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicator if the question is required. The default value is false.

  • Answered_By_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier of the user who answered the question.

  • Source

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Source of the question.

  • Source_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the source of the question.

  • Selected_Responses

  • Is Nullable: NO

  • Data Type: ARRAY

  • Description: Array of selected responses for the question.

Selected Responses Fields

  • Position

  • Is Nullable: NO

  • Data Type: INT64

  • Description: The position of the selected response in the sequence of available responses for the question.

  • Weight

  • Is Nullable: NO

  • Data Type: INT64

  • Description: The weight assigned to the selected response, representing its importance or influence in the assessment scoring.

  • Response_Template_Key

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Unique key linking the selected response to the response template for consistent reference across assessments.

  • Value

  • Is Nullable: NO

  • Data Type: STRING

  • Description: The actual value provided in response to the question, as recorded in the assessment.

  • Value_Code

  • Is Nullable: NO

  • Data Type: STRING

  • Description: The code representing the response value, used for standardized tracking and categorization of responses.

  • Child_Assessment_Response_Question_Keys

  • Is Nullable: NO

  • Data Type: ARRAY

  • Description: An array of keys linking to related child questions, indicating any dependent or follow-up questions triggered by this response.

  • Response_Custom_Code

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Custom code associated with the selected response.

Additional Fields

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the assessment response question was created.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the assessment response question was last modified.

  • Record_Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the record was last modified.

  • Transaction_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Deleted_Indicator

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicator whether the assessment response question is deleted.

  • Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of the assessment response question.

  • Tenant

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Tenant associated with the assessment response question.

  • Active_Version

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates if the assessment response question is the active version.

  • Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: Date associated with the assessment response question.

  • Sequence

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Sequence number of the assessment response question.

  • Source_System_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the source system from where the assessment response question data originated.

  • Source_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the data was sourced.

  • Source_File_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the source file from where the assessment response question data was sourced.

  • Schema_Version

  • Is Nullable: YES

  • Data Type: FLOAT64

  • Description: Version of the schema used for the assessment response question.

  • Member_Partition

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Partition identifier for the member.

  • _updated

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Timestamp indicating the last update of the record.

  • Parent_Assessment_Response_Score_Key

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Key for the parent assessment response score.

  • Parent_Assessment_Response_Score_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the parent assessment response score.

  • Answered_By_Member_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the member who answered the question.

  • Transaction_Actor_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of the actor performing the transaction.

Assessment Response Score Raw

Fields

  • Assessment_Response_Score_Key

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for the assessment response score.

  • Assessment_Response_Key

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for the assessment response.

  • Assessment_Response_Score_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the assessment response score.

  • Template

  • Is Nullable: YES

  • Data Type: STRUCT

  • Description: Template information for the assessment response score.

Template Fields

  • Assessment_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for the assessment associated with the response score.

  • Version_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Key representing the version of the assessment being used.

  • Version_Number

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Version number of the assessment.

Assessment Dataset Specification

Template Fields

Template_Score_Key

  • Required: YES

  • Type: STRING

  • Description: Unique key identifying the specific template score used in the assessment.

Score_Custom_Code

  • Required: YES

  • Type: STRING

  • Description: Custom code associated with the score.

Score_ID

  • Required: YES

  • Type: STRING

  • Description: Identifier for the score within the assessment template.

Block_Version_Key

  • Required: YES

  • Type: INT64

  • Description: Key representing the version of the block containing the score.

Block_ID

  • Required: YES

  • Type: STRING

  • Description: Unique identifier for the block within the assessment structure.

Block_Custom_Code

  • Required: YES

  • Type: STRING

  • Description: Custom code associated with the block.

Assessment_Custom_Code

  • Required: YES

  • Type: STRING

  • Description: Custom code associated with the assessment.

Block_Version_Number

  • Required: YES

  • Type: INT64

  • Description: Version number of the block, indicating any updates or changes to the block.

Score_Reference

  • Required: YES

  • Type: STRING

  • Description: Reference to the specific score or calculation used within the assessment, providing context or details.

Assessment Response Score Fields

Member_ID

  • Required: YES

  • Type: STRING

  • Description: Unique identifier for the member associated with the assessment response score.

Score_Name

  • Required: YES

  • Type: STRING

  • Description: Name of the score.

Matched_Evaluation

  • Required: YES

  • Type: STRUCT

  • Description: Information about the matched evaluation for the score.

Matched_Evaluation.Description

  • Required: YES

  • Type: STRING

  • Description: A detailed description of the matched evaluation used in the assessment response score.

Matched_Evaluation.Minimum_Value

  • Required: YES

  • Type: NUMERIC

  • Description: The minimum value allowed or expected for this evaluation.

Matched_Evaluation.Maximum_Value

  • Required: YES

  • Type: NUMERIC

  • Description: The maximum value allowed or expected for this evaluation.

Matched_Evaluation.Child_Assessment_Response_Questions

  • Required: YES

  • Type: ARRAY

  • Description: The position of this evaluation in relation to other evaluations or scoring elements.

Child_Assessment_Response_Questions.Key

  • Required: YES

  • Type: STRING

  • Description: Key for the maximum value of the matched evaluation.

Child_Assessment_Response_Questions.ID

  • Required: YES

  • Type: STRING

  • Description: Identifier for the maximum value of the matched evaluation.

Matched_Evaluation.Position

  • Required: YES

  • Type: INT64

  • Description: The position or order in which this evaluation appears within the assessment.

Matched_Evaluation.Evaluation_Custom_Code

  • Required: YES

  • Type: STRING

  • Description: Custom code associated with the matched evaluation.

Matched_Evaluation.Template_Evaluation_Key

  • Required: YES

  • Type: STRING

  • Description: The unique key identifying the evaluation template used in this assessment response.

Formula

  • Required: YES

  • Type: STRING

  • Description: Formula used to calculate the score.

Formula_Description

  • Required: YES

  • Type: STRING

  • Description: Description of the formula used for the score calculation.

Parent_Assessment_Response_Questions

  • Required: NO

  • Type: ARRAY

  • Description: Array of parent assessment response questions related to the score.

Parent_Assessment_Response_Questions.Key

  • Required: NO

  • Type: STRING

  • Description: A unique identifier key for the parent assessment response question.

Parent_Assessment_Response_Questions.ID

  • Required: NO

  • Type: STRING

  • Description: The ID associated with the parent assessment response question.

Parent_Assessment_Response_Questions.Formula_Parameter

  • Required: NO

  • Type: STRING

  • Description: A parameter used in the formula or calculation related to the parent assessment response question.

Total_Score

  • Required: YES

  • Type: FLOAT64

  • Description: Total score calculated for the assessment response.

Created_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp when the assessment response score was created.

Last_Modified_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp when the assessment response score was last modified.

Record_Last_Modified_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp when the record was last modified.

Transaction_User_ID

  • Required: YES

  • Type: STRING

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

Deleted_Indicator

  • Required: YES

  • Type: BOOL

  • Description: Indicator whether the assessment response score is deleted.

Type

  • Required: YES

  • Type: STRING

  • Description: Type of the assessment response score.

Tenant

  • Required: YES

  • Type: STRING

  • Description: Tenant associated with the assessment response score.

Active_Version

  • Required: YES

  • Type: BOOL

  • Description: Indicates if the assessment response score is the active version.

Date

  • Required: YES

  • Type: DATE

  • Description: Date associated with the assessment response score.

Sequence

  • Required: YES

  • Type: INT64

  • Description: Sequence number of the assessment response score.

Source_System_Name

  • Required: YES

  • Type: STRING

  • Description: Name of the source system from where the assessment response score data originated.

Source_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp when the data was sourced.

Source_File_Name

  • Required: YES

  • Type: STRING

  • Description: Name of the source file from where the assessment response score data was sourced.

Schema_Version

  • Required: YES

  • Type: FLOAT64

  • Description: Version of the schema used for the assessment response score.

Member_Partition

  • Required: YES

  • Type: INT64

  • Description: Partition identifier for the member.

_updated

  • Required: YES

  • Type: STRING

  • Description: Timestamp indicating the last update of the record.

Transaction_Actor_Type

  • Required: YES

  • Type: STRING

  • Description: Type of the actor performing the transaction.

Assessment Dataset Specification

Assessment Template Block Raw

Table Structure

Column Name

Is Nullable

Data Type

Description

Version_Key

YES

INT64

Unique identifier for the version of the assessment template block.

Block_ID

YES

STRING

Unique identifier for the block.

Block_Custom_Code

YES

STRING

Custom code associated with the block.

Correlation_ID

YES

STRING

Correlation identifier for the block.

Version_Number

YES

INT64

Version number of the block.

Reference

YES

STRING

Reference information for the block.

Block_Name

YES

STRING

Name of the block.

Status

YES

STRING

Status of the block.

Status_Description

YES

STRING

Description of the block status.

Location_Key

YES

INT64

Unique identifier for the location associated with the block.

Location_Name

YES

STRING

Name of the location associated with the block.

Location_Path

YES

STRING

Path of the location associated with the block.

Created_User_ID

YES

STRING

Identifier of the user who created the block.

Reusable

YES

BOOL

Indicates whether the block is reusable.

Created_Timestamp

YES

TIMESTAMP

Timestamp when the block was created.

Last_Modified_Timestamp

YES

TIMESTAMP

Timestamp when the block was last modified.

Questions

NO

ARRAY

Array of questions associated with the block.

Questions

Table Structure

Column Name

Is Nullable

Data Type

Description

Template_Question_Key

NO

INT64

Unique identifier for the template question.

Position

NO

INT64

Position of the question within the block.

Question

NO

STRING

Text of the question.

Question_Type

NO

STRING

Type of the question.

Question_Type_Description

NO

STRING

Description of the question type.

Reference

NO

STRING

Reference information for the question.

Question_ID

NO

STRING

Unique identifier for the question.

Responses.Response_Custom_Code

NO

STRING

Custom code associated with the response.

Required

NO

BOOL

Indicates whether the question is required.

Version_Number

NO

INT64

Version number of the question.

Created_Timestamp

NO

TIMESTAMP

Timestamp when the question was created.

Last_Modified_Timestamp

NO

TIMESTAMP

Timestamp when the question was last modified.

Responses

NO

ARRAY

Array of responses associated with the question.

Responses

Table Structure

Column Name

Is Nullable

Data Type

Description

Response_Template_Key

NO

INT64

Unique identifier for the response template.

Position

NO

INT64

Position of the response within the question.

Value

NO

STRING

Value of the response.

Value_Code

NO

STRING

Code representing the value of the response.

Weight

NO

INT64

Weight assigned to the response.

Created_Timestamp

NO

TIMESTAMP

Timestamp when the response was created.

Last_Modified_Timestamp

NO

TIMESTAMP

Timestamp when the response was last modified.

Child_Template_Question_Key

NO

ARRAY

Array of keys for child template questions related to the response.

Problems

NO

ARRAY

Array of problems associated with the response.

Problems

Table Structure

Column Name

Is Nullable

Data Type

Description

Code

NO

STRING

Code representing the problem.

Description

NO

STRING

Description of the problem.

Created_Timestamp

NO

TIMESTAMP

Timestamp when the problem was created.

Last_Modified_Timestamp

NO

TIMESTAMP

Timestamp when the problem was last modified.

Tasks

Table Structure

Column Name

Is Nullable

Data Type

Description

TasksKey

NO

INT64

Unique identifier for the task.

TasksData

NO

STRING

Data associated with the task.

TasksAdditional_Action

NO

STRING

Additional action associated with the task.

TasksAdditional_Action_Description

NO

STRING

Description of the additional action.

TasksCreated_Timestamp

NO

TIMESTAMP

Timestamp when the task was created.

TasksLast_Modified_Timestamp

NO

TIMESTAMP

Timestamp when the task was last modified.

Notifications

Table Structure

Column Name

Is Nullable

Data Type

Description

Notifications.Key

NO

INT64

Unique identifier for the notification.

Notifications.Data

NO

STRING

Data associated with the notification.

Notifications.Created_Timestamp

NO

TIMESTAMP

Timestamp when the notification was created.

Notifications.Last_Modified_Timestamp

NO

TIMESTAMP

Timestamp when the notification was last modified.

Auto Workflows

Table Structure

Column Name

Is Nullable

Data Type

Description

Auto_Workflows.Key

NO

INT64

Unique identifier for the automated workflow.

Auto_Workflows.Data

NO

STRING

Data associated with the automated workflow.

Auto_Workflows.Created_Timestamp

NO

TIMESTAMP

Timestamp when the automated workflow was created.

Auto_Workflows.Last_Modified_Timestamp

NO

TIMESTAMP

Timestamp when the automated workflow was last modified.

Assessment Dataset Specification

Fields and Descriptions

ows.Last_Modified_Timestamp

  • Type: TIMESTAMP

  • Required: NO

  • Description: Timestamp when the automated workflow was last modified.

Assessment Template Block Raw

Scores

Scores.Template_Score_Key

  • Type: STRING

  • Required: NO

  • Description: Unique identifier for a specific score within the template.

Scores.Score_Name

  • Type: STRING

  • Required: NO

  • Description: The name or label given to the score.

Scores.Reference

  • Type: STRING

  • Required: NO

  • Description: A reference or citation related to the score.

Scores.Score_ID

  • Type: STRING

  • Required: NO

  • Description: An identifier for the score, possibly used in the system.

Scores.Score_Custom_Code

  • Type: STRING

  • Required: NO

  • Description: A custom code assigned to the score for easy reference.

Scores.Formula

  • Type: STRING

  • Required: NO

  • Description: The mathematical or logical expression used to calculate the score.

Scores.Formula_Description

  • Type: STRING

  • Required: NO

  • Description: A detailed explanation of how the formula works or what it represents.

Scores.Parent_Questions

  • Type: ARRAY

  • Required: NO

  • Description: A collection of questions that contribute to or influence the score.

Fields within Scores.Parent_Questions

  • Template_Question_Key: Unique identifier for a specific question within the template.

  • Question_ID: An identifier for the question, possibly used in the system.

  • Question_Custom_Code: A custom code assigned to the question for easy reference.

  • Version_Number: The version number of the question, indicating revisions or updates.

  • Formula_Parameter: The parameter used in the score formula related to this question.

  • Created_Timestamp: Timestamp indicating when the question was created.

  • Last_Modified_Timestamp: Timestamp indicating when the question was last modified.

Scores.Evaluations

  • Type: ARRAY

  • Required: NO

  • Description: A collection of evaluation criteria for the score.

Fields within Scores.Evaluations

  • Template_Evaluation_Key: Unique identifier for a specific evaluation within the template.

  • Evaluation_Custom_Code: A custom code assigned to the evaluation for easy reference.

  • Position: The position or order of the evaluation in the list.

  • Minimum_Value: The lowest possible value for this evaluation range.

  • Maximum_Value: The highest possible value for this evaluation range.

  • Description: A detailed explanation of what this evaluation range represents.

  • Child_Template_Question_Keys: A list of question keys that are relevant to this evaluation.

  • Problems: A collection of potential problems associated with this evaluation range.

Fields within Scores.Evaluations.Problems

  • Code: A code or identifier for a specific problem.

  • Description: A detailed explanation of the problem.

Fields within Scores.Evaluations.Tasks

  • Key: Unique identifier for a specific task.

  • Priority: The priority level assigned to the task.

  • Priority_Description: A description of what the priority level means.

  • Reason: The reason for assigning this task.

  • Reason_Description: A detailed explanation of the reason for the task.

  • Type: The type or category of the task.

  • Type_Description: A description of what the task type means.

  • Additional_Action: Any additional action required for the task.

  • Additional_Action_Description: A detailed explanation of the additional action.

Fields within Scores.Evaluations.Notifications

  • Key: Unique identifier for a specific notification.

  • Urgent: A boolean indicating if the notification is urgent.

  • Text: The content of the notification message.

  • Title: The title or subject of the notification.

Fields within Scores.Evaluations.Auto_Workflows

  • Key: Unique identifier for a specific workflow.

  • Rule_Code: A code representing the rule that triggers the workflow.

  • Rule_Name: The name of the rule that triggers the workflow.

Scores.Position

  • Type: STRING

  • Required: NO

  • Description: The position or order of the score within the block or template.

Additional Fields in Assessment_Template_Block_raw

Record_Last_Modified_Timestamp

  • Type: TIMESTAMP

  • Required: YES

  • Description: Timestamp when the record was last modified.

Transaction_User_ID

  • Type: STRING

  • Required: YES

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

Deleted_Indicator

  • Type: BOOL

  • Required: YES

  • Description: Indicator whether the block is deleted.

Type

  • Type: STRING

  • Required: YES

  • Description: Type of the block.

Tenant

  • Type: STRING

  • Required: YES

  • Description: Tenant associated with the block.

Active_Version

  • Type: BOOL

  • Required: YES

  • Description: Indicates if the block is the active version.

Date

  • Type: DATE

  • Required: YES

  • Description: Date associated with the block.

Assessment Dataset Specification

Assessment Template Block Raw

Fields

  • Sequence

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Sequence number of the block.

  • Source_System_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the source system from where the block data originated.

  • Source_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the data was sourced.

  • Source_File_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the source file from where the block data was sourced.

  • Schema_Version

  • Is Nullable: YES

  • Data Type: FLOAT64

  • Description: Version of the schema used for the block.

  • _updated

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Timestamp indicating the last update of the record.

  • Transaction_Actor_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of the actor performing the transaction.

Assessment Template Raw

Fields

  • Version_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for the version of the assessment template.

  • Assessment_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for the assessment.

  • Assessment_Custom_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Custom code associated with the assessment.

  • Correlation_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Correlation identifier for the assessment.

  • Version_Number

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Version number of the assessment.

  • Reference

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Reference information for the assessment.

  • Assessment_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the assessment.

  • Assessment_Alias

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Alias of the assessment.

  • Status

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Status of the assessment.

  • Status_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the assessment status.

  • Location_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for the location associated with the assessment.

  • Location_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the location associated with the assessment.

  • Location_Path

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Path of the location associated with the assessment.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier of the user who created the assessment.

  • Logic_Applied

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates whether logic is applied in the assessment.

  • Scoring_Applied

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates whether scoring is applied in the assessment.

  • Published

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates whether the assessment is published.

  • Tags

  • Is Nullable: NO

  • Data Type: ARRAY

  • Description: Array of tags associated with the assessment.

Tags Fields

  • Tags.Key

  • Is Nullable: NO

  • Data Type: INT64

  • Description: Unique identifier for the tag.

  • Tags.Name

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Name of the tag.

  • Types.Configs

  • Is Nullable: NO

  • Data Type: ARRAY

  • Description: A collection or array of configuration settings for different types within the system.

Types.Configs Fields

  • Types.Configs.Config_Key

  • Is Nullable: NO

  • Data Type: STRING

  • Description: A unique identifier for each configuration setting, used to reference specific configurations.

  • Types.Configs.Config_Code

  • Is Nullable: NO

  • Data Type: STRING

  • Description: A short code or abbreviation representing the configuration, often used for quick reference or in system processes.

  • Types.Configs.Config_Description

  • Is Nullable: NO

  • Data Type: STRING

  • Description: A detailed explanation or description of what the configuration setting does or represents.

  • Types.Configs.Config_Values

  • Is Nullable: NO

  • Data Type: ARRAY

  • Description: The possible values or options that can be set for this particular configuration.

  • Blocks

  • Is Nullable: NO

  • Data Type: ARRAY

  • Description: Array of blocks associated with the assessment.

Blocks Fields

  • Blocks.Position

  • Is Nullable: NO

  • Data Type: INT64

  • Description: Position of the block within the assessment.

  • Blocks.Version_Key

  • Is Nullable: NO

  • Data Type: INT64

  • Description: Unique identifier for the version of the block.

  • Blocks.Block_ID

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Unique identifier for the block.

  • Blocks.Correlation_ID

  • Is Nullable: NO

  • Data Type: STRING

  • Description: Correlation identifier for the block.

  • Blocks.Version_Number

  • Is Nullable: NO

  • Data Type: INT64

  • Description: Version number of the block.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the assessment was created.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the assessment was last modified.

  • Record_Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the record was last modified.

  • Transaction_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Deleted_Indicator

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicator whether the assessment is deleted.

  • Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of the assessment.

  • Tenant

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Tenant associated with the assessment.

  • Active_Version

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates if the assessment is the active version.

  • Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: Date associated with the assessment.

  • Sequence

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Sequence number associated with the assessment.

  • Source_System_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the source system.

  • Source_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp of the source system.

  • Source_File_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the source file.

  • Schema_Version

  • Is Nullable: YES

  • Data Type: FLOAT64

  • Description: Version of the schema.

  • _updated

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Timestamp of the last update.

  • Transaction_Actor_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of the actor performing the transaction.

Related Articles
Did this answer your question?