CMF_IDDefault Value: NEXT
SEQNUMSDB_OB_TMPL_VW(SQL View) |
Index Back |
|---|---|
Outbound Template Usage ViewOutbound Template Usage View used in Contact Center Dashboard. |
| SELECT A.CMF_ID , A.SEQNUM , E.BUSINESS_UNIT , B.EMAIL_STATUS , A.RB_PACKAGE_ID , A.RB_TEMPLATE_ID , A.TMPLT_CATEGRY_ID , A.TMPLT_TYPE_ID , A.PRODUCT_GROUP , A.PRODUCT_ID , F.SETID_PROD_GRP , F.PRODUCT_SETID , C.INTERACTION_ID , C.PARENT_INTER_ID , B.ROW_ADDED_DTTM , B.ROW_LASTMANT_DTTM FROM PS_RB_EM_APPL_TEMP A , PS_SDB_OB_EMAIL_VW B , PS_RI_INTERACTION C , PS_RI_INTERACTION D , PS_RB_IN_EMAIL E , PS_RBD_BUSET F WHERE A.CMF_ID = B.CMF_ID AND B.EMAIL_STATUS = 'COMP' AND B.INTERACTION_ID = C.INTERACTION_ID AND C.PARENT_INTER_ID <> '0' AND C.PARENT_INTER_ID = D.INTERACTION_ID AND D.INTERACTION_MTHD = 'IEML' AND E.INTERACTION_ID = D.INTERACTION_ID AND E.BUSINESS_UNIT = F.BUSINESS_UNIT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CMF_ID |
Character(36) | VARCHAR2(36) NOT NULL |
Correspondence ID
Default Value: NEXT |
| 2 | SEQNUM |
Number(3,0) | SMALLINT NOT NULL | Sequence Number |
| 3 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 4 | EMAIL_STATUS | Character(4) | VARCHAR2(4) NOT NULL | ERMS Inbound Email Status |
| 5 | RB_PACKAGE_ID | Number(10,0) | DECIMAL(10) NOT NULL | Package |
| 6 | RB_TEMPLATE_ID | Number(10,0) | DECIMAL(10) NOT NULL | Template ID |
| 7 | TMPLT_CATEGRY_ID | Number(6,0) | INTEGER NOT NULL | Template Category ID |
| 8 | TMPLT_TYPE_ID | Number(6,0) | INTEGER NOT NULL | Template Type ID |
| 9 | PRODUCT_GROUP | Character(10) | VARCHAR2(10) NOT NULL | PRoduct Group |
| 10 | PRODUCT_ID | Character(18) | VARCHAR2(18) NOT NULL | Product ID |
| 11 | SETID_PROD_GRP | Character(5) | VARCHAR2(5) NOT NULL | Product Group setid field |
| 12 | PRODUCT_SETID | Character(5) | VARCHAR2(5) NOT NULL | This is the field for Dashboard setid recname. |
| 13 | INTERACTION_ID | Character(15) | VARCHAR2(15) NOT NULL | interaction id |
| 14 | PARENT_INTER_ID | Character(15) | VARCHAR2(15) NOT NULL | Parent Interaction ID.................................... |
| 15 | ROW_ADDED_DTTM | DateTime(26) | TIMESTAMP | This is a datetime field for record creation. |
| 16 | ROW_LASTMANT_DTTM | DateTime(26) | TIMESTAMP | The date and time that the row was last updated. |