Web Information Request Data Model Questions {GCS-31}

This screen may be used to set up the prompts that will appear in the iEnabler for each Web Information Request Type {GCS-30}.

The screen will also allow the user to specify.

Lists of values for each prompt
Fields in input screens (forms programs) in the ITS Back-office system associated with each prompt. This may be used to automatically populate the fields in the input screens.

Fields in the option:

Block 1: Web Information Request Data Model Questions

Field	Type & Length	Description
Information Request Type	A4	Information Request Type as defined in Web Information Request Types {GCS-30}
Line	N4	Sequential line number for question display order in the iEnabler.
Question Description	A80	The text entered here will appear as a prompt (question) in the iEnabler.
Compulsory	A1	(Y)es, (N)o or (S)uppress If (Y)es the iEnabler will not allow the user to save the Information Request unless an answer to the prompt is entered If (S)uppress, the iEnabler will not display the prompt.
Action	A1	(U)pdate, (S)elect or (C)reate. This field, and the next four fields (Type, Program, Block and Field) are used by the software to allow a user to automatically populate an input screen. If the Information Request is not designed to do this, the fields may be left blank. The values in this field are used as follows: If the Information Request should populate fields for a new record, the action should be (C)reate for all the relevant questions. (The system will create a new record with the values in the fields as indicated) If the Information Request should update an existing record, questions used to obtain query criteria for the record should be indicated as (S)elect; and questions used to obtain the data for fields to be updated should be indicated as (U)pdate. (In this case, the system will: first query records in the input screen matching the responses (answers) to the prompts (questions) indicated with (S)elect; and then updated the fields in the records with the responses (answers) to the prompts (questions) where the indication is (U)pdate. Note that the system will not update multiple records, i.e. only the first record queried will be updated.
Type	A1	This is used to indicate whether the field to be populated is a (C)haracter - a (N)umeric - or a (D)ate field.
Program	A12	The program name of the input screen.
Block	A12	The technical name of the block in the input screen
Field	A30	The technical name of the field in the input screen
List of Values	A list of values for the prompt in the iEnabler may be generated by either specifying this field and the next two fields (the Table Reference, Column and Description Column), or the SQL Code field below.
Table Reference	A40	This field is for the database schema and table name (schema.tablename) used for the list of values.
Column	A20	The database column name of the code column of List Of Values.
Description Column	A30	The database column name of the description column of List Of Values.
SQL Code	A8	The Code of an SQL select statement, entered in Additional SQL {BATCH-15} in order to generate the list of values may be specified here. The SQL select statement should return two columns, the second column will only display in the list of values and the first column will supply the values to be saved as answer to the prompt. Note that, since only the values in the first column will be saved to the Routing Request, Email messages generated from the Routing System will not include the values of the second column. To work around this, specify the SQL Statement, so that the first column consists of the code concatenated with the description, with a colon inbetween. The iEnabler program that will create the Routing Request, will interpret the values with the colon; although the full value will appear in the Email message(s) sent, only the part of the value before the colon will be used to automatically populate input screens.
SQL	A2500	The SQL Statement associated with the SQL Code will display here.

Example(s):

Processing Rules
	No special processing rules.

Date	System Version	By Whom	Job	Description
22-Sep-2006	v01.0.0.0	Charlene van der Schyff	t134162	New manual
03-Oct-2007	v01.0.0.0	Frans	T143444	Autopopulate input screens
09-Sep-2008	v01.0.0.0	Charlene van der Schyff	t152060	Edit language obtained from proof read language Juliet Gillies.