PJF_RBS_MAPPING

Details

Schema: FUSION
Object owner: PJF
Object type: TABLE
Tablespace: FUSION_TS_TX_DATA

Primary Key

Name	Columns
PJF_RBS_MAPPING_RULES_PK	RULE_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments	Status
RULE_ID	NUMBER		18	Yes	Identifier for rule that belongs to the RBS
RBS_VERSION_ID	NUMBER		18	Yes	RBS_VERSION_ID *****
RBS_ELEMENT_ID	NUMBER		18		Identifier for storing identifier of rbs element	Active
RULE_FLAG	VARCHAR2	1			Identifier for storing the type of rule	Active
MAX_LEVEL	NUMBER		18	Yes	Identifier for storing the level depth for a rule	Active
LEVEL1	VARCHAR2	30			Identifier for rule type and rule details including level	Active
LEVEL2	VARCHAR2	30			Identifier for rule type and rule details including level	Active
LEVEL3	VARCHAR2	30			Identifier for rule type and rule details including level	Active
LEVEL4	VARCHAR2	30			Identifier for rule type and rule details including level	Active
LEVEL5	VARCHAR2	30			Identifier for rule type and rule details including level	Active
LEVEL6	VARCHAR2	30			Identifier for rule type and rule details including level	Active
LEVEL7	VARCHAR2	30			Identifier for rule type and rule details including level	Active
LEVEL8	VARCHAR2	30			Identifier for rule type and rule details including level	Active
LEVEL9	VARCHAR2	30			Identifier for rule type and rule details including level	Active
LEVEL10	VARCHAR2	30			Identifier for rule type and rule details including level	Active
LEVEL11	VARCHAR2	30			Identifier for rule type and rule details including level	Active
LEVEL12	VARCHAR2	30			Identifier for rule type and rule details including level	Active
LEVEL13	VARCHAR2	30			Identifier for rule type and rule details including level	Active
LEVEL14	VARCHAR2	30			Identifier for rule type and rule details including level	Active
LEVEL15	VARCHAR2	30			Identifier for rule type and rule details including level	Active
PERSON_RC_PRECEDENCE	NUMBER		18		Person Resource Class Precedence number	Active
EQUIPMENT_RC_PRECEDENCE	NUMBER		18		Equipment Resource Class Precedence number	Active
MATERIAL_RC_PRECEDENCE	NUMBER		18		Material Resource Class Precedence number	Active
FIN_ELEM_RC_PRECEDENCE	NUMBER		18		Financial Element Resource Class Precedence number	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
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
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
PERSON_RC_SEQ	VARCHAR2	240			PERSON_RC_SEQ *****
EQUIPMENT_RC_SEQ	VARCHAR2	240			EQUIPMENT_RC_SEQ *****
MATERIAL_RC_SEQ	VARCHAR2	240			MATERIAL_RC_SEQ *****
FIN_ELEM_RC_SEQ	VARCHAR2	240			FIN_ELEM_RC_SEQ *****

Foreign Keys

Table	Foreign Table	Foreign Key Column
PJF_RBS_MAPPING_RULES	pjf_rbs_elements	RBS_ELEMENT_ID
PJF_RBS_MAPPING_RULES	pjf_rbs_versions_b	RBS_VERSION_ID

Indexes

Index	Uniqueness	Tablespace	Columns
PJF_RBS_MAPPING_RULES_N1	Non Unique	Default	RBS_VERSION_ID
PJF_RBS_MAPPING_RULES_U1	Unique	Default	RULE_ID