PJS_SUM_LINKAGE_B
This table contains non-persistent project contract linkage data during bulk summarization.
Details
-
Schema: FUSION
-
Object owner: PJS
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Columns
| Name | Datatype | Precision | Comments |
|---|---|---|---|
| WORKER_ID | NUMBER | 18 | A WORKER_ID is unique for each instance of summarization and is used to identify the data for that intance. |
| PROJECT_ID | NUMBER | 18 | Contains the PROJECT_ID, not the Project Number (SEGMENT1) |
| PROJECT_ELEMENT_ID | NUMBER | 18 | The PROJECT_ELEMENT_ID can be either the TASK_ID or the structure level ELEMENT_ID |
| CLIN_ELEMENT_ID | NUMBER | 18 | Contract linkage ID |
| CONTRACT_ID | NUMBER | 18 | Contains the Contract ID, not the Contract Number. |
| CONTRACT_LINE_ID | NUMBER | 18 | Contains the Contract Line ID. |