Skip to main content

iExchange Dataset Specification

Updated over a month ago

iExchange Dataset Specification

IExchange Dataset Specification

IExchange Blocked Members

Table Structure

Table Name

Column Name

Is Nullable

Data Type

Description

IExchange_Blocked_Members

Log_Entry_Key

YES

INT64

Unique identifier for each log entry or record related to blocked members.

IExchange_Blocked_Members

Blocked_Member_Key

YES

INT64

Unique identifier for each blocked member within the dataset.

IExchange_Blocked_Members

Member_ID

YES

STRING

Identifier for the specific member associated with the blocked entry.

IExchange_Blocked_Members

Created_Timestamp

YES

TIMESTAMP

Timestamp indicating when the blocked entry was created or logged.

IExchange_Blocked_Members

Last_Modified_Timestamp

YES

TIMESTAMP

Timestamp indicating the last modification of the blocked entry.

IExchange Transactions

Table Structure

Table Name

Column Name

Is Nullable

Data Type

Description

IExchange_Transactions

Log_Entry_Key

YES

STRING

Unique identifier for each log entry or record related to blocked members.

IExchange_Transactions

Member_ID

YES

STRING

Identifier for the specific member associated with the transaction.

IExchange_Transactions

Request_ID

YES

STRING

Unique identifier for each specific request associated with transactions.

IExchange_Transactions

Primary_Request_Diagnosis_Key

YES

STRING

Key associated with the primary diagnosis related to the request.

IExchange_Transactions

Item_Detail_Key

YES

INT64

Key associated with specific item details within the transaction.

IExchange_Transactions

Outcome_Status

YES

STRING

Status or outcome of the transaction (e.g., approved, denied, pending).

IExchange_Transactions

Outcome_Status_Description

YES

STRING

Description of the outcome status (e.g., “Approved by reviewer”).

IExchange_Transactions

Payer_Name

YES

STRING

Name of the payer or insurance company associated with the transaction.

IExchange_Transactions

Oracle_Key

YES

STRING

Unique identifier related to Oracle systems or processes.

IExchange_Transactions

Calculated_Goal_Units

YES

STRING

Calculated goal units or targets for the transaction (if applicable).

IExchange_Transactions

CareWebQI_Oracle_Key

YES

STRING

Key associated with CareWebQI processes or records.

IExchange_Transactions

CareWebQI_Episode_ID

YES

STRING

Identifier for the specific episode or case within CareWebQI.

IExchange_Transactions

CareWebQI_Guideline_Code

YES

STRING

Code representing a specific guideline or protocol within CareWebQI.

IExchange_Transactions

CareWebQI_Guideline_Name

YES

STRING

Name or label of the guideline or protocol within CareWebQI.

IExchange_Transactions

CareWebQI_Status_Code

YES

STRING

Code representing the status of the transaction within CareWebQI.

IExchange_Transactions

CareWebQI_Status_Description

YES

STRING

Description of the status of the transaction within CareWebQI.

IExchange_Transactions

Questionnaire_ID

YES

STRING

Identifier for the specific questionnaire associated with the transaction.

IExchange_Transactions

User_Type

YES

STRING

Type of user (e.g., reviewer, administrator) associated with the transaction.

IExchange_Transactions

iExchange_Group_ID

YES

STRING

Identifier for the specific group or category within iExchange.

IExchange_Transactions

iExchange_Group_Name

YES

STRING

Name or label of the group or category within iExchange.

IExchange_Transactions

Version

YES

STRING

Version or release number associated with the transaction.

IExchange_Transactions

InterQualConnect_Oracle_Key

YES

STRING

Key associated with InterQualConnect processes or records.

IExchange_Transactions

InterQualConnect_Review_ID

YES

INT64

Identifier for the specific review or assessment within InterQualConnect.

IExchange_Transactions

InterQualConnect_Product

YES

STRING

Product or service associated with the transaction within InterQualConnect.

IExchange_Transactions

InterQualConnect_Product_Description

