march 2019 release 8 - fairmont state university · 2019. 6. 19. · (gubinst) and campus code...

Banner General Release NotesRelease 8.11March 2019

Notices and Privacy

Notices and Privacy© 2019 Ellucian.

Contains confidential and proprietary information of Ellucian and its subsidiaries. Use of thesematerials is limited to Ellucian licensees, and is subject to the terms and conditions of one or morewritten license agreements between Ellucian and the licensee in question.

In preparing and providing this publication, Ellucian is not rendering legal, accounting, or othersimilar professional services. Ellucian makes no claims that an institution's use of this publicationor the software for which it is provided will guarantee compliance with applicable federal or statelaws, rules, or regulations. Each organization should seek legal, accounting, and other similarprofessional services from competent providers of the organization's own choosing.

Ellucian's Privacy Statement is available at: www.ellucian.com/privacy.

Ellucian shall have the right to (a) use, store, process, modify, reproduce, distribute and displaycustomer data, and to grant sublicenses to third parties, for the sole purposes of providing thesoftware, performing Ellucian's obligations under its agreements with customers and complying withapplicable law or legal requirements; (b) use, store, process, modify and reproduce customer datafor Ellucian's internal business purposes, including development, diagnostic, forecasting, planning,analysis and corrective purposes in connection with the software, and for otherwise improvingand enhancing the software; and (c) use, store, process, modify, reproduce, display, perform,distribute, disclose and otherwise exploit in any manner Aggregated Data for Ellucian's businesspurposes, including disclosure within its public statements and marketing materials describingand/or promoting Ellucian and/or the software. “Aggregated Data” means any data obtained orgenerated by Ellucian, including data pertaining to the software, Ellucian's systems and software,and the use of any of the foregoing, and includes data derived from customer data, which in allinstances (i) does not identify any individual and (ii) is not attributed or attributable to a specificcustomer. Aggregated Data includes data that has been combined into databases which includethird party data.

Ellucian2003 Edmund Halley DriveReston, VA 20191United States of America

©2019 Ellucian. Confidential and Proprietary 2

https://www.ellucian.com/privacy

Contents

Contents

Introduction.................................................................................................................................... 5

Database support for Ellucian Ethos..................................................................................6New Time Zone field.....................................................................................................................6

Modified tables........................................................................................................................6Installation Controls (GUBINST) table............................................................................. 6Campus Code Validation (STVCAMP) table....................................................................6

New scripts............................................................................................................................. 7Modified International Standards Organization (ISO) code field.................................................. 7

New scripts............................................................................................................................. 7

Database support for the collection of Social Economic Identity Detailsdata.....................................................................................................................................................8

New scripts....................................................................................................................................8New tables.....................................................................................................................................9

Person Social Economic Identity and Biographical Audit Trail (GORPSAD) table................. 9Person Social Economic Identity Details (GORPSID) table.................................................10Social Economic Identity Rules (GORSEID) table...............................................................10Social Economic Identity Report Template (GORSETP) table.............................................11Social Economic Identity Codes (GTVSEID) table...............................................................12Social Economic Identity Report (GTVSEIR) table.............................................................. 12

Database support for tracking Banner localization inventory................................14New tables...................................................................................................................................14

Banner Localization Code (GTVLCIN) table........................................................................ 14Localization Inventory (GURLCIN) table.............................................................................. 15

New scripts..................................................................................................................................15

Database support for Application Navigator................................................................. 20Modified table.............................................................................................................................. 20New scripts..................................................................................................................................20

Database support for Action Item Processing enhancement.................................21Modified tables............................................................................................................................ 21

Action Item Post (GCBAPST) table..................................................................................... 21Action Item Page Builder Template (GCBPBTR) table........................................................ 21Assigned Action Item (GCRAACT) table..............................................................................22Action Item Status Rule (GCRAISR) table...........................................................................22

New tables...................................................................................................................................22Action Item Review Audit (GCBRAUD) table.......................................................................22AIP Document Metadata (GCRAFLU) table.........................................................................24AIP Document Content (GCRAFCT) table...........................................................................25Action Item Review Status Validation (GTVRVST) table..................................................... 26


Contents

Default Action Item Review Status (GCRRVSD) table.........................................................26Action Item Review Status Rule (GCRRVST) table.............................................................27

New scripts..................................................................................................................................28

Database support for Banner Communication Management..................................31New tables...................................................................................................................................31

Recurring Scheduling for Communications (GCBCREC) table............................................31Text Message Communications Template (GCBTMTL) table.............................................. 33Communications Text Message Item (GCRTITM) table.......................................................34

Modified tables............................................................................................................................ 35Group Send (GCBGSND) table............................................................................................35Population (GCBPOPL) table............................................................................................... 36

New scripts..................................................................................................................................36New views................................................................................................................................... 39Modified views.............................................................................................................................39

Resolutions...................................................................................................................................40


Introduction

IntroductionThe Banner General 8.11 release is a cumulative release of all interim releases and patches thatwent out after the 8.10 release. In addition, it contains a number of enhancements and defectcorrections.

Note: Also included in this release are the following two patches:

• Previously released (but not rolled-up) Banner General 8.10.2.1 to provide updates to PCItransaction software for WebLogic 12.2 and Tomcat 8 support.

• Banner General 8.10.1.1 to provide signed JAR files with a new expiration date.


Database support for Ellucian Ethos

Database support for Ellucian EthosThe Banner General 8.11 release includes database changes to support Banner Ethos APIs andEllucian Ethos Integration.

This enhancement satisfies CR-000163004.

New Time Zone field

The Banner General 8.11 release introduces a new Time Zone field to the Installation Controls(GUBINST) and Campus Code Validation (STVCAMP) tables to support setting up the Time Zoneby institution and campus.

This new field provides time zone support, which incorporates daylight savings time offsets. Whilethis feature supports Ellucian Ethos APIs, it is also available to all customers whether they useEllucian Ethos or not.

Institutions can now set the their time zone in addition to setting the appropriate time zone forindividual campuses.

Modified tables

This release delivers the following modified tables to support the new Time Zone field.

Installation Controls (GUBINST) table

This release delivers a new column to GUBINST, enabling the institution to set up it's time zone.

Column Name Null? Type Description

GUBINST_TIMEZONE_NAME NULL VARCHAR2(100) This field identifies timezone in which the institutionresides.

Campus Code Validation (STVCAMP) table

This release delivers a new column to STVCAMP, enabling the institution to set time zones forindividual campuses.


STVCAMP_TIMEZONE_NAME NULL VARCHAR2(100) This field identifies time zonein which the campus resides.


Database support for Ellucian Ethos

New scripts

