Project.Time

Purpose

The Project Time (& Expenses) fact tables are designed to display quantitative data related to the time and (expenses) associated with projects. This table integrates with dimension tables, such as project_details and employee_details to provide detailed insights into the utilisation of resources and the costs incurred. The primary purpose is to support project management and operational efficiency across the organisation.

Code & Source related to Project.Expenses

Use Case

Owner: Martyn Cole
Typical Use Case: For the Calculation of in project booked Time (Actuals) within Project Reporting Portal
Style: Fact, meaning it consists of the measurements, metrics or facts of a business process

Source

FACT_PROJECT_TRANS_OL

WHERE Report_Group = TIME

Key Parameters

Company
Project
Customer
Person/Resource

Sample Exec

EXEC get.myView @dataMart = 'Project', @viewName = 'Time', @token = '<myToken>', @version = '<202404>'

Response

src.COMPANY_ID,
src.PROJECT_ID,
src.CUSTOMER_ID,
dim_emp.PERSON_ID,
src.RESOURCE_ID,

SEQ

    src.ACTIVITY_SEQ,
    src.SUB_PROJECT_ID,
    src.PROJECT_TRANSACTION_SEQ_KEY,
    src.RESOURCE_SEQ,
dim_rpt.REPORT_CODE_GROUP,

Entity

ent_proj.project_item_id,
ent_cust.customer_id AS customer_item_id,

Dates

CONVERT(date, src.ACCOUNT_DATE, 23) AS ACCOUNT_DATE,

Measures

SALES

src.SALES_QUANTITY,
src.SALES_PRICE,
src.SALES_AMOUNT,
src.SALES_PRICE_BASE,
src.SALES_AMOUNT_BASE,

INTERNAL

	src.SALES_QUANTITY AS INTERNAL_QUANTITY,
	src.INTERNAL_PRICE,
	src.OVERHEAD_PRICE,
	src.TOTAL_INTERNAL_PRICE,
	src.INTERNAL_AMOUNT,

INVOICE

	src.INVOICE_ID,
	src.INVOICABILITY,
	src.INVOICE_STATUS,
	src.CURRENCY_CODE,

Codes

	src.ORG_CODE,
	src.ORG_STRUCTURE_ID,
	src.POS_CODE,
	src.REPORT_CODE,
	src.WORK_LOCATION,
	src.INTERNAL_COMMENTS --2024-07-11

SQL

BMT-DWH-DEV/Project_Time.sql