MCFEM_MAIL_MAIN

index back

Email repository

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

PeopleSoft Field NameField TypeColumn TypeDescription
MCF_EMAIL_IDNumber(16,0)DECIMAL(16) NOT NULLEmail Id
MCF_EMAIL_STATUSNumber(3,0)SMALLINT NOT NULLStatus
MCF_EMAIL_FROMCharacter(254)VARCHAR2(254) NOT NULLFrom
MCF_EMAIL_SENDERCharacter(254)VARCHAR2(254) NOT NULLSender
MCF_UIDCharacter(70)VARCHAR2(70) NOT NULLUIDL
MCF_WL_SUBJECTCharacter(254)VARCHAR2(254) NOT NULLSubject
MCF_DTTM_RECVDateTime(26)TIMESTAMPDateTime Received
MCF_OFFSET_RECVSigned Number(4,0)DECIMAL(3) NOT NULLTimezone offset of the Receive datetime for an email. Offest is represented in +/- minutes from UTC ranging from -720 to +720
MCF_DTTM_SENTDateTime(26)TIMESTAMPDateTime Sent
MCF_OFFSET_SENTSigned Number(4,0)DECIMAL(3) NOT NULLTimezone offset of the Sent datetime for an email. Offest is represented in +/- minutes from UTC ranging from -720 to +720
MCF_DTTM_SAVEDDateTime(26)TIMESTAMPDateTime Saved
MCF_EMAIL_MSG_IDCharacter(254)VARCHAR2(254) NOT NULLMessage ID
MCF_EMAIL_LANG_CDCharacter(3)VARCHAR2(3) NOT NULLLanguage Code
MCF_MSG_SIZENumber(15,0)DECIMAL(15) NOT NULLMessage size
MCF_ATTACH_LISTCharacter(254)VARCHAR2(254) NOT NULLAttachment List
MCF_ATTACH_SIZESCharacter(254)VARCHAR2(254) NOT NULLAttachment Size
MCF_IS_ATT_URLNumber(1,0)SMALLINT NOT NULLis URL?
MCF_ATT_URLCharacter(254)VARCHAR2(254) NOT NULLAttachment URL
MCF_EMAIL_TEXTLong CharacterCLOBText
MCF_CONTENT_TYPECharacter(254)VARCHAR2(254) NOT NULLContent Type
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19