Skip to main content

Questionnaire Dataset Specification

Questionnaire Dataset Specification

Questionnaire Dataset Specification

The "Questionnaire Dataset Specification" contains metadata for the member program questionnaire in ACM. Questionnaire_Key is its unique key. It is referenced from questionnaire response by Questionnaire_Key.

Key Components of the Dataset

Comparing Scores

  • Includes tables that allow for the comparison of scores across different questionnaires, facilitating analysis of trends and performance over time.

Storing Questionnaire Scores

  • Captures scores from completed questionnaires, providing a basis for evaluating and monitoring respondent performance and changes.

Comparing Question Responses

  • Contains data for side-by-side comparison of responses to similar questions across different questionnaires or time periods, aiding in the detection of patterns and deviations.

Detailed Question Response Information

  • Stores in-depth details about each question's responses, including respondent demographics and context, enhancing the depth of data analysis.

Logging Questionnaire Activities and Metadata

  • Tracks updates, modifications, and usage of questionnaires, providing a detailed audit trail that helps maintain data integrity and history.

  • Holds unprocessed, detailed data about questionnaire metadata, crucial for conducting detailed investigations and historical comparisons.

This dataset is crucial for organizations that utilize questionnaires as a tool for gathering information, providing them with the necessary resources to manage, track, and analyze data effectively, thereby optimizing the use of questionnaires and enhancing decision-making processes.

Table: Questionnaire_Score_Comparison

Columns and Descriptions

  • Member_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique identifier for each individual or member participating in the questionnaire.

  • Class

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Represents a classification or category associated with the member (e.g., patient class, risk group, etc.). See Dictionary Questionnaire Class table in the Dictionary Dataset Specification.

  • Class_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A textual description corresponding to the specific class or category assigned to the member. See Dictionary Questionnaire Class table in the Dictionary Dataset Specification.

  • Questionnaire_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Identifies the specific questionnaire administered to the member.

  • Questionnaire_Title

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The title or name of the questionnaire used for assessment.

  • Questionnaire_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A code or identifier associated with the questionnaire.

  • Dashboard_Indicator

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates whether the member’s scores are displayed on a dashboard or summary view.

  • Scoring_Function_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Refers to a specific scoring function used to calculate scores based on questionnaire responses.

  • Scoring_Function_Score_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Describes the meaning or interpretation of the scores generated by the scoring function.

  • Scoring_Function_Report_Title

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The title assigned to the report or summary that includes the member’s scores.

  • Scoring_Function_Formula

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Specifies the mathematical formula or algorithm used to compute scores.

  • Scoring_Function_Formula_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Provides a detailed explanation of how the scoring function formula operates.

  • Scoring_Function

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates the type of scoring method employed (e.g., Likert scale, weighted scoring, etc.).

  • Scoring_Function_Format_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Describes the format of the scores (e.g., numeric, categorical, etc.).

  • First_Score

  • Is Nullable: YES

  • Data Type: NUMERIC

  • Description: Represents the initial score obtained by the member during the assessment period.

  • First_Score_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

  • Latest_Score

  • Is Nullable: YES

  • Data Type: NUMERIC

  • Description: Denotes the most recent score achieved by the member.

  • Latest_Score_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

  • Days_Count_Between_First_Last_Scores

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Calculates the duration between the first and the latest recorded scores.

Questionnaire Dataset Specification

Overview

This section outlines the specifications for the dataset related to questionnaire responses and scoring within the Care Intelligence platform. Each column in the dataset is described in detail, including its name, data type, and purpose.

Questionnaire Scores Table

Member_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique identifier for each individual or member participating in the questionnaire.

Questionnaire_Response_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: A key or identifier associated with a specific response or submission within the questionnaire.

Class

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Represents a classification or category associated with the member (e.g., patient class, risk group, etc.).

  • See Dictionary Questionnaire Class table in the Dictionary Dataset Specification.

Class_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A textual description corresponding to the specific class or category assigned to the member.

  • See Dictionary Questionnaire Class table in the Dictionary Dataset Specification.

Response_Note

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Additional notes or comments related to the questionnaire response.

Complete_Indicator

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates whether the questionnaire response is complete or partially filled out.

Source

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The origin or channel through which the questionnaire data was collected (e.g., web form, paper survey).

Source_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Describes the source or method used to collect the questionnaire data.

Source_Entry_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the questionnaire response was entered or recorded.

Completed_By_Auto_Close

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates whether the completion of the questionnaire was automatically triggered (e.g., timed out).

Questionnaire_Response_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifies the user who last modified the questionnaire response.

Questionnaire_Response_Modified_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name of the user who last modified the questionnaire response.

Questionnaire_Response_Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the questionnaire response was initially created.

Questionnaire_Response_Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The most recent date and time when the questionnaire response was modified.

Questionnaire_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Identifies the specific questionnaire administered to the member.

Questionnaire_Version_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Refers to a specific version of the questionnaire.

Questionnaire_Version_Number

  • Is Nullable: YES

  • Data Type: INT64

  • Description: The numerical version number assigned to the questionnaire.

Questionnaire_Title

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The title or name of the questionnaire used for assessment.

Questionnaire_Version_Title

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Version of the title or name of the questionnaire used for assessment.

Questionnaire_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A code or identifier associated with the questionnaire.

Dashboard_Indicator

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates whether the member’s scores are displayed on a dashboard or summary view.

Questionnaire_Version_Last_Modified_Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: Date when the questionnaire version was modified.

Score_Response_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: A key or identifier associated with a specific score response within the questionnaire.

Calculated_Score

  • Is Nullable: YES

  • Data Type: NUMERIC

  • Description: The computed score based on questionnaire responses and scoring functions.

Score_Response_Void_Indicator

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates whether the score response has been voided or invalidated.

Score_Response_Void_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Score_Response_Void_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifies the user who voided the score response.

Score_Response_Void_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name of the user who voided the score response.

Score_Response_Void_Reason

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The reason or explanation for voiding the score response.

Score_Response_Void_Reason_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Provides a detailed description of the void reason.

Score_Response_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifies the user who last modified the score response.

Score_Response_Modified_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name of the user who last modified the score response.

Score_Response_Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Score_Response_Created_Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: The date when the score response was initially created.

Score_Response_Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The most recent date and time when the score response was modified.

Scoring_Function_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Refers to a specific scoring function used to calculate scores based on questionnaire responses.

Scoring_Function_Version_Number

  • Is Nullable: YES

  • Data Type: INT64

  • Description: The version number associated with the scoring function.

Scoring_Function_Score_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Describes the meaning or interpretation of the scores generated by the scoring function.

Scoring_Function_Score_Version_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Version of the score description.

Scoring_Function_Report_Title

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The title assigned to the report or summary that includes the member’s scores.

Scoring_Function_Version_Report_Title

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Version of the title assigned to the report or summary that includes the member’s scores.

Scoring_Function_Version_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Refers to a specific version of the scoring function.

Scoring_Function_Formula

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Specifies the mathematical formula or algorithm used to compute scores.

Questionnaire Dataset Specification

Questionnaire Scores

Scoring_Function_Formula_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Provides a detailed explanation of the mathematical formula or algorithm used to compute scores.

Scoring_Function

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates the type of scoring method employed (e.g., Likert scale, weighted scoring, etc.).

Scoring_Function_Format_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Describes the format of the scores (e.g., numeric, categorical, etc.).

Enrollment_Program

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Refers to the program or process through which individuals are enrolled or registered.

Screening_Program

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Pertains to the program or process used for screening or assessing individuals.

Program_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique identifier associated with a specific program or initiative.

First

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Represents the initial occurrence or value (e.g., first assessment, first score).

Latest

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Denotes the most recent occurrence or value (e.g., latest assessment, latest score).

First_Completed

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates whether the first assessment or task was completed.

Latest_Completed

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates whether the most recent assessment or task was completed.

Questionnaire Question Response Comparison

Member_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the member or patient.

Class

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Class identifier for the question response. See Dictionary Questionnaire Class table in the Dictionary Dataset Specification.

Class_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the class of the question response. See Dictionary Questionnaire Class table in the Dictionary Dataset Specification.

Question_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Identifier for the question in the response.

Full_Question_Clinical

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Full clinical question text.

Short_Question

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Abbreviated or shortened version of the question.

Question_Report_Title

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Title used for reporting purposes related to the question.

Question_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Code associated with the question.

Question_Response_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of response expected for the question. See Dictionary Response Type table in the Dictionary Dataset Specification.

Question_Display_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Display type for the question in the user interface.

Question_Response_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the question response type. See Dictionary Response Type table in the Dictionary Dataset Specification.

Question_Response_Value_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Data type of the response value. See Dictionary Response Value Type table in the Dictionary Dataset Specification.

Question_Response_Value_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the data type of the response value. See Dictionary Response Value Type table in the Dictionary Dataset Specification.

First_Response_Value_Text

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Textual value of the first response.

First_Response_Value_Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: Date value of the first response.

First_Response_Value_Number

  • Is Nullable: YES

  • Data Type: NUMERIC

  • Description: Numeric value of the first response.

First_Response_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp of the first response.

Latest_Response_Value_Text

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Textual value of the latest response.

Latest_Response_Value_Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: Date value of the latest response.

Latest_Response_Value_Number

  • Is Nullable: YES

  • Data Type: NUMERIC

  • Description: Numeric value of the latest response.

Latest_Response_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp of the latest response.

Days_Count_Between_First_Last_Responses

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Number of days between the first and latest responses.

One_Response_Indicator

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicator to show if only one response was recorded.

Questionnaire Question Response Details

Member_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the member or patient.

Questionnaire_Response_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Identifier for the questionnaire response.

Class

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Class identifier for the question response. See Dictionary Questionnaire Class table in the Dictionary Dataset Specification.

Class_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the class of the question response. See Dictionary Questionnaire Class table in the Dictionary Dataset Specification.

Response_Note

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Notes or additional information related to the response.

Source

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Source of the response data.

Source_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the source of the response data.

Source_Entry_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the response was entered.

Completed_By_Auto_Close

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicator if the response was completed automatically.

Questionnaire_Response_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: ID of the user who modified the questionnaire response.

Questionnaire Dataset Specification

Questionnaire Response Details

Questionnaire_Response_Modified_User_Name

  • Required: YES

  • Type: STRING

  • Description: Name of the user who modified the questionnaire response.

Questionnaire_Response_Created_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp when the questionnaire response was created.

Questionnaire_Response_Last_Modified_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp of the last modification to the questionnaire response.

Questionnaire_Key

  • Required: YES

  • Type: INT64

  • Description: Identifier for the questionnaire.

Questionnaire_Version_Key

  • Required: YES

  • Type: INT64

  • Description: Identifier for the version of the questionnaire.

Questionnaire_Version_Number

  • Required: YES

  • Type: INT64

  • Description: Version number of the questionnaire.

Questionnaire_Title

  • Required: YES

  • Type: STRING

  • Description: Title of the questionnaire.

Questionnaire_Version_Title

  • Required: YES

  • Type: STRING

  • Description: Title version of the questionnaire.

Questionnaire_Code

  • Required: YES

  • Type: STRING

  • Description: Code associated with the questionnaire.

Dashboard_Indicator

  • Required: YES

  • Type: BOOL

  • Description: Indicator for dashboard visibility.

Question Response Details

Question_Response_Key

  • Required: YES

  • Type: INT64

  • Description: Identifier for the question response.

Question_Response_Scoring_Weight

  • Required: YES

  • Type: NUMERIC

  • Description: Weight or score assigned to the question response.

Question_Response_Modified_User_ID

  • Required: YES

  • Type: STRING

  • Description: ID of the user who modified the question response.

Question_Response_Modified_User_Name

  • Required: YES

  • Type: STRING

  • Description: Name of the user who modified the question response.

Question_Position

  • Required: YES

  • Type: INT64

  • Description: Position of the question in the questionnaire.

Question_Key

  • Required: YES

  • Type: INT64

  • Description: Identifier for the question.

Question_Version_Key

  • Required: YES

  • Type: INT64

  • Description: Identifier for the version of the question.

Question_Version_Number

  • Required: YES

  • Type: INT64

  • Description: Version number of the question.

Full_Question_Clinical

  • Required: YES

  • Type: STRING

  • Description: Full clinical question text.

Full_Question_Version_Clinical

  • Required: YES

  • Type: STRING

  • Description: Version of the full clinical question text.

Short_Question

  • Required: YES

  • Type: STRING

  • Description: Abbreviated or shortened version of the question.

Question_Report_Title

  • Required: YES

  • Type: STRING

  • Description: Title used for reporting purposes related to the question.

Question_Version_Report_Title

  • Required: YES

  • Type: STRING

  • Description: Version of the title used for reporting purposes related to the question.

Question_Code

  • Required: YES

  • Type: STRING

  • Description: Code associated with the question.

Question_Response_Type

  • Required: YES

  • Type: STRING

  • Description: Type of response expected for the question.

  • Note: See Dictionary Response Type table in the Dictionary Dataset Specification.

Question_Display_Type

  • Required: YES

  • Type: STRING

  • Description: Display type for the question in the user interface.

Question_Response_Type_Description

  • Required: YES

  • Type: STRING

  • Description: Description of the question response type.

  • Note: See Dictionary Response Type table in the Dictionary Dataset Specification.

Question_Response_Value_Type

  • Required: YES

  • Type: STRING

  • Description: Data type of the response value.

  • Note: See Dictionary Response Value Type table in the Dictionary Dataset Specification.

Question_Response_Value_Type_Description

  • Required: YES

  • Type: STRING

  • Description: Description of the data type of the response value.

  • Note: See Dictionary Response Value Type table in the Dictionary Dataset Specification.

Question_Response_Created_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp when the question response was created.

Question_Response_Last_Modified_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp of the last modification to the question response.

Question_Response_Last_Modified_Date

  • Required: YES

  • Type: DATE

  • Description: Date of the last modification to the question response.

Response Details

Response_Detail_Key

  • Required: YES

  • Type: INT64

  • Description: Identifier for the response detail.

Response_Value_Text

  • Required: YES

  • Type: STRING

  • Description: Textual value of the response.

Response_Value_Date

  • Required: YES

  • Type: DATE

  • Description: Date value of the response.

Response_Value_Number

  • Required: YES

  • Type: NUMERIC

  • Description: Numeric value of the response.

Response_Value_Clarification

  • Required: YES

  • Type: STRING

  • Description: Clarification or additional information about the response.

Response_Void_Indicator

  • Required: YES

  • Type: BOOL

  • Description: Indicator for voided response.

Response_Void_Reason

  • Required: YES

  • Type: STRING

  • Description: Reason for voiding the response.

Response_Void_Reason_Description

  • Required: YES

  • Type: STRING

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

Response_Void_User_ID

  • Required: YES

  • Type: STRING

  • Description: User ID who voided the response.

Response_Void_User_Name

  • Required: YES

  • Type: STRING

  • Description: User name who voided the response.

Response_Void_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp when the response was voided.

Response_Selection_Key

  • Required: YES

  • Type: INT64

  • Description: Identifier for the response selection.

Response_Detail_Created_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp when the response detail was created.

Response_Detail_Last_Modified_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp of the last modification to the response detail.

Response_Detail_Last_Modified_Date

  • Required: YES

  • Type: DATE

  • Description: Date of the last modification to the response detail.

Questionnaire Dataset Specification

Questionnaire Question Response Details

Enrollment_Program

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Program related to the enrollment.

Screening_Program

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Program related to the screening.

Program_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the program.

Complete_Indicator

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicator for completion status.

First

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicator for the first occurrence.

Latest

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicator for the latest occurrence.

First_Completed

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicator for the first completion.

Latest_Completed

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicator for the latest completion.

Member_Enrollment_Effective_Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: Effective date of member enrollment.

Member_Enrollment_Termination_Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: Termination date of member enrollment.

Member_Enrollment_Key

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for member enrollment.

Group_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the group.

Group_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the group.

Plan_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the plan. See Dictionary Plan table in the Dictionary Dataset Specification.

Plan_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the plan. See Dictionary Plan table in the Dictionary Dataset Specification.

Line_Of_Business

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the line of business.

Line_Of_Business_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the line of business.

Questionnaire Log

Member_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique identifier for each individual or member participating in the questionnaire.

Questionnaire_Response_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: A key or identifier associated with a specific response or submission within the questionnaire.

Class

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Represents a classification or category associated with the member (e.g., patient class, risk group, etc.). See Dictionary Questionnaire Class table in the Dictionary Dataset Specification.

Class_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A textual description corresponding to the specific class or category assigned to the member. See Dictionary Questionnaire Class table in the Dictionary Dataset Specification.

Response_Note

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Additional notes or comments related to the questionnaire response.

Complete_Indicator

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates whether the questionnaire response is complete or partially filled out.

Source

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The origin or channel through which the questionnaire data was collected (e.g., web form, paper survey).

Source_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Describes the source or method used to collect the questionnaire data.

Source_Entry_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the questionnaire response was entered or recorded.

Completed_By_Auto_Close

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates whether the completion of the questionnaire was automatically triggered (e.g., timed out).

Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifies the user who last modified the questionnaire response.

Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the questionnaire response was initially created.

Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The most recent date and time when the questionnaire response was modified.

Questionnaire

  • Is Nullable: YES

  • Data Type: STRUCT

  • Description: Refers to the specific questionnaire administered to the member. See below for detailed information on each parameter in the structure.

Questionnaire_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Identifies the specific questionnaire administered to the member.

Questionnaire_Version_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Refers to a specific version of the questionnaire.

Questionnaire_Version_Number

  • Is Nullable: YES

  • Data Type: INT64

  • Description: The numerical version number assigned to the questionnaire.

Questionnaire_Title

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The title or name of the questionnaire used for assessment.

Questionnaire_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A code or identifier associated with the questionnaire.

Dashboard_Indicator

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates whether the member’s scores are displayed on a dashboard or summary view.

Questionnaire_Effective_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date when the questionnaire becomes effective or applicable.

Questionnaire_Termination_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date when the questionnaire is no longer valid or applicable.

Questionnaire_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifies the user who last modified the questionnaire details.

Questionnaire_Modified_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name of the user who last modified the questionnaire details.

Questionnaire_Version_Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the specific questionnaire version was created.

Questionnaire_Version_Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The most recent date and time when the questionnaire version was modified.

Score Responses

Calculated_Score

  • Is Nullable: YES

  • Data Type: NUMERIC

  • Description: The computed score based on questionnaire responses and scoring functions.

Score_Response_Void_Indicator

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates whether the score response has been voided or invalidated.

Score_Response_Void_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Questionnaire Dataset Specification

Score Responses

Void User ID

  • Field Name: nse_Void_User_ID

  • Required: YES

  • Type: STRING

  • Description: Identifies the user who voided the score response.

Void Reason

  • Field Name: Score_Responses.Score_Response_Void_Reason

  • Required: YES

  • Type: STRING

  • Description: The reason or explanation for voiding the score response.

Void Reason Description

  • Field Name: Score_Responses.Score_Response_Void_Reason_Description

  • Required: YES

  • Type: STRING

  • Description: Provides a detailed description of the void reason.

Modified User ID

  • Field Name: Score_Responses.Score_Response_Modified_User_ID

  • Required: YES

  • Type: STRING

  • Description: Identifies the user who last modified the score response.

Created Timestamp

  • Field Name: Score_Responses.Score_Response_Created_Timestamp

  • Required: YES

  • Type: TIMESTAMP

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

Last Modified Timestamp

  • Field Name: Score_Responses.Score_Response_Last_Modified_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: The most recent date and time when the score response was modified.

Scoring Function Key

  • Field Name: Score_Responses.Scoring_Function_Key

  • Required: YES

  • Type: INT64

  • Description: Refers to a specific scoring function used to calculate scores based on questionnaire responses.

Scoring Function Version Number

  • Field Name: Score_Responses.Scoring_Function_Version_Number

  • Required: YES

  • Type: INT64

  • Description: The version number associated with the scoring function.

Scoring Function Score Description

  • Field Name: Score_Responses.Scoring_Function_Score_Description

  • Required: YES

  • Type: STRING

  • Description: Describes the meaning or interpretation of the scores generated by the scoring function.

Scoring Function Report Title

  • Field Name: Score_Responses.Scoring_Function_Report_Title

  • Required: YES

  • Type: STRING

  • Description: The title assigned to the report or summary that includes the member’s scores.

Scoring Function Version Key

  • Field Name: Score_Responses.Scoring_Function_Version_Key

  • Required: YES

  • Type: INT64

  • Description: Refers to a specific version of the scoring function.

Scoring Function Formula

  • Field Name: Score_Responses.Scoring_Function_Formula

  • Required: YES

  • Type: STRING

  • Description: Specifies the mathematical formula or algorithm used to compute scores.

Scoring Function Formula Description

  • Field Name: Score_Responses.Scoring_Function_Formula_Description

  • Required: YES

  • Type: STRING

  • Description: Provides a detailed explanation of the mathematical formula or algorithm used to compute scores.

Scoring Function

  • Field Name: Score_Responses.Scoring_Function

  • Required: YES

  • Type: STRING

  • Description: Indicates the type of scoring method employed (e.g., Likert scale, weighted scoring, etc.).

Scoring Function Format Type

  • Field Name: Score_Responses.Scoring_Function_Format_Type

  • Required: YES

  • Type: STRING

  • Description: Describes the format of the scores (e.g., numeric, categorical, etc.).

Scoring Function Effective Timestamp

  • Field Name: Score_Responses.Scoring_Function_Effective_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: The date when the specific scoring function becomes effective or applicable.

Scoring Function Termination Timestamp

  • Field Name: Score_Responses.Scoring_Function_Termination_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: The date when the specific scoring function is no longer valid or applicable.

Scoring Function Modified User ID

  • Field Name: Score_Responses.Scoring_Function_Modified_User_ID

  • Required: YES

  • Type: STRING

  • Description: Identifies the user who last modified the details of the scoring function.

Scoring Function Version Created Timestamp

  • Field Name: Score_Responses.Scoring_Function_Version_Created_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: The date and time when a specific version of the scoring function was created.

Scoring Function Version Last Modified Timestamp

  • Field Name: Score_Responses.Scoring_Function_Version_Last_Modified_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: The most recent date and time when a specific version of the scoring function was modified.

Questionnaire Log

Question Responses

  • Field Name: Question_Responses

  • Required: NO

  • Type: ARRAY

  • Description: Represents the individual responses to specific questions within the questionnaire. See below for detailed information on each parameter in the array.

Question Response Key

  • Field Name: Question_Responses.Question_Response_Key

  • Required: YES

  • Type: INT64

  • Description: Identifier for the question response.

Question Response Scoring Weight

  • Field Name: Question_Responses.Question_Response_Scoring_Weight

  • Required: YES

  • Type: NUMERIC

  • Description: Weight or score assigned to the question response.

Question Response Modified User ID

  • Field Name: Question_Responses.Question_Response_Modified_User_ID

  • Required: YES

  • Type: STRING

  • Description: ID of the user who modified the question response.

Question Position

  • Field Name: Question_Responses.Question_Position

  • Required: YES

  • Type: INT64

  • Description: Position of the question in the questionnaire.

Question Key

  • Field Name: Question_Responses.Question_Key

  • Required: YES

  • Type: INT64

  • Description: Identifier for the question.

Question Version Key

  • Field Name: Question_Responses.Question_Version_Key

  • Required: YES

  • Type: INT64

  • Description: Identifier for the version of the question.

Question Version Number

  • Field Name: Question_Responses.Question_Version_Number

  • Required: YES

  • Type: INT64

  • Description: Version number of the question.

Full Question Clinical

  • Field Name: Question_Responses.Full_Question_Clinical

  • Required: YES

  • Type: STRING

  • Description: Full clinical question text.

Short Question

  • Field Name: Question_Responses.Short_Question

  • Required: YES

  • Type: STRING

  • Description: Abbreviated or shortened version of the question.

Question Report Title

  • Field Name: Question_Responses.Question_Report_Title

  • Required: YES

  • Type: STRING

  • Description: Title used for reporting purposes related to the question.

Question Code

  • Field Name: Question_Responses.Question_Code

  • Required: YES

  • Type: STRING

  • Description: Code associated with the question.

Question Response Type

  • Field Name: Question_Responses.Question_Response_Type

  • Required: YES

  • Type: STRING

  • Description: Type of response expected for the question. See Dictionary Response Type table in the Dictionary Dataset Specification.

Question Display Type

  • Field Name: Question_Responses.Question_Display_Type

  • Required: YES

  • Type: STRING

  • Description: Display type for the question in the user interface.

Question Response Type Description

  • Field Name: Question_Responses.Question_Response_Type_Description

  • Required: YES

  • Type: STRING

  • Description: Description of the question response type. See Dictionary Response Type table in the Dictionary Dataset Specification.

Question Response Value Type

  • Field Name: Question_Responses.Question_Response_Value_Type

  • Required: YES

  • Type: STRING

  • Description: Data type of the response value. See Dictionary Response Value Type table in the Dictionary Dataset Specification.

Question Response Value Type Description

  • Field Name: Question_Responses.Question_Response_Value_Type_Description

  • Required: YES

  • Type: STRING

  • Description: Description of the data type of the response value. See Dictionary Response Value Type table in the Dictionary Dataset Specification.

Question Effective Timestamp

  • Field Name: Question_Responses.Question_Effective_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp when the question became effective.

Question Termination Timestamp

  • Field Name: Question_Responses.Question_Termination_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp when the question is terminated.

Question Modified User ID

  • Field Name: Question_Responses.Question_Modified_User_ID

  • Required: YES

  • Type: STRING

  • Description: ID of the user who modified the question.

Question Version Created Timestamp

  • Field Name: Question_Responses.Question_Version_Created_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp when the version of the question was created.

Question Version Last Modified Timestamp

  • Field Name: Question_Responses.Question_Version_Last_Modified_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp of the last modification to the question version.

Question Response Created Timestamp

  • Field Name: Question_Responses.Question_Response_Created_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp when the question response was created.

Question Response Last Modified Timestamp

  • Field Name: Question_Responses.Question_Response_Last_Modified_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp of the last modification to the question response.

Response Detail Key

  • Field Name: Question_Responses.Response_Detail_Key

  • Required: YES

  • Type: INT64

  • Description: Identifier for the response detail.

Response Value Clarification

  • Field Name: Question_Responses.Response_Value_Clarification

  • Required: YES

  • Type: STRING

  • Description: Clarification or additional information about the response.

Response Void Indicator

  • Field Name: Question_Responses.Response_Void_Indicator

  • Required: YES

  • Type: BOOL

  • Description: Indicator for voided response.

Response Void Reason

  • Field Name: Question_Responses.Response_Void_Reason

  • Required: YES

  • Type: STRING

  • Description: Reason for voiding the response.

Response Void Reason Description

  • Field Name: Question_Responses.Response_Void_Reason_Description

  • Required: YES

  • Type: STRING

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

Questionnaire Dataset Specification

Question Responses

Response_Void_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID who voided the response.

Response_Void_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the response was voided.

Response_Selection_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Identifier for the response selection.

Response_Detail_Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the response detail was created.

Response_Detail_Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp of the last modification to the response detail.

Questionnaire Log

Enrollment_Program

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Refers to the program or process through which individuals are enrolled or registered.

Screening_Program

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Pertains to the program or process used for screening or assessing individuals.

Program_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique identifier associated with a specific program or initiative.

Record_Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The most recent date and time when any record within the questionnaire log was modified.

Transaction_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifies the user responsible for the transaction or modification.

Deleted_Indicator

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates whether a record has been deleted or voided.

Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Specifies the type or category of the questionnaire log entry (e.g., response, modification, etc.).

Tenant

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Refers to the specific organizational unit or context within which the questionnaire log operates.

Active_Version

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Denotes the currently active version of the questionnaire log.

Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: The date associated with the questionnaire log entry.

Sequence

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Represents the order or sequence of log entries.

Source_System_Name

  • Is Nullable: YES

  • Data Type: STRING

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

Source_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp associated with the data source.

Source_File_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name of the file or data source containing the questionnaire log information.

Schema_Version

  • Is Nullable: YES

  • Data Type: FLOAT64

  • Description: Indicates the version of the schema or data model used for the questionnaire log.

Member_Partition

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Refers to a specific partition or subset of members within the dataset.

Action

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Describes the action or operation performed on the questionnaire log entry (e.g., create, update, delete).

Transaction_Actor_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of the actor performing the transaction.

Questionnaire Metadata

Questionnaire_Version_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for the specific version of the questionnaire.

Version_Number

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Version number of the questionnaire, indicating revisions or updates.

Title

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Title or name of the questionnaire.

Effective_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp marking when this version of the questionnaire became effective.

Termination_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when this version of the questionnaire was terminated or became inactive.

Version_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: ID of the user who last modified this version of the questionnaire.

Version_Modified_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the user who last modified this version of the questionnaire.

Version_Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when this version of the questionnaire was created.

Version_Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when this version of the questionnaire was last modified.

Questionnaire_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Primary key for the questionnaire, linking different versions and forms.

Questionnaire_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Code uniquely identifying the questionnaire across versions.

Class

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Classification of the questionnaire, indicating its general use or nature.

Class_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the class, explaining the purpose or usage of the questionnaire within the specified class.

Help

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Help text or instructions provided within the questionnaire for guidance.

Position

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Position or order of the questionnaire in a sequence or collection.

Active_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the questionnaire was activated or went live.

Inactive_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the questionnaire was deactivated or retired.

Dashboard_Indicator

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Boolean indicating whether the questionnaire is displayed on administrative dashboards.

All_Roles_Indicator

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Boolean indicating whether the questionnaire is available to all user roles.

All_Customer_Categories_Indicator

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Boolean indicating whether the questionnaire is applicable across all customer categories.

Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: ID of the user who last modified the questionnaire metadata.

Modified_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the user who last modified the questionnaire metadata.

Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp marking the creation of the questionnaire metadata record.

Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp marking the last modification of the questionnaire metadata record.

Questionnaire Metadata Customer Categories

Customer_Category_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for the customer category associated with a specific questionnaire version.

Questionnaire Dataset Specification

Questionnaire Metadata Customer Categories

Columns

  • Questionnaire_Version_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Identifier linking to a specific version of the questionnaire for which the customer category applies.

  • Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Code representing the customer category applicable to the questionnaire.

  • Effective_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the association between the questionnaire and the customer category became effective.

  • Termination_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the association between the questionnaire and the customer category was terminated.

  • Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: ID of the user who last modified the record concerning the association of the questionnaire with a customer category.

  • Modified_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the user who last modified the record.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the record associating the questionnaire with a customer category was created.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the record was last modified, showing updates to the association details.

Questionnaire Metadata Display Hierarchy

Columns

  • Questionnaire_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: A unique identifier for the questionnaire.

  • Questionnaire_Version_Key

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique identifier for a specific version of the questionnaire.

  • Questionnaire_Effective_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp from which this questionnaire version became effective.

  • Questionnaire_Termination_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when this questionnaire version was or will be terminated.

  • Questionnaire_Version_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The user ID of the person who last modified this questionnaire version.

  • Questionnaire_Title

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The title of the questionnaire.

  • Questionnaire_Question_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: A unique identifier for a question within the questionnaire.

  • Section_Title

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The title of the section in which the question appears.

  • Top_Level_Position

  • Is Nullable: YES

  • Data Type: INT64

  • Description: The position of the question at the top level of the questionnaire hierarchy.

  • Question_Depth

  • Is Nullable: YES

  • Data Type: INT64

  • Description: The depth of the question within the questionnaire's hierarchical structure.

  • Other_Level_Position

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The position of the question within its specific level of the hierarchy.

  • Question_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Another identifier for the question, possibly used for internal references.

  • Question_Code

  • Is Nullable: YES

  • Data Type: STRING

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

  • Question_Required

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates whether the question is mandatory or optional.

  • Short_Question

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A shortened version of the question text.

  • Full_Question_Clinical

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The full text of the question as it appears in clinical contexts.

  • Response_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A description of the type of response expected for this question.

  • Question_Report_Title

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The title of the question as it should appear in reports.

  • Question_Selections

  • Is Nullable: NO

  • Data Type: ARRAY

  • Description: A collection of possible selections or answers for the question.

Question Selections Subfields

  • Question_Selection_Key

  • Is Nullable: NO

  • Data Type: INT64

  • Description: A unique identifier for a specific selection option.

  • Question_Selection_Code

  • Is Nullable: NO

  • Data Type: STRING

  • Description: A code assigned to the selection option for easy reference.

  • Question_Selection_Value

  • Is Nullable: NO

  • Data Type: STRING

  • Description: The text or value of the selection option.

  • Question_Selection_Position

  • Is Nullable: NO

  • Data Type: INT64

  • Description: The position or order of the selection option in the list of choices.

  • Questionnaire_Question_Key_Path

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The hierarchical path to this question within the questionnaire structure.

  • Questionnaire_Question_Short_Question_Path

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The hierarchical path to this question using shortened question texts.

Additional Metadata Display Hierarchy Columns

Columns

  • Questionnaire_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for the questionnaire in the metadata display hierarchy.

  • Questionnaire_Version_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Identifier for the specific version of the questionnaire.

  • Questionnaire_Effective_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Date and time when the questionnaire version became active.

  • Questionnaire_Termination_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Date and time when the questionnaire version expired or was terminated.

  • Questionnaire_Version_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the person who last modified the questionnaire version.

  • Questionnaire_Title

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Title of the questionnaire as displayed in the metadata hierarchy.

  • Questionnaire_Question_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for each question within the questionnaire.

  • Section_Title

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Title of the section in which the question appears.

Questionnaire Dataset Specification

Questionnaire Metadata Display Hierarchy

Title

  • Type: STRING

  • Description: Title of the section containing the question, if the questionnaire is organized by sections.

