Skip to main content

Fax Dataset Specification

Updated over a month ago

Fax Dataset Specification

Fax Dataset Specification

The "Fax Dataset Specification" provides a structured approach to managing and tracking the lifecycle of faxes within an organization. This dataset is essential for organizations that rely on fax communications for documentation, legal, or operational purposes, ensuring that all fax activities are meticulously recorded and easily accessible.

Key Elements of the Dataset

Fax Records

  • Stores comprehensive details of each fax transmission, including:

  • Sender and receiver information

  • Date and time of sending

  • Contents of the fax

  • Ensures that each communication is documented for future reference.

Fax Activity Log

  • Tracks the status and history of fax transactions.

  • Records activities such as:

  • When a fax was sent

  • When a fax was received

  • Issues during transmission

  • Provides a detailed audit trail of fax communications.

Fax Raw Data

  • Contains unprocessed, detailed data of fax transmissions.

  • Captures all raw information associated with faxes.

  • Crucial for in-depth analysis and auditing purposes.

This dataset plays a critical role in the effective management of fax communications, helping organizations maintain a reliable and traceable record of their fax transactions.

Table Specification

Fax Table

Column Name

Is Nullable

Data Type

Description

Fax_Key

YES

INT64

Unique identifier for the fax.

Sender

YES

STRUCT

Name or identifier of the sender.

Sender.Key

YES

INT64

Unique identifier for each sender entry within the fax log.

Sender.Fax_Number

YES

STRING

Fax number associated with the sender.

Sender.Created_Timestamp

YES

TIMESTAMP

Timestamp indicating when the sender record was first created.

Sender.Last_Modified_Timestamp

YES

TIMESTAMP

Timestamp indicating when the sender record was last updated.

Sender_Key

YES

INT64

Key identifying the sender.

Sending_Fax_Number

YES

STRING

Fax number from which the fax is sent.

Sender_Created_Timestamp

YES

TIMESTAMP

Timestamp when sender information was created.

Sender_Last_Modified_Timestamp

YES

TIMESTAMP

Timestamp when sender information was last modified.

File_Name

YES

STRING

Name of the fax file.

File_Type

YES

STRING

Type of the fax file.

File_Size

YES

STRING

Size of the fax file.

File_Size_Bytes

YES

INT64

Size of the fax file in bytes.

Page_Count

YES

INT64

Number of pages in the fax.

File_URL

YES

STRING

URL link to access the fax file.

Status

YES

STRING

Current status of the fax.

Status_Description

YES

STRING

Description of the fax status.

Status_Timestamp

YES

TIMESTAMP

Timestamp of the fax status.

Incoming_Timestamp

YES

TIMESTAMP

Timestamp when the fax was received.

Receiving_Fax_Number_Key

YES

INT64

Key identifying the receiving fax number.

Receiving_Fax_Number

YES

STRING

Fax number of the recipient.

Receiving_Department_Key

YES

INT64

Key identifying the receiving department.

Receiving_Department_ID

YES

STRING

ID of the receiving department.

Receiving_Department_Name

YES

STRING

Name of the receiving department. Maps to Department.Department_Name.

Receiving_Created_Timestamp

YES

TIMESTAMP

Timestamp when receiving information was created.

Receiving_Last_Modified_Timestamp

YES

TIMESTAMP

Timestamp when receiving information was last modified.

Assignment_Key

YES

INT64

Key identifying the assignment related to the fax.

Assignee_ID

YES

STRING

ID of the assignee associated with the fax.

Assignee_Name

YES

STRING

Full name of the assignee associated with the fax.

Assignee_Type

YES

STRING

Type of the assignee responsible for the fax.

Assignee_Department_Priority

YES

INT64

Priority of the assignee department.

Assigned_Timestamp

YES

TIMESTAMP

Timestamp when the fax was assigned.

Assignment_Created_User_ID

YES

STRING

ID of the user who created the assignment.

Assignment_Created_User_Name

YES

STRING

Name of the user who created the assignment. Maps to User.Full_Name.

Assignment_Created_Timestamp

YES

TIMESTAMP

Timestamp when the assignment was created.

Assignment_Last_Modified_User_ID

YES

STRING

ID of the user who last modified the assignment.

Assignment_Last_Modified_User_Name

YES

STRING

Name of the user who last modified the assignment. Maps to User.Full_Name.

Assignment_Last_Modified_Timestamp

YES

TIMESTAMP

Timestamp when the assignment was last modified.

Follow_Up_Key

YES

INT64

Key identifying the follow-up related to the fax.

Follow_Up_Description

YES

STRING

Description of the follow-up action.

Follow_Up_Reason

YES

STRING

Reason for the follow-up.

Follow_Up_Reason_Description

YES

STRING

Description of the follow-up reason.

Follow_Up_Time_Zone_Code

YES

STRING

Time zone code for the follow-up.

Follow_Up_Follow_Up_Timestamp

YES

TIMESTAMP

Timestamp for the follow-up action.

Follow_Up_Created_User_ID

YES

STRING

ID of the user who created the follow-up.

Follow_Up_Created_User_Name

YES

STRING

Name of the user who created the follow-up. Maps to User.Full_Name.

Follow_Up_Created_Timestamp

YES

TIMESTAMP

Timestamp when the follow-up was created.

Follow_Up_Last_Modified_User_ID

YES

STRING

ID of the user who last modified the follow-up.

Follow_Up_Last_Modified_User_Name

YES

STRING

Name of the user who last modified the follow-up. Maps to User.Full_Name.

Follow_Up_Last_Modified_Timestamp

YES

TIMESTAMP

Timestamp when the follow-up was last modified.

Fax Dataset Specification

Timestamp

  • Timestamp: Timestamp when the follow-up was last modified.

Fax Archive

Columns

  • Archive_Key:

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Key identifying the archived fax.

  • Archive_Action:

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Action taken for archiving the fax.

  • Archive_Created_User_ID:

  • Is Nullable: YES

  • Data Type: STRING

  • Description: ID of the user who created the archive.

  • Archive_Created_User_Name:

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the user who created the archive. Maps to User.Full_Name.

  • Archive_Created_Timestamp:

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the archive was created.

  • Archive_Last_Modified_User_ID:

  • Is Nullable: YES

  • Data Type: STRING

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

  • Archive_Last_Modified_User_Name:

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the user who last modified the archive. Maps to User.Full_Name.

  • Archive_Last_Modified_Timestamp:

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the archive was last modified.

Fax Escalation

Columns

  • Escalation_Key:

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for the escalation.

  • Escalation_Reason:

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Reason for the escalation.

  • Escalation_Reason_Description:

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the escalation reason.

  • Escalation_Requester_Name:

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the requester for escalation.

  • Escalation_Requester_Phone_Number:

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Phone number of the requester for escalation.

  • Escalation_Created_User_ID:

  • Is Nullable: YES

  • Data Type: STRING

  • Description: ID of the user who created the escalation.

  • Escalation_Created_User_Name:

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the user who created the escalation. Maps to User.Full_Name.

  • Escalation_Created_Timestamp:

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the escalation was created.

  • Escalation_Last_Modified_User_ID:

  • Is Nullable: YES

  • Data Type: STRING

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

  • Escalation_Last_Modified_User_Name:

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the user who last modified the escalation. Maps to User.Full_Name.

  • Escalation_Last_Modified_Timestamp:

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the escalation was last modified.

Fax Processing Information

