IFS Tabular Model: Maintenance

This Tabular Model is used for: Maintenance. There is a list of Tabular Models pre-packaged and delivered as a part of IFS Analysis Models, and you can refer to them here.

Contents

Usage/Purpose

Main analysis scenarios are:

Fact Tables

Model Table DW Source view (SQL Server) BI Access View Referenced Information Source Recommended Access Type
ASSET HEALTH MEASURES FACT_ASSET_HEALTH_TM FACT_ASSET_HEALTH_BI FACT_ASSET_HEALTH On Line
CURRENCY RATES FACT_CURRENCY_RATES_TM FACT_CURRENCY_RATES_BI FACT_CURRENCY_RATES On Line
FACT TIME DIM_BI_TIME_BI DIM_BI_TIME_BI DIM_BI_TIME On Line
FACT WORK ORDER FACT_WORK_ORDER_TM FACT_WORK_ORDER_BI FACT_WORK_ORDER Data Mart
FACT WORK TASK FACT_WORK_TASK_TM FACT_WORK_TASK_BI FACT_WORK_TASK Data Mart
WO BUDGET FACT_WO_BUDGET_TM FACT_WO_BUDGET_BI FACT_WO_BUDGET Data Mart
WORK TASK ACTUALS COST FACT_WORK_TASK_ACTUALS_COST_TM FACT_WORK_TASK_ACTUALS_COST_BI FACT_WORK_TASK_ACTUALS_COST Data Mart
WORK TASK ACTUALS SALES FACT_WO_TASK_ACTUALS_SALES_TM FACT_WO_TASK_ACTUALS_SALES_BI FACT_WO_TASK_ACTUALS_SALES Data Mart
WORK TASK PLANNED FACT_WORK_TASK_PLANNED_TM FACT_WORK_TASK_PLANNED_BI FACT_WORK_TASK_PLANNED Data Mart
WORK TASK POSTINGS FACT_JT_TASK_ACCOUNTING_TM FACT_JT_TASK_ACCOUNTING_BI FACT_JT_TASK_ACCOUNTING Data Mart

 Corresponding Information Sources are described below. Detailed infomation about Information Sources can be found in About Information Sources

FACT_WO_TASK_ACTUALS_SALES
Work Order Actuals Sales Information Source is based on revenues related to Work Tasks. This Information Source carries transactions for time reporting, material issues, tools usages, expenses like revenue amounts.

FACT_WORK_TASK_ACTUALS_COST
Work Task Actuals Cost Information Source is based on costs related to Work Tasks. This information source carries transactions for Expenses, External, Fixed Price, Material, Personnel and Tool/Equipment.

FACT_WO_BUDGET
Work Order Budget Information Source is based on the manually entered budget costs and revenues on workorders. It should mainly be used in conjunction with Work Order Actuals information source for analysis.

FACT_WORK_TASK_PLANNED
Work Task Planned Information Source is based on the planning lines on the work tasks. It should mainly be used in conjunction with Work Task Actuals information source for analysis.

FACT_WORK_ORDERS
Work Order Information Source is based on IFS\Work Orders. This information source carries work orders in all statuses, i.e both active and historical work orders as well as work requests and fault reports.

FACT_WORK_TASK
A work order can have one or more work tasks connected to it. Work task is an entity which executes the work initiated, for example through a Fault Report or Service request. If IFS/Service Management is used, performed maintenance activities are reported, monitored and invoiced to customer through work tasks.

FACT_JT_TASK_ACCOUNTING
Work Task Accounting Information Source is based on actual transactions related to Work Tasks. It combines data from Work Order, Work Task, Work Task Transaction and Work Task Cost

Dimension Tables

