HCSC_RCPNT_LOOK

(SQL Table)
 Index Back

Prompt Table Setup Recipient

Prompt Table setup for Ad hoc notification Recipient setup component

  • Related Language Record: HCSC_RCP_LK_LNG

    • # 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 KEYVALUE Character(30) VARCHAR2(30) NOT NULL Key Value

    Prompt Table: HCSC_FLDNM1_VW

    3 FIELDLABEL Character(30) VARCHAR2(30) NOT NULL Field Label
    4 RECNAME1 Character(15) VARCHAR2(15) NOT NULL Record Name 1

    Prompt Table: PSRECDEFNPVW

    5 HCSC_DISPLAY_LBL Character(50) VARCHAR2(50) NOT NULL Display Label

    Prompt Table: HCSC_FLDNM_VW

    6 HCSC_PROMPT_IND Character(1) VARCHAR2(1) NOT NULL Prompt Indicator

    Y/N Table Edit

    Default Value: N

    7 DATA_TYPE_CD Character(1) VARCHAR2(1) NOT NULL Data Type Code
    N=Customer Data
    S=Sample Data
    Y=System Data