Global.Organisation

Purpose

PRU and Programme Organisation

Source

DIM_CODE_E_OL

Parameters

PRU

Sample Exec

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

Response

pru_label.item_code as PRU, 
pru_label.item_desc AS [PRU Name], 
company_label.item_code as COMPANY_ID,
company_label.item_class as REGION,
company_label.item_desc as [Company Name],
prog.value AS Programme, 
prog_label.item_desc AS [Programme Name], 
subprog.value AS [Sub Programme], 
subprog_label.item_desc AS [Sub Programme Name]

SQL

BMT-DWH-DEV/Global_Organisation.sql

2 thoughts on “Global.Organisation”

Leave a Comment