PTPRCSRUNFLD_VW

(SQL View)
Index Back

SELECT DISTINCT B.pnlgrpname , B.pnlname , B.recordname , A.fieldname FROM PSRECFIELD A , PS_PTPRCSRUNREC_VW B WHERE A.recname = B.recordname

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name
2 PNLNAME Character(30) VARCHAR2(30) NOT NULL Page Name (see PSPNLDEFN).
3 RECORDNAME Character(15) VARCHAR2(15) NOT NULL Record Name
4 PTPRCSRUNCNTLFLD Character(18) VARCHAR2(18) NOT NULL Run Control Field

Prompt Table: PTPRCSRUNFLD_VW