Question Depth

  • Type: INT64

  • Description: Depth or hierarchical level of the question within the questionnaire structure.

Question Key

  • Type: INT64

  • Description: Unique identifier for the individual question.

Question Code

  • Type: STRING

  • Description: Code or shorthand for the question, used for reference in the questionnaire structure.

Question Required

  • Type: BOOL

  • Description: Indicates if the question is mandatory (yes/no).

Short Question

  • Type: STRING

  • Description: Abbreviated text of the question, used in condensed displays.

Full Question Clinical

  • Type: STRING

  • Description: Full clinical version of the question text, intended for detailed displays.

Response Type Description

  • Type: STRING

  • Description: Describes the type of response expected for the question (e.g., multiple choice, free text).

Question Report Title

  • Type: STRING

  • Description: Title for the question when displayed in reports, potentially different from the question text.

Question Selections

  • Type: ARRAY

  • Description: Array of possible response options or selections for the question, if applicable.

Question Selection Key

  • Type: INT64

  • Description: Unique identifier for each possible response selection option.

Question Selection Code

  • Type: STRING

  • Description: Code representing each selection option for easy reference within the system.

Question Selection Value

  • Type: STRING

  • Description: Display text for each selection option shown to users.

Question Selection Position

  • Type: INT64

  • Description: Position or order of each selection option within the list of response choices.

Questionnaire Question Key Path

  • Type: STRING

  • Description: Path representation showing the unique identifiers of each question in the hierarchy within the questionnaire.

Questionnaire Question Short Question Path

  • Type: STRING

  • Description: Path representation showing the short form text of each question in the hierarchy, useful for summary views or quick navigation.

Questionnaire Metadata Programs

Program Key

  • Type: INT64

  • Description: Unique identifier for the program associated with a specific questionnaire version.

Questionnaire Version Key

  • Type: INT64

  • Description: Identifier linking to a specific version of the questionnaire for which the program details apply.

Program

  • Type: STRING

  • Description: Name or identifier of the program linked to the questionnaire version.

Program Description

  • Type: STRING

  • Description: Detailed description of the program as it relates to the questionnaire.

Primary

  • Type: BOOL

  • Description: Indicates whether the program is the primary focus for the associated questionnaire version.

Effective Timestamp

  • Type: TIMESTAMP

  • Description: Timestamp when the association between the questionnaire and the program became active.

Termination Timestamp

  • Type: TIMESTAMP

  • Description: Timestamp when the association between the questionnaire and the program was terminated.

Modified User ID

  • Type: STRING

  • Description: ID of the user who last modified the record regarding the program and questionnaire association.

Modified User Name

  • Type: STRING

  • Description: Name of the user who last modified the record, providing accountability and traceability.

Created Timestamp

  • Type: TIMESTAMP

  • Description: Timestamp when the record associating the questionnaire with the program was initially created.

Last Modified Timestamp

  • Type: TIMESTAMP

  • Description: Timestamp when the record was last updated to reflect changes in the program or its association with the questionnaire.

Questionnaire Metadata Question

Questionnaire Question Key

  • Type: INT64

  • Description: Unique identifier for the questionnaire question.

Questionnaire Version Key

  • Type: INT64

  • Description: Links the question to a specific version of the questionnaire.

Section Key

  • Type: INT64

  • Description: Identifier for the section within the questionnaire where this question is placed.

Position

  • Type: INT64

  • Description: Numeric position or order of the question within its section or the questionnaire.

Member Portal

  • Type: BOOL

  • Description: Indicates whether the question is visible on the member portal.

Provider Portal

  • Type: BOOL

  • Description: Indicates whether the question is visible on the provider portal.

Depth

  • Type: INT64

  • Description: Level of nesting or depth of the question within the questionnaire structure.

Required

  • Type: BOOL

  • Description: Indicates if answering the question is mandatory.

Questionnaire Question Modified User ID

  • Type: STRING

  • Description: ID of the user who last modified the question.

Questionnaire Question Modified User Name

  • Type: STRING

  • Description: Name of the user who last modified the question.

Questionnaire Question Created Timestamp

  • Type: TIMESTAMP

  • Description: Timestamp when the question was first created.

Questionnaire Question Last Modified Timestamp

  • Type: TIMESTAMP

  • Description: Timestamp when the question was last modified.

Question Key

  • Type: INT64

  • Description: Secondary identifier for the question, often used in cross-referencing within the dataset.

Short Question

  • Type: STRING

  • Description: A brief or shortened form of the question text.

Question Code

  • Type: STRING

  • Description: Code assigned to the question for identification.

Questionnaire Dataset Specification

Questionnaire Metadata Question

Response_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of response required (e.g., text, select, radio button).

Response_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the response type to aid in understanding the expected input.

Response_Value_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Specifies the data type of the response (e.g., integer, string).

Response_Value_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Provides additional detail about the nature of the response value type.

Class

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Classification or category of the question, which might relate to its function or usage in the questionnaire.

Class_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Detailed description of the class to clarify its meaning and application.

Active

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates whether the question is currently active and should be displayed.

Question_Available_To_AWF

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Determines if the question can be accessed by automated workflows (AWF).

Clinical_Help

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Help text providing clinical guidance or information related to the question.

Non_Clinical_Help

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Help text providing non-clinical advice or information such as administrative details related to the question.

Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the person who last modified any details of the question.

Modified_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the person who last updated the question, used for tracking changes.

Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the question entry was originally created.

Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp of the most recent update made to the question's details.

Questionnaire Metadata Question Child Questions

Child_Question_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for each child question entry within the table.

Questionnaire_Question_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: References the parent question's unique identifier within the questionnaire.

Child_Questionnaire_Question_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for the child question, linking it to its specific details within the questionnaire.

Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: ID of the user who last modified the child question entry.

Modified_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the user who last made changes to the child question record.

Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the child question record was first created in the database.

Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp of the most recent update made to the child question's record, capturing any changes made.

Questionnaire Metadata Question Entry Test Enablers

Entry_Test_Enabler_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for the entry test enabler record, used for tracking within the dataset.

Entry_Test_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: References the key of the entry test that this enabler is associated with, linking specific conditions or rules for questionnaire entry.

Questionnaire_Question_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Identifies the questionnaire question that this entry test enabler affects, establishing contextual dependencies.

Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: ID of the user who last modified this enabler entry, providing accountability for changes.

Modified_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the user who last updated the entry test enabler, ensuring traceability of modifications.

Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the entry test enabler was created, used for audit and tracking purposes.

Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp of the most recent modification to the entry test enabler record, useful for version control and updates tracking.

Questionnaire Metadata Question Entry Tests

Entry_Test_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for the entry test record. This key is used to reference specific entry tests.

Questionnaire Dataset Specification

Questionnaire Metadata Question Entry Tests

Columns

  • Questionnaire_Question_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Links to the questionnaire question this entry test is associated with, indicating which question the test applies to.

  • Minimum_Value

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Specifies the minimum value allowed for responses to the questionnaire question, ensuring responses meet predetermined criteria.

  • Maximum_Value

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Specifies the maximum value allowed for responses to the questionnaire question, ensuring responses do not exceed predetermined limits.

  • Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier of the user who last modified the entry test, tracking changes and maintaining data integrity.

  • Modified_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the user who last modified the entry test, providing clarity on who made the last updates.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the entry test record was created, providing a record of when the test was initially set up.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the entry test record was last modified, ensuring a track record of the most recent updates.

Questionnaire Metadata Question Selection Enablers

Columns

  • Selection_Enabler_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for the selection enabler record. This key is used to uniquely identify and reference specific enablers within the questionnaire framework.

  • Questionnaire_Selection_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Links to the specific selection within a questionnaire to which this enabler is applied, facilitating dynamic control over option availability based on prior inputs.

  • Questionnaire_Question_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Identifies the questionnaire question associated with this selection enabler, indicating which question's response influences the availability of this selection.

  • Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier of the user who last modified the selection enabler record, aiding in tracking changes and maintaining accountability.

  • Modified_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the user who last modified the selection enabler record, providing clarity on the person responsible for the most recent updates.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the selection enabler record was initially created, establishing a historical context for the record's inception.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp noting when the selection enabler record was last updated, ensuring a track record of the latest modifications for audit and review purposes.

Questionnaire Metadata Question Selection Problems

Columns

  • Selection_Problem_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for the selection problem record. This key is used to uniquely identify and manage specific problem records related to questionnaire selections.

  • Questionnaire_Selection_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Links to the specific questionnaire selection that this problem is associated with, ensuring that problems are correctly mapped to their relevant questionnaire components.

  • Problem

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A brief label or identifier for the problem, used to quickly reference the nature of the issue associated with the questionnaire selection.

  • Problem_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Detailed description of the problem, providing further insight into the issue, its context, and its implications for the questionnaire functionality.

  • Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier of the user who last modified the problem record, which helps track changes and maintain accountability in the management of questionnaire issues.

  • Modified_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the user who last modified the problem record, offering clarity on who is responsible for the latest changes to the problem details.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp marking when the problem record was initially created, providing a historical record of when the problem was first acknowledged and documented.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating the last modification to the problem record, useful for tracking updates and changes over time for audit and maintenance purposes.

Questionnaire Metadata Question Selection Versions

Columns

  • Selection_Version_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for each version of a questionnaire selection, used to track changes and maintain different versions over time.

  • Questionnaire_Selection_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: References the specific questionnaire selection to which this version belongs, linking the version directly to its parent selection.

  • Question_Version_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Links to the questionnaire version that includes this specific selection, integrating the selection within the broader questionnaire structure.

  • Position

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Indicates the ordinal position of this selection within the questionnaire, helping to organize and display the selection in the correct sequence.

  • Value

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Specifies the value associated with this selection version, used to define the content or options available for this selection.

Questionnaire Dataset Specification

Questionnaire Metadata Question Selection Versions

Clarification Indicator

  • Column Name: Clarification_Indicator

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: A boolean indicator specifying whether additional clarification is required or provided for this selection, enhancing understanding or requiring further input.

Mutual Exclusive

  • Column Name: Mutual_Exclusive

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: A boolean value that indicates whether the selection is mutually exclusive with other selections, preventing multiple concurrent selections when true.

Modified User ID

  • Column Name: Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier of the user who last modified this version, aiding in tracking changes and attributing modifications within the system.

Modified User Name

  • Column Name: Modified_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the user who made the last changes to this version, providing clear accountability and referencing for system audits.

Created Timestamp

  • Column Name: Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp marking the creation of this version, essential for historical data tracking and version management.

Last Modified Timestamp

  • Column Name: Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp of the last modification to this version, crucial for maintaining accurate records of updates and changes over time.

Questionnaire Metadata Question Selections

Questionnaire Selection Key

  • Column Name: Questionnaire_Selection_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for the selection within the questionnaire, used to uniquely identify and manage each selection entity.

Questionnaire Question Key

  • Column Name: Questionnaire_Question_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: References the questionnaire question to which this selection is linked, establishing a relational connection within the dataset.

Question Selection Key

  • Column Name: Question_Selection_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: A unique key for tracking individual selections linked to specific questions, ensuring accurate response capture and analysis.

Scoring Weight

  • Column Name: Scoring_Weight

  • Is Nullable: YES

  • Data Type: NUMERIC

  • Description: Numeric value that assigns a weight to the selection for scoring purposes, utilized in calculating scores based on selected options.

Modified User ID

  • Column Name: Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: ID of the user who last modified the selection, crucial for audit trails and change management within the system.

Modified User Name

  • Column Name: Modified_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the user who last updated the selection, providing accountability and traceability for changes.

Created Timestamp

  • Column Name: Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the selection was first created, important for historical data tracking and analysis.

Last Modified Timestamp

  • Column Name: Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp of the most recent modification to the selection, essential for maintaining the integrity and relevance of the questionnaire data.

Selection Code

  • Column Name: Selection_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A specific code assigned to the selection, used for identification and possibly linking to other data elements or logic within the system.

Selection Modified User ID

  • Column Name: Selection_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: ID of the user who last modified the selection details, helping in maintaining detailed records of who made changes.

Selection Modified User Name

  • Column Name: Selection_Modified_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the user who modified the selection details, ensuring clear documentation of who made specific updates.

Selection Created Timestamp

  • Column Name: Selection_Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp marking the creation of the selection detail, used to track when each selection was initially added to the database.

Selection Last Modified Timestamp

  • Column Name: Selection_Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The last modification timestamp for the selection details, used to trace the most recent updates to the selection settings.

Questionnaire Metadata Question Versions

Version Key

  • Column Name: Version_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for each version of a questionnaire question, used to track changes and updates over time.

Questionnaire Question Key

  • Column Name: Questionnaire_Question_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Links to the specific questionnaire question this version belongs to, establishing relational context within the dataset.

Version Number

  • Column Name: Version_Number

  • Is Nullable: YES

  • Data Type: INT64

  • Description: A sequential number representing the version of the questionnaire question, useful for version control and historical tracking.

Full Question Clinical

  • Column Name: Full_Question_Clinical

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The complete clinical text of the question as it appears in the questionnaire, providing clear context for responses.

Effective Timestamp

  • Column Name: Effective_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when this version of the question became effective, crucial for temporal data accuracy and applicability.

Termination Timestamp

  • Column Name: Termination_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp marking when this version was retired or replaced, essential for maintaining historical data integrity.

Report Title

  • Column Name: Report_Title

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Title used in reports for this version of the question, aiding in data aggregation and presentation.

Display Type

  • Column Name: Display_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Specifies how the question is displayed in the questionnaire, affecting respondent interaction and data collection.

Response Type Description

  • Column Name: Response_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Describes the type of response expected for the question, guiding data entry and validation.

Field Length

  • Column Name: Field_Length

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Defines the maximum length of the response field, ensuring data consistency and proper storage.

Questionnaire Dataset Specification

Questionnaire Metadata Question Versions

Input_Length

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Specifies the length of input allowed for responses, important for form design and user interface considerations.

Maximum_Value

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The maximum allowable value for numeric responses, used in validations to maintain data quality.

Minimum_Value

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The minimum allowable value for numeric responses, ensuring responses are within a defined acceptable range.

Selections_Allowed

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Number of selections permitted if the question allows multiple responses, crucial for maintaining logical data structure.

Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier of the user who last modified this version, providing a trail for audit and change management.

Modified_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the user who last modified this version, adding a personal accountability layer to the change history.

Version_Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when this version was created, marking its origin and aiding in chronological tracking of updates.

Version_Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when this version was last modified, crucial for understanding the most recent updates and changes.

Questionnaire Metadata Roles

Role_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for a specific role related to the questionnaire, used for access control and permissions management.

Questionnaire_Version_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Links to the specific version of the questionnaire this role is associated with, ensuring role permissions align with questionnaire versions.

Role_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique code representing the role, used for quick identification and reference in system processes.

Role_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Provides a detailed description of the role, clarifying the responsibilities and permissions associated with it.

Effective_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp marking when the role permissions or definitions become effective, critical for managing access over time.

Termination_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the role permissions are no longer valid, essential for maintaining security and relevancy.

Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier of the user who last modified the role information, aiding in tracking changes and maintaining data integrity.

Modified_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the user who last updated the role details, providing a personal link to the change history for accountability.

Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the role was initially created, useful for historical tracking and auditing purposes.

Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp of the most recent modification to the role, ensuring that all changes are accurately recorded and traceable.

Questionnaire Metadata Sections

Section_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for the section within the questionnaire, used to distinctly reference each part of the questionnaire structure.

Questionnaire_Version_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Identifies the specific version of the questionnaire to which this section belongs, ensuring consistency and accuracy in responses.

Title

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The title of the section, providing a clear and concise description of the content covered in this part of the questionnaire.

Position

  • Is Nullable: YES

  • Data Type: INT64

  • Description: The order in which this section appears within the questionnaire, used for proper sequencing and display.

Help_Text

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Descriptive text provided to assist users in understanding the context or requirements of the section, aimed at improving response accuracy.

Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier of the user who last made changes to the section, important for tracking modifications and maintaining version control.

Modified_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name of the user who last updated the section, providing a traceable record of who made changes for accountability purposes.

Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when the section was originally created, serving as a record of its inception for historical reference.

Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp of the most recent change made to the section, essential for version control and update tracking.

Questionnaire Responses

Member_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier for the member whose responses are recorded.

Questionnaire_Response_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: A unique key that identifies each specific set of responses within a questionnaire.

Class

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The classification of the questionnaire based on its purpose or content.

Class_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Detailed description of the class, explaining its significance and use.

Response_Note

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Notes or additional information provided by the responder or system regarding the responses.

Source

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The origin of the questionnaire response, such as an app or a clinical visit.

Source_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Describes the source in detail to clarify the context of the response entry.

Source_Entry_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating the entry time of the source, useful for chronological tracking.

Questionnaire Dataset Specification

Questionnaire Responses

Columns and Descriptions

  • Completed_By_Auto_Close

  • Type: BOOL

  • Description: Indicates whether the questionnaire was automatically closed by the system.

  • Questionnaire_Response_Modified_User_ID

  • Type: STRING

  • Description: ID of the user who last modified the response.

  • Questionnaire_Response_Modified_User_Name

  • Type: STRING

  • Description: Name of the user who last modified the response.

  • Questionnaire_Response_Created_Timestamp

  • Type: TIMESTAMP

  • Description: Timestamp when the response was initially created.

  • Questionnaire_Response_Last_Modified_Timestamp

  • Type: TIMESTAMP

  • Description: Timestamp when the response was last modified.

  • Questionnaire_Response_Last_Modified_Date

  • Type: DATE

  • Description: The date when the last modification was made to the response.

  • Questionnaire_Key

  • Type: INT64

  • Description: The key linking to the specific questionnaire.

  • Questionnaire_Version_Key

  • Type: INT64

  • Description: The key for the specific version of the questionnaire being responded to.

  • Questionnaire_Version_Number

  • Type: INT64

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

  • Questionnaire_Title

  • Type: STRING

  • Description: The title of the questionnaire.

  • Questionnaire_Version_Title

  • Type: STRING

  • Description: The title of the specific version of the questionnaire.

  • Questionnaire_Code

  • Type: STRING

  • Description: A unique code assigned to the questionnaire for identification.

  • Dashboard_Indicator

  • Type: BOOL

  • Description: Indicates whether the questionnaire data is displayed on dashboards.

  • Enrollment_Program

  • Type: STRING

  • Description: Program under which the questionnaire was enrolled.

  • Screening_Program

  • Type: STRING

  • Description: Screening program associated with the questionnaire.

  • Program_ID

  • Type: STRING

  • Description: Unique identifier for the program related to the questionnaire.

  • Complete_Indicator

  • Type: BOOL

  • Description: Indicates whether the questionnaire has been completed.

  • First

  • Type: BOOL

  • Description: Indicates if this is the first set of responses for the questionnaire.

  • Latest

  • Type: BOOL

  • Description: Indicates if this is the latest set of responses for the questionnaire.

  • First_Completed

  • Type: BOOL

  • Description: Indicates if this was the first completed instance of the questionnaire.

  • Latest_Completed

  • Type: BOOL

  • Description: Indicates if this was the latest completed instance of the questionnaire.

  • Member_Enrollment_Effective_Date

  • Type: DATE

  • Description: Effective date of member enrollment.

  • Member_Enrollment_Termination_Date

  • Type: DATE

  • Description: Termination date of member enrollment.

  • Member_Enrollment_Key

  • Type: STRING

  • Description: Identifier for member enrollment.

Questionnaire Metadata Log

Columns and Descriptions

  • Questionnaire_Version_Key

  • Type: INT64

  • Description: Unique identifier for a specific version of the questionnaire, crucial for tracking changes over time.

  • Version_Number

  • Type: INT64

  • Description: Sequential number representing the version of the questionnaire, aiding in version control and history.

  • Title

  • Type: STRING

  • Description: The title or name of the questionnaire, used for identification and display purposes.

  • Effective_Timestamp

  • Type: TIMESTAMP

  • Description: The date and time when this version of the questionnaire became effective or active.

  • Termination_Timestamp

  • Type: TIMESTAMP

  • Description: The date and time when this version of the questionnaire was terminated or became inactive.

  • Version_Modified_User_ID

  • Type: STRING

  • Description: Identifier of the user who last modified this version, ensuring traceability of changes.

  • Version_Created_Timestamp

  • Type: TIMESTAMP

  • Description: Timestamp when this version of the questionnaire was created, providing a historical record.

  • Version_Last_Modified_Timestamp

  • Type: TIMESTAMP

  • Description: Timestamp when this version of the questionnaire was last modified, tracking the most recent updates.

  • Questionnaire_Key

  • Type: INT64

  • Description: Unique identifier for the questionnaire, linking various versions and related data.

  • Questionnaire_Code

  • Type: STRING

  • Description: A code or shorthand identifier for the questionnaire, used for quick reference and categorization.

  • Class

  • Type: STRING

  • Description: Classification or type of the questionnaire, indicating its purpose or thematic grouping.

    • Note: See Dictionary Questionnaire Class table in the Dictionary Dataset Specification.

  • Class_Description

  • Type: STRING

  • Description: Detailed description of the class, providing context and understanding of its use.

    • Note: See Dictionary Questionnaire Class table in the Dictionary Dataset Specification.

  • Help

  • Type: STRING

  • Description: Help text or guidance provided for understanding or completing the questionnaire.

  • Position

  • Type: INT64

  • Description: The order or sequence of the questionnaire in a larger set or collection, determining its placement.

  • Active_Timestamp

  • Type: TIMESTAMP

  • Description: The timestamp when the questionnaire became active, marking its availability for use.

  • Inactive_Timestamp

  • Type: TIMESTAMP

  • Description: The timestamp when the questionnaire became inactive, indicating it is no longer in use.

  • Dashboard_Indicator

  • Type: BOOL

  • Description: A boolean flag indicating whether the questionnaire is featured on dashboards or prominent interfaces.

  • All_Roles_Indicator

  • Type: BOOL

  • Description: A boolean flag indicating whether the questionnaire is applicable to all user roles, ensuring broad accessibility.

  • All_Customer_Categories_Indicator

  • Type: BOOL

  • Description: A boolean indicating if the questionnaire applies to all customer categories, reflecting its universal relevance.

Questionnaire Dataset Specification

Questionnaire Metadata Log

d_User_ID

  • Type: STRING

  • Required: YES

  • Description: Identifier of the user who last made changes to the questionnaire log, for accountability.

Created_Timestamp

  • Type: TIMESTAMP

  • Required: YES

  • Description: The timestamp when the questionnaire log record was initially created, marking the entry point of data.

Last_Modified_Timestamp

  • Type: TIMESTAMP

  • Required: YES

  • Description: The most recent timestamp when the questionnaire log record was modified, tracking updates.

Customer_Categories

  • Type: ARRAY

  • Required: NO

  • Description: An array detailing the customer categories applicable to the questionnaire, specifying targeted audience segments.

  • Parameters:

  • Key

    • Type: INT64

    • Required: YES

    • Description: A unique key for the customer category.

  • Code

    • Type: STRING

    • Required: YES

    • Description: A unique code for the customer category.

  • Questionnaire_Effective_Timestamp

    • Type: TIMESTAMP

    • Required: YES

    • Description: The date when the questionnaire becomes effective or applicable.

  • Questionnaire_Termination_Timestamp

    • Type: TIMESTAMP

    • Required: YES

    • Description: The date when the questionnaire is no longer valid or applicable.

  • Modified_User_ID

    • Type: STRING

    • Required: YES

    • Description: User ID of the user who last modified the record.

  • Created_Timestamp

    • Type: TIMESTAMP

    • Required: YES

    • Description: Timestamp indicating when the record was created.

  • Last_Modified_Timestamp

    • Type: TIMESTAMP

    • Required: YES

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

Programs

  • Type: ARRAY

  • Required: NO

  • Description: An array of programs associated with the questionnaire, defining its application or relevance in various programmatic contexts.

  • Parameters:

  • Key

    • Type: INT64

    • Required: YES

    • Description: A unique identifier or key for the specific program associated with the questionnaire.

  • Program

    • Type: STRING

    • Required: YES

    • Description: The name or code representing the program linked to the questionnaire.

  • Program_Description

    • Type: STRING

    • Required: YES

    • Description: A detailed description of the program, providing context or additional information about its purpose.

  • Primary

    • Type: STRING

    • Required: YES

    • Description: Indicates whether this program is the primary or main program associated with the questionnaire (e.g., a flag or marker).

  • Effective_Timestamp

    • Type: TIMESTAMP

    • Required: YES

    • Description: The date when the questionnaire becomes effective or applicable.

  • Termination_Timestamp

    • Type: TIMESTAMP

    • Required: YES

    • Description: The date when the questionnaire is no longer valid or applicable.

  • Modified_User_ID

    • Type: STRING

    • Required: YES

    • Description: User ID of the user who last modified the record.

  • Created_Timestamp

    • Type: TIMESTAMP

    • Required: YES

    • Description: Timestamp indicating when the record was created.

  • Last_Modified_Timestamp

    • Type: TIMESTAMP

    • Required: YES

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

Roles

  • Type: ARRAY

  • Required: NO

  • Description: An array defining the roles for which the questionnaire is intended, ensuring appropriate targeting and use.

  • Parameters:

  • Program_Provider_Roles_Key

    • Type: INT64

    • Required: YES

    • Description: Unique identifier for the program provider roles entry.

  • Role_Code

    • Type: STRING

    • Required: YES

    • Description: Code representing the role of the provider within the program.

  • Role_Description

    • Type: STRING

    • Required: YES

    • Description: Description of the role of the provider within the program.

  • Role_Effective_Date

    • Type: DATE

    • Required: YES

    • Description: Effective date of the provider's role within the program.

  • Role_Termination_Date

    • Type: DATE

    • Required: YES

    • Description: Termination date of the provider's role within the program, if applicable.

  • Modified_User_ID

    • Type: TIMESTAMP

    • Required: YES

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

  • Role_Created_Timestamp

    • Type: TIMESTAMP

    • Required: YES

    • Description: Timestamp indicating when the provider's role entry was created.

  • Role_Last_Modified_Timestamp

    • Type: TIMESTAMP

    • Required: YES

    • Description: Timestamp indicating when the provider's role entry was last modified.

Sections

  • Type: ARRAY

  • Required: NO

  • Description: An array detailing the different sections of the questionnaire, aiding in structuring and organizing the content.

  • Parameters:

  • Key

    • Type: INT64

    • Required: YES

    • Description: A unique identifier for each section within the questionnaire.

  • Title

    • Type: STRING

    • Required: YES

    • Description: The title or name of the section, providing a brief overview of its content.

  • Position

    • Type: STRING

    • Required: YES

    • Description: The order or position of the section within the questionnaire.

  • Help_Text

    • Type: STRING

    • Required: YES

    • Description: Additional information or instructions to assist users in understanding the section.

  • Modified_User_ID

    • Type: TIMESTAMP

    • Required: YES

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

  • Created_Timestamp

    • Type: TIMESTAMP

    • Required: YES

    • Description: Timestamp indicating when the record was created.

  • Last_Modified_Timestamp

    • Type: TIMESTAMP

    • Required: YES

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

Record_Last_Modified_Timestamp

  • Type: TIMESTAMP

  • Required: YES

  • Description: The latest timestamp when any part of the record was updated, for data currency.

Transaction_User_ID

  • Type: STRING

  • Required: YES

  • Description: The identifier of the user associated with the transaction, providing a trace of interactions.

Deleted_Indicator

  • Type: BOOL

  • Required: YES

  • Description: A boolean flag indicating whether the record has been marked as deleted, crucial for data integrity.

Type

  • Type: STRING

  • Required: YES

  • Description: The type or category of the log entry, aiding in classification and filtering.

Tenant

  • Type: STRING

  • Required: YES

  • Description: Identifies the tenant domain within which the log record exists, important for multi-tenant environments.

Active_Version

  • Type: BOOL

  • Required: YES

  • Description: Indicates whether the log record is the current active version of the questionnaire metadata.

Date

  • Type: DATE

  • Required: YES

  • Description: The date associated with the log record, often used for historical tracking and reporting.

Sequence

  • Type: INT64

  • Required: YES

  • Description: A sequential number that orders the log entries, useful for sorting and historical analysis.

Source_System_Name

  • Type: STRING

  • Required: YES

  • Description: The name of the system from which the log data originates, key for data lineage.

Source_Timestamp

  • Type: TIMESTAMP

  • Required: YES

  • Description: The timestamp from the source system when the log entry was generated.

Questionnaire Dataset Specification

Questionnaire Metadata Log

Source_File_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name of the file from the source system, useful for data tracking and archival.

Schema_Version

  • Is Nullable: YES

  • Data Type: FLOAT64

  • Description: The version of the data schema to which the log record adheres, important for data consistency.

_updated

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A system-generated flag or timestamp indicating when the record was last updated, ensuring timeliness.

Action

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Represents the specific action taken or recorded in the log, providing clarity on the nature of the log entry.

Transaction_Actor_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of the actor performing the transaction.

Questionnaire Metadata Question Log

Questionnaire_Question_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for each question within the questionnaire, essential for tracking and managing individual questions.

Questionnaire_Version_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Identifies the version of the questionnaire to which the question belongs, allowing for version control and historical tracking.

Section_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Key that links the question to a specific section within the questionnaire, organizing the questionnaire content structurally.

Position

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Numerical order of the question within its section or the questionnaire, dictating the sequence in which questions are presented.

Member_Portal

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates whether the question is visible or relevant in the member-facing portal, guiding user experience design.

Provider_Portal

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Flags whether the question appears in the provider-facing portal, affecting how providers interact with the questionnaire.

Depth

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Represents the level of nesting or hierarchy for the question, useful in complex questionnaires with layered or conditional questions.

Required

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Boolean indicating whether answering the question is mandatory, ensuring critical data is collected in the questionnaire response.

Questionnaire_Question_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the individual who last modified the question, providing an audit trail for changes.

Questionnaire_Question_Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp of when the question was initially created, marking its origin in the system.

Questionnaire_Question_Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The last time the question was updated, tracking the most recent changes.

Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: A unique key for each log entry, facilitating the tracking of individual changes and updates to questionnaire questions.

Short_Question

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A brief or abbreviated form of the question, used for quick reference or in space-constrained contexts.

Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique code assigned to the question, aiding in identification and reference in analysis or reporting.

Response_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Defines the kind of response expected for the question, such as multiple choice, text, or numerical.\ See Dictionary Response Type table in the Dictionary Dataset Specification.

Response_Value_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Specifies the data type or nature of the response values, guiding data collection and validation processes.\ See Dictionary Response Value Type table in the Dictionary Dataset Specification.

Response_Value_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Provides a detailed explanation of the response value type, clarifying the expected input format or content.\ See Dictionary Response Value Type table in the Dictionary Dataset Specification.

Class

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Categorizes the question into a particular class or group, aiding in thematic organization and analysis.\ See Dictionary Questionnaire Class table in the Dictionary Dataset Specification.

Class_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Detailed explanation of the class, offering context and understanding of the question's thematic grouping.\ See Dictionary Questionnaire Class table in the Dictionary Dataset Specification.

Active

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Boolean indicating whether the question is currently active and should be presented in the questionnaire.

Question_Available_To_AWF

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Specifies whether the question is available for automated workflows, affecting how the question is processed in system operations.

Clinical_Help

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Help text or guidance provided within a clinical context, assisting users in understanding or answering the question accurately.

Non_Clinical_Help

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Additional help text or information provided in a non-clinical context, supporting users outside of direct patient care scenarios.

Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The ID of the user who last made changes to the question log, tracking the source of modifications.

Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The time and date when the log record for the question was created, establishing a chronological record of entries.

Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The most recent time and date the log record was updated, maintaining a history of changes.

Child_Questions

  • Is Nullable: NO

  • Data Type: ARRAY

  • Description: An array of child questions, if any, which are dependent on or related to the main question, supporting complex questionnaire structures.

Questionnaire Dataset Specification

Child Questions

Parameters

  • Questionnaire_Key

  • Type: INT64

  • Required: YES

  • Description: Identifier for the questionnaire to which the question belongs.

  • Questionnaire_Question_Key

  • Type: INT64

  • Required: YES

  • Description: Unique identifier for the questionnaire question.

  • Created_Timestamp

  • Type: TIMESTAMP

  • Required: YES

  • Description: Timestamp indicating when the record was created.

  • Last_Modified_User_ID

  • Type: STRING

  • Required: YES

  • Description: User ID of the user who last modified the record.

  • Last_Modified_Timestamp

  • Type: TIMESTAMP

  • Required: YES

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

Questionnaire Metadata Question Log

Entry Tests

  • Description: An array of conditions or criteria that must be met for the question to be presented or considered relevant, ensuring appropriate question display.

Parameters

  • Key

  • Type: INT64

  • Required: YES

  • Description: A unique identifier for each entry test.

  • Minimum_Value

  • Type: STRING

  • Required: YES

  • Description: The minimum acceptable value for the entry test.

  • Maximum_Value

  • Type: STRING

  • Required: YES

  • Description: The maximum acceptable value for the entry test.

  • Modified_User_ID

  • Type: STRING

  • Required: YES

  • Description: User ID of the user who last modified the record.

  • Created_Timestamp

  • Type: TIMESTAMP

  • Required: YES

  • Description: Timestamp indicating when the record was created.

  • Last_Modified_Timestamp

  • Type: TIMESTAMP

  • Required: YES

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

Enablers

  • Description: Defines conditions or thresholds that activate or modify the scoring function, allowing for dynamic and context-sensitive scoring.

