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. |
BASE_CAMPUS | Root | The campus that is associated with the employee's base location, as set in TeleTracking Capacity IQ® Admin Tool. |
BASE_CAMPUS_ADT_ID | System Calc | The ADT ID of the campus associated with user based on their base location. |
BASE_CAMPUS_ID | System Calc | A system identifier for the base campus of the employee based on their base location, not visible to users of the application. |
BASE_CUSTOMER_FACILITY_ID | Root | A unique identifier for a given campus that is defined in the Capacity IQ® campus settings for use with Transfer IQ® facility IDs—used more widely in DWC. This is the campus associated with the user's base location. |
BASE_LOCATION | Root | The bed location that is associated with the employee's base location, as set in TeleTracking Capacity IQ® Admin Tool. |
BASE_LOCATION_ADT_ID | System Calc | The ADT ID of the location associated with user based on their base location. |
BASE_LOCATION_ID | System Calc | A system identifier for the base location of the employee, not visible to users of the application. |
BASE_ROOM_ADT_ID | System Calc | The ADT ID of the room associated with user based on their base location. |
BASE_UNIT | Root | The unit that is associated with the employee's base location, as set in TeleTracking Capacity IQ® Admin Tool. |
BASE_UNIT_ADT_ID | System Calc | The ADT ID of the unit that is associated with the employee's base location, as set in TeleTracking Capacity IQ® Admin Tool. |
BASE_UNIT_DISCIPLINE | Root | The name of the discipline that is associated with the unit that is associated with the user's base location. This a group of specially related units, such as Surgical, Medical, Adolescent Medicine, Maternal/Child, Behavior Health, Med/Surgical, Burn. |
BASE_UNIT_DISCIPLINE_ID | System Calc | The IS of the discipline that is associated with the unit that is associated with the user's base location. This a group of specially related units, such as Surgical, Medical, Adolescent Medicine, Maternal/Child, Behavior Health, Med/Surgical, Burn. |
BASE_UNIT_ID | System Calc | A system identifier for the base unit of the employee, not visible to users of the application. |
CLOUDACQUISITIONDATE_UTC | System Calc | The second step in the data ingestion process that is used internally for latency calculations. This field is not intended for client report building. |
EMPLOYEE_LOGIN_ID | System Calc | The unique username associated with the employee. |
EMPLOYEE_NAME | Root | Full name (in the format of FN MI LN) of the employee |
EMPLOYEE_STATUS_TIMESTAMP | Root | The latest date and local time of day when the employee status is updated |
EMPLOYEE_STATUS_TIMESTAMP_ENTERPRISE | Root | The latest date and enterprise time of day when the employee status is updated. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings. |
EMPLOYEE_STATUS_TIMESTAMP_UTC | Root | The latest date and UTC time of day when the employee status is updated |
EMPLOYEE_STATUS_TYPE | Root | The status of the employee. Values can include: Dispatched, Delay/Dispatched, In Progress, Delay/In Progress, Assist, Break/Lunch, In, Available, Out |
EMPLOYEE_STATUS_TYPE_CODE | System Calc | System calculation used for localization filtering that displays the Employee Status Type. This field is not intended for client report building. |
EMPLOYEE_STATUS_TYPE_ID | System Calc | A system identifier for the Employee Status Type not visible to users of the application. |
EMPLOYEE_USER_ID | System Calc | The id of the user. This field is not intended for client report building. |
ENTERPRISE | Root | The name of a collection of campuses. |
INSTANCEID | System Calc | System calculation used for data partitioning. This field is not intended for client reporting. |
LASTMODDATE | System Calc | System calculation that displays the most recent update to the application database 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 application database in enterprise time. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings.This field is not intended for client reporting. |
LASTMODDATE_UTC | System Calc | System calculation that displays the most recent update to the application database in UTC time. This field is not intended for client reporting. |
LATEST_LASTMODDATE | System Calc | System calculation that displays the most recent update to the application database in local time. This field is not intended for client reporting. |
LATEST_LASTMODDATE_ENTERPRISE | System Calc | System calculation that displays the most recent update to the application database in enterprise time. The enterprise time is in the timezone configured in the Operations IQ® Platform enterprise settings.This field is not intended for client reporting. |
LATEST_LASTMODDATE_UTC | System Calc | System calculation that displays the most recent update to the application database in UTC time. This field is not intended for client reporting. |
TENANTID | System Calc | The unique identifier associated with the tenant. This field is not intended for client reporting. |
WAREHOUSEACQUISITIONDATE_UTC | System Calc | The latest timestamp that a record is inserted in the Snowflake Data Warehouse in UTC format. |
Zone Names | Root | A comma-separated list of the names of the zones where the employee is assigned and available to receive a new job at the time of the employee status record. Returns NULL when the employee has no active zone assignment and All Zones when the employee is assigned to all zones. |
Zone IVRIDs | Root | A comma-separated list of the IVR IDs for those same zones, in the same order as Zone Names. Returns NULL when the employee has no active zone assignment and All Zones when the employee is assigned to all zones. |