HR_EERCDDEL_EXC (SQL Table)	Index Back
Setup Exceptions - ERN Delete This is a setup table for the user to indicate the exceptions for the records to be processed.

HR_EERCDDEL_EXC

(SQL Table)

Setup Exceptions - ERN Delete

This is a setup table for the user to indicate the exceptions for the records to be processed.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 HR_INCLUDE_EXCLUDE Character(1) VARCHAR2(1) NOT NULL Defines the exception type (include or exclude).
1=Include
2=Exclude
3=Include Child Table
Default Value: 1

3 HR_EMPLID_FLDNAME Character(18) VARCHAR2(18) NOT NULL Person ID (or "EMPLID-like") Field Name.
Prompt Table: PSRECFIELDDB

4 HR_EMPLRCD_FLDNAME Character(18) VARCHAR2(18) NOT NULL Employee Record Number (or "EMPL_RCD-like") Field Name
Prompt Table: PSRECFIELDDB

5 PARENTRECNAME Character(15) VARCHAR2(15) NOT NULL Parent Record Name
Prompt Table: PSRECDEFN

6 HR_SQL_DEL_COND Character(30) VARCHAR2(30) NOT NULL Delete condition (SQL object)
Prompt Table: HR_EERCDSQL_VW

7 HR_SQL_DEL_RCD Character(30) VARCHAR2(30) NOT NULL Record number (SQL object)
Prompt Table: HR_EERCDSQL_VW

8 HR_SQL_DEL_WHERE Character(30) VARCHAR2(30) NOT NULL Addition where condition used for the ERN Delete process.
Prompt Table: HR_EERCDSQL_VW

9 SYSTEM_DATA_FLG Character(1) VARCHAR2(1) NOT NULL This Y/ N field is used to identify which rows in a table are considered SYSTEM DATA.
Default Value: N

10 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

11 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN). Prompt Table: PSRECDEFN
2	HR_INCLUDE_EXCLUDE	Character(1)	VARCHAR2(1) NOT NULL	Defines the exception type (include or exclude). 1=Include 2=Exclude 3=Include Child Table Default Value: 1
3	HR_EMPLID_FLDNAME	Character(18)	VARCHAR2(18) NOT NULL	Person ID (or "EMPLID-like") Field Name. Prompt Table: PSRECFIELDDB
4	HR_EMPLRCD_FLDNAME	Character(18)	VARCHAR2(18) NOT NULL	Employee Record Number (or "EMPL_RCD-like") Field Name Prompt Table: PSRECFIELDDB
5	PARENTRECNAME	Character(15)	VARCHAR2(15) NOT NULL	Parent Record Name Prompt Table: PSRECDEFN
6	HR_SQL_DEL_COND	Character(30)	VARCHAR2(30) NOT NULL	Delete condition (SQL object) Prompt Table: HR_EERCDSQL_VW
7	HR_SQL_DEL_RCD	Character(30)	VARCHAR2(30) NOT NULL	Record number (SQL object) Prompt Table: HR_EERCDSQL_VW
8	HR_SQL_DEL_WHERE	Character(30)	VARCHAR2(30) NOT NULL	Addition where condition used for the ERN Delete process. Prompt Table: HR_EERCDSQL_VW
9	SYSTEM_DATA_FLG	Character(1)	VARCHAR2(1) NOT NULL	This Y/ N field is used to identify which rows in a table are considered SYSTEM DATA. Default Value: N
10	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
11	LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.