Data Points
Snowflake Field Name | Tableau Data Source Field | Folder | Definition |
N/A | Bed Supervisor Name | Root | Each bed supervisor's name from the contacted facility. |
N/A | Case Created Timestamp | Root | Created date in local time zone for when the record was entered into Case Tab (OpenTransfers) on OPTC. |
N/A | Case Created Timestamp UTC | Root | Created date in UTC for when the record was entered into Case Tab (OpenTransfers) on OPTC. |
N/A | Case Created to Escalated Decision Time | Root | Case created to escalation AOC final decision date time for the contacted facility (Calculation: Escalated Decision Timestamp minus Case Created Timestamp) |
N/A | Case Created to Escalated Time | Root | Case created to escalation page date time for the contacted facility (Calculation: Escalated Paged Timestamp minus Case Created Timestamp) |
N/A | Case Created to Facility Decision Time | Root | Case created to facility's decision date time for the contacted facility (Calculation: Facility Decision Timestamp minus Case Created Timestamp). |
N/A | Case Created to Facility Paged Time | Root | Case created to page date time for the contacted facility (Calculation: Facility Paged Timestamp minus Case Created Timestamp). |
N/A | Case Disposition | Root | Comes from the Disposition tab on Case in OPTC - Disposition. |
N/A | Case Disposition Reason | Root | Comes from the Disposition tab on Case in OPTC - Disposition Reason. |
N/A | Case LastMod Date | Root | LastMod Date in local time zone for when the record was modified into Case Tab (OpenTransfers) on OPTC. |
N/A | Case LastMod Date UTC | Root | LastMod Date in UTC zone for when the record was modified into Case Tab (OpenTransfers) on OPTC. |
N/A | Created Date | Root | Created Date in Local Time zone for when the record was entered into Facility Communication Tab on OPTC. |
N/A | Created Date UTC | Root | Created Date in UTC for when the record was entered into Facility Communication Tab on OPTC. |
N/A | Date Filter | Root | Used to select a specific range of dates. |
N/A | Date Partition | Root | Non-Strict Dynamic Partition Column. |
N/A | Facility Decision Timestamp | Root | The contacted facility's decision date time. |
N/A | Facility Disposition | Root | The disposition on contact of the contacted facility. |
N/A | Facility Disposition Reason | Root | The disposition reason on contact of the contacted facility. |
N/A | Facility Name | Root | The name of the contacted facility. |
N/A | Facility Paged Timestamp | Root | Paged date time for each facility. |
N/A | Facility Paged to Decision Time | Root | Facility first contacted/paged to decision timestamp for the contacted facility (Calculation: Facility Decision Timestamp minus Facility Paged Timestamp) |
N/A | Escalated Decision Timestamp | Root | Escalation AOC Final Decision Date Time for the contacted facility (this may be NULL). |
N/A | Escalated Paged Timestamp | Root | Escalation AOC paged date time for the contacted facility. |
N/A | Escalation Disposition | Root | The final disposition on escalation through AOC of the contacted facility. |
N/A | Escalated to Escalated Decision Time | Root | Escalation Page time to Escalation final decision timestamp for the contacted facility (Calculation: Escalated Decision Timestamp minus Escalated Paged Timestamp) |
N/A | Escalation Officer Name | Root | The name of AOC for the contacted facility if the case was escalated at that facility (this may be NULL). |
N/A | Is Escalated at Facility | Root | Should be set to True for each facility if the case was escalated at that facility. Otherwise, the field should be False. |
N/A | LastMod Date | Root | LastMod Date in Local Time zone for when the record was modified into Facility Communication Tab on OPTC. |
N/A | LastMod Date UTC | Root | LastMod Date in UTC zone for when the record was modified into Facility Communication Tab on OTPC. |
N/A | Tenant ID | Root | Tenant GUID - Non-Strict Dynamic Partition Column. |
N/A | Transfer Case Number | Root | Unique Transfer ID assigned to each case. |
WAREHOUSEACQUISITIONDATE_UTC | WAREHOUSEACQUISITIONDATE_UTC | System Calc | The latest timestamp that a record is inserted in the Snowflake Data Warehouse in UTC format. |