PSC_TS_SUBCLASS_META
This table contains subclassing metadata information.
Details
-
Schema: FUSION
-
Object owner: PSC_TS
-
Object type: TABLE
-
Tablespace: REFERENCE
Primary Key
| Name | Columns |
|---|---|
|
PSC_TS_SUBCLASS_META_PK |
SUBCLASS_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Status |
|---|---|---|---|---|---|---|
| SUBCLASS_ID | VARCHAR2 | 50 | Yes | This column is used to indicate subclass id | Active | |
| SUBCLASS_DESC | VARCHAR2 | 100 | Yes | This column is used to indicate subclass desc | Active | |
| APPMOD_NAME | VARCHAR2 | 100 | Yes | This column is used to indicate appmod name | Active | |
| APPMOD_CONFIG | VARCHAR2 | 100 | Yes | This column is used to indicate appmod config | Active | |
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | Active | |
| TABLE_0_NAME | VARCHAR2 | 60 | Yes | This column is used to indicate table 0 name | Active | |
| DISCR_COLUMN_NAME | VARCHAR2 | 60 | Yes | This column is used to indicate discr column name | Active | |
| BASE_PACKAGE_NAME | VARCHAR2 | 200 | Yes | This column is used to indicate base package name | Active | |
| SESSIONDEF_PACKAGE_NAME | VARCHAR2 | 200 | Yes | This column is used to indicate sessiondef package name | Active | |
| REST_SUBPACKAGE | VARCHAR2 | 60 | Yes | This column is used to indicate rest subpackage | Active | |
| BASE_EO_NAME | VARCHAR2 | 200 | Yes | This column is used to indicate base eo name | Active | |
| BASE_VO_NAME | VARCHAR2 | 200 | Yes | This column is used to indicate base vo name | Active | |
| SOURCE_PROPERTY_NAME | VARCHAR2 | 60 | Yes | This column is used to indicate source property name | Active | |
| DISCR_PROPERTY_NAME | VARCHAR2 | 60 | Yes | This column is used to indicate discr property name | Active | |
| NEW_EO_SUFFIX | VARCHAR2 | 60 | Yes | This column is used to indicate new eo suffix | Active | |
| NEW_VO_SUFFIX | VARCHAR2 | 60 | Yes | This column is used to indicate new vo suffix | Active | |
| NEW_FLATVO_SUFFIX | VARCHAR2 | 60 | Yes | This column is used to indicate new flatvo suffix | Active | |
| NEW_REST_SUFFIX | VARCHAR2 | 60 | Yes | This column is used to indicate new rest suffix | Active | |
| NEW_RESTFLAT_SUFFIX | VARCHAR2 | 60 | Yes | This column is used to indicate new restflat suffix | Active | |
| DISCR_CODE_PROPERTY | VARCHAR2 | 60 | Yes | This column is used to indicate discr code property | Active | |
| ADFM_CATALOG | VARCHAR2 | 200 | Yes | This column is used to indicate adfm catalog | Active | |
| OPSS_ADMIN_PRIVILEGES | VARCHAR2 | 200 | Yes | This column is used to indicate opss admin privileges | Active | |
| RESOURCE_REGISTRY | VARCHAR2 | 200 | Yes | This column is used to indicate resource registry | Active | |
| OPSS_REST_PERMISSION | VARCHAR2 | 200 | Yes | This column is used to indicate opss rest permission | Active | |
| OPSS_POLICY_NAME | VARCHAR2 | 60 | Yes | This column is used to indicate opss policy name | Active | |
| OPSS_ADMIN_USER | VARCHAR2 | 20 | This column is used to indicate opss admin user | Active | ||
| CUSTOM_VIEW_ROLE | VARCHAR2 | 100 | CUSTOM_VIEW_ROLE | |||
| CUSTOM_MANAGE_ROLE | VARCHAR2 | 100 | CUSTOM_MANAGE_ROLE | |||
| CUSTOM_APPLY_DATA_ROLE | VARCHAR2 | 100 | CUSTOM_APPLY_DATA | |||
| CUSTOM_MANAGE_AGENCY_ROLE | VARCHAR2 | 100 | CUSTOM_MANAGE_AGENCY | |||
| CUSTOM_PSC_VIEW_ALL_APPL | VARCHAR2 | 100 | CUSTOM_PSC_VIEW_ALL_APPL | |||
| TABLE_KEY | VARCHAR2 | 100 | TABLE_KEY | |||
| VO_KEY | VARCHAR2 | 100 | VO_KEY | |||
| DEFAULT_TEMPLATE | VARCHAR2 | 100 | DEFAULT_TEMPLATE | |||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | Active | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | Active | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | Active | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | Active | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | Active | ||
| SEED_DATA_LOCK | NUMBER | 1 | Yes | Indicates whether the row is seed data. Valid values are 0 for data that is customer data, 1 for seed data that cannot be modified, and 2 indicates that the seed data can be modified. | ||
| DELETED_FLAG | VARCHAR2 | 1 | Yes | Indicates whether the record is logically deleted (Y or N). Valid values are Y for deleted record, and N for active record. Default value is N. | ||
| SEED_DATA_SOURCE | VARCHAR2 | 512 | Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file. | |||
| ORA_SEED_SET1 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET1. Context values are Y or N. | ||
| ORA_SEED_SET2 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET2. Context values are Y or N. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| PSC_TS_SUBCLASS_META_PK | Unique | Default | SUBCLASS_ID, ORA_SEED_SET1 |
| PSC_TS_SUBCLASS_META_PK1 | Unique | Default | SUBCLASS_ID, ORA_SEED_SET2 |