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. |
Applied By | Root | The name of the employee who applied the priority |
Applied Timestamp | Root | The time the priority was applied in local time |
Applied Timestamp Enterprise | Root | The time the priority was applied in Enterprise time |
Applied Timestamp Utc | Root | The time the priority was applied in UTC |
Bed Adt Id | Root | A unique identifier for the individual bed location. |
Building | Root | The building where the cleaning job took place. |
Building Id | Root | The unique identifier for the building where the cleaning job took place. |
Campus | Root | The name of the campus in which the assignment took place |
Campus Id | Root | The unique identifier of the campus in which the assignment took place |
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. |
Customer Facility Id | Root | If a facility is integrated with the Capacity IQ, and the facility recorded in the staff communication history entry has an external identifier, it will display the value set in the campus settings for that facility. |
Datepartition | Root | System calculation used internally to partition the data for efficient processing. This field is not intended for client report building. |
Duration | Root | The amount of time in minutes that the assignment was active |
Enterprise | Root | The name of a collection of campuses. |
Enterprise Id | Root | The unique identifier of a collection of campuses. |
Facility Adt Id | Root | The facility ADT ID of the location associated with the assignment. If this value is NULL in the location settings, it is derived from the campus settings |
Floor | Root | The floor associated with the location which had an assignment |
Floor Id | Root | The unique identifier of the floor associated with the location which had an assignment |
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 |
Location | Root | The location associated with the assignment |
Location Id | Root | The unique identifier of the location associated with the assignment |
Location Priority Assignments Id | Root | The unique identifier for the data source. The unique value per assignment |
Location Type | Root | The type of location associated with the assignment |
Location Type Code | Root | The type of location associated with the assignment - not intended for customer reporting |
Location Type Id | Root | The unqie identifier for the type of location associated with the assignment |
Nursestation Adt Id | Root | The Nursing Station ADT ID of the assignment location |
Patient Age | Root | The age of the person receiving medical treatment at the time of the visit. |
Patient Diagnosis | Root | The cause of the patient's disease or injury that is believed to be the primary reason that the patient needs medical attention at the current time. |
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 Id | Root | Unique identification number for the patient. |
Patient Lastname | Root | The last name of the person receiving medical treatment. |
Patient Level Of Care | Root | The degree of care that the patient requires, such as critical, acute, intermediate. |
Patient Mrn | Root | The medical record number for 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 Type | Root | Name of the category for the patient, such as pre-admit, acute care, inpatient, etc. |
Patient Visit Number | Root | Patient's visit number/account number. |
Priority | Root | The specific priority applied to the location |
Removal Source | Root | The manner in which the priority was removed |
Removed By | Root | The employee who removed the priority |
Removed Timestamp | Root | The time the priority was removed in local time |
Removed Timestamp Enterprise | Root | The time the priority was removed in Enterprise time |
Removed Timestamp Utc | Root | The time the priority was removed in UTC |
Room | Root | The room associated with the location. |
Room Adt Id | Root | A unique identifier associated with the room |
Room Id | Root | A unique identifier associated with the room |
Tenantid | Root | Tenant GUID - Non-Strict Dynamic Partition Column. |
Unit | Root | The unit associated with the location which had an assignment |
Unit Category Code | Root | The grouping of units that is associated with the unit |
Unit Category Name | Root | The grouping of units that is associated with the unit |
Unit Category Type Id | Root | The grouping of units that is associated with the unit |
Unit Discipline | Root | The name of a group of specially related units, such as Surgical, Medical, Adolescent Medicine, Maternal/Child, Behavior Health, Med/Surgical, Burn that include the assignment location |
Unit Id | Root | A unique identifier associated with the unit. |
Warehouseacquisitiondate Utc | Root | The latest timestamp that a record is inserted in the Snowflake Data Warehouse in UTC format. |