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 enterprise date and 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: In Progress, Available, Break, Lunch, Logged In

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.