PJF_COMP_RULE_SETS
PJF_COMP_RULE_SETS stores implementation-defined classifications used to describe how employees are compensated, particularly for premium overtime hours. We refer to compensation rule sets as compensation rules throughout the documentation for Oracle Projects. . . An employee's compensation rule may determine premium hours if premium overtime hours are calculated using the Overtime Calculation program. See the overtime essay in the Oracle Projects User's Guide for more information about using compensation rules to process overtime hours. . .
Details
-
Schema: FUSION
-
Object owner: PJF
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
PJF_COMP_RULE_SETS_PK |
COMP_RULE_SET_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Flexfield-mapping |
|---|---|---|---|---|---|---|
| COMP_RULE_SET_NAME | VARCHAR2 | 20 | Yes | Implementation-defined name that uniquely identifies the compensation rule ***** | ||
| COMP_RULE_SET_ID | NUMBER | 18 | Yes | The identifier of the Labor costing rule. ***** | ||
| 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. | |||
| START_DATE_ACTIVE | DATE | Yes | First effective date of the compensation rule | |||
| END_DATE_ACTIVE | DATE | Last effective date of the compensation rule | ||||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | Labor Costing Rules Descriptive Flexfield (PJF_COMP_RULE_SET_DESC_FLEX) | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Labor Costing Rules Descriptive Flexfield (PJF_COMP_RULE_SET_DESC_FLEX) | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Labor Costing Rules Descriptive Flexfield (PJF_COMP_RULE_SET_DESC_FLEX) | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Labor Costing Rules Descriptive Flexfield (PJF_COMP_RULE_SET_DESC_FLEX) | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Labor Costing Rules Descriptive Flexfield (PJF_COMP_RULE_SET_DESC_FLEX) | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Labor Costing Rules Descriptive Flexfield (PJF_COMP_RULE_SET_DESC_FLEX) | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Labor Costing Rules Descriptive Flexfield (PJF_COMP_RULE_SET_DESC_FLEX) | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Labor Costing Rules Descriptive Flexfield (PJF_COMP_RULE_SET_DESC_FLEX) | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Labor Costing Rules Descriptive Flexfield (PJF_COMP_RULE_SET_DESC_FLEX) | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Labor Costing Rules Descriptive Flexfield (PJF_COMP_RULE_SET_DESC_FLEX) | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Labor Costing Rules Descriptive Flexfield (PJF_COMP_RULE_SET_DESC_FLEX) | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Labor Costing Rules Descriptive Flexfield (PJF_COMP_RULE_SET_DESC_FLEX) | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Labor Costing Rules Descriptive Flexfield (PJF_COMP_RULE_SET_DESC_FLEX) | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Labor Costing Rules Descriptive Flexfield (PJF_COMP_RULE_SET_DESC_FLEX) | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Labor Costing Rules Descriptive Flexfield (PJF_COMP_RULE_SET_DESC_FLEX) | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Labor Costing Rules Descriptive Flexfield (PJF_COMP_RULE_SET_DESC_FLEX) | ||
| COSTING_METHOD | VARCHAR2 | 30 | Yes | Indicates whether labor costs are calculated by applying cost rates or whether labor costs are calculated by the labor costing extension. | ||
| 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_org_cost_sch_rules | pjf_comp_rule_sets | COMP_RULE_SET_NAME |
| pjf_comp_ot_exp_types | pjf_comp_rule_sets | COMP_RULE_SET_NAME |
| pjf_comp_ot_defaults_all | pjf_comp_rule_sets | COMP_RULE_SET_NAME |
| pjf_comp_details_all | pjf_comp_rule_sets | COMP_RULE_SET_NAME |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| PJF_COMP_RULE_SETS_U1 | Unique | Default | COMP_RULE_SET_ID |
| PJF_COMP_RULE_SETS_U2 | Unique | Default | COMP_RULE_SET_NAME |