PJS_BASE_CUSTOM

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

Details

• Schema: FUSION

• Object owner: PJS

• Object type: TABLE

• Tablespace: FUSION_TS_TX_DATA

Columns

Name	Datatype	Length	Precision	Not-null	Comments	Status
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
PROJECT_ID	NUMBER		18		Contains the PROJECT_ID, not the Project Number (SEGMENT1)	Active
BUSINESS_UNIT_ID	NUMBER		18		Business Unit ID	Active
TASK_ID	NUMBER		18		Task ID	Active
RESOURCE_CLASS_ID	NUMBER		18		Resource attribute used to identify TXN_ACCUM_HEADER_ID
CALENDAR_ID	NUMBER		18		Time dimension calendar ID	Active
CALENDAR_TYPE	VARCHAR2	1			Indicates whether PA or GL calendar	Active
PERIOD_NAME	VARCHAR2	30			Period name	Active
CURRENCY_TYPE	VARCHAR2	1			Currency type	Active
CURRENCY_CODE	VARCHAR2	15			Currency code	Active
CUSTOM1	NUMBER				Placeholder column used to store measures extracted with the custom PL/SQL API.	Active
CUSTOM2	NUMBER				Placeholder column used to store measures extracted with the custom PL/SQL API.	Active
CUSTOM3	NUMBER				Placeholder column used to store measures extracted with the custom PL/SQL API.	Active
CUSTOM4	NUMBER				Placeholder column used to store measures extracted with the custom PL/SQL API.	Active
CUSTOM5	NUMBER				Placeholder column used to store measures extracted with the custom PL/SQL API.	Active
CUSTOM6	NUMBER				Placeholder column used to store measures extracted with the custom PL/SQL API.	Active
CUSTOM7	NUMBER				Placeholder column used to store measures extracted with the custom PL/SQL API.	Active
CUSTOM8	NUMBER				Placeholder column used to store measures extracted with the custom PL/SQL API.	Active
CUSTOM9	NUMBER				Placeholder column used to store measures extracted with the custom PL/SQL API.	Active
CUSTOM10	NUMBER				Placeholder column used to store measures extracted with the custom PL/SQL API.	Active
CUSTOM11	NUMBER				Placeholder column used to store measures extracted with the custom PL/SQL API.	Active
CUSTOM12	NUMBER				Placeholder column used to store measures extracted with the custom PL/SQL API.	Active
CUSTOM13	NUMBER				Placeholder column used to store measures extracted with the custom PL/SQL API.	Active
CUSTOM14	NUMBER				Placeholder column used to store measures extracted with the custom PL/SQL API.	Active
CUSTOM15	NUMBER				Placeholder column used to store measures extracted with the custom PL/SQL API.	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