1. Tables and Views
  2. PSC_API_CATALOG

PSC_API_CATALOG

This table contains api catalog information.

Details

  • Schema: FUSION

  • Object owner: PSC_TS

  • Object type: TABLE

  • Tablespace: REFERENCE

Primary Key

Name Columns

PSC_API_CATALOG_PK

RESOURCE_NAME

Columns

Name Datatype Length Precision Not-null Comments Status
RESOURCE_ID VARCHAR2 50 Yes Resource id from PSC_RESOURCE_TYPES_B table Active
REST_END_POINT VARCHAR2 1000 Yes Rest end point referenced in the PSC_RESTENDPOINTS_B table Active
VERSION VARCHAR2 20 Yes Rest version number referenced in the PSC_RESTENDPOINTS_B table Active
RESOURCE_NAME VARCHAR2 256 Yes Unique resource name identifier. Active
REPORTABLE VARCHAR2 1 Yes Resource id can be used in reporting tools as data source Active
IS_SEARCH_ENABLED VARCHAR2 1 Yes This column is used to indicate is search enabled 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
IS_OFFLINE_SUPPORT_REQUIRED VARCHAR2 1 Yes This column is used to indicate is offline support required Active
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
QUERYSOURCE VARCHAR2 1 Resource id can be used as primary/related object in custom query Active
PROMPT_ENABLED VARCHAR2 1 This field to indicate if this rest resource is prompt enabled.
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.
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.
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.
MODULE_ID VARCHAR2 32 Seed Data Framework: indicates the module that owns the row. A module is an entry in Application Taxonomy such as a Logical Business Area. When the MODULE_ID column exists and the owner of the row is not specified, then the Seed Data Framework will not extract the row as seed data.
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.

Foreign Keys

Table Foreign Table Foreign Key Column
PSC_API_CATALOG psc_resource_types_b RESOURCE_ID

Indexes

Index Uniqueness Tablespace Columns Status
PSC_API_CATALOG_PK Unique FUSION_TS_SEED RESOURCE_NAME, ORA_SEED_SET1 Active
PSC_API_CATALOG_PK1 Unique FUSION_TS_SEED RESOURCE_NAME, ORA_SEED_SET2