[Home] [Help]
[Dependency Information]
Object Name: | MSC_INT_COLUMN_MAP |
---|---|
Object Type: | TABLE |
Owner: | MSC |
Subobject Name: | |
Status: | VALID |
PS/SNO Integration table that translates columns of more than 30 chars to a short name
Tablespace: | ![]() |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
MSC_INT_COLUMN_MAP_PK | NORMAL | UNIQUE |
![]() |
![]() ![]() ![]() ![]() ![]() |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
API_ID | VARCHAR2 | (30) | Yes | API ID of the packages |
MODEL | VARCHAR2 | (30) | Yes | Name of the XML model |
ENTITY_NAME | VARCHAR2 | (100) | Yes | Name of the entity name that makes the model |
LONG_PROPERTY | VARCHAR2 | (100) | Yes | Actual name of the column that is being translated |
SHORT_PROPERTY | VARCHAR2 | (100) | Translated column name | |
ZD_EDITION_NAME | VARCHAR2 | (30) | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT API_ID
, MODEL
, ENTITY_NAME
, LONG_PROPERTY
, SHORT_PROPERTY
, ZD_EDITION_NAME
FROM MSC.MSC_INT_COLUMN_MAP;
MSC.MSC_INT_COLUMN_MAP does not reference any database object
MSC.MSC_INT_COLUMN_MAP is referenced by following:
|
|
|