HIPAA LOG Dataset Specification
HIPAA LOG Dataset Specification
The "HIPAA Log Dataset Specification" is a structured dataset developed to manage and track HIPAA-related transactions and activities within a healthcare system. This dataset is essential for ensuring compliance with HIPAA standards, which govern the privacy and security of protected health information (PHI).
Key Elements of the Dataset
HIPAA Transaction Records
Records details of transactions that occur under HIPAA regulations.
Includes information on the nature, timing, and parties involved in the transactions.
Ensures that all HIPAA-compliant interactions are accurately documented.
HIPAA Log
Documents the history and changes related to HIPAA transactions.
Provides a detailed audit trail crucial for monitoring compliance and reviewing the integrity of PHI handling processes.
HIPAA Log Raw
Contains unprocessed, detailed logs of HIPAA-related activities.
Offers invaluable raw data for conducting in-depth analyses and audits.
Provides insights into the operational aspects of HIPAA compliance.
This dataset plays a critical role in the monitoring and auditing of PHI transactions and interactions within the healthcare system, helping to maintain strict compliance with HIPAA regulations and safeguard patient information.
HIPAA Log Table Specification
Columns and Descriptions
Column Name | Is Nullable | Data Type | Description |
Log_Entry_Key | YES | INT64 | A unique identifier assigned to each transaction log entry in the dataset. |
Member_ID | YES | STRING | Identifier for the member or individual involved in the transaction. |
Request_ID | YES | STRING | Identifier for the specific request or action associated with the transaction. |
Program_ID | YES | STRING | Identifier for the program or service associated with the transaction. |
Screening_Key | YES | STRING | The key identifying the screening related to the log entry. |
User_ID | YES | STRING | Identifier for the user who initiated or performed the transaction. |
User_Full_Name | YES | STRING | Full name of the user who initiated or performed the transaction. |
Log_Timestamp | YES | TIMESTAMP | Time when the transaction log entry was recorded. |
Log_Date | YES | DATE | Date when the transaction log entry was recorded. |
Transaction_Type | YES | STRING | Type of transaction, such as data access, modification, or deletion. See Dictionary Transaction Type table in the Dictionary Dataset Specification. |
Transaction_Type_Description | YES | STRING | Description of the type of transaction. |
Transaction_Source | YES | STRING | Source or origin of the transaction. See Dictionary Transaction Source table in the Dictionary Dataset Specification. |
Transaction_Source_Description | YES | STRING | Description providing further details about the source or origin of the transaction. See Dictionary Transaction Source table in the Dictionary Dataset Specification. |
Created_Timestamp | YES | TIMESTAMP | Date and time when the transaction was created. |
Last_Modified_Timestamp | YES | TIMESTAMP | Date and time when the transaction was last modified. |
HIPAA Log Raw Table Specification
Columns and Descriptions
Column Name | Is Nullable | Data Type | Description |
Log_Entry_Key | YES | INT64 | A unique identifier assigned to each log entry in the dataset. |
Log_Entry_Type | YES | STRING | Indicates the type or category of the log entry. |
iExchange_Oracle_Key | YES | STRING | A key linking the log entry to corresponding data or transactions in the Oracle database within the iExchange system. |
Member_ID | YES | STRING | Identifier for the member or individual associated with the transaction or activity recorded in the log. |
Program_ID | YES | STRING | Identifier for the program or service associated with the transaction or activity recorded in the log. |
Request_ID | YES | STRING | Identifier for the specific request or action associated with the transaction or activity recorded in the log. |
iExchange_Questionnaire_ID | YES | STRING | Identifier for the questionnaire associated with the transaction or activity recorded in the log within the iExchange system. |
iExchange_Outcome_Status | YES | STRING | Status of the outcome or result associated with the transaction or activity recorded in the log within the iExchange system. |
iExchange_Outcome_Status_Description | YES | STRING | Description providing further details about the outcome or result associated with the transaction or activity recorded in the log within the iExchange system. |
iExchange_Payer_Name | YES | STRING | Name of the payer or insurance provider associated with the transaction or activity recorded in the log within the iExchange system. |
User_ID | YES | STRING | Identifier for the user who initiated or performed the transaction or activity recorded in the log. |
User_Full_Name | YES | STRING | Full name of the user who initiated or performed the transaction or activity recorded in the log. |
iExchange_User_Type | YES | STRING | Type or role of the user associated with the transaction or activity recorded in the log within the iExchange system. |
iExchange_Group_ID | YES | STRING | Identifier for the group or department associated with the transaction or activity recorded in the log within the iExchange system. See Dictionary iExchange Group table in the Dictionary Dataset Specification. |
iExchange_Group_Name | YES | STRING | Name of the group or department associated with the transaction or activity recorded in the log within the iExchange system. See Dictionary iExchange Group table in the Dictionary Dataset Specification. |
Log_Timestamp | YES | TIMESTAMP | Date and time when the log entry was recorded. |
Transaction_Type | YES | STRING | Type of transaction or activity recorded in the log, such as data access, modification, or deletion. See Dictionary Transaction Type table in the Dictionary Dataset Specification. |
Transaction_Source | YES | STRING | Source or origin of the transaction or activity recorded in the log. See Dictionary Transaction Source table in the Dictionary Dataset Specification. |
Transaction_Source_Description | YES | STRING | Description providing further details about the source or origin of the transaction or activity recorded in the log. See Dictionary Transaction Source table in the Dictionary Dataset Specification. |
HIPAA LOG Dataset Specification
CareWebQI
CareWebQI
STRUCT\ Specific identifier or reference related to CareWebQI within the iExchange system, associated with the transaction or activity recorded in the log.
iExchange_CareWebQI.Oracle_Key
Data Type: STRING\ A unique identifier used within the Oracle database to trace this particular record, ensuring traceability within system audits.
iExchange_CareWebQI.Episode_ID
Data Type: STRING\ The identifier for the healthcare episode related to the guideline check, linking this record to a specific patient encounter.
iExchange_CareWebQI.Guideline_Code
Data Type: STRING\ A code representing the specific healthcare guideline being checked, which helps categorize and reference the compliance criteria.
iExchange_CareWebQI.Criteria_Met
Data Type: BOOL\ A boolean indicator showing whether the healthcare service met the guideline criteria, crucial for compliance reporting.
iExchange_Calculated_Goal_Units
Data Type: INT64\ Indicates the calculated goal units associated with the transaction or activity recorded in the log within the iExchange system.
iExchange_Requested_Units
Data Type: INT64\ Indicates the requested units associated with the transaction or activity recorded in the log within the iExchange system.
iExchange_Version
Data Type: STRING\ Version or release of the iExchange system associated with the transaction or activity recorded in the log.
InterQualConnect
iExchange_InterQualConnect
STRUCT\ Indicates whether the transaction or activity recorded in the log involves InterQualConnect functionality within the iExchange system.
iExchange_InterQualConnect.Oracle_Key
Data Type: STRING\ A unique identifier used within the Oracle database to trace this particular record, ensuring traceability within system audits.
iExchange_InterQualConnect.Review_ID
Data Type: STRING\ The identifier for the specific review instance related to the healthcare product, linking this record to a particular assessment.
iExchange_InterQualConnect.Product
Data Type: STRING\ The name or type of healthcare product or service being reviewed, which helps categorize and reference the review criteria.
iExchange_InterQualConnect.Criteria_Met_Description
Data Type: STRING\ A description detailing the outcomes of the review and whether the specific criteria of the healthcare guidelines were met.
Timestamps
Created_Timestamp
Data Type: TIMESTAMP\ Date and time when the record associated with the log entry was created.
Last_Modified_Timestamp
Data Type: TIMESTAMP\ Date and time when the record associated with the log entry was last modified.
Record_Last_Modified_Timestamp
Data Type: TIMESTAMP\ Date and time when the record associated with the log entry was last modified.
Blocked Members
iExchange_Blocked_Members
Data Type: ARRAY\ Indicates whether the member associated with the transaction or activity recorded in the log is blocked within the iExchange system.
iExchange_Blocked_Members.Key
Data Type: INT64\ A unique identifier for each blocked member entry within the HIPAA log, ensuring distinct traceability and management of compliance records.
iExchange_Blocked_Members.Member_ID
Data Type: STRING\ The identifier of the member who has been blocked, linking this record to a specific individual within the healthcare system.
iExchange_Blocked_Members.Created_Timestamp
Data Type: TIMESTAMP\ Timestamp indicating when the record of the blocked member was first created, marking the initial time of the action.
iExchange_Blocked_Members.Last_Modified_Timestamp
Data Type: TIMESTAMP\ Timestamp indicating when the record of the blocked member was last updated, useful for tracking changes and maintaining current operational data.
General Attributes
Transaction_User_ID
Data Type: STRING\ Identifier for the user who initiated or performed the transaction or activity recorded in the log.
Deleted_Indicator
Data Type: BOOL\ Indicator showing whether the record associated with the log entry has been marked as deleted.
Type
Data Type: STRING\ Type or category of the record associated with the log entry.
Tenant
Data Type: STRING\ Identifier for the tenant or client organization associated with the transaction or activity recorded in the log.
Active_Version
Data Type: BOOL\ Indicates the active version or status of the record associated with the log entry.
Date
Data Type: DATE\ Date associated with the transaction or activity recorded in the log.
Sequence
Data Type: INT64\ Sequence number or identifier associated with the transaction or activity recorded in the log.
Source_System_Name
Data Type: STRING\ Name of the source system from which the transaction or activity recorded in the log originated.
Source_Timestamp
Data Type: STRING\ Date and time when the transaction or activity recorded in the log originated in the source system.
Source_File_Name
Data Type: STRING\ Name of the source file from which the transaction or activity recorded in the log originated.
Schema_Version
Data Type: FLOAT64\ Version of the schema or data model associated with the transaction or activity recorded in the log.
Action
Data Type: STRING\ Action or operation performed as part of the transaction or activity recorded in the log.
Log Entry Details
Log_Entry_Key
Data Type: INT64\ A unique identifier assigned to each log entry in the dataset.
Log_Entry_Type
Data Type: STRING\ Indicates the type or category of the log entry.
iExchange_Oracle_Key
Data Type: STRING\ A key linking the log entry to corresponding data or transactions in the Oracle database within the iExchange system.
Member_ID
Data Type: STRING\ Identifier for the member or individual associated with the transaction or activity recorded in the log.
Program_ID
Data Type: STRING\ Identifier for the program or service associated with the transaction or activity recorded in the log.
Request_ID
Data Type: STRING\ Identifier for the specific request or action associated with the transaction or activity recorded in the log.
iExchange_Questionnaire_ID
Data Type: STRING\ Identifier for the questionnaire associated with the transaction or activity recorded in the log within the iExchange system.
iExchange_Outcome_Status
Data Type: STRING\ Status of the outcome or result associated with the transaction or activity recorded in the log within the iExchange system.
iExchange_Outcome_Status_Description
Data Type: STRING\ Description providing further details about the outcome or result associated with the transaction or activity recorded in the log.
HIPAA LOG Dataset Specification
iExchange System Fields
iExchange_Payer_Name
Required: YES
Type: STRING
Description: Name of the payer or insurance provider associated with the transaction or activity recorded in the log within the iExchange system.
User_ID
Required: YES
Type: STRING
Description: Identifier for the user who initiated or performed the transaction or activity recorded in the log.
User_Full_Name
Required: YES
Type: STRING
Description: Full name of the user who initiated or performed the transaction or activity recorded in the log.
iExchange_User_Type
Required: YES
Type: STRING
Description: Type or role of the user associated with the transaction or activity recorded in the log within the iExchange system.
iExchange_Group_ID
Required: YES
Type: STRING
Description: Identifier for the group or department associated with the transaction or activity recorded in the log within the iExchange system.
Reference: See Dictionary iExchange Group table in the Dictionary Dataset Specification.
iExchange_Group_Name
Required: YES
Type: STRING
Description: Name of the group or department associated with the transaction or activity recorded in the log within the iExchange system.
Reference: See Dictionary iExchange Group table in the Dictionary Dataset Specification.
Log_Timestamp
Required: YES
Type: TIMESTAMP
Description: Date and time when the log entry was recorded.
Transaction_Type
Required: YES
Type: STRING
Description: Type of transaction or activity recorded in the log, such as data access, modification, or deletion.
Reference: See Dictionary Transaction Type table in the Dictionary Dataset Specification.
Transaction_Source
Required: YES
Type: STRING
Description: Source or origin of the transaction or activity recorded in the log.
Reference: See Dictionary Transaction Source table in the Dictionary Dataset Specification.
Transaction_Source_Description
Required: YES
Type: STRING
Description: Description providing further details about the source or origin of the transaction or activity recorded in the log.
Reference: See Dictionary Transaction Source table in the Dictionary Dataset Specification.
iExchange_CareWebQI
Required: YES
Type: STRUCT
Description: Specific identifier or reference related to CareWebQI within the iExchange system, associated with the transaction or activity recorded in the log.
iExchange_CareWebQI.Oracle_Key
Required: YES
Type: STRING
Description: A unique identifier used within the Oracle database to trace this particular record, ensuring traceability within system audits.
iExchange_CareWebQI.Episode_ID
Required: YES
Type: STRING
Description: The identifier for the healthcare episode related to the guideline check, linking this record to a specific patient encounter.
iExchange_CareWebQI.Guideline_Code
Required: YES
Type: STRING
Description: A code representing the specific healthcare guideline being checked, which helps categorize and reference the compliance criteria.
iExchange_CareWebQI.Criteria_Met
Required: YES
Type: BOOL
Description: A boolean indicator showing whether the healthcare service met the guideline criteria, crucial for compliance reporting.
iExchange_Calculated_Goal_Units
Required: YES
Type: INT64
Description: Indicates the calculated goal units associated with the transaction or activity recorded in the log within the iExchange system.
iExchange_Requested_Units
Required: YES
Type: INT64
Description: Indicates the requested units associated with the transaction or activity recorded in the log within the iExchange system.
iExchange_Version
Required: YES
Type: STRING
Description: Version or release of the iExchange system associated with the transaction or activity recorded in the log.
iExchange_InterQualConnect
Required: YES
Type: STRUCT
Description: Indicates whether the transaction or activity recorded in the log involves InterQualConnect functionality within the iExchange system.
iExchange_InterQualConnect.Oracle_Key
Required: YES
Type: STRING
Description: A unique identifier used within the Oracle database to trace this particular record, ensuring traceability within system audits.
iExchange_InterQualConnect.Review_ID
Required: YES
Type: STRING
Description: The identifier for the specific review instance related to the healthcare product, linking this record to a particular assessment.
iExchange_InterQualConnect.Product
Required: YES
Type: STRING
Description: The name or type of healthcare product or service being reviewed, which helps categorize and reference the review criteria.
iExchange_InterQualConnect.Criteria_Met_Description
Required: YES
Type: STRING
Description: A description detailing the outcomes of the review and whether the specific criteria of the healthcare guidelines were met.
Created_Timestamp
Required: YES
Type: TIMESTAMP
Description: Date and time when the record associated with the log entry was created.
Last_Modified_Timestamp
Required: YES
Type: TIMESTAMP
Description: Date and time when the record associated with the log entry was last modified.
iExchange_Blocked_Members
Required: NO
Type: ARRAY
Description: Indicates whether the member associated with the transaction or activity recorded in the log is blocked within the iExchange system.
iExchange_Blocked_Members.Key
Required: YES
Type: INT64
Description: A unique identifier for each blocked member entry within the HIPAA raw data, ensuring distinct traceability and management of compliance records.
iExchange_Blocked_Members.Member_ID
Required: YES
Type: STRING
Description: The identifier of the member who has been blocked, linking this record to a specific individual within the healthcare system.
iExchange_Blocked_Members.Created_Timestamp
Required: YES
Type: TIMESTAMP
Description: Timestamp indicating when the record of the blocked member was first created, marking the initial time of the action.
iExchange_Blocked_Members.Last_Modified_Timestamp
Required: YES
Type: TIMESTAMP
Description: Timestamp indicating when the record of the blocked member was last updated, useful for tracking changes and maintaining current operational data.
Record_Last_Modified_Timestamp
Required: YES
Type: TIMESTAMP
Description: Date and time when the record associated with the log entry was last modified.
Transaction_User_ID
Required: YES
Type: STRING
Description: Identifier for the user who initiated or performed the transaction or activity recorded in the log.
Deleted_Indicator
Required: YES
Type: BOOL
Description: Indicator showing whether the record associated with the log entry has been marked as deleted.
Type
Required: YES
Type: STRING
Description: Type or category of the record associated with the log entry.
Tenant
Required: YES
Type: STRING
Description: Identifier for the tenant or client organization associated with the transaction or activity recorded in the log.
Active_Version
Required: YES
Type: BOOL
Description: Indicates the active version or status of the record associated with the log entry.
Date
Required: YES
Type: DATE
Description: Date associated with the transaction or activity recorded in the log.
Sequence
Required: YES
Type: STRING
Description: Sequence associated with the transaction or activity recorded in the log.
HIPAA LOG Dataset Specification
Overview
HIPAA Transaction Records
This table records details of transactions that occur under HIPAA regulations. It includes information on the nature, timing, and parties involved in the transactions, ensuring that all HIPAA-compliant interactions are accurately documented.
HIPAA Log
Documents the history and changes related to HIPAA transactions. This log provides a detailed audit trail that is crucial for monitoring compliance and reviewing the integrity of PHI handling processes.
HIPAA Log Raw
Contains unprocessed, detailed logs of HIPAA-related activities. This raw data is invaluable for conducting in-depth analyses and audits, offering insights into the operational aspects of HIPAA compliance.
Column Specifications
General Columns
ES
Data Type: INT64
Description: Sequence number or identifier associated with the transaction or activity recorded in the log.
Source_System_Name
Is Nullable: YES
Data Type: STRING
Description: Name of the source system from which the transaction or activity recorded in the log originated.
Source_Timestamp
Is Nullable: YES
Data Type: STRING
Description: Date and time when the transaction or activity recorded in the log originated in the source system.
Source_File_Name
Is Nullable: YES
Data Type: STRING
Description: Name of the source file from which the transaction or activity recorded in the log originated.
Schema_Version
Is Nullable: YES
Data Type: FLOAT64
Description: Version of the schema or data model associated with the transaction or activity recorded in the log.
Action
Is Nullable: YES
Data Type: STRING
Description: Action or operation performed as part of the transaction or activity recorded in the log.
Transaction_Actor_Type
Is Nullable: YES
Data Type: STRING
Description: Type of the actor performing the transaction.
Screening_Key
Is Nullable: YES
Data Type: STRING
Description: The key identifying the screening related to the log entry.
HIPAA Log Table
Column Name | Is Nullable | Data Type | Description |
Log_Entry_Key | YES | INT64 | A unique identifier assigned to each transaction log entry in the dataset. |
Member_ID | YES | STRING | Identifier for the member or individual involved in the transaction. |
Request_ID | YES | STRING | Identifier for the specific request or action associated with the transaction. |
Program_ID | YES | STRING | Identifier for the program or service associated with the transaction. |
Screening_Key | YES | STRING | The key identifying the screening related to the log entry. |
User_ID | YES | STRING | Identifier for the user who initiated or performed the transaction. |
User_Full_Name | YES | STRING | Full name of the user who initiated or performed the transaction. |
Log_Timestamp | YES | TIMESTAMP | Time when the transaction log entry was recorded. |
Log_Date | YES | DATE | Date when the transaction log entry was recorded. |
Transaction_Type | YES | STRING | Type of transaction, such as data access, modification, or deletion. See Dictionary Transaction Type table. |
Transaction_Type_Description | YES | STRING | Description of the type of transaction. |
Transaction_Source | YES | STRING | Source or origin of the transaction. See Dictionary Transaction Source table. |
Transaction_Source_Description | YES | STRING | Description providing further details about the source or origin of the transaction. |
Created_Timestamp | YES | TIMESTAMP | Date and time when the transaction was created. |
Last_Modified_Timestamp | YES | TIMESTAMP | Date and time when the transaction was last modified. |
HIPAA Log Raw Table
Column Name | Is Nullable | Data Type | Description |
Log_Entry_Key | YES | INT64 | A unique identifier assigned to each log entry in the dataset. |
Log_Entry_Type | YES | STRING | Indicates the type or category of the log entry. |
iExchange_Oracle_Key | YES | STRING | A key linking the log entry to corresponding data or transactions in the Oracle database within the iExchange system. |
Member_ID | YES | STRING | Identifier for the member or individual associated with the transaction or activity recorded in the log. |
Program_ID | YES | STRING | Identifier for the program or service associated with the transaction or activity recorded in the log. |
Request_ID | YES | STRING | Identifier for the specific request or action associated with the transaction or activity recorded in the log. |
iExchange_Questionnaire_ID | YES | STRING | Identifier for the questionnaire associated with the transaction or activity recorded in the log within the iExchange system. |
iExchange_Outcome_Status | YES | STRING | Status of the outcome or result associated with the transaction or activity recorded in the log within the iExchange system. |
iExchange_Outcome_Status_Description | YES | STRING | Description providing further details about the outcome or result associated with the transaction or activity recorded in the log within the iExchange system. |
iExchange_Payer_Name | YES | STRING | Name of the payer or insurance provider associated with the transaction or activity recorded in the log within the iExchange system. |
User_ID | YES | STRING | Identifier for the user who initiated or performed the transaction or activity recorded in the log. |
User_Full_Name | YES | STRING | Full name of the user who initiated or performed the transaction or activity recorded in the log. |
iExchange_User_Type | YES | STRING | Type or role of the user associated with the transaction or activity recorded in the log within the iExchange system. |
iExchange_Group_ID | YES | STRING | Identifier for the group or department associated with the transaction or activity recorded in the log within the iExchange system. See Dictionary iExchange Group table. |
iExchange_Group_Name | YES | STRING | Name of the group or department associated with the transaction or activity recorded in the log within the iExchange system. See Dictionary iExchange Group table. |
Log_Timestamp | YES | TIMESTAMP | Date and time when the transaction log entry was recorded. |
HIPAA LOG Dataset Specification
Overview
The HIPAA LOG dataset provides detailed specifications for tracking transactions, activities, and compliance within the Care Intelligence system. Each entry in the log includes information about the transaction type, source, associated identifiers, timestamps, and other relevant metadata.
Fields
Transaction_Type
Is Nullable: YES
Data Type: STRING
Description: Type of transaction or activity recorded in the log, such as data access, modification, or deletion.\ See the Dictionary Transaction Type table in the Dictionary Dataset Specification.
Transaction_Source
Is Nullable: YES
Data Type: STRING
Description: Source or origin of the transaction or activity recorded in the log.\ See the Dictionary Transaction Source table in the Dictionary Dataset Specification.
Transaction_Source_Description
Is Nullable: YES
Data Type: STRING
Description: Description providing further details about the source or origin of the transaction or activity recorded in the log.\ See the Dictionary Transaction Source table in the Dictionary Dataset Specification.
iExchange_CareWebQI
iExchange_CareWebQI
Is Nullable: YES
Data Type: STRUCT
Description: Specific identifier or reference related to CareWebQI within the iExchange system, associated with the transaction or activity recorded in the log.
iExchange_CareWebQI.Oracle_Key
Is Nullable: YES
Data Type: STRING
Description: A unique identifier used within the Oracle database to trace this particular record, ensuring traceability within system audits.
iExchange_CareWebQI.Episode_ID
Is Nullable: YES
Data Type: STRING
Description: The identifier for the healthcare episode related to the guideline check, linking this record to a specific patient encounter.
iExchange_CareWebQI.Guideline_Code
Is Nullable: YES
Data Type: STRING
Description: A code representing the specific healthcare guideline being checked, which helps categorize and reference the compliance criteria.
iExchange_CareWebQI.Criteria_Met
Is Nullable: YES
Data Type: BOOL
Description: A boolean indicator showing whether the healthcare service met the guideline criteria, crucial for compliance reporting.
iExchange_Calculated_Goal_Units
Is Nullable: YES
Data Type: INT64
Description: Indicates the calculated goal units associated with the transaction or activity recorded in the log within the iExchange system.
iExchange_Requested_Units
Is Nullable: YES
Data Type: INT64
Description: Indicates the requested units associated with the transaction or activity recorded in the log within the iExchange system.
iExchange_Version
Is Nullable: YES
Data Type: STRING
Description: Version or release of the iExchange system associated with the transaction or activity recorded in the log.
iExchange_InterQualConnect
iExchange_InterQualConnect
Is Nullable: YES
Data Type: STRUCT
Description: Indicates whether the transaction or activity recorded in the log involves InterQualConnect functionality within the iExchange system.
iExchange_InterQualConnect.Oracle_Key
Is Nullable: YES
Data Type: STRING
Description: A unique identifier used within the Oracle database to trace this particular record, ensuring traceability within system audits.
iExchange_InterQualConnect.Review_ID
Is Nullable: YES
Data Type: STRING
Description: The identifier for the specific review instance related to the healthcare product, linking this record to a particular assessment.
iExchange_InterQualConnect.Product
Is Nullable: YES
Data Type: STRING
Description: The name or type of healthcare product or service being reviewed, which helps categorize and reference the review criteria.
iExchange_InterQualConnect.Criteria_Met_Description
Is Nullable: YES
Data Type: STRING
Description: A description detailing the outcomes of the review and whether the specific criteria of the healthcare guidelines were met.
Created_Timestamp
Is Nullable: YES
Data Type: TIMESTAMP
Description: Date and time when the record associated with the log entry was created.
Last_Modified_Timestamp
Is Nullable: YES
Data Type: TIMESTAMP
Description: Date and time when the record associated with the log entry was last modified.
iExchange_Blocked_Members
iExchange_Blocked_Members
Is Nullable: NO
Data Type: ARRAY
Description: Indicates whether the member associated with the transaction or activity recorded in the log is blocked within the iExchange system.
iExchange_Blocked_Members.Key
Is Nullable: YES
Data Type: INT64
Description: A unique identifier for each blocked member entry within the HIPAA log, ensuring distinct traceability and management of compliance records.
iExchange_Blocked_Members.Member_ID
Is Nullable: YES
Data Type: STRING
Description: The identifier of the member who has been blocked, linking this record to a specific individual within the healthcare system.
iExchange_Blocked_Members.Created_Timestamp
Is Nullable: YES
Data Type: TIMESTAMP
Description: Timestamp indicating when the record of the blocked member was first created, marking the initial time of the action.
iExchange_Blocked_Members.Last_Modified_Timestamp
Is Nullable: YES
Data Type: TIMESTAMP
Description: Timestamp indicating when the record of the blocked member was last updated, useful for tracking changes and maintaining current operational data.
Record_Last_Modified_Timestamp
Is Nullable: YES
Data Type: TIMESTAMP
Description: Date and time when the record associated with the log entry was last modified.
Transaction_User_ID
Is Nullable: YES
Data Type: STRING
Description: Identifier for the user who initiated or performed the transaction or activity recorded in the log.
Deleted_Indicator
Is Nullable: YES
Data Type: BOOL
Description: Indicator showing whether the record associated with the log entry has been marked as deleted.
Type
Is Nullable: YES
Data Type: STRING
Description: Type or category of the record associated with the log entry.
Tenant
Is Nullable: YES
Data Type: STRING
Description: Identifier for the tenant or client organization associated with the transaction or activity recorded in the log.
Active_Version
Is Nullable: YES
Data Type: BOOL
Description: Indicates the active version or status of the record associated with the log entry.
Date
Is Nullable: YES
Data Type: DATE
Description: Date associated with the transaction or activity recorded in the log.
Sequence
Is Nullable: YES
Data Type: INT64
Description: Sequence number or identifier associated with the transaction or activity recorded in the log.
Source_System_Name
Is Nullable: YES
Data Type: STRING
Description: Name of the source system from which the transaction or activity recorded in the log originated.
Source_Timestamp
Is Nullable: YES
Data Type: STRING
Description: Date and time when the transaction or activity recorded in the log originated in the source system.
Source_File_Name
Is Nullable: YES
Data Type: STRING
Description: Name of the source file from which the transaction or activity recorded in the log originated.
Schema_Version
Is Nullable: YES
Data Type: FLOAT64
Description: Version of the schema or data model associated with the transaction or activity recorded in the log.
Action
Is Nullable: YES
Data Type: STRING
Description: Action or operation performed as part of the transaction or activity recorded in the log.
HIPAA LOG Dataset Specification
Log Entry Attributes
Log_Entry_Key
Type: INT64
Required: YES
Description: A unique identifier assigned to each log entry in the dataset.
Log_Entry_Type
Type: STRING
Required: YES
Description: Indicates the type or category of the log entry.
iExchange_Oracle_Key
Type: STRING
Required: YES
Description: A key linking the log entry to corresponding data or transactions in the Oracle database within the iExchange system.
Member_ID
Type: STRING
Required: YES
Description: Identifier for the member or individual associated with the transaction or activity recorded in the log.
Program_ID
Type: STRING
Required: YES
Description: Identifier for the program or service associated with the transaction or activity recorded in the log.
Request_ID
Type: STRING
Required: YES
Description: Identifier for the specific request or action associated with the transaction or activity recorded in the log.
iExchange_Questionnaire_ID
Type: STRING
Required: YES
Description: Identifier for the questionnaire associated with the transaction or activity recorded in the log within the iExchange system.
iExchange_Outcome_Status
Type: STRING
Required: YES
Description: Status of the outcome or result associated with the transaction or activity recorded in the log within the iExchange system.
iExchange_Outcome_Status_Description
Type: STRING
Required: YES
Description: Description providing further details about the outcome or result associated with the transaction or activity recorded in the log within the iExchange system.
iExchange_Payer_Name
Type: STRING
Required: YES
Description: Name of the payer or insurance provider associated with the transaction or activity recorded in the log within the iExchange system.
User_ID
Type: STRING
Required: YES
Description: Identifier for the user who initiated or performed the transaction or activity recorded in the log.
User_Full_Name
Type: STRING
Required: YES
Description: Full name of the user who initiated or performed the transaction or activity recorded in the log.
iExchange_User_Type
Type: STRING
Required: YES
Description: Type or role of the user associated with the transaction or activity recorded in the log within the iExchange system.
iExchange_Group_ID
Type: STRING
Required: YES
Description: Identifier for the group or department associated with the transaction or activity recorded in the log within the iExchange system.\ See Dictionary iExchange Group table in the Dictionary Dataset Specification.
iExchange_Group_Name
Type: STRING
Required: YES
Description: Name of the group or department associated with the transaction or activity recorded in the log within the iExchange system.\ See Dictionary iExchange Group table in the Dictionary Dataset Specification.
Log_Timestamp
Type: TIMESTAMP
Required: YES
Description: Date and time when the log entry was recorded.
Transaction_Type
Type: STRING
Required: YES
Description: Type of transaction or activity recorded in the log, such as data access, modification, or deletion.\ See Dictionary Transaction Type table in the Dictionary Dataset Specification.
Transaction_Source
Type: STRING
Required: YES
Description: Source or origin of the transaction or activity recorded in the log.\ See Dictionary Transaction Source table in the Dictionary Dataset Specification.
Transaction_Source_Description
Type: STRING
Required: YES
Description: Description providing further details about the source or origin of the transaction or activity recorded in the log.\ See Dictionary Transaction Source table in the Dictionary Dataset Specification.
iExchange_CareWebQI Attributes
iExchange_CareWebQI
Type: STRUCT
Required: YES
Description: Specific identifier or reference related to CareWebQI within the iExchange system, associated with the transaction or activity recorded in the log.
iExchange_CareWebQI.Oracle_Key
Type: STRING
Required: YES
Description: A unique identifier used within the Oracle database to trace this particular record, ensuring traceability within system audits.
iExchange_CareWebQI.Episode_ID
Type: STRING
Required: YES
Description: The identifier for the healthcare episode related to the guideline check, linking this record to a specific patient encounter.
iExchange_CareWebQI.Guideline_Code
Type: STRING
Required: YES
Description: A code representing the specific healthcare guideline being checked, which helps categorize and reference the compliance criteria.
iExchange_CareWebQI.Criteria_Met
Type: BOOL
Required: YES
Description: A boolean indicator showing whether the healthcare service met the guideline criteria, crucial for compliance reporting.
Additional Attributes
iExchange_Calculated_Goal_Units
Type: INT64
Required: YES
Description: Indicates the calculated goal units associated with the transaction or activity recorded in the log within the iExchange system.
iExchange_Requested_Units
Type: INT64
Required: YES
Description: Indicates the requested units associated with the transaction or activity recorded in the log within the iExchange system.
iExchange_Version
Type: STRING
Required: YES
Description: Version or release of the iExchange system associated with the transaction or activity recorded in the log.
iExchange_InterQualConnect Attributes
iExchange_InterQualConnect
Type: STRUCT
Required: YES
Description: Indicates whether the transaction or activity recorded in the log involves InterQualConnect functionality within the iExchange system.
iExchange_InterQualConnect.Oracle_Key
Type: STRING
Required: YES
Description: A unique identifier used within the Oracle database to trace this particular record, ensuring traceability within system audits.
iExchange_InterQualConnect.Review_ID
Type: STRING
Required: YES
Description: The identifier for the specific review instance related to the healthcare product, linking this record to a particular assessment.
iExchange_InterQualConnect.Product
Type: STRING
Required: YES
Description: The name or type of healthcare product or service being reviewed, which helps categorize and reference the review criteria.
iExchange_InterQualConnect.Criteria_Met_Description
Type: STRING
Required: YES
Description: A description detailing the outcomes of the review and whether the specific criteria of the healthcare guidelines were met.
Timestamps
Created_Timestamp
Type: TIMESTAMP
Required: YES
Description: Date and time when the record associated with the log entry was created.
Last_Modified_Timestamp
Type: TIMESTAMP
Required: YES
Description: Date and time when the record associated with the log entry was last modified.
iExchange_Blocked_Members
iExchange_Blocked_Members
Type: ARRAY
Required: NO
Description: Indicates whether the member associated with the transaction or activity recorded in the log is blocked within the iExchange system.
HIPAA LOG Dataset Specification
Overview
The HIPAA LOG dataset contains detailed specifications for tracking and managing compliance records within the healthcare system. Each field in the dataset is designed to ensure traceability, operational accuracy, and compliance with HIPAA regulations.
Dataset Fields
Key
Required: YES
Type: INT64
Description: A unique identifier for each blocked member entry within the HIPAA raw data, ensuring distinct traceability and management of compliance records.
iExchange_Blocked_Members.Member_ID
Required: YES
Type: STRING
Description: The identifier of the member who has been blocked, linking this record to a specific individual within the healthcare system.
iExchange_Blocked_Members.Created_Timestamp
Required: YES
Type: TIMESTAMP
Description: Timestamp indicating when the record of the blocked member was first created, marking the initial time of the action.
iExchange_Blocked_Members.Last_Modified_Timestamp
Required: YES
Type: TIMESTAMP
Description: Timestamp indicating when the record of the blocked member was last updated, useful for tracking changes and maintaining current operational data.
Record_Last_Modified_Timestamp
Required: YES
Type: TIMESTAMP
Description: Date and time when the record associated with the log entry was last modified.
Transaction_User_ID
Required: YES
Type: STRING
Description: Identifier for the user who initiated or performed the transaction or activity recorded in the log.
Deleted_Indicator
Required: YES
Type: BOOL
Description: Indicator showing whether the record associated with the log entry has been marked as deleted.
Type
Required: YES
Type: STRING
Description: Type or category of the record associated with the log entry.
Tenant
Required: YES
Type: STRING
Description: Identifier for the tenant or client organization associated with the transaction or activity recorded in the log.
Active_Version
Required: YES
Type: BOOL
Description: Indicates the active version or status of the record associated with the log entry.
Date
Required: YES
Type: DATE
Description: Date associated with the transaction or activity recorded in the log.
Sequence
Required: YES
Type: INT64
Description: Sequence number or identifier associated with the transaction or activity recorded in the log.
Source_System_Name
Required: YES
Type: STRING
Description: Name of the source system from which the transaction or activity recorded in the log originated.
Source_Timestamp
Required: YES
Type: STRING
Description: Date and time when the transaction or activity recorded in the log originated in the source system.
Source_File_Name
Required: YES
Type: STRING
Description: Name of the source file from which the transaction or activity recorded in the log originated.
Schema_Version
Required: YES
Type: FLOAT64
Description: Version of the schema or data model associated with the transaction or activity recorded in the log.
Action
Required: YES
Type: STRING
Description: Action or operation performed as part of the transaction or activity recorded in the log.
Transaction_Actor_Type
Required: YES
Type: STRING
Description: Type of the actor performing the transaction.
Screening_Key
Required: YES
Type: STRING
Description: The key identifying the screening related to the log entry.