Clinical Science

Attribute or measure name Table field Archive source table
Encounter State ID Encounter State ID WFM_ClscEncounterState
Encounter ID Encounter ID WFM_ClscEncounterState
Triage Event ID Triage Event ID WFM_ClscEncounterState
Unit ID Unit ID WFM_ClscEncounterState
Unit Bed ID Unit Bed ID WFM_ClscEncounterState
Temporary Unit ID Temporary Unit ID WFM_ClscEncounterState
Patient Care Type ID Patient Care Type ID WFM_ClscEncounterState
Patient Care Service ID Patient Care Service ID WFM_ClscEncounterState
Encounter State Effective Start Date Encounter State Effective Start Date WFM_ClscEncounterState
Encounter State Effective End Date Encounter State Effective End Date WFM_ClscEncounterState
Encounter State UTC Insert Date Encounter State UTC Insert Date WFM_ClscEncounterState
Encounter State UTC Update Date Encounter State UTC Update Date WFM_ClscEncounterState
Is Deleted Deleted WFM_ClscEncounterState
Variation Variation WFM_ClscEncounterState
Data Lake Time Stamp Data Lake Time Stamp WFM_ClscEncounterState
Encounter State Start Time Encounter State Effective Start Date WFM_ClscEncounterState
Length of Stay WFM_ClscUnitBudget
Patient ID Patient ID WFM_ClscUnitBudget
Team ID Workbrain Team ID WFM_ClscUnitBudget
Unit Budget ID Unit Budget ID WFM_ClscUnitBudget
Unit Budget Start Date Unit Budget Start Date WFM_ClscUnitBudget
Unit Budget End Date Unit Budget End Date WFM_ClscUnitBudget
Unit Budget Hours Per Patient Day Unit Budget Hours Per Patient Day WFM_ClscUnitBudget
Unit Budget UTC Insert Date Unit Budget UTC Insert Date WFM_ClscUnitBudget
Unit Budget UTC Update Date Unit Budget UTC Update Date WFM_ClscUnitBudget
Unit Budget Patient Category ID Unit Budget Patient Category ID WFM_ClscUnitBudget
Patient Care Type Category ID Patient Care Type Category ID WFM_ClscUnitBudget
Unit Budget Patient Category PtDayNum Unit Budget Patient Category PtDayNum WFM_ClscUnitBudget
Unit Budget Patient Category UTC Insert Date Unit Budget Patient Category UTC Insert Date WFM_ClscUnitBudget
Unit Budget Patient Category UTC Update Date Unit Budget Patient Category UTC Update Date WFM_ClscUnitBudget
Unit Detail ID WFM_ClscUnitDetail
Unit Government Reporting Code ID Unit Government Reporting Code ID WFM_ClscUnitDetail
Workbrain User ID Workbrain User ID WFM_ClscUnitDetail
Workbrain User Actual ID Workbrain User Actual ID WFM_ClscUnitDetail
Unit Detail Gndb Num Unit Detail Gndb Num WFM_ClscUnitDetail
Unit Detail Available Beds Unit Detail Available Beds WFM_ClscUnitDetail
Unit Detail Licensed Beds Unit Detail Licensed Beds WFM_ClscUnitDetail
Unit Detail Fatigue Factor Unit Detail Fatigue Factor WFM_ClscUnitDetail
Unit Detail Effective Start Date Unit Detail Effective Start Date WFM_ClscUnitDetail
Unit Detail Effective End Date Unit Detail Effective End Date WFM_ClscUnitDetail
Unit Detail UTC Insert Date Unit Detail UTC Insert Date WFM_ClscUnitDetail
Unit Detail UTC Update Date Unit Detail UTC Update Date WFM_ClscUnitDetail
Workload ID Workload ID WFM_ClscWorkload
Unit Intervention ID Unit Intervention ID WFM_ClscWorkload
Care Giver ID Care Giver ID WFM_ClscWorkload
Work Date Work Date WFM_ClscWorkload
Workload Minutes Workload Minutes WFM_ClscWorkload
Workload UTC Insert Date Workload UTC Insert Date WFM_ClscWorkload
Workload UTC Update Date Workload UTC Update Date WFM_ClscWorkload
Assignment Patient History ID Assignment Patient History ID WFM_ClscAsgmtSummary
Assignment Summary ID Assignment Summary ID WFM_ClscAsgmtSummary
Assignment Type ID Assignment Type ID WFM_ClscAsgmtSummary
Assignment Patient History Action Date Assignment Patient History Action Date WFM_ClscAsgmtSummary
Assignment Patient History UTC Insert Date Assignment Patient History UTC Insert Date WFM_ClscAsgmtSummary
Assignment Patient History UTC Update Date Assignment Patient History UTC Update Date WFM_ClscAsgmtSummary
Assignment Action Type ID Assignment Action Type ID WFM_ClscAsgmtSummary
Assignment Primary Employee ID Assignment Primary Employee ID WFM_ClscAsgmtSummary
Unit Day Part ID Unit Day Part ID WFM_ClscAsgmtSummary
Assignment Summary Date Assignment Summary Date WFM_ClscAsgmtSummary
Assignment Summary Published Assignment Summary Published WFM_ClscAsgmtSummary
Assignment Summary Flag1 Assignment Summary Flag1 WFM_ClscAsgmtSummary
Assignment Summary Flag2 Assignment Summary Flag2 WFM_ClscAsgmtSummary
Assignment Summary Flag3 Assignment Summary Flag3 WFM_ClscAsgmtSummary
Assignment Summary Flag4 Assignment Summary Flag4 WFM_ClscAsgmtSummary
Assignment Summary Flag5 Assignment Summary Flag5 WFM_ClscAsgmtSummary
Assignment Summary Udf1 Assignment Summary Udf1 WFM_ClscAsgmtSummary
Assignment Summary Udf2 Assignment Summary Udf2 WFM_ClscAsgmtSummary
Assignment Summary Udf3 Assignment Summary Udf3 WFM_ClscAsgmtSummary
Assignment Summary Udf4 Assignment Summary Udf4 WFM_ClscAsgmtSummary
Assignment Summary Udf5 Assignment Summary Udf5 WFM_ClscAsgmtSummary
Assignment Summary UTC Insert Date Assignment Summary UTC Insert Date WFM_ClscAsgmtSummary
Assignment Summary UTC Update Date Assignment Summary UTC Update Date WFM_ClscAsgmtSummary
Assignment Summary Start Date Assignment Summary Start Date WFM_ClscAsgmtSummary
Assignment Summary End Date Assignment Summary End Date WFM_ClscAsgmtSummary
Encounter Number Encounter Number WFM_ClscEncounterState
Admit Type ID Admit Type ID WFM_ClscEncounterState
Encounter Admit Date Encounter Admit Date WFM_ClscEncounterState
Encounter Discharge Date Encounter Discharge Date WFM_ClscEncounterState
Encounter UTC Insert Date Encounter UTC Insert Date WFM_ClscEncounterState
Encounter IsDeleted Encounter IsDeleted WFM_ClscEncounterState
Encounter UTC Update Date Encounter UTC Update Date WFM_ClscEncounterState
Encounter State ID Encounter State ID WFM_ClscEncounterState
Encounter State Unit Is Fresh Encounter State Unit Is Fresh WFM_ClscEncounterState
Encounter State Unit Bed Is Fresh Encounter State Unit Bed Is Fresh WFM_ClscEncounterState
Encounter State Temp Unit Is Fresh Encounter State Temp Unit Is Fresh WFM_ClscEncounterState
Encounter State Patient Care Type Is Fresh Encounter State Patient Care Type Is Fresh WFM_ClscEncounterState
Encounter State Patient Care Service Is Fresh Encounter State Patient Care Service Is Fresh WFM_ClscEncounterState
Encounter State Is Signed Out Encounter State Is Signed Out WFM_ClscEncounterState
Encounter State Is Deleted Encounter State Is Deleted WFM_ClscEncounterState
Encounter State UTC Insert Date Encounter State UTC Insert Date WFM_ClscEncounterState
Encounter State UTC Update Date Encounter State UTC Update Date WFM_ClscEncounterState
Job Team ID Job Team ID WFM_ClscJobTeam
Workbrain Team ID Workbrain Team ID WFM_ClscJobTeam
Job ID Job ID WFM_ClscJobTeam
Job Team Is Unit Producing Job Team Is Unit Producing WFM_ClscJobTeam
Job Team Is Gndb Job Team Is Gndb WFM_ClscJobTeam
Job Team Is Rn Job For Ratios Job Team Is Rn Job For Ratios WFM_ClscJobTeam
Job Team Is Primary Emp Job Job Team Is Primary Emp Job WFM_ClscJobTeam
Job Team Is Support Emp Job Job Team Is Support Emp Job WFM_ClscJobTeam
Job Team Is In Cs Autoassign Job Team Is In Cs Autoassign WFM_ClscJobTeam
Job Team Flag1 Job Team Flag1 WFM_ClscJobTeam
Job Team Flag2 Job Team Flag2 WFM_ClscJobTeam
Job Team Flag3 Job Team Flag3 WFM_ClscJobTeam
Job Team Flag4 Job Team Flag4 WFM_ClscJobTeam
Job Team Flag5 Job Team Flag5 WFM_ClscJobTeam
Job Team Udf1 Job Team Udf1 WFM_ClscJobTeam
Job Team Udf2 Job Team Udf2 WFM_ClscJobTeam
Job Team Udf3 Job Team Udf3 WFM_ClscJobTeam
Job Team Udf4 Job Team Udf4 WFM_ClscJobTeam
Job Team Udf5 Job Team Udf5 WFM_ClscJobTeam
Job Team UTC Insert Date Job Team UTC Insert Date WFM_ClscJobTeam
Job Team UTC Update Date Job Team UTC Update Date WFM_ClscJobTeam
Unit Is Active Unit Is Active WFM_ClscUnitBudget
Unit Budget Name Unit Budget Name WFM_ClscUnitBudget
Unit Budget Description Unit Budget Description WFM_ClscUnitBudget
Unit Budget Start Date Unit Budget Start Date WFM_ClscUnitBudget
Unit Budget Flag1 Unit Budget Flag1 WFM_ClscUnitBudget
Unit Budget Flag2 Unit Budget Flag2 WFM_ClscUnitBudget
Unit Budget Flag3 Unit Budget Flag3 WFM_ClscUnitBudget
Unit Budget Flag4 Unit Budget Flag4 WFM_ClscUnitBudget
Unit Budget Flag5 Unit Budget Flag5 WFM_ClscUnitBudget
Unit Budget Udf1 Unit Budget Udf1 WFM_ClscUnitBudget
Unit Budget Udf2 Unit Budget Udf2 WFM_ClscUnitBudget
Unit Budget Udf3 Unit Budget Udf3 WFM_ClscUnitBudget
Unit Budget Udf4 Unit Budget Udf4 WFM_ClscUnitBudget
Unit Budget Udf5 Unit Budget Udf5 WFM_ClscUnitBudget
Unit Budget Job ID Unit Budget Job ID WFM_ClscUnitBudgetJob
Unit Budget Job Annual Hours Unit Budget Job Annual Hours WFM_ClscUnitBudgetJob
Unit Budget Job Flag1 Unit Budget Job Flag1 WFM_ClscUnitBudgetJob
Unit Budget Job Flag2 Unit Budget Job Flag2 WFM_ClscUnitBudgetJob
Unit Budget Job Flag3 Unit Budget Job Flag3 WFM_ClscUnitBudgetJob
Unit Budget Job Flag4 Unit Budget Job Flag4 WFM_ClscUnitBudgetJob
Unit Budget Job Flag5 Unit Budget Job Flag5 WFM_ClscUnitBudgetJob
Unit Budget Job Udf1 Unit Budget Job Udf1 WFM_ClscUnitBudgetJob
Unit Budget Job Udf2 Unit Budget Job Udf2 WFM_ClscUnitBudgetJob
Unit Budget Job Udf3 Unit Budget Job Udf3 WFM_ClscUnitBudgetJob
Unit Budget Job Udf4 Unit Budget Job Udf4 WFM_ClscUnitBudgetJob
Unit Budget Job Udf5 Unit Budget Job Udf5 WFM_ClscUnitBudgetJob
Unit Budget Job UTC Insert Date Unit Budget Job UTC Insert Date WFM_ClscUnitBudgetJob
Unit Budget Job UTC Update Date Unit Budget Job UTC Update Date WFM_ClscUnitBudgetJob
Unit Budget Patient Category PtDayNum Unit Budget Patient Category PtDayNum WFM_ClscUnitBudgetPtCat
Unit Budget Patient Category Flag1 Unit Budget Patient Category Flag1 WFM_ClscUnitBudgetPtCat
Unit Budget Patient Category Flag2 Unit Budget Patient Category Flag2 WFM_ClscUnitBudgetPtCat
Unit Budget Patient Category Flag3 Unit Budget Patient Category Flag3 WFM_ClscUnitBudgetPtCat
Unit Budget Patient Category Flag4 Unit Budget Patient Category Flag4 WFM_ClscUnitBudgetPtCat
Unit Budget Patient Category Flag5 Unit Budget Patient Category Flag5 WFM_ClscUnitBudgetPtCat
Unit Budget Patient Category Udf1 Unit Budget Patient Category Udf1 WFM_ClscUnitBudgetPtCat
Unit Budget Patient Category Udf2 Unit Budget Patient Category Udf2 WFM_ClscUnitBudgetPtCat
Unit Budget Patient Category Udf3 Unit Budget Patient Category Udf3 WFM_ClscUnitBudgetPtCat
Unit Budget Patient Category Udf4 Unit Budget Patient Category Udf4 WFM_ClscUnitBudgetPtCat
Unit Budget Patient Category Udf5 Unit Budget Patient Category Udf5 WFM_ClscUnitBudgetPtCat
Unit Detail Is Workload Shift Adjusted Unit Detail Is Workload Shift Adjusted WFM_ClscUnitDetail
Unit Detail Flag1 Unit Detail Flag1 WFM_ClscUnitDetail
Unit Detail Flag2 Unit Detail Flag2 WFM_ClscUnitDetail
Unit Detail Flag3 Unit Detail Flag3 WFM_ClscUnitDetail
Unit Detail Flag4 Unit Detail Flag4 WFM_ClscUnitDetail
Unit Detail Flag5 Unit Detail Flag5 WFM_ClscUnitDetail
Unit Detail Udf1 Unit Detail Udf1 WFM_ClscUnitDetail
Unit Detail Udf2 Unit Detail Udf2 WFM_ClscUnitDetail
Unit Detail Udf3 Unit Detail Udf3 WFM_ClscUnitDetail
Unit Detail Udf4 Unit Detail Udf4 WFM_ClscUnitDetail
Unit Detail Udf5 Unit Detail Udf5 WFM_ClscUnitDetail
Workload Is Preselected Workload Is Preselected WFM_ClscWorkload
Workload Is Autoselected Workload Is Autoselected WFM_ClscWorkload
Workload Is Deleted Workload Is Deleted WFM_ClscWorkload
Workload Is Indirect Workload Is Indirect WFM_ClscWorkload