Parameters

  • Child Questions

  • Questionnaire_Key

    • Type: INT64

    • Required: YES

    • Description: Identifier for the questionnaire to which the question belongs.

  • Questionnaire_Question_Key

    • Type: INT64

    • Required: YES

    • Description: Unique identifier for the questionnaire question.

  • Created_Timestamp

    • Type: TIMESTAMP

    • Required: YES

    • Description: Timestamp indicating when the record was created.

  • Last_Modified_User_ID

    • Type: STRING

    • Required: YES

    • Description: User ID of the user who last modified the record.

  • Last_Modified_Timestamp

    • Type: TIMESTAMP

    • Required: YES

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

Selections

  • Description: An array detailing the available choices or responses for the question, typically used for multiple-choice or selection-based questions.

Parameters

  • Key

  • Type: INT64

  • Required: YES

  • Description: A unique identifier for each selection.

  • Selection_Key

  • Type: INT64

  • Required: YES

  • Description: A unique identifier for the specific selection within the entry.

  • Scoring_Weight

  • Type: STRING

  • Required: YES

  • Description: The weight assigned to the selection for scoring purposes.

  • Modified_User_ID

  • Type: STRING

  • Required: YES

  • Description: User ID of the user who last modified the record.

  • Created_Timestamp

  • Type: TIMESTAMP

  • Required: YES

  • Description: Timestamp indicating when the record was created.

  • Last_Modified_Timestamp

  • Type: TIMESTAMP

  • Required: YES

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

Enablers

  • Description: Defines conditions or thresholds that activate or modify the scoring function, allowing for dynamic and context-sensitive scoring.

Parameters

  • Child Questions

  • Questionnaire_Key

    • Type: INT64

    • Required: YES

    • Description: Identifier for the questionnaire to which the question belongs.

  • Questionnaire_Question_Key

    • Type: INT64

    • Required: YES

    • Description: Unique identifier for the questionnaire question.

  • Created_Timestamp

    • Type: TIMESTAMP

    • Required: YES

    • Description: Timestamp indicating when the record was created.

  • Last_Modified_User_ID

    • Type: STRING

    • Required: YES

    • Description: User ID of the user who last modified the record.

  • Last_Modified_Timestamp

    • Type: TIMESTAMP

    • Required: YES

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

Problems

  • Description: A collection of problems associated with the selections.

Parameters

  • Key

  • Type: INT64

  • Required: YES

  • Description: A unique identifier for each problem within the selections.

  • Problem

  • Type: STRING

  • Required: YES

  • Description: The specific problem identified within the selection.

  • Problem_Description

  • Type: STRING

  • Required: YES

  • Description: A detailed description of the problem, providing more context and information.

  • Modified_User_ID

  • Type: STRING

  • Required: YES

  • Description: User ID of the user who last modified the record.

  • Created_Timestamp

  • Type: TIMESTAMP

  • Required: YES

  • Description: Timestamp indicating when the record was created.

  • Last_Modified_Timestamp

  • Type: TIMESTAMP

  • Required: YES

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

Versions

  • Description: Version of the selection.

Parameters

  • Key

  • Type: INT64

  • Required: YES

  • Description: A unique identifier for each version of the selection.

  • Question_Version_Key

  • Type: INT64

  • Required: YES

  • Description: A unique identifier for the version of the question associated with the selection.

  • Position

  • Type: STRING

  • Required: YES

  • Description: The order or position of the version within the selection.

  • Value

  • Type: STRING

  • Required: YES

  • Description: The value assigned to the version of the selection.

  • Clarification_Indicator

  • Type: STRING

  • Required: YES

  • Description: An indicator specifying whether clarification is needed for the version.

  • Mutual_Exclusive

  • Type: STRING

  • Required: YES

  • Description: Indicates whether the version is mutually exclusive with other versions.

  • Modified_User_ID

  • Type: STRING

  • Required: YES

  • Description: User ID of the user who last modified the record.

  • Created_Timestamp

  • Type: TIMESTAMP

  • Required: YES

  • Description: Timestamp indicating when the record was created.

  • Last_Modified_Timestamp

  • Type: TIMESTAMP

  • Required: YES

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

Questionnaire Dataset Specification

Questionnaire Metadata Question Log

Versions

  • Versions.Questionnaire_Version_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Refers to a specific version of the questionnaire.

  • Versions.Questionnaire_Version_Number

  • Is Nullable: YES

  • Data Type: INT64

  • Description: The numerical version number assigned to the questionnaire.

  • Versions.Full_Question_Clinical

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Full clinical question text.

  • Versions.Questionnaire_Effective_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the questionnaire became effective.

  • Versions.Questionnaire_Termination_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the questionnaire is terminated.

  • Versions.Question_Report_Title

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Title used for reporting purposes related to the question.

  • Versions.Question_Display_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Display type for the question in the user interface.

  • Versions.Question_Response_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the question response type. See Dictionary Response Type table in the Dictionary Dataset Specification.

  • Versions.Field_Length

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The length of the field for the version of the selection.

  • Versions.Input_Length

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The maximum length of input allowed for the version of the selection.

  • Versions.Maximum_Value

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The maximum value that can be assigned to the version of the selection.

  • Versions.Minimum_Value

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The minimum value that can be assigned to the version of the selection.

  • Versions.Selections_Allowed

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates whether multiple selections are allowed for the version.

  • Versions.Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the user who last modified the record.

  • Versions.Version_Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the record was created.

  • Versions.Version_Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Questionnaire Metadata Question Log Fields

  • Record_Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp of the last modification to the record, ensuring the log reflects the latest changes.

  • Transaction_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID associated with the transaction in the log, linking changes to specific user actions.

  • Deleted_Indicator

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: A boolean indicating whether the question log record has been marked as deleted, important for data integrity and historical tracking.

  • Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The type or category of the log record, often used to differentiate between different kinds of log entries.

  • Tenant

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the tenant domain or administrative boundary to which the log record pertains, crucial in multi-tenant systems.

  • Active_Version

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates whether the log entry represents the currently active version of the question, important for understanding the question's lifecycle.

  • Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: The date associated with the log entry, often used for sorting and historical analysis.

  • Sequence

  • Is Nullable: YES

  • Data Type: INT64

  • Description: A sequence number for the log entry, helping to order entries chronologically or logically.

  • Source_System_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the source system from which the log data is derived, aiding in data lineage.

  • Source_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp from the source system, indicating when the data was generated or logged, providing a time-based context for the data.

  • Source_File_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name of the file from the source system, useful for tracking the origin of the data and for audit purposes.

  • Schema_Version

  • Is Nullable: YES

  • Data Type: FLOAT64

  • Description: Indicates the version of the data schema that the log entry adheres to, ensuring compatibility and consistency in data interpretation.

  • _updated

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A flag or timestamp indicating when the log entry was last updated, providing a mechanism for tracking changes over time.

  • Action

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Describes the action represented by the log entry, such as 'create', 'update', or 'delete', offering insights into the nature of the changes recorded.

  • Transaction_Actor_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of the actor performing the transaction.

Questionnaire Metadata Scoring Function

  • Questionnaire_Function_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: A unique identifier for the scoring function within the questionnaire metadata, linking to specific scoring logic.

  • Questionnaire_Version_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Connects to a particular version of the questionnaire, ensuring that the scoring function applies to the correct set of questions and answers.

  • Section_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Identifies the section of the questionnaire that the scoring function is related to, helping to categorize and organize the scoring logic.

  • Position

  • Is Nullable: YES

  • Data Type: INT64

  • Description: The order in which the scoring function appears within the questionnaire or section, dictating the sequence of scoring evaluations.

  • Member_Portal

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates whether the scoring function is accessible or relevant in the member-facing portal, enabling personalized scoring mechanisms.

  • Provider_Portal

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Shows if the scoring function is used in the provider-facing portal, facilitating provider-specific assessments.

  • Questionnaire_Function_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The ID of the user who last modified the scoring function, providing an audit trail for changes.

  • Questionnaire_Function_Modified_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name of the user who last modified the scoring function.

Questionnaire Dataset Specification

Questionnaire Metadata Scoring Function

ING

  • Description: The name of the user who last modified the scoring function, providing an audit trail for changes.

Questionnaire_Function_Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when the scoring function was first created, giving a historical context.

Questionnaire_Function_Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The last time the scoring function was updated, offering insights into the currency of the scoring logic.

Scoring_Function_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: A primary key for the scoring function record, ensuring unique identification within the log.

Class

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Represents the classification or category of the scoring function, aiding in grouping similar functions.

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

Class_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A textual description of the class, providing clarity on the function's purpose or category.

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

Formula

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The actual scoring formula or algorithm used, critical for understanding how scores are calculated.

Formula_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Explains the logic and methodology behind the scoring formula, offering detailed insight into its operational mechanics.

Function

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifies the specific scoring function or method being applied, linking to predefined scoring algorithms.

Format_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Describes the format or structure of the scoring output, ensuring compatibility with reporting and analysis tools.

Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Tracks the creation, modification, and the user responsible for these actions, essential for maintaining the integrity and history of the scoring function data.

Modified_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Tracks the creation, modification, and the user responsible for these actions, essential for maintaining the integrity and history of the scoring function data.

Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Tracks the creation, modification, and the user responsible for these actions, essential for maintaining the integrity and history of the scoring function data.

Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Tracks the creation, modification, and the user responsible for these actions, essential for maintaining the integrity and history of the scoring function data.

Questionnaire Metadata Scoring Function Child Questions

Scoring_Function_Child_Question_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for each child question within the scoring function.

Questionnaire_Function_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Identifier linking to the primary scoring function this child question is part of.

Questionnaire_Question_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Identifier for the specific question in the questionnaire.

Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: ID of the user who last modified the record.

Modified_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the user who last modified the record.

Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the record was initially created.

Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the record was last modified.

Questionnaire Metadata Scoring Function Enablers

Scoring_Function_Enabler_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for each scoring function enabler.

Questionnaire_Function_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Identifier linking to the primary scoring function this enabler is part of.

Minimum_Value

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Minimum value assigned to this scoring function enabler.

Maximum_Value

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Maximum value assigned to this scoring function enabler.

Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: ID of the user who last modified the record.

Modified_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the user who last modified the record.

Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the record was initially created.

Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the record was last modified.

Questionnaire Metadata Scoring Function Enabler Questions

Scoring_Function_Enabler_Question_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for each enabler question within the scoring function.

Scoring_Function_Enabler_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Identifier linking to the primary scoring function enabler this question is part of.

Questionnaire_Question_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Identifier for the specific question in the questionnaire.

Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: ID of the user who last modified the record.

Modified_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the user who last modified the record.

Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the record was initially created.

Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the record was last modified.

Questionnaire Dataset Specification

Questionnaire Metadata Scoring Function Inputs

Table Details

  • Table Name: Questionnaire_Metadata_Scoring_Function_Inputs

Columns

  • Scoring_Function_Input_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for each input used in the scoring function.

  • Questionnaire_Function_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Identifier linking to the main scoring function to which this input belongs.

  • Questionnaire_Question_Key

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the specific question in the questionnaire associated with this input.

  • Required

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates if the input is mandatory for the scoring function (Yes/No).

  • Required_Once

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates if the input is required only once during the scoring process (Yes/No).

  • Parameter_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the parameter that describes the input.

  • Modified_User_ID

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: ID of the user who last modified this record.

  • Modified_User_Name

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Name of the user who last modified this record.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the record was initially created.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Questionnaire Metadata Scoring Function Versions

Table Details

  • Table Name: Questionnaire_Metadata_Scoring_Function_Versions

Columns

  • Scoring_Function_Version_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for each version of the scoring function.

  • Scoring_Function_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Identifier linking to the primary scoring function.

  • Version_Number

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Version number of the scoring function.

  • Score_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the score for this version.

  • Report_Title

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Title of the report associated with this scoring function version.

  • Effective_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when this version of the scoring function became effective.

  • Effective_Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: Date when this version of the scoring function became effective.

  • Termination_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when this version of the scoring function was terminated or replaced.

  • Termination_Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: Date when this version of the scoring function was terminated or replaced.

  • Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: ID of the user who last modified this version record.

  • Modified_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the user who last modified this version record.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when this version record was initially created.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when this version record was last modified.

Questionnaire Metadata Scoring Function Log

Table Details

  • Table Name: Questionnaire_Metadata_Scoring_Function_log

Columns

  • Questionnaire_Function_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: A unique identifier for the scoring function within the questionnaire metadata, linking to specific scoring logic.

  • Questionnaire_Version_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Connects to a particular version of the questionnaire, ensuring that the scoring function applies to the correct set of questions and answers.

  • Section_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Identifies the section of the questionnaire that the scoring function is related to, helping to categorize and organize the scoring logic.

  • Position

  • Is Nullable: YES

  • Data Type: INT64

  • Description: The order in which the scoring function appears within the questionnaire or section, dictating the sequence of scoring evaluations.

  • Member_Portal

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates whether the scoring function is accessible or relevant in the member-facing portal, enabling personalized scoring mechanisms.

  • Provider_Portal

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Shows if the scoring function is used in the provider-facing portal, facilitating provider-specific assessments.

  • Questionnaire_Function_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The ID of the user who last modified the scoring function, providing an audit trail for changes.

  • Questionnaire_Function_Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when the scoring function was first created, giving a historical context.

  • Questionnaire_Function_Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The last time the scoring function was updated, offering insights into the currency of the scoring logic.

  • Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: A primary key for the scoring function log record, ensuring unique identification within the log.

  • Class

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Represents the classification or category of the scoring function, aiding in grouping similar functions. See Dictionary Questionnaire Class table in the Dictionary Dataset Specification.

  • Class_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A textual description of the class, providing clarity on the function's purpose or category. See Dictionary Questionnaire Class table in the Dictionary Dataset Specification.

Questionnaire Dataset Specification

Questionnaire Metadata Scoring Function Log

Formula

  • Type: YES STRING

  • Description: The actual scoring formula or algorithm used, critical for understanding how scores are calculated.

Formula Description

  • Type: YES STRING

  • Description: Explains the logic and methodology behind the scoring formula, offering detailed insight into its operational mechanics.

Function

  • Type: YES STRING

  • Description: Identifies the specific scoring function or method being applied, linking to predefined scoring algorithms.

Format Type

  • Type: YES STRING

  • Description: Describes the format or structure of the scoring output, ensuring compatibility with reporting and analysis tools.

Modified User ID

  • Type: YES STRING

  • Description: Tracks the creation, modification, and the user responsible for these actions, essential for maintaining the integrity and history of the scoring function data.

Created Timestamp

  • Type: YES TIMESTAMP

  • Description: Tracks the creation, modification, and the user responsible for these actions, essential for maintaining the integrity and history of the scoring function data.

Last Modified Timestamp

  • Type: YES TIMESTAMP

  • Description: Tracks the creation, modification, and the user responsible for these actions, essential for maintaining the integrity and history of the scoring function data.

Inputs

  • Type: NO ARRAY

  • Description: A collection of inputs or variables used in the scoring function, detailing the data elements that influence the scoring outcome.

Parameters in Inputs Array:

  • Questionnaire Key

  • Type: YES INT64

  • Description: Identifier for the questionnaire to which the question belongs.

  • Questionnaire Question Key

  • Type: YES INT64

  • Description: Unique identifier for the questionnaire question.

  • Required

  • Type: YES STRING

  • Description: Indicates whether the input is mandatory for the process or form.

  • Required Once

  • Type: YES STRING

  • Description: Specifies if the input is required only once during the process or form submission.

  • Parameter Name

  • Type: YES STRING

  • Description: The name of the parameter for the input, used for identification and reference purposes.

  • Modified User ID

  • Type: YES STRING

  • Description: User ID of the user who last modified the record.

  • Created Timestamp

  • Type: YES TIMESTAMP

  • Description: Timestamp indicating when the record was created.

  • Last Modified Timestamp

  • Type: YES TIMESTAMP

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

Child Questions

  • Type: NO ARRAY

  • Description: Lists sub-questions or dependent questions that are part of the scoring mechanism, showing the hierarchical structure of questionnaire logic.

Parameters in Child Questions Array:

  • Questionnaire Key

  • Type: YES INT64

  • Description: Identifier for the questionnaire to which the question belongs.

  • Questionnaire Question Key

  • Type: YES INT64

  • Description: Unique identifier for the questionnaire question.

  • Modified User ID

  • Type: YES STRING

  • Description: User ID of the user who last modified the record.

  • Created Timestamp

  • Type: YES TIMESTAMP

  • Description: Timestamp indicating when the record was created.

  • Last Modified Timestamp

  • Type: YES TIMESTAMP

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

Enablers

  • Type: NO ARRAY

  • Description: Defines conditions or thresholds that activate or modify the scoring function, allowing for dynamic and context-sensitive scoring.

Parameters in Enablers Array:

  • Key

  • Type: YES INT64

  • Description: A unique identifier for each enabler.

  • Minimum Value

  • Type: YES STRING

  • Description: The minimum value required for the enabler to be active or valid.

  • Maximum Value

  • Type: YES STRING

  • Description: The maximum value allowed for the enabler to be active or valid.

  • Modified User ID

  • Type: YES STRING

  • Description: User ID of the user who last modified the record.

  • Created Timestamp

  • Type: YES TIMESTAMP

  • Description: Timestamp indicating when the record was created.

  • Last Modified Timestamp

  • Type: YES TIMESTAMP

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

Parameters in Enablers Questions Array:

  • Questionnaire Key

  • Type: YES INT64

  • Description: Identifier for the questionnaire to which the question belongs.

  • Questionnaire Question Key

  • Type: YES INT64

  • Description: Unique identifier for the questionnaire question.

  • Modified User ID

  • Type: YES STRING

  • Description: User ID of the user who last modified the record.

  • Created Timestamp

  • Type: YES TIMESTAMP

  • Description: Timestamp indicating when the record was created.

  • Last Modified Timestamp

  • Type: YES TIMESTAMP

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

Versions

  • Type: NO ARRAY

  • Description: Tracks different iterations or versions of the scoring function, accommodating updates and changes over time.

Parameters in Versions Array:

  • Scoring Function Key

  • Type: YES INT64

  • Description: Refers to a specific scoring function used to calculate scores based on questionnaire responses.

  • Scoring Function Version Number

  • Type: YES INT64

  • Description: The version number associated with the scoring function.

  • Scoring Function Score Description

  • Type: YES STRING

  • Description: Describes the meaning or interpretation of the scores generated by the scoring function.

  • Scoring Function Report Title

  • Type: YES STRING

  • Description: The title assigned to the report or summary that includes the member’s scores.

  • Questionnaire Effective Timestamp

  • Type: YES TIMESTAMP

  • Description: The date when the questionnaire becomes effective or applicable.

  • Questionnaire Termination Timestamp

  • Type: YES TIMESTAMP

  • Description: The date when the questionnaire is no longer valid or applicable.

  • Modified User ID

  • Type: YES STRING

  • Description: User ID of the user who last modified the record.

  • Created Timestamp

  • Type: YES TIMESTAMP

  • Description: Timestamp indicating when the record was created.

  • Last Modified Timestamp

  • Type: YES TIMESTAMP

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

Questionnaire Dataset Specification

Questionnaire Metadata Scoring Function Log

Record_Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Indicates the last time any part of the record was updated, providing a timestamp for the most recent change.

Transaction_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifies the user who made the last transaction or modification to the scoring function, aiding in audit and accountability.

Deleted_Indicator

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: A boolean value indicating whether the scoring function has been marked as deleted, helping to manage the lifecycle and visibility of the scoring functions within the system.

Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Categorizes the scoring function log entry, perhaps differentiating between different types of scoring activities or methodologies used in the questionnaire.

Tenant

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Represents the tenant or domain within which the scoring function is used, allowing for multi-tenant segmentation and management of scoring functions.

Active_Version

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: A boolean flag indicating whether the version of the scoring function being logged is the active or currently used version, important for identifying the relevant scoring logic in use at any given time.

Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: The date associated with the log entry, possibly indicating when the scoring function was applied or assessed.

Sequence

  • Is Nullable: YES

  • Data Type: INT64

  • Description: A numerical order or sequence number that may indicate the position or precedence of the scoring function within a set or process.

Source_System_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name of the system from which the scoring function log entry originated, useful for tracing the source of data and understanding the system landscape.

Source_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp from the source system, indicating when the log entry or the scoring function action was originally recorded or initiated.

Source_File_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name of the file or dataset from the source system, providing a reference to the original data or configuration used for the scoring function.

Schema_Version

  • Is Nullable: YES

  • Data Type: FLOAT64

  • Description: Indicates the version of the data schema used for the scoring function log, ensuring compatibility and understanding of the data structure.

_updated

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A string or timestamp indicating when the log entry was last updated, providing a temporal reference for data changes or updates.

Action

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Describes the action taken in the log entry, such as creating, updating, or deleting a scoring function, giving context to the nature of the log record.

Transaction_Actor_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of the actor performing the transaction.

Questionnaire Metadata Raw

Questionnaire_Version_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for a specific version of a questionnaire.

Version_Number

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Numeric value representing the version number of the questionnaire.

Title

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Descriptive title or name of the questionnaire.

Effective_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the questionnaire version becomes effective.

Termination_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the questionnaire version is terminated or no longer valid.

Version_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the user who last modified the questionnaire version.

Version_Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the questionnaire version was initially created.

Version_Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating the most recent modification time for the questionnaire version.

Questionnaire_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for the entire questionnaire.

Questionnaire_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Code or short identifier associated with the questionnaire.

Class

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Classification or category of the questionnaire (e.g., medical history, lifestyle assessment).\ See Dictionary Questionnaire Class table in the Dictionary Dataset Specification.

Class_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Additional details or context about the specified questionnaire class.\ See Dictionary Questionnaire Class table in the Dictionary Dataset Specification.

Help

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Information or guidance related to the questionnaire.

Position

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Indicates the position or order of the questionnaire within a set or sequence.

Active_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the questionnaire version becomes active or usable.

Inactive_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the questionnaire version is no longer active or valid.

Dashboard_Indicator

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Boolean indicator specifying whether the questionnaire appears on a dashboard or summary view.

All_Roles_Indicator

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Boolean indicator specifying whether the questionnaire is accessible to all user roles.

All_Customer_Categories_Indicator

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Boolean indicator specifying whether the questionnaire is applicable to all customer categories.

Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the user who last modified the questionnaire.

Customer_Categories

  • Is Nullable: NO

  • Data Type: ARRAY

  • Description: Categories or groups of customers associated with the questionnaire.

Questionnaire Dataset Specification

Customer Categories

Key

  • Customer_Categories.Code\ Is Nullable: YES\ Data Type: STRING

Questionnaire Effective Timestamp

  • Customer_Categories.Questionnaire_Effective_Timestamp\ Is Nullable: YES\ Data Type: TIMESTAMP\ Description: The date when the questionnaire becomes effective or applicable.

Questionnaire Termination Timestamp

  • Customer_Categories.Questionnaire_Termination_Timestamp\ Is Nullable: YES\ Data Type: TIMESTAMP\ Description: The date when the questionnaire is no longer valid or applicable.

Modified User ID

  • Customer_Categories.Modified_User_ID\ Is Nullable: YES\ Data Type: STRING\ Description: User ID of the user who last modified the record.

Created Timestamp

  • Customer_Categories.Created_Timestamp\ Is Nullable: YES\ Data Type: TIMESTAMP\ Description: Timestamp indicating when the record was created.

Last Modified Timestamp

  • Customer_Categories.Last_Modified_Timestamp\ Is Nullable: YES\ Data Type: TIMESTAMP\ Description: Timestamp indicating when the record was last modified.

Questionnaire Metadata

Programs

An array of programs associated with the questionnaire, defining its application or relevance in various programmatic contexts.

Parameters in the Array:

  • Programs.Key\ Is Nullable: YES\ Data Type: INT64\ Description: A unique identifier for each program.

  • Programs.Program\ Is Nullable: YES\ Data Type: STRING\ Description: The name or title of the program.

  • Programs.Program_Description\ Is Nullable: YES\ Data Type: STRING\ Description: A detailed description of the program, outlining its purpose and scope.

  • Programs.Primary\ Is Nullable: YES\ Data Type: STRING\ Description: Indicates whether the program is the primary or main program among multiple programs.

  • Programs.Effective_Timestamp\ Is Nullable: YES\ Data Type: TIMESTAMP\ Description: The date when the questionnaire becomes effective or applicable.

  • Programs.Termination_Timestamp\ Is Nullable: YES\ Data Type: TIMESTAMP\ Description: The date when the questionnaire is no longer valid or applicable.

  • Programs.Modified_User_ID\ Is Nullable: YES\ Data Type: STRING\ Description: User ID of the user who last modified the record.

  • Programs.Created_Timestamp\ Is Nullable: YES\ Data Type: TIMESTAMP\ Description: Timestamp indicating when the record was created.

  • Programs.Last_Modified_Timestamp\ Is Nullable: YES\ Data Type: TIMESTAMP\ Description: Timestamp indicating when the record was last modified.

Roles

An array defining the roles for which the questionnaire is intended, ensuring appropriate targeting and use.

Parameters in the Array:

  • Roles.Program_Provider_Roles_Key\ Is Nullable: YES\ Data Type: INT64\ Description: Unique identifier for the program provider roles entry.

  • Roles.Role_Code\ Is Nullable: YES\ Data Type: STRING\ Description: Code representing the role of the provider within the program.

  • Roles.Role_Description\ Is Nullable: YES\ Data Type: STRING\ Description: Description of the role of the provider within the program.

  • Roles.Role_Effective_Date\ Is Nullable: YES\ Data Type: DATE\ Description: Effective date of the provider's role within the program.

  • Roles.Role_Termination_Date\ Is Nullable: YES\ Data Type: DATE\ Description: Termination date of the provider's role within the program, if applicable.

  • Roles.Role_Created_Timestamp\ Is Nullable: YES\ Data Type: TIMESTAMP\ Description: Timestamp indicating when the provider's role entry was created.

  • Roles.Role_Last_Modified_Timestamp\ Is Nullable: YES\ Data Type: TIMESTAMP\ Description: Timestamp indicating when the provider's role entry was last modified.

Sections

An array detailing the different sections of the questionnaire, aiding in structuring and organizing the content.

Parameters in the Array:

  • Sections.Key\ Is Nullable: YES\ Data Type: STRING\ Description: A unique identifier for each section within the questionnaire.

  • Sections.Title\ Is Nullable: YES\ Data Type: STRING\ Description: The title or name of the section, providing a brief overview of its content.

  • Sections.Position\ Is Nullable: YES\ Data Type: STRING\ Description: The order or position of the section within the questionnaire.

  • Sections.Help_Text\ Is Nullable: YES\ Data Type: STRING\ Description: Additional information or instructions to assist users in understanding the section.

  • Sections.Modified_User_ID\ Is Nullable: YES\ Data Type: TIMESTAMP\ Description: Timestamp indicating when the record was last modified.

  • Sections.Created_Timestamp\ Is Nullable: YES\ Data Type: TIMESTAMP\ Description: Timestamp indicating when the record was created.

  • Sections.Last_Modified_Timestamp\ Is Nullable: YES\ Data Type: TIMESTAMP\ Description: Timestamp indicating when the record was last modified.

Additional Metadata Fields

  • Questionnaire_Metadata_raw.Record_Last_Modified_Timestamp\ Is Nullable: YES\ Data Type: TIMESTAMP\ Description: Timestamp indicating the most recent modification time for any record related to the questionnaire.

  • Questionnaire_Metadata_raw.Transaction_User_ID\ Is Nullable: YES\ Data Type: STRING\ Description: Identifier for the user associated with a specific transaction related to the questionnaire.

  • Questionnaire_Metadata_raw.Deleted_Indicator\ Is Nullable: YES\ Data Type: BOOL\ Description: Boolean indicator specifying whether the questionnaire version is deleted or archived.

  • Questionnaire_Metadata_raw.Type\ Is Nullable: YES\ Data Type: STRING\ Description: Type or category of the questionnaire (e.g., assessment, survey).

  • Questionnaire_Metadata_raw.Tenant\ Is Nullable: YES\ Data Type: STRING\ Description: Identifier for the specific tenant or organization associated with the questionnaire.

  • Questionnaire_Metadata_raw.Active_Version\ Is Nullable: YES\ Data Type: BOOL\ Description: Indicates the currently active version of the questionnaire.

  • Questionnaire_Metadata_raw.Date\ Is Nullable: YES\ Data Type: DATE\ Description: Date associated with the questionnaire (e.g., creation date, effective date).

  • Questionnaire_Metadata_raw.Sequence\ Is Nullable: YES\ Data Type: INT64\ Description: Numeric order or sequence of the questionnaire within a larger process or workflow.

  • Questionnaire_Metadata_raw.Source_System_Name\ Is Nullable: YES\ Data Type: STRING\ Description: Name of the system or source from which the questionnaire data originates.

  • Questionnaire_Metadata_raw.Source_Timestamp\ Is Nullable: YES\ Data Type: TIMESTAMP\ Description: Timestamp indicating when the questionnaire data was sourced or imported.

  • Questionnaire_Metadata_raw.Source_File_Name\ Is Nullable: YES\ Data Type: STRING\ Description: Name of the file or data source containing the questionnaire information.

  • Questionnaire_Metadata_raw.Schema_Version\ Is Nullable: YES\ Data Type: FLOAT64\ Description: Version of the data schema or structure used for the questionnaire.

  • Questionnaire_Metadata_raw._updated\ Is Nullable: YES\ Data Type: STRING\ Description: Internal field indicating the last update time for the questionnaire record.

  • Questionnaire_Metadata_raw.Transaction_Actor_Type\ Is Nullable: YES\ Data Type: STRING\ Description: Type of the actor performing the transaction.

Questionnaire Scoring Function

Parameters

  • Questionnaire_Metadata_Scoring_Function_raw.Questionnaire_Function_Key\ Is Nullable: YES\ Data Type: INT64\ Description: Unique identifier for a specific function associated with a questionnaire.

  • Questionnaire_Metadata_Scoring_Function_raw.Questionnaire_Version_Key\ Is Nullable: YES\ Data Type: INT64\ Description: Identifier linking the function to a specific version of the questionnaire.

  • Questionnaire_Metadata_Scoring_Function_raw.Section_Key\ Is Nullable: YES\ Data Type: INT64\ Description: Unique identifier for a section within the questionnaire.

  • Questionnaire_Metadata_Scoring_Function_raw.Position\ Is Nullable: YES\ Data Type: INT64\ Description: Indicates the position of the scoring function.

Questionnaire Dataset Specification

Questionnaire Metadata Scoring Function Raw

Member Portal

  • YES\ Type: BOOL\ Boolean indicator specifying whether the function is accessible via the member portal.

Provider Portal

  • YES\ Type: BOOL\ Boolean indicator specifying whether the function is accessible via the provider portal.

Questionnaire Function Modified User ID

  • YES\ Type: STRING\ Identifier for the user who last modified the function.

Questionnaire Function Created Timestamp

  • YES\ Type: TIMESTAMP\ Timestamp indicating when the function was initially created.

Questionnaire Function Last Modified Timestamp

  • YES\ Type: TIMESTAMP\ Timestamp indicating the most recent modification time for the function.

Key

  • YES\ Type: INT64\ Additional identifier or key associated with the function.

Class

  • YES\ Type: STRING\ Classification or category of the function (e.g., scoring, calculation).\ See Dictionary Questionnaire Class table in the Dictionary Dataset Specification.

Class Description

  • YES\ Type: STRING\ Provides additional context or details about the specified function class.\ See Dictionary Questionnaire Class table in the Dictionary Dataset Specification.

Formula

  • YES\ Type: STRING\ Mathematical or logical formula used by the function.

Formula Description

  • YES\ Type: STRING\ Elaborates on the purpose or interpretation of the specified formula.

Function

  • YES\ Type: STRING\ Describes the specific purpose or operation performed by the function.

Format Type

  • YES\ Type: STRING\ Specifies the data format or type expected for the function output.

Modified User ID

  • YES\ Type: STRING\ Identifier for the user who last modified the function.

Inputs

Overview

  • NO\ Type: ARRAY\ A collection of inputs or variables used in the scoring function, detailing the data elements that influence the scoring outcome.\ See below for detailed information on each parameter in the array.

Parameters

Questionnaire Key

  • YES\ Type: INT64\ Identifier for the questionnaire to which the question belongs.

Questionnaire Question Key

  • YES\ Type: INT64\ Unique identifier for the questionnaire question.

Required

  • YES\ Type: STRING\ Indicates whether the input is mandatory for the process or form.

Required Once

  • YES\ Type: STRING\ Specifies if the input is required only once during the process or form submission.

Parameter Name

  • YES\ Type: STRING\ The name of the parameter for the input, used for identification and reference purposes.

Modified User ID

  • YES\ Type: STRING\ User ID of the user who last modified the record.

Created Timestamp

  • YES\ Type: TIMESTAMP\ Timestamp indicating when the record was created.

Last Modified Timestamp

  • YES\ Type: TIMESTAMP\ Timestamp indicating when the record was last modified.

Child Questions

Overview

  • NO\ Type: ARRAY\ Lists sub-questions or dependent questions that are part of the scoring mechanism, showing the hierarchical structure of questionnaire logic.\ See below for detailed information on each parameter in the array.

Parameters

Questionnaire Key

  • YES\ Type: INT64\ Identifier for the questionnaire to which the question belongs.

Questionnaire Question Key

  • YES\ Type: INT64\ Unique identifier for the questionnaire question.

Modified User ID

  • YES\ Type: STRING\ User ID of the user who last modified the record.

Created Timestamp

  • YES\ Type: TIMESTAMP\ Timestamp indicating when the record was created.

Last Modified Timestamp

  • YES\ Type: TIMESTAMP\ Timestamp indicating when the record was last modified.

Enablers

Overview

  • NO\ Type: ARRAY\ Defines conditions or thresholds that activate or modify the scoring function, allowing for dynamic and context-sensitive scoring.\ See below for detailed information on each parameter in the array.

Parameters

