HCSC_RECIPIENT

(SQL Table)
 Index Back

Recipient Type setup

Setup table for AD Hoc notification recipient types

  • Related Language Record: HCSC_RCPNT_LANG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 HCSC_RECIPIENT_ID Character(8) VARCHAR2(8) NOT NULL Recipient ID for Adhoc Recipient types
    2 HCSC_RECIPIENT_NM Character(30) VARCHAR2(30) NOT NULL Description for Recipient ID of adhoc notification
    3 HCSC_USERLIST_SRC Character(1) VARCHAR2(1) NOT NULL Source type for user list population. It could be U: All Users R: Role Based S: SQL Definition Q: Query Based A: Application Class
    A=Application Class
    Q=Query Based
    R=Role Based
    S=SQL Definition
    U=All Users

    Default Value: U

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

    Prompt Table: PSRECDEFNPVW

    5 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

    Prompt Table: HCSC_FLDNM1_VW

    6 FIELDLABEL Character(30) VARCHAR2(30) NOT NULL Field Label
    7 HCSC_DISPLAY_LBL Character(50) VARCHAR2(50) NOT NULL Display Label

    Prompt Table: HCSC_FLDNM1_VW

    8 STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
    A=Active
    I=Inactive

    Default Value: A

    9 HCSC_EFFDT_ENABLED Character(1) VARCHAR2(1) NOT NULL Effective dated record indicator

    Y/N Table Edit

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

    Prompt Table: PSROLEDEFN_VW

    11 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: EOAW_SQLID_VW

    • 12 QRYNAME Character(30) VARCHAR2(30) NOT NULL Query Name

    Prompt Table: QRY_NAME_VW

    13 PACKAGEROOT Character(30) VARCHAR2(30) NOT NULL Root Package ID

    Prompt Table: EOAWPACKAGE_VW

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

    Prompt Table: PSPACKAGPATH_VW

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

    Prompt Table: PSPACKAGCLAS_VW

    16 APPCLASSMETHOD Character(60) VARCHAR2(60) NOT NULL Application Class Method Name
    17 DATA_TYPE_CD Character(1) VARCHAR2(1) NOT NULL Data Type Code
    N=Customer Data
    S=Sample Data
    Y=System Data
    18 OBJECTOWNERID Character(4) VARCHAR2(4) NOT NULL Object owner identifier