JTF_RS_CHGD_ROLE_RELATIONS

This table stores the relations between Groups. Primary key is Group_relate_id. Ex. for relation_type is 'PARENT_GROUP' (Similar to JTF_RS_GRP_RELATIONS with a OPERATION_FLAG Column added)

Details

• Schema: FUSION

• Object owner: HZ

• Object type: TABLE

• Tablespace: APPS_TS_TX_DATA

Primary Key

Name	Columns
JTF_RS_CHGD_ROLE_RELATIONS_PK	ROLE_RELATE_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments	Status
ROLE_RELATE_ID	NUMBER		18	Yes	Role Relate Identifier.
ROLE_RESOURCE_TYPE	VARCHAR2	30			Resource Type for the corresponding Role.	Active
ROLE_RESOURCE_ID	NUMBER		18		Resource Identifier for the corresponding role.	Active
ROLE_ID	NUMBER		18		Role Identifier.	Active
DELETE_FLAG	VARCHAR2	1			Delet Flag.	Active
START_DATE_ACTIVE	DATE				Effective Start date of the role relation.	Active
END_DATE_ACTIVE	DATE				Effective end date of the role relation.	Active
OPERATION_FLAG	VARCHAR2	1			Operation Flag.	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.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.

Foreign Keys

Table	Foreign Table	Foreign Key Column
JTF_RS_CHGD_ROLE_RELATIONS	hz_parties	ROLE_RESOURCE_ID
JTF_RS_CHGD_ROLE_RELATIONS	jtf_rs_roles_b	ROLE_ID
JTF_RS_CHGD_ROLE_RELATIONS	jtf_rs_role_relations	ROLE_RELATE_ID

Indexes

Index	Uniqueness	Tablespace	Columns
JTF_RS_CHGD_ROLE_RELATIONS_PK	Unique	Default	ROLE_RELATE_ID