Data Points
Tableau Data Source Field | Folder | Description |
Acquisitiondate Utc | Root | The first step in the data ingestion process that is used internally for latency calculations. This field is not intended for client report building. |
Cloudacquisitiondate Utc | Root | The second step in the data ingestion process that is 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 record was entered. |
Createddate Enterprise | Root | Created Date in enterprise time for when the record was entered. |
Createddate Utc | Root | Created Date in UTC time for when the record was entered. |
Datepartition | Root | System calculation used internally to partition the data for efficient processing. This field is not intended for client report building. |
Instanceid | Root | A system calculation used for data partitioning. It is not intended for client reporting. |
Lastmoddate | Root | The date of the most recent update to the assignment in local time zone. |
Lastmoddate Enterprise | Root | The date of the most recent update to the assignment in Enterprise time |
Lastmoddate Utc | Root | The date of the most recent update to the assignment in UTC time |
Latest Lastmoddate | Root | The date of the most recent update to the assignment in local time zone. |
Latest Lastmoddate Enterprise | Root | The date of the most recent update to the assignment in Enterprise time |
Latest Lastmoddate Utc | Root | The date of the most recent update to the assignment in UTC time |
New Assigned Bed Adt Id | Root | A unique identifier for the new individual bed location. |
New Assigned Building | Root | The building associated with the new placement assignment |
New Assigned Campus | Root | The campus associated with the new placement assignment |
New Assigned Campus Id | Root | The unique ID for the campus associated with the new placement assignment |
New Assigned Enterprise | Root | The enterprise associated with the new placement assignment |
New Assigned Facility Adt Id | Root | The unique facility ADT ID associated with the new placement assignment |
New Assigned Floor | Root | The floor associated with the new placement assignment |
New Assigned Location | Root | The location/bed associated with the new placement assignment |
New Assigned Location Id | Root | The unique identifier for the location associated with the new placement assignment |
New Assigned Nursestation Adt Id | Root | The unique identifier for the Nurse Station associated with the new placement assignment |
New Assigned Room | Root | The room associated with the new placement assignment |
New Assigned Room Adt Id | Root | The unqiue ADT ID for the room associated with the new placement assignment |
New Assigned Unit | Root | The unit associated with the new placement assignment |
New Assigned Unit Abbreviation | Root | The unit abbreviation associated with the new placement assignment |
New Assigned Unit Category | Root | The ubnit category associated with the new placement assignment |
New Assigned Unit Discipline | Root | The unit discipline associated with the new placement assignment |
New Assigned Unit Id | Root | The unique identifier for the unit associated with the new placement assignment |
New Assigner | Root | The employee who set the new placement assignment |
New Location Id | Root | The unique location identifier for the new placement assignment |
Occupied Location Id | Root | The unique identifer for the location that is occupied |
Occurrence Timestamp | Root | The time that the reassignment took place in local time |
Occurrence Timestamp Enterprise | Root | The time that the reassignment took place in enterprise time |
Occurrence Timestamp Utc | Root | The time that the reassignment took place in UTC |
Patient Dob | Root | The date of birth of the person receiving medical treatment. |
Patient Firstname | Root | The first name of the person receiving medical treatment. |
Patient Gender | Root | The gender of the person receiving medical treatment. |
Patient Lastname | Root | The last name of the person receiving medical treatment. |
Patient Mrn | Root | The medical record number for person receiving medical treatment. |
Patient Visit Id | Root | The Database or Internal Record ID for a patient's visit. This field is not intended for client report building |
Patient Visit Number | Root | Patient's visit number/account number. |
Placement Id | Root | The identifier for a home location (bed) that is assigned to a patient in a health system. |
Placement Reassignment Id | Root | The unique identifier for the data source. The ID associated with each placement reassignment |
Prev Placement Reassignment Id | Root | The ID associated with the previous placement reassignment |
Previous Assigned Bed Adt Id | Root | A unique identifier for the previous individual bed location. |
Previous Assigned Building | Root | The building associated with the previous placement assignment |
Previous Assigned Campus | Root | The campus associated with the previous placement assignment |
Previous Assigned Campus Id | Root | The unique ID for the campus associated with the previous placement assignment |
Previous Assigned Enterprise | Root | The enterprise associated with the previous placement assignment |
Previous Assigned Facility Adt Id | Root | The unique facility ADT ID associated with the previous placement assignment |
Previous Assigned Floor | Root | The floor associated with the previous placement assignment |
Previous Assigned Location | Root | The location/bed associated with the previous placement assignment |
Previous Assigned Location Id | Root | The unique identifier for the location associated with the previous placement assignment |
Previous Assigned Nursestation Adt Id | Root | The unique identifier for the Nurse Station associated with the previous placement assignment |
Previous Assigned Room | Root | The room associated with the previous placement assignment |
Previous Assigned Room Adt Id | Root | The unqiue ADT ID for the room associated with the previous placement assignment |
Previous Assigned Unit | Root | The unit associated with the previous placement assignment |
Previous Assigned Unit Abbreviation | Root | The unit abbreviation associated with the previous placement assignment |
Previous Assigned Unit Category | Root | The ubnit category associated with the previous placement assignment |
Previous Assigned Unit Discipline | Root | The unit discipline associated with the previous placement assignment |
Previous Assigned Unit Id | Root | The unique identifier for the unit associated with the previous placement assignment |
Previous Assigner | Root | The employee who set the previous placement assignment |
Previous Location Id | Root | The unique location identifier for the previous placement assignment |
Tenantid | Root | Tenant GUID - Non-Strict Dynamic Partition Column. |
Warehouseacquisitiondate Utc | Root | The latest timestamp that a record is inserted in the Snowflake Data Warehouse in UTC format. |
Patient Age | Root | The age of the person receiving medical treatment at the time of the visit. |