PJS_CONTRACT_EXTR_STATUS

This table contains a persistent list of all contracts eligible for summarization, as well as how and when they have been summarized.

Details

Schema: FUSION
Object owner: PJS
Object type: TABLE
Tablespace: FUSION_TS_TX_DATA

Columns

Name	Datatype	Length	Precision	Not-null	Comments	Status
CONTRACT_ID	NUMBER		18		Contains the Contract ID, not the Contract Number.	Active
CONTRACT_LINE_ID	NUMBER		18		Contains the Contract Line ID.
BUSINESS_UNIT_ID	NUMBER		18		Business Unit ID	Active
EXTRACTION_STATUS	VARCHAR2	30			Indicates which type of summarization, if any, has been run	Active
EXTRACTION_STATUS_COST	VARCHAR2	30			Stores extraction status of actuals cost data.
EXTRACTION_STATUS_REV	VARCHAR2	30			Stores extraction status of revenue data
EXTRACTION_STATUS_INV	VARCHAR2	30			Stores extraction status of invoice data
HALFWAY_FLAG	VARCHAR2	1			Inernal flag	Active
ONLINE_FLAG	VARCHAR2	1			Inernal flag	Active
CONTRACT_NAME	VARCHAR2	240			Contains the Contract Name	Active
PURGE_STATUS	VARCHAR2	30			Contract purge status	Active
LAST_SUM_REV_DATE	DATE				Indicates the last time summarization has been run for the revenue area.
LAST_AVAILABLE_REV_DATE	DATE				Indicates the time before which transaction data is available in Essbase.
LAST_SUM_REV_GL_PERIOD	VARCHAR2	30			Contains the latest period for which revenue data has been extracted
LAST_SUM_REV_PA_PERIOD	VARCHAR2	30			Contains the latest period for which revenue data has been extracted
LAST_SUM_INV_DATE	DATE				Indicates the last time summarization has been run for the invoice area.
LAST_AVAILABLE_INV_DATE	DATE				Indicates the time before which transaction data is available in Essbase.
LAST_SUM_INV_GL_PERIOD	VARCHAR2	30			Contains the latest period for which invoice data has been extracted
LAST_SUM_INV_PA_PERIOD	VARCHAR2	30			Contains the latest period for which invoice data has been extracted
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.	Active
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.	Active
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.	Active
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.	Active
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.	Active
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.
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.

Indexes

Index	Uniqueness	Tablespace	Columns
PJS_CONTRACT_EXTR_STATUS_N1	Non Unique	Default	CONTRACT_ID
PJS_CONTRACT_EXTR_STATUS_N2	Non Unique	Default	CONTRACT_LINE_ID