Columns

  • Processing_Information_Key:

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Key identifying the processing information.

  • Processing_Information_Request_ID:

  • Is Nullable: YES

  • Data Type: STRING

  • Description: ID of the request associated with processing information.

  • Processing_Information_Action:

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Action related to processing information.

  • Processing_Information_Created_User_ID:

  • Is Nullable: YES

  • Data Type: STRING

  • Description: ID of the user who created the processing information.

  • Processing_Information_Created_User_Name:

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the user who created the processing information. Maps to User.Full_Name.

  • Processing_Information_Created_Timestamp:

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when processing information was created.

  • Processing_Information_Last_Modified_User_ID:

  • Is Nullable: YES

  • Data Type: STRING

  • Description: ID of the user who last modified processing information.

  • Processing_Information_Last_Modified_User_Name:

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the user who last modified processing information. Maps to User.Full_Name.

  • Processing_Information_Last_Modified_Timestamp:

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when processing information was last modified.

Fax Record Metadata

Columns

  • Created_Timestamp:

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the record was created.

  • Last_Modified_Timestamp:

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the record was last modified.

  • Days_To_Process:

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Number of days between the creation of the processing information for the fax (Fax.Processing_Information.Created_Timestamp) and the incoming timestamp of the fax (Fax.Incoming_Timestamp).

Fax Log

Columns

  • Fax_Key:

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for the fax record.

  • Sender:

  • Sender.Key:

    • Is Nullable: YES

    • Data Type: INT64

    • Description: A unique identifier for each sender entry within the fax log, ensuring distinct traceability of fax communication records.

  • Sender.Fax_Number:

    • Is Nullable: YES

    • Data Type: STRING

    • Description: The fax number associated with the sender, used to identify the origin of fax communications within the healthcare system.

  • Sender.Created_Timestamp:

    • Is Nullable: YES

    • Data Type: TIMESTAMP

    • Description: Timestamp indicating when the sender record was first created, marking the establishment of the fax number within the system.

  • Sender.Last_Modified_Timestamp:

    • Is Nullable: YES

    • Data Type: TIMESTAMP

    • Description: Timestamp indicating when the sender record was last updated, useful for tracking changes and maintaining current contact details.

  • File_Name:

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the fax file.

  • File_Type:

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of the fax file.

  • File_Size:

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Size of the fax file.

  • File_Size_Bytes:

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Size of the fax file in bytes.

  • Page_Count:

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Number of pages in the fax.

  • File_URL:

  • Is Nullable: YES

  • Data Type: STRING

  • Description: URL or location of the fax file.

  • Status:

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Status of the fax transmission.

  • Status_Description:

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the fax status.

  • Status_Timestamp:

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the fax status was updated.

  • Incoming_Timestamp:

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the fax was received.

  • Receiving:

  • Receiving.Fax_Number_Key:

    • Is Nullable: YES

    • Data Type: INT64

    • Description: A unique identifier for each receiver entry within the fax log, ensuring distinct traceability of fax communication records.

  • Receiving.Fax_Number:

    • Is Nullable: YES

    • Data Type: STRING

    • Description: The fax number associated with the receiving end, used to identify the destination of fax communications within the healthcare system.

  • Receiving.Department_Key:

    • Is Nullable: YES

    • Data Type: INT64

    • Description: A unique identifier linking the fax number to a specific department, facilitating categorization and routing of communications.

  • Receiving.Department_ID:

    • Is Nullable: YES

    • Data Type: STRING

    • Description: The identifier of the department receiving the fax, providing clarity on the departmental allocation within the healthcare system.

  • Receiving.Created_Timestamp:

    • Is Nullable: YES

    • Data Type: TIMESTAMP

    • Description: Timestamp indicating when the receiving record was first created, marking the establishment or update of the fax number within the system.

  • Receiving.Last_Modified_Timestamp:

    • Is Nullable: YES

    • Data Type: TIMESTAMP

    • Description: Timestamp indicating when the receiving record was last updated, useful for tracking changes and maintaining current departmental contact details.

  • Assignment:

  • Assignment.Key:

    • Is Nullable: YES

    • Data Type: INT64

    • Description: A unique identifier for each assignment entry within the fax log, ensuring distinct traceability of user and department assignments.

  • Assignment.User_ID:

    • Is Nullable: YES

    • Data Type: STRING

    • Description: The identifier of the user assigned to the fax.

Fax Dataset Specification

Assignment

Assignment.User_Type

  • Required: YES

  • Type: STRING

  • Description: The type of user, which categorizes the user's role or level of access within the healthcare system, such as administrator, physician, or nurse.

Assignment.Department_Key

  • Required: YES

  • Type: INT64

  • Description: A unique identifier that links the assignment to a specific department, facilitating organizational management and internal routing.

Assignment.Department_ID

  • Required: YES

  • Type: STRING

  • Description: The identifier of the department involved in the fax communication, providing clarity on the departmental allocation within the healthcare system.

Assignment.Department_Priority

  • Required: YES

  • Type: INT64

  • Description: A numerical value indicating the priority level of the department in operational or emergency contexts, which can prioritize communication handling.

Assignment.Assigned_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp indicating when the user or department was assigned to the fax, marking the specific time of operational delegation.

Assignment.Created_User_ID

  • Required: YES

  • Type: STRING

  • Description: The identifier of the user who created the assignment record, ensuring accountability and traceability of record initiation.

Assignment.Created_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp indicating when the assignment record was first created, providing a timeline for the establishment of responsibilities.

Assignment.Last_Modified_User_ID

  • Required: YES

  • Type: STRING

  • Description: The identifier of the user who last modified the assignment record, useful for tracking changes and maintaining accountability.

Assignment.Last_Modified_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp indicating when the assignment record was last updated, useful for monitoring updates and ensuring current operational data.

Fax Log

Follow-Up

Follow_Up.Key

  • Required: YES

  • Type: INT64

  • Description: A unique identifier for each follow-up entry within the fax log, ensuring distinct traceability of follow-up actions.

Follow_Up.Description

  • Required: YES

  • Type: STRING

  • Description: A brief description of the follow-up action required or taken, providing an overview of the follow-up's purpose.

Follow_Up.Reason_Key

  • Required: YES

  • Type: INT64

  • Description: A unique identifier linking the follow-up to a specific reason, facilitating detailed categorization and response tracking.

Follow_Up.Reason

  • Required: YES

  • Type: STRING

  • Description: The reason code associated with the follow-up, used to classify and manage follow-up activities based on predefined categories.

Follow_Up.Reason_Description

  • Required: YES

  • Type: STRING

  • Description: A detailed description of the reason for the follow-up, offering clarity on the nature of the follow-up and its context within healthcare operations.

Follow_Up.Time_Zone_Code

  • Required: YES

  • Type: STRING

  • Description: The time zone code applicable to the follow-up timestamp, ensuring accurate scheduling and timing of follow-up activities across different regions.

Follow_Up.Follow_Up_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp indicating when the follow-up action is scheduled to occur or was completed, marking the specific timing of the action.

Follow_Up.Created_User_ID

  • Required: YES

  • Type: STRING

  • Description: The identifier of the user who created the follow-up record, ensuring accountability and traceability of record initiation.

Follow_Up.Created_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp indicating when the follow-up record was first created, providing a timeline for the establishment of follow-up actions.

Follow_Up.Last_Modified_User_ID

  • Required: YES

  • Type: STRING

  • Description: The identifier of the user who last modified the follow-up record, useful for tracking changes and maintaining accountability.

Follow_Up.Last_Modified_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp indicating when the follow-up record was last updated, useful for monitoring updates and ensuring current operational data.

Archive

Archive.Key

  • Required: YES

  • Type: INT64

  • Description: A unique identifier for each archival entry within the fax log, ensuring distinct traceability of archival records.

Archive.Action

  • Required: YES

  • Type: STRING

  • Description: The specific action taken during the archival process, such as 'store', 'delete', or 'retrieve', detailing the nature of the archival activity.

Archive.Created_User_ID

  • Required: YES

  • Type: STRING

  • Description: The identifier of the user who created the archival record, ensuring accountability and traceability of the action initiation.