Key

  • YES\ Type: INT64\ A unique identifier for each enabler.

Minimum Value

  • YES\ Type: STRING\ The minimum value required for the enabler to be active or valid.

Maximum Value

  • YES\ Type: STRING\ The maximum value allowed for the enabler to be active or valid.

Modified User ID

  • YES\ Type: STRING\ User ID of the user who last modified the record.

Created Timestamp

  • YES\ Type: TIMESTAMP\ Timestamp indicating when the record was created.

Last Modified Timestamp

  • YES\ Type: TIMESTAMP\ Timestamp indicating when the record was last modified.

Questions

Questionnaire Key

  • YES\ Type: INT64\ Identifier for the questionnaire to which the question belongs.

Questionnaire Question Key

  • YES\ Type: INT64\ Unique identifier for the questionnaire question.

Modified User ID

  • YES\ Type: STRING\ User ID of the user who last modified the record.

Created Timestamp

  • YES\ Type: TIMESTAMP\ Timestamp indicating when the record was created.

Last Modified Timestamp

  • YES\ Type: TIMESTAMP\ Timestamp indicating when the record was last modified.

Versions

Overview

  • NO\ Type: ARRAY\ Tracks different iterations or versions of the scoring function, accommodating updates and changes over time.\ See below for detailed information on each parameter in the array.

Parameters

Scoring Function Key

  • YES\ Type: INT64\ Refers to a specific scoring function used to calculate scores based on questionnaire responses.

Scoring Function Version Number

  • YES\ Type: INT64\ The version number associated with the scoring function.

Scoring Function Score Description

  • YES\ Type: STRING\ Describes the meaning or interpretation of the scores generated by the scoring function.

Scoring Function Re

(Content ends abruptly)

Questionnaire Dataset Specification

Report Metadata

port_Title

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The title assigned to the report or summary that includes the member’s scores.

Versions Metadata

Versions.Questionnaire_Effective_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date when the questionnaire becomes effective or applicable.

Versions.Questionnaire_Termination_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date when the questionnaire is no longer valid or applicable.

Versions.Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the user who last modified the record.

Versions.Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the record was created.

Versions.Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Questionnaire Metadata Scoring Function

Questionnaire_Metadata_Scoring_Function_raw.Record_Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating the most recent modification time for any record related to the function.

Questionnaire_Metadata_Scoring_Function_raw.Transaction_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the user associated with a specific transaction related to the function.

Questionnaire_Metadata_Scoring_Function_raw.Deleted_Indicator

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Boolean indicator specifying whether the function is deleted or archived.

Questionnaire_Metadata_Scoring_Function_raw.Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Specifies the type or category of the function (e.g., scoring, validation).

Questionnaire_Metadata_Scoring_Function_raw.Tenant

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the specific tenant or organization associated with the function.

Questionnaire_Metadata_Scoring_Function_raw.Active_Version

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates the currently active version of the function.

Questionnaire_Metadata_Scoring_Function_raw.Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: Date associated with the function (e.g., creation date, effective date).

Questionnaire_Metadata_Scoring_Function_raw.Sequence

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Numeric order or sequence of the function within a larger process or workflow.

Questionnaire_Metadata_Scoring_Function_raw.Source_System_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the system or source from which the function data originates.

Questionnaire_Metadata_Scoring_Function_raw.Source_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the function data was sourced or imported.

Questionnaire_Metadata_Scoring_Function_raw.Source_File_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the file or data source containing the function information.

Questionnaire_Metadata_Scoring_Function_raw.Schema_Version

  • Is Nullable: YES

  • Data Type: FLOAT64

  • Description: Version of the data schema or structure used for the function.

Questionnaire_Metadata_Scoring_Function_raw._updated

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Internal field indicating the last update time for the function record.

Questionnaire_Metadata_Scoring_Function_raw.Transaction_Actor_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of the actor performing the transaction.

Questionnaire Raw Data

Questionnaire_raw.Member_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique identifier for each individual or member participating in the questionnaire.

Questionnaire_raw.Questionnaire_Response_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: A key or identifier associated with a specific response or submission within the questionnaire.

Questionnaire_raw.Class

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Represents a classification or category associated with the member (e.g., patient class, risk group, etc.).\ See Dictionary Questionnaire Class table in the Dictionary Dataset Specification.

Questionnaire_raw.Class_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A textual description corresponding to the specific class or category assigned to the member.\ See Dictionary Questionnaire Class table in the Dictionary Dataset Specification.

Questionnaire_raw.Response_Note

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Additional notes or comments related to the questionnaire response.

Questionnaire_raw.Complete_Indicator

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates whether the questionnaire response is complete or partially filled out.

Questionnaire_raw.Source

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The origin or channel through which the questionnaire data was collected (e.g., web form, paper survey).

Questionnaire_raw.Source_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Describes the source or method used to collect the questionnaire data.

Questionnaire_raw.Source_Entry_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the questionnaire response was entered or recorded.

Questionnaire_raw.Completed_By_Auto_Close

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates whether the completion of the questionnaire was automatically triggered (e.g., timed out).

Questionnaire_raw.Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifies the user who last modified the questionnaire response.

Questionnaire_raw.Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the questionnaire response was initially created.

Questionnaire_raw.Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The most recent date and time when the questionnaire response was modified.

Questionnaire_raw.Questionnaire

  • Is Nullable: YES

  • Data Type: STRUCT

  • Description: Refers to the specific questionnaire administered to the member.\ See below for detailed information on each parameter in the Structure.

Questionnaire.Questionnaire_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Identifies the specific questionnaire administered to the member.

Questionnaire.Questionnaire_Version_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Refers to a specific version of the questionnaire.

Questionnaire.Questionnaire_Version_Number

  • Is Nullable: YES

  • Data Type: INT64

  • Description: The numerical version number assigned to the questionnaire.

Questionnaire.Questionnaire_Title

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The title or name of the questionnaire used for assessment.

Questionnaire.Questionnaire_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A code or identifier associated with the questionnaire.

Questionnaire.Dashboard_Indicator

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates whether the member’s scores are displayed on a dashboard or summary view.

Questionnaire.Questionnaire_Effective_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date when the questionnaire becomes effective or applicable.

Questionnaire.Questionnaire_Termination_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date when the questionnaire is no longer valid or applicable.

Questionnaire.Questionnaire_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifies the user who last modified the questionnaire details.

Questionnaire.Questionnaire_Modified_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name of the user who last modified the questionnaire details.

Questionnaire.Questionnaire_Version_Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the specific questionnaire version was created.

Questionnaire Dataset Specification

Questionnaire Metadata

Questionnaire_Version_Last_Modified_Timestamp

  • Type: TIMESTAMP

  • Description: The most recent date and time when the questionnaire version was modified.

Questionnaire Raw Score Responses

Score_Responses

  • Type: ARRAY

  • Description: Pertains to the recorded scores associated with the questionnaire responses. Detailed information on each parameter in the array is provided below.

Score_Response_Key

  • Type: INT64

  • Description: A key or identifier associated with a specific score response within the questionnaire.

Calculated_Score

  • Type: NUMERIC

  • Description: The computed score based on questionnaire responses and scoring functions.

Score_Response_Void_Indicator

  • Type: BOOL

  • Description: Indicates whether the score response has been voided or invalidated.

Score_Response_Void_Timestamp

  • Type: TIMESTAMP

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

Score_Response_Void_User_ID

  • Type: STRING

  • Description: Identifies the user who voided the score response.

Score_Response_Void_User_Name

  • Type: STRING

  • Description: The name of the user who voided the score response.

Score_Response_Void_Reason

  • Type: STRING

  • Description: The reason or explanation for voiding the score response.

Score_Response_Void_Reason_Description

  • Type: STRING

  • Description: Provides a detailed description of the void reason.

Score_Response_Modified_User_ID

  • Type: STRING

  • Description: Identifies the user who last modified the score response.

Score_Response_Modified_User_Name

  • Type: STRING

  • Description: The name of the user who last modified the score response.

Score_Response_Created_Timestamp

  • Type: TIMESTAMP

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

Score_Response_Last_Modified_Timestamp

  • Type: TIMESTAMP

  • Description: The most recent date and time when the score response was modified.

Scoring_Function

Scoring_Function_Key

  • Type: INT64

  • Description: Refers to a specific scoring function used to calculate scores based on questionnaire responses.

Scoring_Function_Version_Number

  • Type: INT64

  • Description: The version number associated with the scoring function.

Scoring_Function_Score_Description

  • Type: STRING

  • Description: Describes the meaning or interpretation of the scores generated by the scoring function.

Scoring_Function_Report_Title

  • Type: STRING

  • Description: The title assigned to the report or summary that includes the member’s scores.

Scoring_Function_Version_Key

  • Type: INT64

  • Description: Refers to a specific version of the scoring function.

Scoring_Function_Formula

  • Type: STRING

  • Description: Specifies the mathematical formula or algorithm used to compute scores.

Scoring_Function_Formula_Description

  • Type: STRING

  • Description: Provides a detailed explanation of the mathematical formula or algorithm used to compute scores.

Scoring_Function

  • Type: STRING

  • Description: Indicates the type of scoring method employed (e.g., Likert scale, weighted scoring, etc.).

Scoring_Function_Format_Type

  • Type: STRING

  • Description: Describes the format of the scores (e.g., numeric, categorical, etc.).

Scoring_Function_Effective_Timestamp

  • Type: TIMESTAMP

  • Description: The date when the specific scoring function becomes effective or applicable.

Scoring_Function_Termination_Timestamp

  • Type: TIMESTAMP

  • Description: The date when the specific scoring function is no longer valid or applicable.

Scoring_Function_Modified_User_ID

  • Type: STRING

  • Description: Identifies the user who last modified the details of the scoring function.

Scoring_Function_Modified_User_Name

  • Type: STRING

  • Description: The name of the user who last modified the details of the scoring function.

Scoring_Function_Version_Created_Timestamp

  • Type: TIMESTAMP

  • Description: The date and time when a specific version of the scoring function was created.

Questionnaire Raw Question Responses

Question_Responses

  • Type: ARRAY

  • Description: Represents the individual responses to specific questions within the questionnaire. Detailed information on each parameter in the array is provided below.

Question_Response_Key

  • Type: INT64

  • Description: Identifier for the question response.

Question_Response_Scoring_Weight

  • Type: NUMERIC

  • Description: Weight or score assigned to the question response.

Question_Response_Modified_User_ID

  • Type: STRING

  • Description: ID of the user who modified the question response.

Question_Response_Modified_User_Name

  • Type: STRING

  • Description: Name of the user who modified the question response.

Question

Question_Position

  • Type: INT64

  • Description: Position of the question in the questionnaire.

Question_Key

  • Type: INT64

  • Description: Identifier for the question.

Question_Version_Key

  • Type: INT64

  • Description: Identifier for the version of the question.

Question_Version_Number

  • Type: INT64

  • Description: Version number of the question.

Full_Question_Clinical

  • Type: STRING

  • Description: Full clinical question text.

Short_Question

  • Type: STRING

  • Description: Abbreviated or shortened version of the question.

Question_Report_Title

  • Type: STRING

  • Description: Title used for reporting purposes related to the question.

Question_Code

  • Type: STRING

  • Description: Code associated with the question.

Question_Response_Type

  • Type: STRING

  • Description: Type of response expected for the question. See Dictionary Response Type table in the Dictionary Dataset Specification.

Question_Display_Type

  • Type: STRING

  • Description: Display type for the question in the user interface.

Question_Response_Type_Description

  • Type: STRING

  • Description: Description of the question response type. See Dictionary Response Type table in the Dictionary Dataset Specification.

Question_Response_Value_Type

  • Type: STRING

  • Description: Specifies the value type of the question response.

Questionnaire Dataset Specification

Question Responses

Question Attributes

  • Question_Response_Value_Type_Description

  • Data Type: STRING

  • Description: Description of the data type of the response value. See Dictionary Response Value Type table in the Dictionary Dataset Specification.

  • Question_Effective_Timestamp

  • Data Type: TIMESTAMP

  • Description: Timestamp when the question became effective.

  • Question_Termination_Timestamp

  • Data Type: TIMESTAMP

  • Description: Timestamp when the question is terminated.

  • Question_Modified_User_ID

  • Data Type: STRING

  • Description: ID of the user who modified the question.

  • Question_Modified_User_Name

  • Data Type: STRING

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

  • Question_Version_Created_Timestamp

  • Data Type: TIMESTAMP

  • Description: Timestamp when the version of the question was created.

  • Question_Version_Last_Modified_Timestamp

  • Data Type: TIMESTAMP

  • Description: Timestamp of the last modification to the question version.

  • Question_Response_Created_Timestamp

  • Data Type: TIMESTAMP

  • Description: Timestamp when the question response was created.

  • Question_Response_Last_Modified_Timestamp

  • Data Type: TIMESTAMP

  • Description: Timestamp of the last modification to the question response.

Response Details

  • Response_Detail_Key

  • Data Type: INT64

  • Description: Identifier for the response detail.

  • Response_Value_Text

  • Data Type: STRING

  • Description: Textual value of the response.

  • Response_Value_Date

  • Data Type: DATE

  • Description: Date value of the response.

  • Response_Value_Number

  • Data Type: NUMERIC

  • Description: Numeric value of the response.

  • Response_Value_Clarification

  • Data Type: STRING

  • Description: Clarification or additional information about the response.

  • Response_Void_Indicator

  • Data Type: BOOL

  • Description: Indicator for voided response.

  • Response_Void_Reason

  • Data Type: STRING

  • Description: Reason for voiding the response.

  • Response_Void_Reason_Description

  • Data Type: STRING

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

  • Response_Void_User_ID

  • Data Type: STRING

  • Description: User ID who voided the response.

  • Response_Void_User_Name

  • Data Type: STRING

  • Description: User name who voided the response.

  • Response_Void_Timestamp

  • Data Type: TIMESTAMP

  • Description: Timestamp when the response was voided.

  • Response_Selection_Key

  • Data Type: INT64

  • Description: Identifier for the response selection.

  • Response_Detail_Created_Timestamp

  • Data Type: TIMESTAMP

  • Description: Timestamp when the response detail was created.

  • Response_Detail_Last_Modified_Timestamp

  • Data Type: TIMESTAMP

  • Description: Timestamp of the last modification to the response detail.

Questionnaire Raw

Program Details

  • Enrollment_Program

  • Data Type: STRING

  • Description: Refers to the program or process through which individuals are enrolled or registered.

  • Screening_Program

  • Data Type: STRING

  • Description: Pertains to the program or process used for screening or assessing individuals.

  • Program_ID

  • Data Type: STRING

  • Description: A unique identifier associated with a specific program or initiative.

Metadata and Attributes

  • Record_Last_Modified_Timestamp

  • Data Type: TIMESTAMP

  • Description: The most recent date and time when any record within the questionnaire log was modified.

  • Transaction_User_ID

  • Data Type: STRING

  • Description: Identifies the user responsible for the transaction or modification.

  • Deleted_Indicator

  • Data Type: BOOL

  • Description: Indicates whether a record has been deleted or voided.

  • Type

  • Data Type: STRING

  • Description: Specifies the type or category of the questionnaire log entry (e.g., response, modification, etc.).

  • Tenant

  • Data Type: STRING

  • Description: Refers to the specific organizational unit or context within which the questionnaire log operates.

  • Active_Version

  • Data Type: BOOL

  • Description: Denotes the currently active version of the questionnaire log.

  • Date

  • Data Type: DATE

  • Description: The date associated with the questionnaire log entry.

  • Sequence

  • Data Type: INT64

  • Description: Represents the order or sequence of log entries.

  • Source_System_Name

  • Data Type: STRING

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

  • Source_Timestamp

  • Data Type: TIMESTAMP

  • Description: The timestamp associated with the data source.

  • Source_File_Name

  • Data Type: STRING

  • Description: The name of the file or data source containing the questionnaire log information.

  • Schema_Version

  • Data Type: FLOAT64

  • Description: Indicates the version of the schema or data model used for the questionnaire log.

  • Member_Partition

  • Data Type: INT64

  • Description: Refers to a specific partition or subset of members within the dataset.

  • Transaction_Actor_Type

  • Data Type: STRING

  • Description: Type of the actor performing the transaction.

Questionnaire Metadata Question Raw

Question Metadata

  • Questionnaire_Question_Key

  • Data Type: INT64

  • Description: Unique key for identifying each questionnaire question.

  • Questionnaire_Version_Key

  • Data Type: INT64

  • Description: Key linking to the specific version of the questionnaire this question is part of.

  • Section_Key

  • Data Type: INT64

  • Description: Key identifying the section within the questionnaire that this question belongs to.

  • Position

  • Data Type: INT64

  • Description: Numerical order of the question within its section or questionnaire.

  • Member_Portal

  • Data Type: BOOL

  • Description: Indicates whether the question is visible in the member portal.

  • Provider_Portal

  • Data Type: BOOL

  • Description: Indicates whether the question is visible in the provider portal.

  • Depth

  • Data Type: INT64

  • Description: Represents the nesting level of the question within the questionnaire, useful for hierarchical question structures.

  • Required

  • Data Type: BOOL

  • Description: Indicates whether the question is mandatory.

Questionnaire Dataset Specification

Questionnaire Metadata Question Raw

Fields

  • Questionnaire_Question_Modified_User_ID

  • Type: STRING

  • Required: YES

  • Description: User ID of the last person who modified this questionnaire question.

  • Questionnaire_Question_Created_Timestamp

  • Type: TIMESTAMP

  • Required: YES

  • Description: Timestamp when the question was initially created.

  • Questionnaire_Question_Last_Modified_Timestamp

  • Type: TIMESTAMP

  • Required: YES

  • Description: Timestamp when the question was last modified.

  • Key

  • Type: INT64

  • Required: YES

  • Description: General identifier for referencing the question internally.

  • Short_Question

  • Type: STRING

  • Required: YES

  • Description: A shorter or abbreviated form of the question text.

  • Code

  • Type: STRING

  • Required: YES

  • Description: A unique code that may be used to identify the question in a coded form.

  • Response_Type

  • Type: STRING

  • Required: YES

  • Description: Describes the type of response expected for the question (e.g., Yes/No, Multiple Choice).

  • Response_Value_Type

  • Type: STRING

  • Required: YES

  • Description: Indicates the type of data expected to be captured (e.g., integer, string).

  • Response_Value_Type_Description

  • Type: STRING

  • Required: YES

  • Description: Detailed description of the response value type.

  • Class

  • Type: STRING

  • Required: YES

  • Description: Category or class the question belongs to within the questionnaire structure.

  • Class_Description

  • Type: STRING

  • Required: YES

  • Description: Descriptive details about the class.

  • Active

  • Type: BOOL

  • Required: YES

  • Description: Indicates whether the question is currently active and should be displayed.

  • Question_Available_To_AWF

  • Type: BOOL

  • Required: YES

  • Description: Specifies if the question is available to automated workflow processes.

  • Clinical_Help

  • Type: STRING

  • Required: YES

  • Description: Help text providing clinical context or guidance related to the question.

  • Non_Clinical_Help

  • Type: STRING

  • Required: YES

  • Description: Non-clinical help text providing guidance or information related to the question.

  • Modified_User_ID

  • Type: STRING

  • Required: YES

  • Description: User ID of the individual who last modified the question record.

  • Created_Timestamp

  • Type: TIMESTAMP

  • Required: YES

  • Description: Timestamp when the question record was created.

  • Last_Modified_Timestamp

  • Type: TIMESTAMP

  • Required: YES

  • Description: Timestamp when the question record was last updated.

Child Questions

  • Child_Questions

  • Type: ARRAY

  • Required: NO

  • Description: Lists sub-questions or dependent questions that are part of the scoring mechanism, showing the hierarchical structure of questionnaire logic.

Child Questions Fields

  • Questionnaire_Key

  • Type: INT64

  • Required: YES

  • Description: Identifier for the questionnaire to which the question belongs.

  • Questionnaire_Question_Key

  • Type: INT64

  • Required: YES

  • Description: Unique identifier for the questionnaire question.

  • Modified_User_ID

  • Type: STRING

  • Required: YES

  • Description: User ID of the user who last modified the record.

  • Created_Timestamp

  • Type: TIMESTAMP

  • Required: YES

  • Description: Timestamp indicating when the record was created.

  • Last_Modified_Timestamp

  • Type: TIMESTAMP

  • Required: YES

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

Entry Tests

  • Entry_Tests

  • Type: ARRAY

  • Required: NO

  • Description: An array of conditions or criteria that must be met for the question to be presented or considered relevant, ensuring appropriate question display.

Entry Tests Fields

  • Key

  • Minimum_Value

  • Maximum_Value

  • Modified_User_ID

  • Type: STRING

  • Required: YES

  • Description: User ID of the user who last modified the record.

  • Created_Timestamp

  • Type: TIMESTAMP

  • Required: YES

  • Description: Timestamp indicating when the record was created.

  • Last_Modified_Timestamp

  • Type: TIMESTAMP

  • Required: YES

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

Enablers

  • Enablers

  • Type: ARRAY

  • Required: NO

  • Description: Defines conditions or thresholds that activate or modify the scoring function, allowing for dynamic and context-sensitive scoring.

Enablers Fields

  • Child_Questions.Questionnaire_Key

  • Type: INT64

  • Required: YES

  • Description: Identifier for the questionnaire to which the question belongs.

  • Child_Questions.Questionnaire_Question_Key

  • Type: INT64

  • Required: YES

  • Description: Unique identifier for the questionnaire question.

  • Child_Questions.Created_Timestamp

  • Type: TIMESTAMP

  • Required: YES

  • Description: Timestamp indicating when the record was created.

  • Child_Questions.Last_Modified_User_ID

  • Type: STRING

  • Required: YES

  • Description: User ID of the user who last modified the record.

  • Child_Questions.Last_Modified_Timestamp

  • Type: TIMESTAMP

  • Required: YES

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

Selections

  • Selections

  • Type: ARRAY

  • Required: NO

  • Description: An array detailing the available choices or responses for the question, typically used for multiple-choice or selection-based questions.

Selections Fields

  • Key

  • Type: INT64

  • Required: YES

  • Description: A unique identifier for each selection.

  • Selection_Key

  • Type: STRING

  • Required: YES

  • Description: A unique identifier for the specific selection within the entry.

  • Scoring_Weight

  • Type: STRING

  • Required: YES

  • Description: The weight assigned to the selection for scoring purposes.

  • Modified_User_ID

  • Type: STRING

  • Required: YES

  • Description: User ID of the user who last modified the record.

  • Created_Timestamp

  • Type: TIMESTAMP

  • Required: YES

  • Description: Timestamp indicating when the record was created.

  • Last_Modified_Timestamp

  • Type: TIMESTAMP

  • Required: YES

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

  • Code

  • Type: STRING

  • Required: YES

  • Description: Unique code of the selection.

  • Selection_Modified_User_ID

  • Type: STRING

  • Required: YES

  • Description: User ID of the user who last modified the record.

  • Selection_Created_Timestamp

  • Type: TIMESTAMP

  • Required: YES

  • Description: Timestamp indicating when the record was created.

  • Selection_Last_Modified_Timestamp

  • Type: TIMESTAMP

  • Required: YES

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

Selection Enablers

  • Enablers

  • Type: ARRAY

  • Required: NO

  • Description: Defines conditions or thresholds that activate or modify the scoring function.

Questionnaire Dataset Specification

Selections

Enablers

Child Questions

  • Questionnaire_Key

  • Required: YES

  • Type: INT64

  • Description: Identifier for the questionnaire to which the question belongs.

  • Questionnaire_Question_Key

  • Required: YES

  • Type: INT64

  • Description: Unique identifier for the questionnaire question.

  • Created_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp indicating when the record was created.

  • Last_Modified_User_ID

  • Required: YES

  • Type: STRING

  • Description: User ID of the user who last modified the record.

  • Last_Modified_Timestamp

  • Required: YES

  • Type: TIMESTAMP

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

Problems

  • Key

  • Required: YES

  • Type: INT64

  • Description: A unique identifier for each problem within the selections.

  • Problem

  • Required: YES

  • Type: STRING

  • Description: The specific problem identified within the selection.

  • Problem_Description

  • Required: YES

  • Type: STRING

  • Description: A detailed description of the problem, providing more context and information.

  • Modified_User_ID

  • Required: YES

  • Type: STRING

  • Description: User ID of the user who last modified the record.

  • Created_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp indicating when the record was created.

  • Last_Modified_Timestamp

  • Required: YES

  • Type: TIMESTAMP

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

Versions

  • Key

  • Required: YES

  • Type: INT64

  • Description: A unique identifier for each version of the selection.

  • Question_Version_Key

  • Required: YES

  • Type: INT64

  • Description: A unique identifier for the version of the question associated with the selection.

  • Position

  • Required: YES

  • Type: STRING

  • Description: The order or position of the version within the selection.

  • Value

  • Required: YES

  • Type: STRING

  • Description: The value assigned to the version of the selection.

  • Clarification_Indicator

  • Required: YES

  • Type: STRING

  • Description: An indicator specifying whether clarification is needed for the version.

  • Mutual_Exclusive

  • Required: YES

  • Type: STRING

  • Description: Indicates whether the version is mutually exclusive with other versions.

  • Modified_User_ID

  • Required: YES

  • Type: STRING

  • Description: User ID of the user who last modified the record.

  • Created_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp indicating when the record was created.

  • Last_Modified_Timestamp

  • Required: YES

  • Type: TIMESTAMP

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

Questionnaire Metadata Question Raw

Versions

  • Questionnaire_Version_Key

  • Required: YES

  • Type: INT64

  • Description: Refers to a specific version of the questionnaire.

  • Questionnaire_Version_Number

  • Required: YES

  • Type: INT64

  • Description: The numerical version number assigned to the questionnaire.

  • Full_Question_Clinical

  • Required: YES

  • Type: STRING

  • Description: Full clinical question text.

  • Questionnaire_Effective_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp when the questionnaire became effective.

  • Questionnaire_Termination_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp when the questionnaire is terminated.

  • Question_Report_Title

  • Required: YES

  • Type: STRING

  • Description: Title used for reporting purposes related to the question.

  • Question_Display_Type

  • Required: YES

  • Type: STRING

  • Description: Display type for the question in the user interface.

  • Question_Response_Type_Description

  • Required: YES

  • Type: STRING

  • Description: Description of the question response type. See Dictionary Response Type table in the Dictionary Dataset Specification.

  • Field_Length

  • Required: YES

  • Type: STRING

  • Description: The length of the field for the version of the selection.

  • Input_Length

  • Required: YES

  • Type: STRING

  • Description: The maximum length of input allowed for the version of the selection.

  • Maximum_Value

  • Required: YES

  • Type: STRING

  • Description: The maximum value that can be assigned to the version of the selection.

  • Minimum_Value

  • Required: YES

  • Type: STRING

  • Description: The minimum value that can be assigned to the version of the selection.

  • Selections_Allowed

  • Required: YES

  • Type: STRING

  • Description: Indicates whether multiple selections are allowed for the version.

  • Modified_User_ID

  • Required: YES

  • Type: STRING

  • Description: User ID of the user who last modified the record.

  • Version_Created_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp indicating when the record was created.

  • Version_Last_Modified_Timestamp

  • Required: YES

  • Type: TIMESTAMP

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

Metadata Fields

  • Record_Last_Modified_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp indicating the last modification to the question's record.

  • Transaction_User_ID

  • Required: YES

  • Type: STRING

  • Description: Identifier of the user involved in the last transaction affecting this record.

  • Deleted_Indicator

  • Required: YES

  • Type: BOOL

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

  • Type

  • Required: YES

  • Type: STRING

  • Description: General type classification of the question.

  • Tenant

  • Required: YES

  • Type: STRING

  • Description: Identifies the tenant in the context of a multi-tenant system.

  • Active_Version

  • Required: YES

  • Type: BOOL

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

  • Date

  • Required: YES

  • Type: DATE

  • Description: Date associated with the record entry or modification.

  • Sequence

  • Required: YES

  • Type: INT64

  • Description: Sequential identifier used for ordering or versioning within the system.

  • Source_System_Name

  • Required: YES

  • Type: STRING

  • Description: Name of the source system from which the question data originates.

  • Source_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp when the data was captured from the source system.

  • Source_File_Name

  • Required: YES

  • Type: STRING

  • Description: Name of the file from the source system containing the question data.

  • Schema_Version

  • Required: YES

  • Type: FLOAT64

  • Description: Version of the data schema used for this question record.

  • _updated

  • Required: YES

  • Type: STRING

  • Description: Indicates any recent updates to the record.

Questionnaire Dataset Specification

Features and Capabilities

Comparing Scores

  • Includes tables that allow for the comparison of scores across different questionnaires.

  • Facilitates analysis of trends and performance over time.

Storing Questionnaire Scores

  • Captures scores from completed questionnaires.

  • Provides a basis for evaluating and monitoring respondent performance and changes.

Comparing Question Responses

  • Contains data for side-by-side comparison of responses to similar questions across different questionnaires or time periods.

  • Aids in the detection of patterns and deviations.

Detailed Question Response Information

  • Stores in-depth details about each question's responses.

  • Includes respondent demographics and context, enhancing the depth of data analysis.

Logging Questionnaire Activities and Metadata

  • Tracks updates, modifications, and usage of questionnaires.

  • Provides a detailed audit trail that helps maintain data integrity and history.

  • Holds unprocessed, detailed data about questionnaire metadata.

  • Crucial for conducting detailed investigations and historical comparisons.

Table Specifications

Table: Questionnaire_Score_Comparison

Column Name

Is Nullable

Data Type

Description

Member_ID

YES

STRING

A unique identifier for each individual or member participating in the questionnaire.

Class

YES

STRING

Represents a classification or category associated with the member (e.g., patient class, risk group, etc.). See Dictionary Questionnaire Class table in the Dictionary Dataset Specification.

Class_Description

YES

STRING

A textual description corresponding to the specific class or category assigned to the member. See Dictionary Questionnaire Class table in the Dictionary Dataset Specification.

Questionnaire_Key

YES

INT64

Identifies the specific questionnaire administered to the member.

Questionnaire_Title

YES

STRING

The title or name of the questionnaire used for assessment.

Questionnaire_Code

YES

STRING

A code or identifier associated with the questionnaire.

Dashboard_Indicator

YES

BOOL

Indicates whether the member’s scores are displayed on a dashboard or summary view.

Scoring_Function_Key

YES

INT64

Refers to a specific scoring function used to calculate scores based on questionnaire responses.

Scoring_Function_Score_Description

YES

STRING

Describes the meaning or interpretation of the scores generated by the scoring function.

Scoring_Function_Report_Title

YES

STRING

The title assigned to the report or summary that includes the member’s scores.

Scoring_Function_Formula

YES

STRING

Specifies the mathematical formula or algorithm used to compute scores.

Scoring_Function_Formula_Description

YES

STRING

Provides a detailed explanation of how the scoring function formula operates.

Scoring_Function

YES

STRING

Indicates the type of scoring method employed (e.g., Likert scale, weighted scoring, etc.).

Scoring_Function_Format_Type

YES

STRING

Describes the format of the scores (e.g., numeric, categorical, etc.).

First_Score

YES

NUMERIC

Represents the initial score obtained by the member during the assessment period.

First_Score_Timestamp

YES

TIMESTAMP

The date and time when the first score was recorded.

Latest_Score

YES

NUMERIC

Denotes the most recent score achieved by the member.

Latest_Score_Timestamp

YES

TIMESTAMP

The date and time when the latest score was recorded.

Days_Count_Between_First_Last_Scores

YES

INT64

Calculates the duration (in days) between the first and latest scores.

One_Score_Indicator

YES

BOOL

Indicates whether the member has only one recorded score (binary indicator).

Table: Questionnaire_Scores

Column Name

Is Nullable

Data Type

Description

Member_ID

YES

STRING

A unique identifier for each individual or member participating in the questionnaire.

Questionnaire_Response_Key

YES

INT64

A key or identifier associated with a specific response or submission within the questionnaire.

Class

YES

STRING

Represents a classification or category associated with the member (e.g., patient class, risk group, etc.). See Dictionary Questionnaire Class table in the Dictionary Dataset Specification.

Class_Description

YES

STRING

A textual description corresponding to the specific class or category assigned to the member. See Dictionary Questionnaire Class table in the Dictionary Dataset Specification.

Response_Note

YES

STRING

Additional notes or comments related to the questionnaire response.

Complete_Indicator

YES

BOOL

Indicates whether the questionnaire response is complete or partially filled out.

Source

YES

STRING

The origin or channel through which the questionnaire data was collected (e.g., web form, paper survey).

Source_Description

YES

STRING

Describes the source or method used to collect the questionnaire data.

Source_Entry_Timestamp

YES

TIMESTAMP

The date and time when the questionnaire response was entered or recorded.

Questionnaire Dataset Specification

Questionnaire Scores

Completed By Auto Close

  • Field Name: Completed_By_Auto_Close

  • Required: YES

  • Type: BOOL

  • Description: Indicates whether the completion of the questionnaire was automatically triggered (e.g., timed out).

Questionnaire Response Modified User ID

  • Field Name: Questionnaire_Response_Modified_User_ID

  • Required: YES

  • Type: STRING

  • Description: Identifies the user who last modified the questionnaire response.

Questionnaire Response Modified User Name

  • Field Name: Questionnaire_Response_Modified_User_Name

  • Required: YES

  • Type: STRING

  • Description: The name of the user who last modified the questionnaire response.

Questionnaire Response Created Timestamp

  • Field Name: Questionnaire_Response_Created_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: The date and time when the questionnaire response was initially created.

Questionnaire Response Last Modified Timestamp

  • Field Name: Questionnaire_Response_Last_Modified_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: The most recent date and time when the questionnaire response was modified.

