RB_STR_AET

(SQL Table)
Index Back

State Record For Structured

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