Archive.Created_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp indicating when the archival record was first created, marking the initial time of the archival action.

Archive.Last_Modified_User_ID

  • Required: YES

  • Type: STRING

  • Description: The identifier of the user who last modified the archival record, useful for tracking changes and maintaining accountability.

Archive.Last_Modified_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp indicating when the archival record was last updated, useful for monitoring updates and ensuring current operational data for compliance.

Escalation

Escalation.Key

  • Required: YES

  • Type: INT64

  • Description: A unique identifier for each escalation entry within the fax log, ensuring distinct traceability of escalation records.

Escalation.Reason

  • Required: YES

  • Type: STRING

  • Description: The coded reason for the escalation, used to categorize the urgency or specific issue prompting the escalation.

Escalation.Reason_Description

  • Required: YES

  • Type: STRING

  • Description: A detailed description of the reason for escalation, providing context and specifics about the nature of the issue.

Escalation.Requester_Name

  • Required: YES

  • Type: STRING

  • Description: The name of the individual who requested the escalation, often a healthcare provider or administrative staff.

Escalation.Requester_Phone_Number

  • Required: YES

  • Type: STRING

  • Description: The contact phone number for the requester, enabling follow-up or immediate contact regarding the escalation.

Escalation.Created_User_ID

  • Required: YES

  • Type: STRING

  • Description: The identifier of the user who created the escalation record, ensuring accountability and traceability of the action initiation.

Escalation.Created_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp indicating when the escalation record was first created, marking the initial time of the action related to addressing the escalation.

Escalation.Last_Modified_User_ID

  • Required: YES

  • Type: STRING

  • Description: The identifier of the user who last modified the escalation record, useful for tracking changes and maintaining accountability.

Fax Dataset Specification

Escalation

Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the escalation record was last updated, useful for monitoring updates and ensuring current operational data for compliance.

Fax_log

Processing_Information

  • Is Nullable: YES

  • Data Type: STRUCT

  • Description: Information related to processing the fax.

Processing_Information.Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: A unique identifier for each processing entry within the fax log, ensuring distinct traceability of processing records.

Processing_Information.Request_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier of the request being processed, used to track the specific fax communication or request within the healthcare system.

Processing_Information.Action

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The specific action taken during the processing of the request, such as 'received', 'processed', or 'forwarded', detailing the nature of the activity.

Processing_Information.Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier of the user who created the processing record, ensuring accountability and traceability of the action initiation.

Processing_Information.Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the processing record was first created, marking the initial time of the processing action.

Processing_Information.Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier of the user who last modified the processing record, useful for tracking changes and maintaining accountability.

Processing_Information.Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the processing record was last updated, useful for monitoring updates and ensuring current operational data.

Fax_log Attributes

Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the fax record was created.

Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

Record_Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp of the last modification to the record.

Transaction_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

Deleted_Indicator

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicator for whether the record is deleted.

Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of fax record.

Tenant

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Tenant information associated with the record.

Active_Version

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Version of the record that is active.

Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: Date of the record.

Sequence

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Sequence of the record.

Source_System_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the source system.

Source_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp of the source data.

Source_File_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the source file.

Schema_Version

  • Is Nullable: YES

  • Data Type: FLOAT64

  • Description: Version of the dataset schema.

Action

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Action performed on the fax record.

Transaction_Actor_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of the actor performing the transaction.

Fax_raw

Fax_raw Attributes

Fax_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for the fax record.

Sender

  • Is Nullable: YES

  • Data Type: STRUCT

  • Description: Information about the sender of the fax.

Sender.Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: A unique identifier for each sender entry within the fax raw data, ensuring distinct traceability of fax communication records.

Sender.Fax_Number

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The fax number associated with the sender, used to identify the origin of fax communications within the healthcare system.

Sender.Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the sender record was first created, marking the establishment or update of the fax number within the system.

Sender.Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the sender record was last updated, useful for tracking changes and maintaining current contact details.

File_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the fax file.

File_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of the fax file.

File_Size

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Size of the fax file.

File_Size_Bytes

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Size of the fax file in bytes.

Page_Count

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Number of pages in the fax.

File_URL

  • Is Nullable: YES

  • Data Type: STRING

  • Description: URL or location of the fax file.

Status

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Status of the fax transmission.

Status_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the fax status.

Status_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the fax status was updated.

Incoming_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the fax was received.

Receiving

  • Is Nullable: YES

  • Data Type: STRUCT

  • Description: Information related to receiving the fax.

Receiving.Fax_Number_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: A unique identifier for each receiving entry within the fax raw data, ensuring distinct traceability of fax communication records to receivers.

Receiving.Fax_Number

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The fax number associated with the receiving end, used to identify the destination of fax communications within the healthcare system.

Receiving.Department_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: A unique identifier linking the fax number to a specific department, facilitating organizational management and internal routing.

Receiving.Department_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier of the department receiving the fax, providing clarity on the departmental allocation within the healthcare system.

Receiving.Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the receiving record was first created, marking the establishment or update of the fax number within the system.

Receiving.Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the receiving record was last updated, useful for tracking changes and maintaining current departmental contact details.

Assignment

  • Is Nullable: YES

  • Data Type: STRUCT

  • Description: Information related to assigning the fax.

Assignment.Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: A unique identifier for each assignment entry within the fax raw data, ensuring distinct traceability of user and department assignments.

Assignment.User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier of the user who is assigned to handle or is responsible for the fax, linking personnel to specific tasks or communications.

Assignment.User_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The type of user, which categorizes the user's role or level of access within the healthcare system, such as administrator, physician, or nurse.

Assignment.Department_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: A unique identifier that links the assignment to a specific department, facilitating organizational management.

Fax Dataset Specification

Assignment

Assignment.Department_ID

  • Required: YES

  • Type: STRING

  • Description: The identifier of the department involved in the fax communication, providing clarity on the departmental allocation within the healthcare system.

Assignment.Department_Priority

  • Required: YES

  • Type: INT64

  • Description: A numerical value indicating the priority level of the department in operational or emergency contexts, which can prioritize communication handling.

Assignment.Assigned_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp indicating when the user or department was assigned to the fax, marking the specific time of operational delegation.

Assignment.Created_User_ID

  • Required: YES

  • Type: STRING

  • Description: The identifier of the user who created the assignment record, ensuring accountability and traceability of record initiation.

Assignment.Created_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp indicating when the assignment record was first created, providing a timeline for the establishment of responsibilities.

Assignment.Last_Modified_User_ID

  • Required: YES

  • Type: STRING

  • Description: The identifier of the user who last modified the assignment record, useful for tracking changes and maintaining accountability.

Assignment.Last_Modified_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp indicating when the assignment record was last updated, useful for monitoring updates and ensuring current operational data.

Fax_raw Follow_Up

Follow_Up.Key

  • Required: YES

  • Type: INT64

  • Description: A unique identifier for each follow-up entry within the fax raw data, ensuring distinct traceability of follow-up actions.

Follow_Up.Description

  • Required: YES

  • Type: STRING

  • Description: A brief description of the follow-up action required or taken, providing an overview of the follow-up's purpose.

Follow_Up.Reason_Key

  • Required: YES

  • Type: INT64

  • Description: A unique identifier linking the follow-up to a specific reason, facilitating detailed categorization and response tracking.

Follow_Up.Reason

  • Required: YES

  • Type: STRING

  • Description: The reason code associated with the follow-up, used to classify and manage follow-up activities based on predefined categories.

Follow_Up.Reason_Description

  • Required: YES

  • Type: STRING

  • Description: A detailed description of the reason for the follow-up, offering clarity on the nature of the follow-up and its context within healthcare operations.