This release delivers new DDL scripts used to add the time zone column to the Installation Controls(GUBINST) and Code Validation (STVCAMP) tables.

Script Description

gubinst_081100_01.sql Add column GUBINST_TIMEZONE_NAME at a length of100.

gubinst_081100_02.sql Add comment on column GUBINST_TIMEZONE_NAME.

stvcamp_081100_01.sql Add column STVCAMP_TIMEZONE_NAME at a length of100.

stvcamp_081100_02.sql Add comment on column STVCAMP_TIMEZONE_NAME.

Modified International Standards Organization (ISO) codefield

The Banner General 8.11 release delivers new scripts to support the mapping of state, county andlanguage ISO codes to Banner codes for all institutions using Ethos even if they do not licenseBanner Student.

The Banner Ethos APIs will consume the ISO codes information from the following tables instead ofthe EDI Cross-Reference Rules (SOAXREF) page.

• State/Province Code Validation (STVSTAT) table• County Code Validation (STVCNTY) table• Language Code Validation (STVLANG) table

New scripts

This release delivers new scripts to modify the length of the ISO Code column from 3 to 8 onthe State/Province Code Validation (STVSTAT), County Code Validation table (STVCNTY), andLanguage Code Validation (STVLANG) tables.

Script Description

stvcnty_081100_01.sql Modify column STVCNTY_SCOD_CODE_ISO to a length of 8.

stvcnty_081100_02.sql Correct a comment on column STVCNTY_SCOD_CODE_ISO.

stvlang_081100_01.sql Modify column STVLANG_SCOD_CODE_ISO to a length of 8.

stvlang_081100_02.sql Correct a comment on column STVLANG_SCOD_CODE_ISO.

stvstat_081100_01.sql Modify column STVSTAT_SCOD_CODE_ISO to a length of 8.

stvstat_081100_02.sql Correct a comment on column STVSTAT_SCOD_CODE_ISO.


Database support for the collection of Social Economic Identity Details data

Database support for the collection of SocialEconomic Identity Details data

The Banner General 8.11 release includes new scripts and tables to store the collection of SocialEconomic Identity Details data, which will help facilitate the collection of Higher Education StatisticsAgency (HESA) regulatory data.


New scripts

This release delivers the following new scripts.

DDL

Scripts Description

gorpsad_081100_01.sql Alter table script to add columns to the GORPSADtable.

gorpsad_081100_02.sql Adds table comments to new columns on GORPSAD.

gorsetp_081100_01.sql Alter table script to add column to the GORSETPtable.

gorsetp_081100_02.sql Adds table comments to new column on GORSETP.

DML

Script Description

gurmesgi_081100.sql Seed data script for new API.

DBPROCS

Scripts Description

gokd_gorpsad0.sql Script for DML package header for GORPSAD.

gokd_gorpsad1.sql Script for DML package body for GORPSAD.

gokb_socecon_audit_r0.sql Script for rules package header for social economicbio audit API.

gokb_socecon_audit_r1.sql Script for rules package body for social economic bioaudit API.

gokb_socecon_audit_s0.sql Script for error messages package header for socialeconomic bio audit API.



Scripts Description

gokb_socecon_audit_s1.sql Script for error messages package body for socialeconomic bio audit API.

gokb_socecon_audit0.sql Script for package header for social economic bioaudit API.

gokb_socecon_audit1.sql Script for package body for social economic bio auditAPI.

New tables

This release delivers the following new tables.

Person Social Economic Identity and Biographical Audit Trail(GORPSAD) table

Stores the audit trail information about the entries and updates made to the Social EconomicIdentity or Biographic details of a person.


GORPSAD_PIDM NULL NUMBER(8,0) Internal identification numberof the person.

GORPSAD_COLUMN_NAME NULL VARCHAR(30) Oracle Table Column Nameof audit value.

GORPSAD_TABLE_KEY NULL VARCHAR2(250) Key value for SocialEconomic Identity orBiographic Audit Record.

GORPSAD_VALUE NULL VARCHAR2(250) Data value for audit log.

GORPSAD_DATE NULL DATE Date audit trail entry logged.

GORPSAD_USER_ID NULL VARCHAR2(30) The User ID of the personwho inserted or last updatedthis record.

GORPSAD_ACTIVITY_DATE NULL DATE Date the record was createdor updated.

GORPSAD_DATA_ORIGIN NULL VARCHAR2(30) Source system that createdor updated the data.

GORPSAD_SURROGATE_ID NULL NUMBER(19,0) Immutable unique key.

GORPSAD_VERSION NULL NUMBER(19,0) Optimistic lock token.

GORPSAD_VPDI_CODE NULL VARCHAR2(6) Multi-entity processing code.



Person Social Economic Identity Details (GORPSID) table

Stores information about the Social Economic Identity details of a person.


GORPSID_PIDM NOTNULL

NUMBER(8,0) Internal identification numberof the person.

GORPSID_SEIR_CODE NOTNULL

VARCHAR2(30) Social Economic IdentityReport Code.

GORPSID_SEID_CODE NOTNULL

VARCHAR2(30) Social Economic IdentityCode.

GORPSID_SEQ_NO NOTNULL

NUMBER(4) Sequence number forPerson, Social EconomicIdentity Report and SocialEconomic Identity Codevalues.

GORPSID_SEID_VALUE NULL VARCHAR2(250) Social Economic Identityvalue.

GORPSID_USER_ID NULL VARCHAR(230) The User ID of the personwho inserted or last updatedthis record.

GORPSID_ACTIVITY_DATE NULL DATE Date the record was createdor updated.

GORPSID_DATA_ORIGIN NULL VARCHAR2(30) Source system that createdor updated the data.

GORPSID_SURROGATE_ID NULL NUMBER(19,0) Immutable unique key.

GORPSID_VERSION NULL NUMBER(19,0) Optimistic lock token.

GORPSID_VPDI_CODE NULL VARCHAR2(6) Multi-entity processing code.

Social Economic Identity Rules (GORSEID) table

Stores information about the values associated with Social Economic Identity Codes.


GORSEID_SEID_CODE NOTNULL

VARCHAR2(30) Social Economic IdentityCode

GORSEID_SEID_VALUE NOTNULL

VARCHAR2(30) Social Economic IdentityValue.

GORSEID_SEID_VALUE_DESC NOTNULL

VARCHAR2(100) Social Economic Identityvalue description.




GORSEID_USER_ID NULL VARCHAR2(30) The user ID of the personwho inserted or last updatedthis record.

GORSEID_ACTIVITY_DATE NULL DATE Date the record was createdor updated.

GORSEID_DATA_ORIGIN NULL VARCHAR2(30) Source system that createdor updated the data.