YES

STRING

Description of the product or service within InterQualConnect.

IExchange_Transactions

InterQualConnect_Criteria_Met

YES

TIMESTAMP

Indicator (e.g., Yes/No) whether the criteria were met for the transaction.

IExchange_Transactions

InterQualConnect_Criteria_Met_Description

YES

DATE

Description of whether the criteria were met (e.g., “Met criteria”).

IExchange_Transactions

iExchange_Requested_Units

YES

STRING

Units or quantities requested for the transaction within iExchange.

IExchange_Transactions

User_ID

YES

STRING

Unique identifier for the user associated with the transaction.

IExchange_Transactions

User_Full_Name

YES

STRING

Full name of the user associated with the transaction.

IExchange_Transactions

Log_Timestamp

YES

STRING

Timestamp indicating when the log entry was recorded.

IExchange_Transactions

Log_Date

YES

TIMESTAMP

Date associated with the log entry.

IExchange_Transactions

Transaction_Source

YES

TIMESTAMP

Source or origin of the transaction (e.g., web portal, mobile app).

IExchange_Transactions

Transaction_Source_Description

YES

STRING

Description of the transaction source (e.g., “Submitted via mobile app”).

IExchange_Transactions

Transaction_Type

YES

TIMESTAMP

Type or category of the transaction (e.g., medical claim, authorization).

IExchange_Transactions

Transaction_Type_Description

YES

TIMESTAMP

Description of the transaction type (e.g., “Medical claim submission”).

IExchange Dataset Specification

Log Entry Key

  • Field Name: Log_Entry_Key

  • Required: YES

  • Data Type: STRING

  • Description: Unique identifier for each log entry or record related to blocked members.

IExchange Transactions

Member Information

  • Field Name: Member_ID

  • Required: YES

  • Data Type: STRING

  • Description: Identifier for the specific member associated with the transaction.

Request Information

  • Field Name: Request_ID

  • Required: YES

  • Data Type: STRING

  • Description: Unique identifier for each specific request associated with transactions.

  • Field Name: Primary_Request_Diagnosis_Key

  • Required: YES

  • Data Type: STRING

  • Description: Key associated with the primary diagnosis related to the request.

Item Details

  • Field Name: Item_Detail_Key

  • Required: YES

  • Data Type: INT64

  • Description: Key associated with specific item details within the transaction.

Outcome Information

  • Field Name: Outcome_Status

  • Required: YES

  • Data Type: STRING

  • Description: Status or outcome of the transaction (e.g., approved, denied, pending).

  • Field Name: Outcome_Status_Description

  • Required: YES

  • Data Type: STRING

  • Description: Description of the outcome status (e.g., “Approved by reviewer”).

Payer Information

  • Field Name: Payer_Name

  • Required: YES

  • Data Type: STRING

  • Description: Name of the payer or insurance company associated with the transaction.

Oracle Information

  • Field Name: Oracle_Key

  • Required: YES

  • Data Type: STRING

  • Description: Unique identifier related to Oracle systems or processes.

Calculated Goals

  • Field Name: Calculated_Goal_Units

  • Required: YES

  • Data Type: STRING

  • Description: Calculated goal units or targets for the transaction (if applicable).

CareWebQI Information

Episode Details

  • Field Name: CareWebQI_Oracle_Key

  • Required: YES

  • Data Type: STRING

  • Description: Key associated with CareWebQI processes or records.

  • Field Name: CareWebQI_Episode_ID

  • Required: YES

  • Data Type: STRING

  • Description: Identifier for the specific episode or case within CareWebQI.

Guidelines

  • Field Name: CareWebQI_Guideline_Code

  • Required: YES

  • Data Type: STRING

  • Description: Code representing a specific guideline or protocol within CareWebQI.

  • Field Name: CareWebQI_Guideline_Name

  • Required: YES

  • Data Type: STRING

  • Description: Name or label of the guideline or protocol within CareWebQI.

