EOQF_RCPNT_TBL

(SQL Table)
 Index Back

Recipient List

  • Related Language Record: EOQF_RCPNT_LNG

  • Parent Record Of EOQF_PRMPT_TBL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EOQF_RECIPIENT_ID Character(30) VARCHAR2(30) NOT NULL Recipient List ID
    2 EOQF_USER_SOURCE Character(1) VARCHAR2(1) NOT NULL Recipient Source type
    C=Application Class
    Q=Query
    R=Role
    S=SQL Definition

    Default Value: R

    3 EOQF_DESCR Character(60) VARCHAR2(60) NOT NULL Description
    4 DESCRLONG Long Character CLOB Long Description
    5 QRYNAME Character(30) VARCHAR2(30) NOT NULL Query Name

    Prompt Table: QRY_NAME_VW

    6 ROLENAME Character(30) VARCHAR2(30) NOT NULL The name of a Role in the Role Definition Table (see PSROLEDEFN).

    Prompt Table: PSROLEDEFN_VW

    7 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: EOQF_SQLID_VW

    • 8 PACKAGEROOT Character(30) VARCHAR2(30) NOT NULL Root Package ID

    Prompt Table: PSPACKAGROOT_VW

    9 QUALIFYPATH Character(127) VARCHAR2(127) NOT NULL Qualified Package/Class Path

    Prompt Table: PSPACKAGPATH_VW

    10 APPCLASSID Character(30) VARCHAR2(30) NOT NULL Application Class ID

    Prompt Table: PSPACKAGCLAS_VW

    11 APPCLASSMETHOD Character(60) VARCHAR2(60) NOT NULL Application Class Method Name
    12 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

    Prompt Table: PSRECDEFNPVW