Follow_Up.Time_Zone_Code

  • Required: YES

  • Type: STRING

  • Description: The time zone code applicable to the follow-up timestamp, ensuring accurate scheduling and timing of follow-up activities across different regions.

Follow_Up.Follow_Up_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp indicating when the follow-up action is scheduled to occur or was completed, marking the specific timing of the action.

Follow_Up.Created_User_ID

  • Required: YES

  • Type: STRING

  • Description: The identifier of the user who created the follow-up record, ensuring accountability and traceability of record initiation.

Follow_Up.Created_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp indicating when the follow-up record was first created, providing a timeline for the establishment of follow-up actions.

Follow_Up.Last_Modified_User_ID

  • Required: YES

  • Type: STRING

  • Description: The identifier of the user who last modified the follow-up record, useful for tracking changes and maintaining accountability.

Follow_Up.Last_Modified_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp indicating when the follow-up record was last updated, useful for monitoring updates and ensuring current operational data.

Fax_raw Archive

Archive.Key

  • Required: YES

  • Type: INT64

  • Description: A unique identifier for each archival entry within the fax raw data, ensuring distinct traceability of archival records.

Archive.Action

  • Required: YES

  • Type: STRING

  • Description: The specific action taken during the archival process, such as 'store', 'delete', or 'retrieve', detailing the nature of the archival activity.

Archive.Created_User_ID

  • Required: YES

  • Type: STRING

  • Description: The identifier of the user who created the archival record, ensuring accountability and traceability of the action initiation.

Archive.Created_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp indicating when the archival record was first created, marking the initial time of the archival action.

Archive.Last_Modified_User_ID

  • Required: YES

  • Type: STRING

  • Description: The identifier of the user who last modified the archival record, useful for tracking changes and maintaining accountability.

Archive.Last_Modified_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp indicating when the archival record was last updated, useful for monitoring updates and ensuring current operational data for compliance.

Fax_raw Escalation

Escalation.Key

  • Required: YES

  • Type: INT64

  • Description: A unique identifier for each escalation entry within the fax raw data, ensuring distinct traceability of escalation records.

Escalation.Reason

  • Required: YES

  • Type: STRING

  • Description: The coded reason for the escalation, used to categorize the urgency or specific issue prompting the escalation.

Escalation.Reason_Description

  • Required: YES

  • Type: STRING

  • Description: A detailed description of the reason for the escalation, providing context and specifics about the nature of the issue.

Escalation.Requester_Name

  • Required: YES

  • Type: STRING

  • Description: The name of the individual who requested the escalation, often a healthcare provider or administrative staff.

Escalation.Requester_Phone_Number

  • Required: YES

  • Type: STRING

  • Description: The contact phone number for the requester, enabling follow-up or immediate contact regarding the escalation.

Escalation.Created_User_ID

  • Required: YES

  • Type: STRING

  • Description: The identifier of the user who created the escalation record, ensuring accountability and traceability of the action initiation.

Escalation.Created_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp indicating when the escalation record was first created, marking the initial time of the action related to addressing the escalation.

Escalation.Last_Modified_User_ID

  • Required: YES

  • Type: STRING

  • Description: The identifier of the user who last modified the escalation record, useful for tracking changes and maintaining accountability.

Escalation.Last_Modified_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp indicating when the escalation record was last updated, useful for monitoring updates and ensuring current operational data.

Fax_raw Processing_Information

Processing_Information.Key

  • Required: YES

  • Type: INT64

  • Description: A unique identifier for each processing entry within the fax raw data, ensuring distinct traceability of processing records.

Fax Dataset Specification

Processing Information

Fields

  • Request_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier of the request being processed, used to track the specific fax communication or request within the healthcare system.

  • Action

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The specific action taken during the processing of the request, such as 'received', 'processed', or 'forwarded', detailing the nature of the activity.

  • Created_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier of the user who created the processing record, ensuring accountability and traceability of the action initiation.

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the processing record was first created, marking the initial time of the processing action.

  • Last_Modified_User_ID

  • Is Nullable: YES

  • Data Type: STRING

  • Description: The identifier of the user who last modified the processing record, useful for tracking changes and maintaining accountability.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp indicating when the processing record was last updated, useful for monitoring updates and ensuring current operational data.

Fax Raw Data

Fields

  • Created_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the fax record was created.

  • Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

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

  • Record_Last_Modified_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp of the last modification to the record.

  • Transaction_User_ID

  • Is Nullable: YES

  • Data Type: STRING

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

  • Deleted_Indicator

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Indicator for whether the record is deleted.

  • Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of fax record.

  • Tenant

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Tenant information associated with the record.

  • Active_Version

  • Is Nullable: YES

  • Data Type: BOOL

  • Description: Version of the record that is active.

  • Date

  • Is Nullable: YES

  • Data Type: DATE

  • Description: Date of the record.

  • Sequence

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Sequence of the record.

  • Source_System_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the source system.

  • Source_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp of the source data.

  • Source_File_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the source file.

  • Schema_Version

  • Is Nullable: YES

  • Data Type: FLOAT64

  • Description: Version of the dataset schema.

  • Transaction_Actor_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of the actor performing the transaction.

Fax Records

Overview

  • Description: This table stores comprehensive details of each fax transmission, including sender and receiver information, date and time of sending, and the contents of the fax. It ensures that each communication is documented for future reference.

Fields

Table Name

Column Name

Is Nullable

Data Type

Description

Fax

Fax_Key

YES

INT64

Unique identifier for the fax.

Fax

Sender

YES

STRUCT

Name or identifier of the sender.

Sender.Key

YES

INT64

A unique identifier for each sender entry within the fax log, ensuring distinct traceability of fax communication records.

Sender.Fax_Number

YES

STRING

The fax number associated with the sender, used to identify the origin of fax communications within the healthcare system.

Sender.Created_Timestamp

YES

TIMESTAMP

Timestamp indicating when the sender record was first created, marking the establishment of the fax number within the system.

Sender.Last_Modified_Timestamp

YES

TIMESTAMP

Timestamp indicating when the sender record was last updated, useful for tracking changes and maintaining current contact details.

Fax

Sender_Key

YES

INT64

Key identifying the sender.

Fax

Sending_Fax_Number

YES

STRING

Fax number from which the fax is sent.

Fax

Sender_Created_Timestamp

YES

TIMESTAMP

Timestamp when sender information was created.

Fax

Sender_Last_Modified_Timestamp

YES

TIMESTAMP

Timestamp when sender information was last modified.

Fax

File_Name

YES

STRING

Name of the fax file.

Fax

File_Type

YES

STRING

Type of the fax file.

Fax

File_Size

YES

STRING

Size of the fax file.

Fax

File_Size_Bytes

YES

INT64

Size of the fax file in bytes.

Fax

Page_Count

YES

INT64

Number of pages in the fax.

Fax

File_URL

YES

STRING

URL link to access the fax file.

Fax

Status

YES

STRING

Current status of the fax.

Fax

Status_Description

YES

STRING

Description of the fax status.

Fax

Status_Timestamp

YES

TIMESTAMP

Timestamp of the fax status.

Fax

Incoming_Timestamp

YES

TIMESTAMP

Timestamp when the fax was received.

Fax

Receiving_Fax_Number_Key

YES

INT64

Key identifying the receiving fax number.

Fax

Receiving_Fax_Number

YES

STRING

Fax number of the recipient.

Fax

Receiving_Department_Key

YES

INT64

Key identifying the receiving department.

Fax

Receiving_Department_ID

YES

STRING

ID of the receiving department.

Fax

Receiving_Department_Name

YES

STRING

Name of the receiving department. Maps to Department.Department_Name.

Fax

Receiving_Created_Timestamp

YES

TIMESTAMP

Timestamp when receiving information was created.

Fax

Receiving_Last_Modified_Timestamp

YES

TIMESTAMP

