RB_CLONE_REC_V2 (SQL View)	Index Back
Dummy Record for Cloning Dummy Record for Cloning. This record is used as placeholder for a grid/scroll area for user to specify whether a particular rowset should be copied or not.

RB_CLONE_REC_V2

(SQL View)

Dummy Record for Cloning

Dummy Record for Cloning. This record is used as placeholder for a grid/scroll area for user to specify whether a particular rowset should be copied or not.

SELECT DISTINCT A.BCNAME , A.BCITEMPARENT , B.RECNAME , A.PARENTRECNAME , A.MESSAGE_SET_NBR , A.MESSAGE_NBR , A.PROMPTED , A.BCSCROLL , A.PNLNAME , A.PAGE_SECTION_ID FROM PS_RB_CLONE_REC A , PS_RB_CLONE_FLDS B , PSRECDEFN C WHERE A.BCNAME = B.BCNAME AND A.BCSCROLL = B.BCSCROLL AND A.BCITEMPARENT = B.BCITEMPARENT AND B.INCLUDE = 'Y' AND A.BCSCROLL > 0 AND B.RECNAME = C.RECNAME AND C.RECTYPE IN (0,1)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BCNAME Character(30) VARCHAR2(30) NOT NULL Business Component Name (see PSBCDEFN).

2 BCITEMPARENT Character(30) VARCHAR2(30) NOT NULL Parent Collection Name

3 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

4 PARENTRECNAME Character(15) VARCHAR2(15) NOT NULL Parent Record Name

5 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.

6 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.

7 PROMPTED Character(1) VARCHAR2(1) NOT NULL Prompted?

8 BCSCROLL Number(3,0) SMALLINT NOT NULL Scroll level

9 PNLNAME Character(30) VARCHAR2(30) NOT NULL Page Name (see PSPNLDEFN).

10 PAGE_SECTION_ID Character(15) VARCHAR2(15) NOT NULL Section Identifier defined for the section (various types of group boxes or grouping of fields) in the configurable component.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BCNAME	Character(30)	VARCHAR2(30) NOT NULL	Business Component Name (see PSBCDEFN).
2	BCITEMPARENT	Character(30)	VARCHAR2(30) NOT NULL	Parent Collection Name
3	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN).
4	PARENTRECNAME	Character(15)	VARCHAR2(15) NOT NULL	Parent Record Name
5	MESSAGE_SET_NBR	Number(5,0)	INTEGER NOT NULL	Message Set Number. This field refers to the Message Set Number in the Message Catalog.
6	MESSAGE_NBR	Number(5,0)	INTEGER NOT NULL	Message Number. This field refers to the Message Number in the Message Catalog.
7	PROMPTED	Character(1)	VARCHAR2(1) NOT NULL	Prompted?
8	BCSCROLL	Number(3,0)	SMALLINT NOT NULL	Scroll level
9	PNLNAME	Character(30)	VARCHAR2(30) NOT NULL	Page Name (see PSPNLDEFN).
10	PAGE_SECTION_ID	Character(15)	VARCHAR2(15) NOT NULL	Section Identifier defined for the section (various types of group boxes or grouping of fields) in the configurable component.