Rpc Dataset Specification
RPC Dataset Specification
Overview
The "RPC Dataset Specification" contains the most recent Right Party Contact (RPC) data for the member obtained from a data vendor. Each record corresponds to a single member, with memberId serving as its unique key. The dataset supports multiple functions in RPC operations and includes the following key components:
Member ID: Stores identifiers for members involved in RPC transactions, ensuring that each transaction is accurately logged and traceable to a specific user or system entity.
Timestamps: Includes creation and update timestamps for each RPC transaction, providing a chronological record that is essential for tracking changes and ensuring data integrity.
Provider Information: Captures details about the providers facilitating the RPC, including system or service identifiers, which helps in managing and auditing the sources of RPC requests.
Contact Details: Records contact information related to the RPC transactions, important for maintaining communication channels in case of issues or follow-up needs.
RPC Response Data: Contains additional data related to the responses from RPC transactions, such as status codes and messages, aiding in the analysis of transaction success and troubleshooting.
This dataset is vital for managing RPC-related data efficiently, supporting the robust functionality of RPC systems, and ensuring seamless interoperability and communication across different technological platforms.
RPC Data
Table Structure
Column Name | Is Nullable | Data Type | Description |
| YES | STRING | Unique identifier for a participant or patient within the system, used to track and associate with their medical records. |
| YES | TIMESTAMP | The date and time when the record was initially created, which helps to track when the information was first entered into the system. |
| YES | TIMESTAMP | The most recent date and time the record was updated, important for understanding the timeliness of the information. |
| YES | TIMESTAMP | The date and time when the data was received, indicating when information from a service provider was received. |
| YES | TIMESTAMP | The last date and time data was requested, reflecting when information for this participant was last sought. |
| NO | STRING | List of service providers who supplied the data, useful for assessing the source of information. |
| YES | STRING | The participant's first name, used for personal identification. |
| YES | STRING | The participant's middle name, which can be used for additional identification. |
| YES | STRING | The participant's last name, a key element in identification in medical and administrative records. |
| YES | STRING | The main living address of the participant, used for correspondence and emergency contacts. |
| YES | STRING | Additional address line, which may contain information about an apartment, building, or other address details. |
| YES | STRING | The city of the primary address, important for local health management and coordination. |
| YES | STRING | The state of the primary address, used for regional management and reporting. |
| YES | STRING | The zip code of the primary address, aiding in geographic segmentation and logistics. |
| YES | STRING | The main contact phone number for the participant, used for communication. |
| YES | STRING | The participant's email address, used for electronic communication. |
| YES | STRING | Raw data from the provider, containing detailed information received directly from the service source. |
RPC Data Attribute Map
Table Structure
Column Name | Is Nullable | Data Type | Description |
| YES | STRING | This is the unique identifier for each member within the system, used to link the attribute map data specifically to an individual. |
| NO | STRING | Lists the sources or providers of the attribute map data, indicating where the additional information originates. |
| YES | STRING | The first name of the member, which is part of the personal information included in the attribute map data. |
| YES | STRING | The middle name of the member, providing additional personal detail to help distinguish between individuals with similar names. |
| YES | STRING | The last name of the member, crucial for fully identifying the individual in the system. |
| YES | STRING | Represents the specific key or identifier for each piece of data in the attribute map, allowing for the categorization and retrieval of various data elements. |
| YES | STRING | The actual data or value associated with each key in the attribute map, containing detailed information about the member that is specific to the provider's data set. |
RPC Log
Table Structure
Column Name | Is Nullable | Data Type | Description |
| YES | STRING | Identifies the specific tenant or client within the platform, segregating data access and usage. |
| YES | STRING | The unique identifier for the member whose data is being logged, enabling tracking and analysis of individual member interactions. |
| YES | TIMESTAMP | The timestamp marking when the log entry was initially created, providing a chronological record of events. |
| YES | TIMESTAMP | The timestamp of the most recent update to the log entry, reflecting the latest changes or interactions. |
| YES | TIMESTAMP | The timestamp indicating when the RPC (Remote Procedure Call) data was received, helping to monitor data flow and latency. |
| YES | TIMESTAMP | The timestamp of the last request for the member’s data, useful for tracking frequency and timing of data access. |
| YES | STRING | The source or provider of the RPC data. |
RPC Dataset Specification
RPC Log
Overview
The RPC log contains structured data about members, including personal identifiers, contact information, and metadata. It facilitates identification, personalization, and data processing.
Fields
RPC_log.firstName
Is Nullable: YES
Data Type: STRING
Description: Personal identifier of the member, facilitating identification and personalization in data processing.
RPC_log.middleName
Is Nullable: YES
Data Type: STRING
Description: Personal identifier of the member, facilitating identification and personalization in data processing.
RPC_log.lastName
Is Nullable: YES
Data Type: STRING
Description: Personal identifier of the member, facilitating identification and personalization in data processing.
RPC_log.primaryAddress
Is Nullable: YES
Data Type: STRUCT
Description: Structured data including line 1, line 2, city, state, and zip code, providing comprehensive location details of the member.
Parameters:
primaryAddress.primaryAddressLine1
Is Nullable: YES
Data Type: STRING
Description: The main living address of the participant, used for correspondence and emergency contacts.
primaryAddress.primaryAddressLine2
Is Nullable: YES
Data Type: STRING
Description: Additional address line, which may contain information about an apartment, building, or other address details.
primaryAddress.primaryAddressCity
Is Nullable: YES
Data Type: STRING
Description: The city of the primary address, important for local health management and coordination.
primaryAddress.primaryAddressState
Is Nullable: YES
Data Type: STRING
Description: The state of the primary address, used for regional management and reporting.
primaryAddress.primaryAddressZip
Is Nullable: YES
Data Type: STRING
Description: The zip code of the primary address, aiding in geographic segmentation and logistics.
RPC_log.primaryPhone
Is Nullable: YES
Data Type: STRING
Description: The main contact number for the member, essential for communication and verification processes.
RPC_log.primaryEmail
Is Nullable: YES
Data Type: STRING
Description: The primary email address of the member, used for digital communication and notifications.
RPC_log.attributeMap
Is Nullable: NO
Data Type: ARRAY
Description: A complex data structure containing key-value pairs that represent additional attributes or metadata associated with the member, enhancing the detail and utility of the log data.
Parameters:
attributeMap.attributeMapKey
Is Nullable: YES
Data Type: STRING
Description: Represents the specific key or identifier for each piece of data in the attribute map, allowing for the categorization and retrieval of various data elements.
attributeMap.attributeMapValue
Is Nullable: YES
Data Type: STRING
Description: The actual data or value associated with each key in the attribute map, containing detailed information about the member that is specific to the provider's data set.
RPC_log.providerRawResponse
Is Nullable: YES
Data Type: STRING
Description: Contains the raw response data from the provider, offering an unprocessed view of the information received during the RPC.
RPC_log.date
Is Nullable: YES
Data Type: DATE
Description: The specific date on which the log entry was recorded, aiding in temporal analysis and historical context of the data.
RPC Data Raw
Overview
The RPC raw data table contains detailed information about members, including timestamps, identifiers, and structured data for tracking and analysis.
Fields
RPC_Data_raw.tenant
Is Nullable: YES
Data Type: STRING
Description: Identifies the tenant or client within the system, indicating ownership or scope of the raw data.
RPC_Data_raw.memberId
Is Nullable: YES
Data Type: STRING
Description: Unique identifier for the member, crucial for linking the raw data to a specific individual in the database.
RPC_Data_raw.createdAt
Is Nullable: YES
Data Type: TIMESTAMP
Description: Timestamp indicating when the raw data record was created, providing a chronological context.
RPC_Data_raw.lastUpdatedAt
Is Nullable: YES
Data Type: TIMESTAMP
Description: Timestamp showing the last time the raw data was updated, reflecting the most recent changes or interactions.
RPC_Data_raw.receivedAt
Is Nullable: YES
Data Type: TIMESTAMP
Description: Timestamp marking when the raw data was received from the source or provider, important for tracking data flow and timing.
RPC_Data_raw.lastRequestedAt
Is Nullable: YES
Data Type: TIMESTAMP
Description: Timestamp of when the raw data for the member was last requested, useful for monitoring data access frequency.
RPC_Data_raw.provider
Is Nullable: YES
Data Type: STRING
Description: The source or provider of the raw data, essential for source verification and data integrity analysis.
RPC_Data_raw.firstName
Is Nullable: YES
Data Type: STRING
Description: Components of the member's name, critical for personal identification and data organization.
RPC_Data_raw.middleName
Is Nullable: YES
Data Type: STRING
Description: Components of the member's name, critical for personal identification and data organization.
RPC_Data_raw.lastName
Is Nullable: YES
Data Type: STRING
Description: Components of the member's name, critical for personal identification and data organization.
RPC_Data_raw.primaryAddress
Is Nullable: YES
Data Type: STRUCT
Description: Structured data including line 1, line 2, city, state, and zip code, providing comprehensive location details of the member.
Parameters:
primaryAddress.primaryAddressLine1
Is Nullable: YES
Data Type: STRING
Description: The main living address of the participant, used for correspondence and emergency contacts.
primaryAddress.primaryAddressLine2
Is Nullable: YES
Data Type: STRING
Description: Additional address line, which may contain information about an apartment, building, or other address details.
primaryAddress.primaryAddressCity
Is Nullable: YES
Data Type: STRING
Description: The city of the primary address, important for local health management and coordination.
primaryAddress.primaryAddressState
Is Nullable: YES
Data Type: STRING
Description: The state of the primary address, used for regional management and reporting.
primaryAddress.primaryAddressZip
Is Nullable: YES
Data Type: STRING
Description: The zip code of the primary address, aiding in geographic segmentation and logistics.
RPC_Data_raw.primaryPhone
Is Nullable: YES
Data Type: STRING
Description: The primary contact phone number for the member, important for communication and verification processes.
RPC_Data_raw.primaryEmail
Is Nullable: YES
Data Type: STRING
Description: The main email address for the member, used for electronic communication and digital engagement tracking.
RPC_Data_raw.attributeMap
Is Nullable: NO
Data Type: ARRAY
Description: A complex data structure containing key-value pairs that represent additional attributes or metadata associated with the member, enhancing the detail and utility of the log data.
Parameters:
attributeMap.attributeMapKey
Is Nullable: YES
Data Type: STRING
Description: Represents the specific key or identifier for each piece of data in the attribute map, allowing for the categorization and retrieval of various data elements.
attributeMap.attributeMapValue
Is Nullable: YES
Data Type: STRING
Description: The actual data or value associated with each key in the attribute map, containing detailed information about the member that is specific to the provider's data set.
RPC_Data_raw.providerRawResponse
Is Nullable: YES
Data Type: STRING
Description: The unprocessed raw response data from the provider, offering an unfiltered view of the information received.
RPC Dataset Specification
Overview
The RPC dataset provides processed response data from the provider, offering a foundational view of the received information for in-depth analysis. It includes various attributes that facilitate efficient data management, tracking, and auditing.
RPC_Data Table
Description
The RPC_Data table contains detailed information about participants, providers, and transactions. It is designed to ensure accurate logging, traceability, and efficient management of RPC data.
Columns
Column Name | Is Nullable | Data Type | Description |
memberId | YES | STRING | Unique identifier for a participant or patient within the system, used to track and associate with their medical records. |
createdAt | YES | TIMESTAMP | The date and time when the record was initially created, which helps to track when the information was first entered into the system. |
lastUpdatedAt | YES | TIMESTAMP | The most recent date and time the record was updated, important for understanding the timeliness of the information. |
receivedAt | YES | TIMESTAMP | The date and time when the data was received, indicating when information from a service provider was received. |
lastRequestedAt | YES | TIMESTAMP | The last date and time data was requested, reflecting when information for this participant was last sought. |
provider | NO | STRING | List of service providers who supplied the data, useful for assessing the source of information. |
firstName | YES | STRING | The participant's first name, used for personal identification. |
middleName | YES | STRING | The participant's middle name, which can be used for additional identification. |
lastName | YES | STRING | The participant's last name, a key element in identification in medical and administrative records. |
primaryAddressLine1 | YES | STRING | The main living address of the participant, used for correspondence and emergency contacts. |
primaryAddressLine2 | YES | STRING | Additional address line, which may contain information about an apartment, building, or other address details. |
primaryAddressCity | YES | STRING | The city of the primary address, important for local health management and coordination. |
primaryAddressState | YES | STRING | The state of the primary address, used for regional management and reporting. |
primaryAddressZip | YES | STRING | The zip code of the primary address, aiding in geographic segmentation and logistics. |
primaryPhone | YES | STRING | The main contact phone number for the participant, used for communication. |
primaryEmail | YES | STRING | The participant's email address, used for electronic communication. |
providerRawResponse | YES | STRING | Raw data from the provider, containing detailed information received directly from the service source. |
RPC_Data_Attribute_Map Table
Description
The RPC_Data_Attribute_Map table provides a mapping of attributes associated with members, offering detailed data categorization and retrieval capabilities.
Columns
Column Name | Is Nullable | Data Type | Description |
memberId | YES | STRING | This is the unique identifier for each member within the system, used to link the attribute map data specifically to an individual. |
provider | NO | STRING | Lists the sources or providers of the attribute map data, indicating where the additional information originates. |
firstName | YES | STRING | The first name of the member, which is part of the personal information included in the attribute map data. |
middleName | YES | STRING | The middle name of the member, providing additional personal detail to help distinguish between individuals with similar names. |
lastName | YES | STRING | The last name of the member, crucial for fully identifying the individual in the system. |
attributeMapKey | YES | STRING | Represents the specific key or identifier for each piece of data in the attribute map, allowing for the categorization and retrieval of various data elements. |
attributeMapValue | YES | STRING | The actual data or value associated with each key in the attribute map, containing detailed information about the member that is specific to the provider's data set. |
RPC_log Table
Description
The RPC_log table captures detailed logs of RPC transactions, providing a chronological record of events and interactions for tracking and analysis.
Columns
Column Name | Is Nullable | Data Type | Description |
tenant | YES | STRING | Identifies the specific tenant or client within the platform, segregating data access and usage. |
memberId | YES | STRING | The unique identifier for the member whose data is being logged, enabling tracking and analysis of individual member interactions. |
createdAt | YES | TIMESTAMP | The timestamp marking when the log entry was initially created, providing a chronological record of events. |
lastUpdatedAt | YES | TIMESTAMP | The timestamp of the most recent update to the log entry, reflecting the latest changes or interactions. |
receivedAt | YES | TIMESTAMP | The timestamp indicating when the RPC (Remote Procedure Call) data was received, helping to monitor data flow and latency. |
Key Features of RPC Dataset
Member Partition: An integer representing a partitioning key used in data segmentation or distribution, facilitating efficient data management and query performance.
Member ID: Stores identifiers for members involved in RPC transactions, ensuring that each transaction is accurately logged and traceable to a specific user or system entity.
Timestamps: Includes creation and update timestamps for each RPC transaction, providing a chronological record that is essential for tracking changes and ensuring data integrity.
Provider Information: Captures details about the providers facilitating the RPC, including system or service identifiers, which helps in managing and auditing the sources of RPC requests.
Contact Details: Records contact information related to the RPC transactions, important for maintaining communication channels in case of issues or follow-up needs.
RPC Response Data: Contains additional data related to the responses from RPC transactions, such as status codes and messages, aiding in the analysis of transaction success and troubleshooting.
RPC Dataset Specification
RequestedAt
Is Nullable: YES
Data Type: TIMESTAMP
Description: The timestamp of the last request for the member’s data, useful for tracking frequency and timing of data access.
RPC_log
provider
Is Nullable: YES
Data Type: STRING
Description: The source or provider of the RPC data, indicating the origin of the logged information.
firstName
Is Nullable: YES
Data Type: STRING
Description: Personal identifiers of the member, facilitating identification and personalization in data processing.
middleName
Is Nullable: YES
Data Type: STRING
Description: Personal identifiers of the member, facilitating identification and personalization in data processing.
lastName
Is Nullable: YES
Data Type: STRING
Description: Personal identifiers of the member, facilitating identification and personalization in data processing.
primaryAddress
Is Nullable: YES
Data Type: STRUCT
Description: Structured data including line 1, line 2, city, state, and zip code, providing comprehensive location details of the member.\ See below for detailed information on each parameter in the structure.
primaryAddress.primaryAddressLine1
Is Nullable: YES
Data Type: STRING
Description: The main living address of the participant, used for correspondence and emergency contacts.
primaryAddress.primaryAddressLine2
Is Nullable: YES
Data Type: STRING
Description: Additional address line, which may contain information about an apartment, building, or other address details.
primaryAddress.primaryAddressCity
Is Nullable: YES
Data Type: STRING
Description: The city of the primary address, important for local health management and coordination.
primaryAddress.primaryAddressState
Is Nullable: YES
Data Type: STRING
Description: The state of the primary address, used for regional management and reporting.
primaryAddress.primaryAddressZip
Is Nullable: YES
Data Type: STRING
Description: The zip code of the primary address, aiding in geographic segmentation and logistics.
primaryPhone
Is Nullable: YES
Data Type: STRING
Description: The main contact number for the member, essential for communication and verification processes.
primaryEmail
Is Nullable: YES
Data Type: STRING
Description: The primary email address of the member, used for digital communication and notifications.
attributeMap
Is Nullable: NO
Data Type: ARRAY
Description: A complex data structure containing key-value pairs that represent additional attributes or metadata associated with the member, enhancing the detail and utility of the log data.\ See below for detailed information on each parameter in the array.
attributeMap.attributeMapKey
Is Nullable: YES
Data Type: STRING
Description: Represents the specific key or identifier for each piece of data in the attribute map, allowing for the categorization and retrieval of various data elements.
attributeMap.attributeMapValue
Is Nullable: YES
Data Type: STRING
Description: The actual data or value associated with each key in the attribute map, containing detailed information about the member that is specific to the provider's data set.
providerRawResponse
Is Nullable: YES
Data Type: STRING
Description: Contains the raw response data from the provider, offering an unprocessed view of the information received during the RPC.
date
Is Nullable: YES
Data Type: DATE
Description: The specific date on which the log entry was recorded, aiding in temporal analysis and historical context of the data.
Table Content
RPC_Data_raw
tenant
Is Nullable: YES
Data Type: STRING
Description: Identifies the tenant or client within the system, indicating ownership or scope of the raw data.
memberId
Is Nullable: YES
Data Type: STRING
Description: Unique identifier for the member, crucial for linking the raw data to a specific individual in the database.
createdAt
Is Nullable: YES
Data Type: TIMESTAMP
Description: Timestamp indicating when the raw data record was created, providing a chronological context.
lastUpdatedAt
Is Nullable: YES
Data Type: TIMESTAMP
Description: Timestamp showing the last time the raw data was updated, reflecting the most recent changes or interactions.
receivedAt
Is Nullable: YES
Data Type: TIMESTAMP
Description: Timestamp marking when the raw data was received from the source or provider, important for tracking data flow and timing.
lastRequestedAt
Is Nullable: YES
Data Type: TIMESTAMP
Description: Timestamp of when the raw data for the member was last requested, useful for monitoring data access frequency.
provider
Is Nullable: YES
Data Type: STRING
Description: The source or provider of the raw data, essential for source verification and data integrity analysis.
firstName
Is Nullable: YES
Data Type: STRING
Description: Components of the member's name, critical for personal identification and data organization.
middleName
Is Nullable: YES
Data Type: STRING
Description: Components of the member's name, critical for personal identification and data organization.
lastName
Is Nullable: YES
Data Type: STRING
Description: Components of the member's name, critical for personal identification and data organization.
primaryAddress
Is Nullable: YES
Data Type: STRUCT
Description: Structured data including line 1, line 2, city, state, and zip code, providing comprehensive location details of the member.\ See below for detailed information on each parameter in the structure.
primaryAddress.primaryAddressLine1
Is Nullable: YES
Data Type: STRING
Description: The main living address of the participant, used for correspondence and emergency contacts.
primaryAddress.primaryAddressLine2
Is Nullable: YES
Data Type: STRING
Description: Additional address line, which may contain information about an apartment, building, or other address details.
primaryAddress.primaryAddressCity
Is Nullable: YES
Data Type: STRING
Description: The city of the primary address, important for local health management and coordination.
primaryAddress.primaryAddressState
Is Nullable: YES
Data Type: STRING
Description: The state of the primary address, used for regional management and reporting.
primaryAddress.primaryAddressZip
Is Nullable: YES
Data Type: STRING
Description: The zip code of the primary address, aiding in geographic segmentation and logistics.
primaryPhone
Is Nullable: YES
Data Type: STRING
Description: The primary contact phone number for the member, important for communication and verification processes.
primaryEmail
Is Nullable: YES
Data Type: STRING
Description: The main email address for the member, used for electronic communication and digital engagement tracking.
attributeMap
Is Nullable: NO
Data Type: ARRAY
Description: A complex data structure containing key-value pairs that represent additional attributes or metadata associated with the member, enhancing the detail and utility of the raw data.\ See below for detailed information on each parameter in the array.
attributeMap.attributeMapKey
Is Nullable: YES
Data Type: STRING
Description: Represents the specific key or identifier for each piece of data in the attribute map, allowing for the categorization and retrieval of various data elements.
attributeMap.attributeMapValue
Is Nullable: YES
Data Type: STRING
Description: The actual data or value associated with each key in the attribute map, containing detailed information about the member that is specific to the provider's data set.
RPC Dataset Specification
Attribute Map Parameters
attributeMap.attributeMapKey
Required: YES
Type: STRING
Description: Represents the specific key or identifier for each piece of data in the attribute map, allowing for the categorization and retrieval of various data elements.
attributeMap.attributeMapValue
Required: YES
Type: STRING
Description: The actual data or value associated with each key in the attribute map, containing detailed information about the member that is specific to the provider's data set.
RPC Data Raw Parameters
providerRawResponse
Required: YES
Type: STRING
Description: The unprocessed response data from the provider, offering a foundational view of the received information for in-depth analysis.
memberPartition
Required: YES
Type: INT64
Description: An integer representing a partitioning key used in data segmentation or distribution, facilitating efficient data management and query performance.