VC_VALREC_VW (SQL View)	Index Back
Record Name Prompt View This view is used by the Payout Formula Defn table as a prompt for the RECNAME field to limit the record choices being used in the payout formulas.

VC_VALREC_VW

(SQL View)

Record Name Prompt View

This view is used by the Payout Formula Defn table as a prompt for the RECNAME field to limit the record choices being used in the payout formulas.

SELECT A.RECNAME FROM PSRECDEFN A WHERE A.RECNAME = 'EMPLOYMENT' OR A.RECNAME = 'SAL_GRADE_TBL' OR A.RECNAME = 'JOB' OR A.RECNAME = 'PERS_DATA_EFFDT'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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