Questionnaire Key

  • Field Name: Questionnaire_Key

  • Required: YES

  • Type: INT64

  • Description: Identifies the specific questionnaire administered to the member.

Questionnaire Version Key

  • Field Name: Questionnaire_Version_Key

  • Required: YES

  • Type: INT64

  • Description: Refers to a specific version of the questionnaire.

Questionnaire Version Number

  • Field Name: Questionnaire_Version_Number

  • Required: YES

  • Type: INT64

  • Description: The numerical version number assigned to the questionnaire.

Questionnaire Title

  • Field Name: Questionnaire_Title

  • Required: YES

  • Type: STRING

  • Description: The title or name of the questionnaire used for assessment.

Questionnaire Version Title

  • Field Name: Questionnaire_Version_Title

  • Required: YES

  • Type: STRING

  • Description: Version of the title or name of the questionnaire used for assessment.

Questionnaire Code

  • Field Name: Questionnaire_Code

  • Required: YES

  • Type: STRING

  • Description: A code or identifier associated with the questionnaire.

Dashboard Indicator

  • Field Name: Dashboard_Indicator

  • Required: YES

  • Type: BOOL

  • Description: Indicates whether the member’s scores are displayed on a dashboard or summary view.

Questionnaire Version Last Modified Date

  • Field Name: Questionnaire_Version_Last_Modified_Date

  • Required: YES

  • Type: DATE

  • Description: Date when the questionnaire version was modified.

Score Response Key

  • Field Name: Score_Response_Key

  • Required: YES

  • Type: INT64

  • Description: A key or identifier associated with a specific score response within the questionnaire.

Calculated Score

  • Field Name: Calculated_Score

  • Required: YES

  • Type: NUMERIC

  • Description: The computed score based on questionnaire responses and scoring functions.

Score Response Void Indicator

  • Field Name: Score_Response_Void_Indicator

  • Required: YES

  • Type: BOOL

  • Description: Indicates whether the score response has been voided or invalidated.

Score Response Void Timestamp

  • Field Name: Score_Response_Void_Timestamp

  • Required: YES

  • Type: TIMESTAMP

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

Score Response Void User ID

  • Field Name: Score_Response_Void_User_ID

  • Required: YES

  • Type: STRING

  • Description: Identifies the user who voided the score response.

Score Response Void User Name

  • Field Name: Score_Response_Void_User_Name

  • Required: YES

  • Type: STRING

  • Description: The name of the user who voided the score response.

Score Response Void Reason

  • Field Name: Score_Response_Void_Reason

  • Required: YES

  • Type: STRING

  • Description: The reason or explanation for voiding the score response.

Score Response Void Reason Description

  • Field Name: Score_Response_Void_Reason_Description

  • Required: YES

  • Type: STRING

  • Description: Provides a detailed description of the void reason.

Score Response Modified User ID

  • Field Name: Score_Response_Modified_User_ID

  • Required: YES

  • Type: STRING

  • Description: Identifies the user who last modified the score response.

Score Response Modified User Name

  • Field Name: Score_Response_Modified_User_Name

  • Required: YES

  • Type: STRING

  • Description: The name of the user who last modified the score response.

Score Response Created Timestamp

  • Field Name: Score_Response_Created_Timestamp

  • Required: YES

  • Type: TIMESTAMP

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

Score Response Created Date

  • Field Name: Score_Response_Created_Date

  • Required: YES

  • Type: DATE

  • Description: The date when the score response was initially created.

Score Response Last Modified Timestamp

  • Field Name: Score_Response_Last_Modified_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: The most recent date and time when the score response was modified.

Scoring Function Key

  • Field Name: Scoring_Function_Key

  • Required: YES

  • Type: INT64

  • Description: Refers to a specific scoring function used to calculate scores based on questionnaire responses.

Scoring Function Version Number

  • Field Name: Scoring_Function_Version_Number

  • Required: YES

  • Type: INT64

  • Description: The version number associated with the scoring function.

Scoring Function Score Description

  • Field Name: Scoring_Function_Score_Description

  • Required: YES

  • Type: STRING

  • Description: Describes the meaning or interpretation of the scores generated by the scoring function.

Scoring Function Score Version Description

  • Field Name: Scoring_Function_Score_Version_Description

  • Required: YES

  • Type: STRING

  • Description: Version of the score description.

Scoring Function Report Title

  • Field Name: Scoring_Function_Report_Title

  • Required: YES

  • Type: STRING

  • Description: The title assigned to the report or summary that includes the member’s scores.

Scoring Function Version Report Title

  • Field Name: Scoring_Function_Version_Report_Title

  • Required: YES

  • Type: STRING

  • Description: Version of the title assigned to the report or summary that includes the member’s scores.

Scoring Function Version Key

  • Field Name: Scoring_Function_Version_Key

  • Required: YES

  • Type: INT64

  • Description: Refers to a specific version of the scoring function.

Scoring Function Formula

  • Field Name: Scoring_Function_Formula

  • Required: YES

  • Type: STRING

  • Description: Specifies the mathematical formula or algorithm used to compute scores.

Scoring Function Formula Description

  • Field Name: Scoring_Function_Formula_Description

  • Required: YES

  • Type: STRING

  • Description: Provides a detailed explanation of the mathematical formula or algorithm used to compute scores.

Scoring Function

  • Field Name: Scoring_Function

  • Required: YES

  • Type: STRING

  • Description: Indicates the type of scoring method employed (e.g., Likert scale, weighted scoring, etc.).

Scoring Function Format Type

  • Field Name: Scoring_Function_Format_Type

  • Required: YES

  • Type: STRING

  • Description: Describes the format of the scores (e.g., numeric, categorical, etc.).

Enrollment Program

  • Field Name: Enrollment_Program

  • Required: YES

  • Type: STRING

  • Description: Refers to the program or process through which individuals are enrolled or registered.

Screening Program

  • Field Name: Screening_Program

  • Required: YES

  • Type: STRING

  • Description: Pertains to the program or process used for screening or assessing individuals.

Program ID

  • Field Name: Program_ID

  • Required: YES

  • Type: STRING

  • Description: A unique identifier associated with a specific program or initiative.

First

  • Field Name: First

  • Required: YES

  • Type: BOOL

  • Description: Represents the initial occurrence or value (e.g., first assessment, first score).

Latest

  • Field Name: Latest

  • Required: YES

  • Type: BOOL

  • Description: Denotes the most recent occurrence or value (e.g., latest assessment, latest score).

First Completed

  • Field Name: First_Completed

  • Required: YES

  • Type: BOOL

  • Description: Represents the first completed instance or value.

Questionnaire Dataset Specification

Questionnaire Scores

Latest Completed

  • Data Type: BOOL

  • Description: Indicates whether the most recent assessment or task was completed.

Table Content

Questionnaire Question Response Comparison

Column Name

Is Nullable

Data Type

Description

Member_ID

YES

STRING

Identifier for the member or patient.

Class

YES

STRING

Class identifier for the question response. See Dictionary Questionnaire Class table in the Dictionary Dataset Specification.

Class_Description

YES

STRING

Description of the class of the question response. See Dictionary Questionnaire Class table in the Dictionary Dataset Specification.

Question_Key

YES

INT64

Identifier for the question in the response.

Full_Question_Clinical

YES

STRING

Full clinical question text.

Short_Question

YES

STRING

Abbreviated or shortened version of the question.

Question_Report_Title

YES

STRING

Title used for reporting purposes related to the question.

Question_Code

YES

STRING

Code associated with the question.

Question_Response_Type

YES

STRING

Type of response expected for the question. See Dictionary Response Type table in the Dictionary Dataset Specification.

Question_Display_Type

YES

STRING

Display type for the question in the user interface.

Question_Response_Type_Description

YES

STRING

Description of the question response type. See Dictionary Response Type table in the Dictionary Dataset Specification.

Question_Response_Value_Type

YES

STRING

Data type of the response value. See Dictionary Response Value Type table in the Dictionary Dataset Specification.

Question_Response_Value_Type_Description

YES

STRING

Description of the data type of the response value. See Dictionary Response Value Type table in the Dictionary Dataset Specification.

First_Response_Value_Text

YES

STRING

Textual value of the first response.

First_Response_Value_Date

YES

DATE

Date value of the first response.

First_Response_Value_Number

YES

NUMERIC

Numeric value of the first response.

First_Response_Timestamp

YES

TIMESTAMP

Timestamp of the first response.

Latest_Response_Value_Text

YES

STRING

Textual value of the latest response.

Latest_Response_Value_Date

YES

DATE

Date value of the latest response.

Latest_Response_Value_Number

YES

NUMERIC

Numeric value of the latest response.

Latest_Response_Timestamp

YES

TIMESTAMP

Timestamp of the latest response.

Days_Count_Between_First_Last_Responses

YES

INT64

Number of days between the first and latest responses.

One_Response_Indicator

YES

BOOL

Indicator to show if only one response was recorded.

Questionnaire Question Response Details

Column Name

Is Nullable

Data Type

Description

Member_ID

YES

STRING

Identifier for the member or patient.

Questionnaire_Response_Key

YES

INT64

Identifier for the questionnaire response.

Class

YES

STRING

Class identifier for the question response. See Dictionary Questionnaire Class table in the Dictionary Dataset Specification.

Class_Description

YES

STRING

Description of the class of the question response. See Dictionary Questionnaire Class table in the Dictionary Dataset Specification.

Response_Note

YES

STRING

Notes or additional information related to the response.

Source

YES

STRING

Source of the response data.

Source_Description

YES

STRING

Description of the source of the response data.

Source_Entry_Timestamp

YES

TIMESTAMP

Timestamp when the response was entered.

Completed_By_Auto_Close

YES

BOOL

Indicator if the response was completed automatically.

Questionnaire_Response_Modified_User_ID

YES

STRING

ID of the user who modified the questionnaire response.

Questionnaire_Response_Modified_User_Name

YES

STRING

Name of the user who modified the questionnaire response.

Questionnaire_Response_Created_Timestamp

YES

TIMESTAMP

Timestamp when the questionnaire response was created.

Questionnaire_Response_Last_Modified_Timestamp

YES

TIMESTAMP

Timestamp of the last modification to the questionnaire response.

Questionnaire_Key

YES

INT64

Identifier for the questionnaire.

Questionnaire_Ver

YES

STRING

Version of the questionnaire.

Questionnaire Dataset Specification

Questionnaire Details

Questionnaire Version Key

  • Type: INT64

  • Required: YES

  • Description: Identifier for the version of the questionnaire.

Questionnaire Version Number

  • Type: INT64

  • Required: YES

  • Description: Version number of the questionnaire.

Questionnaire Title

  • Type: STRING

  • Required: YES

  • Description: Title of the questionnaire.

Questionnaire Version Title

  • Type: STRING

  • Required: YES

  • Description: Title version of the questionnaire.

Questionnaire Code

  • Type: STRING

  • Required: YES

  • Description: Code associated with the questionnaire.

Dashboard Indicator

  • Type: BOOL

  • Required: YES

  • Description: Indicator for dashboard visibility.

Question Response Details

Question Response Key

  • Type: INT64

  • Required: YES

  • Description: Identifier for the question response.

Question Response Scoring Weight

  • Type: NUMERIC

  • Required: YES

  • Description: Weight or score assigned to the question response.

Question Response Modified User ID

  • Type: STRING

  • Required: YES

  • Description: ID of the user who modified the question response.

Question Response Modified User Name

  • Type: STRING

  • Required: YES

  • Description: Name of the user who modified the question response.

Question Position

  • Type: INT64

  • Required: YES

  • Description: Position of the question in the questionnaire.

Question Key

  • Type: INT64

  • Required: YES

  • Description: Identifier for the question.

Question Version Key

  • Type: INT64

  • Required: YES

  • Description: Identifier for the version of the question.

Question Version Number

  • Type: INT64

  • Required: YES

  • Description: Version number of the question.

Full Question Clinical

  • Type: STRING

  • Required: YES

  • Description: Full clinical question text.

Full Question Version Clinical

  • Type: STRING

  • Required: YES

  • Description: Version of the full clinical question text.

Short Question

  • Type: STRING

  • Required: YES

  • Description: Abbreviated or shortened version of the question.

Question Report Title

  • Type: STRING

  • Required: YES

  • Description: Title used for reporting purposes related to the question.

Question Version Report Title

  • Type: STRING

  • Required: YES

  • Description: Version of the title used for reporting purposes related to the question.

Question Code

  • Type: STRING

  • Required: YES

  • Description: Code associated with the question.

Question Response Type

  • Type: STRING

  • Required: YES

  • Description: Type of response expected for the question. See Dictionary Response Type table in the Dictionary Dataset Specification.

Question Display Type

  • Type: STRING

  • Required: YES

  • Description: Display type for the question in the user interface.

Question Response Type Description

  • Type: STRING

  • Required: YES

  • Description: Description of the question response type. See Dictionary Response Type table in the Dictionary Dataset Specification.

Question Response Value Type

  • Type: STRING

  • Required: YES

  • Description: Data type of the response value. See Dictionary Response Value Type table in the Dictionary Dataset Specification.

Question Response Value Type Description

  • Type: STRING

  • Required: YES

  • Description: Description of the data type of the response value. See Dictionary Response Value Type table in the Dictionary Dataset Specification.

Question Response Created Timestamp

  • Type: TIMESTAMP

  • Required: YES

  • Description: Timestamp when the question response was created.

Question Response Last Modified Timestamp

  • Type: TIMESTAMP

  • Required: YES

  • Description: Timestamp of the last modification to the question response.

Question Response Last Modified Date

  • Type: DATE

  • Required: YES

  • Description: Date of the last modification to the question response.

Response Details

Response Detail Key

  • Type: INT64

  • Required: YES

  • Description: Identifier for the response detail.

Response Value Text

  • Type: STRING

  • Required: YES

  • Description: Textual value of the response.

Response Value Date

  • Type: DATE

  • Required: YES

  • Description: Date value of the response.

Response Value Number

  • Type: NUMERIC

  • Required: YES

  • Description: Numeric value of the response.

Response Value Clarification

  • Type: STRING

  • Required: YES

  • Description: Clarification or additional information about the response.

Response Void Indicator

  • Type: BOOL

  • Required: YES

  • Description: Indicator for voided response.

Response Void Reason

  • Type: STRING

  • Required: YES

  • Description: Reason for voiding the response.

Response Void Reason Description

  • Type: STRING

  • Required: YES

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

Response Void User ID

  • Type: STRING

  • Required: YES

  • Description: User ID who voided the response.

Response Void User Name

  • Type: STRING

  • Required: YES

  • Description: User name who voided the response.

Response Void Timestamp

  • Type: TIMESTAMP

  • Required: YES

  • Description: Timestamp when the response was voided.

Response Selection Key

  • Type: INT64

  • Required: YES

  • Description: Identifier for the response selection.

Response Detail Created Timestamp

  • Type: TIMESTAMP

  • Required: YES

  • Description: Timestamp when the response detail was created.

Response Detail Last Modified Timestamp

  • Type: TIMESTAMP

  • Required: YES

  • Description: Timestamp of the last modification to the response detail.

Response Detail Last Modified Date

  • Type: DATE

  • Required: YES

  • Description: Date of the last modification to the response detail.

Questionnaire Dataset Specification

Enrollment Program

  • Column Name: Enrollment_Program

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Program related to the enrollment.

Questionnaire Question Response Details

Screening Program

  • Column Name: Screening_Program

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Program related to the screening.

Program ID

  • Column Name: Program_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the program.

Complete Indicator

  • Column Name: Complete_Indicator

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicator for completion status.

First

  • Column Name: First

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicator for the first occurrence.

Latest

  • Column Name: Latest

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicator for the latest occurrence.

First Completed

  • Column Name: First_Completed

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicator for the first completion.

Latest Completed

  • Column Name: Latest_Completed

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicator for the latest completion.

Member Enrollment Effective Date

  • Column Name: Member_Enrollment_Effective_Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: Effective date of member enrollment.

Member Enrollment Termination Date

  • Column Name: Member_Enrollment_Termination_Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: Termination date of member enrollment.

Member Enrollment Key

  • Column Name: Member_Enrollment_Key

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for member enrollment.

Group ID

  • Column Name: Group_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the group.

Group Name

  • Column Name: Group_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the group.

Plan ID

  • Column Name: Plan_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the plan. See Dictionary Plan table in the Dictionary Dataset Specification.

Plan Description

  • Column Name: Plan_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the plan. See Dictionary Plan table in the Dictionary Dataset Specification.

Line of Business

  • Column Name: Line_Of_Business

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the line of business.

Line of Business Description

  • Column Name: Line_Of_Business_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the line of business.

Questionnaire Log

Member ID

  • Column Name: Member_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique identifier for each individual or member participating in the questionnaire.

Questionnaire Response Key

  • Column Name: Questionnaire_Response_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: A key or identifier associated with a specific response or submission within the questionnaire.

Class

  • Column Name: Class

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Represents a classification or category associated with the member (e.g., patient class, risk group, etc.). See Dictionary Questionnaire Class table in the Dictionary Dataset Specification.

Class Description

  • Column Name: Class_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A textual description corresponding to the specific class or category assigned to the member. See Dictionary Questionnaire Class table in the Dictionary Dataset Specification.

Response Note

  • Column Name: Response_Note

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Additional notes or comments related to the questionnaire response.

Complete Indicator

  • Column Name: Complete_Indicator

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates whether the questionnaire response is complete or partially filled out.

Source

  • Column Name: Source

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The origin or channel through which the questionnaire data was collected (e.g., web form, paper survey).

Source Description

  • Column Name: Source_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Describes the source or method used to collect the questionnaire data.

Source Entry Timestamp

  • Column Name: Source_Entry_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the questionnaire response was entered or recorded.

Completed by Auto Close

  • Column Name: Completed_By_Auto_Close

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates whether the completion of the questionnaire was automatically triggered (e.g., timed out).

Modified User ID

  • Column Name: Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifies the user who last modified the questionnaire response.

Created Timestamp

  • Column Name: Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the questionnaire response was initially created.

Last Modified Timestamp

  • Column Name: Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The most recent date and time when the questionnaire response was modified.

Questionnaire

  • Column Name: Questionnaire

  • Is Nullable: YES

  • Data Type: STRUCT

  • Description: Refers to the specific questionnaire administered to the member. See below for detailed information on each parameter in the structure.

Questionnaire Key

  • Column Name: Questionnaire.Questionnaire_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Identifies the specific questionnaire administered to the member.

Questionnaire Version Key

  • Column Name: Questionnaire.Questionnaire_Version_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Refers to a specific version of the questionnaire.

Questionnaire Version Number

  • Column Name: Questionnaire.Questionnaire_Version_Number

  • Is Nullable: YES

  • Data Type: INT64

  • Description: The numerical version number assigned to the questionnaire.

Questionnaire Title

  • Column Name: Questionnaire.Questionnaire_Title

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The title or name of the questionnaire used for assessment.

Questionnaire Code

  • Column Name: Questionnaire.Questionnaire_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A code or identifier associated with the questionnaire.

Dashboard Indicator

  • Column Name: Questionnaire.Dashboard_Indicator

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates whether the member’s scores are displayed on a dashboard or summary view.

Questionnaire Effective Timestamp

  • Column Name: Questionnaire.Questionnaire_Effective_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date when the questionnaire becomes effective or applicable.

Questionnaire Termination Timestamp

  • Column Name: Questionnaire.Questionnaire_Termination_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date when the questionnaire is no longer valid or applicable.

Questionnaire Modified User ID

  • Column Name: Questionnaire.Questionnaire_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifies the user who last modified the questionnaire details.

Questionnaire Modified User Name

  • Column Name: Questionnaire.Questionnaire_Modified_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name of the user who last modified the questionnaire details.

Questionnaire Version Created Timestamp

  • Column Name: Questionnaire.Questionnaire_Version_Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when the specific questionnaire version was created.

Questionnaire Version Last Modified Timestamp

  • Column Name: Questionnaire.Questionnaire_Version_Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The most recent date and time when the questionnaire version was modified.

Score Responses

  • Column Name: Score_Responses

  • Is Nullable: NO

  • Data Type: ARRAY

  • Description: Pertains to the recorded scores associated with the questionnaire responses.

Questionnaire Dataset Specification

Score Responses

Calculated Score

  • Field Name: Score_Responses.Calculated_Score

  • Required: YES

  • Type: NUMERIC

  • Description: The computed score based on questionnaire responses and scoring functions.

Void Indicator

  • Field Name: Score_Responses.Score_Response_Void_Indicator

  • Required: YES

  • Type: BOOL

  • Description: Indicates whether the score response has been voided or invalidated.

Void Timestamp

  • Field Name: Score_Responses.Score_Response_Void_Timestamp

  • Required: YES

  • Type: TIMESTAMP

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

Void User ID

  • Field Name: Score_Responses.Score_Response_Void_User_ID

  • Required: YES

  • Type: STRING

  • Description: Identifies the user who voided the score response.

Void Reason

  • Field Name: Score_Responses.Score_Response_Void_Reason

  • Required: YES

  • Type: STRING

  • Description: The reason or explanation for voiding the score response.

Void Reason Description

  • Field Name: Score_Responses.Score_Response_Void_Reason_Description

  • Required: YES

  • Type: STRING

  • Description: Provides a detailed description of the void reason.

Modified User ID

  • Field Name: Score_Responses.Score_Response_Modified_User_ID

  • Required: YES

  • Type: STRING

  • Description: Identifies the user who last modified the score response.

Created Timestamp

  • Field Name: Score_Responses.Score_Response_Created_Timestamp

  • Required: YES

  • Type: TIMESTAMP

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

Last Modified Timestamp

  • Field Name: Score_Responses.Score_Response_Last_Modified_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: The most recent date and time when the score response was modified.

Scoring Function Key

  • Field Name: Score_Responses.Scoring_Function_Key

  • Required: YES

  • Type: INT64

  • Description: Refers to a specific scoring function used to calculate scores based on questionnaire responses.

Scoring Function Version Number

  • Field Name: Score_Responses.Scoring_Function_Version_Number

  • Required: YES

  • Type: INT64

  • Description: The version number associated with the scoring function.

Scoring Function Score Description

  • Field Name: Score_Responses.Scoring_Function_Score_Description

  • Required: YES

  • Type: STRING

  • Description: Describes the meaning or interpretation of the scores generated by the scoring function.

Scoring Function Report Title

  • Field Name: Score_Responses.Scoring_Function_Report_Title

  • Required: YES

  • Type: STRING

  • Description: The title assigned to the report or summary that includes the member’s scores.

Scoring Function Version Key

  • Field Name: Score_Responses.Scoring_Function_Version_Key

  • Required: YES

  • Type: INT64

  • Description: Refers to a specific version of the scoring function.

Scoring Function Formula

  • Field Name: Score_Responses.Scoring_Function_Formula

  • Required: YES

  • Type: STRING

  • Description: Specifies the mathematical formula or algorithm used to compute scores.

Scoring Function Formula Description

  • Field Name: Score_Responses.Scoring_Function_Formula_Description

  • Required: YES

  • Type: STRING

  • Description: Provides a detailed explanation of the mathematical formula or algorithm used to compute scores.

Scoring Function Type

  • Field Name: Score_Responses.Scoring_Function

  • Required: YES

  • Type: STRING

  • Description: Indicates the type of scoring method employed (e.g., Likert scale, weighted scoring, etc.).

Scoring Function Format Type

  • Field Name: Score_Responses.Scoring_Function_Format_Type

  • Required: YES

  • Type: STRING

  • Description: Describes the format of the scores (e.g., numeric, categorical, etc.).

Scoring Function Effective Timestamp

  • Field Name: Score_Responses.Scoring_Function_Effective_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: The date when the specific scoring function becomes effective or applicable.

Scoring Function Termination Timestamp

  • Field Name: Score_Responses.Scoring_Function_Termination_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: The date when the specific scoring function is no longer valid or applicable.

Scoring Function Modified User ID

  • Field Name: Score_Responses.Scoring_Function_Modified_User_ID

  • Required: YES

  • Type: STRING

  • Description: Identifies the user who last modified the details of the scoring function.

Scoring Function Version Created Timestamp

  • Field Name: Score_Responses.Scoring_Function_Version_Created_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: The date and time when a specific version of the scoring function was created.

Scoring Function Version Last Modified Timestamp

  • Field Name: Score_Responses.Scoring_Function_Version_Last_Modified_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: The most recent date and time when a specific version of the scoring function was modified.

Questionnaire Log

Question Responses

  • Field Name: Question_Responses

  • Required: NO

  • Type: ARRAY

  • Description: Represents the individual responses to specific questions within the questionnaire. See below for detailed information on each parameter in the Array.

Question Response Key

  • Field Name: Question_Responses.Question_Response_Key

  • Required: YES

  • Type: INT64

  • Description: Identifier for the question response.

Question Response Scoring Weight

  • Field Name: Question_Responses.Question_Response_Scoring_Weight

  • Required: YES

  • Type: NUMERIC

  • Description: Weight or score assigned to the question response.

Question Response Modified User ID

  • Field Name: Question_Responses.Question_Response_Modified_User_ID

  • Required: YES

  • Type: STRING

  • Description: ID of the user who modified the question response.

Question Position

  • Field Name: Question_Responses.Question_Position

  • Required: YES

  • Type: INT64

  • Description: Position of the question in the questionnaire.

Question Key

  • Field Name: Question_Responses.Question_Key

  • Required: YES

  • Type: INT64

  • Description: Identifier for the question.

Question Version Key

  • Field Name: Question_Responses.Question_Version_Key

  • Required: YES

  • Type: INT64

  • Description: Identifier for the version of the question.

Question Version Number

  • Field Name: Question_Responses.Question_Version_Number

  • Required: YES

  • Type: INT64

  • Description: Version number of the question.

Full Clinical Question

  • Field Name: Question_Responses.Full_Question_Clinical

  • Required: YES

  • Type: STRING

  • Description: Full clinical question text.

Short Question

  • Field Name: Question_Responses.Short_Question

  • Required: YES

  • Type: STRING

  • Description: Abbreviated or shortened version of the question.

Question Report Title

  • Field Name: Question_Responses.Question_Report_Title

  • Required: YES

  • Type: STRING

  • Description: Title used for reporting purposes related to the question.

Question Code

  • Field Name: Question_Responses.Question_Code

  • Required: YES

  • Type: STRING

  • Description: Code associated with the question.

Question Response Type

  • Field Name: Question_Responses.Question_Response_Type

  • Required: YES

  • Type: STRING

  • Description: Type of response expected for the question. See Dictionary Response Type table in the Dictionary Dataset Specification.

Question Display Type

  • Field Name: Question_Responses.Question_Display_Type

  • Required: YES

  • Type: STRING

  • Description: Display type for the question in the user interface.

Question Response Type Description

  • Field Name: Question_Responses.Question_Response_Type_Description

  • Required: YES

  • Type: STRING

  • Description: Description of the question response type. See Dictionary Response Type table in the Dictionary Dataset Specification.

Question Response Value Type

  • Field Name: Question_Responses.Question_Response_Value_Type

  • Required: YES

  • Type: STRING

  • Description: Data type of the response value. See Dictionary Response Value Type table in the Dictionary Dataset Specification.

Question Response Value Type Description

  • Field Name: Question_Responses.Question_Response_Value_Type_Description

  • Required: YES

  • Type: STRING

  • Description: Description of the data type of the response value. See Dictionary Response Value Type table in the Dictionary Dataset Specification.

Question Effective Timestamp

  • Field Name: Question_Responses.Question_Effective_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp when the question became effective.

Question Termination Timestamp

  • Field Name: Question_Responses.Question_Termination_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp when the question is terminated.

Question Modified User ID

  • Field Name: Question_Responses.Question_Modified_User_ID

  • Required: YES

  • Type: STRING

  • Description: ID of the user who modified the question.

Question Version Created Timestamp

  • Field Name: Question_Responses.Question_Version_Created_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp when the version of the question was created.

Questionnaire Dataset Specification

Question Responses

Columns and Descriptions

  • Question_Version_Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp of the last modification to the question version.

  • Question_Response_Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the question response was created.

  • Question_Response_Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp of the last modification to the question response.

  • Response_Detail_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Identifier for the response detail.

  • Response_Value_Clarification

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Clarification or additional information about the response.

  • Response_Void_Indicator

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicator for voided response.

  • Response_Void_Reason

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Reason for voiding the response.

  • Response_Void_Reason_Description

  • Is Nullable: YES

  • Data Type: STRING

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

  • Response_Void_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID who voided the response.

  • Response_Void_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the response was voided.

  • Response_Selection_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Identifier for the response selection.

  • Response_Detail_Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the response detail was created.

  • Response_Detail_Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp of the last modification to the response detail.

Questionnaire Log

Columns and Descriptions

  • Enrollment_Program

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Refers to the program or process through which individuals are enrolled or registered.

  • Screening_Program

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Pertains to the program or process used for screening or assessing individuals.

  • Program_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique identifier associated with a specific program or initiative.

  • Record_Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The most recent date and time when any record within the questionnaire log was modified.

  • Transaction_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifies the user responsible for the transaction or modification.

  • Deleted_Indicator

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates whether a record has been deleted or voided.

  • Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Specifies the type or category of the questionnaire log entry (e.g., response, modification, etc.).

  • Tenant

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Refers to the specific organizational unit or context within which the questionnaire log operates.

  • Active_Version

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Denotes the currently active version of the questionnaire log.

  • Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: The date associated with the questionnaire log entry.

  • Sequence

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Represents the order or sequence of log entries.

  • Source_System_Name

  • Is Nullable: YES

  • Data Type: STRING

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

  • Source_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp associated with the data source.

  • Source_File_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name of the file or data source containing the questionnaire log information.

  • Schema_Version

  • Is Nullable: YES

  • Data Type: FLOAT64

  • Description: Indicates the version of the schema or data model used for the questionnaire log.

  • Member_Partition

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Refers to a specific partition or subset of members within the dataset.

  • Action

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Describes the action or operation performed on the questionnaire log entry (e.g., create, update, delete).

  • Transaction_Actor_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of the actor performing the transaction.

Questionnaire Metadata

Columns and Descriptions

  • Questionnaire_Version_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for the specific version of the questionnaire.

  • Version_Number

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Version number of the questionnaire, indicating revisions or updates.

  • Title

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Title or name of the questionnaire.

  • Effective_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp marking when this version of the questionnaire became effective.

  • Termination_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when this version of the questionnaire was terminated or became inactive.

  • Version_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: ID of the user who last modified this version of the questionnaire.

  • Version_Modified_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the user who last modified this version of the questionnaire.

  • Version_Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when this version of the questionnaire was created.

  • Version_Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when this version of the questionnaire was last modified.

  • Questionnaire_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Primary key for the questionnaire, linking different versions and forms.

  • Questionnaire_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Code uniquely identifying the questionnaire across versions.

  • Class

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Classification of the questionnaire, indicating its general use or nature.

  • Class_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the class, explaining the purpose or usage of the questionnaire within the specified class.

  • Help

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Help text or instructions provided within the questionnaire for guidance.

  • Position

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Position or order of the questionnaire in a sequence or collection.

Questionnaire Dataset Specification

Questionnaire Metadata

Columns and Descriptions

  • Active_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the questionnaire was activated or went live.

  • Inactive_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the questionnaire was deactivated or retired.

  • Dashboard_Indicator

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Boolean indicating whether the questionnaire is displayed on administrative dashboards.

  • All_Roles_Indicator

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Boolean indicating whether the questionnaire is available to all user roles.

  • All_Customer_Categories_Indicator

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Boolean indicating whether the questionnaire is applicable across all customer categories.

  • Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: ID of the user who last modified the questionnaire metadata.

  • Modified_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the user who last modified the questionnaire metadata.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp marking the creation of the questionnaire metadata record.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp marking the last modification of the questionnaire metadata record.

Questionnaire Metadata Customer Categories

Columns and Descriptions

  • Customer_Category_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for the customer category associated with a specific questionnaire version.

  • Questionnaire_Version_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Identifier linking to a specific version of the questionnaire for which the customer category applies.

  • Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Code representing the customer category applicable to the questionnaire.

  • Effective_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the association between the questionnaire and the customer category became effective.

  • Termination_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the association between the questionnaire and the customer category was terminated.

  • Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: ID of the user who last modified the record concerning the association of the questionnaire with a customer category.

  • Modified_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the user who last modified the record.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the record associating the questionnaire with a customer category was created.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the record was last modified, showing updates to the association details.

Questionnaire Metadata Display Hierarchy

Columns and Descriptions

  • Questionnaire_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: A unique identifier for the questionnaire.

  • Questionnaire_Version_Key

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique identifier for a specific version of the questionnaire.

  • Questionnaire_Effective_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp from which this questionnaire version became effective.

  • Questionnaire_Termination_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when this questionnaire version was or will be terminated.

  • Questionnaire_Version_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The user ID of the person who last modified this questionnaire version.

  • Questionnaire_Title

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The title of the questionnaire.

  • Questionnaire_Question_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: A unique identifier for a question within the questionnaire.

  • Section_Title

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The title of the section in which the question appears.

  • Top_Level_Position

  • Is Nullable: YES

  • Data Type: INT64

  • Description: The position of the question at the top level of the questionnaire hierarchy.

  • Question_Depth

  • Is Nullable: YES

  • Data Type: INT64

  • Description: The depth of the question within the questionnaire's hierarchical structure.

  • Other_Level_Position

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The position of the question within its specific level of the hierarchy.

  • Question_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Another identifier for the question, possibly used for internal references.

  • Question_Code

  • Is Nullable: YES

  • Data Type: STRING

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

  • Question_Required

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates whether the question is mandatory or optional.

  • Short_Question

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A shortened version of the question text.

  • Full_Question_Clinical

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The full text of the question as it appears in clinical contexts.

  • Response_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A description of the type of response expected for this question.

  • Question_Report_Title

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The title of the question as it should appear in reports.

  • Question_Selections

  • Is Nullable: NO

  • Data Type: ARRAY

  • Description: A collection of possible selections or answers for the question.

  • Question_Selections.Question_Selection_Key

  • Is Nullable: NO

  • Data Type: INT64

  • Description: A unique identifier for a specific selection or answer option.

