Project.RoleAssignment

Purpose

Role Assignments incl Project Manager etc

Alternative to Project Manager in Project Details Plus

Includes Sub-Project Assignment

Use Case

Owner: Martyn Cole
Typical Use Case: Responsibility Assignment Matrix
Style: Fact

Source

QFACT_PROJECT_ROLE_ASSIGNM_OL$

Key Parameters

Company
Project
Resource

Sample Exec

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

Response

    [COMPANY],
    [PROJECT_ID],
    [PERSON_ID],

SEQ

    [SUB_PROJECT_ID],
    [ACTIVITY_SEQ],

Dates

Measures

Codes

    [ROLE_ID],
    CASE [ROLE_ID]
        WHEN 'PM' THEN 'Project Manager'
        WHEN '140' THEN 'Resource Manager'
        WHEN '130' THEN 'Project Controller'
    ELSE
        'no desc' END as [ROLE_Desc],
    [SYSTEM_GENERATED] as [SYSTEM_GENERATED_STATUS]

SQL

BMT-DWH-DEV/Project_RoleAssignment.sql