RC_ROLE_VW2 (SQL View)	Index Back
Role Company Contact View This view is used to return role when using business object search. This view returns consumer role.

RC_ROLE_VW2

(SQL View)

Role Company Contact View

This view is used to return role when using business object search. This view returns consumer role.

SELECT A.BO_ID , %NumToChar(A.ROLE_TYPE_ID) , B.XLATLONGNAME , B.XLATSHORTNAME FROM PS_BO_ROLE A , PSXLATITEM B WHERE A.ROLE_TYPE_ID = 9 AND B.FIELDNAME = 'HIGHER_ED_ROLE' AND B.FIELDVALUE = %NumToChar(A.ROLE_TYPE_ID) AND B.EFF_STATUS = 'A' AND B.EFFDT = ( SELECT MAX(C.EFFDT) FROM PSXLATITEM C WHERE C.FIELDNAME = B.FIELDNAME AND C.FIELDVALUE = B.FIELDVALUE AND C.EFFDT <= %CurrentDateIn)

Related Language Record: RC_ROLE_LVW2

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BO_ID Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID

2 HIGHER_ED_ROLE Character(12) VARCHAR2(12) NOT NULL This field is used to return the role description to BO search results grid.
4=Worker
8=Contact
9=Consumer

3 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name

4 XLATSHORTNAME Character(10) VARCHAR2(10) NOT NULL Translate Value Short Name

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BO_ID	Signed Number(32,0)	DECIMAL(31) NOT NULL	Business Object ID
2	HIGHER_ED_ROLE	Character(12)	VARCHAR2(12) NOT NULL	This field is used to return the role description to BO search results grid. 4=Worker 8=Contact 9=Consumer
3	XLATLONGNAME	Character(30)	VARCHAR2(30) NOT NULL	Translate Long Name
4	XLATSHORTNAME	Character(10)	VARCHAR2(10) NOT NULL	Translate Value Short Name