PJF_RATE_OVERRIDES_INT
Imports rate overrides from an external application into Project Financial Management applications. The Import Project Rate Schedules process validates and imports data from the interface table to Project Financial Management applications transaction tables.
Details
-
Schema: FUSION
-
Object owner: PJF
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
| Name | Columns |
|---|---|
|
PJF_RATE_OVERRIDES_INT_PK |
RATE_OVERRIDE_INT_REC_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| RATE_OVERRIDE_INT_REC_ID | NUMBER | 18 | Yes | Identifier of the rate override that is being imported. | |
| RATE_HASH_CODE | NUMBER | Stores an internally generated code that is used for identifying duplicate rate overrides. | |||
| RATE_USE_CODE | VARCHAR2 | 1 | Yes | Determines the rate usage. C for cost rate override and B for bill rate override. | |
| CONTRACT_ID | NUMBER | 18 | Identifier of the contract for which the rate override is defined. | ||
| CONTRACT_NUMBER | VARCHAR2 | 120 | Number of the contract for which the rate override is defined. | ||
| CONTRACT_TYPE_ID | NUMBER | 18 | Type of the contract for which the rate override is defined. | ||
| CONTRACT_TYPE | VARCHAR2 | 150 | Type of the contract to which the bill or revenue rate override belongs. | ||
| BILL_PLAN_ID | NUMBER | 18 | Identifier of the bill or revenue plan for which the rate override is defined. | ||
| PLAN_NAME | VARCHAR2 | 30 | Name of the bill or revenue plan for which the rate override is defined. | ||
| PLAN_TYPE | VARCHAR2 | 30 | Type of the plan for which the rate override is defined. | ||
| CONTRACT_LINE_ID | NUMBER | 18 | Identifier of the contract line for which the rate override is defined. | ||
| CONTRACT_LINE_NUMBER | VARCHAR2 | 150 | Number of the contract line for which the rate override is defined. | ||
| PROJECT_ID | NUMBER | 18 | Identifier of the project for which the rate override is defined. | ||
| PROJECT_NUMBER | VARCHAR2 | 25 | Number of the project for which the rate override is defined. | ||
| TASK_ID | NUMBER | 18 | Identifier of the project task for which the rate override is defined. | ||
| TASK_NUMBER | VARCHAR2 | 100 | Number of the task for which the rate override is defined. | ||
| PERSON_ID | NUMBER | 18 | Identifier of the person for which the rate override is defined. | ||
| PERSON_NAME | VARCHAR2 | 240 | Name of the person for which the rate override is defined. | ||
| PERSON_NUMBER | VARCHAR2 | 30 | Number of the person for which the rate override is defined. | ||
| PERSON_EMAIL | VARCHAR2 | 240 | Primary email address of the person for which the rate override is defined. | ||
| JOB_ID | NUMBER | 18 | Identifier of the job for which the rate override is defined. | ||
| JOB_CODE | VARCHAR2 | 30 | Code of the job for which the rate override is defined. | ||
| EXPENDITURE_TYPE_ID | NUMBER | 18 | Identifier of the expenditure type for which the rate override is defined. | ||
| EXPENDITURE_TYPE_NAME | VARCHAR2 | 240 | Name of the expenditure type for which the rate override is defined. | ||
| RATE | NUMBER | Yes | Amount of the rate override. | ||
| CURRENCY_CODE | VARCHAR2 | 15 | Yes | Currency used for the override rate. | |
| RATE_UNIT | VARCHAR2 | 30 | Unit of measure for the rate override. | ||
| START_DATE_ACTIVE | DATE | Yes | Date from which the rate override is active. | ||
| END_DATE_ACTIVE | DATE | Date up to which the rate override is active. | |||
| RATE_OVERRIDE_REASON | VARCHAR2 | 80 | Reason for the rate override. | ||
| RATE_OVERRIDE_REASON_CODE | VARCHAR2 | 30 | Lookup code of rate override reason. | ||
| STATUS | VARCHAR2 | 30 | Yes | Internal status of the record during various stages of its lifecycle. | |
| LOAD_REQUEST_ID | NUMBER | 18 | Identifier of the enterprise service scheduler process that loads the record into Interface table. | ||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Who column: indicates the user who created the row. | ||
| CREATION_DATE | TIMESTAMP | Who column: indicates the date and time of the creation of the row. | |||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Who column: indicates the user who last updated the row. | ||
| LAST_UPDATE_DATE | TIMESTAMP | 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. | ||
| PROJECT_ROLE_ID | NUMBER | 18 | Identifier of the project role for which the rate override is defined. | ||
| PROJECT_ROLE_NAME | VARCHAR2 | 240 | Name of the project role for which the rate override is defined. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| PJF_RATE_OVERRIDES_INT | pjf_projects_all_b | PROJECT_ID |
| PJF_RATE_OVERRIDES_INT | pjf_proj_elements_b | TASK_ID |
| PJF_RATE_OVERRIDES_INT | okc_contract_types_b | CONTRACT_TYPE_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| PJF_RATE_OVERRIDES_INT_N1 | Non Unique | Default | REQUEST_ID, STATUS |
| PJF_RATE_OVERRIDES_INT_N2 | Non Unique | Default | RATE_HASH_CODE |
| PJF_RATE_OVERRIDES_INT_U1 | Unique | Default | RATE_OVERRIDE_INT_REC_ID |