MCF_EMAIL_ID0=Not Started
1=Processing
2=Completed
E=Error
F=Failure
S=Success
Y/N Table Edit
Y/N Table Edit
RB_STR_ANLY_LOG(SQL Table) |
Index Back |
|---|---|
Structured Analysis LogStructured Analysis Log |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | MCF_EMAIL_ID |
Number(16,0) | DECIMAL(16) NOT NULL | Email Id |
| 2 | ANALYSIS_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Deternined the Status of Content analysis
0=Not Started 1=Processing 2=Completed |
| 3 | START_DTTM | DateTime(26) | TIMESTAMP | start date time |
| 4 | END_DTTM | DateTime(26) | TIMESTAMP | end date time |
| 5 | MAILBOX_ID | Character(30) | VARCHAR2(30) NOT NULL | Mail Box Id is an Id associated with Mail Boxes |
| 6 | WEBFORM_TEMPL_ID | Character(30) | VARCHAR2(30) NOT NULL | Webform_template_id is an id associated with Webform Template |
| 7 | APPL_SERVICES_ID | Character(30) | VARCHAR2(30) NOT NULL | Application Services Id |
| 8 | RB_PACKAGE_ID | Number(10,0) | DECIMAL(10) NOT NULL | Package |
| 9 | FROM_ADDRESS | Character(200) | VARCHAR2(200) NOT NULL | Dialog Designer: Reply To Email Address |
| 10 | REPLY_TO_ADDRESS | Character(254) | VARCHAR2(254) NOT NULL | Email Address associated with the Reply To Person |
| 11 | ANALYSIS_OUTCOME | Character(1) | VARCHAR2(1) NOT NULL |
Determines the Outcome of Content Analysis
E=Error F=Failure S=Success |
| 12 | ROUTE_EXCP_WRKLIST | Character(1) | VARCHAR2(1) NOT NULL |
Flag indicating if it was Routed to an Exception Worklist (or) not
Y/N Table Edit |
| 13 | ROUTE_DEF_WRKLIST | Character(1) | VARCHAR2(1) NOT NULL |
Flag indicating if it was Routed to a Default Worklist (or) not
Y/N Table Edit |
| 14 | WORKLISTNAME | Character(30) | VARCHAR2(30) NOT NULL | Worklist Name |