PJB_DENORM_RATES
This table is for rate denormalization. The records will be derived during the change management flow.
Details
-
Schema: FUSION
-
Object owner: PJB
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
PJB_DENORM_RATES_PK |
DENORM_RATE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| DENORM_RATE_ID | NUMBER | 18 | Yes | DENORM_RATE_ID ***** | |
| CONTRACT_ID | NUMBER | CONTRACT_ID ***** | |||
| BILL_RATE_OVERRIDE_ID | NUMBER | 18 | BILL_RATE_OVERRIDE_ID ***** | ||
| JOB_ASSIGNMENT_OVERRIDE_ID | NUMBER | 18 | JOB_ASSIGNMENT_OVERRIDE_ID ***** | ||
| JOB_TITLE_OVERRIDE_ID | NUMBER | 18 | JOB_TITLE_OVERRIDE_ID ***** | ||
| LABOR_MULTIPLIER_ID | NUMBER | 18 | LABOR_MULTIPLIER_ID ***** | ||
| RATE_OVERRIDE_TYPE_CODE | VARCHAR2 | 30 | Yes | RATE_OVERRIDE_TYPE_CODE ***** | |
| BILL_PLAN_ID | NUMBER | 18 | Yes | BILL_PLAN_ID ***** | |
| CONTRACT_LINE_ID | NUMBER | 18 | CONTRACT_LINE_ID ***** | ||
| MAJOR_VERSION | NUMBER | 18 | MAJOR_VERSION ***** | ||
| ORGANIZATION_ID | NUMBER | 18 | ORGANIZATION_ID ***** | ||
| RATE | NUMBER | RATE ***** | |||
| MARKUP_PERCENTAGE | NUMBER | MARKUP_PERCENTAGE ***** | |||
| RATE_CURRENCY_CODE | VARCHAR2 | 30 | RATE_CURRENCY_CODE ***** | ||
| BILL_RATE_UNIT_CODE | VARCHAR2 | 30 | BILL_RATE_UNIT_CODE ***** | ||
| DISCOUNT_PERCENTAGE | NUMBER | DISCOUNT_PERCENTAGE ***** | |||
| RATE_DISC_REASON_CODE | VARCHAR2 | 30 | Rate change reason code | ||
| LABOR_MULTIPLIER | NUMBER | LABOR_MULTIPLIER ***** | |||
| START_DATE_ACTIVE | DATE | Yes | START_DATE_ACTIVE ***** | ||
| END_DATE_ACTIVE | DATE | END_DATE_ACTIVE ***** | |||
| PERSON_ID | NUMBER | 18 | PERSON_ID ***** | ||
| JOB_ID | NUMBER | 18 | JOB_ID ***** | ||
| BILLING_TITLE | VARCHAR2 | 80 | BILLING_TITLE ***** | ||
| NON_LABOR_RESOURCE | VARCHAR2 | 30 | NON_LABOR_RESOURCE ***** | ||
| EXPENDITURE_TYPE | VARCHAR2 | 30 | EXPENDITURE_TYPE ***** | ||
| NON_LABOR_RESOURCE_ID | NUMBER | 18 | NON_LABOR_RESOURCE_ID ***** | ||
| EXPENDITURE_TYPE_ID | NUMBER | 18 | EXPENDITURE_TYPE_ID ***** | ||
| PRECEDENCE_NUM | NUMBER | 18 | PRECEDENCE_NUM ***** | ||
| 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. | |
| 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_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. | |
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| PJB_DENORM_RATES | pjb_bill_rate_ovrrds | BILL_RATE_OVERRIDE_ID, MAJOR_VERSION |
| PJB_DENORM_RATES | pjb_job_assgmnt_ovrrds | MAJOR_VERSION, JOB_ASSIGNMENT_OVERRIDE_ID |
| PJB_DENORM_RATES | pjb_labor_mult_ovrrds | LABOR_MULTIPLIER_ID, MAJOR_VERSION |
| PJB_DENORM_RATES | pjb_job_title_ovrrds | JOB_TITLE_OVERRIDE_ID, MAJOR_VERSION |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| PJB_DENORM_RATES_N1 | Non Unique | Default | BILL_PLAN_ID, CONTRACT_LINE_ID, PRECEDENCE_NUM, START_DATE_ACTIVE, END_DATE_ACTIVE |
| PJB_DENORM_RATES_N2 | Non Unique | Default | BILL_PLAN_ID, CONTRACT_LINE_ID, PRECEDENCE_NUM, RATE_OVERRIDE_TYPE_CODE, PERSON_ID, START_DATE_ACTIVE, END_DATE_ACTIVE |
| PJB_DENORM_RATES_N3 | Non Unique | Default | BILL_PLAN_ID, CONTRACT_LINE_ID, PRECEDENCE_NUM, RATE_OVERRIDE_TYPE_CODE, JOB_ID, START_DATE_ACTIVE, END_DATE_ACTIVE |
| PJB_DENORM_RATES_N4 | Non Unique | Default | BILL_PLAN_ID, CONTRACT_LINE_ID, PRECEDENCE_NUM, RATE_OVERRIDE_TYPE_CODE, EXPENDITURE_TYPE_ID, NON_LABOR_RESOURCE_ID, START_DATE_ACTIVE, END_DATE_ACTIVE |
| PJB_DENORM_RATES_U4 | Unique | Default | DENORM_RATE_ID |