Data Points
Tableau Data Source Field | Folder | Description |
ACQUISITIONDATE_UTC | System Calc | The first step in the data ingestion process. Used internally for latency calculations. This field is not intended for client report building. |
CLOUDACQUISITIONDATE UTC | System Calc | The second step in the data ingestion process. Used internally for latency calculations. This field is not intended for client report building. |
CREATEDDATE | Root | Created Date in Local Time zone for when the patient custom column was created in Capacity IQ®. |
CREATEDDATE ENTERPRISE | Root | Created Date in Enterprise time zone for when the patient custom column was created in Capacity IQ®. The enterprise time is in the timezone configured in the Operations |
CREATEDDATE UTC | Root | Created Date in UTC Time zone for when the patient custom column was created in Capacity IQ®. |
CUSTOMER FACILITY ID | System Calc | A unique identifier for a given campus that is defined in the Capacity IQ® campus settings under the Campus Account ID field. Commonly used with the Data IQ® Warehouse Connector to allow joining against an external identifier in an enterprise data warehouse. |
CUSTOM FIELD COLUMN TYPE | Root | The column type of the custom column in Capacity IQ®. Example: text, numeric, datetime, boolean. |
CUSTOM FIELD DESCRIPTION | Root | The custom column description in Capacity IQ® |
CUSTOM FIELD HEADER | Root | The value of the custom header in Capacity IQ® |
CUSTOM FIELD ID | Root | The unique identifier of the custom column in Capacity IQ® |
CUSTOM FIELD NAME | Root | The displayed name of the custom column in Capacity IQ® |
CUSTOM FIELD VALUE | Root | The value set for the custom column in Capacity IQ® |
LASTMODDATE | System Calc | System calculation that displays the most recent update to the custom data field in local time. This field is not intended for client reporting. |
LASTMODDATE ENTERPRISE | System Calc | System calculation that displays the most recent update to the custom data field in enterprise time. This field is not intended for client reporting. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings. |
LASTMODDATE UTC | System Calc | System calculation that displays the most recent update to the custom data field in UTC time. This field is not intended for client reporting. |
LATEST LASTMODDATE ENTERPRISE | System Calc | This is the most recent timestamp in Enterprise timezone indicating when any data point within a record was last updated. The enterprise time is in the timezone configured in the IQ Platform enterprise settings. |
LATEST LASTMODDATE UTC | System Calc | This is the most recent timestamp in UTC timezone indicating when any data point within a record was last updated. |
PATIENT CAMPUS | Root | The campus associated with the patient visit record when the record was created |
PATIENT CAMPUS ID | System Calc | A unique identifier associated with campus. |
PATIENT DIAGNOSIS | Root | The latest admit diagnosis text associated with the patient visit record. |
PATIENT DISCHARGE TIMESTAMP | Root | The latest local timestamp the patient entered a discharged status |
PATIENT DISCHARGE TIMESTAMP ENTERPRISE | Root | The latest enterprise timestamp when the patient entered a discharged status. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings. |
PATIENT DISCHARGE TIMESTAMP UTC | Root | The latest UTC timestamp the patient entered a discharged status |
PATIENT DOB | Root | The date of birth of the patient receiving medical treatment. |
PATIENT FIRSTNAME | Root | The First name of the patient |
PATIENT GENDER | Root | Gender set in the patient visit record |
PATIENT GENDER CODE | System Calc | The gender code mearked for the patient. This field is used in standard content for multi-language support. This field is not intended for client report building.ort multi-language workbooks. This field is not intended for client report building. |
PATIENT HOME LOCATION ID | System Calc | The database identifier or internal record ID of the patient's latest home location. This is not intended for client report building. |
PATIENT HOME LOCATION | System Calc | The latest home location of the patient |
PATIENT IS EVER ADMITTED | Root | Indicates if the patient was ever admitted or not |
PATIENT LASTNAME | Root | The Last name of the patient |
PATIENT LEVEL OF CARE | Root | The degree of care that the patient requires, such as critical, acute, intermediate. |
PATIENT LEVEL OF CARE ID | System Calc | Unique identifier associated with Patient's LevelofCare |
PATIENT MIDDLE INITIAL | Root | The Middle Initial of the patient |
PATIENT MRN | Root | The medical record number for a person receiving medical treatment. |
PATIENT STATUS TYPE | Root | The latest patient status type set on the patient record. The values can include ConfirmedDischarge, Discharged, InHouse, OutPatient, PendingDischarge, PendingTransfer, PreAdmit, VisitCanceled. |
PATIENT STATUS TYPE CODE | Root | The key that represents the status of the patient. This field is used in standard content for multi-language support. This field is not intended for client report building. |
PATIENT STATUS TYPE ID | System Calc | This field is Patient's PatientStatusTypeID |
PATIENT TYPE | Root | The patient type as set in the patient's record in Capacity IQ®. |
PATIENT VISIT ID | Root | Unique identifier associated for the patient visit. Not intended for client report building. |
PATIENT VISIT NUMBER | Root | The patient's visit number/account number. |
WAREHOUSEACQUISITIONDATE UTC | System Calc | The timestamp that a record is inserted in the Snowflake Data Warehouse in UTC format. |