Timestamp when receiving information was last modified.

Fax

Assignment_Key

YES

INT64

Key identifying the assignment related to the fax.

Fax

Assignee_ID

YES

STRING

ID of the assignee associated with the fax, which can be either a user ID (Fax.Assignment.User_ID) or a department ID (Fax.Assignment.Department_ID). If the user ID is not available, the department ID is used.

Fax

Assignee_Name

YES

STRING

Full name of the assignee associated with the fax.

Fax Activity Log

Overview

  • Description: The "Fax Log" tracks the status and history of fax transactions. It records activities such as when a fax was sent, received, or if there were any issues during transmission, providing a detailed audit trail of fax communications.

Fax Raw Data

Overview

  • Description: This table contains the unprocessed, detailed data of fax transmissions. It captures all the raw information associated with faxes, which is crucial for in-depth analysis and auditing purposes.

Fax Dataset Specification

Fax Table

Assignee Information

  • Assignee_Type

  • Data Type: STRING

  • Description: Type of the assignee responsible for the fax.

  • Assignee_Department_Priority

  • Data Type: INT64

  • Description: Priority of the assignee department.

Assignment Details

  • Assigned_Timestamp

  • Data Type: TIMESTAMP

  • Description: Timestamp when the fax was assigned.

  • Assignment_Created_User_ID

  • Data Type: STRING

  • Description: ID of the user who created the assignment.

  • Assignment_Created_User_Name

  • Data Type: STRING

  • Description: Name of the user who created the assignment. Maps to User.Full_Name.

  • Assignment_Created_Timestamp

  • Data Type: TIMESTAMP

  • Description: Timestamp when the assignment was created.

  • Assignment_Last_Modified_User_ID

  • Data Type: STRING

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

  • Assignment_Last_Modified_User_Name

  • Data Type: STRING

  • Description: Name of the user who last modified the assignment. Maps to User.Full_Name.

  • Assignment_Last_Modified_Timestamp

  • Data Type: TIMESTAMP

  • Description: Timestamp when the assignment was last modified.

Follow-Up Information

  • Follow_Up_Key

  • Data Type: INT64

  • Description: Key identifying the follow-up related to the fax.

  • Follow_Up_Description

  • Data Type: STRING

  • Description: Description of the follow-up action.

  • Follow_Up_Reason

  • Data Type: STRING

  • Description: Reason for the follow-up.

  • Follow_Up_Reason_Description

  • Data Type: STRING

  • Description: Description of the follow-up reason.

  • Follow_Up_Time_Zone_Code

  • Data Type: STRING

  • Description: Time zone code for the follow-up.

  • Follow_Up_Follow_Up_Timestamp

  • Data Type: TIMESTAMP

  • Description: Timestamp for the follow-up action.

  • Follow_Up_Created_User_ID

  • Data Type: STRING

  • Description: ID of the user who created the follow-up.

  • Follow_Up_Created_User_Name

  • Data Type: STRING

  • Description: Name of the user who created the follow-up. Maps to User.Full_Name.

  • Follow_Up_Created_Timestamp

  • Data Type: TIMESTAMP

  • Description: Timestamp when the follow-up was created.

  • Follow_Up_Last_Modified_User_ID

  • Data Type: STRING

  • Description: ID of the user who last modified the follow-up.

  • Follow_Up_Last_Modified_User_Name

  • Data Type: STRING

  • Description: Name of the user who last modified the follow-up. Maps to User.Full_Name.

  • Follow_Up_Last_Modified_Timestamp

  • Data Type: TIMESTAMP

  • Description: Timestamp when the follow-up was last modified.

Archive Information

  • Archive_Key

  • Data Type: INT64

  • Description: Key identifying the archived fax.

  • Archive_Action

  • Data Type: STRING

  • Description: Action taken for archiving the fax.

  • Archive_Created_User_ID

  • Data Type: STRING

  • Description: ID of the user who created the archive.

  • Archive_Created_User_Name

  • Data Type: STRING

  • Description: Name of the user who created the archive. Maps to User.Full_Name.

  • Archive_Created_Timestamp

  • Data Type: TIMESTAMP

  • Description: Timestamp when the archive was created.

  • Archive_Last_Modified_User_ID

  • Data Type: STRING

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

  • Archive_Last_Modified_User_Name

  • Data Type: STRING

  • Description: Name of the user who last modified the archive. Maps to User.Full_Name.

  • Archive_Last_Modified_Timestamp

  • Data Type: TIMESTAMP

  • Description: Timestamp when the archive was last modified.

Escalation Information

  • Escalation_Key

  • Data Type: INT64

  • Description: Unique identifier for the escalation.

  • Escalation_Reason

  • Data Type: STRING

  • Description: Reason for the escalation.

  • Escalation_Reason_Description

  • Data Type: STRING

  • Description: Description of the escalation reason.

  • Escalation_Requester_Name

  • Data Type: STRING

  • Description: Name of the requester for escalation.

  • Escalation_Requester_Phone_Number

  • Data Type: STRING

  • Description: Phone number of the requester for escalation.

  • Escalation_Created_User_ID

  • Data Type: STRING

  • Description: ID of the user who created the escalation.

  • Escalation_Created_User_Name

  • Data Type: STRING

  • Description: Name of the user who created the escalation. Maps to User.Full_Name.

  • Escalation_Created_Timestamp

  • Data Type: TIMESTAMP

  • Description: Timestamp when the escalation was created.

  • Escalation_Last_Modified_User_ID

  • Data Type: STRING

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

  • Escalation_Last_Modified_User_Name

  • Data Type: STRING

  • Description: Name of the user who last modified the escalation. Maps to User.Full_Name.

  • Escalation_Last_Modified_Timestamp

  • Data Type: TIMESTAMP

  • Description: Timestamp when the escalation was last modified.

Processing Information

  • Processing_Information_Key

  • Data Type: INT64

  • Description: Key identifying the processing information.

  • Processing_Information_Request_ID

  • Data Type: STRING

  • Description: ID of the request associated with processing information.

  • Processing_Information_Action

  • Data Type: STRING

  • Description: Action related to processing information.

  • Processing_Information_Created_User_ID

  • Data Type: STRING

  • Description: ID of the user who created the processing information.

  • Processing_Information_Created_User_Name

  • Data Type: STRING

  • Description: Name of the user who created the processing information. Maps to User.Full_Name.

  • Processing_Information_Created_Timestamp

  • Data Type: TIMESTAMP

  • Description: Timestamp when processing information was created.

  • Processing_Information_Last_Modified_User_ID

  • Data Type: STRING

  • Description: ID of the user who last modified processing information.

  • Processing_Information_Last_Modified_User_Name

  • Data Type: STRING

  • Description: Name of the user who last modified processing information. Maps to User.Full_Name.

  • Processing_Information_Last_Modified_Timestamp

  • Data Type: TIMESTAMP

  • Description: Timestamp when processing information was last modified.

Record Metadata

  • Created_Timestamp

  • Data Type: TIMESTAMP

  • Description: Timestamp when the record was created.

  • Last_Modified_Timestamp

  • Data Type: TIMESTAMP

  • Description: Timestamp when the record was last modified.

  • Days_To_Process

  • Data Type: INT64

  • Description: Number of days between the creation of the processing information for the fax (Fax.Processing_Information.Created_Timestamp) and the incoming timestamp of the fax (Fax.Incoming_Timestamp).

Fax_log Table

Fax Record Details

  • Fax_Key

  • Data Type: INT64

  • Description: Unique identifier for the fax record.

  • Sender

  • Data Type: STRUCT

  • Description: Information about the sender.

Fax Dataset Specification

Sender Information

Sender.Key

  • Required: YES

  • Type: INT64

  • Description: A unique identifier for each sender entry within the fax log, ensuring distinct traceability of fax communication records.

