Changes between Initial Version and Version 1 of ztvclsdInsert

Timestamp:

06/19/17 15:28:01 (7 years ago)

Author:

lttoth@…

Comment:

--

ztvclsdInsert

@@ +1 @@
+= Creating New SUPER Classes in ZUAUSR =
+
+== Overview ==
+Since ZUAUSR is slated for retirement, requests for new ZUAUSR SUPER classes are discouraged.  However, as part of the ongoing effort to consolidate functions in ZUAUSR and distill what roles and functions are actually being used by our constituency, ZUAUSR administrators have had cause to create new SUPER classes.   
+
+And there are a occasions where a new SUPER class is required based on a change in BANNER.  Those fall into four categories:
+* Replacing a Previous Function with a Place Holder Class (see [[https://iam.alaska.edu/trac/wiki/ztvclsaInsert|Creating New Base Classes in ZUAUSR]])
+* Wrapper Classes for a new Banner Class
+* Classes added to 
+* Multiple classes added to a SUPER class
+
+== Wrapper Classes for New Banner Class & Single Addition to a SUPER Class ==
+A Base class was recently created for the PREP instance of Banner, TRAINING.  That class was not included in any other SUPER class and at creation, no other base class was associated with it.  The following two steps had to be taken to create the SUPER class:  Create the SUPER base class and associate the TRAINING base class to it.
+
+Creating the base class follows the expected template for creating any base class.  Convention dictates that any SUPER class created ends in the suffix "_CLS":
+{{{
+INSERT INTO ztvclsa
+(ztvclsa_class_type, ztvclsa_class_name, ztvclsa_class_inst,
+ ztvclsa_description)
+VALUES
+('SUPER','TRAINING_CLS','PREP','Wrapper for TRAINING functions')
+}}}
+
+To associate the TRAINING Base class with the SUPER class just one entry is needed in this instance.  The type for a SUPER class is always "SUPER".  This can be accomplished via the ZUAUSR Class Maintenance form or by running the following INSERT query:
+{{{
+INSERT INTO ztvclsd
+(ztvclsd_class_type, ztvclsd_class_name, ztvclsd_class_inst,
+ ztvclsd_assoc_class_type, ztvclsd_assoc_class_name, ztvclsd_assoc_class_inst)
+VALUES
+('SUPER','TRAINING_CLS','PREP',
+ 'BANNER','TRAINING','PREP'
+}}}
+
+Any single entry addition to a SUPER class follows this template.
+
+== Multiple Classes Added to a SUPER Class ==
+Several classes can be associated with a SUPER class at once.  This can be done in the ZUAUSR Class Maintenance Form.  The same can be accomplished with the following INSERT query. 
+
+{{{
+
+INSERT ALL 
+INTO ztvclsd
+(ztvclsd_class_type, ztvclsd_class_name, ztvclsd_class_inst,
+ ztvclsd_assoc_class_type, ztvclsd_assoc_class_name, ztvclsd_assoc_class_inst)
+VALUES
+('SUPER','CORE_BANNER_PREP_CLS','PREP',
+ 'ORACLE','USR_DEFAULT_CONNECT','PREP')
+INTO ztvclsd
+(ztvclsd_class_type, ztvclsd_class_name, ztvclsd_class_inst,
+ ztvclsd_assoc_class_type, ztvclsd_assoc_class_name, ztvclsd_assoc_class_inst)
+VALUES
+('SUPER','CORE_BANNER_PREP_CLS','PREP',
+ 'ORACLE','BAN_DEFAULT_M','PREP')
+INTO ztvclsd
+(ztvclsd_class_type, ztvclsd_class_name, ztvclsd_class_inst,
+ ztvclsd_assoc_class_type, ztvclsd_assoc_class_name, ztvclsd_assoc_class_inst)
+VALUES
+('SUPER','CORE_BANNER_PREP_CLS','PREP',
+ 'ORACLE','BAN_DEFAULT_Q','PREP)
+SELECT * FROM dual
+
+}}}