PJS_PPC_CATALOG_B
This table stores the seeded or user created page structures of the project program communication reports. The page structure objects could be seeded or user created. Within user created they could be private or public. The page structure objects could be of any type i.e. Groups, Measures, Texts, Tables, Graphs and other items.
Details
-
Schema: FUSION
-
Object owner: PJS
-
Object type: TABLE
-
Tablespace: REFERENCE
Primary Key
| Name | Columns |
|---|---|
|
PJS_PPC_CATALOG_B_PK |
OBJECT_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| OBJECT_ID | NUMBER | 18 | Yes | Unique identifier of a catalog object. | |
| OBJECT_TYPE | VARCHAR2 | 30 | Yes | Specifies the types of objects in a catalog like a group, item, and table. | |
| OBJECT_PARENT_ID | NUMBER | 18 | Yes | Specifies the parent object of objects that are part of a group in a catalog. | |
| OBJECT_LEVEL | NUMBER | 9 | Yes | Level in an object hierarchy. | |
| OBJECT_USAGE | VARCHAR2 | 30 | Yes | Specifies if a catalog object is for a project or program. | |
| OBJECT_ORIGIN | VARCHAR2 | 30 | Yes | Specifies if a catalog object is seeded or user created. | |
| OBJECT_GROUP_PUBLIC_ACCESS | VARCHAR2 | 1 | Yes | Specifies whether a user-created group is available to others for use. | |
| OBJECT_NEW_LINE_IN_GROUP | VARCHAR2 | 1 | Yes | Specifies if an item appears in a new line within a group. | |
| OBJECT_HIDDEN_FLAG | VARCHAR2 | 1 | Yes | Specifies if an item is displayed on the UI. | |
| 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. | |
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| 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. | |
| 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. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| OBJECT_ICON | VARCHAR2 | 500 | Specifies the icon details for thecatalog card on the UI. | ||
| OBJECT_LABEL_POSITION | VARCHAR2 | 30 | Label alignment of a catalog object like left, center, or right. | ||
| OBJECT_GROUP_OWNER_PERSON_ID | NUMBER | 18 | Owner of a user-created group object. | ||
| OBJECT_SEQ_IN_GROUP | NUMBER | 9 | Specifies the sequence of items in a group. | ||
| TABLE_GRAPH_TYPE | VARCHAR2 | 30 | Specifies the default graph type, like bar or pie, to be rendered for a table-type item. | ||
| TABLE_DEF_SORT_ORDER_COL_NO | NUMBER | 3 | Default column for sorting table data. | ||
| TABLE_DEFAULT_SORT_ORDER | VARCHAR2 | 30 | Default sort order, like ascending or descending, on a table column. | ||
| TABLE_COL_TYPE_COL_1 | VARCHAR2 | 30 | Type, like text, date, number, or amount, for the first column of the table-type items. | ||
| TABLE_COL_TYPE_COL_2 | VARCHAR2 | 30 | Type, like text, date, number, or amount, for the second column of the table-type items. | ||
| TABLE_COL_TYPE_COL_3 | VARCHAR2 | 30 | Type, like text, date, number, or amount, for the fthird column of the table-type items. | ||
| TABLE_COL_TYPE_COL_4 | VARCHAR2 | 30 | Type, like text, date, number, or amount, for the fourth column of the table-type items. | ||
| TABLE_COL_TYPE_COL_5 | VARCHAR2 | 30 | Type, like text, date, number, or amount, for the ffifth column of the table-type items. | ||
| TABLE_COL_TYPE_COL_6 | VARCHAR2 | 30 | Type, like text, date, number, or amount, for the sixth column of the table-type items. | ||
| ITEM_OR_TABLE_SQL_QUERY | CLOB | The query for tables or items based on SQL. | |||
| ITEM_OR_TABLE_REST_URL | VARCHAR2 | 1000 | The URL for tables or items based on REST. | ||
| ITEM_SHORT_CODE | VARCHAR2 | 30 | Shortcode for items to be used in a formula within the same group. | ||
| ITEM_CALC_FORMULA | VARCHAR2 | 400 | Text field to store the formula that a group item is based on. This is applicable only for items that can be used in calculations. | ||
| ITEM_LOV_LOOKUP_TYPE | VARCHAR2 | 30 | List of values that an item of type input-list is based on. | ||
| ITEM_DATA_TYPE | VARCHAR2 | 30 | Catalog object data type like text, number, amount, or date. | ||
| EXTERNAL_SOURCE | VARCHAR2 | 30 | External source from where the data is uploaded. | ||
| EXTERNAL_SOURCE_REFERENCE | VARCHAR2 | 30 | External source reference identifier from where the data is uploaded. | ||
| ADDL_ATTRIBUTE1 | VARCHAR2 | 150 | Oracle internal use only. | ||
| ADDL_ATTRIBUTE2 | VARCHAR2 | 150 | Oracle internal use only. | ||
| ADDL_ATTRIBUTE3 | VARCHAR2 | 150 | Oracle internal use only. | ||
| ADDL_ATTRIBUTE4 | VARCHAR2 | 150 | Oracle internal use only. | ||
| ADDL_ATTRIBUTE5 | VARCHAR2 | 150 | Oracle internal use only. | ||
| OBJECT_REFERENCE_ID | NUMBER | 18 | Catalog self reference of the object. | ||
| MEASURE_ID | NUMBER | 18 | Performance measure reference. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| PJS_PPC_CATALOG_B_N1 | Non Unique | Default | OBJECT_USAGE, OBJECT_PARENT_ID, OBJECT_LEVEL, OBJECT_SEQ_IN_GROUP, ITEM_SHORT_CODE |
| PJS_PPC_CATALOG_B_N2 | Non Unique | Default | OBJECT_USAGE, OBJECT_ORIGIN, OBJECT_GROUP_OWNER_PERSON_ID, OBJECT_GROUP_PUBLIC_ACCESS |
| PJS_PPC_CATALOG_B_U1 | Unique | Default | OBJECT_ID, ORA_SEED_SET1 |
| PJS_PPC_CATALOG_B_U11 | Unique | Default | OBJECT_ID, ORA_SEED_SET2 |