RB_WEBFORM_AET(SQL Table) | 
Index Back | 
|---|---|
Upgrade Webform Defn State RecThis table is the state record for upgrade AE RB_RMCF | 
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description | 
|---|---|---|---|---|
| 1 | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance | |
| 2 | WEBFORM_TEMPL_ID | Character(30) | VARCHAR2(30) NOT NULL | Webform_template_id is an id associated with Webform Template | 
| 3 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code | 
| 4 | DESCR100 | Character(100) | VARCHAR2(100) NOT NULL | Length 100 Description | 
| 5 | NLP_CATEGORY | Character(100) | VARCHAR2(100) NOT NULL | 
Used as category field
 Prompt Table: RB_AMPCTGRYST_V  | 
| 6 | USE_WEBFORM_CATGRY | Character(1) | VARCHAR2(1) NOT NULL | 
Flag to indicate AMP to always use the Category on Webform Definition.
 Y/N Table Edit  | 
| 7 | APP_SRV_INPUT_TYPE | Character(1) | VARCHAR2(1) NOT NULL | 
Class name of the Application Services which is the fully qualified name including the Application Packages
 C=Custom R=Rowset X=XmlDoc  | 
| 8 | INBOUND_APPL_MSG | Character(30) | VARCHAR2(30) NOT NULL | 
Message Name associated with the inbound Structured e-mail
 Prompt Table: PSMSGDEFN  | 
| 9 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL | 
Record (Table) Name (see PSRECDEFN).
 Prompt Table: RB_INMSGREC_VW  | 
| 10 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | 
Field Name (see PSDBFIELD).
 Prompt Table: RB_DUMMY_DYN_VW  | 
| 11 | MAILBOX_ID | Character(30) | VARCHAR2(30) NOT NULL | 
Mail Box Id is an Id associated with Mail Boxes
 Prompt Table: RB_MAILBOX_DEFN  | 
| 12 | APPL_SERVICES_ID | Character(30) | VARCHAR2(30) NOT NULL | 
Application Services Id
 Prompt Table: RB_APP_SRV_DEFN  | 
| 13 | SUCCESS_PACKAGE_ID | Number(10,0) | DECIMAL(10) NOT NULL | 
Package Id for Suucessful return from Applications API
 Prompt Table: RBC_ERMS_CLTR_V  | 
| 14 | FAILURE_PACKAGE_ID | Number(10,0) | DECIMAL(10) NOT NULL | 
Package Id for Failurel return from Applications API
 Prompt Table: RBC_ERMS_CLTR_V  | 
| 15 | ERROR_PACKAGE_ID | Number(10,0) | DECIMAL(10) NOT NULL | 
Package Id for Auto Acknowledgement
 Prompt Table: RBC_ERMS_CLTR_V  | 
| 16 | NUMROWS | Number(15,0) | DECIMAL(15) NOT NULL | Number of Rows fetched. |