GORSEID_SURROGATE_ID NULL NUMBER(19,0) Immutable unique key.

GORSEID_VERSION NULL NUMBER(19,0) Optimistic lock token.

GORSEID_VPDI_CODE NULL VARCHAR2(6) Multi-entity processing code.

Social Economic Identity Report Template (GORSETP) table

Stores information about the association of Social Economic Identity Codes with Social EconomicIdentity Reports and the field type of the Identity Codes.


GORSETP_SEIR_CODE NOTNULL

VARCHAR2(30) Social Economic IdentityReport Code

GORSETP_SEID_CODE NOTNULL

VARCHAR2(30) Social Economic IdentityCode.

GORSETP_FIELD_TYPE_CDE NOTNULL

VARCHAR2(1) Code to describe if socialeconomic identity value isbased on pull down (P) orfree format (F) data entry.

GORSETP_USER_ID NULL VARCHAR2(30) The user ID of the personwho inserted or last updatedthis record.

GORSETP_ACTIVITY_DATE NULL DATE Date the record was createdor updated.

GORSETP_DATA_ORIGIN NULL VARCHAR2(30) Source system that createdor updated the data.

GORSETP_SURROGATE_ID NULL NUMBER(19,0) Immutable unique key.

GORSETP_VERSION NULL NUMBER(19,0) Optimistic lock token.

GORSETP_VPDI_CODE NULL VARCHAR2(6) Multi-entity processing code.



Social Economic Identity Codes (GTVSEID) table

Stores Social Economic Identity Code information.


GTVSEID_CODE NOTNULL

VARCHAR2(30) Social Economic IdentityCode

GTVSEID_LABEL NOTNULL

VARCHAR2(30) Social Economic Identityvalue label.

GTVSEID_DESC NOTNULL

VARCHAR2(100) Social Economic Identityvalue description.

GTVSEID_USER_ID NULL VARCHAR2(30) The user ID of the personwho inserted or last updatedthis record.

GTVSEID_ACTIVITY_DATE NULL DATE Date the record was createdor updated.

GTVSEID_DATA_ORIGIN NULL VARCHAR2(30) Source system that createdor updated the data.

GTVSEID_SURROGATE_ID NULL NUMBER(19,0) Immutable unique key.

GTVSEID_VERSION NULL NUMBER(19,0) Optimistic lock token.

GTVSEID_VPDI_CODE NULL VARCHAR2(6) Multi-entity processing code.

Social Economic Identity Report (GTVSEIR) table

Stores Social Economic Identity Report code information.


GTVSEIR_CODE NOTNULL

VARCHAR2(30) Social Economic IdentityReport Code.

GTVSEIR_DESC NOTNULL

VARCHAR2(100) Social Economic IdentityReport description.

GTVSEIR_USER_ID NULL VARCHAR2(30) The User ID of the personwho inserted or last updatedthis record.

GTVSEIR_ACTIVITY_DATE NULL DATE Most recent date the recordwas created or updated.

GTVSEIR_DATA_ORIGIN NULL VARCHAR2(30) Source system that createdor updated the data.

GTVSEIR_SURROGATE_ID NULL NUMBER(19,0) Immutable uinique key.

GTVSEIR_VERSION NULL NUMBER(19,0) Optimistic lock token




GTVSEIR_VPDI_CODE NULL VARCHAR2(6) Multi-entity processing code.


Database support for tracking Banner localization inventory

Database support for tracking Bannerlocalization inventory

The Banner General 8.11 release includes database changes to support tracking Bannerlocalization inventory at an institution for version control.


New tables

This release delivers the following new tables to support tracking Banner localization inventory.

Banner Localization Code (GTVLCIN) table

This table stores the values of localization names.


GTVLCIN_CODE NOTNULL

VARCHAR2(120) Banner Localizationcode.

GTVLCIN_DESC NOTNULL

VARCHAR2(240) Description of theBanner Localization.

GTVLCIN_SYSTEM_REQUIRED_IND NOTNULL

VARCHAR2(4) Y/N indicator.Indicates if thesystem requires therecord.

GTVLCIN_ACTIVITY_DATE NOTNULL

DATE The date on whichinformation was lastentered or updatedfor this record.

GTVLCIN_USER_ID NOTNULL

VARCHAR2(120) The ID of the userwho last updated orinserted the record.

GTVLCIN_DATA_ORIGIN NULL VARCHAR2(120) The source systemthat created orupdated the data.

GTVLCIN_SURROGATE_ID NULL NUMBER(19) Immutable uniquekey.

GTVLCIN_VERSION NULL NUMBER(19) Optimistic locktoken.




GTVLCIN_VPDI_CODE NULL VARCHAR2(24) Multi-entityprocessing code.

Localization Inventory (GURLCIN) table

This table stores the institution's localization inventory.


GURLCIN_LCIN_CODE NOTNULL

VARCHAR2(120) Banner Localizationcode.

GURLCIN_ACTIVITY_DATE NOTNULL

DATE The date on whichinformation was lastentered or updated forthis record.

GURLCIN_USER_ID NOTNULL

VARCHAR2(120) The ID of the user wholast updated or insertedthe record.

GURLCIN_DATA_ORIGIN NULL VARCHAR2(120) The source system thatcreated or updated thedata.

GURLCIN_SURROGATE_ID NULL NUMBER(19) Immutable unique key.

GURLCIN_VERSION NULL NUMBER(19) Optimistic lock token.

GURLCIN_VPDI_CODE NULL VARCHAR2(24) Multi-entity processingcode.

New scripts

This release delivers the following new scripts to support tracking Banner localization inventory.

DDL

These scripts create the Banner Localization Code (GTVLCIN) and Localization Inventory(GURLCIN) tables

Script Description

gtvlcin_081100_01.sql Creates table GTVLCIN for Banner Localization Codes.

gtvlcin_081100_02.sql Creates primary key for GTVLCIN.

gtvlcin_081100_03.sql Inserts table and column comments to GTVLICN.

gurlcin_081100_01.sql Creates table GURLCIN for Banner Localization Inventory.



Script Description

gurlcin_081100_02.sql Creates primary key for GURLCIN.

gurlcin_081100_03.sql Creates foreign key for GURLCIN to GTVLCIN.

gurlcin_081100_04.sql Inserts table and column comments to GURLCIN.

DML

The gtvlcini_081100.sql script delivers the following required Banner Localization Codes toGTVLCIN.

Localization Code Description

CALBCOM California Common

CALBFA California Finaid

CALBHR California HR

CALBSTU California Student

EGEN SC Global Web Service Interface Client

REPT California Report

