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