Questionnaire Dataset Specification

Questionnaire Metadata Display Hierarchy

Table Content

Table Name

Column Name

Is Nullable

Data Type

Description

Questionnaire_Metadata_Display_Hierarchy

Questionnaire_Key

YES

INT64

Unique identifier for the questionnaire in the metadata display hierarchy.

Questionnaire_Metadata_Display_Hierarchy

Questionnaire_Version_Key

YES

INT64

Identifier for the specific version of the questionnaire.

Questionnaire_Metadata_Display_Hierarchy

Questionnaire_Effective_Timestamp

YES

TIMESTAMP

Date and time when the questionnaire version became active.

Questionnaire_Metadata_Display_Hierarchy

Questionnaire_Termination_Timestamp

YES

TIMESTAMP

Date and time when the questionnaire version expired or was terminated.

Questionnaire_Metadata_Display_Hierarchy

Questionnaire_Version_Modified_User_ID

YES

STRING

User ID of the person who last modified the questionnaire version.

Questionnaire_Metadata_Display_Hierarchy

Questionnaire_Title

YES

STRING

Title of the questionnaire as displayed in the metadata hierarchy.

Questionnaire_Metadata_Display_Hierarchy

Questionnaire_Question_Key

YES

INT64

Unique identifier for each question within the questionnaire.

Questionnaire_Metadata_Display_Hierarchy

Section_Title

YES

STRING

Title of the section containing the question, if the questionnaire is organized by sections.

Questionnaire_Metadata_Display_Hierarchy

Question_Depth

YES

INT64

Depth or hierarchical level of the question within the questionnaire structure.

Questionnaire_Metadata_Display_Hierarchy

Question_Key

YES

INT64

Unique identifier for the individual question.

Questionnaire_Metadata_Display_Hierarchy

Question_Code

YES

STRING

Code or shorthand for the question, used for reference in the questionnaire structure.

Questionnaire_Metadata_Display_Hierarchy

Question_Required

YES

BOOL

Indicates if the question is mandatory (yes/no).

Questionnaire_Metadata_Display_Hierarchy

Short_Question

YES

STRING

Abbreviated text of the question, used in condensed displays.

Questionnaire_Metadata_Display_Hierarchy

Full_Question_Clinical

YES

STRING

Full clinical version of the question text, intended for detailed displays.

Questionnaire_Metadata_Display_Hierarchy

Response_Type_Description

YES

STRING

Describes the type of response expected for the question (e.g., multiple choice, free text).

Questionnaire_Metadata_Display_Hierarchy

Question_Report_Title

YES

STRING

Title for the question when displayed in reports, potentially different from the question text.

Questionnaire_Metadata_Display_Hierarchy

Question_Selections

NO

ARRAY

Array of possible response options or selections for the question, if applicable.

Questionnaire_Metadata_Display_Hierarchy

Questionnaire_Question_Key_Path

YES

STRING

Path representation showing the unique identifiers of each question in the hierarchy within the questionnaire.

Questionnaire_Metadata_Display_Hierarchy

Questionnaire_Question_Short_Question_Path

YES

STRING

Path representation showing the short form text of each question in the hierarchy, useful for summary views or quick navigation.

Question Selections

Column Name

Is Nullable

Data Type

Description

Question_Selections.Question_Selection_Key

YES

INT64

Unique identifier for each possible response selection option.

Question_Selections.Question_Selection_Code

YES

STRING

Code representing each selection option for easy reference within the system.

Question_Selections.Question_Selection_Value

YES

STRING

Display text for each selection option shown to users.

Question_Selections.Question_Selection_Position

YES

INT64

Position or order of each selection option within the list of response choices.

Questionnaire Metadata Programs

Table Content

Table Name

Column Name

Is Nullable

Data Type

Description

Questionnaire_Metadata_Programs

Program_Key

YES

INT64

Unique identifier for the program associated with a specific questionnaire version.

Questionnaire_Metadata_Programs

Questionnaire_Version_Key

YES

INT64

Identifier linking to a specific version of the questionnaire for which the program details apply.

Questionnaire_Metadata_Programs

Program

YES

STRING

Name or identifier of the program linked to the questionnaire version.

Questionnaire_Metadata_Programs

Program_Description

YES

STRING

Detailed description of the program as it relates to the questionnaire.

Questionnaire_Metadata_Programs

Primary

YES

BOOL

Indicates whether the program is the primary focus for the associated questionnaire version.

Questionnaire_Metadata_Programs

Effective_Timestamp

YES

TIMESTAMP

Timestamp when the association between the questionnaire and the program became active.

Questionnaire_Metadata_Programs

Termination_Timestamp

YES

TIMESTAMP

Timestamp when the association between the questionnaire and the program was terminated.

Questionnaire_Metadata_Programs

Modified_User_ID

YES

STRING

ID of the user who last modified the record regarding the program and questionnaire association.

Questionnaire Dataset Specification

Table: ta_Programs

Columns

  • Modified_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the user who last modified the record, providing accountability and traceability.

Table: Questionnaire_Metadata_Programs

Columns

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the record associating the questionnaire with the program was initially created.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the record was last updated to reflect changes in the program or its association with the questionnaire.

Table: Questionnaire_Metadata_Question

Columns

  • Questionnaire_Question_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for the questionnaire question.

  • Questionnaire_Version_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Links the question to a specific version of the questionnaire.

  • Section_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Identifier for the section within the questionnaire where this question is placed.

  • Position

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Numeric position or order of the question within its section or the questionnaire.

  • Member_Portal

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates whether the question is visible on the member portal.

  • Provider_Portal

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates whether the question is visible on the provider portal.

  • Depth

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Level of nesting or depth of the question within the questionnaire structure.

  • Required

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates if answering the question is mandatory.

  • Questionnaire_Question_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: ID of the user who last modified the question.

  • Questionnaire_Question_Modified_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the user who last modified the question.

  • Questionnaire_Question_Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the question was first created.

  • Questionnaire_Question_Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the question was last modified.

  • Question_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Secondary identifier for the question, often used in cross-referencing within the dataset.

  • Short_Question

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A brief or shortened form of the question text.

  • Question_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Code assigned to the question for identification purposes, often used in coding and analyses.

  • Response_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of response required (e.g., text, select, radio button).

  • Response_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the response type to aid in understanding the expected input.

  • Response_Value_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Specifies the data type of the response (e.g., integer, string).

  • Response_Value_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Provides additional detail about the nature of the response value type.

  • Class

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Classification or category of the question, which might relate to its function or usage in the questionnaire.

  • Class_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Detailed description of the class to clarify its meaning and application.

  • Active

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates whether the question is currently active and should be displayed.

  • Question_Available_To_AWF

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Determines if the question can be accessed by automated workflows (AWF).

  • Clinical_Help

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Help text providing clinical guidance or information related to the question.

  • Non_Clinical_Help

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Help text providing non-clinical advice or information such as administrative details related to the question.

  • Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the person who last modified any details of the question.

  • Modified_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the person who last updated the question, used for tracking changes.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the question entry was originally created.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp of the most recent update made to the question's details.

Table: Questionnaire_Metadata_Question_Child_Questions

Columns

  • Child_Question_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for each child question entry within the table.

  • Questionnaire_Question_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: References the parent question's unique identifier within the questionnaire.

  • Child_Questionnaire_Question_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for the child question, linking it to its specific details within the questionnaire.

  • Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: ID of the user who last modified the child question entry.

  • Modified_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the user who last made changes to the child question record.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the child question record was first created in the database.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp of the most recent update made to the child question's details.

Questionnaire Dataset Specification

Overview

This section provides detailed specifications for the dataset tables related to questionnaires in the Care Intelligence system. Each table contains metadata and attributes essential for managing questionnaire functionality, including child questions, entry tests, and selection enablers.

Questionnaire Metadata: Child Questions

Table Name: Questionnaire_Metadata_Question_Child_Questions

Columns:

  • Child_Question_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for each child question entry within the table.

  • Questionnaire_Question_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: References the parent question's unique identifier within the questionnaire.

  • Child_Questionnaire_Question_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for the child question, linking it to its specific details within the questionnaire.

  • Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: ID of the user who last modified the child question entry.

  • Modified_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the user who last made changes to the child question record.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the child question record was first created in the database.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp of the most recent update made to the child question's record, capturing any changes made.

Questionnaire Metadata: Entry Test Enablers

Table Name: Questionnaire_Metadata_Question_Entry_Test_Enablers

Columns:

  • Entry_Test_Enabler_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for the entry test enabler record, used for tracking within the dataset.

  • Entry_Test_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: References the key of the entry test that this enabler is associated with, linking specific conditions or rules for questionnaire entry.

  • Questionnaire_Question_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Identifies the questionnaire question that this entry test enabler affects, establishing contextual dependencies.

  • Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: ID of the user who last modified this enabler entry, providing accountability for changes.

  • Modified_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the user who last updated the entry test enabler, ensuring traceability of modifications.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the entry test enabler was created, used for audit and tracking purposes.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp of the most recent modification to the entry test enabler record, useful for version control and updates tracking.

Questionnaire Metadata: Entry Tests

Table Name: Questionnaire_Metadata_Question_Entry_Tests

Columns:

  • Entry_Test_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for the entry test record. This key is used to reference specific entry tests within the questionnaire framework.

  • Questionnaire_Question_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Links to the questionnaire question this entry test is associated with, indicating which question the test applies to.

  • Minimum_Value

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Specifies the minimum value allowed for responses to the questionnaire question, ensuring responses meet predetermined criteria.

  • Maximum_Value

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Specifies the maximum value allowed for responses to the questionnaire question, ensuring responses do not exceed predetermined limits.

  • Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier of the user who last modified the entry test, tracking changes and maintaining data integrity.

  • Modified_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the user who last modified the entry test, providing clarity on who made the last updates.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the entry test record was created, providing a record of when the test was initially set up.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the entry test record was last modified, ensuring a track record of the most recent updates.

Questionnaire Metadata: Selection Enablers

Table Name: Questionnaire_Metadata_Question_Selection_Enablers

Columns:

  • Selection_Enabler_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for the selection enabler record. This key is used to uniquely identify and reference specific enablers within the questionnaire framework.

  • Questionnaire_Selection_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Links to the specific selection within a questionnaire to which this enabler is applied, facilitating dynamic control over option availability based on prior inputs.

  • Questionnaire_Question_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Identifies the questionnaire question associated with this selection enabler, indicating which question's response influences the availability of this selection.

  • Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier of the user who last modified the selection enabler record, aiding in tracking changes and maintaining accountability.

  • Modified_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the user who last modified the selection enabler record, providing clarity on the person responsible for the most recent updates.

Questionnaire Dataset Specification

Selection Enablers

Columns

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the selection enabler record was initially created, establishing a historical context for the record's inception.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp noting when the selection enabler record was last updated, ensuring a track record of the latest modifications for audit and review purposes.

Questionnaire Metadata: Question Selection Problems

Columns

  • Selection_Problem_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for the selection problem record. This key is used to uniquely identify and manage specific problem records related to questionnaire selections.

  • Questionnaire_Selection_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Links to the specific questionnaire selection that this problem is associated with, ensuring that problems are correctly mapped to their relevant questionnaire components.

  • Problem

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A brief label or identifier for the problem, used to quickly reference the nature of the issue associated with the questionnaire selection.

  • Problem_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Detailed description of the problem, providing further insight into the issue, its context, and its implications for the questionnaire functionality.

  • Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier of the user who last modified the problem record, which helps track changes and maintain accountability in the management of questionnaire issues.

  • Modified_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the user who last modified the problem record, offering clarity on who is responsible for the latest changes to the problem details.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp marking when the problem record was initially created, providing a historical record of when the problem was first acknowledged and documented.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating the last modification to the problem record, useful for tracking updates and changes over time for audit and maintenance purposes.

Questionnaire Metadata: Question Selection Versions

Columns

  • Selection_Version_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for each version of a questionnaire selection, used to track changes and maintain different versions over time.

  • Questionnaire_Selection_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: References the specific questionnaire selection to which this version belongs, linking the version directly to its parent selection.

  • Question_Version_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Links to the questionnaire version that includes this specific selection, integrating the selection within the broader questionnaire structure.

  • Position

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Indicates the ordinal position of this selection within the questionnaire, helping to organize and display the selection in the correct sequence.

  • Value

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The actual content or option value provided by this selection version, which respondents can choose or view within the questionnaire.

  • Clarification_Indicator

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: A boolean indicator specifying whether additional clarification is required or provided for this selection, enhancing understanding or requiring further input.

  • Mutual_Exclusive

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: A boolean value that indicates whether the selection is mutually exclusive with other selections, preventing multiple concurrent selections when true.

  • Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier of the user who last modified this version, aiding in tracking changes and attributing modifications within the system.

  • Modified_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the user who made the last changes to this version, providing clear accountability and referencing for system audits.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp marking the creation of this version, essential for historical data tracking and version management.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp of the last modification to this version, crucial for maintaining accurate records of updates and changes over time.

Questionnaire Metadata: Question Selections

Columns

  • Questionnaire_Selection_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for the selection within the questionnaire, used to uniquely identify and manage each selection entity.

  • Questionnaire_Question_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: References the questionnaire question to which this selection is linked, establishing a relational connection within the dataset.

  • Question_Selection_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: A unique key for tracking individual selections linked to specific questions, ensuring accurate response capture and analysis.

  • Scoring_Weight

  • Is Nullable: YES

  • Data Type: NUMERIC

  • Description: Numeric value that assigns a weight to the selection for scoring purposes.

Questionnaire Dataset Specification

Questionnaire Metadata Question Selections

Columns

  • Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: ID of the user who last modified the selection, crucial for audit trails and change management within the system.

  • Modified_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the user who last updated the selection, providing accountability and traceability for changes.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the selection was first created, important for historical data tracking and analysis.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp of the most recent modification to the selection, essential for maintaining the integrity and relevance of the questionnaire data.

  • Selection_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A specific code assigned to the selection, used for identification and possibly linking to other data elements or logic within the system.

  • Selection_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: ID of the user who last modified the selection details, helping in maintaining detailed records of who made changes.

  • Selection_Modified_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the user who modified the selection details, ensuring clear documentation of who made specific updates.

  • Selection_Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp marking the creation of the selection detail, used to track when each selection was initially added to the database.

  • Selection_Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The last modification timestamp for the selection details, used to trace the most recent updates to the selection settings.

Questionnaire Metadata Question Versions

Columns

  • Version_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for each version of a questionnaire question, used to track changes and updates over time.

  • Questionnaire_Question_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Links to the specific questionnaire question this version belongs to, establishing relational context within the dataset.

  • Version_Number

  • Is Nullable: YES

  • Data Type: INT64

  • Description: A sequential number representing the version of the questionnaire question, useful for version control and historical tracking.

  • Full_Question_Clinical

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The complete clinical text of the question as it appears in the questionnaire, providing clear context for responses.

  • Effective_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when this version of the question became effective, crucial for temporal data accuracy and applicability.

  • Termination_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp marking when this version was retired or replaced, essential for maintaining historical data integrity.

  • Report_Title

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Title used in reports for this version of the question, aiding in data aggregation and presentation.

  • Display_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Specifies how the question is displayed in the questionnaire, affecting respondent interaction and data collection.

  • Response_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Describes the type of response expected for the question, guiding data entry and validation.

  • Field_Length

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Defines the maximum length of the response field, ensuring data consistency and proper storage.

  • Input_Length

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Specifies the length of input allowed for responses, important for form design and user interface considerations.

  • Maximum_Value

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The maximum allowable value for numeric responses, used in validations to maintain data quality.

  • Minimum_Value

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The minimum allowable value for numeric responses, ensuring responses are within a defined acceptable range.

  • Selections_Allowed

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Number of selections permitted if the question allows multiple responses, crucial for maintaining logical data structure.

  • Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier of the user who last modified this version, providing a trail for audit and change management.

  • Modified_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the user who last modified this version, adding a personal accountability layer to the change history.

  • Version_Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when this version was created, marking its origin and aiding in chronological tracking of updates.

  • Version_Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when this version was last modified, crucial for understanding the most recent updates and changes.

Questionnaire Metadata Roles

Columns

  • Role_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for a specific role related to the questionnaire, used for access control and permissions management.

  • Questionnaire_Version_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Links to the specific version of the questionnaire this role is associated with, ensuring role permission.

Questionnaire Dataset Specification

Questionnaire Metadata Roles

Role_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique code representing the role, used for quick identification and reference in system processes.

Role_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Provides a detailed description of the role, clarifying the responsibilities and permissions associated with it.

Effective_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp marking when the role permissions or definitions become effective, critical for managing access over time.

Termination_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the role permissions are no longer valid, essential for maintaining security and relevancy.

Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier of the user who last modified the role information, aiding in tracking changes and maintaining data integrity.

Modified_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the user who last updated the role details, providing a personal link to the change history for accountability.

Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the role was initially created, useful for historical tracking and auditing purposes.

Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp of the most recent modification to the role, ensuring that all changes are accurately recorded and traceable.

Questionnaire Metadata Sections

Section_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for the section within the questionnaire, used to distinctly reference each part of the questionnaire structure.

Questionnaire_Version_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Identifies the specific version of the questionnaire to which this section belongs, ensuring consistency and accuracy in responses.

Title

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The title of the section, providing a clear and concise description of the content covered in this part of the questionnaire.

Position

  • Is Nullable: YES

  • Data Type: INT64

  • Description: The order in which this section appears within the questionnaire, used for proper sequencing and display.

Help_Text

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Descriptive text provided to assist users in understanding the context or requirements of the section, aimed at improving response accuracy.

Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier of the user who last made changes to the section, important for tracking modifications and maintaining version control.

Modified_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name of the user who last updated the section, providing a traceable record of who made changes for accountability purposes.

Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when the section was originally created, serving as a record of its inception for historical reference.

Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp of the most recent change made to the section, essential for version control and update tracking.

Questionnaire Responses

Member_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The unique identifier for the member whose responses are recorded.

Questionnaire_Response_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: A unique key that identifies each specific set of responses within a questionnaire.

Class

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The classification of the questionnaire based on its purpose or content.

Class_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Detailed description of the class, explaining its significance and use.

Response_Note

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Notes or additional information provided by the responder or system regarding the responses.

Source

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The origin of the questionnaire response, such as an app or a clinical visit.

Source_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Describes the source in detail to clarify the context of the response entry.

Source_Entry_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp marking when the response was entered into the system.

Completed_By_Auto_Close

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates whether the questionnaire was automatically closed by the system.

Questionnaire_Response_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: ID of the user who last modified the response.

Questionnaire_Response_Modified_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the user who last modified the response.

Questionnaire_Response_Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the response was initially created.

Questionnaire_Response_Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the response was last modified.

Questionnaire_Response_Last_Modified_Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: The date when the last modification was made to the response.

Questionnaire_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: The key linking to the specific questionnaire.

Questionnaire_Version_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: The key for the specific version of the questionnaire being responded to.

Questionnaire_Version_Number

  • Is Nullable: YES

  • Data Type: INT64

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

Questionnaire_Title

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The title of the questionnaire.

Questionnaire_Version_Title

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The title of the specific version of the questionnaire.

Questionnaire Dataset Specification

Questionnaire Responses

NG

  • Description: The title of the specific version of the questionnaire.

Questionnaire_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique code assigned to the questionnaire for identification.

Dashboard_Indicator

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates whether the questionnaire data is displayed on dashboards.

Enrollment_Program

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Program under which the questionnaire was enrolled.

Screening_Program

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Screening program associated with the questionnaire.

Program_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Unique identifier for the program related to the questionnaire.

Complete_Indicator

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates whether the questionnaire has been completed.

First

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates if this is the first set of responses for the questionnaire.

Latest

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates if this is the latest set of responses for the questionnaire.

First_Completed

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates if this was the first completed instance of the questionnaire.

Latest_Completed

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates if this was the latest completed instance of the questionnaire.

Member_Enrollment_Effective_Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: Effective date of member enrollment.

Member_Enrollment_Termination_Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: Termination date of member enrollment.

Member_Enrollment_Key

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for member enrollment.

Questionnaire Metadata Log

Questionnaire_Version_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for a specific version of the questionnaire, crucial for tracking changes over time.

Version_Number

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Sequential number representing the version of the questionnaire, aiding in version control and history.

Title

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The title or name of the questionnaire, used for identification and display purposes.

Effective_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when this version of the questionnaire became effective or active.

Termination_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date and time when this version of the questionnaire was terminated or became inactive.

Version_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier of the user who last modified this version, ensuring traceability of changes.

Version_Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when this version of the questionnaire was created, providing a historical record.

Version_Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when this version of the questionnaire was last modified, tracking the most recent updates.

Questionnaire_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for the questionnaire, linking various versions and related data.

Questionnaire_Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A code or shorthand identifier for the questionnaire, used for quick reference and categorization.

Class

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Classification or type of the questionnaire, indicating its purpose or thematic grouping. See Dictionary Questionnaire Class table in the Dictionary Dataset Specification.

Class_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Detailed description of the class, providing context and understanding of its use. See Dictionary Questionnaire Class table in the Dictionary Dataset Specification.

Help

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Help text or guidance provided for understanding or completing the questionnaire.

Position

  • Is Nullable: YES

  • Data Type: INT64

  • Description: The order or sequence of the questionnaire in a larger set or collection, determining its placement.

Active_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when the questionnaire became active, marking its availability for use.

Inactive_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when the questionnaire became inactive, indicating it is no longer in use.

Dashboard_Indicator

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: A boolean flag indicating whether the questionnaire is featured on dashboards or prominent interfaces.

All_Roles_Indicator

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: A boolean flag indicating whether the questionnaire is applicable to all user roles, ensuring broad accessibility.

All_Customer_Categories_Indicator

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: A boolean indicating if the questionnaire applies to all customer categories, reflecting its universal relevance.

Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier of the user who last made changes to the questionnaire log, for accountability.

Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when the questionnaire log record was initially created, marking the entry point of data.

Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The most recent timestamp when the questionnaire log record was modified, tracking updates.

Customer_Categories

  • Is Nullable: NO

  • Data Type: ARRAY

  • Description: An array detailing the customer categories applicable to the questionnaire, specifying targeted audience segments. See below for detailed information on each parameter in the array.

Customer_Categories.Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: A unique key for the customer category.

Customer_Categories.Code

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique code for the customer category.

Customer_Categories.Questionnaire_Effective_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when the customer category became effective for the questionnaire.

Questionnaire Dataset Specification

Metadata Fields

Effective Timestamp

  • Field Name: Customer_Categories.Questionnaire_Termination_Timestamp

  • Type: TIMESTAMP

  • Description: The date when the questionnaire becomes effective or applicable.

Termination Timestamp

  • Field Name: Customer_Categories.Questionnaire_Termination_Timestamp

  • Type: TIMESTAMP

  • Description: The date when the questionnaire is no longer valid or applicable.

Modified User ID

  • Field Name: Customer_Categories.Modified_User_ID

  • Type: STRING

  • Description: User ID of the user who last modified the record.

Created Timestamp

  • Field Name: Customer_Categories.Created_Timestamp

  • Type: TIMESTAMP

  • Description: Timestamp indicating when the record was created.

Last Modified Timestamp

  • Field Name: Customer_Categories.Last_Modified_Timestamp

  • Type: TIMESTAMP

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

Questionnaire Metadata Log

Programs

  • Field Name: Questionnaire_Metadata_log.Programs

  • Type: ARRAY

  • Description: An array of programs associated with the questionnaire, defining its application or relevance in various programmatic contexts.

Program Fields

  • Key

  • Type: INT64

  • Description: A unique identifier or key for the specific program associated with the questionnaire.

  • Program

  • Type: STRING

  • Description: The name or code representing the program linked to the questionnaire.

  • Program Description

  • Type: STRING

  • Description: A detailed description of the program, providing context or additional information about its purpose.

  • Primary

  • Type: STRING

  • Description: Indicates whether this program is the primary or main program associated with the questionnaire (e.g., a flag or marker).

  • Effective Timestamp

  • Type: TIMESTAMP

  • Description: The date when the questionnaire becomes effective or applicable.

  • Termination Timestamp

  • Type: TIMESTAMP

  • Description: The date when the questionnaire is no longer valid or applicable.

  • Modified User ID

  • Type: STRING

  • Description: User ID of the user who last modified the record.

  • Created Timestamp

  • Type: TIMESTAMP

  • Description: Timestamp indicating when the record was created.

  • Last Modified Timestamp

  • Type: TIMESTAMP

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

Roles

  • Field Name: Questionnaire_Metadata_log.Roles

  • Type: ARRAY

  • Description: An array defining the roles for which the questionnaire is intended, ensuring appropriate targeting and use.

Role Fields

  • Program Provider Roles Key

  • Type: INT64

  • Description: Unique identifier for the program provider roles entry.

  • Role Code

  • Type: STRING

  • Description: Code representing the role of the provider within the program.

  • Role Description

  • Type: STRING

  • Description: Description of the role of the provider within the program.

  • Role Effective Date

  • Type: DATE

  • Description: Effective date of the provider's role within the program.

  • Role Termination Date

  • Type: DATE

  • Description: Termination date of the provider's role within the program, if applicable.

  • Modified User ID

  • Type: TIMESTAMP

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

  • Role Created Timestamp

  • Type: TIMESTAMP

  • Description: Timestamp indicating when the provider's role entry was created.

  • Role Last Modified Timestamp

  • Type: TIMESTAMP

  • Description: Timestamp indicating when the provider's role entry was last modified.

Sections

  • Field Name: Questionnaire_Metadata_log.Sections

  • Type: ARRAY

  • Description: An array detailing the different sections of the questionnaire, aiding in structuring and organizing the content.

Section Fields

  • Key

  • Type: INT64

  • Description: A unique identifier for each section within the questionnaire.

  • Title

  • Type: STRING

  • Description: The title or name of the section, providing a brief overview of its content.

  • Position

  • Type: STRING

  • Description: The order or position of the section within the questionnaire.

  • Help Text

  • Type: STRING

  • Description: Additional information or instructions to assist users in understanding the section.

  • Modified User ID

  • Type: TIMESTAMP

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

  • Created Timestamp

  • Type: TIMESTAMP

  • Description: Timestamp indicating when the record was created.

  • Last Modified Timestamp

  • Type: TIMESTAMP

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

Additional Metadata Fields

Record Last Modified Timestamp

  • Field Name: Questionnaire_Metadata_log.Record_Last_Modified_Timestamp

  • Type: TIMESTAMP

  • Description: The latest timestamp when any part of the record was updated, for data currency.

Transaction User ID

  • Field Name: Questionnaire_Metadata_log.Transaction_User_ID

  • Type: STRING

  • Description: The identifier of the user associated with the transaction, providing a trace of interactions.

Deleted Indicator

  • Field Name: Questionnaire_Metadata_log.Deleted_Indicator

  • Type: BOOL

  • Description: A boolean flag indicating whether the record has been marked as deleted, crucial for data integrity.

Type

  • Field Name: Questionnaire_Metadata_log.Type

  • Type: STRING

  • Description: The type or category of the log entry, aiding in classification and filtering.

Tenant

  • Field Name: Questionnaire_Metadata_log.Tenant

  • Type: STRING

  • Description: Identifies the tenant domain within which the log record exists, important for multi-tenant environments.

Active Version

  • Field Name: Questionnaire_Metadata_log.Active_Version

  • Type: BOOL

  • Description: Indicates whether the log record is the current active version of the questionnaire metadata.

Date

  • Field Name: Questionnaire_Metadata_log.Date

  • Type: DATE

  • Description: The date associated with the log record, often used for historical tracking and reporting.

Sequence

  • Field Name: Questionnaire_Metadata_log.Sequence

  • Type: INT64

  • Description: A sequential number that orders the log entries, useful for sorting and historical analysis.

Source System Name

  • Field Name: Questionnaire_Metadata_log.Source_System_Name

  • Type: STRING

  • Description: The name of the system from which the log data originates, key for data lineage.

Source Timestamp

  • Field Name: Questionnaire_Metadata_log.Source_Timestamp

  • Type: TIMESTAMP

  • Description: The timestamp from the source system when the log entry was generated, aiding in synchronization.

Source File Name

  • Field Name: Questionnaire_Metadata_log.Source_File_Name

  • Type: STRING

  • Description: The name of the file from the source system, useful for data tracking and archival.

Schema Version

  • Field Name: Questionnaire_Metadata_log.Schema_Version

  • Type: FLOAT64

  • Description: The version of the data schema to which the log record adheres, important for data consistency.

Updated Flag

  • Field Name: Questionnaire_Metadata_log._updated

  • Type: STRING

  • Description: A system-generated flag or timestamp indicating the last update to the record.

Questionnaire Dataset Specification

Questionnaire Metadata Log

Fields

  • Action

  • Data Type: STRING

  • Nullable: YES

  • Description: Represents the specific action taken or recorded in the log, providing clarity on the nature of the log entry.

  • Transaction_Actor_Type

  • Data Type: STRING

  • Nullable: YES

  • Description: Type of the actor performing the transaction.

Questionnaire Metadata Question Log

Fields

  • Questionnaire_Question_Key

  • Data Type: INT64

  • Nullable: YES

  • Description: Unique identifier for each question within the questionnaire, essential for tracking and managing individual questions.

  • Questionnaire_Version_Key

  • Data Type: INT64

  • Nullable: YES

  • Description: Identifies the version of the questionnaire to which the question belongs, allowing for version control and historical tracking.

  • Section_Key

  • Data Type: INT64

  • Nullable: YES

  • Description: Key that links the question to a specific section within the questionnaire, organizing the questionnaire content structurally.

  • Position

  • Data Type: INT64

  • Nullable: YES

  • Description: Numerical order of the question within its section or the questionnaire, dictating the sequence in which questions are presented.

  • Member_Portal

  • Data Type: BOOL

  • Nullable: YES

  • Description: Indicates whether the question is visible or relevant in the member-facing portal, guiding user experience design.

  • Provider_Portal

  • Data Type: BOOL

  • Nullable: YES

  • Description: Flags whether the question appears in the provider-facing portal, affecting how providers interact with the questionnaire.

  • Depth

  • Data Type: INT64

  • Nullable: YES

  • Description: Represents the level of nesting or hierarchy for the question, useful in complex questionnaires with layered or conditional questions.

  • Required

  • Data Type: BOOL

  • Nullable: YES

  • Description: Boolean indicating whether answering the question is mandatory, ensuring critical data is collected in the questionnaire response.

  • Questionnaire_Question_Modified_User_ID

  • Data Type: STRING

  • Nullable: YES

  • Description: User ID of the individual who last modified the question, providing an audit trail for changes.

  • Questionnaire_Question_Created_Timestamp

  • Data Type: TIMESTAMP

  • Nullable: YES

  • Description: Timestamp of when the question was initially created, marking its origin in the system.

  • Questionnaire_Question_Last_Modified_Timestamp

  • Data Type: TIMESTAMP

  • Nullable: YES

  • Description: The last time the question was updated, tracking the most recent changes.

  • Key

  • Data Type: INT64

  • Nullable: YES

  • Description: A unique key for each log entry, facilitating the tracking of individual changes and updates to questionnaire questions.

  • Short_Question

  • Data Type: STRING

  • Nullable: YES

  • Description: A brief or abbreviated form of the question, used for quick reference or in space-constrained contexts.

  • Code

  • Data Type: STRING

  • Nullable: YES

  • Description: A unique code assigned to the question, aiding in identification and reference in analysis or reporting.

  • Response_Type

  • Data Type: STRING

  • Nullable: YES

  • Description: Defines the kind of response expected for the question, such as multiple choice, text, or numerical. See Dictionary Response Type table in the Dictionary Dataset Specification.

  • Response_Value_Type

  • Data Type: STRING

  • Nullable: YES

  • Description: Specifies the data type or nature of the response values, guiding data collection and validation processes. See Dictionary Response Value Type table in the Dictionary Dataset Specification.

  • Response_Value_Type_Description

  • Data Type: STRING

  • Nullable: YES

  • Description: Provides a detailed explanation of the response value type, clarifying the expected input format or content. See Dictionary Response Value Type table in the Dictionary Dataset Specification.

  • Class

  • Data Type: STRING

  • Nullable: YES

  • Description: Categorizes the question into a particular class or group, aiding in thematic organization and analysis. See Dictionary Questionnaire Class table in the Dictionary Dataset Specification.

  • Class_Description

  • Data Type: STRING

  • Nullable: YES

  • Description: Detailed explanation of the class, offering context and understanding of the question's thematic grouping. See Dictionary Questionnaire Class table in the Dictionary Dataset Specification.

  • Active

  • Data Type: BOOL

  • Nullable: YES

  • Description: Boolean indicating whether the question is currently active and should be presented in the questionnaire.

  • Question_Available_To_AWF

  • Data Type: BOOL

  • Nullable: YES

  • Description: Specifies whether the question is available for automated workflows, affecting how the question is processed in system operations.

  • Clinical_Help

  • Data Type: STRING

  • Nullable: YES

  • Description: Help text or guidance provided within a clinical context, assisting users in understanding or answering the question accurately.

  • Non_Clinical_Help

  • Data Type: STRING

  • Nullable: YES

  • Description: Additional help text or information provided in a non-clinical context, supporting users outside of direct patient care scenarios.

  • Modified_User_ID

  • Data Type: STRING

  • Nullable: YES

  • Description: The ID of the user who last made changes to the question log, tracking the source of modifications.

  • Created_Timestamp

  • Data Type: TIMESTAMP

  • Nullable: YES

  • Description: The time and date when the log record for the question was created, establishing a chronological record of entries.

  • Last_Modified_Timestamp

  • Data Type: TIMESTAMP

  • Nullable: YES

  • Description: The most recent time and date the log record was updated, maintaining a history of changes.

  • Child_Questions

  • Data Type: ARRAY

  • Nullable: NO

  • Description: An array of child questions, if any, which are dependent on or related to the main question, supporting complex question structures. See below for additional details.

