MCFEM_MAIL_MAIN

index back

Email repository

Main part of an email record. Parts are stored in MCFEM_MAIL_ATT

PeopleSoft Field Name Field Type Column Type Description
MCF_EMAIL_ID Number(16,0) DECIMAL(16) NOT NULL Email Id
MCF_EMAIL_STATUS Number(3,0) SMALLINT NOT NULL Status
MCF_EMAIL_FROM Character(254) VARCHAR2(254) NOT NULL From
MCF_EMAIL_SENDER Character(254) VARCHAR2(254) NOT NULL Sender
MCF_UID Character(70) VARCHAR2(70) NOT NULL UIDL
MCF_WL_SUBJECT Character(254) VARCHAR2(254) NOT NULL Subject
MCF_DTTM_RECV DateTime(26) TIMESTAMP DateTime Received
MCF_OFFSET_RECV Signed Number(4,0) DECIMAL(3) NOT NULL Timezone offset of the Receive datetime for an email. Offest is represented in +/- minutes from UTC ranging from -720 to +720
MCF_DTTM_SENT DateTime(26) TIMESTAMP DateTime Sent
MCF_OFFSET_SENT Signed Number(4,0) DECIMAL(3) NOT NULL Timezone offset of the Sent datetime for an email. Offest is represented in +/- minutes from UTC ranging from -720 to +720
MCF_DTTM_SAVED DateTime(26) TIMESTAMP DateTime Saved
MCF_EMAIL_MSG_ID Character(254) VARCHAR2(254) NOT NULL Message ID
MCF_EMAIL_LANG_CD Character(3) VARCHAR2(3) NOT NULL Language Code
MCF_MSG_SIZE Number(15,0) DECIMAL(15) NOT NULL Message size
MCF_ATTACH_LIST Character(254) VARCHAR2(254) NOT NULL Attachment List
MCF_ATTACH_SIZES Character(254) VARCHAR2(254) NOT NULL Attachment Size
MCF_IS_ATT_URL Number(1,0) SMALLINT NOT NULL is URL?
MCF_ATT_URL Character(254) VARCHAR2(254) NOT NULL Attachment URL
MCF_EMAIL_TEXT Long Character CLOB Text
MCF_CONTENT_TYPE Character(254) VARCHAR2(254) NOT NULL Content Type
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19