PJC_TXN_MASS_ADJUST

This table contains information related to the mass adjustment of project transactions. It also contains data that is used for reporting on these transactions.

Details

• Schema: FUSION

• Object owner: PJC

• Object type: TABLE

• Tablespace: TRANSACTION_TABLES

Primary Key

Name	Columns
PJC_TXN_MASS_ADJUST_PK	MASS_ADJUST_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments	Status
MASS_ADJUST_ID	NUMBER		18	Yes	The system-generated number that uniquely identifies the expenditure item	Active
ADJUSTMENT_TYPE	VARCHAR2	72		Yes	Adjustment Type Code	Active
PROJECT_ID	NUMBER		18		The project_id of the event that the expenditure item is FIFO marked by	Active
TASK_ID	NUMBER		18		The identifier of the task to which the expenditure item is charged	Active
CONTRACT_ID	NUMBER		18		Unique identifier of the contract.
FUNDING_SOURCE_ID	NUMBER		18		Unique identifier of the funding source.
WORK_TYPE_ID	NUMBER		18		Identifier for a work type assigned to the transaction.	Active
JUSTIFICATION	VARCHAR2	1000		Yes	Justification for mass adjustment.	Active
QUERY_CONDITION	BLOB				Saved query condition for mass adjustment.	Active
ADJUSTMENT_STATUS	VARCHAR2	20			Adjustment status	Active
PROCESS_ID	NUMBER		18		Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.	Active
SUBMIT_BY	VARCHAR2	64			Submit by.	Active
SUBMIT_DATE	TIMESTAMP				Date submitted.	Active
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.	Active
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.	Active
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.	Active
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of 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

Foreign Keys

Table	Foreign Table	Foreign Key Column
PJC_TXN_MASS_ADJUST	pjf_proj_elements_b	TASK_ID
PJC_TXN_MASS_ADJUST	pjf_projects_all_b	PROJECT_ID
PJC_TXN_MASS_ADJUST	pjf_work_types_b	WORK_TYPE_ID

Indexes

Index	Uniqueness	Tablespace	Columns	Status
PJC_TXN_MASS_ADJUST_U1	Unique	FUSION_TS_TX_IDX	MASS_ADJUST_ID	Active