Maintain Dynamic Web Application {STWEBM-5}


The Institution must use this option to define the fields that must be displayed on the Biographical, Alumni Biographical and Personnel Personal Data options on the Student iEnabler. 

Once all the fields are set to the user's preference, the button labelled “Generate Dynamic Application” on the 'Search' panel box must be pressed. A Program will be activated that 

will effect the changes made. The user needs to <EXIT> the generation option for the changes to take effect. The next execution of the option on the iEnabler will have the updated screen.


The institution must indicate which fields are displayed and then, set some attributes relating to the appearance of the fields on the iEnabler. The dynamic structure is only applicable to Student, 

Personnel and Alumni Biographical detail {SREGB-1} (Table IADBIO), {PBOP-1} (Table PAAPR1) and {SALUM-4} (Table IGABIO).



Fields in this option:

Panel box:  'Search' - Table Selection


Field Type
&
Length
Description
Table Select A3  Enter the first 3 characters of the table code to view the detail in the follow-up panel boxes. A LOV is available on this field.
Generate Dynamic Application
If information is changed in Panel box ' Field Properties' or 'Field Type Detail' and the Web biographical option must be adapted
accordingly, the user may click on this button and the Web biographical options will be updated automatically. This is valid for
Student Biographical (IADBIO), Personnel Biographical (PAAPR1) and Alumni Biographical (IGABIO) detail.

Example:

Example of ...stwebm-5b1


Example:

Example of ...stwebm-5b2



Panel box 2:  Table Fields Selection

To identify the fields to be used in the Student iEnabler Biographical information.


Field Type
&
Length
Description
Field Name A40 All the fields linked to the table, as defined in the database dictionary. {DMAIN-1} TAB - Table and Columns.
Field Prompt A80 This field refers to the description displayed, as defined in {DMAIN-1} TAB - Objects. This can be changed using Panel box -
'Field Properties' of this application.
Display Sequence N12 This field indicates the sequence in which the fields are displayed. The sequence is created at intervals of 10 to leave space
for changes to the order.  This can be changed using Panel box - 'Field Properties of this application.

Panel box 3:  Field Properties

To specify the detail of each field selected in the previous panel box.


Field Type
&
Length
Description
Field Name A40 Take note that there is a master / detail relationship between the fields on the panel box 'Table Fields Selection'.  This means that when a user click on a field
in the 'Table Fields Selection', the same field with all the relevant data will display in the 'Fields Properties' panel box.


Example of ...stwebm-5b2

Field PromptA80An institution may change the description to suit their needs. This is the field description that will be shown next to the field on the iEnabler biographical option.
Display Indicator Yes  /No Should the field be displayed? If ‘Y’, this will be displayed on the iEnabler.
Insert / Update Indicator Yes / No Displayed Fields are specified as "Insert" or "Update". Fields specified as "Insert" can only be entered on creation of a biographical record. During the Update of a
biographical record, only those fields marked as "Insert" will be displayed. Fields specified as "Update" can be entered after creation of a biographical option,
as well as after an update of biographical data.
Required ItemA3Valid Values equals 'Yes / No'.
Display SequenceN12This affects the sequence in which the fields will be displayed.
Maximum Field Length N5 Supply Maximum Field Length.
Field Type /
Field Type Indicator /
Field Type Detail
A1  This indicates the type of field to be displayed. There is a fixed set of field types that can be utilised. A combination of the 'Field Type' and the 'Field Type' indicator
make up a 'Type'. There are LOV's to help you make your choices.  Below is a example of the 'Field Type Detail, that is link to the 'Field Type Indicator' and then linked to the 'Field Type'.


Field TypeField Type IndicatorField Type Detail
A - Radio Button1.  Yes / No
2.  Gender
Yes / No
Female / Male
B - Dropdown1.  Marital Status




2.  Language Preference


3.  Alien Indicator



4.  Funding



5.  NSN Status



6.  Payment Method


7. Account Type
S - Single
M - Married
D - Divorced
W - Widow/er

