PJS_SUM_LINKAGE_GT

This global temporary table contains non-persistent project contract linkage data during online summarization.

Details

Name
WORKER_IDNUMBER18A WORKER_ID is unique for each instance of summarization and is used to identify the data for that intance. PROJECT_IDNUMBER18Contains the PROJECT_ID, not the Project Number (SEGMENT1) PROJECT_ELEMENT_IDNUMBER18The PROJECT_ELEMENT_ID can be either the TASK_ID or the structure level ELEMENT_ID CLIN_ELEMENT_IDNUMBER18Contract linkage ID CONTRACT_IDNUMBER18Contains the Contract ID, not the Contract Number. CONTRACT_LINE_IDNUMBER18Contains the Contract Line ID.

Name

WORKER_IDNUMBER18A WORKER_ID is unique for each instance of summarization and is used to identify the data for that intance.

PROJECT_IDNUMBER18Contains the PROJECT_ID, not the Project Number (SEGMENT1)

PROJECT_ELEMENT_IDNUMBER18The PROJECT_ELEMENT_ID can be either the TASK_ID or the structure level ELEMENT_ID

CLIN_ELEMENT_IDNUMBER18Contract linkage ID

CONTRACT_IDNUMBER18Contains the Contract ID, not the Contract Number.

CONTRACT_LINE_IDNUMBER18Contains the Contract Line ID.