HR_EERCDCTL_VW2

(SQL View)
 Index Back

HR - EmplID Field Names View

This View displays a selection of all EmplID field names (EmplID like field names) that have edittable values prompted against the list of edittables defined in the HR_ERN_DEL_EDIT table present in the system and 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 , P.HR_EMPLID_FLDNAME 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).
2 HR_EMPLID_FLDNAME Character(18) VARCHAR2(18) NOT NULL Person ID (or "EMPLID-like") Field Name.