PJS_CN_BASE_CON

This table contains persistent contract data that is aggregated by period and has relevent resource attributes assigned.

Details

• Schema: FUSION

• Object owner: PJS

• Object type: TABLE

• Tablespace: TRANSACTION_TABLES

Columns

Name	Datatype	Length	Precision	Not-null	Comments	Status
BUSINESS_UNIT_ID	NUMBER		18	Yes	Business Unit ID	Active
CONTRACT_ID	NUMBER		18	Yes	Contains the Contract ID, not the Contract Number.	Active
CONTRACT_LINE_ID	NUMBER		18	Yes	Contains the Contract Line ID.	Active
BILLING_TYPE_CODE	VARCHAR2	30		Yes	Billing type code	Active
CONTRACT_PROJECT_LINKAGE_ID	NUMBER		18		Contains the unique ID for a link between a project task (or project) and a contract line (or contract).	Active
LINKED_PROJECT_ID	NUMBER		18		Project ID linked to the contract line or contract	Active
LINKED_TASK_ID	NUMBER		18		Task ID	Active
TRANSACTION_PROJECT_ID	NUMBER		18		Project ID linked to the contract line or contract	Active
TRANSACTION_TASK_ID	NUMBER		18		Task ID	Active
TXN_ACCUM_HEADER_ID	NUMBER		18		Each TXN_ACCUM_HEADER_ID corresponds to a unique combination of resource attributes and is used for RBS mapping	Active
CALENDAR_TYPE	VARCHAR2	1			Indicates whether PA or GL calendar	Active
PERIOD_NAME	VARCHAR2	30			Period name	Active
START_DATE	DATE				Period start date
END_DATE	DATE				Period end date
CURRENCY_TYPE_ID	NUMBER		18		Bitmap indicating various types of currency	Active
CURRENCY_CODE	VARCHAR2	15			Currency code	Active
CC_REVENUE	NUMBER				Contract revenue	Active
PFC_REVENUE	NUMBER				Project functional revenue	Active
RC_REVENUE	NUMBER				Revenue currency revenue	Active
PC_REVENUE	NUMBER				Project revenue	Active
TC_REVENUE	NUMBER				Transaction revenue	Active
TC_PC_REVENUE	NUMBER				Stores the amount in PC for T lines.
TC_PFC_REVENUE	NUMBER				Stores the amount in PFC for T lines.
CC_BILLED	NUMBER				Billed invoice	Active
PFC_BILLED	NUMBER				Project functional billed invoice	Active
IC_BILLED	NUMBER				Billed invoice	Active
PC_BILLED	NUMBER				Project billed invoice	Active
TC_BILLED	NUMBER				Billed invoice	Active
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.	Active
AWARD_PERIOD_ID	NUMBER		18		Identifier for the award budget period. The award budget period is defined separately from the GL period.

Indexes

Index	Uniqueness	Tablespace	Columns
PJS_CN_BASE_CON_N1	Non Unique	FUSION_TS_TX_DATA	CONTRACT_ID, CONTRACT_LINE_ID, PERIOD_NAME
PJS_CN_BASE_CON_N2	Non Unique	Default	LINKED_PROJECT_ID