DDIC Blocking Task
dr DDIC für en Task mit eigenem Layout für s'Blocking azluege
[Data Dictionary 1.0]
datamart rbsc$blocking
/*
-------------------------------------------------------------------------------------------------------------
Bank:
Business Area:
Description: DDIC for RBSC$TASK_BLOCKING allowing access to blocked object information
-------------------------------------------------------------------------------------------------------------
ID Date Name, Company Issue Affected BUs, Description
-------------------------------------------------------------------------------------------------------------
001
-------------------------------------------------------------------------------------------------------------
*/
descn [Datamart for information on blocked objects]
bu_id id obj_bp_bu
descn [Business Unit]
label [LABEL.BU]
select [ob.bu_id]
obj_type_id id table code_obj_type
descn [Object type]
label [LABEL.OBJ_TYPE]
select [ob.obj_type_id]
obj_sub_type_id id table code_obj_sub_type
descn [Object Subtype]
label [LABEL.OBJ_SUB_TYPE]
select [ob.obj_sub_type_id]
obj_id id obj
descn [Object]
label [LABEL.OBJ]
select [ob.id]
alias [obj_id]
block_id id table code_block
descn [Block Code]
label [LABEL.BLOCK_CODE]
select [ob.block_id]
block_text text
descn [BLOCK TEXT]
label [LABEL.BLOCK_TEXT]
select [ob.block]
alias [block_text]
remark text
descn [Remark]
label [LABEL.REMARK]
select [r.remark]
end datamart