SSEN SC Global Self Service Engine

XIGN SC International XML Import Tool

INTLSTU SC International Student Tracking

OIA SC India Office of International Affairs

DEEWR SC Australia DEEWR Reporting

TAC SC Australia Tertiary Admission Centre Data Load

CCV SC Australia Centrelink Student Collection

AVETIS SC Australia Reporting for Vocational Sector

CHESSN SC Australia CHESSN Management

AVETMISS SC Australia Vocational Education in Schools Data Load

INTRAK SC Australia International Student Tracking for Australasia

ARSMCT SC LatinAmerica ARSMCT Multi-Currency / Multi-Tax

ARBRA SC Brazil ARBRA Accounts Receivables for Brazil

STUAADM SC Brazil STUAADM APIs for Admission Process

STUABSC SC Brazil STUABSC Automatic Block Schedule Generation

STUFIMP SC Brazil STUFIMP End of Term Procedures

STUMECR SC Brazil STUMECR Education Ministry (MEC) Reports

STUPSEL SC Brazil STUPSEL Admissions Selection Process




STUREGP SC Brazil STUREGP Regulatory Procedures

BACS SC Europe BACS Direct Debit for the UK

CAO SC Europe CAO for Ireland

ECTS SC Europe ECTS

DIPLS SC Europe DIPLS Diploma Supplement

GRDS SC Europe Graduation Management

HESA SC Europe HESA for the UK

PROGCAT SC Europe PROGCAT Programme Catalogue and Fee Generation

SLC SC Europe SLC Student Loans Company for the UK

UCAS SC Europe UCAS for the UK

FCP SC Canada FCP Federal Contractors Program

NPYRE SC Canada NPYRE Non Payroll Year End Reporting

CSB SC Canada CSB Canada Savings Bond

PSIS SC Canada PSIS Statistics Canada Reporting

SWF SC Canada SWF Standard Workload Form

TD1 SC Canada TD1 Federal Provincial Personal Tax Exemption

TRIC SC Canada TRIC Tri Council Reporting for Canada

OCAS SC Canada OCAS - Ontario College Application Service

YREND SC Canada YREND Year End Reporting with HR

VOCAP SC Europe VOCAP Vocational Placements

STUDEMRE SC LatinAmerica STUDEMRE Admissions for Chile

STURUT SC LatinAmerica STURUT RUT Validation for Chile

ARSSDC SC LatinAmerica ARSSDC Sales Documents

FINACB SC LatinAmerica FINACB Accounting Books

FINACP SC LatinAmerica FINACP Accounting by PIDM

FINART SC LatinAmerica FINART Finance Accounting Reporting Tool

FINDIE SC LatinAmerica FINDIE Deferred Income and Expenses

FINIAJ SC LatinAmerica FINIAJ Inflation Adjustments

FINIUB SC LatinAmerica FINIUB Investment Under Budget

FINLAT SC LatinAmerica FINLAT Finance LatinAmerica

FINTXW SC LatinAmerica FINTXW Tax Withhold

HRPCON SC LatinAmerica HRPCON HR Connector




STULOCF SC LatinAmerica STULOCF Long Currency Fields

MEATA SC Middle East Air Ticket Administration for HR

MEEFA SC Middle East Education Fee Administration for HR

MEFWW SC Middle East Flexible Work Week for HR

HRLVE SC Middle East Leave for HR

ARMTAX SC Middle East Accounts Receivable Multi-Tax

MEOLA SC Middle East On Line Admissions for KSA

CHEDS SC Middle East CHEDS for UAE

MESCCOMM MESC Common

STUOSSR SC Brazil STUOSSR One Stop Services

BWGSRE SC LatinAmerica BWGSRE General Survey Engine

BWSTES SC LatinAmerica BWSTES Teaching Evaluation by Students

BWLCMX SC LatinAmerica BWLCMX Conflict Matrix

BWSPBR SC LatinAmerica BWSPBR Program Based Registration

STUBIBL SC Brazil STUBIBL Bibliography

STUSEATT SC LatinAmerica STUSEAT Seat Management for Admissions

ARSAIP SC LatinAmerica ARSAIP Accounting Interface by Program

HRPDME SC LatinAmerica HRPDME Monthly Days

HRPSAE SC LatinAmerica HRPSAE Payroll Special Average Earnings

TCCSTU TCC Student

TCCFIN TCC Finance

TCCHR TCC Human Resources

TCCFA TCC Financial Aid

AMELLN SC Australia Adult Migrant English Program Language

ARTS SC Australia Automatic Results Transfer File Processing

FINIFRS SC LatinAmerica FINIFRS International Financial Standards

STUFAVL SC Brazil STUFAVL Partial Time Faculty Unavailability

T2202A SC Canada T2202A - Amounts Certificate

PL/SQL script

This script delivers a new function to find if the institution has a Banner Localization Inventory.



Script Description

guflcin.sql New function: F_FindLocalizationInstalled


Database support for Application Navigator

Database support for Application NavigatorThis release introduces database modifications to support Application Navigator featuredevelopment.


Modified table

This release delivers a new column to the Object Maintenance (GUBOBJS) table.

This new column is an indicator used for integrating user preference menu choices.


GUBOBJS_INTEGRATED_MENU_IND NOTNULL

VARCHAR2(1) Indicates the BannerObject is currentlyused by the integratedmenu to supportAdministrativeUsers with tools likeApplication Navigator.

The default value is N.

New scripts

This release delivers new scripts to add the new column to the Object Maintenance (GUBOBJS)table.

Script Description

gubobjs_081100_01.sql Adds new column GUBOBJS_INTEGRATED_MENU_IND.

gubobjs_081100_02.sql Add comment on column GUBOBJS_INTEGRATED_MENU_IND.


Database support for Action Item Processing enhancement

Database support for Action Item Processingenhancement

This release delivers new database object to support Action Item Processing to allow review ofaction items.

This enhancement enables designating actions items as requiring review before marking themcomplete. This allows action item reviewers to view these action items and mark them as reviewed.


Modified tables

This release delivers the following modified tables to support Action Item Processing.

Action Item Post (GCBAPST) table

This release introduces two new columns for storing Date and Time and Time Zone


GCBAPST_DISPLAY_DATE NULL DATE Date and time of ActionItem Post.

GCBAPST_TIME_ZONE NULL VARCHAR2(100) Time Zone for Action ItemPost

Action Item Page Builder Template (GCBPBTR) table

This release introduces a new column for Template Description.


GCBPBTR_DESCRIPTION NULL CLOB Description of page buildertemplate.



Assigned Action Item (GCRAACT) table

