PJO_COMMITMENT_CONTROLS
This is used in commitment controls.
Details
-
Schema: FUSION
-
Object owner: PJO
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
PJO_COMMITMENT_CONTROLS_PK |
COMMITMENT_CONTROL_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| COMMITMENT_CONTROL_ID | NUMBER | 18 | Yes | COMMITMENT_CONTROL_ID ***** | |
| PLAN_TYPE_ID | NUMBER | 18 | Yes | PLAN_TYPE_ID ***** | |
| PROJECT_ID | NUMBER | 18 | PROJECT_ID ***** | ||
| OBJECT_ID1 | NUMBER | 18 | OBJECT_ID1 ***** | ||
| PLAN_VERSION_ID | NUMBER | 18 | PLAN_VERSION_ID ***** | ||
| CONTROL_LEVEL_FLAG | VARCHAR2 | 1 | CONTROL_LEVEL_FLAG ***** | ||
| CONTROL_LEVEL | VARCHAR2 | 255 | CONTROL_LEVEL ***** | ||
| CONTROL_VALUE | VARCHAR2 | 255 | CONTROL_VALUE ***** | ||
| PROJECT_BUDGET_LEDGER_ID | NUMBER | 18 | PROJECT_BUDGET_LEDGER_ID ***** | ||
| ATTRIBUTE_STATUS | VARCHAR2 | 30 | ATTRIBUTE_STATUS ***** | ||
| USE_DEFAULT_TOLERANCE_FLAG | VARCHAR2 | 1 | USE_DEFAULT_TOLERANCE_FLAG ***** | ||
| TOLERANCE | NUMBER | 18 | TOLERANCE ***** | ||
| TASK_ID | NUMBER | 18 | TASK_ID ***** | ||
| RBS_ELEMENT_ID | NUMBER | 18 | RBS_ELEMENT_ID ***** | ||
| PERIOD_START_DATE | DATE | PERIOD_START_DATE ***** | |||
| PERIOD_END_DATE | DATE | PERIOD_END_DATE ***** | |||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created 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. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| PJO_COMMITMENT_CONTROLS | pjo_plan_types_b | PLAN_TYPE_ID |
| PJO_COMMITMENT_CONTROLS | pjf_projects_all_b | PROJECT_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| PJO_COMMITMENT_CONTROLS_U1 | Unique | Default | COMMITMENT_CONTROL_ID |