HR_EERCDDEL_VW (SQL View)	Index Back
ERN Results - Deletions ERN Delete Results Table. This table consists of all records that have been processed and includes the number of rows deleted in each record as part of ERN Delete process.

HR_EERCDDEL_VW

(SQL View)

ERN Results - Deletions

ERN Delete Results Table. This table consists of all records that have been processed and includes the number of rows deleted in each record as part of ERN Delete process.

SELECT PROCESS_INSTANCE , EMPLID , EMPL_RCD , RECNAME , HR_EMPLID_FLDNAME , HR_EMPLRCD_FLDNAME , SUM(TOTAL_ROW_COUNT) FROM %Table(HR_EERCDDEL_LST) GROUP BY PROCESS_INSTANCE , EMPLID , EMPL_RCD , RECNAME , HR_EMPLID_FLDNAME , HR_EMPLRCD_FLDNAME

Parent record: HR_EERCDDEL_RES

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

3 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr

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

5 HR_EMPLID_FLDNAME Character(18) VARCHAR2(18) NOT NULL Person ID (or "EMPLID-like") Field Name.

6 HR_EMPLRCD_FLDNAME Character(18) VARCHAR2(18) NOT NULL Employee Record Number (or "EMPL_RCD-like") Field Name

7 TOTAL_ROW_COUNT Number(8,0) INTEGER NOT NULL Total Row Count

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
3	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
4	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN).
5	HR_EMPLID_FLDNAME	Character(18)	VARCHAR2(18) NOT NULL	Person ID (or "EMPLID-like") Field Name.
6	HR_EMPLRCD_FLDNAME	Character(18)	VARCHAR2(18) NOT NULL	Employee Record Number (or "EMPL_RCD-like") Field Name
7	TOTAL_ROW_COUNT	Number(8,0)	INTEGER NOT NULL	Total Row Count