This release introduces two new columns to store the response ID from the Action Item status Rule(GCRAISR) and Action Item Review Status (GTVRVST) tables.


GCRAACT_GCRAISR_ID NULL NUMBER(19,0) ID of response selectedby the user for the actionitem.

GCRAACT_RVST_CODE NULL VARCHAR2(10) Code that indicates statusof the action item reviewprocess. Set to NULLwhen the action item is notin review.

Action Item Status Rule (GCRAISR) table

This release introduces two new columns to store Review Required Indicator and Number OfAttachments Allowed.


GCRAISR_REV_REQ_IND NOTNULL

VARCHAR2(1) Response requires reviewindicator.

GCRAISR_ALLOWED_ATTACHMENT NOTNULL

NUMBER(3,0) Number of attachmentsallowed for a response.

New tables

This release delivers six new tables to support Action Item Processing to allow review of actionitems.

Action Item Review Audit (GCBRAUD) table

This table stores details about reviews completed in Action Item processing. These reviews arespecific for a user's Action Item and response. You cannot update a review after it is saved.


GCBRAUD_SURROGATE_ID NOTNULL

NUMBER(19,0) Immutable unique key.

GCBRAUD_GCRAACT_ID NOTNULL

NUMBER(19,0) Surrogate ID of GCRAACTtable which contains actionitems assigned to users.




GCBRAUD_GCRAISR_ID NOTNULL

NUMBER(19,0) Surrogate ID of GCRAISRtable which points to userresponse for the actionitem.

GCBRAUD_REVIEWER_PIDM NOTNULL

NUMBER(8,0) Internal identificationnumber of the reviewer.

GCBRAUD_REVIEW_DATETIME NOTNULL

TIMESTAMP(9) Date and time the reviewwas done.

GCBRAUD_RVST_CODE NOTNULL

VARCHAR2(10) Review status codechosen by the reviewer aspart of the review.

GCBRAUD_EXTERNAL_COMMENT_IND NOTNULL

VARCHAR2(1) External commentindicator.

• N: Comment is internalto reviewers.

• Y: Comment isexternal to users.

GCBRAUD_USER_ID NOTNULL

VARCHAR2(30) This field identifies thesystem user.

GCBRAUD_ACTIVITY_DATE NOTNULL

DATE The date on whichinformation was lastentered or updated for thisrecord.

GCBRAUD_REVIEW_COMMENTS NULL VARCHAR2(4000) Comment provided byreviewer as part of thereview.

GCBRAUD_CONTACT_INFO NULL VARCHAR2(200) Office or person to contactabout review status.

GCBRAUD_VERSION NULL NUMBER(19,0) Optimistic lock token.

GCBRAUD_DATA_ORIGIN NULL VARCHAR2(30) The source system thatcreated or updated thedata.

GCBRAUD_VPDI_CODE NULL VARCHAR2(6) Multi-entity processingcode.



AIP Document Metadata (GCRAFLU) table

This table stores information about an uploaded document.


GCRAFLU_SURROGATE_ID NOTNULL


GCRAFLU_GCRAACT_ID NOTNULL

NUMBER(19,0) Surrogate ID ofGCRAACT table thatcontains action itemsassigned to users.

GCRAFLU_GCRAISR_ID NOTNULL

NUMBER(19,0) Surrogate ID of GCRAISRtable that contains currentresponse assigned toassociated action item.

GCRAFLU_DOCUMENT_NAME NOTNULL

VARCHAR2(60) Name of the uploadeddocument.

GCRAFLU_DOCUMENT_UPLOADED_DATE

NOTNULL

DATE The date and time of thedocument upload.

GCRAFLU_FILE_LOCATION NOTNULL

VARCHAR2(3) File storage locationvalue.

• AIP: Indicatesfile saved to theGCRAFCT table.

• BDM: Indicatesfile saved inApplicationXtender.

GCRAFLU_USER_ID NOTNULL

VARCHAR2(30) The user ID of the personwho inserted or lastupdated this record.

GCRAFLU_ACTIVITY_DATE NOTNULL


GCRAFLU_USER_COMMENTS NULL VARCHAR2(4000)Comments provided byuser about the uploadedfile.

GCRAFLU_DELETE_AFTER_DATE NULL DATE The calculated deletiondate of the physical fileand database row basedon date created andstorage days value.




GCRAFLU_STORAGE_DAYS NULL NUMBER(4,0) Maintain file in storagesystem for number of daysafter file is created

GCRAFLU_VERSION NULL NUMBER(19,0) Optimistic lock token.

GCRAFLU_DATA_ORIGIN NULL VARCHAR2(30) Source system thatcreated or updated thedata.

GCRAFLU_VPDI_CODE NULL VARCHAR2(6) Multi-entity processingcode.

AIP Document Content (GCRAFCT) table

This table stores the content of the uploaded document, if you have configured the system to do so.


GCRAFCT_SURROGATE_ID NOTNULL


GCRAFCT_GCRAACT_ID NOTNULL

NUMBER(19,0) Surrogate ID of theGCRAFLU table whichcontains the metadata ofthe file.

GCRAFCT_USER_ID NOTNULL


GCRAFCT_ACTIVITY_DATE NOTNULL


GCRAFCT_DOCUMENT_CONTENT NULL BLOB Content of uploadeddocument.

GCRAFCT_VERSION NULL NUMBER(19,0) Optimistic lock token.

GCRAFCT_DATA_ORIGIN NULL VARCHAR2(30) The source system thatcreated or updated thedata.

GCRAFCT_VPDI_CODE NULL VARCHAR2(6) Multi-entity processingcode.



Action Item Review Status Validation (GTVRVST) table

Validation table containing the valid values for review status codes. Review status codes control theflow of a review.


GTVRVST_CODE NOTNULL

VARCHAR2(10) Unique Code for theReview Status.

GTVRVST_DESC NOTNULL

VARCHAR2(30) Describes the purpose ofa Review Status.

GTVRVST_ACTIVE_IND NOTNULL

VARCHAR2(1) Indicator for Active ReviewStatus. Values are (Y)esand (N)o.

GTVRVST_SURROGATE_ID NOTNULL


GTVRVST_USER_ID NOTNULL


GTVRVST_ACTIVITY_DATE NOTNULL


GTVRVST_VERSION NULL NUMBER(19,0) Optimistic lock token.

GTVRVST_DATA_ORIGIN NULL VARCHAR2(30) The source system thatcreated or updated thedata.

GTVRVST_VPDI_CODE NULL VARCHAR2(6) Multi-entity processingcode.

Default Action Item Review Status (GCRRVSD) table

This table contains the valid value of the institution's default review status.


GCRRVSD_SURROGATE_ID NOTNULL


