PJC_EXPEND_ITEM_ADJ_ACTS

PA_EXPEND_ITEM_ADJ_ACTIVITIES stores audit records of actions chosen by users in any of the Oracle Projects expenditure adjustment windows that may cause adjustments to the cost, revenue, and/or invoice amounts of an expenditure item. . .

Details

• Schema: FUSION

• Object owner: PJC

• Object type: TABLE

• Tablespace: FUSION_TS_TX_DATA

Primary Key

Name	Columns
PJC_EXPEND_ITEM_ADJ_ACTS_PK	EXPENDITURE_ITEM_ID, ACTIVITY_DATE

Columns

Name	Datatype	Length	Precision	Not-null	Comments	Status
EXPENDITURE_ITEM_ID	NUMBER		18	Yes	The identifier of the expenditure item for which the adjustment was made
ACTIVITY_DATE	TIMESTAMP			Yes	The date and time in which the adjustment activity was performed	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
MODULE_CODE	VARCHAR2	30		Yes	The module in which the adjustment activity was performed	Active
ADJUSTMENT_JUSTIFICATION	VARCHAR2	1000			This column stores user entered justification for the adjustment .in adjustment approval work flow.
DESCRIPTION	VARCHAR2	250			Description of the expenditure item adjustment activity	Active
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.	Active
REQUEST_ID	NUMBER		18		Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.	Active
JOB_DEFINITION_NAME	VARCHAR2	100			Enterprise Service Scheduler: indicates the name of the job that created or last updated the row.
JOB_DEFINITION_PACKAGE	VARCHAR2	900			Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row.
REJECTION_CODE	VARCHAR2	30			The reason why the expenditure item was rejected during mass adjustment	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
ADJUSTMENT_TYPE	VARCHAR2	30			ADJUSTMENT_TYPE *****
STATUS	VARCHAR2	2			STATUS *****
PROJECT_ID	NUMBER		18		PROJECT_ID *****
TASK_ID	NUMBER		18		TASK_ID *****
WORK_TYPE_ID	NUMBER		18		WORK_TYPE_ID *****
BILLABLE_FLAG	VARCHAR2	1			BILLABLE_FLAG *****
CAPITALIZABLE_FLAG	VARCHAR2	1			CAPITALIZABLE_FLAG *****
ACCT_CURR_DATE	DATE				ACCT_CURR_DATE *****
ACCT_CURR_TYPE	VARCHAR2	30			ACCT_CURR_TYPE *****
ACCT_CURR_RATE	NUMBER				ACCT_CURR_RATE *****
PROJFUNC_CURR_DATE	DATE				PROJFUNC_CURR_DATE *****
PROJFUNC_CURR_TYPE	VARCHAR2	30			PROJFUNC_CURR_TYPE *****
PROJFUNC_CURR_RATE	NUMBER				PROJFUNC_CURR_RATE *****
PROJ_TP_CURR_DATE	DATE				PROJ_TP_CURR_DATE *****
PROJ_TP_CURR_TYPE	VARCHAR2	30			PROJ_TP_CURR_TYPE *****
PROJ_TP_CURR_RATE	NUMBER				PROJ_TP_CURR_RATE *****
EXCEPTION_ACTIVITY_CODE	VARCHAR2	30			The action that may cause a cost, revenue, or invoice adjustment for the expenditure item	Active
QUANTITY	NUMBER				QUANTITY *****
BILL_HOLD_FLAG	VARCHAR2	1			BILL_HOLD_FLAG *****
REVENUE_HOLD_FLAG	VARCHAR2	1			REVENUE_HOLD_FLAG *****

Foreign Keys

Table	Foreign Table	Foreign Key Column
PJC_EXPEND_ITEM_ADJ_ACTS	pjc_exp_items_all	EXPENDITURE_ITEM_ID

Indexes

Index	Uniqueness	Tablespace	Columns
PJC_EXPEND_ITEM_ADJ_ACTS_N1	Non Unique	Default	STATUS, EXPENDITURE_ITEM_ID
PJC_EXPEND_ITEM_ADJ_ACTS_N2	Non Unique	FUSION_TS_TX_DATA	REQUEST_ID
PJC_EXPEND_ITEM_ADJ_ACTS_U1	Unique	Default	EXPENDITURE_ITEM_ID, ACTIVITY_DATE