RSF_BO_ROLTY_LN (SQL View)	Index Back
RSF-BO ROLE TYPE VIEW FOR CONSUMERS AND COMPANY

RSF_BO_ROLTY_LN

(SQL View)

RSF-BO ROLE TYPE VIEW

FOR CONSUMERS AND COMPANY

SELECT A.LANGUAGE_CD , A.ROLE_TYPE_ID , A.DESCRSHORT FROM PS_BO_ROLE_TYP_LNG A , PS_RSF_BO_ROLTY_VW B WHERE A.ROLE_TYPE_ID = B.ROLE_TYPE_ID

Related Language Record for RSF_BO_ROLTY_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
2	ROLE_TYPE_ID	Number(12,0)	DECIMAL(12) NOT NULL	Role Type ID
3	ROLE_TYPE_NAME	Character(30)	VARCHAR2(30) NOT NULL	Role Type Name