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