1. Tables and Views for Project Management
  2. PJF_RATE_SCHEDULE_LINES_INT

PJF_RATE_SCHEDULE_LINES_INT

Table used to import project rate schedule lines 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_SCHEDULE_LINES_INT_PK

RATE_SCHEDULE_LINE_INT_REC_ID

Columns

Name Datatype Length Precision Not-null Comments
RATE_SCHEDULE_LINE_INT_REC_ID NUMBER 18 Yes Unique identifier of the rate schedule line 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.
PERSON_NAME VARCHAR2 240 Name of the person for whom the rate or markup percentage is created in the rate schedule.
PERSON_NUMBER VARCHAR2 30 A number that uniquely identifies the person for whom the rate is defined.
PERSON_EMAIL VARCHAR2 240 The e-mail address of the person for whom the rate is defined.
PERSON_JOB_CODE VARCHAR2 30 The job assigned to the person in human resources for which the rate or markup percentage is created in the rate schedule.
PERSON_ORG_NAME VARCHAR2 240 The organization assigned to the person in human resources for which the rate or markup percentage is created in the rate schedule.
JOB_CODE VARCHAR2 30 Code of the job to which a rate is defined in the rate schedule.
EXPENDITURE_TYPE_NAME VARCHAR2 240 A classification of cost assigned to each expenditure item. Expenditure types are grouped into cost groups (expenditure categories) and revenue groups (revenue categories).
NON_LABOR_RESOURCE_NAME VARCHAR2 240 The name of the nonlabor resource.
NON_LABOR_RES_ORG_NAME VARCHAR2 240 Name of the nonlabor resource organization that owns the nonlabor resource to which a rate or markup percentage is defined in the rate schedule.
RESOURCE_CLASS_NAME VARCHAR2 240 A grouping of resource types. Resource classes are predefined and include Labor, Equipment, Material Items, and Financial Elements.
RESOURCE_CLASS_ORG_NAME VARCHAR2 240 Name of the resource class organization to which a rate or markup percentage is defined in the rate schedule.
UNIT_OF_MEASURE VARCHAR2 80 The unit of measure associated with the resource class in the resource class rate schedule line.
RATE NUMBER The rate, assigned to the rate schedule line, that is to be applied to calculate the raw cost and revenue amounts.
MARKUP_PERCENTAGE NUMBER Indicates the percent to increase or decrease the rate from the source rate schedule.
START_DATE_ACTIVE DATE Yes The date from which the rate is active.
END_DATE_ACTIVE DATE The date to which the rate is active.
LOAD_REQUEST_ID NUMBER 18 The identifier of the Enterprise Service Scheduler process that loaded the record into the 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_NAME VARCHAR2 240 Name of the project role for which the rate or markup percentage is created in the rate schedule.

Indexes

Index Uniqueness Tablespace Columns
PJF_RATE_SCHEDULE_LINES_U3 Unique Default RATE_SCHEDULE_LINE_INT_REC_ID