PJB_CNTRCT_PROJ_LINKS

Details

Schema: FUSION
Object owner: PJB
Object type: TABLE
Tablespace: INTERFACE

Primary Key

Name	Columns
PJB_CNTRCT_PROJ_LINKS_INT_PK	BATCH_ID, INTERFACE_ROW_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
BATCH_ID	NUMBER		18	Yes	Batch Id is unique for a bulk import batch.
INTERFACE_ROW_ID	NUMBER		18	Yes	Unique identifier for each interface row within a batch.
EXT_SOURCE	VARCHAR2	150			Along with Ext_Key, it forms a unique key in pjb_cntrct_proj_links table.
EXT_KEY	VARCHAR2	150			Along with Ext_Source, it forms a unique key in pjb_cntrct_proj_links table.
LINE_EXT_SOURCE	VARCHAR2	150			Along with Line_Ext_Key, it forms a unique key in okc_k_lines_b table.
LINE_EXT_KEY	VARCHAR2	150			Along with Line_Ext_Source, it forms a unique key in okc_k_lines_b table.
IMPORT_STATUS_CODE	VARCHAR2	30			Gives status of a row during import. Possible values are - I(In-process), V(Valid), S(Success), W(Warning), E(Error) and X(Format error).
ACTION_CODE	VARCHAR2	30			Specifies operation for a row. Possible values are NULL, INSERT, UPDATE and DELETE.
INTERNAL_ACTION_CODE	VARCHAR2	30			Internal column and will be set to UPDATE or INSERT for rows with ACTION_CODE=NULL depending on row already exists or not.
REQUEST_ID	NUMBER		18		Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
FILE_NAME_SYSTASK_ID	NUMBER		18		Internal column, used by file import to save the individual sys task id for each input csv file.
FILE_RECORD_NUM	NUMBER		18		Internal column, used by file import to save the record number in each input csv file.
LINK_ID	NUMBER		18		Not user enterable. For Internal usage.
MAJOR_VERSION	NUMBER		18		Not user enterable. For Internal usage.
CONTRACT_ID	NUMBER		18		Not user enterable. For Internal usage.
CONTRACT_LINE_ID	NUMBER		18		Not user enterable. For Internal usage.
PROJECT_ID	NUMBER		18		Refer to pjb_cntrct_proj_links table.
PROJECT_NUMBER	VARCHAR2	25			PROJECT_NUMBER
TASK_ID	NUMBER		18		Refer to proj_element_id of pjb_cntrct_proj_links table.
TASK_NUMBER	VARCHAR2	100			TASK_NUMBER
FUNDING_AMOUNT	NUMBER				Refer to pjb_cntrct_proj_links table.
ACTIVE_FLAG	VARCHAR2	1			Refer to pjb_cntrct_proj_links table.
PERCENT_COMPLETE	NUMBER		5		Refer to pjb_cntrct_proj_links table.
BILLING_TYPE_CODE	VARCHAR2	30			Not user enterable. For Internal usage.
INTERNAL_LINKAGE_OVN	NUMBER		9		Object Version Number copied from corresponding linkages record. This is used for UPDATE cases to see if record is updated by another user during processing of bulk import and throw error appropriately.
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.
CREATION_DATE	TIMESTAMP				Who column: indicates the date and time of the creation of the row.
CREATED_BY	VARCHAR2	64			Who column: indicates the user who created the row.
LAST_UPDATE_DATE	TIMESTAMP				Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY	VARCHAR2	64			Who column: indicates the user who last updated the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.

Indexes

Index	Uniqueness	Tablespace	Columns
PJB_CNTRCT_PROJ_LINKS_INT_N3	Non Unique	Default	BATCH_ID, EXT_KEY, EXT_SOURCE
PJB_CNTRCT_PROJ_LINKS_INT_U1	Unique	Default	BATCH_ID, INTERFACE_ROW_ID
PJB_CNTRCT_PROJ_LNKS_INT_N1	Non Unique	Default	PROJECT_ID, TASK_ID
PJB_CNTRCT_PROJ_LNKS_INT_N2	Non Unique	Default	CONTRACT_ID, CONTRACT_LINE_ID