E - English
A - Alternate

Y - Foreigner
P - Permanent Resident
N - No

N - Normal Funding
P - Private Funding
G - Funding By Other Government

A - Active
I - Inactive
P - Partial

Q - Cheque
A - ACB-Transfer

C - Current
S - Saving
T - Transmission
C - Text1. Text Input
D - Date1. Date InputDate Input
E - Display Only1. Text DisplayText Display
F - Text Uppercase1. Text InputDate Input
G - Date without calendar1. Date Input
H - List of Values1. List of Values
Q - Dropdown1. Satisfaction Rating





6. Duration
1.  Extremely Dissatisfied
2.  Dissatisfied
3.  Satisfied
4.  Extremely Satisfied
0.  N / A

1.  Less Than A Year
2.  1 - 2 Years
3.  3 - 5 Years
4.  6 -10 Years
5.  More than 10 years
S - Radio Button1. Yes / No and N / A



2. True / False



3. Rating (Better / Worse)  
Y - Yes
N - No
0 - N / A

T - True
F - False
0 - N / A

B - Better
W - Worse
0 - N / A

LOV Source A80 This field, together with the "Field Type" and "Field Type Indicator" fields, can be used to create a list of values. 
The Notation is "schema.table.code.descr" or "schema.view.code.descr"

For example, to get a LOV on Titles, the Field Type would be set to 'H'. When the 'Field Type equals 'H', the LOV is a Mandatory field.
When the 'Field Type' is anything else than 'H', this field will not be accessable.
When the 'Field Type' changed from 'H' to a different value, the 'LOV Name' field will be set to 'NULL'.

The Field Type Indicator would be set to '1'.

Possible LOV’s  for Table = 'IAD' to use:

Field Name:LOV Name:
CHURCHgen.gajchr.gajcode.gajname
CITZgen.ggqcty.ggqcntryc.ggqcntryn
CNTORIGweb.w47vcntry_orig.w47v_code.w47v_name
CNTRYCweb.w82v_cntryc.w82v_cntryc.w82v_cntrycdesc
EMPLstud.ibfemp.ibfcode.ibfname
ETHNgen.galegr.galcode.galname
EXAMCENTstud.ibaexm.ibacode.ibaname
EXAUTHstud.ibieah.ibicode.ibiname
ICCODEKMAN.KACICA.KACICCODE.KACDESC
IWI1WEB.W83V_IWI.W83_IWI.W83_DESC
IWI2WEB.W83V_IWI.W83_IWI.W83_DESC
IWI3WEB.W83V_IWI.W83_IWI.W83_DESC
LANGgen.gamlng.gamcode.gamname
MATTYPEweb.w81v_mattype.mat_type.mat_desc
OCCUPstud.ibpocc.ibpcode.ibpname
PACTstud.ibjpac.ibjcode.ibjname
PCODEstud.ibvpos.ibvpcode.ibvtown
SCHOOLCODEstud.ibcsch.ibccode.ibcname
SOCECATweb.w46vsoc_cat.w46v_catcode.w46v_catname
STUDTYPEstud.ilesty.ilestudtype.ilestudtyped
TMONEYfinc.foqmon.foqtmoney.foqmname
UNITstud.ibbunt.ibbcode.ibbuname

                           

This will result in an icon being placed next to the field on the Student iEnabler.  On selection of the LOV button, a list of
the code and description pairs will be displayed.

Note:  When the Citizenship Code is set up, i.e. Field Name = CITZ, Display Indicator = Y(es)  and the LOV Name =
gen.ggqcty.ggqcntryc.ggqcntryn, only the active Citizenship Codes as set up on {GCS2-6} will display on the list of values
on the Student iEnabler.

New functionality for Field Type H to allow LOV's to be limited with a basic "where" clause.
Format for the LOV is Schema.Table.Code_columnname.Description_columnname.basic_where_clause

