RB_WEBFORM_AET

(SQL Table)
Index Back

Upgrade Webform Defn State Rec

This table is the state record for upgrade AE RB_RMCF

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE 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.