PJF_RATE_SCHEDULES_INT
Table used to import project rate schedules from an external application into Oracle Fusion Project Financial Management. The Import Project Rate Schedules process validates and imports data from the interface table to Oracle Fusion Project Financial Management reference tables.
Details
-
Schema: FUSION
-
Object owner: PJF
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
| Name | Columns |
|---|---|
|
PJF_RATE_SCHEDULES_INT_PK |
RATE_SCH_INT_REC_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| RATE_SCH_INT_REC_ID | NUMBER | 18 | Yes | Unique identifier of the rate schedule being imported. | |
| RATE_SCHEDULE_NAME | VARCHAR2 | 30 | Yes | Name of the rate schedule that contains rates or markup percentage for person, job, nonlabor expenditure type, nonlabor resource and resource class. | |
| DESCRIPTION | VARCHAR2 | 250 | The description of the rate schedule. | ||
| SCHEDULE_TYPE | VARCHAR2 | 30 | Yes | The type of rate schedule. | |
| PROJECT_RATES_SET_NAME | VARCHAR2 | 80 | Yes | The set of reference data used to filter and share rate schedules across business units. | |
| JOB_SET_NAME | VARCHAR2 | 80 | The set of reference data used to determine which jobs are available for the job-based rate schedule. | ||
| CURRENCY_CODE | VARCHAR2 | 15 | Yes | The currency associated with the rate schedule. | |
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| LOAD_REQUEST_ID | NUMBER | 18 | The identifier of the Enterprise Service Scheduler process that loaded the record into the interface table. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who 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. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| PJF_RATE_SCHEDULES_U1 | Unique | Default | RATE_SCH_INT_REC_ID |