Sender.Fax_Number

  • Required: YES

  • Type: STRING

  • Description: The fax number associated with the sender, used to identify the origin of fax communications within the healthcare system.

Sender.Created_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp indicating when the sender record was first created, marking the establishment of the fax number within the system.

Sender.Last_Modified_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp indicating when the sender record was last updated, useful for tracking changes and maintaining current contact details.

Fax Log Information

Fax_log.File_Name

  • Required: YES

  • Type: STRING

  • Description: Name of the fax file.

Fax_log.File_Type

  • Required: YES

  • Type: STRING

  • Description: Type of the fax file.

Fax_log.File_Size

  • Required: YES

  • Type: STRING

  • Description: Size of the fax file.

Fax_log.File_Size_Bytes

  • Required: YES

  • Type: INT64

  • Description: Size of the fax file in bytes.

Fax_log.Page_Count

  • Required: YES

  • Type: INT64

  • Description: Number of pages in the fax.

Fax_log.File_URL

  • Required: YES

  • Type: STRING

  • Description: URL or location of the fax file.

Fax_log.Status

  • Required: YES

  • Type: STRING

  • Description: Status of the fax transmission.

Fax_log.Status_Description

  • Required: YES

  • Type: STRING

  • Description: Description of the fax status.

Fax_log.Status_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp when the fax status was updated.

Fax_log.Incoming_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp when the fax was received.

Receiving Information

Receiving.Fax_Number_Key

  • Required: YES

  • Type: INT64

  • Description: A unique identifier for each receiver entry within the fax log, ensuring distinct traceability of fax communication records.

Receiving.Fax_Number

  • Required: YES

  • Type: STRING

  • Description: The fax number associated with the receiving end, used to identify the destination of fax communications within the healthcare system.

Receiving.Department_Key

  • Required: YES

  • Type: INT64

  • Description: A unique identifier linking the fax number to a specific department, facilitating categorization and routing of communications.

Receiving.Department_ID

  • Required: YES

  • Type: STRING

  • Description: The identifier of the department receiving the fax, providing clarity on the departmental allocation within the healthcare system.

Receiving.Created_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp indicating when the receiving record was first created, marking the establishment or update of the fax number within the system.

Receiving.Last_Modified_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp indicating when the receiving record was last updated, useful for tracking changes and maintaining current departmental contact details.

Assignment Information

Assignment.Key

  • Required: YES

  • Type: INT64

  • Description: A unique identifier for each assignment entry within the fax log, ensuring distinct traceability of user and department assignments.

Assignment.User_ID

  • Required: YES

  • Type: STRING

  • Description: The identifier of the user who is assigned to handle or is responsible for the fax, linking personnel to specific tasks or communications.

Assignment.User_Type

  • Required: YES

  • Type: STRING

  • Description: The type of user, which categorizes the user's role or level of access within the healthcare system, such as administrator, physician, or nurse.

Assignment.Department_Key

  • Required: YES

  • Type: INT64

  • Description: A unique identifier that links the assignment to a specific department, facilitating organizational management and internal routing.

Assignment.Department_ID

  • Required: YES

  • Type: STRING

  • Description: The identifier of the department involved in the fax communication, providing clarity on the departmental allocation within the healthcare system.

Assignment.Department_Priority

  • Required: YES

  • Type: INT64

  • Description: A numerical value indicating the priority level of the department in operational or emergency contexts, which can prioritize communication handling.

Assignment.Assigned_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp indicating when the user or department was assigned to the fax, marking the specific time of operational delegation.

Assignment.Created_User_ID

  • Required: YES

  • Type: STRING

  • Description: The identifier of the user who created the assignment record, ensuring accountability and traceability of record initiation.

Assignment.Created_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp indicating when the assignment record was first created, providing a timeline for the establishment of responsibilities.

Assignment.Last_Modified_User_ID

  • Required: YES

  • Type: STRING

  • Description: The identifier of the user who last modified the assignment record, useful for tracking changes and maintaining accountability.

Assignment.Last_Modified_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp indicating when the assignment record was last updated, useful for monitoring updates and ensuring current operational data.

Follow-Up Information

Follow_Up.Key

  • Required: YES

  • Type: INT64

  • Description: A unique identifier for each follow-up entry within the fax log, ensuring distinct traceability of follow-up actions.

Follow_Up.Description

  • Required: YES

  • Type: STRING

  • Description: A brief description of the follow-up action required or taken, providing an overview of the follow-up's purpose.

Follow_Up.Reason_Key

  • Required: YES

  • Type: INT64

  • Description: A unique identifier linking the follow-up to a specific reason, facilitating detailed categorization and response tracking.

Follow_Up.Reason

  • Required: YES

  • Type: STRING

  • Description: The reason code associated with the follow-up, used to classify and manage follow-up activities based on predefined categories.

Follow_Up.Reason_Description

  • Required: YES

  • Type: STRING

  • Description: A detailed description of the reason for the follow-up, offering clarity on the nature of the follow-up and its context within healthcare operations.

Follow_Up.Time_Zone_Code

  • Required: YES

  • Type: STRING

  • Description: The time zone code applicable to the follow-up timestamp, ensuring accurate scheduling and timing of follow-up activities across different regions.

Follow_Up.Follow_Up_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp indicating when the follow-up action is scheduled to occur or was completed, marking the timeline for follow-up activities.

Fax Dataset Specification

Follow-Up

Follow_Up.Created_User_ID

  • Required: YES

  • Type: STRING

  • Description: The identifier of the user who created the follow-up record, ensuring accountability and traceability of record initiation.

Follow_Up.Created_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp indicating when the follow-up record was first created, providing a timeline for the establishment of follow-up actions.

Follow_Up.Last_Modified_User_ID

  • Required: YES

  • Type: STRING

  • Description: The identifier of the user who last modified the follow-up record, useful for tracking changes and maintaining accountability.

Follow_Up.Last_Modified_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp indicating when the follow-up record was last updated, useful for monitoring updates and ensuring current operational data.

Fax Log

Archive

Archive.Key

  • Required: YES

  • Type: INT64

  • Description: A unique identifier for each archival entry within the fax log, ensuring distinct traceability of archival records.

Archive.Action

  • Required: YES

  • Type: STRING

  • Description: The specific action taken during the archival process, such as 'store', 'delete', or 'retrieve', detailing the nature of the archival activity.

Archive.Created_User_ID

  • Required: YES

  • Type: STRING

  • Description: The identifier of the user who created the archival record, ensuring accountability and traceability of the action initiation.

Archive.Created_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp indicating when the archival record was first created, marking the initial time of the archival action.

Archive.Last_Modified_User_ID

  • Required: YES

  • Type: STRING

  • Description: The identifier of the user who last modified the archival record, useful for tracking changes and maintaining accountability.

Archive.Last_Modified_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp indicating when the archival record was last updated, useful for monitoring updates and ensuring current operational data for compliance.

Escalation

Escalation.Key

  • Required: YES

  • Type: INT64

  • Description: A unique identifier for each escalation entry within the fax log, ensuring distinct traceability of escalation records.

Escalation.Reason

  • Required: YES

  • Type: STRING

  • Description: The coded reason for the escalation, used to categorize the urgency or specific issue prompting the escalation.

Escalation.Reason_Description

  • Required: YES

  • Type: STRING

  • Description: A detailed description of the reason for escalation, providing context and specifics about the nature of the issue.

Escalation.Requester_Name

  • Required: YES

  • Type: STRING

  • Description: The name of the individual who requested the escalation, often a healthcare provider or administrative staff.

Escalation.Requester_Phone_Number

  • Required: YES

  • Type: STRING

  • Description: The contact phone number for the requester, enabling follow-up or immediate contact regarding the escalation.

