PJF_BUSINESS_OBJECT_MAPPING

This table contains mapping of SAS Roles, actions, Spectra business objects, and Project Roles.

Details

• Schema: FUSION

• Object owner: PJF

• Object type: TABLE

• Tablespace: pjf_business_object_mapping

Primary Key

Name	Columns
PJF_BUSINESS_OBJECT_MAPPING_PK	OBJECT_MAPPING_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
OBJECT_MAPPING_ID	NUMBER		18	Yes	Unique identifier of the business object mapping.
BOSS_BUSINESS_OBJECT	VARCHAR2	255		Yes	Name of the spectra business object.
ALLOWED_ACTION_CODE	VARCHAR2	80		Yes	Action defined in SAS policy for the business object. For example, an action can be READ, CREATE, UPDATE, DELETE, or a custom action.
ROLE_CODE	VARCHAR2	64		Yes	The role code of the SAS policy.
CONTEXT_TYPE	VARCHAR2	30		Yes	Source of context value. For example, the value 'PROJECT_ROLE' indicates the SAS role captured in PROJECT_ROLE is mapped to a project role.
CONTEXT_VALUE1	VARCHAR2	30		Yes	Stores the context value depending on the context type. For example, the value will be project role identifier when the CONTEXT_TYPE is 'PROJECT_ROLE'.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.
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.
REQUEST_ID	NUMBER		18		Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
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.

Indexes

Index	Uniqueness	Tablespace	Columns
PJF_BUSINESS_OBJECT_MAPPING_U1	Unique	PJF_BUSINESS_OBJECT_MAPPING_U1	OBJECT_MAPPING_ID
PJF_BUSINESS_OBJECT_MAPPING_U2	Unique	PJF_BUSINESS_OBJECT_MAPPING_U2	BOSS_BUSINESS_OBJECT, CONTEXT_TYPE, CONTEXT_VALUE1, ALLOWED_ACTION_CODE