EMAIL_ADDR_CV

(SQL View)
Index Back

Email Addresses Clairvia

Clone of EMAIL ADDRESSES record for Clairvia Fullsync message

SELECT EML.EMPLID , EML.E_ADDR_TYPE , EML.EMAIL_ADDR , EML.PREF_EMAIL_FLAG FROM PS_EMAIL_ADDRESSES EML , PS_PER_ORG_ASG_INT ASG WHERE ASG.EMPLID = EML.EMPLID AND ASG.INT_APP_TYPE = 'SCH' AND ASG.INTEGR_PROD_CD = 'CV' AND ASG.ENROLLED_FLAG = 'Y'

  • Parent record: PERSON
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Default Value: NEW

    Prompt Table: PERSON_NAME

    2 E_ADDR_TYPE Character(4) VARCHAR2(4) NOT NULL Email Type
    BUSN=Business
    CAMP=Campus
    DORM=Dormitory
    HOME=Home
    OTHR=Other
    3 EMAIL_ADDR Character(70) VARCHAR2(70) NOT NULL Email Address
    4 PREF_EMAIL_FLAG Character(1) VARCHAR2(1) NOT NULL Preferred
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N