PJF_PROJECT_CLASSES_INT
Table to import project classifications 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_CLASSES_INT_PK |
PROJ_CLASS_XFACE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| PROJ_CLASS_XFACE_ID | NUMBER | 18 | Yes | Unique identifier of the project classification being imported. | |
| PROJECT_ID | NUMBER | 18 | Identifier of the project to which the project classification belongs. | ||
| PROJECT_NAME | VARCHAR2 | 240 | Yes | Name of the project to which the project classification belongs. | |
| CLASS_CATEGORY_ID | NUMBER | 18 | Identifier of the Class Category for which project classification is being imported. | ||
| CLASS_CATEGORY | VARCHAR2 | 240 | Class Category Name for which project classification is being imported. | ||
| CLASS_CODE_ID | NUMBER | 18 | Identifier of the Class Code for which project classification is being imported. | ||
| CLASS_CODE | VARCHAR2 | 240 | Class Code Name for which project classification is being imported. | ||
| CODE_PERCENTAGE | NUMBER | Percentage of Class Code for which project classification is being imported. | |||
| 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 classification import. Valid values are SUBMITTED,PROCESSING,SUCCESS and ERROR. | ||
| PROCESSING_MODE | VARCHAR2 | 10 | Indicates the processing mode. Valid values are Create, Update, and Delete. The default value is Create. | ||
| 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. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| PJF_PROJECT_CLASSES_INT_U1 | Unique | Default | PROJ_CLASS_XFACE_ID |