DBA Data[Home] [Help] [Dependency Information]

TABLE: CSM.CSM_HA_RESP_MAPPINGS

Object Details
Object Name: CSM_HA_RESP_MAPPINGS
Object Type: TABLE
Owner: CSM
Subobject Name:
Status: VALID


This table lists all the responsibilities that have a corresponding HA responsibility mapped. It is assumed that the HA responsibility is defined by product teams, implementers to limit the UI activity in HA Record mode. During the HA mode, only the HA responsibilities should be used. An UI will be provided to populate this table.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
CSM_HA_RESP_MAPPINGS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnRESP_MAPPING_ID
CSM_HA_RESP_MAPPINGS_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnAPPLICATION_ID
ColumnRESPONSIBILITY_ID
ColumnHA_APPLICATION_ID
ColumnHA_RESPONSIBILITY_ID
Columns
Name Datatype Length Mandatory Comments
RESP_MAPPING_ID NUMBER
Yes
APPLICATION_ID NUMBER
Yes
RESPONSIBILITY_ID NUMBER
Yes
HA_APPLICATION_ID NUMBER
Yes
HA_RESPONSIBILITY_ID NUMBER
Yes
HA_RESP_KEY VARCHAR2 (255) Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
LAST_UPDATE_LOGIN NUMBER
Yes
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT RESP_MAPPING_ID
,      APPLICATION_ID
,      RESPONSIBILITY_ID
,      HA_APPLICATION_ID
,      HA_RESPONSIBILITY_ID
,      HA_RESP_KEY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM CSM.CSM_HA_RESP_MAPPINGS;

Dependencies

[top of page]

CSM.CSM_HA_RESP_MAPPINGS does not reference any database object

CSM.CSM_HA_RESP_MAPPINGS is referenced by following:

SchemaCSM
ViewCSM_HA_RESP_MAPPINGS#