HR_EERCDDEL_CTL (SQL Table)	Index Back
Setup Control Tbl - ERN Delete This is a setup table for the user to indicate the records to look into for the presence of data during the ERN Delete Process. If data is found in a table which is contained in this control setup table, then the delete process will record this conflict triggered in.

HR_EERCDDEL_CTL

(SQL Table)

Setup Control Tbl - ERN Delete

This is a setup table for the user to indicate the records to look into for the presence of data during the ERN Delete Process. If data is found in a table which is contained in this control setup table, then the delete process will record this conflict triggered in.

Related Language Record: HR_EERCDCTL_LNG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SEQUENCE_NBR_6 Number(6,0) INTEGER NOT NULL Sequence

2 HR_CONTROL_REC_TYP Character(1) VARCHAR2(1) NOT NULL Defines the level of control provided for the ERN Delete process, either on a Table or using a SQL object.
1=Table
2=SQL

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

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

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

6 SQLID Character(30) VARCHAR2(30) NOT NULL SQL Object Identifier. This column has different meanings depending upon value of SQLTYPE
SQLTYPE = 0: SQL object name
SQLTYPE = 1: Application Engine Step Identifier
SQLTYPE = 2: RECNAME
SQLTYPE = 6: Application Engine XSLT (XML definition)
Prompt Table: HR_EERCDSQL_VW

7 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.
Prompt Table: MESSAGE_SET_VW

8 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.
Prompt Table: PSMSGCATDEFN

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.

12 COMMENTS Long Character CLOB Comment

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SEQUENCE_NBR_6	Number(6,0)	INTEGER NOT NULL	Sequence
2	HR_CONTROL_REC_TYP	Character(1)	VARCHAR2(1) NOT NULL	Defines the level of control provided for the ERN Delete process, either on a Table or using a SQL object. 1=Table 2=SQL
3	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN). Prompt Table: HR_EERCDCTL_VW1
4	HR_EMPLID_FLDNAME	Character(18)	VARCHAR2(18) NOT NULL	Person ID (or "EMPLID-like") Field Name. Prompt Table: HR_EERCDCTL_VW2
5	HR_EMPLRCD_FLDNAME	Character(18)	VARCHAR2(18) NOT NULL	Employee Record Number (or "EMPL_RCD-like") Field Name Prompt Table: HR_EERCDCTL_VW3
6	SQLID	Character(30)	VARCHAR2(30) NOT NULL	SQL Object Identifier. This column has different meanings depending upon value of SQLTYPE SQLTYPE = 0: SQL object name SQLTYPE = 1: Application Engine Step Identifier SQLTYPE = 2: RECNAME SQLTYPE = 6: Application Engine XSLT (XML definition) Prompt Table: HR_EERCDSQL_VW
7	MESSAGE_SET_NBR	Number(5,0)	INTEGER NOT NULL	Message Set Number. This field refers to the Message Set Number in the Message Catalog. Prompt Table: MESSAGE_SET_VW
8	MESSAGE_NBR	Number(5,0)	INTEGER NOT NULL	Message Number. This field refers to the Message Number in the Message Catalog. Prompt Table: PSMSGCATDEFN
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.
12	COMMENTS	Long Character	CLOB	Comment