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