HR_EERCDCTL_VW3

(SQL View)
 Index Back

HR - Empl_Rcd Field Names View

This View displays a selection of all Empl_Rcd field names (Empl_Rcd 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 P.RECNAME , P.FIELDNAME , R.FIELDNAME FROM PSRECFIELDDB P , PSRECDEFN Q , PSRECFIELDDB R , PSKEYDEFN I WHERE P.RECNAME = Q.RECNAME AND P.RECNAME = R.RECNAME AND I.RECNAME = R.RECNAME AND I.FIELDNAME = P.FIELDNAME AND I.INDEXID = '_' AND Q.RECTYPE = 0 AND Q.RECNAME NOT LIKE 'UPG%' AND Q.RECNAME NOT LIKE 'AUDIT%' AND Q.RECNAME NOT LIKE '%AET%' AND NOT EXISTS ( SELECT 'x' FROM PS_HR_EERCDDEL_EXC WHERE RECNAME=P.RECNAME) AND EXISTS ( SELECT 'x' FROM PS_HR_EERCDDEL_FL1 WHERE HR_EMPLID_FLDNAME = P.FIELDNAME) AND EXISTS ( SELECT 'x' FROM PS_HR_EERCDDEL_FL2 WHERE HR_EMPLRCD_FLDNAME = R.FIELDNAME) AND ( EXISTS ( SELECT 'x' FROM PSKEYDEFN I WHERE I.RECNAME = R.RECNAME AND I.FIELDNAME = R.FIELDNAME AND I.INDEXID = '_') OR NOT EXISTS ( SELECT 'x' FROM PSKEYDEFN I , PS_HR_EERCDDEL_FL2 FL2 WHERE I.RECNAME = R.RECNAME AND I.FIELDNAME = FL2.HR_EMPLRCD_FLDNAME AND I.INDEXID = '_') )

# 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.
3 HR_EMPLRCD_FLDNAME Character(18) VARCHAR2(18) NOT NULL Employee Record Number (or "EMPL_RCD-like") Field Name