MCF_EMAIL_IDMCFEM_MAIL_MAIN(SQL Table) |
Index Back |
|---|---|
Email repositoryMain part of an email record. Parts are stored in MCFEM_MAIL_ATT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | MCF_EMAIL_ID |
Number(16,0) | DECIMAL(16) NOT NULL | Email Id |
| 2 | MCF_EMAIL_STATUS | Number(3,0) | SMALLINT NOT NULL | Status |
| 3 | MCF_EMAIL_FROM | Character(254) | VARCHAR2(254) NOT NULL | From |
| 4 | MCF_EMAIL_SENDER | Character(254) | VARCHAR2(254) NOT NULL | Sender |
| 5 | MCF_UID | Character(70) | VARCHAR2(70) NOT NULL | UIDL |
| 6 | MCF_WL_SUBJECT | Character(254) | VARCHAR2(254) NOT NULL | Subject |
| 7 | MCF_DTTM_RECV | DateTime(26) | TIMESTAMP | DateTime Received |
| 8 | 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 |
| 9 | MCF_DTTM_SENT | DateTime(26) | TIMESTAMP | DateTime Sent |
| 10 | 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 |
| 11 | MCF_DTTM_SAVED | DateTime(26) | TIMESTAMP | DateTime Saved |
| 12 | MCF_EMAIL_MSG_ID | Character(254) | VARCHAR2(254) NOT NULL | Message ID |
| 13 | MCF_EMAIL_LANG_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 14 | MCF_MSG_SIZE | Number(15,0) | DECIMAL(15) NOT NULL | Message size |
| 15 | MCF_ATTACH_LIST | Character(254) | VARCHAR2(254) NOT NULL | Attachment List |
| 16 | MCF_ATTACH_SIZES | Character(254) | VARCHAR2(254) NOT NULL | Attachment Size |
| 17 | MCF_IS_ATT_URL | Number(1,0) | SMALLINT NOT NULL | is URL? |
| 18 | MCF_ATT_URL | Character(254) | VARCHAR2(254) NOT NULL | Attachment URL |
| 19 | MCF_EMAIL_TEXT | Long Character | CLOB | Text |
| 20 | MCF_CONTENT_TYPE | Character(254) | VARCHAR2(254) NOT NULL | Content Type |