Escalation.Created_User_ID

  • Required: YES

  • Type: STRING

  • Description: The identifier of the user who created the escalation record, ensuring accountability and traceability of the action initiation.

Escalation.Created_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp indicating when the escalation record was first created, marking the initial time of the action related to addressing the escalation.

Escalation.Last_Modified_User_ID

  • Required: YES

  • Type: STRING

  • Description: The identifier of the user who last modified the escalation record, useful for tracking changes and maintaining accountability.

Escalation.Last_Modified_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp indicating when the escalation record was last updated, useful for monitoring updates and ensuring current operational data for compliance.

Processing Information

Processing_Information.Key

  • Required: YES

  • Type: INT64

  • Description: A unique identifier for each processing entry within the fax log, ensuring distinct traceability of processing records.

Processing_Information.Request_ID

  • Required: YES

  • Type: STRING

  • Description: The identifier of the request being processed, used to track the specific fax communication or request within the healthcare system.

Processing_Information.Action

  • Required: YES

  • Type: STRING

  • Description: The specific action taken during the processing of the request, such as 'received', 'processed', or 'forwarded', detailing the nature of the activity.

Processing_Information.Created_User_ID

  • Required: YES

  • Type: STRING

  • Description: The identifier of the user who created the processing record, ensuring accountability and traceability of the action initiation.

Processing_Information.Created_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp indicating when the processing record was first created, marking the initial time of the processing action.

Processing_Information.Last_Modified_User_ID

  • Required: YES

  • Type: STRING

  • Description: The identifier of the user who last modified the processing record, useful for tracking changes and maintaining accountability.

Processing_Information.Last_Modified_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp indicating when the processing record was last updated, useful for monitoring updates and ensuring current operational data.

General Fax Log Fields

Fax_log.Created_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp when the fax record was created.

Fax_log.Last_Modified_Timestamp

  • Required: YES

  • Type: TIMESTAMP

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

Fax_log.Record_Last_Modified_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp of the last modification to the record.

Fax_log.Transaction_User_ID

  • Required: YES

  • Type: STRING

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

Fax_log.Deleted_Indicator

  • Required: YES

  • Type: BOOL

  • Description: Indicator for whether the record is deleted.

Fax_log.Type

  • Required: YES

  • Type: STRING

  • Description: Type of fax record.

Fax_log.Tenant

  • Required: YES

  • Type: STRING

  • Description: Tenant information associated with the record.

Fax_log.Active_Version

  • Required: YES

  • Type: BOOL

  • Description: Version of the record that is active.

Fax_log.Date

  • Required: YES

  • Type: DATE

  • Description: Date of the record.

Fax_log.Sequence

  • Required: YES

  • Type: INT64

  • Description: Sequence of the record.

Fax_log.Source_System_Name

  • Required: YES

  • Type: STRING

  • Description: Name of the source system.

Fax_log.Source_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp of the source data.

Fax_log.Source_File_Name

  • Required: YES

  • Type: STRING

  • Description: Name of the source file.

Fax Dataset Specification

Overview

This document specifies the schema and structure of the fax dataset used within the Care Intelligence system. It includes detailed descriptions of table names, column names, data types, and their respective purposes.

Table: Fax_log

Columns

  • Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the source file.

  • Schema_Version

  • Is Nullable: YES

  • Data Type: FLOAT64

  • Description: Version of the dataset schema.

  • Action

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Action performed on the fax record.

  • Transaction_Actor_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of the actor performing the transaction.

Table: Fax_raw

Columns

General Information

  • Fax_Key

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Unique identifier for the fax record.

  • File_Name

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Name of the fax file.

  • File_Type

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Type of the fax file.

  • File_Size

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Size of the fax file.

  • File_Size_Bytes

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Size of the fax file in bytes.

  • Page_Count

  • Is Nullable: YES

  • Data Type: INT64

  • Description: Number of pages in the fax.

  • File_URL

  • Is Nullable: YES

  • Data Type: STRING

  • Description: URL or location of the fax file.

  • Status

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Status of the fax transmission.

  • Status_Description

  • Is Nullable: YES

  • Data Type: STRING

  • Description: Description of the fax status.

  • Status_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the fax status was updated.

  • Incoming_Timestamp

  • Is Nullable: YES

  • Data Type: TIMESTAMP

  • Description: Timestamp when the fax was received.

Sender Information

  • Sender

  • Key

    • Is Nullable: YES

    • Data Type: INT64

    • Description: A unique identifier for each sender entry within the fax raw data, ensuring distinct traceability of fax communication records.

  • Fax_Number

    • Is Nullable: YES

    • Data Type: STRING

    • Description: The fax number associated with the sender, used to identify the origin of fax communications within the healthcare system.

  • Created_Timestamp

    • Is Nullable: YES

    • Data Type: TIMESTAMP

    • Description: Timestamp indicating when the sender record was first created, marking the establishment or update of the fax number within the system.

  • Last_Modified_Timestamp

    • Is Nullable: YES

    • Data Type: TIMESTAMP

    • Description: Timestamp indicating when the sender record was last updated, useful for tracking changes and maintaining current contact details.

Receiving Information

  • Receiving

  • Fax_Number_Key

    • Is Nullable: YES

    • Data Type: INT64

    • Description: A unique identifier for each receiving entry within the fax raw data, ensuring distinct traceability of fax communication records to receivers.

  • Fax_Number

    • Is Nullable: YES

    • Data Type: STRING

    • Description: The fax number associated with the receiving end, used to identify the destination of fax communications within the healthcare system.

  • Department_Key

    • Is Nullable: YES

    • Data Type: INT64

    • Description: A unique identifier linking the fax number to a specific department, facilitating organizational management and internal routing.

  • Department_ID

    • Is Nullable: YES

    • Data Type: STRING

    • Description: The identifier of the department receiving the fax, providing clarity on the departmental allocation within the healthcare system.

  • Created_Timestamp

    • Is Nullable: YES

    • Data Type: TIMESTAMP

    • Description: Timestamp indicating when the receiving record was first created, marking the establishment or update of the fax number within the system.

  • Last_Modified_Timestamp

    • Is Nullable: YES

    • Data Type: TIMESTAMP

    • Description: Timestamp indicating when the receiving record was last updated, useful for tracking changes and maintaining current departmental contact details.

Assignment Information

  • Assignment

  • Key

    • Is Nullable: YES

    • Data Type: INT64

    • Description: A unique identifier for each assignment entry within the fax raw data, ensuring distinct traceability of user and department assignments.

  • User_ID

    • Is Nullable: YES

    • Data Type: STRING

    • Description: The identifier of the user who is assigned to handle or is responsible for the fax, linking personnel to specific tasks or communications.

  • User_Type

    • Is Nullable: YES

    • Data Type: STRING

    • Description: The type of user, which categorizes the user's role or level of access within the healthcare system, such as administrator, physician, or nurse.

  • Department_Key

    • Is Nullable: YES

    • Data Type: INT64

    • Description: A unique identifier that links the assignment to a specific department, facilitating organizational management and internal routing.

  • Department_ID

    • Is Nullable: YES

    • Data Type: STRING

    • Description: The identifier of the department involved in the fax communication, providing clarity on the departmental allocation within the healthcare system.

  • Department_Priority

    • Is Nullable: YES

    • Data Type: INT64

    • Description: A numerical value indicating the priority level of the department in operational or emergency contexts, which can prioritize communication handling.

  • Assigned_Timestamp

    • Is Nullable: YES

    • Data Type: TIMESTAMP

    • Description: Timestamp indicating when the user or department was assigned to the fax, marking the specific time of operational delegation.

  • Created_User_ID

    • Is Nullable: YES

    • Data Type: STRING

    • Description: The identifier of the user who created the assignment record, ensuring accountability and traceability of record initiation.

  • Created_Timestamp

    • Is Nullable: YES

    • Data Type: TIMESTAMP

    • Description: Timestamp indicating when the assignment record was first created, providing a timeline for the establishment of responsibilities.

  • Last_Modified_User_ID

    • Is Nullable: YES

    • Data Type: STRING

    • Description: The identifier of the user who last modified the assignment record, useful for tracking changes and maintaining accountability.

  • Last_Modified_Timestamp

    • Is Nullable: YES

    • Data Type: TIMESTAMP

    • Description: Timestamp indicating when the assignment record was last updated, useful for monitoring updates and ensuring current operational data.