GCRRVSD_RVST_CODE NOTNULL

VARCHAR2(10) Default Review StatusCode.

GCRRVSD_USER_ID NOTNULL





GCRRVSD_ACTIVITY_DATE NOTNULL


GCRRVSD_VERSION NULL NUMBER(19,0) Optimistic lock token.

GCRRVSD_DATA_ORIGIN NULL VARCHAR2(30) The source system thatcreated or updated thedata.

GCRRVSD_VPDI_CODE NULL VARCHAR2(6) Multi-entity processingcode.

Action Item Review Status Rule (GCRRVST) table

This table contains the locale-specific names of the status codes, in addition to the processing flags.


GCRRVST_SURROGATE_ID NOTNULL


GCRRVST_RVST_CODE NOTNULL

VARCHAR2(10) Unique Code for theReview Status.

GCRRVST_RVST_NAME NOTNULL

VARCHAR2(30) Name of the ReviewStatus.

GCRRVST_LOCALE NOTNULL

VARCHAR2(20) Locale for multiplelanguage support.

GCRRVST_REVIEW_ONGOING_IND NOTNULL

VARCHAR2(1) Indicator that the revieweris reviewing the response.A value of Y locks actionitem and a value of Nunlocks action item forresubmission of response.

GCRRVST_REVIEW_SUCCESS_IND NOTNULL

VARCHAR2(1) Indicator that review wassuccessful. A value ofN halts a process and avalue of Y lifts the halt.

GCRRVST_USER_ID NOTNULL


GCRRVSD_ACTIVITY_DATE NOTNULL


GCRRVSD_VERSION NULL NUMBER(19,0) Optimistic lock token.




GCRRVSD_DATA_ORIGIN NULL VARCHAR2(30) The source system thatcreated or updated thedata.

GCRRVSD_VPDI_CODE NULL VARCHAR2(6) Multi-entity processingcode.

New scripts

This release delivers new scripts to support Action Item Processing.

DDL scripts

Script Description

gcbapst_081100_01.sql Adds two columns to the GCBAPST table

gcbapst_081100_02.sql New column comments to GCBAPST

gcbpbtr_081100_01.sql Adds a column to the GCBPBTR table

gcbpbtr_081100_02.sql New column comments to GCBPBTR

gcraact_081100_01.sql Adds two columns to the GCRAACT table

gcraact_081100_02.sql Adds foreign key constraint to table GCRAACT

gcraact_081100_03.sql Adds foreign key constraint to table GCRAACT

gcraact_081100_04.sql New column comments to GCRAACT

gcraisr_081100_01.sql Adds two columns to the GCRAISR table

gcraisr_081100_02.sql New column comments to GCRAISR

gcbraud_081100_01.sql Creates table GCBRAUD.

gcbraud_081100_02.sql Adds primary key constraint to table GCBRAUD.

gcbraud_081100_03.sql Adds foreign key constraint to table GCBRAUD.



gcbraud_081100_06.sql Adds column comments to GCBRAUD.

gcraflu_081100_01.sql Creates table GCRAFLU.

gcraflu_081100_02.sql Adds primary key constraint to table GCRAFLU.

gcraflu_081100_03.sql Adds foreign key constraint to table GCRAFLU.





Script Description

gcraflu_081100_06.sql Adds column comments to GCRAFLU.

gcrafct_081100_01.sql Creates table GCRAFCT.

gcrafct_081100_02.sql Adds primary key constraint to table GCRAFCT.

gcrafct_081100_03.sql Adds foreign key constraint to table GCRAFCT.

gcrafct_081100_04.sql Adds column comments to GCRAFCT.

gtvrvst_081100_01.sql Creates table GTVRVST.

gtvrvst_081100_02.sql Adds primary key constraint to table GTVRVST.

gtvrvst_081100_03.sql Creates unique index for table GTVRVST.

gtvrvst_081100_04.sql Adds column comments to GTVRVST.

gcrrvsd_081100_01.sql Creates table GCRRVSD.

gcrrvsd_081100_01.sql Adds primary key constraint to table GCRRVSD.

gcrrvsd_081100_01.sql Create unique index for table GCRRVSD.

gcrrvsd_081100_01.sql Adds column comments to GCRRVSD.

gcrrvst_081100_01.sql Creates table GCRRVST.

gcrrvst_081100_02.sql Adds primary key constraint to table GCRRVST

gcrrvst_081100_03.sql Create unique index for table GCRRVST.

gcrrvst_081100_04.sql Adds column comments to GCRRVST.

gos_gcraflu_seq.sql Create sequences to table GCRAFLU.

gos_gcrrvsd_seq.sql Create sequences to table GCRRVSD.

gos_gcrrvst_seq.sql Create sequences to table GCRRVST.

gos_gtvrvst_seq.sql Create sequences to table GTVRVST.

gos_gcbraud_seq.sql Create sequences to table GCBRAUD.

gos_gcrafct_seq.sql Create sequences to table GCRAFCT.

DML script

Script Description

ggubmepoi_081100.sql Enables MEP.

DBPROC package

The GCKPACT package used for posting of an action item to the user.

Package Description

GCKPACT Added f_post_action_item to posting of an action item to the user.



DBPROC scripts

Script Description

gckpact0.sql Package used for posting of an action item to the user.

gckpact1.sql Package body used for posting of an action item to the user.

gt_gcrrvsd_surrogate_id.sql Adding new trigger for gcrrvsd sequence and version.

gt_gcrrvst_surrogate_id.sql Adding new trigger for gcrrvst sequence and version.

gt_gtvrvst_surrogate_id.sql Adding new trigger for gtvrvst sequence and version.

gt_gcbraud_surrogate_id.sql Adding new trigger for gcbraud sequence and version.

gt_gcrafct_surrogate_id.sql Adding new trigger for gcrafct sequence and version.

gt_gcraflu_surrogate_id.sql Adding new trigger for gcraflu sequence and version

gctrvsd0.sql Insert trigger on Default Review Status table (GCRRVSD), tomake sure table has only one record.

gctrvsd1.sql Delete trigger on Default Review Status table (GCRRVSD),to make sure table always has one record.


Database support for Banner Communication Management

Database support for Banner CommunicationManagement

This release delivers new and modified tables, views and other database objects to support theBanner General Communication Management 9.5 release.

These new tables and procedures are a required component of Communication Management tosupport recurrent scheduling of communications, one time scheduling of populations, performanceimprovements and other miscellaneous improvements.


New tables

The Banner General 8.11 release introduces three new tables to support Banner CommunicationManagement.

Recurring Scheduling for Communications (GCBCREC) table

