MCF_EMAIL_IDSEQ_NUM0=Type
1=Product Group
2=Product
3=Mood
4=Documents
5=Solutions
6=Category
7=Priority
RB_AMP_NLPOUTPT(SQL Table) |
Index Back |
|---|---|
Common application recordThe common application Category record |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | MCF_EMAIL_ID |
Number(16,0) | DECIMAL(16) NOT NULL | Email Id |
| 2 | SEQ_NUM |
Number(3,0) | SMALLINT NOT NULL | Sequence |
| 3 | EML_NLP_RET_CATG | Character(4) | VARCHAR2(4) NOT NULL |
Email Category like Type, Product Group, Product, Mood etc., Thishelps Email Workspace to identify where to use the returned Category.
0=Type 1=Product Group 2=Product 3=Mood 4=Documents 5=Solutions 6=Category 7=Priority |
| 4 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |
| 5 | KB_THRESHOLD | Number(6,2) | DECIMAL(5,2) NOT NULL | Used to indicate the threshold |
| 6 | SOLUTION_DESCR | Long Character | CLOB | Solution Description |