Purpose
PRU and Programme Organisation
Source
DIM_CODE_E_OLParameters
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]
2 thoughts on “Global.Organisation”