HR_EERCDCTL_VW1 (SQL View)	Index Back
HR - Record Names View This View displays a selection of all records(record type 0) from the PSRECDEFN record present in the system that are: 1. keyed by EmplID+Empl_Rcd. 2. containing ID-like fields that are not named EMPLID, EMPL_RCD such as SUPERVISOR_ID, BENEFIT_RCD_NBR. 3. containing EMPLID, EMPL_RCD in a subrecord. 4. containing EMPLID+EMPL_RCD -like fields in a subrecord. 5. containing EMPLID+EMPL_RCD in a sub-sub record. 6. containing EMPLID+EMPL_RCD like fields in a sub-sub record.

HR_EERCDCTL_VW1

(SQL View)

HR - Record Names View

This View displays a selection of all records(record type 0) from the PSRECDEFN record present in the system that are: 1. keyed by EmplID+Empl_Rcd. 2. containing ID-like fields that are not named EMPLID, EMPL_RCD such as SUPERVISOR_ID, BENEFIT_RCD_NBR. 3. containing EMPLID, EMPL_RCD in a subrecord. 4. containing EMPLID+EMPL_RCD -like fields in a subrecord. 5. containing EMPLID+EMPL_RCD in a sub-sub record. 6. containing EMPLID+EMPL_RCD like fields in a sub-sub record.

SELECT DISTINCT P.RECNAME FROM PS_HR_EERCDCTL_VW3 P

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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