RC_COMP_RECDFN2 (SQL View)	Index Back
Component Occurs Levels View for finding the record names along with level for a given component interface.

RC_COMP_RECDFN2

(SQL View)

Component Occurs Levels

View for finding the record names along with level for a given component interface.

SELECT DISTINCT %Substring(A.BCPGNAME,1, 18) , B.RECNAME , 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 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

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	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN).
3	OCCURSLEVEL	Number(1,0)	SMALLINT NOT NULL	Occurs level