GP_PIN_MAP_SRCH

(SQL View)
Index Back

Element Field Rel. Search Rec

Search record for the Element.

SELECT A.RECNAME, B.RECDESCR FROM PS_GP_PIN_FLD_MAP1 A, PSRECDEFN B WHERE A.RECNAME=B.RECNAME

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

Prompt Table: GP_MAP_RECNM_VW

2 RECDESCR Character(30) VARCHAR2(30) NOT NULL Record Description