PJF_PROJECT_PARTIES_INT
Table to import project team members from an external application into Oracle Fusion Project Financial Management. The Import Projects process validates and imports data from the interface table to Oracle Fusion Project Financial Management transaction tables.
Details
-
Schema: FUSION
-
Object owner: PJF
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
| Name | Columns |
|---|---|
|
PJF_PROJECT_PARTIES_INT_PK |
TEAM_MEMBER_XFACE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| TEAM_MEMBER_XFACE_ID | NUMBER | 18 | Yes | Unique identifier of the team member being imported. | |
| PROJECT_ID | NUMBER | 18 | Identifier of the project to which the team member belongs. | ||
| PROJECT_NAME | VARCHAR2 | 240 | Yes | Name of the project to which the team member belongs. | |
| RESOURCE_SOURCE_ID | NUMBER | 18 | Identifier of the person for whom project team member record is being imported. | ||
| TEAM_MEMBER_NUMBER | VARCHAR2 | 30 | Number of the person for whom project team member record is being imported. | ||
| TEAM_MEMBER_NAME | VARCHAR2 | 240 | List Name of the person for whom project team member record is being imported. | ||
| TEAM_MEMBER_EMAIL | VARCHAR2 | 240 | Email Address of the person for whom project team member record is being imported. | ||
| PROJECT_ROLE_ID | NUMBER | 18 | Identifier of Project Role Type to be assigned to the team member. | ||
| PROJECT_ROLE_NAME | VARCHAR2 | 240 | Project Role Type Name to be assigned to the team member. | ||
| START_DATE_ACTIVE | DATE | Start Date of project team member. | |||
| END_DATE_ACTIVE | DATE | End Date of project team member. | |||
| TRACK_TIME_FLAG | VARCHAR2 | 1 | Flag to indicate whether the application must track missing time for the team member. Valid values are Y and N. | ||
| LOAD_REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that loaded the interface table. | ||
| LOAD_STATUS | VARCHAR2 | 30 | Load Status of the record from csv file to interface table. Valid values are ON HOLD and COMPLETE. | ||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| IMPORT_STATUS | VARCHAR2 | 30 | Status of the project team member import. Valid values are SUBMITTED,PROCESSING,SUCCESS and ERROR. | ||
| CREATION_DATE | TIMESTAMP | Who column: indicates the date and time of the creation of the row. | |||
| CREATED_BY | VARCHAR2 | 64 | Who column: indicates the user who created the row. | ||
| LAST_UPDATE_DATE | TIMESTAMP | Who column: indicates the date and time of the last update of the row. | |||
| LAST_UPDATED_BY | VARCHAR2 | 64 | 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. | ||
| 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. | |
| ALLOCATION | NUMBER | Allocation Percentage for the resource | |||
| EFFORT | NUMBER | Total Effort in hours for the resource | |||
| COST_RATE | NUMBER | Cost Rate of the resource | |||
| BILL_RATE | NUMBER | Bill Rate of the resource | |||
| ASSIGNMENT_TYPE | VARCHAR2 | 30 | Type of assignment of the project resource. Possible values are BILLABLE or NON-BILLABLE or null. | ||
| BILLABLE_PERCENT | NUMBER | Percentage of the billable scheduled time of the project resource. | |||
| BILLABLE_PERCENT_REASON_CODE | VARCHAR2 | 30 | Reason Code for the billable percentage of the project resource being less than 100%. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| PJF_PROJECT_PARTIES_INT_U1 | Unique | Default | TEAM_MEMBER_XFACE_ID |