PJF_PM_PROD_CNTRL_RULES
PA_PM_PRODUCT_CONTROL_RULES holds information about the various actions to be controlled for a specific external product. An entry in this table indicates that an action is not allowed by the product that created the original project, task, or budget record. The related Oracle Projects forms do not allow any modification to such imported records.
Details
-
Schema: FUSION
-
Object owner: PJF
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
PJF_PM_PROD_CNTRL_RULES_PK |
PM_PROD_CONTROL_RULE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| CONTROL_RULE_ID | NUMBER | 18 | Yes | The identifier for the control action | |
| PM_PRODUCT_CODE | VARCHAR2 | 30 | Yes | The identifier of the external system | |
| FIELD_VALUE_ID | NUMBER | 18 | Holds the Plan Type Id for certain field names (like AC for Cost Budget). | ||
| PM_PROD_CONTROL_RULE_ID | NUMBER | 18 | Yes | Uniquely identifies the action control row. | |
| START_DATE_ACTIVE | DATE | Yes | The effective start date | ||
| END_DATE_ACTIVE | DATE | The effective end date | |||
| 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. | |
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of 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 |
|---|---|---|
| PJF_PM_PROD_CNTRL_RULES | pjf_pm_control_actions | CONTROL_RULE_ID |
| PJF_PM_PROD_CNTRL_RULES | pjo_plan_types_b | FIELD_VALUE_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| PJF_PM_PROD_CNTRL_RULES_U1 | Unique | Default | PM_PRODUCT_CODE, CONTROL_RULE_ID, START_DATE_ACTIVE |
| PJF_PM_PROD_CNTRL_RULES_U2 | Unique | Default | PM_PROD_CONTROL_RULE_ID |