PJS_PPC_REPORT_STRUCTURE_B
This table stores the page structure of a report or template used in project program communication.
Details
-
Schema: FUSION
-
Object owner: PJS
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
PJS_PPC_REP_STRUCT_B_PK |
OBJECT_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| OBJECT_ID | NUMBER | 18 | Yes | Unique identifier of an object within the report or template. | |
| REPORT_ID | NUMBER | 18 | Yes | Unique identifier of a template or report. | |
| OBJECT_PARENT_ID | NUMBER | 18 | Yes | Specifies the parent object of report or template items that are part of a group. | |
| OBJECT_LEVEL | NUMBER | 9 | Yes | Level in an object hierarchy. | |
| OBJECT_DISPLAY_SEQ | NUMBER | 9 | Yes | Specifies the display order of an object in the report or template. | |
| OBJECT_TYPE | VARCHAR2 | 30 | Yes | Specifies the types of objects like group, item, and table. | |
| OBJECT_NEW_LINE_IN_GROUP | VARCHAR2 | 1 | Yes | Specifies if an object appears in a new line in a report or template. | |
| OBJECT_HIDDEN_FLAG | VARCHAR2 | 1 | Yes | Specifies if an item is displayed on the UI. | |
| 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. | |
| 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 the object in the report or template. | ||
| OBJECT_LABEL_POSITION | VARCHAR2 | 30 | Label alignment of a catalog object like left, center, or right. | ||
| OBJECT_REFERENCE_ID | NUMBER | 18 | Catalog reference of the report or template object. | ||
| 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 third 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 fifth 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 objects based on SQL. | |||
| ITEM_OR_TABLE_REST_URL | VARCHAR2 | 1000 | The URL for objects 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. | ||
| 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. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| PJS_PPC_REP_STRUCT_B_N1 | Non Unique | Default | REPORT_ID |
| PJS_PPC_REP_STRUCT_B_N2 | Non Unique | Default | OBJECT_PARENT_ID, OBJECT_LEVEL, OBJECT_DISPLAY_SEQ, ITEM_SHORT_CODE |
| PJS_PPC_REP_STRUCT_B_U1 | Unique | Default | OBJECT_ID |