[Home] [Help] [Dependency Information]
Object Name: | JTF_FM_EMAIL_STATS |
---|---|
Object Type: | TABLE |
Owner: | JTF |
FND Design Data: | JTF.JTF_FM_EMAIL_STATS |
Subobject Name: | |
Status: | VALID |
Table to hold statistical information on Emails sent out by Fulfillment Server.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
JTF_FM_EMAIL_STATS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | REQUEST_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
REQUEST_ID | NUMBER | Yes | Column that stores the Fulfillment Request Id | |
TOTAL | NUMBER | Total is the aggregate number of emails sent for that request Id. | ||
SENT | NUMBER | Sent represents the number of emails successfully sent. | ||
MALFORMED | NUMBER | Number of email recipients who had Malformed Email Address | ||
BOUNCED | NUMBER | Number of Emails that bounced back for a given request. | ||
OPENED | NUMBER | Number of emails that were opened. | ||
UNSUBSCRIBED | NUMBER | Number of recipients who opted for to "Unsubscribe" after receiving a request | ||
DO_NOT_CONTACT | NUMBER | Number of contacts that had a "DO NOT CONTACT" Flag set | ||
CREATED_BY | NUMBER | Yes | Record created by. | |
CREATION_DATE | DATE | Yes | Record creation date | |
LAST_UPDATED_BY | NUMBER | Yes | Record last updated by | |
LAST_UPDATE_DATE | DATE | Yes | Last Updated date. | |
LAST_UPDATE_LOGIN | NUMBER | Last update Login | ||
RESUBMITTED_MALFORMED | NUMBER | this column will keep track of the number of jobs within a request that initially had malformed requests but later the address has been changed and resubmitted | ||
RESUBMITTED_JOB_COUNT | NUMBER | this column will keep track of the number of each individual job that has been resubmitted. |
Cut, paste (and edit) the following text to query this object:
SELECT REQUEST_ID
, TOTAL
, SENT
, MALFORMED
, BOUNCED
, OPENED
, UNSUBSCRIBED
, DO_NOT_CONTACT
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, RESUBMITTED_MALFORMED
, RESUBMITTED_JOB_COUNT
FROM JTF.JTF_FM_EMAIL_STATS;
JTF.JTF_FM_EMAIL_STATS does not reference any database object
JTF.JTF_FM_EMAIL_STATS is referenced by following:
|
|
|