RDH_REL_ROLE_VW (SQL View)	Index Back
Rel Type view Relationship Type view to show the descriptions of the 2 Role Types

RDH_REL_ROLE_VW

(SQL View)

Rel Type view

Relationship Type view to show the descriptions of the 2 Role Types

SELECT A.REL_TYPE_ID , B.ROLE_TYPE_ID , A.DESCR , B.DESCR FROM PS_BO_REL_TYPE A , PS_BO_ROLE_TYPE B WHERE B.ROLE_TYPE_ID IN( A.ROLE_TYPE_ID_1,A.ROLE_TYPE_ID_2)

Related Language Record: RDH_REL_ROLELVW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 REL_TYPE_ID Number(12,0) DECIMAL(12) NOT NULL Relationship Type ID

2 ROLE_TYPE_ID Number(12,0) DECIMAL(12) NOT NULL Role Type ID

3 REL_TYPE_NAME Character(50) VARCHAR2(50) NOT NULL Bus Object Relationship Name

4 ROLE_TYPE_NAME Character(30) VARCHAR2(30) NOT NULL Role Type Name

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	REL_TYPE_ID	Number(12,0)	DECIMAL(12) NOT NULL	Relationship Type ID
2	ROLE_TYPE_ID	Number(12,0)	DECIMAL(12) NOT NULL	Role Type ID
3	REL_TYPE_NAME	Character(50)	VARCHAR2(50) NOT NULL	Bus Object Relationship Name
4	ROLE_TYPE_NAME	Character(30)	VARCHAR2(30) NOT NULL	Role Type Name