Status Information

  • Field Name: CareWebQI_Status_Code

  • Required: YES

  • Data Type: STRING

  • Description: Code representing the status of the transaction within CareWebQI.

  • Field Name: CareWebQI_Status_Description

  • Required: YES

  • Data Type: STRING

  • Description: Description of the status of the transaction within CareWebQI.

Questionnaire Information

  • Field Name: Questionnaire_ID

  • Required: YES

  • Data Type: STRING

  • Description: Identifier for the specific questionnaire associated with the transaction.

User Information

User Type

  • Field Name: User_Type

  • Required: YES

  • Data Type: STRING

  • Description: Type of user (e.g., reviewer, administrator) associated with the transaction.

User Details

  • Field Name: User_ID

  • Required: YES

  • Data Type: STRING

  • Description: Unique identifier for the user associated with the transaction.

  • Field Name: User_Full_Name

  • Required: YES

  • Data Type: STRING

  • Description: Full name of the user associated with the transaction.

iExchange Group Information

Group Details

  • Field Name: iExchange_Group_ID

  • Required: YES

  • Data Type: STRING

  • Description: Identifier for the specific group or category within iExchange.

  • Field Name: iExchange_Group_Name

  • Required: YES

  • Data Type: STRING

  • Description: Name or label of the group or category within iExchange.

Version Information

  • Field Name: Version

  • Required: YES

  • Data Type: STRING

  • Description: Version or release number associated with the transaction.

InterQualConnect Information

Oracle Details

  • Field Name: InterQualConnect_Oracle_Key

  • Required: YES

  • Data Type: STRING

  • Description: Key associated with InterQualConnect processes or records.

Review Information

  • Field Name: InterQualConnect_Review_ID

  • Required: YES

  • Data Type: INT64

  • Description: Identifier for the specific review or assessment within InterQualConnect.

Product Information

  • Field Name: InterQualConnect_Product

  • Required: YES

  • Data Type: STRING

  • Description: Product or service associated with the transaction within InterQualConnect.

  • Field Name: InterQualConnect_Product_Description

  • Required: YES

  • Data Type: STRING

  • Description: Description of the product or service within InterQualConnect.

Criteria Information

  • Field Name: InterQualConnect_Criteria_Met

  • Required: YES

  • Data Type: TIMESTAMP

  • Description: Indicator (e.g., Yes/No) whether the criteria were met for the transaction.

  • Field Name: InterQualConnect_Criteria_Met_Description

  • Required: YES

  • Data Type: DATE

  • Description: Description of whether the criteria were met (e.g., “Met criteria”).

iExchange Requested Units

  • Field Name: iExchange_Requested_Units

  • Required: YES

  • Data Type: STRING

  • Description: Units or quantities requested for the transaction within iExchange.

Logging Information

Timestamp and Date

  • Field Name: Log_Timestamp

  • Required: YES

  • Data Type: STRING

  • Description: Timestamp indicating when the log entry was recorded.

  • Field Name: Log_Date

  • Required: YES

  • Data Type: TIMESTAMP

  • Description: Date associated with the log entry.

Transaction Information

Source Details

  • Field Name: Transaction_Source

  • Required: YES

  • Data Type: TIMESTAMP

  • Description: Source or origin of the transaction (e.g., web portal, mobile app).

  • Field Name: Transaction_Source_Description

  • Required: YES

  • Data Type: STRING

  • Description: Description of the transaction source (e.g., “Submitted via mobile app”).

Type Details

  • Field Name: Transaction_Type

  • Required: YES

  • Data Type: TIMESTAMP

  • Description: Type or category of the transaction (e.g., medical claim, authorization).

  • Field Name: Transaction_Type_Description

  • Required: YES

  • Data Type: TIMESTAMP

  • Description: Description of the transaction type (e.g., “Medical claim submission”).

Related Articles
Educational Material Dataset Specification
HIPAA LOG Dataset Specification
Assessment Dataset Specification
Questionnaire Dataset Specification
Cost Dataset Specification
Did this answer your question?