Tabular Model - Maintenance

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 MEASURESFACT_ASSET_HEALTH_TMFACT_ASSET_HEALTH_BIFACT_ASSET_HEALTHOn Line
CURRENCY RATESFACT_CURRENCY_RATES_TMFACT_CURRENCY_RATES_BIFACT_CURRENCY_RATESOn Line
FACT TIMEDIM_BI_TIME_BIDIM_BI_TIME_BIDIM_BI_TIMEOn Line
FACT WORK ORDERFACT_WORK_ORDER_TMFACT_WORK_ORDER_BIFACT_WORK_ORDERData Mart
FACT WORK TASKFACT_WORK_TASK_TMFACT_WORK_TASK_BIFACT_WORK_TASKData Mart
WO BUDGETFACT_WO_BUDGET_TMFACT_WO_BUDGET_BIFACT_WO_BUDGETData Mart
WORK TASK ACTUALS COSTFACT_WORK_TASK_ACTUALS_COST_TMFACT_WORK_TASK_ACTUALS_COST_BIFACT_WORK_TASK_ACTUALS_COSTData Mart
WORK TASK ACTUALS SALESFACT_WO_TASK_ACTUALS_SALES_TMFACT_WO_TASK_ACTUALS_SALES_BIFACT_WO_TASK_ACTUALS_SALESData Mart
WORK TASK PLANNEDFACT_WORK_TASK_PLANNED_TMFACT_WORK_TASK_PLANNED_BIFACT_WORK_TASK_PLANNEDData Mart
WORK TASK POSTINGSFACT_JT_TASK_ACCOUNTING_TMFACT_JT_TASK_ACCOUNTING_BIFACT_JT_TASK_ACCOUNTINGData 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
ACCOUNTDIM_ACCOUNT_TMDIM_ACCOUNT_BIDIM_ACCOUNTOn Line
ACTIVITYDIM_ACTIVITY_TMDIM_ACTIVITY_BIDIM_ACTIVITYOn Line
ACTUAL EQUIPMENT OBJECTDIM_EQUIPMENT_OBJECT_TMDIM_EQUIPMENT_OBJECT_BIDIM_EQUIPMENT_OBJECTOn Line
ACTUAL FINISH DATEDIM_BI_TIME_BIDIM_BI_TIME_BIDIM_BI_TIMEOn Line
ACTUAL OBJECT SITEDIM_SITE_TMDIM_SITE_BIDIM_SITEOn Line
ACTUAL START DATEDIM_BI_TIME_BIDIM_BI_TIME_BIDIM_BI_TIMEOn Line
ASSET HEALTHFACT_ASSET_HEALTH_TMFACT_ASSET_HEALTH_BIFACT_ASSET_HEALTHOn Line
ASSET HEALTH DIMENSIONDIM_ASSET_HEALTH_TMDIM_ASSET_HEALTH_BIDIM_ASSET_HEALTHOn Line
ASSET HEALTH HISTORYFACT_ASSET_HEALTH_HISTORY_TMFACT_ASSET_HEALTH_HISTORY_BIFACT_ASSET_HEALTH_HISTORYOn Line
ASSET HEALTH INDI HSTFACT_ASSET_HEALTH_INDI_HST_TMFACT_ASSET_HEALTH_INDI_HST_BIFACT_ASSET_HEALTH_INDI_HSTOn Line
ASSET HEALTH INDICATORFACT_ASSET_HEALTH_INDICATOR_TMFACT_ASSET_HEALTH_INDICATOR_BIFACT_ASSET_HEALTH_INDICATOROn Line
ASSET HEALTH INDICATOR DIMENSIONDIM_ASSET_HEALTH_INDICATOR_TMDIM_ASSET_HEALTH_INDICATOR_BIDIM_ASSET_HEALTH_INDICATOROn Line
ASSET HEALTH LEVELFACT_ASSET_HEALTH_LEVEL_TMFACT_ASSET_HEALTH_LEVEL_BIFACT_ASSET_HEALTH_LEVELOn Line
ASSET TYPEDIM_ASSET_TYPE_TMDIM_ASSET_TYPE_BIDIM_ASSET_TYPEOn Line
CANCEL TASK CAUSEDIM_CANCEL_TASK_CAUSE_TMDIM_CANCEL_TASK_CAUSE_BIDIM_CANCEL_TASK_CAUSEOn Line
CAUSEDIM_CAUSE_TMDIM_CAUSE_BIDIM_CAUSEOn Line
CLASSDIM_CLASS_TMDIM_CLASS_BIDIM_CLASSOn Line
CODE BDIM_CODE_B_TMDIM_CODE_B_BIDIM_CODE_BOn Line
CODE CDIM_CODE_C_TMDIM_CODE_C_BIDIM_CODE_COn Line
CODE DDIM_CODE_D_TMDIM_CODE_D_BIDIM_CODE_DOn Line
CODE EDIM_CODE_E_TMDIM_CODE_E_BIDIM_CODE_EOn Line
CODE FDIM_CODE_F_TMDIM_CODE_F_BIDIM_CODE_FOn Line
CODE GDIM_CODE_G_TMDIM_CODE_G_BIDIM_CODE_GOn Line
CODE HDIM_CODE_H_TMDIM_CODE_H_BIDIM_CODE_HOn Line
CODE IDIM_CODE_I_TMDIM_CODE_I_BIDIM_CODE_IOn Line
CODE JDIM_CODE_J_TMDIM_CODE_J_BIDIM_CODE_JOn Line
COLOR LEVELEAM_COLOR_LEVELN/AEAM_COLOR_LEVELOn Line
COMPANYDIM_COMPANY_TMDIM_COMPANY_BIDIM_COMPANYOn Line
COMPATIBLE UNITDIM_CMPUNT_COMPATIBLE_UNIT_TMDIM_CMPUNT_COMPATIBLE_UNIT_BIDIM_CMPUNT_COMPATIBLE_UNITOn Line
CREATED DATEDIM_BI_TIME_BIDIM_BI_TIME_BIDIM_BI_TIMEOn Line
CRITICALITYDIM_CRITICALITY_TMDIM_CRITICALITY_BIDIM_CRITICALITYOn Line
CUSTOMERDIM_CUSTOMER_TMDIM_CUSTOMER_BIDIM_CUSTOMEROn Line
DISCOVERYDIM_DISCOVERY_TMDIM_DISCOVERY_BIDIM_DISCOVERYOn Line
EQUIPMENT OBJECTDIM_EQUIPMENT_OBJECT_TMDIM_EQUIPMENT_OBJECT_BIDIM_EQUIPMENT_OBJECTOn Line
EVENTDIM_EVENT_TMDIM_EVENT_BIDIM_EVENTOn Line
EnvPathEAM_ENVIRONMENT_PATHN/AEAM_ENVIRONMENT_PATHOn Line
FAILING COMPONENTDIM_FAILING_COMPONENT_TMDIM_FAILING_COMPONENT_BIDIM_FAILING_COMPONENTOn Line
FAULT TYPEDIM_FAULT_TYPE_TMDIM_FAULT_TYPE_BIDIM_FAULT_TYPEOn Line
HEALTH LEVELEAM_HEALTH_LEVELN/AEAM_HEALTH_LEVELOn Line
ITEM CLASSDIM_ITEM_CLASS_TMDIM_ITEM_CLASS_BIDIM_ITEM_CLASSOn Line
ITEM CLASS FUNCTIONDIM_ITEM_CLASS_FUNCTION_TMDIM_ITEM_CLASS_FUNCTION_BIDIM_ITEM_CLASS_FUNCTIONOn Line
ITEM CLASS SOURCEDIM_IC_SOURCE_TYPE_TMDIM_IC_SOURCE_TYPE_BIDIM_IC_SOURCE_TYPEOn Line
LINEAR ASSETDIM_LINAST_LINEAR_ASSET_TMDIM_LINAST_LINEAR_ASSET_BIDIM_LINAST_LINEAR_ASSETOn Line
OPERATIONAL STATUSDIM_OPERATIONAL_STATUS_TMDIM_OPERATIONAL_STATUS_BIDIM_OPERATIONAL_STATUSOn Line
ORGANIZATIONDIM_ORGANIZATION_TMDIM_ORGANIZATION_BIDIM_ORGANIZATIONOn Line
ORGANIZATION SITEDIM_SITE_TMDIM_SITE_BIDIM_SITEOn Line
PERFORMED ACTIONDIM_PERFORMED_ACTION_TMDIM_PERFORMED_ACTION_BIDIM_PERFORMED_ACTIONOn Line
PLANNED DATEDIM_BI_TIME_BIDIM_BI_TIME_BIDIM_BI_TIMEOn Line
PLANNED FINISH DATEDIM_BI_TIME_BIDIM_BI_TIME_BIDIM_BI_TIMEOn Line
PLANNED START DATEDIM_BI_TIME_BIDIM_BI_TIME_BIDIM_BI_TIMEOn Line
PM GROUPDIM_PM_GROUP_TMDIM_PM_GROUP_BIDIM_PM_GROUPOn Line
PRIORITYDIM_PRIORITY_TMDIM_PRIORITY_BIDIM_PRIORITYOn Line
PROJECTDIM_PROJECT_TMDIM_PROJECT_BIDIM_PROJECTOn Line
PROJECT PROGRAMDIM_PROJECT_PROGRAM_TMDIM_PROJECT_PROGRAM_BIDIM_PROJECT_PROGRAMOn Line
REPORTED EQUIPMENT OBJECTDIM_EQUIPMENT_OBJECT_TMDIM_EQUIPMENT_OBJECT_BIDIM_EQUIPMENT_OBJECTOn Line
REPORTED OBJECT SITEDIM_SITE_TMDIM_SITE_BIDIM_SITEOn Line
REPORTING CURRENCYDIM_REPORTING_CURRENCY_TMFACT_CURRENCY_RATES_BI,LUP_REP_CURR_RATE_TYPE_TC,DIM_CURRENCY_CODE_BI,DIM_CURRENCY_RATE_TYPE_BIDIM_REPORTING_CURRENCYOn Line
REPORTING DATEDIM_BI_TIME_BIDIM_BI_TIME_BIDIM_BI_TIMEOn Line
REPORTING PERIODDIM_REPORTING_PERIOD_MAINTENANCE_TMDIM_RDP_COMPANY_PERIOD_BIDIM_REPORTING_PERIOD_MAINTENANCEOn Line
REQUIRED FINISH DATEDIM_BI_TIME_BIDIM_BI_TIME_BIDIM_BI_TIMEOn Line
REQUIRED START DATEDIM_BI_TIME_BIDIM_BI_TIME_BIDIM_BI_TIMEOn Line
SALES PARTDIM_SALES_PART_TMDIM_SALES_PART_BIDIM_SALES_PARTOn Line
SERVICE CONTRACTDIM_SERVICE_CONTRACT_LINE_TMDIM_SERVICE_CONTRACT_LINE_BIDIM_SERVICE_CONTRACT_LINEOn Line
SITEDIM_SITE_TMDIM_SITE_BIDIM_SITEOn Line
SLA LATEST FINISH DATEDIM_BI_TIME_BIDIM_BI_TIME_BIDIM_BI_TIMEOn Line
SLA LATEST START DATEDIM_BI_TIME_BIDIM_BI_TIME_BIDIM_BI_TIMEOn Line
SLA ORDERDIM_SLA_ORDER_TMDIM_SLA_ORDER_BIDIM_SLA_ORDEROn Line
SLA ORDER LINEDIM_SLA_ORDER_LINE_TMDIM_SLA_ORDER_LINE_BIDIM_SLA_ORDER_LINEOn Line
SOURCE CONNECTIONDIM_JT_CONNECTED_OBJECT_TMDIM_JT_CONNECTED_OBJECT_BIDIM_JT_CONNECTED_OBJECTOn Line
SOURCE OBJECTDIM_SOURCE_OBJECT_TMDIM_SOURCE_OBJECT_BIDIM_SOURCE_OBJECTOn Line
SOURCE SITEDIM_SITE_TMDIM_SITE_BIDIM_SITEOn Line
SUB PROJECTDIM_SUB_PROJECT_TMDIM_SUB_PROJECT_BIDIM_SUB_PROJECTOn Line
SUPPLIERDIM_SUPPLIER_TMDIM_SUPPLIER_BIDIM_SUPPLIEROn Line
SYMPTOMDIM_SYMPTOM_TMDIM_SYMPTOM_BIDIM_SYMPTOMOn Line
TASK ACCOUNTING TYPEDIM_TASK_ACCOUNTING_TYPE_TMDIM_TASK_ACCOUNTING_TYPE_BIDIM_TASK_ACCOUNTING_TYPEOn Line
TIME TYPEDIM_TIME_TYPE_TMDIM_TIME_TYPE_BIDIM_TIME_TYPEOn Line
TRANSACTION TYPEDIM_TRANSACTION_TYPE_TMDIM_TRANSACTION_TYPE_BIDIM_TRANSACTION_TYPEOn Line
VIM SERIALDIM_VIM_SERIAL_TMDIM_VIM_SERIAL_BIDIM_VIM_SERIALOn Line
VOUCHER DATEDIM_BI_TIME_BIDIM_BI_TIME_BIDIM_BI_TIMEOn Line
WO CONNECTION TYPEDIM_WO_CONNECTION_TYPE_TMDIM_WO_CONNECTION_TYPE_BIDIM_WO_CONNECTION_TYPEOn Line
WO COST TYPEDIM_WO_COST_TYPE_TMDIM_WO_COST_TYPE_BIDIM_WO_COST_TYPEOn Line
WORK ORDERDIM_WORK_ORDER_TMDIM_WORK_ORDER_BIDIM_WORK_ORDEROn Line
WORK STAGEDIM_WORK_STAGE_TMDIM_WORK_STAGE_BIDIM_WORK_STAGEOn Line
WORK TASKDIM_WORK_TASK_TMDIM_WORK_TASK_BIDIM_WORK_TASKOn Line
WORK TYPEDIM_WORK_TYPE_TMDIM_WORK_TYPE_BIDIM_WORK_TYPEOn Line
WORK TYPE CATEGORYDIM_WORK_TYPE_CATEGORY_TMDIM_WORK_TYPE_CATEGORY_BIDIM_WORK_TYPE_CATEGORYOn Line
WT CONNECTION TYPE ACTUALDIM_WO_CONNECTION_TYPE_TMDIM_WO_CONNECTION_TYPE_BIDIM_WO_CONNECTION_TYPEOn Line
WT CONNECTION TYPE REPORTEDDIM_WO_CONNECTION_TYPE_TMDIM_WO_CONNECTION_TYPE_BIDIM_WO_CONNECTION_TYPEOn Line

Configurations

Limitations

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)