BO_ROL_DESCR_VW (SQL View)	Index Back
BO Role Descr BO Role Type Id - Descrption Mapping for Person SES

BO_ROL_DESCR_VW

(SQL View)

BO Role Descr

BO Role Type Id - Descrption Mapping for Person SES

SELECT A.BO_ID ,B.ROLE_TYPE_ID ,B.DESCR FROM PS_BO_ROLE A , PS_BO_ROLE_TYPE B WHERE A.ROLE_TYPE_ID=B.ROLE_TYPE_ID AND A.ROLE_START_DT <= %CurrentDateIn AND A.ROLE_END_DT >=%CurrentDateIn

# 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 ROLE_TYPE_ID Number(12,0) DECIMAL(12) NOT NULL Role Type ID

3 ROLENAME Character(30) VARCHAR2(30) NOT NULL The name of a Role in the Role Definition Table (see PSROLEDEFN).

#	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	ROLE_TYPE_ID	Number(12,0)	DECIMAL(12) NOT NULL	Role Type ID
3	ROLENAME	Character(30)	VARCHAR2(30) NOT NULL	The name of a Role in the Role Definition Table (see PSROLEDEFN).