FT_PER_EMAIL

(SQL Table)
 Index Back

Personal Data - Email Address

Fusion Table - PER_EMAIL_ADDRESSES

  • 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

    2 E_ADDR_TYPE Character(4) VARCHAR2(4) NOT NULL Email Address Type. Note: Dorm long name has been updated as Dormitory as part of PI26 updates. And, the owner id of the field is updated to CC from HR.
    BUSN=Business
    CAMP=Campus
    DORM=Dormitory
    HOME=Home
    OTHR=Other
    3 FT_EMAIL_ADDR_GUID Character(36) VARCHAR2(36) NOT NULL EMAIL_ADDRESS_ID GUID
    4 FT_PERSON_ID_GUID Character(36) VARCHAR2(36) NOT NULL Person GUID
    5 FT_BUS_GROUP_ID Number(18,0) DECIMAL(18) NOT NULL Business Group ID
    6 FT_DATE_FROM Date(10) DATE Date From
    7 FT_DATE_TO Date(10) DATE Date To
    8 FT_EMAIL_TYPE Character(30) VARCHAR2(30) NOT NULL Fusion field - EMAIL_TYPE
    9 FT_EMAIL_ADDRESS Character(100) VARCHAR2(100) NOT NULL Email Address
    10 FT_PRIMARY_FLG Character(1) VARCHAR2(1) NOT NULL Primary Flag
    11 FT_PRIMARY_FLAG Character(30) VARCHAR2(30) NOT NULL Primary Supervisor Flag
    12 FT_ATTR_CATEGORY Character(30) VARCHAR2(30) NOT NULL Attribute Category
    13 FT_ATTRIBUTE1 Character(1) VARCHAR2(1) NOT NULL Attribute
    14 FT_ATTRIBUTE2 Character(1) VARCHAR2(1) NOT NULL Attribute
    15 FT_ATTRIBUTE3 Character(1) VARCHAR2(1) NOT NULL Attribute
    16 FT_ATTRIBUTE4 Character(1) VARCHAR2(1) NOT NULL Attribute
    17 FT_ATTRIBUTE5 Character(1) VARCHAR2(1) NOT NULL Attribute
    18 FT_ATTRIBUTE6 Character(1) VARCHAR2(1) NOT NULL Attribute
    19 FT_ATTRIBUTE7 Character(1) VARCHAR2(1) NOT NULL Attribute
    20 FT_ATTRIBUTE8 Character(1) VARCHAR2(1) NOT NULL Attribute
    21 FT_ATTRIBUTE9 Character(1) VARCHAR2(1) NOT NULL Attribute
    22 FT_ATTRIBUTE10 Character(1) VARCHAR2(1) NOT NULL Attribute
    23 FT_ATTRIBUTE11 Character(1) VARCHAR2(1) NOT NULL Attribute
    24 FT_ATTRIBUTE12 Character(1) VARCHAR2(1) NOT NULL Attribute
    25 FT_ATTRIBUTE13 Character(1) VARCHAR2(1) NOT NULL Attribute
    26 FT_ATTRIBUTE14 Character(1) VARCHAR2(1) NOT NULL Attribute
    27 FT_ATTRIBUTE15 Character(1) VARCHAR2(1) NOT NULL Attribute
    28 FT_ATTRIBUTE16 Character(1) VARCHAR2(1) NOT NULL Attribute
    29 FT_ATTRIBUTE17 Character(1) VARCHAR2(1) NOT NULL Attribute
    30 FT_ATTRIBUTE18 Character(1) VARCHAR2(1) NOT NULL Attribute
    31 FT_ATTRIBUTE19 Character(1) VARCHAR2(1) NOT NULL Attribute
    32 FT_ATTRIBUTE20 Character(1) VARCHAR2(1) NOT NULL Attribute
    33 FT_ATTRIBUTE21 Character(1) VARCHAR2(1) NOT NULL Attribute
    34 FT_ATTRIBUTE22 Character(1) VARCHAR2(1) NOT NULL Attribute
    35 FT_ATTRIBUTE23 Character(1) VARCHAR2(1) NOT NULL Attribute
    36 FT_ATTRIBUTE24 Character(1) VARCHAR2(1) NOT NULL Attribute
    37 FT_ATTRIBUTE25 Character(1) VARCHAR2(1) NOT NULL Attribute
    38 FT_ATTRIBUTE26 Character(1) VARCHAR2(1) NOT NULL Attribute
    39 FT_ATTRIBUTE27 Character(1) VARCHAR2(1) NOT NULL Attribute
    40 FT_ATTRIBUTE28 Character(1) VARCHAR2(1) NOT NULL Attribute
    41 FT_ATTRIBUTE29 Character(1) VARCHAR2(1) NOT NULL Attribute
    42 FT_ATTRIBUTE30 Character(1) VARCHAR2(1) NOT NULL Attribute
    43 FT_LANGUAGE Character(4) VARCHAR2(4) NOT NULL Language
    44 FT_PROC_MARKER Character(36) VARCHAR2(36) NOT NULL Process marker field
    45 FT_ERROR_FLAG Character(1) VARCHAR2(1) NOT NULL Error Flag
    N=No
    Y=Yes

    Default Value: N

    46 FT_BYPASS_FLAG Character(1) VARCHAR2(1) NOT NULL Bypass Flag

    Default Value: N

    47 FT_ALTERNATE_REC Character(50) VARCHAR2(50) NOT NULL Source Record
    48 FT_ALTERNATE_KEY Character(254) VARCHAR2(254) NOT NULL Alternate Key