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 | PROCESS_INSTANCE | 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----- |