PJS_SUM_SCOPE_CONTRACT_GT

This table stores the contracts which come under the scope of the current request.

Details

• Schema: FUSION

• Object owner: FUSION

• Object type: TABLE

• Tablespace: Default

Columns

Name	Datatype	Length	Precision	Comments
CONTRACT_ID	NUMBER		18	CONTRACT_ID
CONTRACT_NUMBER	VARCHAR2	240		CONTRACT_NUMBER
WORKER_ID	NUMBER		18	WORKER_ID
BATCH_ID	NUMBER		18	BATCH_ID
BUSINESS_UNIT_ID	NUMBER		18	Business unit ID
EXTRACTION_STATUS	VARCHAR2	30		Indicates which type of summarization, if any, has been run
INV_EXTRACTION_STATUS	VARCHAR2	30		Indicates which type of summarization, if any, has been run
REV_EXTRACTION_STATUS	VARCHAR2	30		Indicates which type of summarization, if any, has been run
HALFWAY_FLAG	VARCHAR2	1		Internal flag
ONLINE_FLAG	VARCHAR2	1		Internal flag
ADDL_ATTR_CHAR_1	VARCHAR2	150		Oracle internal use only.
ADDL_ATTR_CHAR_2	VARCHAR2	150		Oracle internal use only.
ADDL_ATTR_CHAR_3	VARCHAR2	150		Oracle internal use only.
ADDL_ATTR_CHAR_4	VARCHAR2	150		Oracle internal use only.
ADDL_ATTR_CHAR_5	VARCHAR2	150		Oracle internal use only.
ADDL_ATTR_CHAR_6	VARCHAR2	150		Oracle internal use only.
ADDL_ATTR_CHAR_7	VARCHAR2	150		Oracle internal use only.
ADDL_ATTR_CHAR_8	VARCHAR2	150		Oracle internal use only.
ADDL_ATTR_CHAR_9	VARCHAR2	150		Oracle internal use only.
ADDL_ATTR_CHAR_10	VARCHAR2	150		Oracle internal use only.
ADDL_ATTR_NUM_1	NUMBER			Oracle internal use only.
ADDL_ATTR_NUM_2	NUMBER			Oracle internal use only.
ADDL_ATTR_NUM_3	NUMBER			Oracle internal use only.
ADDL_ATTR_NUM_4	NUMBER			Oracle internal use only.
ADDL_ATTR_NUM_5	NUMBER			Oracle internal use only.
ADDL_ATTR_NUM_6	NUMBER			Oracle internal use only.
ADDL_ATTR_NUM_7	NUMBER			Oracle internal use only.
ADDL_ATTR_NUM_8	NUMBER			Oracle internal use only.
ADDL_ATTR_NUM_9	NUMBER			Oracle internal use only.
ADDL_ATTR_NUM_10	NUMBER			Oracle internal use only.