RSF_COMP_LVL_VW (SQL View)	Index Back
Component Levels Used to identify the Occurs Level when defining Sales Assignment Criteria.

RSF_COMP_LVL_VW

(SQL View)

Component Levels

Used to identify the Occurs Level when defining Sales Assignment Criteria.

SELECT DISTINCT %Substring(A.BCPGNAME,1,18) , A.MARKET , B.BCSCROLL FROM PSBCDEFN A , PSBCITEM B WHERE A.BCNAME = B.BCNAME

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name

2 MARKET Character(3) VARCHAR2(3) NOT NULL Market

3 OCCURSLEVEL Number(1,0) SMALLINT NOT NULL Occurs level

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PNLGRPNAME	Character(18)	VARCHAR2(18) NOT NULL	Component Name
2	MARKET	Character(3)	VARCHAR2(3) NOT NULL	Market
3	OCCURSLEVEL	Number(1,0)	SMALLINT NOT NULL	Occurs level