Model Table DW Source view (SQL Server) BI Access View Referenced Information Source Recommended Access Type
ACCOUNT DIM_ACCOUNT_TM DIM_ACCOUNT_BI DIM_ACCOUNT On Line
ACTIVITY DIM_ACTIVITY_TM DIM_ACTIVITY_BI DIM_ACTIVITY On Line
ACTUAL EQUIPMENT OBJECT DIM_EQUIPMENT_OBJECT_TM DIM_EQUIPMENT_OBJECT_BI DIM_EQUIPMENT_OBJECT On Line
ACTUAL FINISH DATE DIM_BI_TIME_BI DIM_BI_TIME_BI DIM_BI_TIME On Line
ACTUAL OBJECT SITE DIM_SITE_TM DIM_SITE_BI DIM_SITE On Line
ACTUAL START DATE DIM_BI_TIME_BI DIM_BI_TIME_BI DIM_BI_TIME On Line
ASSET HEALTH FACT_ASSET_HEALTH_TM FACT_ASSET_HEALTH_BI FACT_ASSET_HEALTH On Line
ASSET HEALTH DIMENSION DIM_ASSET_HEALTH_TM DIM_ASSET_HEALTH_BI DIM_ASSET_HEALTH On Line
ASSET HEALTH HISTORY FACT_ASSET_HEALTH_HISTORY_TM FACT_ASSET_HEALTH_HISTORY_BI FACT_ASSET_HEALTH_HISTORY On Line
ASSET HEALTH INDI HST FACT_ASSET_HEALTH_INDI_HST_TM FACT_ASSET_HEALTH_INDI_HST_BI FACT_ASSET_HEALTH_INDI_HST On Line
ASSET HEALTH INDICATOR FACT_ASSET_HEALTH_INDICATOR_TM FACT_ASSET_HEALTH_INDICATOR_BI FACT_ASSET_HEALTH_INDICATOR On Line
ASSET HEALTH INDICATOR DIMENSION DIM_ASSET_HEALTH_INDICATOR_TM DIM_ASSET_HEALTH_INDICATOR_BI DIM_ASSET_HEALTH_INDICATOR On Line
ASSET HEALTH LEVEL FACT_ASSET_HEALTH_LEVEL_TM FACT_ASSET_HEALTH_LEVEL_BI FACT_ASSET_HEALTH_LEVEL On Line
ASSET TYPE DIM_ASSET_TYPE_TM DIM_ASSET_TYPE_BI DIM_ASSET_TYPE On Line
CANCEL TASK CAUSE DIM_CANCEL_TASK_CAUSE_TM DIM_CANCEL_TASK_CAUSE_BI DIM_CANCEL_TASK_CAUSE On Line
CAUSE DIM_CAUSE_TM DIM_CAUSE_BI DIM_CAUSE On Line
CLASS DIM_CLASS_TM DIM_CLASS_BI DIM_CLASS On Line
CODE B DIM_CODE_B_TM DIM_CODE_B_BI DIM_CODE_B On Line
CODE C DIM_CODE_C_TM DIM_CODE_C_BI DIM_CODE_C On Line
CODE D DIM_CODE_D_TM DIM_CODE_D_BI DIM_CODE_D On Line
CODE E DIM_CODE_E_TM DIM_CODE_E_BI DIM_CODE_E On Line
CODE F DIM_CODE_F_TM DIM_CODE_F_BI DIM_CODE_F On Line
CODE G DIM_CODE_G_TM DIM_CODE_G_BI DIM_CODE_G On Line
CODE H DIM_CODE_H_TM DIM_CODE_H_BI DIM_CODE_H On Line
CODE I DIM_CODE_I_TM DIM_CODE_I_BI DIM_CODE_I On Line
CODE J DIM_CODE_J_TM DIM_CODE_J_BI DIM_CODE_J On Line
COLOR LEVEL EAM_COLOR_LEVEL N/A EAM_COLOR_LEVEL On Line
COMPANY DIM_COMPANY_TM DIM_COMPANY_BI DIM_COMPANY On Line
COMPATIBLE UNIT DIM_CMPUNT_COMPATIBLE_UNIT_TM DIM_CMPUNT_COMPATIBLE_UNIT_BI DIM_CMPUNT_COMPATIBLE_UNIT On Line
CREATED DATE DIM_BI_TIME_BI DIM_BI_TIME_BI DIM_BI_TIME On Line
CRITICALITY DIM_CRITICALITY_TM DIM_CRITICALITY_BI DIM_CRITICALITY On Line
CUSTOMER DIM_CUSTOMER_TM DIM_CUSTOMER_BI DIM_CUSTOMER On Line
DISCOVERY DIM_DISCOVERY_TM DIM_DISCOVERY_BI DIM_DISCOVERY On Line
EQUIPMENT OBJECT DIM_EQUIPMENT_OBJECT_TM DIM_EQUIPMENT_OBJECT_BI DIM_EQUIPMENT_OBJECT On Line
EVENT DIM_EVENT_TM DIM_EVENT_BI DIM_EVENT On Line
EnvPath EAM_ENVIRONMENT_PATH N/A EAM_ENVIRONMENT_PATH On Line
FAILING COMPONENT DIM_FAILING_COMPONENT_TM DIM_FAILING_COMPONENT_BI DIM_FAILING_COMPONENT On Line
FAULT TYPE DIM_FAULT_TYPE_TM DIM_FAULT_TYPE_BI DIM_FAULT_TYPE On Line
HEALTH LEVEL EAM_HEALTH_LEVEL N/A EAM_HEALTH_LEVEL On Line
ITEM CLASS DIM_ITEM_CLASS_TM DIM_ITEM_CLASS_BI DIM_ITEM_CLASS On Line
ITEM CLASS FUNCTION DIM_ITEM_CLASS_FUNCTION_TM DIM_ITEM_CLASS_FUNCTION_BI DIM_ITEM_CLASS_FUNCTION On Line
ITEM CLASS SOURCE DIM_IC_SOURCE_TYPE_TM DIM_IC_SOURCE_TYPE_BI DIM_IC_SOURCE_TYPE On Line
LINEAR ASSET DIM_LINAST_LINEAR_ASSET_TM DIM_LINAST_LINEAR_ASSET_BI DIM_LINAST_LINEAR_ASSET On Line
OPERATIONAL STATUS DIM_OPERATIONAL_STATUS_TM DIM_OPERATIONAL_STATUS_BI DIM_OPERATIONAL_STATUS On Line
ORGANIZATION DIM_ORGANIZATION_TM DIM_ORGANIZATION_BI DIM_ORGANIZATION On Line
ORGANIZATION SITE DIM_SITE_TM DIM_SITE_BI DIM_SITE On Line
PERFORMED ACTION DIM_PERFORMED_ACTION_TM DIM_PERFORMED_ACTION_BI DIM_PERFORMED_ACTION On Line
PLANNED DATE DIM_BI_TIME_BI DIM_BI_TIME_BI DIM_BI_TIME On Line
PLANNED FINISH DATE DIM_BI_TIME_BI DIM_BI_TIME_BI DIM_BI_TIME On Line
PLANNED START DATE DIM_BI_TIME_BI DIM_BI_TIME_BI DIM_BI_TIME On Line
PM GROUP DIM_PM_GROUP_TM DIM_PM_GROUP_BI DIM_PM_GROUP On Line
PRIORITY DIM_PRIORITY_TM DIM_PRIORITY_BI DIM_PRIORITY On Line
PROJECT DIM_PROJECT_TM DIM_PROJECT_BI DIM_PROJECT On Line
PROJECT PROGRAM DIM_PROJECT_PROGRAM_TM DIM_PROJECT_PROGRAM_BI DIM_PROJECT_PROGRAM On Line
REPORTED EQUIPMENT OBJECT DIM_EQUIPMENT_OBJECT_TM DIM_EQUIPMENT_OBJECT_BI DIM_EQUIPMENT_OBJECT On Line
REPORTED OBJECT SITE DIM_SITE_TM DIM_SITE_BI DIM_SITE On Line
REPORTING CURRENCY DIM_REPORTING_CURRENCY_TM FACT_CURRENCY_RATES_BI,LUP_REP_CURR_RATE_TYPE_TC,DIM_CURRENCY_CODE_BI,DIM_CURRENCY_RATE_TYPE_BI DIM_REPORTING_CURRENCY On Line
REPORTING DATE DIM_BI_TIME_BI DIM_BI_TIME_BI DIM_BI_TIME On Line
REPORTING PERIOD DIM_REPORTING_PERIOD_MAINTENANCE_TM DIM_RDP_COMPANY_PERIOD_BI DIM_REPORTING_PERIOD_MAINTENANCE On Line
REQUIRED FINISH DATE DIM_BI_TIME_BI DIM_BI_TIME_BI DIM_BI_TIME On Line
REQUIRED START DATE DIM_BI_TIME_BI DIM_BI_TIME_BI DIM_BI_TIME On Line
SALES PART DIM_SALES_PART_TM DIM_SALES_PART_BI DIM_SALES_PART On Line
SERVICE CONTRACT DIM_SERVICE_CONTRACT_LINE_TM DIM_SERVICE_CONTRACT_LINE_BI DIM_SERVICE_CONTRACT_LINE On Line
SITE DIM_SITE_TM DIM_SITE_BI DIM_SITE On Line
SLA LATEST FINISH DATE DIM_BI_TIME_BI DIM_BI_TIME_BI DIM_BI_TIME On Line
SLA LATEST START DATE DIM_BI_TIME_BI DIM_BI_TIME_BI DIM_BI_TIME On Line
SLA ORDER DIM_SLA_ORDER_TM DIM_SLA_ORDER_BI DIM_SLA_ORDER On Line
SLA ORDER LINE DIM_SLA_ORDER_LINE_TM DIM_SLA_ORDER_LINE_BI DIM_SLA_ORDER_LINE On Line
SOURCE CONNECTION DIM_JT_CONNECTED_OBJECT_TM DIM_JT_CONNECTED_OBJECT_BI DIM_JT_CONNECTED_OBJECT On Line
SOURCE OBJECT DIM_SOURCE_OBJECT_TM DIM_SOURCE_OBJECT_BI DIM_SOURCE_OBJECT On Line
SOURCE SITE DIM_SITE_TM DIM_SITE_BI DIM_SITE On Line
SUB PROJECT DIM_SUB_PROJECT_TM DIM_SUB_PROJECT_BI DIM_SUB_PROJECT On Line
SUPPLIER DIM_SUPPLIER_TM DIM_SUPPLIER_BI DIM_SUPPLIER On Line
SYMPTOM DIM_SYMPTOM_TM DIM_SYMPTOM_BI DIM_SYMPTOM On Line
TASK ACCOUNTING TYPE DIM_TASK_ACCOUNTING_TYPE_TM DIM_TASK_ACCOUNTING_TYPE_BI DIM_TASK_ACCOUNTING_TYPE On Line
TIME TYPE DIM_TIME_TYPE_TM DIM_TIME_TYPE_BI DIM_TIME_TYPE On Line
TRANSACTION TYPE DIM_TRANSACTION_TYPE_TM DIM_TRANSACTION_TYPE_BI DIM_TRANSACTION_TYPE On Line
VIM SERIAL DIM_VIM_SERIAL_TM DIM_VIM_SERIAL_BI DIM_VIM_SERIAL On Line
VOUCHER DATE DIM_BI_TIME_BI DIM_BI_TIME_BI DIM_BI_TIME On Line
WO CONNECTION TYPE DIM_WO_CONNECTION_TYPE_TM DIM_WO_CONNECTION_TYPE_BI DIM_WO_CONNECTION_TYPE On Line
WO COST TYPE DIM_WO_COST_TYPE_TM DIM_WO_COST_TYPE_BI DIM_WO_COST_TYPE On Line
WORK ORDER DIM_WORK_ORDER_TM DIM_WORK_ORDER_BI DIM_WORK_ORDER On Line
WORK STAGE DIM_WORK_STAGE_TM DIM_WORK_STAGE_BI DIM_WORK_STAGE On Line
WORK TASK DIM_WORK_TASK_TM DIM_WORK_TASK_BI DIM_WORK_TASK On Line
WORK TYPE DIM_WORK_TYPE_TM DIM_WORK_TYPE_BI DIM_WORK_TYPE On Line
WORK TYPE CATEGORY DIM_WORK_TYPE_CATEGORY_TM DIM_WORK_TYPE_CATEGORY_BI DIM_WORK_TYPE_CATEGORY On Line
WT CONNECTION TYPE ACTUAL DIM_WO_CONNECTION_TYPE_TM DIM_WO_CONNECTION_TYPE_BI DIM_WO_CONNECTION_TYPE On Line
WT CONNECTION TYPE REPORTED DIM_WO_CONNECTION_TYPE_TM DIM_WO_CONNECTION_TYPE_BI DIM_WO_CONNECTION_TYPE On Line