This table defines a message entity scheduled for recurrence and the corresponding attributesrequired to create a background process for assembling and submitting a batch of communicationmessages through a channel provider.


GCBCREC_SURROGATE_ID NOTNULL

NUMBER(19) Generated unique numericidentifier for this entity.

GCBCREC_JOB_NAME NOTNULL

VARCHAR2(2048) Name describing thisrecurrent schedulemessage.

GCBCREC_CREATOR_ID NOTNULL

VARCHAR2(30) The oracle user id of theuser who created thisrecord.

GCBCREC_CREATIONDATETIME NOTNULL

TIMESTAMP(6) The date and time ofcreation.

GCBCREC_CRON_STRING NOTNULL

VARCHAR2(255) Cron String that satisfiesthe Quartz rules whichrepresents the schedule ofthe recurrence.

GCBCREC_CRON_TIMEZONE NOTNULL

VARCHAR2(255) Timezone against whichthe cron string should bevalidated and fired.




GCBCREC_ORGANIZATION_ID NOTNULL

NUMBER(19) The surrogate id of theorganization that thismessage belongs to.

GCBCREC_POPL_ID NOTNULL

NUMBER(19) The populationidentification number.

GCBCREC_TEMPLATE_ID NOTNULL

NUMBER(19) The template identificationnumber.

GCBCREC_RECALC_ON_SEND NOTNULL

VARCHAR2(1) Indicates if the chosenpopulation needsrecalculation before atthe time of sending eachrecurrent message.

GCBCREC_CURRENT_STATE NOTNULL

VARCHAR2(255) The current state of theprocess.

GCBCREC_ACTIVITY_DATE NOTNULL

DATE Date that record wascreated or last updated.

GCBCREC_USER_ID NOTNULL

VARCHAR2(30) The user ID of the personwho created or lastupdated this record.

GCBCREC_JOB_DESCRIPTION NULL VARCHAR2(2048) Description of thisrecurrent schedulemessage.

GCBCREC_JOB_ID NULL VARCHAR2(64) The job id of thescheduled job.

GCBCREC_GROUP_ID NULL VARCHAR2(256) The group id for thescheduled quartz job ortrigger.

GCBCREC_ERROR_CODE NULL VARCHAR2(256) The error code of anyerror generated duringprocessing.

GCBCREC_ERROR_TEXT NULL CLOB The full text of anyerror generated duringprocessing.

GCBCREC_START_DATE NULL TIMESTAMP(6) The date from when theprocess can be run asper the cron expressionoccurrence.

GCBCREC_END_DATE NULL TIMESTAMP(6) The date beyond whichthe process should not berun.

GCBCREC_STOPPED_DATE NULL TIMESTAMP(6) The date the process wasstopped.




GCBCREC_EVENT_ID NULL NUMBER(19) The ID of the Event thatgenerated the recurrentscheduled message.

GCBCREC_PARAMETER_VALUES NULL CLOB The map of parametername and values for thecorresponding template.

GCBCREC_NUM_OCCURRENCES NULL NUMBER(19) The total number of timesthe scheduled messageshould be executed.

GCBCREC_TOTAL_COUNT NULL NUMBER(19) The total number of timesthe scheduled messagehas been executed.

GCBCREC_SUCCESS_COUNT NULL NUMBER(19) The number of timesthe scheduled messagehas been executedsuccessfully.

GCBCREC_FAILURE_COUNT NULL NUMBER(19) The number of times theexecution of scheduledmessage failed.

GCBCREC_VERSION NULL NUMBER(19) Optimistic lock token.

GCBCREC_DATA_ORIGIN NULL VARCHAR2(30) Source system thatcreated or updated thedata.

GCBCREC_VPDI_CODE NULL VARCHAR2(6) Multi-entity processingcode.

Text Message Communications Template (GCBTMTL) table

This table extends the Template object (GCBTMPL) table. It describes the place holders for a textmessage created using the template.

Do not modify this table outside the context of a template object.


GCBTMTL_SURROGATE_ID NOTNULL

NUMBER(19) Generated uniquenumeric identifier for thisGCBTMPL.

Note: This is both a PKand FK to the GCBTMPL.




GCBTMTL_USER_ID NOTNULL

VARCHAR2(30) The user Id of the personwho inserted or lastupdated the record.

GCBTMTL_ACTIVITY_DATE NOTNULL


GCBTMTL_TOLIST NULL VARCHAR2(1020) The list of recipient phonenumbers.

GCBTMTL_MESSAGE NULL CLOB The content of the textmessage.

GCBTMTL_FOOTER NULL CLOB The footer of the textmessage.

GCBTMTL_DESTINATION_LINK NULL CLOB A url associated with themessage.

GCBTMTL_DESTINATION_LABEL NULL CLOB A label describing thedestination link.

GCBTMTL_VERSION NULL NUMBER(19) Optimistic lock token.

GCBTMTL_DATA_ORIGIN NULL VARCHAR2(30) Source system thatcreated or updated thedata.

GCBTMTL_VPDI_CODE NULL VARCHAR2(6) Multi-entity processingcode.

Communications Text Message Item (GCRTITM) table

This table describes the place holders of a text message created using the template. This extendsthe Communication Item (GCRCITM) object.

Do not modify this table outside the context of a communication item.

Column Null? Type Description

GCRTITM_SURROGATE_ID NOTNULL

NUMBER(19) Generated unique numericidentifier for this entity.

GCRTITM_USER_ID NOTNULL

VARCHAR2(30) The user Id of the personwho inserted or lastupdated the record.

GCRTITM_ACTIVITY_DATE NOTNULL




Column Null? Type Description

GCRTITM_RESPONSE NULL CLOB Response headers thatwere captured from asuccessful posting ofthe notification in JSONformat.

GCRTITM_CONTENT NULL CLOB CONTENT: The contentthat is included in themessage.

GCRTITM_TOLIST NULL VARCHAR2(1020) The list of people receivingthis message.

GCRTITM_VERSION NULL NUMBER(19) Optimistic lock token.

GCRTITM_DATA_ORIGIN NULL VARCHAR2(30) Source system thatcreated or updated thedata.

GCRTITM_VPDI_CODE NULL VARCHAR2(6) Multi-entity processingcode.

Modified tables

This release delivers the following two modified tables to support the Banner GeneralCommunication Management 9.5 release.

Group Send (GCBGSND) table

This release delivers two new columns to GCBGSND.


GCBGSND_CUMULATIVE_STATE NULL VARCHAR2(255) Indicates the status of thegroup send taking intoaccount the statuses ofthe corresponding jobsand the group send items

GCBGSND_CREC_ID NULL NUMBER(19) Indicates the parentrecurring schedulemessage record id thatcreated the group send.