Follow-Up Information

  • Follow_Up

  • Key

    • Is Nullable: YES

    • Data Type: INT64

    • Description: A unique identifier for each follow-up entry within the fax raw data, ensuring distinct traceability of follow-up actions.

  • Description

    • Is Nullable: YES

    • Data Type: STRING

    • Description: A brief description of the follow-up action required or taken, providing an overview of the follow-up's purpose.

  • Reason_Key

    • Is Nullable: YES

    • Data Type: INT64

    • Description: A unique identifier linking the follow-up to a specific reason, facilitating detailed categorization and response tracking.

  • Reason

    • Is Nullable: YES

    • Data Type: STRING

    • Description: The reason code associated with the follow-up, used to classify and manage follow-up activities based on predefined categories.

Fax Dataset Specification

Follow-Up

Follow_Up.Reason_Description

  • Required: YES

  • Type: STRING

  • Description: A detailed description of the reason for the follow-up, offering clarity on the nature of the follow-up and its context within healthcare operations.

Follow_Up.Time_Zone_Code

  • Required: YES

  • Type: STRING

  • Description: The time zone code applicable to the follow-up timestamp, ensuring accurate scheduling and timing of follow-up activities across different regions.

Follow_Up.Follow_Up_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp indicating when the follow-up action is scheduled to occur or was completed, marking the specific timing of the action.

Follow_Up.Created_User_ID

  • Required: YES

  • Type: STRING

  • Description: The identifier of the user who created the follow-up record, ensuring accountability and traceability of record initiation.

Follow_Up.Created_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp indicating when the follow-up record was first created, providing a timeline for the establishment of follow-up actions.

Follow_Up.Last_Modified_User_ID

  • Required: YES

  • Type: STRING

  • Description: The identifier of the user who last modified the follow-up record, useful for tracking changes and maintaining accountability.

Follow_Up.Last_Modified_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp indicating when the follow-up record was last updated, useful for monitoring updates and ensuring current operational data.

Fax Raw

Archive

Archive.Key

  • Required: YES

  • Type: INT64

  • Description: A unique identifier for each archival entry within the fax raw data, ensuring distinct traceability of archival records.

Archive.Action

  • Required: YES

  • Type: STRING

  • Description: The specific action taken during the archival process, such as 'store', 'delete', or 'retrieve', detailing the nature of the archival activity.

Archive.Created_User_ID

  • Required: YES

  • Type: STRING

  • Description: The identifier of the user who created the archival record, ensuring accountability and traceability of the action initiation.

Archive.Created_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp indicating when the archival record was first created, marking the initial time of the archival action.

Archive.Last_Modified_User_ID

  • Required: YES

  • Type: STRING

  • Description: The identifier of the user who last modified the archival record, useful for tracking changes and maintaining accountability.

Archive.Last_Modified_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp indicating when the archival record was last updated, useful for monitoring updates and ensuring current operational data for compliance.

Escalation

Escalation.Key

  • Required: YES

  • Type: INT64

  • Description: A unique identifier for each escalation entry within the fax raw data, ensuring distinct traceability of escalation records.

Escalation.Reason

  • Required: YES

  • Type: STRING

  • Description: The coded reason for the escalation, used to categorize the urgency or specific issue prompting the escalation.

Escalation.Reason_Description

  • Required: YES

  • Type: STRING

  • Description: A detailed description of the reason for the escalation, providing context and specifics about the nature of the issue.

Escalation.Requester_Name

  • Required: YES

  • Type: STRING

  • Description: The name of the individual who requested the escalation, often a healthcare provider or administrative staff.

Escalation.Requester_Phone_Number

  • Required: YES

  • Type: STRING

  • Description: The contact phone number for the requester, enabling follow-up or immediate contact regarding the escalation.

Escalation.Created_User_ID

  • Required: YES

  • Type: STRING

  • Description: The identifier of the user who created the escalation record, ensuring accountability and traceability of the action initiation.

Escalation.Created_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp indicating when the escalation record was first created, marking the initial time of the action related to addressing the escalation.

Escalation.Last_Modified_User_ID

  • Required: YES

  • Type: STRING

  • Description: The identifier of the user who last modified the escalation record, useful for tracking changes and maintaining accountability.

Escalation.Last_Modified_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp indicating when the escalation record was last updated, useful for monitoring updates and ensuring current operational data.

Processing Information

Processing_Information.Key

  • Required: YES

  • Type: INT64

  • Description: A unique identifier for each processing entry within the fax raw data, ensuring distinct traceability of processing records.

Processing_Information.Request_ID

  • Required: YES

  • Type: STRING

  • Description: The identifier of the request being processed, used to track the specific fax communication or request within the healthcare system.

Processing_Information.Action

  • Required: YES

  • Type: STRING

  • Description: The specific action taken during the processing of the request, such as 'received', 'processed', or 'forwarded', detailing the nature of the activity.

Processing_Information.Created_User_ID

  • Required: YES

  • Type: STRING

  • Description: The identifier of the user who created the processing record, ensuring accountability and traceability of the action initiation.

Processing_Information.Created_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp indicating when the processing record was first created, marking the initial time of the processing action.

Processing_Information.Last_Modified_User_ID

  • Required: YES

  • Type: STRING

  • Description: The identifier of the user who last modified the processing record, useful for tracking changes and maintaining accountability.

Processing_Information.Last_Modified_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp indicating when the processing record was last updated, useful for monitoring updates and ensuring current operational data.

General Fax Raw Fields

Fax_raw.Created_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp when the fax record was created.

Fax_raw.Last_Modified_Timestamp

  • Required: YES

  • Type: TIMESTAMP

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

Fax_raw.Record_Last_Modified_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp of the last modification to the record.

Fax_raw.Transaction_User_ID

  • Required: YES

  • Type: STRING

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

Fax_raw.Deleted_Indicator

  • Required: YES

  • Type: BOOL

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

Fax Dataset Specification

Fax_raw Dataset Fields

Type

  • Required: YES

  • Type: STRING

  • Description: Type of fax record.

Tenant

  • Required: YES

  • Type: STRING

  • Description: Tenant information associated with the record.

Active_Version

  • Required: YES

  • Type: BOOL

  • Description: Version of the record that is active.

Date

  • Required: YES

  • Type: DATE

  • Description: Date of the record.

Sequence

  • Required: YES

  • Type: INT64

  • Description: Sequence of the record.

Source_System_Name

  • Required: YES

  • Type: STRING

  • Description: Name of the source system.

Source_Timestamp

  • Required: YES

  • Type: TIMESTAMP

  • Description: Timestamp of the source data.

Source_File_Name

  • Required: YES

  • Type: STRING

  • Description: Name of the source file.

Schema_Version

  • Required: YES

  • Type: FLOAT64

  • Description: Version of the dataset schema.

Transaction_Actor_Type

  • Required: YES

  • Type: STRING

  • Description: Type of the actor performing the transaction.

Related Articles
Provider Dataset Specification
Interaction Topic Dataset Specification
Assessment Dataset Specification
Questionnaire Dataset Specification
User Dataset Specification
Did this answer your question?