Questionnaire Dataset Specification

Child Questions

Parameters

  • Questionnaire_Key

  • Type: INT64

  • Required: YES

  • Description: Identifier for the questionnaire to which the question belongs.

  • Questionnaire_Question_Key

  • Type: INT64

  • Required: YES

  • Description: Unique identifier for the questionnaire question.

  • Created_Timestamp

  • Type: TIMESTAMP

  • Required: YES

  • Description: Timestamp indicating when the record was created.

  • Last_Modified_User_ID

  • Type: STRING

  • Required: YES

  • Description: User ID of the user who last modified the record.

  • Last_Modified_Timestamp

  • Type: TIMESTAMP

  • Required: YES

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

Questionnaire Metadata Question Log

Entry Tests

  • Type: ARRAY

  • Required: NO

  • Description: An array of conditions or criteria that must be met for the question to be presented or considered relevant, ensuring appropriate question display.

Parameters

  • Key

  • Type: INT64

  • Required: YES

  • Description: A unique identifier for each entry test.

  • Minimum_Value

  • Type: STRING

  • Required: YES

  • Description: The minimum acceptable value for the entry test.

  • Maximum_Value

  • Type: STRING

  • Required: YES

  • Description: The maximum acceptable value for the entry test.

  • Modified_User_ID

  • Type: STRING

  • Required: YES

  • Description: User ID of the user who last modified the record.

  • Created_Timestamp

  • Type: TIMESTAMP

  • Required: YES

  • Description: Timestamp indicating when the record was created.

  • Last_Modified_Timestamp

  • Type: TIMESTAMP

  • Required: YES

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

Enablers

  • Type: ARRAY

  • Required: NO

  • Description: Defines conditions or thresholds that activate or modify the scoring function, allowing for dynamic and context-sensitive scoring.

Parameters

  • Child_Questions.Questionnaire_Key

  • Type: INT64

  • Required: YES

  • Description: Identifier for the questionnaire to which the question belongs.

  • Child_Questions.Questionnaire_Question_Key

  • Type: INT64

  • Required: YES

  • Description: Unique identifier for the questionnaire question.

  • Child_Questions.Created_Timestamp

  • Type: TIMESTAMP

  • Required: YES

  • Description: Timestamp indicating when the record was created.

  • Child_Questions.Last_Modified_User_ID

  • Type: STRING

  • Required: YES

  • Description: User ID of the user who last modified the record.

  • Child_Questions.Last_Modified_Timestamp

  • Type: TIMESTAMP

  • Required: YES

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

Selections

  • Type: ARRAY

  • Required: NO

  • Description: An array detailing the available choices or responses for the question, typically used for multiple-choice or selection-based questions.

Parameters

  • Key

  • Type: INT64

  • Required: YES

  • Description: A unique identifier for each selection.

  • Selection_Key

  • Type: INT64

  • Required: YES

  • Description: A unique identifier for the specific selection within the entry.

  • Scoring_Weight

  • Type: STRING

  • Required: YES

  • Description: The weight assigned to the selection for scoring purposes.

  • Modified_User_ID

  • Type: STRING

  • Required: YES

  • Description: User ID of the user who last modified the record.

  • Created_Timestamp

  • Type: TIMESTAMP

  • Required: YES

  • Description: Timestamp indicating when the record was created.

  • Last_Modified_Timestamp

  • Type: TIMESTAMP

  • Required: YES

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

  • Selection_Modified_User_ID

  • Type: STRING

  • Required: YES

  • Description: User ID of the user who last modified the record.

  • Selection_Created_Timestamp

  • Type: TIMESTAMP

  • Required: YES

  • Description: Timestamp indicating when the record was created.

  • Selection_Last_Modified_Timestamp

  • Type: TIMESTAMP

  • Required: YES

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

Enablers

  • Type: ARRAY

  • Required: NO

  • Description: Defines conditions or thresholds that activate or modify the scoring function, allowing for dynamic and context-sensitive scoring.

Parameters

  • Child_Questions.Questionnaire_Key

  • Type: INT64

  • Required: YES

  • Description: Identifier for the questionnaire to which the question belongs.

  • Child_Questions.Questionnaire_Question_Key

  • Type: INT64

  • Required: YES

  • Description: Unique identifier for the questionnaire question.

  • Child_Questions.Created_Timestamp

  • Type: TIMESTAMP

  • Required: YES

  • Description: Timestamp indicating when the record was created.

  • Child_Questions.Last_Modified_User_ID

  • Type: STRING

  • Required: YES

  • Description: User ID of the user who last modified the record.

  • Child_Questions.Last_Modified_Timestamp

  • Type: TIMESTAMP

  • Required: YES

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

Problems

  • Type: ARRAY

  • Required: YES

  • Description: A collection of problems associated with the selections.

Parameters

  • Key

  • Type: INT64

  • Required: YES

  • Description: A unique identifier for each problem within the selections.

  • Problem

  • Type: STRING

  • Required: YES

  • Description: The specific problem identified within the selection.

  • Problem_Description

  • Type: STRING

  • Required: YES

  • Description: A detailed description of the problem, providing more context and information.

  • Modified_User_ID

  • Type: STRING

  • Required: YES

  • Description: User ID of the user who last modified the record.

  • Created_Timestamp

  • Type: TIMESTAMP

  • Required: YES

  • Description: Timestamp indicating when the record was created.

  • Last_Modified_Timestamp

  • Type: TIMESTAMP

  • Required: YES

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

Versions

  • Type: ARRAY

  • Required: YES

  • Description: Version of the selection.

Parameters

  • Key

  • Type: INT64

  • Required: YES

  • Description: A unique identifier for each version of the selection.

  • Question_Version_Key

  • Type: INT64

  • Required: YES

  • Description: A unique identifier for the version of the question associated with the selection.

  • Position

  • Type: STRING

  • Required: YES

  • Description: The order or position of the version within the selection.

  • Value

  • Type: STRING

  • Required: YES

  • Description: The value assigned to the version of the selection.

  • Clarification_Indicator

  • Type: STRING

  • Required: YES

  • Description: An indicator specifying whether clarification is needed for the version.

Questionnaire Dataset Specification

Selections.Versions

Mutual_Exclusive

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates whether the version is mutually exclusive with other versions.

Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the user who last modified the record.

Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the record was created.

Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Questionnaire_Metadata_Question_Log

Versions

  • Is Nullable: NO

  • Data Type: ARRAY

  • Description: An array of different versions of the question, reflecting changes over time and supporting version control. See below for detailed information on each parameter in the array.

Questionnaire_Version_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Refers to a specific version of the questionnaire.

Questionnaire_Version_Number

  • Is Nullable: YES

  • Data Type: INT64

  • Description: The numerical version number assigned to the questionnaire.

Full_Question_Clinical

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Full clinical question text.

Questionnaire_Effective_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the questionnaire became effective.

Questionnaire_Termination_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the questionnaire is terminated.

Question_Report_Title

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Title used for reporting purposes related to the question.

Question_Display_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Display type for the question in the user interface.

Question_Response_Type_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the question response type. See Dictionary Response Type table in the Dictionary Dataset Specification.

Field_Length

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The length of the field for the version of the selection.

Input_Length

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The maximum length of input allowed for the version of the selection.

Maximum_Value

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The maximum value that can be assigned to the version of the selection.

Minimum_Value

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The minimum value that can be assigned to the version of the selection.

Selections_Allowed

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Indicates whether multiple selections are allowed for the version.

Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the user who last modified the record.

Version_Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the record was created.

Version_Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Record_Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp of the last modification to the record, ensuring the log reflects the latest changes.

Transaction_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID associated with the transaction in the log, linking changes to specific user actions.

Deleted_Indicator

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: A boolean indicating whether the question log record has been marked as deleted, important for data integrity and historical tracking.

Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The type or category of the log record, often used to differentiate between different kinds of log entries.

Tenant

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the tenant domain or administrative boundary to which the log record pertains, crucial in multi-tenant systems.

Active_Version

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates whether the log entry represents the currently active version of the question, important for understanding the question's lifecycle.

Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: The date associated with the log entry, often used for sorting and historical analysis.

Sequence

  • Is Nullable: YES

  • Data Type: INT64

  • Description: A sequence number for the log entry, helping to order entries chronologically or logically.

Source_System_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the source system from which the log data is derived, aiding in data lineage.

Source_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp from the source system, indicating when the data was generated or logged, providing a time-based context for the data.

Source_File_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name of the file from the source system, useful for tracking the origin of the data and for audit purposes.

Schema_Version

  • Is Nullable: YES

  • Data Type: FLOAT64

  • Description: Indicates the version of the data schema that the log entry adheres to, ensuring compatibility and consistency in data interpretation.

_updated

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A flag or timestamp indicating when the log entry was last updated, providing a mechanism for tracking changes over time.

Action

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Describes the action represented by the log entry, such as 'create', 'update', or 'delete', offering insights into the nature of the changes recorded.

Transaction_Actor_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of the actor performing the transaction.

Questionnaire_Metadata_Scoring_Function

Questionnaire_Function_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: A unique identifier for the scoring function within the questionnaire metadata, linking to specific scoring logic.

Questionnaire_Version_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Connects to a particular version of the questionnaire, ensuring that the scoring function applies to the correct set of questions and answers.

Section_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Identifies the section of the questionnaire that the scoring function is related to.

Questionnaire Dataset Specification

Questionnaire Metadata Scoring Function

Columns and Descriptions

  • Position

  • Is Nullable: YES

  • Data Type: INT64

  • Description: The order in which the scoring function appears within the questionnaire or section, dictating the sequence of scoring evaluations.

  • Member_Portal

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates whether the scoring function is accessible or relevant in the member-facing portal, enabling personalized scoring mechanisms.

  • Provider_Portal

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Shows if the scoring function is used in the provider-facing portal, facilitating provider-specific assessments.

  • Questionnaire_Function_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The ID of the user who last modified the scoring function, providing an audit trail for changes.

  • Questionnaire_Function_Modified_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name of the user who last modified the scoring function, providing an audit trail for changes.

  • Questionnaire_Function_Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp when the scoring function was first created, giving a historical context.

  • Questionnaire_Function_Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The last time the scoring function was updated, offering insights into the currency of the scoring logic.

  • Scoring_Function_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: A primary key for the scoring function record, ensuring unique identification within the log.

  • Class

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Represents the classification or category of the scoring function, aiding in grouping similar functions. See Dictionary Questionnaire Class table in the Dictionary Dataset Specification.

  • Class_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A textual description of the class, providing clarity on the function's purpose or category. See Dictionary Questionnaire Class table in the Dictionary Dataset Specification.

  • Formula

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The actual scoring formula or algorithm used, critical for understanding how scores are calculated.

  • Formula_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Explains the logic and methodology behind the scoring formula, offering detailed insight into its operational mechanics.

  • Function

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifies the specific scoring function or method being applied, linking to predefined scoring algorithms.

  • Format_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Describes the format or structure of the scoring output, ensuring compatibility with reporting and analysis tools.

  • Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Tracks the creation, modification, and the user responsible for these actions, essential for maintaining the integrity and history of the scoring function data.

  • Modified_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Tracks the creation, modification, and the user responsible for these actions, essential for maintaining the integrity and history of the scoring function data.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Tracks the creation, modification, and the user responsible for these actions, essential for maintaining the integrity and history of the scoring function data.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Tracks the creation, modification, and the user responsible for these actions, essential for maintaining the integrity and history of the scoring function data.

Questionnaire Metadata Scoring Function Child Questions

Columns and Descriptions

  • Scoring_Function_Child_Question_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for each child question within the scoring function.

  • Questionnaire_Function_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Identifier linking to the primary scoring function this child question is part of.

  • Questionnaire_Question_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Identifier for the specific question in the questionnaire.

  • Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: ID of the user who last modified the record.

  • Modified_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the user who last modified the record.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the record was initially created.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the record was last modified.

Questionnaire Metadata Scoring Function Enablers

Columns and Descriptions

  • Scoring_Function_Enabler_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for each scoring function enabler.

  • Questionnaire_Function_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Identifier linking to the primary scoring function this enabler is part of.

  • Minimum_Value

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Minimum value assigned to this scoring function enabler.

  • Maximum_Value

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Maximum value assigned to this scoring function enabler.

  • Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: ID of the user who last modified the record.

  • Modified_User_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the user who last modified the record.

Questionnaire Dataset Specification

Table: Questionnaire_Metadata_Scoring_Function_Enablers

Column Name

Is Nullable

Data Type

Description

Created_Timestamp

YES

TIMESTAMP

Timestamp when the record was initially created.

Last_Modified_Timestamp

YES

TIMESTAMP

Timestamp when the record was last modified.

Table: Questionnaire_Metadata_Scoring_Function_Enabler_Questions

Column Name

Is Nullable

Data Type

Description

Scoring_Function_Enabler_Question_Key

YES

INT64

Unique identifier for each enabler question within the scoring function.

Scoring_Function_Enabler_Key

YES

INT64

Identifier linking to the primary scoring function enabler this question is part of.

Questionnaire_Question_Key

YES

INT64

Identifier for the specific question in the questionnaire.

Modified_User_ID

YES

STRING

ID of the user who last modified the record.

Modified_User_Name

YES

STRING

Name of the user who last modified the record.

Created_Timestamp

YES

TIMESTAMP

Timestamp when the record was initially created.

Last_Modified_Timestamp

YES

TIMESTAMP

Timestamp when the record was last modified.

Table: Questionnaire_Metadata_Scoring_Function_Inputs

Column Name

Is Nullable

Data Type

Description

Scoring_Function_Input_Key

YES

INT64

Unique identifier for each input used in the scoring function.

Questionnaire_Function_Key

YES

INT64

Identifier linking to the main scoring function to which this input belongs.

Questionnaire_Question_Key

YES

STRING

Identifier for the specific question in the questionnaire associated with this input.

Required

YES

STRING

Indicates if the input is mandatory for the scoring function (Yes/No).

Required_Once

YES

STRING

Indicates if the input is required only once during the scoring process (Yes/No).

Parameter_Name

YES

STRING

Name of the parameter that describes the input.

Modified_User_ID

YES

TIMESTAMP

ID of the user who last modified this record.

Modified_User_Name

YES

TIMESTAMP

Name of the user who last modified this record.

Created_Timestamp

YES

TIMESTAMP

Timestamp indicating when the record was initially created.

Last_Modified_Timestamp

YES

TIMESTAMP

Timestamp indicating when the record was last modified.

Table: Questionnaire_Metadata_Scoring_Function_Versions

Column Name

Is Nullable

Data Type

Description

Scoring_Function_Version_Key

YES

INT64

Unique identifier for each version of the scoring function.

Scoring_Function_Key

YES

INT64

Identifier linking to the primary scoring function.

Version_Number

YES

INT64

Version number of the scoring function.

Score_Description

YES

STRING

Description of the score for this version.

Report_Title

YES

STRING

Title of the report associated with this scoring function version.

Effective_Timestamp

YES

TIMESTAMP

Timestamp when this version of the scoring function became effective.

Effective_Date

YES

DATE

Date when this version of the scoring function became effective.

Termination_Timestamp

YES

TIMESTAMP

Timestamp when this version of the scoring function was terminated or replaced.

Termination_Date

YES

DATE

Date when this version of the scoring function was terminated or replaced.

Modified_User_ID

YES

STRING

ID of the user who last modified this version record.

Modified_User_Name

YES

STRING

Name of the user who last modified this version record.

Created_Timestamp

YES

TIMESTAMP

Timestamp indicating when this version record was initially created.

Last_Modified_Timestamp

YES

TIMESTAMP

Timestamp indicating when this version record was last modified.

Table: Questionnaire_Metadata_Scoring_Function_Log

Column Name

Is Nullable

Data Type

Description

Questionnaire_Function_Key

YES

INT64

A unique identifier for the scoring function within the questionnaire metadata, linking to specific scoring logic.

Questionnaire_Version_Key

YES

INT64

Connects to a particular version of the questionnaire, ensuring that the scoring function applies to the correct set of questions and answers.

Section_Key

YES

INT64

Identifies the section of the questionnaire that the scoring function is related to, helping to categorize and organize.

Questionnaire Dataset Specification

Questionnaire Metadata Scoring Function Log

Position

  • Type: INT64

  • Required: YES

  • Description: The order in which the scoring function appears within the questionnaire or section, dictating the sequence of scoring evaluations.

Member Portal

  • Type: BOOL

  • Required: YES

  • Description: Indicates whether the scoring function is accessible or relevant in the member-facing portal, enabling personalized scoring mechanisms.

Provider Portal

  • Type: BOOL

  • Required: YES

  • Description: Shows if the scoring function is used in the provider-facing portal, facilitating provider-specific assessments.

Questionnaire Function Modified User ID

  • Type: STRING

  • Required: YES

  • Description: The ID of the user who last modified the scoring function, providing an audit trail for changes.

Questionnaire Function Created Timestamp

  • Type: TIMESTAMP

  • Required: YES

  • Description: The timestamp when the scoring function was first created, giving a historical context.

Questionnaire Function Last Modified Timestamp

  • Type: TIMESTAMP

  • Required: YES

  • Description: The last time the scoring function was updated, offering insights into the currency of the scoring logic.

Key

  • Type: INT64

  • Required: YES

  • Description: A primary key for the scoring function log record, ensuring unique identification within the log.

Class

  • Type: STRING

  • Required: YES

  • Description: Represents the classification or category of the scoring function, aiding in grouping similar functions. See Dictionary Questionnaire Class table in the Dictionary Dataset Specification.

Class Description

  • Type: STRING

  • Required: YES

  • Description: A textual description of the class, providing clarity on the function's purpose or category. See Dictionary Questionnaire Class table in the Dictionary Dataset Specification.

Formula

  • Type: STRING

  • Required: YES

  • Description: The actual scoring formula or algorithm used, critical for understanding how scores are calculated.

Formula Description

  • Type: STRING

  • Required: YES

  • Description: Explains the logic and methodology behind the scoring formula, offering detailed insight into its operational mechanics.

Function

  • Type: STRING

  • Required: YES

  • Description: Identifies the specific scoring function or method being applied, linking to predefined scoring algorithms.

Format Type

  • Type: STRING

  • Required: YES

  • Description: Describes the format or structure of the scoring output, ensuring compatibility with reporting and analysis tools.

Modified User ID

  • Type: STRING

  • Required: YES

  • Description: Tracks the creation, modification, and the user responsible for these actions, essential for maintaining the integrity and history of the scoring function data.

Created Timestamp

  • Type: TIMESTAMP

  • Required: YES

  • Description: Tracks the creation, modification, and the user responsible for these actions, essential for maintaining the integrity and history of the scoring function data.

Last Modified Timestamp

  • Type: TIMESTAMP

  • Required: YES

  • Description: Tracks the creation, modification, and the user responsible for these actions, essential for maintaining the integrity and history of the scoring function data.

Inputs

  • Type: ARRAY

  • Required: NO

  • Description: A collection of inputs or variables used in the scoring function, detailing the data elements that influence the scoring outcome. See below for detailed information on each parameter in the array.

Inputs.Questionnaire Key

  • Type: INT64

  • Required: YES

  • Description: Identifier for the questionnaire to which the question belongs.

Inputs.Questionnaire Question Key

  • Type: INT64

  • Required: YES

  • Description: Unique identifier for the questionnaire question.

Inputs.Required

  • Type: STRING

  • Required: YES

  • Description: Indicates whether the input is mandatory for the process or form.

Inputs.Required Once

  • Type: STRING

  • Required: YES

  • Description: Specifies if the input is required only once during the process or form submission.

Inputs.Parameter Name

  • Type: STRING

  • Required: YES

  • Description: The name of the parameter for the input, used for identification and reference purposes.

Inputs.Modified User ID

  • Type: STRING

  • Required: YES

  • Description: User ID of the user who last modified the record.

Inputs.Created Timestamp

  • Type: TIMESTAMP

  • Required: YES

  • Description: Timestamp indicating when the record was created.

Inputs.Last Modified Timestamp

  • Type: TIMESTAMP

  • Required: YES

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

Child Questions

  • Type: ARRAY

  • Required: NO

  • Description: Lists sub-questions or dependent questions that are part of the scoring mechanism, showing the hierarchical structure of questionnaire logic. See below for detailed information on each parameter in the array.

Child Questions.Questionnaire Key

  • Type: INT64

  • Required: YES

  • Description: Identifier for the questionnaire to which the question belongs.

Child Questions.Questionnaire Question Key

  • Type: INT64

  • Required: YES

  • Description: Unique identifier for the questionnaire question.

Child Questions.Modified User ID

  • Type: STRING

  • Required: YES

  • Description: User ID of the user who last modified the record.

Child Questions.Created Timestamp

  • Type: TIMESTAMP

  • Required: YES

  • Description: Timestamp indicating when the record was created.

Child Questions.Last Modified Timestamp

  • Type: TIMESTAMP

  • Required: YES

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

Enablers

  • Type: ARRAY

  • Required: NO

  • Description: Defines conditions or thresholds that activate or modify the scoring function, allowing for dynamic and context-sensitive scoring. See below for detailed information on each parameter in the array.

Enablers.Key

  • Type: INT64

  • Required: YES

  • Description: A unique identifier for each enabler.

Enablers.Minimum Value

  • Type: STRING

  • Required: YES

  • Description: The minimum value required for the enabler to be active or valid.

Enablers.Maximum Value

  • Type: STRING

  • Required: YES

  • Description: The maximum value allowed for the enabler to be active.

Questionnaire Dataset Specification

Enablers

General Fields

  • Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the user who last modified the record.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the record was created.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Questions

  • Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the user who last modified the record.

  • Questionnaire_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Identifier for the questionnaire to which the question belongs.

  • Questionnaire_Question_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for the questionnaire question.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the record was created.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Questionnaire Metadata Scoring Function Log

Versions

  • Scoring_Function_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Refers to a specific scoring function used to calculate scores based on questionnaire responses.

  • Scoring_Function_Version_Number

  • Is Nullable: YES

  • Data Type: INT64

  • Description: The version number associated with the scoring function.

  • Scoring_Function_Score_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Describes the meaning or interpretation of the scores generated by the scoring function.

  • Scoring_Function_Report_Title

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The title assigned to the report or summary that includes the member’s scores.

  • Questionnaire_Effective_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date when the questionnaire becomes effective or applicable.

  • Questionnaire_Termination_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The date when the questionnaire is no longer valid or applicable.

  • Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: User ID of the user who last modified the record.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the record was created.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

General Fields

  • Record_Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Indicates the last time any part of the record was updated, providing a timestamp for the most recent change.

  • Transaction_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifies the user who made the last transaction or modification to the scoring function, aiding in audit and accountability.

  • Deleted_Indicator

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: A boolean value indicating whether the scoring function has been marked as deleted, helping to manage the lifecycle and visibility of the scoring functions within the system.

  • Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Categorizes the scoring function log entry, perhaps differentiating between different types of scoring activities or methodologies used in the questionnaire.

  • Tenant

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Represents the tenant or domain within which the scoring function is used, allowing for multi-tenant segmentation and management of scoring functions.

  • Active_Version

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: A boolean flag indicating whether the version of the scoring function being logged is the active or currently used version, important for identifying the relevant scoring logic in use at any given time.

  • Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: The date associated with the log entry, possibly indicating when the scoring function was applied or assessed.

  • Sequence

  • Is Nullable: YES

  • Data Type: INT64

  • Description: A numerical order or sequence number that may indicate the position or precedence of the scoring function within a set or process.

  • Source_System_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name of the system from which the scoring function log entry originated, useful for tracing the source of data and understanding the system landscape.

  • Source_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: The timestamp from the source system, indicating when the log entry or the scoring function action was originally recorded or initiated.

  • Source_File_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The name of the file or dataset from the source system, providing a reference to the original data or configuration used for the scoring function.

  • Schema_Version

  • Is Nullable: YES

  • Data Type: FLOAT64

  • Description: Indicates the version of the data schema used for the scoring function log, ensuring compatibility and understanding of the data structure.

  • _updated

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A string or timestamp indicating when the log entry was last updated, providing a temporal reference for data changes or updates.

  • Action

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Describes the action taken in the log entry, such as creating, updating, or deleting a scoring function, giving context to the nature of the log record.

  • Transaction_Actor_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of the actor performing the transaction.

Questionnaire Metadata Raw

General Fields

  • Questionnaire_Version_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for a specific version of a questionnaire.

  • Version_Number

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Numeric value representing the version number of the questionnaire.

Questionnaire Dataset Specification

Questionnaire Metadata

Fields

  • Version_Number

  • Type: STRING

  • Required: YES

  • Description: The version number of the questionnaire.

  • Title

  • Type: STRING

  • Required: YES

  • Description: Descriptive title or name of the questionnaire.

  • Effective_Timestamp

  • Type: TIMESTAMP

  • Required: YES

  • Description: Timestamp indicating when the questionnaire version becomes effective.

  • Termination_Timestamp

  • Type: TIMESTAMP

  • Required: YES

  • Description: Timestamp indicating when the questionnaire version is terminated or no longer valid.

  • Version_Modified_User_ID

  • Type: STRING

  • Required: YES

  • Description: Identifier for the user who last modified the questionnaire version.

  • Version_Created_Timestamp

  • Type: TIMESTAMP

  • Required: YES

  • Description: Timestamp indicating when the questionnaire version was initially created.

  • Version_Last_Modified_Timestamp

  • Type: TIMESTAMP

  • Required: YES

  • Description: Timestamp indicating the most recent modification time for the questionnaire version.

  • Questionnaire_Key

  • Type: INT64

  • Required: YES

  • Description: Unique identifier for the entire questionnaire.

  • Questionnaire_Code

  • Type: STRING

  • Required: YES

  • Description: Code or short identifier associated with the questionnaire.

  • Class

  • Type: STRING

  • Required: YES

  • Description: Classification or category of the questionnaire (e.g., medical history, lifestyle assessment).

    • See Dictionary Questionnaire Class table in the Dictionary Dataset Specification.

  • Class_Description

  • Type: STRING

  • Required: YES

  • Description: Additional details or context about the specified questionnaire class.

    • See Dictionary Questionnaire Class table in the Dictionary Dataset Specification.

  • Help

  • Type: STRING

  • Required: YES

  • Description: Information or guidance related to the questionnaire.

  • Position

  • Type: INT64

  • Required: YES

  • Description: Indicates the position or order of the questionnaire within a set or sequence.

  • Active_Timestamp

  • Type: TIMESTAMP

  • Required: YES

  • Description: Timestamp indicating when the questionnaire version becomes active or usable.

  • Inactive_Timestamp

  • Type: TIMESTAMP

  • Required: YES

  • Description: Timestamp indicating when the questionnaire version is no longer active or valid.

  • Dashboard_Indicator

  • Type: BOOL

  • Required: YES

  • Description: Boolean indicator specifying whether the questionnaire appears on a dashboard or summary view.

  • All_Roles_Indicator

  • Type: BOOL

  • Required: YES

  • Description: Boolean indicator specifying whether the questionnaire is accessible to all user roles.

  • All_Customer_Categories_Indicator

  • Type: BOOL

  • Required: YES

  • Description: Boolean indicator specifying whether the questionnaire is applicable to all customer categories.

  • Modified_User_ID

  • Type: STRING

  • Required: YES

  • Description: Identifier for the user who last modified the questionnaire.

Customer Categories

  • Customer_Categories

  • Type: ARRAY

  • Required: NO

  • Description: Categories or groups of customers to whom the questionnaire applies.

Fields

  • Key

  • Description: Unique identifier for the customer category.

  • Code

  • Description: Code representing the customer category.

  • Questionnaire_Effective_Timestamp

  • Type: TIMESTAMP

  • Required: YES

  • Description: The date when the questionnaire becomes effective or applicable.

  • Questionnaire_Termination_Timestamp

  • Type: TIMESTAMP

  • Required: YES

  • Description: The date when the questionnaire is no longer valid or applicable.

  • Modified_User_ID

  • Type: STRING

  • Required: YES

  • Description: User ID of the user who last modified the record.

  • Created_Timestamp

  • Type: TIMESTAMP

  • Required: YES

  • Description: Timestamp indicating when the record was created.

  • Last_Modified_Timestamp

  • Type: TIMESTAMP

  • Required: YES

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

Programs

  • Programs

  • Type: ARRAY

  • Required: NO

  • Description: An array of programs associated with the questionnaire, defining its application or relevance in various programmatic contexts.

Fields

  • Key

  • Type: INT64

  • Required: YES

  • Description: A unique identifier for each program.

  • Program

  • Type: STRING

  • Required: YES

  • Description: The name or title of the program.

  • Program_Description

  • Type: STRING

  • Required: YES

  • Description: A detailed description of the program, outlining its purpose and scope.

  • Primary

  • Type: STRING

  • Required: YES

  • Description: Indicates whether the program is the primary or main program among multiple programs.

  • Effective_Timestamp

  • Type: TIMESTAMP

  • Required: YES

  • Description: The date when the questionnaire becomes effective or applicable.

  • Termination_Timestamp

  • Type: TIMESTAMP

  • Required: YES

  • Description: The date when the questionnaire is no longer valid or applicable.

  • Modified_User_ID

  • Type: STRING

  • Required: YES

  • Description: User ID of the user who last modified the record.

  • Created_Timestamp

  • Type: TIMESTAMP

  • Required: YES

  • Description: Timestamp indicating when the record was created.

  • Last_Modified_Timestamp

  • Type: TIMESTAMP

  • Required: YES

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

Roles

  • Roles

  • Type: ARRAY

  • Required: NO

  • Description: An array defining the roles for which the questionnaire is intended, ensuring appropriate targeting and use.

Fields

  • Program_Provider_Roles_Key

  • Type: INT64

  • Required: YES

  • Description: Unique identifier for the program provider roles entry.

  • Role_Code

  • Type: STRING

  • Required: YES

  • Description: Code representing the role of the provider within the program.

  • Role_Description

  • Type: STRING

  • Required: YES

  • Description: Description of the role of the provider within the program.

  • Role_Effective_Date

  • Type: DATE

  • Required: YES

  • Description: Effective date of the provider's role within the program.

  • Role_Termination_Date

  • Type: DATE

  • Required: YES

  • Description: Termination date of the provider's role within the program, if applicable.

  • Role_Created_Timestamp

  • Type: TIMESTAMP

  • Required: YES

  • Description: Timestamp indicating when the provider's role entry was created.

  • Role_Last_Modified_Timestamp

  • Type: TIMESTAMP

  • Required: YES

  • Description: Timestamp indicating when the provider's role entry was last modified.

Sections

  • Sections

  • Type: ARRAY

  • Required: NO

  • Description: An array detailing the different sections of the questionnaire, aiding in structuring and organizing the content.

Questionnaire Dataset Specification

Sections

Parameters in the Array

  • Sections.Key

  • Is Nullable: YES

  • Data Type: STRING

  • Description: A unique identifier for each section within the questionnaire.

  • Sections.Title

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The title or name of the section, providing a brief overview of its content.

  • Sections.Position

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The order or position of the section within the questionnaire.

  • Sections.Help_Text

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Additional information or instructions to assist users in understanding the section.

  • Sections.Modified_User_ID

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

  • Sections.Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the record was created.

  • Sections.Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Questionnaire Metadata

Metadata Fields

  • Record_Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating the most recent modification time for any record related to the questionnaire.

  • Transaction_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the user associated with a specific transaction related to the questionnaire.

  • Deleted_Indicator

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Boolean indicator specifying whether the questionnaire version is deleted or archived.

  • Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type or category of the questionnaire (e.g., assessment, survey).

  • Tenant

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the specific tenant or organization associated with the questionnaire.

  • Active_Version

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicates the currently active version of the questionnaire.

  • Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: Date associated with the questionnaire (e.g., creation date, effective date).

  • Sequence

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Numeric order or sequence of the questionnaire within a larger process or workflow.

  • Source_System_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the system or source from which the questionnaire data originates.

  • Source_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the questionnaire data was sourced or imported.

  • Source_File_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the file or data source containing the questionnaire information.

  • Schema_Version

  • Is Nullable: YES

  • Data Type: FLOAT64

  • Description: Version of the data schema or structure used for the questionnaire.

  • _updated

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Internal field indicating the last update time for the questionnaire record.

  • Transaction_Actor_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of the actor performing the transaction.

Questionnaire Metadata Scoring Function

Scoring Function Fields

  • Questionnaire_Function_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for a specific function associated with a questionnaire.

  • Questionnaire_Version_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Identifier linking the function to a specific version of the questionnaire.

  • Section_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for a section within the questionnaire.

  • Position

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Indicates the position or order of the function within a section.

  • Member_Portal

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Boolean indicator specifying whether the function is accessible via the member portal.

  • Provider_Portal

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Boolean indicator specifying whether the function is accessible via the provider portal.

  • Questionnaire_Function_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the user who last modified the function.

  • Questionnaire_Function_Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the function was initially created.

  • Questionnaire_Function_Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating the most recent modification time for the function.

  • Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Additional identifier or key associated with the function.

  • Class

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Classification or category of the function (e.g., scoring, calculation). See Dictionary Questionnaire Class table in the Dictionary Dataset Specification.

  • Class_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Provides additional context or details about the specified function class. See Dictionary Questionnaire Class table in the Dictionary Dataset Specification.

  • Formula

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Mathematical or logical formula used by the function.

  • Formula_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Elaborates on the purpose or interpretation of the specified formula.

  • Function

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Describes the specific purpose or operation performed by the function.

  • Format_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Specifies the data format or type expected for the function output.

  • Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Identifier for the user who last modified the function.

  • Inputs

  • Is Nullable: NO

  • Data Type: ARRAY

  • Description: A collection of inputs or variables used in the scoring function, detailing the data elements that influence the scoring outcome. See below for detailed information on each parameter in the Array.