Default Value A12 This field is used to indicate the default value of the field, to be displayed on the Student iEnabler.
Note:  The LOV for "Field Name" = CITZ, will only display the active Citizenship Codes as set up on {GCS2-6}, in this
"Default Value" field.
Help TextA2000Create 'Text' for the 'Hint' that must appear on mouse-over field on the iEnabler page.


Panel box 4:  Field Type Detail
 

The Institution must use this option to define the field types that will be displayed on the Biographical options on the iEnabler. For example, certain institutions would prefer that one or more of 

the field type label (this is the 'Name' field) need to be changed. This will be done here. Please be aware that if changes are made here, the change is effected for all biographical iEnabler options.  


Field Type
&
Length
Description
Field Type Value N4 The 'Value' will be populated from the 'Field Type' and 'Field Type Indicator' selection.
Field Type NameA40The 'Field Type Name' will be populated from the 'Field Type' and 'Field Type Indicator' selection.  This field is updateable and the user can change the 'Label'' (Name).
Default  A1 Supply Default Value.
Display Sequence N12 This will be populated.  The user can update this field.


Panel box 5:  Field Validation Groups

This panel box is used to group biographical fields together for biographical validation in order of preference.


Field Type
&
Length
Description
Validation Group N3 Users can link groups to the 'Fields'.  This groups are created on the second tab - panel box 'Validation Groups' and will be available on a LOV.
Error Message A250 The error message that will be displayed on the Student iEnabler if the validation rule was not successful.


Tab 2:  Validation Groups

Panel box 1: To define the validation groups and error messages whereto a field will be linked.


Field Type
&
Length
Description
Validation GroupN3Define a 'Group' number.
Error Message A250Define the 'Error Message' that will be displayed on the Student iEnabler if the validation rule was not successful.

Example:

Example of ...stwebm-5b2



Panel box 2:  Validation Group Fields

This is a display only panel box.  There is a 'Master / Detail' relationships between the panel box 'Validation Groups' and 'Validation Group Fields'.  When the user click on the 'Validation Group' all the table and
fields linked to that group will be displayed on the 'Validation Group Field' panel box.

.
Field Type
&
Length
Description
TableA3The 'Table Name' will be displayed from the 'Search' panel box - field 'Table Code'.
Field Name A40The 'Field Name' will be displayed from the 'Field Properties' panel box.
Field PromptA80The 'Field Prompt' will be displayed from the 'Field Properties' panel box.

Example:

Example of ...stwebm-5b2




Processing
Rules
 
  This option is used to control the creation of biographical detail created from the iEnabler Application modules.
The detail of Tab 2 allow biographical fields to be grouped together for biographical validation in order of preference. Each group is then being validated according to this preference, allowing fields to be duplicated across these groups. Every group requires a validation procedure within dyniadbiocrn package.
Each group contains an action for validation failure. (e.g. next group for validation, or termination of validation, with message and routing to supervisor).
Each defined group of details for validation is tested for duplicates (per group) before completion of the next group or remaining biographical detail (not included within a group).


See Also:



History of Changes

Date System Version By Whom Job Description
22-Jan-2007 v01.0.0.0 Charlene van der Schyff t134848 New manual format.
1-Feb-2008 v01.0.0.0 Melanie Zeelie t134848 Proofread.
26-Feb-2008 v01.0.0.0 Melanie Zeelie t144749 Add new field
27-Feb-2008 v01.0.0.0 Melanie Zeelie t127958 Add new Block 5 and 6 details.
17-Nov-2008 v01.0.0.0 Magda van der Westhuizen t151713 Update manual:  Language Editing:  Juliet Gillies.
19-Sep-2012 v02.0.0.0 Amanda van Emmenis t185257 Add possible LOV’s  for Table = 'IAD' to use.  Default Value for "Field Name" = CITZ, displays only active Citizenship Codes.
19-Sep-2014 v03.0.0.0 Dimakatso Mampuru t201481 Add new image
05-Apr-2017v05.0.0.0Magda van der Westhuizent219767Change manual to latest development on INT5.0.