RB_STR_AET(SQL Table) |
Index Back |
|---|---|
State Record For StructuredState Record For Structured Content Analysis |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance | |
| 2 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 3 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 4 | MCF_EMAIL_ID | Number(16,0) | DECIMAL(16) NOT NULL | Email Id |
| 5 | MAILBOX_ID | Character(30) | VARCHAR2(30) NOT NULL | Mail Box Id is an Id associated with Mail Boxes |
| 6 | FROM_ADDRESS | Character(200) | VARCHAR2(200) NOT NULL | Dialog Designer: Reply To Email Address |
| 7 | ACTION_FLAG | Character(2) | VARCHAR2(2) NOT NULL | Action Flag |
| 8 | WEBFORM_TEMPL_ID | Character(30) | VARCHAR2(30) NOT NULL | Webform_template_id is an id associated with Webform Template |
| 9 | APPL_SERVICES_ID | Character(30) | VARCHAR2(30) NOT NULL | Application Services Id |
| 10 | RB_PACKAGE_ID | Number(10,0) | DECIMAL(10) NOT NULL | Package |
| 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 |
| 13 | ROUTE_DEF_WRKLIST | Character(1) | VARCHAR2(1) NOT NULL | Flag indicating if it was Routed to a Default Worklist (or) not |
| 14 | WORKLISTNAME | Character(30) | VARCHAR2(30) NOT NULL | Worklist Name |
| 15 | RB_DUMMY1 | Character(3) | VARCHAR2(3) NOT NULL | Multi-purpose Dummy field----- |