HRS_DA_RECNAME (SQL View)	Index Back
Dup Applicant Prompt This view collects the record names and descriptions for records that the user may use in the duplicate applicant record registry.

HRS_DA_RECNAME

(SQL View)

Dup Applicant Prompt

This view collects the record names and descriptions for records that the user may use in the duplicate applicant record registry.

SELECT DISTINCT A.RECNAME FROM PSRECDEFN A , PSRECFIELD B WHERE A.RECNAME = B.RECNAME AND B.FIELDNAME = 'APPLID' AND A.RECTYPE = 0

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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