GP_RECFLD_VW

(SQL View)
 Index Back

Fieldname prompt-Def Admin

This view will show all the keys for the records returned in PS_GP_ADM_REC_VW.

SELECT A.RECNAME , A.FIELDNAME , B.KEYPOSN FROM PSRECFIELD A , PSKEYDEFN B WHERE A.RECNAME = B.RECNAME (+) AND A.FIELDNAME = B.FIELDNAME (+) AND B.INDEXID (+) = '_'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
2 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
3 KEYPOSN Number(3,0) SMALLINT NOT NULL Key Position