HR_EERCDCTL_VW4

(SQL View)
 Index Back

ERN Delete - Tables

Defines a view on the ERN Control Tables for the tables only.

SELECT SEQUENCE_NBR_6 , HR_CONTROL_REC_TYP , RECNAME , HR_EMPLID_FLDNAME , HR_EMPLRCD_FLDNAME , SQLID , MESSAGE_SET_NBR , MESSAGE_NBR , SYSTEM_DATA_FLG , LASTUPDDTTM , LASTUPDOPRID , COMMENTS FROM PS_HR_EERCDDEL_CTL WHERE HR_CONTROL_REC_TYP='1'

  • 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

    Default Value: 1

    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