PJT_TASK_CODES_INT
This is an interface table for PJT Task Codes import
Details
-
Schema: FUSION
-
Object owner: PJT
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
| Name | Columns |
|---|---|
|
PJT_TASK_CODES_INT_PK |
INTERFACE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| INTERFACE_ID | NUMBER | 18 | Yes | Unique Id for each Interface record | |
| PROJECT_NAME | VARCHAR2 | 240 | Yes | Name of the project. | |
| TASK_NAME | VARCHAR2 | 255 | Name of the task | ||
| TASK_NUMBER | VARCHAR2 | 100 | Yes | Task number from the source application | |
| SRC_REFERENCE_TASK | VARCHAR2 | 25 | Reference to Source Task | ||
| PRJ_TASK_CODE01 | VARCHAR2 | 80 | Value for user defined task attribute value set 01 | ||
| PRJ_TASK_CODE02 | VARCHAR2 | 80 | Value for user defined task attribute value set 02 | ||
| PRJ_TASK_CODE03 | VARCHAR2 | 80 | Value for user defined task attribute value set 03 | ||
| PRJ_TASK_CODE04 | VARCHAR2 | 80 | Value for user defined task attribute value set 04 | ||
| PRJ_TASK_CODE05 | VARCHAR2 | 80 | Value for user defined task attribute value set 05 | ||
| PRJ_TASK_CODE06 | VARCHAR2 | 80 | Value for user defined task attribute value set 06 | ||
| PRJ_TASK_CODE07 | VARCHAR2 | 80 | Value for user defined task attribute value set 07 | ||
| PRJ_TASK_CODE08 | VARCHAR2 | 80 | Value for user defined task attribute value set 08 | ||
| PRJ_TASK_CODE09 | VARCHAR2 | 80 | Value for user defined task attribute value set 09 | ||
| PRJ_TASK_CODE10 | VARCHAR2 | 80 | Value for user defined task attribute value set 10 | ||
| PRJ_TASK_CODE11 | VARCHAR2 | 80 | Value for user defined task attribute value set 11 | ||
| PRJ_TASK_CODE12 | VARCHAR2 | 80 | Value for user defined task attribute value set 12 | ||
| PRJ_TASK_CODE13 | VARCHAR2 | 80 | Value for user defined task attribute value set 13 | ||
| PRJ_TASK_CODE14 | VARCHAR2 | 80 | Value for user defined task attribute value set 14 | ||
| PRJ_TASK_CODE15 | VARCHAR2 | 80 | Value for user defined task attribute value set 15 | ||
| PRJ_TASK_CODE16 | VARCHAR2 | 80 | Value for user defined task attribute value set 16 | ||
| PRJ_TASK_CODE17 | VARCHAR2 | 80 | Value for user defined task attribute value set 17 | ||
| PRJ_TASK_CODE18 | VARCHAR2 | 80 | Value for user defined task attribute value set 18 | ||
| PRJ_TASK_CODE19 | VARCHAR2 | 80 | Value for user defined task attribute value set 19 | ||
| PRJ_TASK_CODE20 | VARCHAR2 | 80 | Value for user defined task attribute value set 20 | ||
| PRJ_TASK_CODE21 | VARCHAR2 | 80 | Value for user defined task attribute value set 21 | ||
| PRJ_TASK_CODE22 | VARCHAR2 | 80 | Value for user defined task attribute value set 22 | ||
| PRJ_TASK_CODE23 | VARCHAR2 | 80 | Value for user defined task attribute value set 23 | ||
| PRJ_TASK_CODE24 | VARCHAR2 | 80 | Value for user defined task attribute value set 24 | ||
| PRJ_TASK_CODE25 | VARCHAR2 | 80 | Value for user defined task attribute value set 25 | ||
| PRJ_TASK_CODE26 | VARCHAR2 | 80 | Value for user defined task attribute value set 26 | ||
| PRJ_TASK_CODE27 | VARCHAR2 | 80 | Value for user defined task attribute value set 27 | ||
| PRJ_TASK_CODE28 | VARCHAR2 | 80 | Value for user defined task attribute value set 28 | ||
| PRJ_TASK_CODE29 | VARCHAR2 | 80 | Value for user defined task attribute value set 29 | ||
| PRJ_TASK_CODE30 | VARCHAR2 | 80 | Value for user defined task attribute value set 30 | ||
| PRJ_TASK_CODE31 | VARCHAR2 | 80 | Value for user defined task attribute value set 31 | ||
| PRJ_TASK_CODE32 | VARCHAR2 | 80 | Value for user defined task attribute value set 32 | ||
| PRJ_TASK_CODE33 | VARCHAR2 | 80 | Value for user defined task attribute value set 33 | ||
| PRJ_TASK_CODE34 | VARCHAR2 | 80 | Value for user defined task attribute value set 34 | ||
| PRJ_TASK_CODE35 | VARCHAR2 | 80 | Value for user defined task attribute value set 35 | ||
| PRJ_TASK_CODE36 | VARCHAR2 | 80 | Value for user defined task attribute value set 36 | ||
| PRJ_TASK_CODE37 | VARCHAR2 | 80 | Value for user defined task attribute value set 37 | ||
| PRJ_TASK_CODE38 | VARCHAR2 | 80 | Value for user defined task attribute value set 38 | ||
| PRJ_TASK_CODE39 | VARCHAR2 | 80 | Value for user defined task attribute value set 39 | ||
| PRJ_TASK_CODE40 | VARCHAR2 | 80 | Value for user defined task attribute value set 40 | ||
| NUMBER_ATTR01 | NUMBER | Value for user defined task numeric attribute 01 | |||
| NUMBER_ATTR02 | NUMBER | Value for user defined task numeric attribute 02 | |||
| NUMBER_ATTR03 | NUMBER | Value for user defined task numeric attribute 03 | |||
| NUMBER_ATTR04 | NUMBER | Value for user defined task numeric attribute 04 | |||
| NUMBER_ATTR05 | NUMBER | Value for user defined task numeric attribute 05 | |||
| NUMBER_ATTR06 | NUMBER | Value for user defined task numeric attribute 06 | |||
| NUMBER_ATTR07 | NUMBER | Value for user defined task numeric attribute 07 | |||
| NUMBER_ATTR08 | NUMBER | Value for user defined task numeric attribute 08 | |||
| NUMBER_ATTR09 | NUMBER | Value for user defined task numeric attribute 09 | |||
| NUMBER_ATTR10 | NUMBER | Value for user defined task numeric attribute 10 | |||
| TEXT_ATTR01 | VARCHAR2 | 200 | Value for user defined task free form text attribute 01 | ||
| TEXT_ATTR02 | VARCHAR2 | 200 | Value for user defined task free form text attribute 02 | ||
| TEXT_ATTR03 | VARCHAR2 | 200 | Value for user defined task free form text attribute 03 | ||
| TEXT_ATTR04 | VARCHAR2 | 200 | Value for user defined task free form text attribute 04 | ||
| TEXT_ATTR05 | VARCHAR2 | 200 | Value for user defined task free form text attribute 05 | ||
| TEXT_ATTR06 | VARCHAR2 | 200 | Value for user defined task free form text attribute 06 | ||
| TEXT_ATTR07 | VARCHAR2 | 200 | Value for user defined task free form text attribute 07 | ||
| TEXT_ATTR08 | VARCHAR2 | 200 | Value for user defined task free form text attribute 08 | ||
| TEXT_ATTR09 | VARCHAR2 | 200 | Value for user defined task free form text attribute 09 | ||
| TEXT_ATTR10 | VARCHAR2 | 200 | Value for user defined task free form text attribute 10 | ||
| TEXT_ATTR11 | VARCHAR2 | 200 | Value for user defined task free form text attribute 11 | ||
| TEXT_ATTR12 | VARCHAR2 | 200 | Value for user defined task free form text attribute 12 | ||
| TEXT_ATTR13 | VARCHAR2 | 200 | Value for user defined task free form text attribute 13 | ||
| TEXT_ATTR14 | VARCHAR2 | 200 | Value for user defined task free form text attribute 14 | ||
| TEXT_ATTR15 | VARCHAR2 | 200 | Value for user defined task free form text attribute 15 | ||
| TEXT_ATTR16 | VARCHAR2 | 200 | Value for user defined task free form text attribute 16 | ||
| TEXT_ATTR17 | VARCHAR2 | 200 | Value for user defined task free form text attribute 17 | ||
| TEXT_ATTR18 | VARCHAR2 | 200 | Value for user defined task free form text attribute 18. | ||
| TEXT_ATTR19 | VARCHAR2 | 200 | Value for user defined task free form text attribute 19. | ||
| TEXT_ATTR20 | VARCHAR2 | 200 | Value for user defined task free form text attribute 20. | ||
| LOAD_REQUEST_ID | NUMBER | 18 | Identifier of the scheduled process that populates the interface table from user uploaded data. | ||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | 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. | |
| IMPORT_STATUS | VARCHAR2 | 30 | Status of the record load from the interface table to the database. Valid values are SUBMITTED,PROCESSING,SUCCESS and ERROR. | ||
| LOAD_STATUS | VARCHAR2 | 30 | Status of the record that is transferred from the CSV file to the interface table. Valid values are ON HOLD and COMPLETE. | ||
| XFACE_FILE_PROCESS_ID | NUMBER | 18 | ID of the process that populated the interface table from a file | ||
| XFACE_LAST_PROCESS_ID | NUMBER | 18 | The request ID of the ESS job that populated DB from an interface table | ||
| XFACE_LAST_STATUS_CODE | VARCHAR2 | 20 | Interface to DB load status code. PROCESSING, SUCCESS, ERROR | ||
| XFACE_ELEMENT_ID | NUMBER | 18 | Unique ID of each interface table row, used as a FK to Messages table. | ||
| TASK_CODE01_ID | NUMBER | 18 | Column to update LOV ID values. | ||
| TASK_CODE02_ID | NUMBER | 18 | Column to update LOV ID values. | ||
| TASK_CODE03_ID | NUMBER | 18 | Column to update LOV ID values. | ||
| TASK_CODE04_ID | NUMBER | 18 | Column to update LOV ID values. | ||
| TASK_CODE05_ID | NUMBER | 18 | Column to update LOV ID values. | ||
| TASK_CODE06_ID | NUMBER | 18 | Column to update LOV ID values. | ||
| TASK_CODE07_ID | NUMBER | 18 | Column to update LOV ID values. | ||
| TASK_CODE08_ID | NUMBER | 18 | Column to update LOV ID values. | ||
| TASK_CODE09_ID | NUMBER | 18 | Column to update LOV ID values. | ||
| TASK_CODE10_ID | NUMBER | 18 | Column to update LOV ID values. | ||
| TASK_CODE11_ID | NUMBER | 18 | Column to update LOV ID values. | ||
| TASK_CODE12_ID | NUMBER | 18 | Column to update LOV ID values. | ||
| TASK_CODE13_ID | NUMBER | 18 | Column to update LOV ID values. | ||
| TASK_CODE14_ID | NUMBER | 18 | Column to update LOV ID values. | ||
| TASK_CODE15_ID | NUMBER | 18 | Column to update LOV ID values. | ||
| TASK_CODE16_ID | NUMBER | 18 | Column to update LOV ID values. | ||
| TASK_CODE17_ID | NUMBER | 18 | Column to update LOV ID values. | ||
| TASK_CODE18_ID | NUMBER | 18 | Column to update LOV ID values. | ||
| TASK_CODE19_ID | NUMBER | 18 | Column to update LOV ID values. | ||
| TASK_CODE20_ID | NUMBER | 18 | Column to update LOV ID values. | ||
| TASK_CODE21_ID | NUMBER | 18 | Column to update LOV ID values. | ||
| TASK_CODE22_ID | NUMBER | 18 | Column to update LOV ID values. | ||
| TASK_CODE23_ID | NUMBER | 18 | Column to update LOV ID values. | ||
| TASK_CODE24_ID | NUMBER | 18 | Column to update LOV ID values. | ||
| TASK_CODE25_ID | NUMBER | 18 | Column to update LOV ID values. | ||
| TASK_CODE26_ID | NUMBER | 18 | Column to update LOV ID values. | ||
| TASK_CODE27_ID | NUMBER | 18 | Column to update LOV ID values. | ||
| TASK_CODE28_ID | NUMBER | 18 | Column to update LOV ID values. | ||
| TASK_CODE29_ID | NUMBER | 18 | Column to update LOV ID values. | ||
| TASK_CODE30_ID | NUMBER | 18 | Column to update LOV ID values. | ||
| TASK_CODE31_ID | NUMBER | 18 | Column to update LOV ID values. | ||
| TASK_CODE32_ID | NUMBER | 18 | Column to update LOV ID values. | ||
| TASK_CODE33_ID | NUMBER | 18 | Column to update LOV ID values. | ||
| TASK_CODE34_ID | NUMBER | 18 | Column to update LOV ID values. | ||
| TASK_CODE35_ID | NUMBER | 18 | Column to update LOV ID values. | ||
| TASK_CODE36_ID | NUMBER | 18 | Column to update LOV ID values. | ||
| TASK_CODE37_ID | NUMBER | 18 | Column to update LOV ID values. | ||
| TASK_CODE38_ID | NUMBER | 18 | Column to update LOV ID values. | ||
| TASK_CODE39_ID | NUMBER | 18 | Column to update LOV ID values. | ||
| TASK_CODE40_ID | NUMBER | 18 | Column to update LOV ID values. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| PJT_TASK_CODES_INT_U1 | Unique | Default | INTERFACE_ID |