PSTREESRCHRECVW

(SQL View)
Index Back

Tree Mng. View on PSPNLGRPDEFN

Used in Tree Manager to select Search Record Name for a specific Component based on a Component Name and Market

SELECT PNLGRPNAME ,MARKET ,SEARCHRECNAME FROM PSPNLGRPDEFN

# 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

Default Value: GBL

3 SEARCHRECNAME Character(15) VARCHAR2(15) NOT NULL Search Record Name