CMF_IDCMF_TRNS_SEQ_NUMCMF_RECIP_SEQ_NUMBAM=Oracle BAM
CM=Correspondence Management
ERMS=Email Response Management
RTS=PS Real Time Suite Dashboard
1=High
2=Medium
3=Low
Y/N Table Edit
Default Value: N
RBC_DLVEML_ATT(SQL View) |
Index Back |
|---|---|
Correspondence state TableCorrespondence Delivery Queue Table. Recipients with attachments. |
| SELECT REQ.CMF_ID , RECP.CMF_TRNS_SEQ_NUM , RECP.CMF_RECIP_SEQ_NUM , REQ.CMF_SOURCE , REQ.SUBMIT_OPRID , REQ.GEN_MSG_PRIORITY , REQ.RB_ACT_RQST_CD , REQ.EMAIL_ADDR_SENDER , REQ.CONTEXT_TAG_FLAG , RECP.CMF_INSTANCE_ID , RECP.INTERACTION_ID , RECP.EMAIL_ADDR , RECP.SUBJECT FROM PS_RBC_REQUEST REQ , PS_RBC_RECIPIENT RECP WHERE CMF_REQST_STATUS = 'SBMT' AND REQ.CMF_ID = RECP.CMF_ID AND RECP.SELECTED_FLAG = 'Y' AND NOT EXISTS( SELECT 'X' FROM PS_RBC_RECP_ATTACH ATN WHERE ATN.CMF_ID = RECP.CMF_ID AND ATN.CMF_TRNS_SEQ_NUM = RECP.CMF_TRNS_SEQ_NUM AND ATN.CMF_RECIP_SEQ_NUM = RECP.CMF_RECIP_SEQ_NUM AND ATN.CMF_ATTACH_STATUS <> 'DLIP') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CMF_ID |
Character(36) | VARCHAR2(36) NOT NULL | Correspondence ID |
| 2 | CMF_TRNS_SEQ_NUM |
Number(3,0) | SMALLINT NOT NULL | Correspondence Management Package Sequence Number |
| 3 | CMF_RECIP_SEQ_NUM |
Number(18,0) | DECIMAL(18) NOT NULL | Correspondence Management Package Sequence Number |
| 4 | CMF_SOURCE | Character(4) | VARCHAR2(4) NOT NULL |
Correspondence Request Status
BAM=Oracle BAM CM=Correspondence Management ERMS=Email Response Management RTS=PS Real Time Suite Dashboard |
| 5 | SUBMIT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Submitted By OPRID......................................... |
| 6 | GEN_MSG_PRIORITY | Character(1) | VARCHAR2(1) NOT NULL |
Priority
1=High 2=Medium 3=Low |
| 7 | RB_ACT_RQST_CD | Character(30) | VARCHAR2(30) NOT NULL | Action Request Code - this code is used primarily for Quality Worklist/Workflow when 'Assign To' is manually entered. |
| 8 | EMAIL_ADDR_SENDER | Long Character | CLOB | This is the senders email address field. |
| 9 | CONTEXT_TAG_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Need Context Tag in Email.........................
Y/N Table Edit Default Value: N |
| 10 | CMF_INSTANCE_ID | Character(36) | VARCHAR2(36) NOT NULL | Correspondence Instance ID |
| 11 | INTERACTION_ID | Character(15) | VARCHAR2(15) NOT NULL | interaction id |
| 12 | EMAIL_ADDR | Character(70) | VARCHAR2(70) NOT NULL | Email address to store the address of email. |
| 13 | SUBJECT | Character(254) | VARCHAR2(254) NOT NULL | Subject |