Configurations

n/a

Limitations

n/a

Relationships

The following table lists the relationships between tables and columns in the model.

Relationship: Table (column) - Table (column)
ASSET HEALTH (Asset Health Level) - COLOR LEVEL (Description)
ASSET HEALTH (Dim_Asset_Id) - ASSET HEALTH DIMENSION (ID)
ASSET HEALTH (Dim_Asset_Type) - ASSET TYPE (ID)
ASSET HEALTH (Dim_Company_Id) - COMPANY (ID)
ASSET HEALTH (Dim_Site_Id) - SITE (ID)
ASSET HEALTH HISTORY (Dim_Asset_Id) - ASSET HEALTH DIMENSION (ID)
ASSET HEALTH HISTORY (Dim_Asset_Type) - ASSET TYPE (ID)
ASSET HEALTH INDICATOR (Dim_Asset_Type) - ASSET TYPE (ID)
ASSET HEALTH INDICATOR (ID) - ASSET HEALTH INDICATOR DIMENSION (ID)
ASSET HEALTH INDI HST (Dim_Asset_Health_Indicator) - ASSET HEALTH INDICATOR DIMENSION (ID)
ASSET HEALTH INDI HST (Dim_Asset_Id) - ASSET HEALTH DIMENSION (ID)
ASSET HEALTH INDI HST (Dim_Asset_Type) - ASSET TYPE (ID)
ASSET HEALTH LEVEL (Dim_Asset_Type) - ASSET TYPE (ID)
ASSET HEALTH LEVEL (Level) - COLOR LEVEL (Description)
CURRENCY RATES (Dim_Reporting_Currency_ID) - REPORTING CURRENCY (ID)
CURRENCY RATES (Dim_Time_ID) - REPORTING DATE (ID)
FACT TIME (ID) - ACTUAL FINISH DATE (ID)
FACT TIME (ID) - ACTUAL START DATE (ID)
FACT TIME (ID) - CREATED DATE (ID)
FACT TIME (ID) - PLANNED DATE (ID)
FACT TIME (ID) - PLANNED FINISH DATE (ID)
FACT TIME (ID) - PLANNED START DATE (ID)
FACT TIME (ID) - REPORTING DATE (ID)
FACT TIME (ID) - REQUIRED FINISH DATE (ID)
FACT TIME (ID) - REQUIRED START DATE (ID)
FACT TIME (ID) - SLA LATEST FINISH DATE (ID)
FACT TIME (ID) - SLA LATEST START DATE (ID)
FACT TIME (ID) - VOUCHER DATE (ID)
FACT WORK ORDER (Dim_Activity_ID) - ACTIVITY (ID)
FACT WORK ORDER (DIM_COMPANY_ID) - COMPANY (ID)
FACT WORK ORDER (Dim_Compatible_Unit_ID) - COMPATIBLE UNIT (ID)
FACT WORK ORDER (Dim_Customer_ID) - CUSTOMER (ID)
FACT WORK ORDER (Dim_Date_Actual_Complete_ID) - ACTUAL FINISH DATE (ID)
FACT WORK ORDER (Dim_Date_Actual_Start_ID) - ACTUAL START DATE (ID)
FACT WORK ORDER (Dim_Date_Created_ID) - CREATED DATE (ID)
FACT WORK ORDER (Dim_Date_Planned_Complete_ID) - PLANNED FINISH DATE (ID)
FACT WORK ORDER (Dim_Date_Planned_Start_ID) - PLANNED START DATE (ID)
FACT WORK ORDER (Dim_Date_Required_Complete_ID) - REQUIRED FINISH DATE (ID)
FACT WORK ORDER (Dim_Date_Required_Start_ID) - REQUIRED START DATE (ID)
FACT WORK ORDER (Dim_Discovery_ID) - DISCOVERY (ID)
FACT WORK ORDER (Dim_Equipment_Object_ID) - ACTUAL EQUIPMENT OBJECT (ID)
FACT WORK ORDER (Dim_Equipment_Object_ID) - REPORTED EQUIPMENT OBJECT (ID)
FACT WORK ORDER (Dim_Event_ID) - EVENT (ID)
FACT WORK ORDER (Dim_Linear_Asset_ID) - LINEAR ASSET (ID)
FACT WORK ORDER (Dim_Operational_Status_ID) - OPERATIONAL STATUS (ID)
FACT WORK ORDER (DIM_ORGANIZATION_ID) - ORGANIZATION (ID)
FACT WORK ORDER (Dim_Priority_ID) - PRIORITY (ID)
FACT WORK ORDER (Dim_Project_ID) - PROJECT (ID)
FACT WORK ORDER (Dim_Proj_Program_ID) - PROJECT PROGRAM (ID)
FACT WORK ORDER (Dim_Reporting_Date_ID) - REPORTING DATE (ID)
FACT WORK ORDER (Dim_Service_Contract_ID) - SERVICE CONTRACT (ID)
FACT WORK ORDER (DIM_SITE_ID) - SITE (ID)
FACT WORK ORDER (Dim_Sla_Order_No) - SLA ORDER (ID)
FACT WORK ORDER (Dim_Sub_Project_ID) - SUB PROJECT (ID)
FACT WORK ORDER (Dim_Supplier_ID) - SUPPLIER (ID)
FACT WORK ORDER (Dim_Symptom_ID) - SYMPTOM (ID)
FACT WORK ORDER (Dim_Vim_Serial_ID) - VIM SERIAL (ID)
FACT WORK ORDER (DIM_WORK_ORDER_ID) - WORK ORDER (ID)
FACT WORK ORDER (DIM_WORK_TYPE_CATEGORY_ID) - WORK TYPE CATEGORY (ID)
FACT WORK ORDER (DIM_WORK_TYPE_ID) - WORK TYPE (ID)
FACT WORK ORDER (Dim_Wo_Connection_Type_ID) - WT CONNECTION TYPE ACTUAL (ID)
FACT WORK TASK (Dim_Activity_ID) - ACTIVITY (ID)
FACT WORK TASK (Dim_Act_Equipment_Object_ID) - ACTUAL EQUIPMENT OBJECT (ID)
FACT WORK TASK (Dim_Cancel_Task_Cause_ID) - CANCEL TASK CAUSE (ID)
FACT WORK TASK (Dim_Cause_ID) - CAUSE (ID)
FACT WORK TASK (Dim_Class_ID) - CLASS (ID)
FACT WORK TASK (Dim_Company_ID) - COMPANY (ID)
FACT WORK TASK (Dim_Customer_ID) - CUSTOMER (ID)
FACT WORK TASK (Dim_Date_Planned_Compl_ID) - PLANNED FINISH DATE (ID)
FACT WORK TASK (Dim_Date_Planned_Start_ID) - PLANNED START DATE (ID)
FACT WORK TASK (Dim_Date_Reported_ID) - REPORTING DATE (ID)
FACT WORK TASK (Dim_Discovery_ID) - DISCOVERY (ID)
FACT WORK TASK (Dim_Event_ID) - EVENT (ID)
FACT WORK TASK (Dim_Failing_Component_ID) - FAILING COMPONENT (ID)
FACT WORK TASK (Dim_Fault_Type_ID) - FAULT TYPE (ID)
FACT WORK TASK (Dim_Item_Class_Function_ID) - ITEM CLASS FUNCTION (ID)
FACT WORK TASK (Dim_Item_Class_ID) - ITEM CLASS (ID)
FACT WORK TASK (Dim_Item_Class_Source_ID) - ITEM CLASS SOURCE (ID)
FACT WORK TASK (Dim_Operational_Status_ID) - OPERATIONAL STATUS (ID)
FACT WORK TASK (Dim_Organization_ID) - ORGANIZATION (ID)
FACT WORK TASK (Dim_Performed_Actions_ID) - PERFORMED ACTION (ID)
FACT WORK TASK (Dim_PM_Group_ID) - PM GROUP (ID)
FACT WORK TASK (Dim_Priority_ID) - PRIORITY (ID)
FACT WORK TASK (Dim_Proj_Program_ID) - PROJECT PROGRAM (ID)
FACT WORK TASK (Dim_Reported_Object_Site_ID) - REPORTED OBJECT SITE (ID)
FACT WORK TASK (Dim_Service_Contract_ID) - SERVICE CONTRACT (ID)
FACT WORK TASK (Dim_Site_ID) - SITE (ID)
FACT WORK TASK (Dim_Site_ID) - SOURCE SITE (ID)
FACT WORK TASK (Dim_SLA_ORDER_Line_ID) - SLA ORDER LINE (ID)
FACT WORK TASK (Dim_Source_Connection_ID) - SOURCE CONNECTION (ID)
FACT WORK TASK (Dim_Supplier_ID) - SUPPLIER (ID)
FACT WORK TASK (Dim_Symptom_ID) - SYMPTOM (ID)
FACT WORK TASK (Dim_Work_Order_ID) - WORK ORDER (ID)
FACT WORK TASK (Dim_Work_Stage_ID) - WORK STAGE (ID)
FACT WORK TASK (Dim_Work_Type_Category_ID) - WORK TYPE CATEGORY (ID)
FACT WORK TASK (Dim_Work_Type_ID) - WORK TYPE (ID)
FACT WORK TASK (Dim_Wo_Connection_Type_ID) - WO CONNECTION TYPE (ID)
WORK TASK ACTUALS COST (Dim_Activity_ID) - ACTIVITY (ID)
WORK TASK ACTUALS COST (Dim_Act_Equipment_Object_ID) - ACTUAL EQUIPMENT OBJECT (ID)
WORK TASK ACTUALS COST (Dim_Cancel_Task_Cause_ID) - CANCEL TASK CAUSE (ID)
WORK TASK ACTUALS COST (Dim_Cause_ID) - CAUSE (ID)
WORK TASK ACTUALS COST (Dim_Class_ID) - CLASS (ID)
WORK TASK ACTUALS COST (Dim_Company_ID) - COMPANY (ID)
WORK TASK ACTUALS COST (Dim_Customer_ID) - CUSTOMER (ID)
WORK TASK ACTUALS COST (Dim_Date_Actual_Compl_ID) - ACTUAL FINISH DATE (ID)
WORK TASK ACTUALS COST (Dim_Date_Actual_Start_ID) - ACTUAL START DATE (ID)
WORK TASK ACTUALS COST (Dim_Date_Planned_Compl_ID) - PLANNED FINISH DATE (ID)
WORK TASK ACTUALS COST (Dim_Date_Planned_Start_ID) - PLANNED START DATE (ID)
WORK TASK ACTUALS COST (Dim_Date_Reported_ID) - REPORTING DATE (ID)
WORK TASK ACTUALS COST (Dim_Discovery_ID) - DISCOVERY (ID)
WORK TASK ACTUALS COST (Dim_Event_ID) - EVENT (ID)
WORK TASK ACTUALS COST (Dim_Failing_Component_ID) - FAILING COMPONENT (ID)
WORK TASK ACTUALS COST (Dim_Fault_Type_ID) - FAULT TYPE (ID)
WORK TASK ACTUALS COST (Dim_Item_Class_Function_ID) - ITEM CLASS FUNCTION (ID)
WORK TASK ACTUALS COST (Dim_Item_Class_ID) - ITEM CLASS (ID)
WORK TASK ACTUALS COST (Dim_Item_Class_Source_ID) - ITEM CLASS SOURCE (ID)
WORK TASK ACTUALS COST (Dim_Operational_Status_ID) - OPERATIONAL STATUS (ID)
WORK TASK ACTUALS COST (Dim_Organization_ID) - ORGANIZATION (ID)
WORK TASK ACTUALS COST (Dim_Performed_Actions_ID) - PERFORMED ACTION (ID)
WORK TASK ACTUALS COST (Dim_PM_Group_ID) - PM GROUP (ID)
WORK TASK ACTUALS COST (Dim_Priority_ID) - PRIORITY (ID)
WORK TASK ACTUALS COST (Dim_Project_ID) - PROJECT (ID)
WORK TASK ACTUALS COST (Dim_Proj_Program_ID) - PROJECT PROGRAM (ID)
WORK TASK ACTUALS COST (Dim_Reported_Object_Site_ID) - REPORTED OBJECT SITE (ID)
WORK TASK ACTUALS COST (Dim_Service_Contract_Line_ID) - SERVICE CONTRACT (ID)
WORK TASK ACTUALS COST (Dim_Site_ID) - ACTUAL OBJECT SITE (ID)
WORK TASK ACTUALS COST (Dim_Site_ID) - SITE (ID)
WORK TASK ACTUALS COST (Dim_Source_Connection_ID) - SOURCE CONNECTION (ID)
WORK TASK ACTUALS COST (Dim_Source_Object_ID) - SOURCE OBJECT (ID)
WORK TASK ACTUALS COST (Dim_Sub_Project_ID) - SUB PROJECT (ID)
WORK TASK ACTUALS COST (Dim_Supplier_ID) - SUPPLIER (ID)
WORK TASK ACTUALS COST (Dim_Symptom_ID) - SYMPTOM (ID)
WORK TASK ACTUALS COST (Dim_Work_Order_ID) - WORK ORDER (ID)
WORK TASK ACTUALS COST (Dim_Work_Stage_ID) - WORK STAGE (ID)
WORK TASK ACTUALS COST (Dim_Work_Task_ID) - WORK TASK (ID)
WORK TASK ACTUALS COST (Dim_Work_Type_Category_ID) - WORK TYPE CATEGORY (ID)
WORK TASK ACTUALS COST (Dim_Work_Type_ID) - WORK TYPE (ID)
WORK TASK ACTUALS COST (Dim_Wo_Connection_Type_ID) - WT CONNECTION TYPE ACTUAL (ID)
WORK TASK ACTUALS SALES (Dim_Activity_ID) - ACTIVITY (ID)
WORK TASK ACTUALS SALES (Dim_Act_Equipment_Object_ID) - ACTUAL EQUIPMENT OBJECT (ID)
WORK TASK ACTUALS SALES (Dim_Act_Equipment_Object_ID) - REPORTED EQUIPMENT OBJECT (ID)
WORK TASK ACTUALS SALES (Dim_Cancel_Task_Cause_ID) - CANCEL TASK CAUSE (ID)
WORK TASK ACTUALS SALES (Dim_Cause_ID) - CAUSE (ID)
WORK TASK ACTUALS SALES (Dim_Class_ID) - CLASS (ID)
WORK TASK ACTUALS SALES (Dim_Company_ID) - COMPANY (ID)
WORK TASK ACTUALS SALES (Dim_Customer_ID) - CUSTOMER (ID)
WORK TASK ACTUALS SALES (Dim_Date_Planned_Compl_ID) - PLANNED FINISH DATE (ID)
WORK TASK ACTUALS SALES (Dim_Date_Planned_Start_ID) - PLANNED START DATE (ID)
WORK TASK ACTUALS SALES (Dim_Date_Reported_ID) - REPORTING DATE (ID)
WORK TASK ACTUALS SALES (Dim_Date_Reported_ID) - SLA LATEST FINISH DATE (ID)
WORK TASK ACTUALS SALES (Dim_Date_Reported_ID) - SLA LATEST START DATE (ID)
WORK TASK ACTUALS SALES (Dim_Discovery_ID) - DISCOVERY (ID)
WORK TASK ACTUALS SALES (Dim_Event_ID) - EVENT (ID)
WORK TASK ACTUALS SALES (Dim_Failing_Component_ID) - FAILING COMPONENT (ID)
WORK TASK ACTUALS SALES (Dim_Fault_Type_ID) - FAULT TYPE (ID)
WORK TASK ACTUALS SALES (Dim_Item_Class_Function_ID) - ITEM CLASS FUNCTION (ID)
WORK TASK ACTUALS SALES (Dim_Item_Class_ID) - ITEM CLASS (ID)
WORK TASK ACTUALS SALES (Dim_Item_Class_Source_ID) - ITEM CLASS SOURCE (ID)
WORK TASK ACTUALS SALES (Dim_Operational_Status_ID) - OPERATIONAL STATUS (ID)
WORK TASK ACTUALS SALES (Dim_Organization_ID) - ORGANIZATION (ID)
WORK TASK ACTUALS SALES (Dim_Performed_Actions_ID) - PERFORMED ACTION (ID)
WORK TASK ACTUALS SALES (Dim_PM_Group_ID) - PM GROUP (ID)
WORK TASK ACTUALS SALES (Dim_Priority_ID) - PRIORITY (ID)
WORK TASK ACTUALS SALES (Dim_Proj_Program_ID) - PROJECT PROGRAM (ID)
WORK TASK ACTUALS SALES (Dim_Reported_Object_Site_ID) - REPORTED OBJECT SITE (ID)
WORK TASK ACTUALS SALES (Dim_Service_Contract_ID) - SERVICE CONTRACT (ID)
WORK TASK ACTUALS SALES (Dim_Site_ID) - ACTUAL OBJECT SITE (ID)
WORK TASK ACTUALS SALES (Dim_Site_ID) - SITE (ID)
WORK TASK ACTUALS SALES (Dim_Site_ID) - SOURCE SITE (ID)
WORK TASK ACTUALS SALES (Dim_Source_Connection_ID) - SOURCE CONNECTION (ID)
WORK TASK ACTUALS SALES (Dim_Source_Object_ID) - SOURCE OBJECT (ID)
WORK TASK ACTUALS SALES (Dim_Supplier_ID) - SUPPLIER (ID)
WORK TASK ACTUALS SALES (Dim_Symptom_ID) - SYMPTOM (ID)
WORK TASK ACTUALS SALES (Dim_Work_Order_ID) - WORK ORDER (ID)
WORK TASK ACTUALS SALES (Dim_Work_Stage_ID) - WORK STAGE (ID)
WORK TASK ACTUALS SALES (Dim_Work_Task_ID) - WORK TASK (ID)
WORK TASK ACTUALS SALES (Dim_Work_Type_Category_ID) - WORK TYPE CATEGORY (ID)
WORK TASK ACTUALS SALES (Dim_Work_Type_ID) - WORK TYPE (ID)
WORK TASK ACTUALS SALES (Dim_Wo_Connection_Type_ID) - WO CONNECTION TYPE (ID)
WORK TASK ACTUALS SALES (Dim_Wo_Connection_Type_ID) - WT CONNECTION TYPE ACTUAL (ID)
WORK TASK PLANNED (Dim_Activity_ID) - ACTIVITY (ID)
WORK TASK PLANNED (Dim_Cause_ID) - CAUSE (ID)
WORK TASK PLANNED (Dim_Class_ID) - CLASS (ID)
WORK TASK PLANNED (Dim_Company_ID) - COMPANY (ID)
WORK TASK PLANNED (Dim_Cost_Type_ID) - WO COST TYPE (ID)
WORK TASK PLANNED (Dim_Criticality_ID) - CRITICALITY (ID)
WORK TASK PLANNED (Dim_Customer_ID) - CUSTOMER (ID)
WORK TASK PLANNED (Dim_Date_Planned_Compl_ID) - PLANNED FINISH DATE (ID)
WORK TASK PLANNED (Dim_Date_Planned_Start_ID) - PLANNED START DATE (ID)
WORK TASK PLANNED (Dim_Discovery_ID) - DISCOVERY (ID)
WORK TASK PLANNED (Dim_Event_ID) - EVENT (ID)
WORK TASK PLANNED (Dim_Fault_Type_ID) - FAULT TYPE (ID)
WORK TASK PLANNED (Dim_Linear_Asset_ID) - LINEAR ASSET (ID)
WORK TASK PLANNED (Dim_Operational_Status_ID) - OPERATIONAL STATUS (ID)
WORK TASK PLANNED (Dim_Organization_ID) - ORGANIZATION (ID)
WORK TASK PLANNED (Dim_Performed_Actions_ID) - PERFORMED ACTION (ID)
WORK TASK PLANNED (Dim_Priority_ID) - PRIORITY (ID)
WORK TASK PLANNED (Dim_Proj_Program_Id) - PROJECT PROGRAM (ID)
WORK TASK PLANNED (Dim_Reporting_Date_ID) - REPORTING DATE (ID)
WORK TASK PLANNED (Dim_Site_ID) - SITE (ID)
WORK TASK PLANNED (Dim_Source_Connection_ID) - SOURCE CONNECTION (ID)
WORK TASK PLANNED (Dim_Sub_Project_ID) - SUB PROJECT (ID)
WORK TASK PLANNED (Dim_Supplier_ID) - SUPPLIER (ID)
WORK TASK PLANNED (Dim_Symptom_ID) - SYMPTOM (ID)
WORK TASK PLANNED (Dim_Vim_Serial_ID) - VIM SERIAL (ID)
WORK TASK PLANNED (Dim_Work_Order_ID) - WORK ORDER (ID)
WORK TASK PLANNED (Dim_Work_Task_ID) - WORK TASK (ID)
WORK TASK PLANNED (Dim_Work_Type_Category_ID) - WORK TYPE CATEGORY (ID)
WORK TASK PLANNED (Dim_Work_Type_ID) - WORK TYPE (ID)
WORK TASK POSTINGS (Dim_Account_ID) - ACCOUNT (ID)
WORK TASK POSTINGS (Dim_Activity_ID) - ACTIVITY (ID)
WORK TASK POSTINGS (Dim_Actual_Obj_Site_ID) - ACTUAL OBJECT SITE (ID)
WORK TASK POSTINGS (Dim_Cancel_Task_Cause_ID) - CANCEL TASK CAUSE (ID)
WORK TASK POSTINGS (Dim_Cause_ID) - CAUSE (ID)
WORK TASK POSTINGS (Dim_Class_ID) - CLASS (ID)
WORK TASK POSTINGS (Dim_Code_B_ID) - CODE B (ID)
WORK TASK POSTINGS (Dim_Code_C_ID) - CODE C (ID)
WORK TASK POSTINGS (Dim_Code_D_ID) - CODE D (ID)
WORK TASK POSTINGS (Dim_Code_E_ID) - CODE E (ID)
WORK TASK POSTINGS (Dim_Code_F_ID) - CODE F (ID)
WORK TASK POSTINGS (Dim_Code_G_ID) - CODE G (ID)
WORK TASK POSTINGS (Dim_Code_H_ID) - CODE H (ID)
WORK TASK POSTINGS (Dim_Code_I_ID) - CODE I (ID)
WORK TASK POSTINGS (Dim_Code_J_ID) - CODE J (ID)
WORK TASK POSTINGS (Dim_Company_ID) - COMPANY (ID)
WORK TASK POSTINGS (Dim_Customer_ID) - CUSTOMER (ID)
WORK TASK POSTINGS (Dim_Date_Actual_Compl_ID) - ACTUAL FINISH DATE (ID)
WORK TASK POSTINGS (Dim_Date_Actual_Start_ID) - ACTUAL START DATE (ID)
WORK TASK POSTINGS (Dim_Date_Earliest_Start_ID) - REQUIRED START DATE (ID)
WORK TASK POSTINGS (Dim_Date_Latest_Finish_ID) - REQUIRED FINISH DATE (ID)
WORK TASK POSTINGS (Dim_Date_Planned_Compl_ID) - PLANNED FINISH DATE (ID)
WORK TASK POSTINGS (Dim_Date_Planned_Start_ID) - PLANNED START DATE (ID)
WORK TASK POSTINGS (Dim_Date_SLA_Latest_Finish_ID) - SLA LATEST FINISH DATE (ID)
WORK TASK POSTINGS (Dim_Date_SLA_Latest_Start_Id) - SLA LATEST START DATE (ID)
WORK TASK POSTINGS (Dim_Discovery_ID) - DISCOVERY (ID)
WORK TASK POSTINGS (Dim_Equipment_Object_ID) - ACTUAL EQUIPMENT OBJECT (ID)
WORK TASK POSTINGS (Dim_Event_ID) - EVENT (ID)
WORK TASK POSTINGS (Dim_Failing_Component_ID) - FAILING COMPONENT (ID)
WORK TASK POSTINGS (Dim_Fault_Type_ID) - FAULT TYPE (ID)
WORK TASK POSTINGS (Dim_Item_Class_Function_ID) - ITEM CLASS FUNCTION (ID)
WORK TASK POSTINGS (Dim_Item_Class_ID) - ITEM CLASS (ID)
WORK TASK POSTINGS (Dim_Item_Class_Source_ID) - ITEM CLASS SOURCE (ID)
WORK TASK POSTINGS (Dim_Item_Class_Source_ID) - SOURCE CONNECTION (ID)
WORK TASK POSTINGS (Dim_Operational_Status_ID) - OPERATIONAL STATUS (ID)
WORK TASK POSTINGS (Dim_Organisation_Site_ID) - ORGANIZATION SITE (ID)
WORK TASK POSTINGS (Dim_Organization_ID) - ORGANIZATION (ID)
WORK TASK POSTINGS (Dim_Performed_Actions_ID) - PERFORMED ACTION (ID)
WORK TASK POSTINGS (Dim_PM_Group_ID) - PM GROUP (ID)
WORK TASK POSTINGS (Dim_Posting_Type_ID) - TASK ACCOUNTING TYPE (ID)
WORK TASK POSTINGS (Dim_Priority_ID) - PRIORITY (ID)
WORK TASK POSTINGS (Dim_Project_ID) - PROJECT (ID)
WORK TASK POSTINGS (Dim_Proj_Program_ID) - PROJECT PROGRAM (ID)
WORK TASK POSTINGS (Dim_Reported_Object_Site_ID) - REPORTED OBJECT SITE (ID)
WORK TASK POSTINGS (Dim_Reporting_Date_Id) - REPORTING DATE (ID)
WORK TASK POSTINGS (Dim_Rep_Mch_Ref_ID) - REPORTED EQUIPMENT OBJECT (ID)
WORK TASK POSTINGS (Dim_Rpd_Company_Period_ID) - REPORTING PERIOD (Company-Date)
WORK TASK POSTINGS (Dim_Service_Contract_Line_ID) - SERVICE CONTRACT (ID)
WORK TASK POSTINGS (Dim_Site_ID) - SITE (ID)
WORK TASK POSTINGS (Dim_Source_Object_ID) - SOURCE OBJECT (ID)
WORK TASK POSTINGS (Dim_Source_Site_ID) - SOURCE SITE (ID)
WORK TASK POSTINGS (Dim_Sub_Project_ID) - SUB PROJECT (ID)
WORK TASK POSTINGS (Dim_Supplier_ID) - SUPPLIER (ID)
WORK TASK POSTINGS (Dim_Symptom_ID) - SYMPTOM (ID)
WORK TASK POSTINGS (Dim_Time_Type_ID) - TIME TYPE (ID)
WORK TASK POSTINGS (Dim_Transaction_Type_ID) - TRANSACTION TYPE (ID)
WORK TASK POSTINGS (Dim_Work_Order_No_Id) - WORK ORDER (ID)
WORK TASK POSTINGS (Dim_Work_Stage_ID) - WORK STAGE (ID)
WORK TASK POSTINGS (Dim_Work_Task_Seq_ID) - WORK TASK (ID)
WORK TASK POSTINGS (Dim_Work_Type_Cat_ID) - WORK TYPE CATEGORY (ID)
WORK TASK POSTINGS (Dim_Work_Type_ID) - WORK TYPE (ID)
WORK TASK POSTINGS (Dim_Wo_Connection_Type_ID) - WO CONNECTION TYPE (ID)
WORK TASK POSTINGS (Dim_WO_Cost_Type_ID) - WO COST TYPE (ID)
WO BUDGET (Dim_Activity_ID) - ACTIVITY (ID)
WO BUDGET (Dim_Company_ID) - COMPANY (ID)
WO BUDGET (Dim_Compatible_Unit_ID) - COMPATIBLE UNIT (ID)
WO BUDGET (Dim_Cost_Type_ID) - WO COST TYPE (ID)
WO BUDGET (Dim_Customer_ID) - CUSTOMER (ID)
WO BUDGET (Dim_Date_Earliest_Start_ID) - REQUIRED START DATE (ID)
WO BUDGET (Dim_Date_Required_Compl_ID) - REQUIRED FINISH DATE (ID)
WO BUDGET (Dim_Discovery_ID) - DISCOVERY (ID)
WO BUDGET (Dim_Equipment_Object_ID) - ACTUAL EQUIPMENT OBJECT (ID)
WO BUDGET (Dim_Linear_Asset_ID) - LINEAR ASSET (ID)
WO BUDGET (Dim_Operational_Status_ID) - OPERATIONAL STATUS (ID)
WO BUDGET (Dim_Organization_ID) - ORGANIZATION (ID)
WO BUDGET (Dim_Priority_ID) - PRIORITY (ID)
WO BUDGET (Dim_Project_ID) - PROJECT (ID)
WO BUDGET (Dim_Proj_Program_ID) - PROJECT PROGRAM (ID)
WO BUDGET (Dim_Reporting_Date_ID) - REPORTING DATE (ID)
WO BUDGET (Dim_Site_ID) - SITE (ID)
WO BUDGET (Dim_Sub_Project_ID) - SUB PROJECT (ID)
WO BUDGET (Dim_Supplier_ID) - SUPPLIER (ID)
WO BUDGET (Dim_Symptom_ID) - SYMPTOM (ID)
WO BUDGET (Dim_Vim_Serial_ID) - VIM SERIAL (ID)
WO BUDGET (Dim_Work_Order_ID) - WORK ORDER (ID)
WO BUDGET (Dim_Work_Type_Category_ID) - WORK TYPE CATEGORY (ID)
WO BUDGET (Dim_Work_Type_ID) - WORK TYPE (ID)
WO BUDGET (Dim_Wo_Connection_Type_ID) - WO CONNECTION TYPE (ID)