Inputs Parameters

  • Inputs.Questionnaire_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Identifier for the questionnaire associated with the input.

Questionnaire Dataset Specification

Inputs

Questionnaire_Key

  • Required: YES

  • Type: INT64

  • Description: Identifier for the questionnaire to which the question belongs.

Questionnaire_Question_Key

  • Required: YES

  • Type: INT64

  • Description: Unique identifier for the questionnaire question.

Required

  • Required: YES

  • Type: STRING

  • Description: Indicates whether the input is mandatory for the process or form.

Required_Once

  • Required: YES

  • Type: STRING

  • Description: Specifies if the input is required only once during the process or form submission.

Parameter_Name

  • Required: YES

  • Type: STRING

  • Description: The name of the parameter for the input, used for identification and reference purposes.

Modified_User_ID

  • Required: YES

  • Type: STRING

  • Description: User ID of the user who last modified the record.

Created_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp indicating when the record was created.

Last_Modified_Timestamp

  • Required: YES

  • Type: TIMESTAMP

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

Questionnaire_Metadata_Scoring_Function_raw

Child_Questions

  • Required: NO

  • Type: ARRAY

  • Description: Lists sub-questions or dependent questions that are part of the scoring mechanism, showing the hierarchical structure of questionnaire logic.

Parameters in Child_Questions Array:

  • Questionnaire_Key:

  • Required: YES

  • Type: INT64

  • Description: Identifier for the questionnaire to which the question belongs.

  • Questionnaire_Question_Key:

  • Required: YES

  • Type: INT64

  • Description: Unique identifier for the questionnaire question.

  • Modified_User_ID:

  • Required: YES

  • Type: STRING

  • Description: User ID of the user who last modified the record.

  • Created_Timestamp:

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp indicating when the record was created.

  • Last_Modified_Timestamp:

  • Required: YES

  • Type: TIMESTAMP

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

Enablers

  • Required: NO

  • Type: ARRAY

  • Description: Defines conditions or thresholds that activate or modify the scoring function, allowing for dynamic and context-sensitive scoring.

Parameters in Enablers Array:

  • Key:

  • Required: YES

  • Type: INT64

  • Description: A unique identifier for each enabler.

  • Minimum_Value:

  • Required: YES

  • Type: STRING

  • Description: The minimum value required for the enabler to be active or valid.

  • Maximum_Value:

  • Required: YES

  • Type: STRING

  • Description: The maximum value allowed for the enabler to be active or valid.

  • Modified_User_ID:

  • Required: YES

  • Type: STRING

  • Description: User ID of the user who last modified the record.

  • Created_Timestamp:

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp indicating when the record was created.

  • Last_Modified_Timestamp:

  • Required: YES

  • Type: TIMESTAMP

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

Questions in Enablers Array:

  • Questionnaire_Key:

  • Required: YES

  • Type: INT64

  • Description: Identifier for the questionnaire to which the question belongs.

  • Questionnaire_Question_Key:

  • Required: YES

  • Type: INT64

  • Description: Unique identifier for the questionnaire question.

  • Modified_User_ID:

  • Required: YES

  • Type: STRING

  • Description: User ID of the user who last modified the record.

  • Created_Timestamp:

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp indicating when the record was created.

  • Last_Modified_Timestamp:

  • Required: YES

  • Type: TIMESTAMP

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

Versions

  • Required: NO

  • Type: ARRAY

  • Description: Tracks different iterations or versions of the scoring function, accommodating updates and changes over time.

Parameters in Versions Array:

  • Scoring_Function_Key:

  • Required: YES

  • Type: INT64

  • Description: Refers to a specific scoring function used to calculate scores based on questionnaire responses.

  • Scoring_Function_Version_Number:

  • Required: YES

  • Type: INT64

  • Description: The version number associated with the scoring function.

  • Scoring_Function_Score_Description:

  • Required: YES

  • Type: STRING

  • Description: Describes the meaning or interpretation of the scores generated by the scoring function.

  • Scoring_Function_Report_Title:

  • Required: YES

  • Type: STRING

  • Description: The title assigned to the report or summary that includes the member’s scores.

  • Questionnaire_Effective_Timestamp:

  • Required: YES

  • Type: TIMESTAMP

  • Description: The date when the questionnaire becomes effective or applicable.

  • Questionnaire_Termination_Timestamp:

  • Required: YES

  • Type: TIMESTAMP

  • Description: The date when the questionnaire is no longer valid or applicable.

  • Modified_User_ID:

  • Required: YES

  • Type: STRING

  • Description: User ID of the user who last modified the record.

  • Created_Timestamp:

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp indicating when the record was created.

  • Last_Modified_Timestamp:

  • Required: YES

  • Type: TIMESTAMP

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

Record_Last_Modified_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp indicating the most recent modification time for any record related to the function.

Transaction_User_ID

  • Required: YES

  • Type: STRING

  • Description: Identifier for the user associated with a specific transaction related to the function.

Deleted_Indicator

  • Required: YES

  • Type: BOOL

  • Description: Boolean indicator specifying whether the function is deleted or archived.

Type

  • Required: YES

  • Type: STRING

  • Description: Specifies the type or category of the function (e.g., scoring, validation).

Tenant

  • Required: YES

  • Type: STRING

  • Description: Identifier for the specific tenant or organization associated with the function.

Active_Version

  • Required: YES

  • Type: BOOL

  • Description: Indicates the currently active version of the function.

Date

  • Required: YES

  • Type: DATE

  • Description: Date associated with the function (e.g., creation date, effective date).

Sequence

  • Required: YES

  • Type: INT64

  • Description: Numeric order or sequence of the function within a larger process or workflow.

Source_System_Name

  • Required: YES

  • Type: STRING

  • Description: Name of the system or source associated with the function.

Questionnaire Dataset Specification

Questionnaire Metadata Scoring Function

Table Content

Table Name

Column Name

Is Nullable

Data Type

Description

Questionnaire_Metadata_Scoring_Function_raw

Source_Timestamp

YES

TIMESTAMP

Timestamp indicating when the function data was sourced or imported.

Questionnaire_Metadata_Scoring_Function_raw

Source_File_Name

YES

STRING

Name of the file or data source containing the function information.

Questionnaire_Metadata_Scoring_Function_raw

Schema_Version

YES

FLOAT64

Version of the data schema or structure used for the function.

Questionnaire_Metadata_Scoring_Function_raw

_updated

YES

STRING

Internal field indicating the last update time for the function record.

Questionnaire_Metadata_Scoring_Function_raw

Transaction_Actor_Type

YES

STRING

Type of the actor performing the transaction.

Questionnaire Raw Data

Table Content

Table Name

Column Name

Is Nullable

Data Type

Description

Questionnaire_raw

Member_ID

YES

STRING

A unique identifier for each individual or member participating in the questionnaire.

Questionnaire_raw

Questionnaire_Response_Key

YES

INT64

A key or identifier associated with a specific response or submission within the questionnaire.

Questionnaire_raw

Class

YES

STRING

Represents a classification or category associated with the member (e.g., patient class, risk group, etc.). See Dictionary Questionnaire Class table in the Dictionary Dataset Specification.

Questionnaire_raw

Class_Description

YES

STRING

A textual description corresponding to the specific class or category assigned to the member. See Dictionary Questionnaire Class table in the Dictionary Dataset Specification.

Questionnaire_raw

Response_Note

YES

STRING

Additional notes or comments related to the questionnaire response.

Questionnaire_raw

Complete_Indicator

YES

BOOL

Indicates whether the questionnaire response is complete or partially filled out.

Questionnaire_raw

Source

YES

STRING

The origin or channel through which the questionnaire data was collected (e.g., web form, paper survey).

Questionnaire_raw

Source_Description

YES

STRING

Describes the source or method used to collect the questionnaire data.

Questionnaire_raw

Source_Entry_Timestamp

YES

TIMESTAMP

The date and time when the questionnaire response was entered or recorded.

Questionnaire_raw

Completed_By_Auto_Close

YES

BOOL

Indicates whether the completion of the questionnaire was automatically triggered (e.g., timed out).

Questionnaire_raw

Modified_User_ID

YES

STRING

Identifies the user who last modified the questionnaire response.

Questionnaire_raw

Created_Timestamp

YES

TIMESTAMP

The date and time when the questionnaire response was initially created.

Questionnaire_raw

Last_Modified_Timestamp

YES

TIMESTAMP

The most recent date and time when the questionnaire response was modified.

Questionnaire_raw

Questionnaire

YES

STRUCT

Refers to the specific questionnaire administered to the member. See below for detailed information on each parameter in the Structure.

Questionnaire Structure

Column Name

Is Nullable

Data Type

Description

Questionnaire.Questionnaire_Key

YES

INT64

Identifies the specific questionnaire administered to the member.

Questionnaire.Questionnaire_Version_Key

YES

INT64

Refers to a specific version of the questionnaire.

Questionnaire.Questionnaire_Version_Number

YES

INT64

The numerical version number assigned to the questionnaire.

Questionnaire.Questionnaire_Title

YES

STRING

The title or name of the questionnaire used for assessment.

Questionnaire.Questionnaire_Code

YES

STRING

A code or identifier associated with the questionnaire.

Questionnaire.Dashboard_Indicator

YES

BOOL

Indicates whether the member’s scores are displayed on a dashboard or summary view.

Questionnaire.Questionnaire_Effective_Timestamp

YES

TIMESTAMP

The date when the questionnaire becomes effective or applicable.

Questionnaire.Questionnaire_Termination_Timestamp

YES

TIMESTAMP

The date when the questionnaire is no longer valid or applicable.

Questionnaire.Questionnaire_Modified_User_ID

YES

STRING

Identifies the user who last modified the questionnaire details.

Questionnaire.Questionnaire_Modified_User_Name

YES

STRING

The name of the user who last modified the questionnaire details.

Questionnaire.Questionnaire_Version_Created_Timestamp

YES

TIMESTAMP

The date and time when the specific questionnaire version was created.

Questionnaire.Questionnaire_Version_Last_Modified_Timestamp

YES

TIMESTAMP

The most recent date and time when the questionnaire version was modified.

Score Responses

Table Content

Column Name

Is Nullable

Data Type

Description

Score_Responses.Score_Response_Key

YES

INT64

A key or identifier associated with a specific score response within the questionnaire.

Score_Responses.Calculated_Score

YES

NUMERIC

The computed score based on questionnaire responses and scoring functions.

Score_Responses.Score_Response_Void_Indicator

YES

BOOL

Indicates whether the score response has been voided or invalidated.

Score_Responses.Score_Response_Void_Timestamp

YES

TIMESTAMP

The date and time when the score response was voided.

Score_Responses.Score_Response_Void_User_ID

YES

STRING

Identifies the user who voided the score response.

Score_Responses.Score_Response_Void_User_Name

YES

STRING

The name of the user who voided the score response.

Score_Responses.Score_Response_Void_Reason

YES

STRING

The reason or explanation for voiding the score response.

Score_Responses.Score_Response_Void_Reason_Description

YES

STRING

Provides a detailed description of the void reason.

Score_Responses.Score_Response_Modified_User_ID

YES

STRING

Identifies the user who last modified the score response.

Questionnaire Dataset Specification

Score Responses

Score_Response_Modified_User_Name

  • Required: YES

  • Type: STRING

  • Description: The name of the user who last modified the score response.

Score_Response_Created_Timestamp

  • Required: YES

  • Type: TIMESTAMP

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

Score_Response_Last_Modified_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: The most recent date and time when the score response was modified.

Scoring_Function

  • Required: NO

  • Type: STRUCT

Scoring_Function_Key

  • Required: YES

  • Type: INT64

  • Description: Refers to a specific scoring function used to calculate scores based on questionnaire responses.

Scoring_Function_Version_Number

  • Required: YES

  • Type: INT64

  • Description: The version number associated with the scoring function.

Scoring_Function_Score_Description

  • Required: YES

  • Type: STRING

  • Description: Describes the meaning or interpretation of the scores generated by the scoring function.

Scoring_Function_Report_Title

  • Required: YES

  • Type: STRING

  • Description: The title assigned to the report or summary that includes the member’s scores.

Scoring_Function_Version_Key

  • Required: YES

  • Type: INT64

  • Description: Refers to a specific version of the scoring function.

Scoring_Function_Formula

  • Required: YES

  • Type: STRING

  • Description: Specifies the mathematical formula or algorithm used to compute scores.

Scoring_Function_Formula_Description

  • Required: YES

  • Type: STRING

  • Description: Provides a detailed explanation of the mathematical formula or algorithm used to compute scores.

Scoring_Function

  • Required: YES

  • Type: STRING

  • Description: Indicates the type of scoring method employed (e.g., Likert scale, weighted scoring, etc.).

Scoring_Function_Format_Type

  • Required: YES

  • Type: STRING

  • Description: Describes the format of the scores (e.g., numeric, categorical, etc.).

Scoring_Function_Effective_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: The date when the specific scoring function becomes effective or applicable.

Scoring_Function_Termination_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: The date when the specific scoring function is no longer valid or applicable.

Scoring_Function_Modified_User_ID

  • Required: YES

  • Type: STRING

  • Description: Identifies the user who last modified the details of the scoring function.

Scoring_Function_Modified_User_Name

  • Required: YES

  • Type: STRING

  • Description: The name of the user who last modified the details of the scoring function.

Scoring_Function_Version_Created_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: The date and time when a specific version of the scoring function was created.

Questionnaire Raw

Question_Responses

  • Required: NO

  • Type: ARRAY

  • Description: Represents the individual responses to specific questions within the questionnaire.

Question_Response_Key

  • Required: YES

  • Type: INT64

  • Description: Identifier for the question response.

Question_Response_Scoring_Weight

  • Required: YES

  • Type: NUMERIC

  • Description: Weight or score assigned to the question response.

Question_Response_Modified_User_ID

  • Required: YES

  • Type: STRING

  • Description: ID of the user who modified the question response.

Question_Response_Modified_User_Name

  • Required: YES

  • Type: STRING

  • Description: Name of the user who modified the question response.

Question

  • Required: NO

  • Type: ARRAY

Question_Position

  • Required: YES

  • Type: INT64

  • Description: Position of the question in the questionnaire.

Question_Key

  • Required: YES

  • Type: INT64

  • Description: Identifier for the question.

Question_Version_Key

  • Required: YES

  • Type: INT64

  • Description: Identifier for the version of the question.

Question_Version_Number

  • Required: YES

  • Type: INT64

  • Description: Version number of the question.

Full_Question_Clinical

  • Required: YES

  • Type: STRING

  • Description: Full clinical question text.

Short_Question

  • Required: YES

  • Type: STRING

  • Description: Abbreviated or shortened version of the question.

Question_Report_Title

  • Required: YES

  • Type: STRING

  • Description: Title used for reporting purposes related to the question.

Question_Code

  • Required: YES

  • Type: STRING

  • Description: Code associated with the question.

Question_Response_Type

  • Required: YES

  • Type: STRING

  • Description: Type of response expected for the question. See Dictionary Response Type table in the Dictionary Dataset Specification.

Question_Display_Type

  • Required: YES

  • Type: STRING

  • Description: Display type for the question in the user interface.

Question_Response_Type_Description

  • Required: YES

  • Type: STRING

  • Description: Description of the question response type. See Dictionary Response Type table in the Dictionary Dataset Specification.

Question_Response_Value_Type

  • Required: YES

  • Type: STRING

  • Description: Data type of the response value. See Dictionary Response Value Type table in the Dictionary Dataset Specification.

Question_Response_Value_Type_Description

  • Required: YES

  • Type: STRING

  • Description: Description of the data type of the response value. See Dictionary Response Value Type table in the Dictionary Dataset Specification.

Question_Effective_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp when the question became effective.

Question_Termination_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp when the question is terminated.

Question_Modified_User_ID

  • Required: YES

  • Type: STRING

  • Description: ID of the user who modified the question.

Question_Modified_User_Name

  • Required: YES

  • Type: STRING

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

Question_Version_Created_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp when the version of the question was created.

Question_Version_Last_Modified_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp when the version of the question was last modified.

Questionnaire Dataset Specification

Question Responses

Question Response Timestamps

  • Question_Response_Created_Timestamp

  • Data Type: TIMESTAMP

  • Description: Timestamp when the question response was created.

  • Question_Response_Last_Modified_Timestamp

  • Data Type: TIMESTAMP

  • Description: Timestamp of the last modification to the question response.

Response Details

  • Response_Detail_Key

  • Data Type: INT64

  • Description: Identifier for the response detail.

  • Response_Value_Text

  • Data Type: STRING

  • Description: Textual value of the response.

  • Response_Value_Date

  • Data Type: DATE

  • Description: Date value of the response.

  • Response_Value_Number

  • Data Type: NUMERIC

  • Description: Numeric value of the response.

  • Response_Value_Clarification

  • Data Type: STRING

  • Description: Clarification or additional information about the response.

  • Response_Void_Indicator

  • Data Type: BOOL

  • Description: Indicator for voided response.

  • Response_Void_Reason

  • Data Type: STRING

  • Description: Reason for voiding the response.

  • Response_Void_Reason_Description

  • Data Type: STRING

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

  • Response_Void_User_ID

  • Data Type: STRING

  • Description: User ID who voided the response.

  • Response_Void_User_Name

  • Data Type: STRING

  • Description: User name who voided the response.

  • Response_Void_Timestamp

  • Data Type: TIMESTAMP

  • Description: Timestamp when the response was voided.

  • Response_Selection_Key

  • Data Type: INT64

  • Description: Identifier for the response selection.

  • Response_Detail_Created_Timestamp

  • Data Type: TIMESTAMP

  • Description: Timestamp when the response detail was created.

  • Response_Detail_Last_Modified_Timestamp

  • Data Type: TIMESTAMP

  • Description: Timestamp of the last modification to the response detail.

Questionnaire Raw

Program Details

  • Enrollment_Program

  • Data Type: STRING

  • Description: Refers to the program or process through which individuals are enrolled or registered.

  • Screening_Program

  • Data Type: STRING

  • Description: Pertains to the program or process used for screening or assessing individuals.

  • Program_ID

  • Data Type: STRING

  • Description: A unique identifier associated with a specific program or initiative.

Record Metadata

  • Record_Last_Modified_Timestamp

  • Data Type: TIMESTAMP

  • Description: The most recent date and time when any record within the questionnaire log was modified.

  • Transaction_User_ID

  • Data Type: STRING

  • Description: Identifies the user responsible for the transaction or modification.

  • Deleted_Indicator

  • Data Type: BOOL

  • Description: Indicates whether a record has been deleted or voided.

  • Type

  • Data Type: STRING

  • Description: Specifies the type or category of the questionnaire log entry (e.g., response, modification, etc.).

  • Tenant

  • Data Type: STRING

  • Description: Refers to the specific organizational unit or context within which the questionnaire log operates.

  • Active_Version

  • Data Type: BOOL

  • Description: Denotes the currently active version of the questionnaire log.

Additional Metadata

  • Date

  • Data Type: DATE

  • Description: The date associated with the questionnaire log entry.

  • Sequence

  • Data Type: INT64

  • Description: Represents the order or sequence of log entries.

  • Source_System_Name

  • Data Type: STRING

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

  • Source_Timestamp

  • Data Type: TIMESTAMP

  • Description: The timestamp associated with the data source.

  • Source_File_Name

  • Data Type: STRING

  • Description: The name of the file or data source containing the questionnaire log information.

  • Schema_Version

  • Data Type: FLOAT64

  • Description: Indicates the version of the schema or data model used for the questionnaire log.

  • Member_Partition

  • Data Type: INT64

  • Description: Refers to a specific partition or subset of members within the dataset.

  • Transaction_Actor_Type

  • Data Type: STRING

  • Description: Type of the actor performing the transaction.

Questionnaire Metadata Question Raw

Question Metadata

  • Questionnaire_Question_Key

  • Data Type: INT64

  • Description: Unique key for identifying each questionnaire question.

  • Questionnaire_Version_Key

  • Data Type: INT64

  • Description: Key linking to the specific version of the questionnaire this question is part of.

  • Section_Key

  • Data Type: INT64

  • Description: Key identifying the section within the questionnaire that this question belongs to.

  • Position

  • Data Type: INT64

  • Description: Numerical order of the question within its section or questionnaire.

  • Member_Portal

  • Data Type: BOOL

  • Description: Indicates whether the question is visible in the member portal.

  • Provider_Portal

  • Data Type: BOOL

  • Description: Indicates whether the question is visible in the provider portal.

  • Depth

  • Data Type: INT64

  • Description: Represents the nesting level of the question within the questionnaire, useful for hierarchical question structures.

  • Required

  • Data Type: BOOL

  • Description: Indicates whether answering the question is mandatory for the completion of the questionnaire.

Modification Metadata

  • Questionnaire_Question_Modified_User_ID

  • Data Type: STRING

  • Description: User ID of the last person who modified this questionnaire question.

  • Questionnaire_Question_Created_Timestamp

  • Data Type: TIMESTAMP

  • Description: Timestamp when the question was initially created.

  • Questionnaire_Question_Last_Modified_Timestamp

  • Data Type: TIMESTAMP

  • Description: Timestamp of the last modification to the questionnaire question.

Questionnaire Dataset Specification

Questionnaire Metadata Question Raw

Fields

  • Timestamp

  • Type: TIMESTAMP

  • Description: Timestamp when the question was initially created.

  • Key

  • Type: INT64

  • Required: YES

  • Description: General identifier for referencing the question internally.

  • Short_Question

  • Type: STRING

  • Required: YES

  • Description: A shorter or abbreviated form of the question text.

  • Code

  • Type: STRING

  • Required: YES

  • Description: A unique code that may be used to identify the question in a coded form.

  • Response_Type

  • Type: STRING

  • Required: YES

  • Description: Describes the type of response expected for the question (e.g., Yes/No, Multiple Choice).

  • Response_Value_Type

  • Type: STRING

  • Required: YES

  • Description: Indicates the type of data expected to be captured (e.g., integer, string).

  • Response_Value_Type_Description

  • Type: STRING

  • Required: YES

  • Description: Detailed description of the response value type.

  • Class

  • Type: STRING

  • Required: YES

  • Description: Category or class the question belongs to within the questionnaire structure.

  • Class_Description

  • Type: STRING

  • Required: YES

  • Description: Descriptive details about the class.

  • Active

  • Type: BOOL

  • Required: YES

  • Description: Indicates whether the question is currently active and should be displayed.

  • Question_Available_To_AWF

  • Type: BOOL

  • Required: YES

  • Description: Specifies if the question is available to automated workflow processes.

  • Clinical_Help

  • Type: STRING

  • Required: YES

  • Description: Help text providing clinical context or guidance related to the question.

  • Non_Clinical_Help

  • Type: STRING

  • Required: YES

  • Description: Non-clinical help text providing guidance or information related to the question.

  • Modified_User_ID

  • Type: STRING

  • Required: YES

  • Description: User ID of the individual who last modified the question record.

  • Created_Timestamp

  • Type: TIMESTAMP

  • Required: YES

  • Description: Timestamp when the question record was created.

  • Last_Modified_Timestamp

  • Type: TIMESTAMP

  • Required: YES

  • Description: Timestamp when the question record was last updated.

  • Child_Questions

  • Type: ARRAY

  • Required: NO

  • Description: Lists sub-questions or dependent questions that are part of the scoring mechanism, showing the hierarchical structure of questionnaire logic.

  • Parameters:

    • Child_Questions.Questionnaire_Key

    • Type: INT64

    • Required: YES

    • Description: Identifier for the questionnaire to which the question belongs.

    • Child_Questions.Questionnaire_Question_Key

    • Type: INT64

    • Required: YES

    • Description: Unique identifier for the questionnaire question.

    • Child_Questions.Modified_User_ID

    • Type: STRING

    • Required: YES

    • Description: User ID of the user who last modified the record.

    • Child_Questions.Created_Timestamp

    • Type: TIMESTAMP

    • Required: YES

    • Description: Timestamp indicating when the record was created.

    • Child_Questions.Last_Modified_Timestamp

    • Type: TIMESTAMP

    • Required: YES

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

  • Entry_Tests

  • Type: ARRAY

  • Required: NO

  • Description: An array of conditions or criteria that must be met for the question to be presented or considered relevant, ensuring appropriate question display.

  • Parameters:

    • Entry_Tests.Key

    • Description: Key parameter for entry tests.

    • Entry_Tests.Minimum_Value

    • Description: Minimum value for entry tests.

    • Entry_Tests.Maximum_Value

    • Description: Maximum value for entry tests.

    • Entry_Tests.Modified_User_ID

    • Type: STRING

    • Required: YES

    • Description: User ID of the user who last modified the record.

    • Entry_Tests.Created_Timestamp

    • Type: TIMESTAMP

    • Required: YES

    • Description: Timestamp indicating when the record was created.

    • Entry_Tests.Last_Modified_Timestamp

    • Type: TIMESTAMP

    • Required: YES

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

  • Entry_Tests.Enablers

  • Type: ARRAY

  • Required: NO

  • Description: Defines conditions or thresholds that activate or modify the scoring function, allowing for dynamic and context-sensitive scoring.

  • Parameters:

    • Entry_Tests.Enablers.Child_Questions.Questionnaire_Key

    • Type: INT64

    • Required: YES

    • Description: Identifier for the questionnaire to which the question belongs.

    • Entry_Tests.Enablers.Child_Questions.Questionnaire_Question_Key

    • Type: INT64

    • Required: YES

    • Description: Unique identifier for the questionnaire question.

    • Entry_Tests.Enablers.Child_Questions.Created_Timestamp

    • Type: TIMESTAMP

    • Required: YES

    • Description: Timestamp indicating when the record was created.

    • Entry_Tests.Enablers.Child_Questions.Last_Modified_User_ID

    • Type: STRING

    • Required: YES

    • Description: User ID of the user who last modified the record.

    • Entry_Tests.Enablers.Child_Questions.Last_Modified_Timestamp

    • Type: TIMESTAMP

    • Required: YES

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

  • Selections

  • Type: ARRAY

  • Required: NO

  • Description: An array detailing the available choices or responses for the question, typically used for multiple-choice or selection-based questions.

  • Parameters:

    • Selections.Key

    • Type: INT64

    • Required: YES

    • Description: A unique identifier for each selection.

    • Selections.Selection_Key

    • Type: STRING

    • Required: YES

    • Description: A unique identifier for the specific selection within the entry.

    • Selections.Scoring_Weight

    • Type: STRING

    • Required: YES

    • Description: The weight assigned to the selection for scoring purposes.

    • Selections.Modified_User_ID

    • Type: STRING

    • Required: YES

    • Description: User ID of the user who last modified the record.

    • Selections.Created_Timestamp

    • Type: TIMESTAMP

    • Required: YES

    • Description: Timestamp indicating when the record was created.

    • Selections.Last_Modified_Timestamp

    • Type: TIMESTAMP

    • Required: YES

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

    • Selections.Code

    • Type: STRING

    • Required: YES

    • Description: Unique code of the selection.

    • Selections.Selection_Modified_User_ID

    • Type: STRING

    • Required: YES

    • Description: User ID of the user who last modified the record.

    • Selections.Selection_Created_Timestamp

    • Type: TIMESTAMP

    • Required: YES

    • Description: Timestamp indicating when the record was created.

    • Selections.Selection_Last_Modified_Timestamp

    • Type: TIMESTAMP

    • Required: YES

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

    • Selections.Enablers

    • Description: Defines conditions or thresholds that act.

Questionnaire Dataset Specification

Selections

Enablers

Child Questions

  • Questionnaire_Key

  • Required: YES

  • Type: INT64

  • Description: Identifier for the questionnaire to which the question belongs.

  • Questionnaire_Question_Key

  • Required: YES

  • Type: INT64

  • Description: Unique identifier for the questionnaire question.

  • Created_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp indicating when the record was created.

  • Last_Modified_User_ID

  • Required: YES

  • Type: STRING

  • Description: User ID of the user who last modified the record.

  • Last_Modified_Timestamp

  • Required: YES

  • Type: TIMESTAMP

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

Problems

  • Key

  • Required: YES

  • Type: INT64

  • Description: A unique identifier for each problem within the selections.

  • Problem

  • Required: YES

  • Type: STRING

  • Description: The specific problem identified within the selection.

  • Problem_Description

  • Required: YES

  • Type: STRING

  • Description: A detailed description of the problem, providing more context and information.

  • Modified_User_ID

  • Required: YES

  • Type: STRING

  • Description: User ID of the user who last modified the record.

  • Created_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp indicating when the record was created.

  • Last_Modified_Timestamp

  • Required: YES

  • Type: TIMESTAMP

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

Versions

  • Key

  • Required: YES

  • Type: INT64

  • Description: A unique identifier for each version of the selection.

  • Question_Version_Key

  • Required: YES

  • Type: INT64

  • Description: A unique identifier for the version of the question associated with the selection.

  • Position

  • Required: YES

  • Type: STRING

  • Description: The order or position of the version within the selection.

  • Value

  • Required: YES

  • Type: STRING

  • Description: The value assigned to the version of the selection.

  • Clarification_Indicator

  • Required: YES

  • Type: STRING

  • Description: An indicator specifying whether clarification is needed for the version.

  • Mutual_Exclusive

  • Required: YES

  • Type: STRING

  • Description: Indicates whether the version is mutually exclusive with other versions.

  • Modified_User_ID

  • Required: YES

  • Type: STRING

  • Description: User ID of the user who last modified the record.

  • Created_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp indicating when the record was created.

  • Last_Modified_Timestamp

  • Required: YES

  • Type: TIMESTAMP

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

Questionnaire Metadata

Question Raw

Versions

  • Questionnaire_Version_Key

  • Required: YES

  • Type: INT64

  • Description: Refers to a specific version of the questionnaire.

  • Questionnaire_Version_Number

  • Required: YES

  • Type: INT64

  • Description: The numerical version number assigned to the questionnaire.

  • Full_Question_Clinical

  • Required: YES

  • Type: STRING

  • Description: Full clinical question text.

  • Questionnaire_Effective_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp when the questionnaire became effective.

  • Questionnaire_Termination_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp when the questionnaire is terminated.

  • Question_Report_Title

  • Required: YES

  • Type: STRING

  • Description: Title used for reporting purposes related to the question.

  • Question_Display_Type

  • Required: YES

  • Type: STRING

  • Description: Display type for the question in the user interface.

  • Question_Response_Type_Description

  • Required: YES

  • Type: STRING

  • Description: Description of the question response type. See Dictionary Response Type table in the Dictionary Dataset Specification.

  • Field_Length

  • Required: YES

  • Type: STRING

  • Description: The length of the field for the version of the selection.

  • Input_Length

  • Required: YES

  • Type: STRING

  • Description: The maximum length of input allowed for the version of the selection.

  • Maximum_Value

  • Required: YES

  • Type: STRING

  • Description: The maximum value that can be assigned to the version of the selection.

  • Minimum_Value

  • Required: YES

  • Type: STRING

  • Description: The minimum value that can be assigned to the version of the selection.

  • Selections_Allowed

  • Required: YES

  • Type: STRING

  • Description: Indicates whether multiple selections are allowed for the version.

  • Modified_User_ID

  • Required: YES

  • Type: STRING

  • Description: User ID of the user who last modified the record.

  • Version_Created_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp indicating when the record was created.

  • Version_Last_Modified_Timestamp

  • Required: YES

  • Type: TIMESTAMP

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

Additional Metadata Fields

  • Record_Last_Modified_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp indicating the last modification to the question's record.

  • Transaction_User_ID

  • Required: YES

  • Type: STRING

  • Description: Identifier of the user involved in the last transaction affecting this record.

  • Deleted_Indicator

  • Required: YES

  • Type: BOOL

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

  • Type

  • Required: YES

  • Type: STRING

  • Description: General type classification of the question.

  • Tenant

  • Required: YES

  • Type: STRING

  • Description: Identifies the tenant in the context of a multi-tenant system.

  • Active_Version

  • Required: YES

  • Type: BOOL

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

  • Date

  • Required: YES

  • Type: DATE

  • Description: Date associated with the record entry or modification.

  • Sequence

  • Required: YES

  • Type: INT64

  • Description: Sequential identifier used for ordering or versioning within the system.

  • Source_System_Name

  • Required: YES

  • Type: STRING

  • Description: Name of the source system.

Questionnaire Dataset Specification

Questionnaire Metadata Question Raw

Source_System

  • Field Name: Source_System

  • Required: YES

  • Type: STRING

  • Description: The system from which the question data originates.

Source_Timestamp

  • Field Name: Source_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp when the data was captured from the source system.

Source_File_Name

  • Field Name: Source_File_Name

  • Required: YES

  • Type: STRING

  • Description: Name of the file from the source system containing the question data.

Schema_Version

  • Field Name: Schema_Version

  • Required: YES

  • Type: FLOAT64

  • Description: Version of the data schema used for this question record.

_updated

  • Field Name: _updated

  • Required: YES

  • Type: STRING

  • Description: Indicates any recent updates to the record not specifically categorized in other fields.

Related Articles
Did this answer your question?