PJO_XCC_PERIOD_MAPPING
Table stores periods of the calendars created during XCC integration and the order of the periods within the calendar. This helps XCC in mapping the periods of the uber calendar which Essbase uses.
Details
-
Schema: FUSION
-
Object owner: PJO
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
PJO_XCC_PERIOD_MAPPING_PK |
MAPPING_ID, PROJECT_ID, OBJECT_ID1 |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| MAPPING_ID | NUMBER | 18 | Yes | Unique identifier of a row within this table. | |
| PROJECT_ID | NUMBER | 18 | Yes | Unique identifier of a project. | |
| OBJECT_ID1 | NUMBER | 18 | Yes | Unique identifier of either an award or a project, depending on whether the calendar is created for an award budget or a project budget. | |
| PERIOD_ID | NUMBER | 18 | Unique identifier of a period for awards with multi-period calendars. | ||
| CALENDAR_ID | NUMBER | 18 | Unique identifier of the calendar. | ||
| PERIOD_NAME | VARCHAR2 | 15 | Name of the period within the calendar. | ||
| PERIOD_SEQ | NUMBER | Sequence of the period within the calendar. | |||
| CALENDAR_TYPE | VARCHAR2 | 20 | Indicates whether the calendar is a multi-period calendar, or a summary calendar. | ||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| 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_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated 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. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| PJO_XCC_PERIOD_MAPPING_U1 | Unique | Default | MAPPING_ID |
| PJO_XCC_PERIOD_MAPPING_U2 | Unique | Default | PROJECT_ID, CALENDAR_ID, PERIOD_SEQ |
| PJO_XCC_PERIOD_MAPPING_U3 | Unique | Default | PROJECT_ID, CALENDAR_ID, PERIOD_NAME |
| PJO_XCC_PERIOD_MAPPING_U4 | Unique | Default | MAPPING_ID, PROJECT_ID, OBJECT_ID1 |