HRCD_CNT_TYP_VW

(SQL View)
 Index Back

Co.Dir.-Addtl Cntct Types

Used to populate the drop down that the users see in the Company Directory.

SELECT A.HRCD_CNTCT_TYPE %Concat '_' %Concat %NumToChar(A.SEQ_NO) , A.HRCD_CNTCT_LBL , A.HRCD_CNTCT_TYPE , A.SEQ_NO , A.HRCD_CNTCT_FMT FROM PS_HRCD_SETUP_CNTC A WHERE A.HRCD_SELECT_FLG = 'Y'

  • Related Language Record: HRCD_CNT_TP_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 HRCD_CNTCT_TYPE_SQ Character(10) VARCHAR2(10) NOT NULL This field contains the Contact Type that will be displayed in the Company Directory to the end user via a derived record.
    2 DESCR20 Character(20) VARCHAR2(20) NOT NULL Description
    3 HRCD_CNTCT_TYPE Character(4) VARCHAR2(4) NOT NULL This field contains the Contact Type that will be displayed in the Company Directory.
    EMOT=Other Email
    EMPE=Personal Email
    IMGT=Instant Msg GTALK
    IMMS=Instant Msg MSN
    IMXP=Instant Msg XMPP
    IMYH=Instant Msg YAHOO
    PHHM=Home Phone
    PHHO=Home Office Phone
    PHMO=Mobile Phone
    PHOT=Other Phone
    USER=Other
    ZZZZ=Admin-Defined
    4 SEQ_NO Number(2,0) SMALLINT NOT NULL Sequence Number
    5 HRCD_CNTCT_FMT Character(1) VARCHAR2(1) NOT NULL This field contains the value format for Contact Type used in the Company Directory Setup.
    E=Email
    I=Instant Message
    T=Text
    Z=Text or Email