Population (GCBPOPL) table

This release delivers two new columns to GCBPOPL.


GCBPOPL_SCHEDULED_DATE NULL TIMESTAMP(6) Scheduled date for thefirst time populationcalculation.

GCBPOPL_STATUS NULL VARCHAR2(30) Status of the population -Values will be Scheduledor null.

New scripts

The Banner General 8.11 release delivers new scripts to support the Banner CommunicationManagement 9.5 release.

DDL

Field Description

gcbcjob_081100_01.sql Creates an index for the activity date column of theCommunication Job Table.

gcbcrec_081100_01.sql Creates the GCBCREC table to store the recurrent messages forcommunications.

gcbcrec_081100_02.sql Creates the Primary Key constraint for the GCBCREC table.

gcbcrec_081100_03.sql Creates an index on the Creator Id column of the GCBCRECtable.

gcbcrec_081100_04.sql Creates an index on the current state column of the GCBCRECtable.

gcbcrec_081100_05.sql Creates an index on the Job Name column of the GCBCRECtable.

gcbcrec_081100_06.sql Creates a foreign key constraint on the Organization Id columnof the GCBCREC table.

gcbcrec_081100_07.sql Creates a foreign key constraint on the Population Id column ofthe GCBCREC table

gcbcrec_081100_08.sql Creates a foreign key constraint on the Template Id column ofthe GCBCREC table.

gcbcrec_081100_09.sql Creates a foreign key constraint on the Event Id column of theGCBCREC table.

gcbcrec_081100_10.sql Creates comments for the GCBCREC table and all the columns



Field Description

gcbevmp_081100_01.sql Refactor index and migration script

gcbevmp_081100_02.sql Migration script before creating unique index.

gcbevmp_081100_03.sql Script to create unique index for Event Name.

gcbgsnd_081100_01.sql Adds a cumulative state column to the Group Send Table.

gcbgsnd_081100_02.sql Migration script to update existing rows in the table with acumulative state.

gcbgsnd_081100_03.sql Adds comments for the new cumulative state and recurrentmessage Id columns.

gcbgsnd_081100_04.sql Refactor Index on job name.

gcbgsnd_081100_05.sql Creates new index on job name.

gcbpopl_081100_01.sql Adds new columns for scheduled status and status for thePopulation table.

gcbpopl_081100_02.sql Adds comments for the new columns of Population table.

gcbpopl_081100_03.sql Refactor Index for Population table.

gcbpopl_081100_04.sql Migration script before creating unique index.

gcbpopl_081100_05.sql Creates unique index for Population table.

gcbpopl_081100_06.sql Create index for Population table.

gcbqury_081100_01.sql Refactor indexes and migration script.

gcbqury_081100_02.sql Migration script before creating unique index.

gcbqury_081100_03.sql Creates unique index for Population Query table.

gcbqury_081100_04.sql Create index for Population Query table.

gcbtmpl_081100_01.sql Refactor indexes and migration script.

gcbtmpl_081100_02.sql Migration script before creating unique index

gcbtmpl_081100_03.sql Creates unique index for Template table.

gcbtmpl_081100_04.sql Creates index for Template table.

gcbtmtl_081100_01.sql Creates new table GCBTMTL for Communication Text MessageTemplates.

gcbtmtl_081100_02.sql Create primary key for GCBTMTL table.

gcbtmtl_081100_03.sql Creates foreign key constraint for the GCBTMTL table.

gcbtmtl_081100_04.sql Adds comments on the GCBTMTL table and all columns.

gcrfldr_081100_01.sql Refactor indexes and migration script

gcrfldr_081100_02.sql Migration script before creating unique index

gcrfldr_081100_03.sql Creates unique index for GCRFLDR table.



Field Description

gcrgsim_081100_01.sql Refactor indexes and migration script.

gcroran_081100_01.sql Refactor indexes and migration script.

gcroran_081100_02.sql Migration script before creating unique index.

gcroran_081100_03.sql Creates unique index for Organization table.

gcrtitm_081100_01.sql Creates new table GCRTITM for storing Communication TextMessage Items.

gcrtitm_081100_02.sql Create primary key constraint for Communication Text MessageItem table.

gcrtitm_081100_03.sql Creates foreign key constraint for Communication Text MessageItem table.

gcrtitm_081100_04.sql Script to create comments for Communication Text MessageItem table and all columns.

gos_gcbcrec_seq_081100.sql Sequence for GCBCREC table

DML

Field Description

gcbqury_081100.sql Migrate Creator field data

gcrmint_081100.sql Migrate creator field data

ggubmepoi_081100.sql Add the new tables for MEP

groles_081100.sql Add additional table grants to delivered roleBAN_DEFAULT_CMQUERYEXECUTE_M

DBPROCS

Field Description

gckextr0.sql Update methods to handle new data source user ids.

gckextr1.sql Update methods to handle new data source user ids

gctcrec0.sql Trigger on GCBCREC table for version and surrogate id column.

gctqrtz_job_details0.sql Pre-delete trigger for GCRQRTZ_JOB_DETAILS table to updaterecurrent message job, group to null and status to Complete ifexecutions complete successfully.

gokmept1.sql Enable support for unique functional based indexes.

gspsecr.sql Update the package to add COMMMGR user to list of specialusers for Banner 9 self service processing.



New views

This release delivers the following scripts.

The delivered scripts create the following new views:

• GVQ_GCBCREC• GVQ_JOBS_DETAIL• GVQ_JOBS_LIST

Field Description

gvq_gcbcrec.sql View for the recurrent message object.

gvq_jobs_detail.sql View for the Communication jobs detail object.

gvq_jobs_list.sql View for the Communication Jobs List object.

Modified views

This release delivers four views scripts.

The delivered views scripts modify the following views:

• GVQ_GCRGSIM• GVQ_GCRCITM• GVQ_GCBPOPL• GVQ_ERROR_LOG

Field Description

gvq_gcrgsim.sql Updated view to show stop date based on gcrgsim and gcbcjobcurrent state.

gvq_gcrcitm.sql Updated view to list the communication log even when thecorresponding template gets deleted.

gvq_gcbopl_detail.sql Updated view to get the population status if there is a scheduledpopulation calculation.

gvq_error_log.sql Optimized the view for performance.


Resolutions

ResolutionsA Resolution Report contains comprehensive and detailed resolution information for a release.

Each change request has a listed URL. Copy and paste the URL into a web browser to see moredetails about the change request on the Ellucian Customer Center. For resolution information in thisrelease, see Banner General Resolutions Report 8.11 in the Documentation Libraries section underBanner General in the Ellucian Customer Center.
