Display User's Business Area Instances

Use naming view CDR_PUB_GENERIC_BA_V to retrieve all the Generic Visualization Business Area instances on which a user has privileges to read data.

You can use this view to build a hierarchy in the visualization tool's user interface that displays each Business Area instance to which the current user has access, in the context of its Work Area, Application Area, and Domain.

This effectively enforces security by allowing the user to select only Business Areas to which he or she has access.

For each Business Area, the view retrieves the following:

COMPANY_ID. NUMBER(6,0) The Business Area instance's company ID.

BA_OBJ_ID. NUMBER(22,0) The Business Area instance's object ID.

BA_OBJ_VER. NUMBER(7,0) The Business Area instance's object version.

BA_NAME. VARCHAR2(200) The Business Area instance's name.

SCHEMA_NAME. VARCHAR2(30) The Business Area instance's unique schema name.

BA_DESCRIPTION. VARCHAR2(2000) The Business Area instance's description, if any.

BA_STATUS_RC. VARCHAR2(30) The Business Area instance's status. The possible values are: $NAMING_STATUS$UPGRADEABLE or $NAMING_STATUS$NONINSTALLABLE. See the Oracle Life Sciences Data Hub Application Developer's Guide for more information.

BA_VALIDATION_STATUS_RC. VARCHAR2(30) The Business Area instance's validation status. The possible values are: $SYSVALDNSTEPS$DEVELOPMENT, $SYSVALDNSTEPS$PRODUCTION, $SYSVALDNSTEPS$QUALITYCONTROL, $SYSVALDNSTEPS$RETIRED.

BA_VERSION_LABEL. VARCHAR2(255) The Business Area instance version's label, if any.

WA_OBJ_ID. NUMBER(22,0) The Business Area instance's parent Work Area's object ID.

WA_OBJ_VER. NUMBER(7,0) The Business Area instance's parent Work Area's object version.

WORKAREA. VARCHAR2(4000) The Business Area instance's parent Work Area's name.

WA_VALIDATION_STATUS_RC. VARCHAR2(30) The Business Area instance's parent Work Area's validation status. The possible values are: $SYSVALDNSTEPS$DEVELOPMENT, $SYSVALDNSTEPS$PRODUCTION, $SYSVALDNSTEPS$QUALITYCONTROL, $SYSVALDNSTEPS$RETIRED.

APPLICATION_AREA. VARCHAR2(4000) The Work Area's parent Application Area's name.

DOMAIN. VARCHAR2(4000) The Application Area's parent Domain's name.

Note:

Multiple levels of Domains are not included in the hierarchy.

BA_DEF_OBJ_ID. NUMBER(22,0) The Business Area definition's object ID.

BA_DEF_OBJ_VER. NUMBER(7,0) The Business Area definition's object version.

BA_DEF_NAME. VARCHAR2(200) The Business Area definition's name.