Jackson Community College

Change Request............: 37492.74

Summary...................: FA DMI Style-sheet update for 2008/2009 COD Processing

Criticality...............: Release

Status....................: Complete

Date Completed............: 4/30/2008

Impact....................:

Priority..................: A

Project...................:

Main Release ID...........:

Application...............: FA

Module Name...............: FA

Mnemonic..................:

Regulatory Enhancements...: Yes

Problem/Issue.............:

Several edits have been introduced by the Department of Education that relate to unsubsidized funding and require a modification to the style-sheets used in the exporting of information to COD.

Resolution................:

The DMI style-sheets used for COD processing have been modified to consider the Additional Unsubsidized Indicator, the Dependency Status, the Grade Level, and the award amount to support the new COD edits related to unsubsidized funding.  In addition, changes have been made to prevent the sending of hyphens in the Address Postal Code field for both the student and the parent borrower.

Client Impact.............:

CLIENT IMPACT

Once clients have loaded the 2008/2009 COD Release (36662.85), they use this style-sheet update to begin processing additional unsubsidized loans.

IMPLEMENTATION INSTRUCTIONS

Not applicable.

TECHNICAL IMPLEMENTATION

Not applicable.

NEW FORMS

Not applicable.

CUSTOM IMPACT

Not applicable.

Description...............:

4/30/08  UPDATE - This release is now available

***********************************************

SU37492.74-4.1.0*345

***********************************************

This DMI update delivers an updated style sheet for DL loan processing.  This new stylesheet is necessary for sending loan records to COD for the 2008/2009 processing year.

Change Request............: 35965.37

Summary...................: TXST 2008 CBM009/CBM00M Maintenance Update

Criticality...............: Release

Status....................: Complete

Date Completed............: 4/30/2008

Impact....................:

Priority..................: A

Project...................:

Main Release ID...........:

Application...............: STSTATE

Module Name...............: TXST

Mnemonic..................: EVCC, BGWF, PGWF, CBME, TSTU, TXGW

Regulatory Enhancements...:

Yes

Problem/Issue.............:

Clients reported several issues and enhancement requests for the Graduation (CBM009) Report and Marketable Skills Achievement (CBM00M) Report programs in the Texas State Reporting - Student (TXST) optional module.  See the Description section for a list of the change requests resolved in this update.

Resolution................:

This software update resolves several issues and delivers a number of enhancements to the Graduation (CBM009) Report and Marketable Skills Achievement (CBM00M) Report programs in the Texas State Reporting - Student (TXST) optional module.  See the Description section for more information about the issues resolved with this software update.

Client Impact.............:

CLIENT IMPACT

The Texas State Reporting - Student (TXST) optional module now reports Graduation and Marketable Skills Achievement data more accurately and reliably.

IMPLEMENTATION INSTRUCTIONS

The file translation tables TXST.CCDS and TXST.DEGREES must be updated with proper level of award for each certificate or degree to be reported in Item #8 on the CBM009 Report.

For certificates:

-     Access the TXST.CCDS table on the File Translation Tables (FLTT) form.

-     For each certificate in the table, enter the appropriate level of award in the first Special Processing column.

-     Any certificate in the table with no level of award will be reported as 2 - Certificate.

-     Finish to save changes.

For degrees:

-     Access the TXST.DEGREES table on the FLTT form.

-     For each degree in the table, enter the appropriate level of award in the first Special Processing column.

-     Any degree in the table with no level of award will be reported as 1 - Associate.

-     Finish to save changes.

TECHNICAL IMPLEMENTATION

Not applicable

NEW FORMS

Not applicable

CUSTOM IMPACT

Not applicable

SOFTWARE PARTNER

Not applicable

Description...............:

04/30/08 -- The following software update has been released and is available to Clients:

****************************

SU35965.37-1805*07

**************************** 

This software update delivers several corrections and enhancements to the Graduation (CBM009) Report and Marketable Skills Achievement (CBM00M) Report programs in the Texas State Reporting - Student (TXST) optional module. 

The following AnswerNet change requests are resolved with this update:

27857.22 - CBM00M/CBME formatting CIP incorrectly The CBM00M Export (CBME) process was modified to format the data reported in Item #9 "Major - CIP Code" correctly in the export file.  It is now left justified and zero-filled per the report specifications.

26952.89 - TXST: Assigning wrong award level to CCD that begins with 'A'

The CBM009 Export (CB9E) process and the Texas Report Grad Work File (TXGW) process now translate the award level for certificates and degrees using translation tables instead of using the first character of the code to determine the level of award.  See the Client Impact Implementation Instructions for information on updating the appropriate file translation tables with award levels.

35454.85 - CBM009 award level table needs updating The TXST.CBM009.AWARD.LEVELS validation code table was updated to meet current specifications for award levels to be reported on the CBM009 Report.

12733.96 - TXST: PGWF writing incorrect key to ST.TX.CRS.STATUS file The Purge Graduation Work File (PGWF) process now writes the status file keys correctly so that the work file status may be reliably tracked for each report year and period.

18110.15 - BGWF - problem in TXSTB004B core completers The Build Graduation Work File (BGWF) process no longer terminates when it encounters a student program missing a CIP code.  It now issues a warning message for the student and continues processing any remaining core curriculum completer students.

37575.96 - CBM002 programs calling IPEDS subroutine The BGWF and TXGW processes were changed to use the Texas-specific subroutine for retrieving a student's active academic program rather than the subroutine created for federal IPEDS reporting.

17916.44 - BGWF doesn't produce error report The BGWF process was corrected to automatically print or display any warnings and errors at completion. 

37598.52 - BGWF needs additional savedlist for core completers The BGWF process populates the graduation work file for both gradates and core curriculum completers, both of which are reported on the CBM009 report.  The process was modified to allow use of a separate savedlist for the two groups of students being reported.

37596.37 - Dates on BGWF should be Academic/Reporting Year The BGWF form has been modified to default the academic year start and end dates based on the reporting year entered for processing.  The dates used for running the CBM009 and CBM00M reports cover the state of Texas fiscal and academic year which runs from September 1 through August 31, ending on August 31 of the reporting year. 

17718.26 - TXST:  EVCC needs catalog year The Evaluate Core Completers (EVCC) process now accepts an optional parameter field to specify a catalog for use when evaluating students against the core curriculum academic program.  If the catalog parameter is blank, the EVCC process will continue to use the most recent catalog from the core curriculum academic program that was entered on the Texas Grad Report Parameters (TGRP) form.

6680.19 - TXST CBM009 Updates

The EVCC process now accepts an optional institution parameter field to override the student's core curriculum completer location.  If the institution parameter is blank, the EVCC process determines the location using the first department of the student's active academic program.  The core curriculum completer institution is stored in a new TXST.STUDENTS field, which was added to the Texas Student Information (TSTU) form.  The new institution field is now used by the BGWF process when building the graduation work file.

Change Request............: 36662.85

Summary...................: 2008/2009 COD Processing

Criticality...............: Release

Status....................: Complete

Date Completed............: 4/30/2008

Impact....................:

Priority..................:

Project...................:

Main Release ID...........:

Application...............: FA

Module Name...............: FA

Mnemonic..................:

Problem/Issue.............:

Regulatory updates were needed in Colleague to be able to process COD information for 2008/2009.  Clients reported a number of issues with the software.  See the Description section for more information about the issues resolved with this software update.

Resolution................:

This software update provides regulatory enhancements for processing COD information for 2008/2009.

This software update also resolves several change requests.  See the Description section for a list of the resolved change requests. See the 2008/2009 COD Processing Release Highlights, available for download at www.datatel.com/documentation, for complete details about this software update.

Client Impact.............:

Clients can now begin processing of 2008/2009 COD information in Colleague.

For more information about the benefits of this software update, see the 2008/2009  COD Processing Release Highlights, available for download from www.datatel.com/documentation.

IMPLEMENTATION INSTRUCTIONS

Not applicable.

TECHNICAL IMPLEMENTATION

Not Applicable.

NEW FORMS

Not applicable.

CUSTOM IMPACT

Not Applicable.

SOFTWARE PARTNER

Not Applicable.

Description...............:

04/30/08 - Update - The following R18 update is available

********************************************************************

SU36662.85-1805*09

********************************************************************

This is the main release to begin COD processing for the 2008/2009 Financial Aid award year. 

NOTE:

Before loading this software release, you must install the following software updates:

SU37453.52-1805*03   

SU37492.74-4.1.0*345  

Software update SU37492.74-4.1.0*345 requires that schools already have DMI 4.1.0 installed.

(DMI 4.1.0 contains updates to the Financial Aid stylesheets used in Release 18 for communicating with the COD System.) 

This software update resolves the following change requests:

33864.37    - The AGRI form was modified to allow access only when detailed from the

                         Grant COD Inquiry (GCOD) form.

29938.63    - Both the DL COD Inquiry (DCOD) and Grant COD Inquiry (GCOD) forms were

                          modified to include only accepted imported disbursements in the calculation

                          of the COD Amt field.

31369.37    - The Sent Amount on both the DL COD Award Disbursements (DLDS) and DL

                          COD History Summary (DLHS) forms have been modified to correctly show

                          zero amounts when appropriate.

35874.15    - The description for the MPNDISOP message class has been updated to

                         "MPN Discharge Report" and the message classes MPNINAOP and MPNEXPOP

                          have been created.

35906.85    - The FA Institutional Defaults (FIDF) and FA Office parameters (FAOP) forms, 

                        in addition to several subroutines, have been modified to accept and validate the new

                         format of the TG number.

16233.93    - The total field on the Pell Upcoming Disbursements (PLUD) report has been

                        expanded to handle larger values.

35403.48    - The COD Export (CODE) process was modified to allow for selection of students

                         who only have a particular type of award like Pell, DL, or Grant thereby limiting the

                        type of errors generated by the process.

36908.56    - Online help has been added to the Dependent Student DNW Percent, the Independent

                         Student with Dependents DNW Pct and the Independent Student w/o Dependents

                        DNW Pct fields on the Supplemental Calc Parameters (SCPM) form.

15713.22    - The Application Workflow Choices (NAWC) form will now generate a message whenever

                         the transaction being compared matches the federally flagged transaction indicating that

                         no comparison is needed.

34631.22    - The subroutines used to transmit Financial Aid award information to Accounts Receivable have

                         been corrected to prevent uninitialized error messages.

32377.15    - Colleague now determines the Fee percent based on the initial transmittal date of the first

                        disbursement.

34414.04    - The Pell Reporting Campus, Pell Entity ID, and DL School Code fields have been removed

                         from the COD Institutional Defaults (CSID) and the FA Office COD Parameters (CSOF) forms.

                      They were no longer needed.

35889.52    - The CODE process has been modified to consider the Additional Unsubsidized Indicator,

                         the Dependency Status, the Grade level and award amount to honor the new COD edits

                         related to additional unsubsidized funding.

.37624.26  -  The CODE export process has been modified to prevent the sending of duplicate

                         Pell information for a student.

37396.22    -  The CODE export process has been modified to prevent the sending of hyphens

                        in the Address Postal Code field.

38269.63    -  Message class records DLFFEXOP and DECFENOP can now be imported using

                        the Entrance/Exit Interview Import (DLEI) process.

37898.48    -  The Promissory Note Print (DLPN) process will now print a 2008 promissory note

                        for students with PLUS awards.

38577.52    - The flags used to specify whether additional unsubsidized awarding is appropriate

                        have been moved to the loan level (and related to a specific loan) instead of at the

                        student level.

The following regulatory changes have also been made:

35883.93    - Several  new records have been created in COD.REASONS for the 2008/2009 year.

35891.41    - The processes related to importing and exporting of COD data have been updated to include

                         new tag information related to ACG and SMART awards for the 2008/2009 year.

35893.37    - The parameters used to import Pell MRR records for 2008/2009 have been created.

35894.44    - The parameters used to import ACG and SMART MRR records for 2008/2009 have been created.

35900.07    - All new Rigorous High School program codes have been created for the 2008/2009 year.

36487.67    - A new computed column, TA.MPN.STATUS, has been created to allow clients to determine

                         a student's most recent MPN status.

37488.22    - New Comment codes for TEACH questions loaded through the ISIR Import (ISIM) process

                      have been created.

37548.48    - The parameters used to import Pell reconciliation information for 2008/2009 have been created.

37552.93    - The parameters used to import ACG and SMART reconciliation information for 2008/2009

                        have been created.

37279.22    - The FA Dispatcher, used in the Department of Ed Import (DOEI) process, has been updated to

                        recognize new message class records for 2008/2009

37618.11    - All reject and warning codes related to COD processing have been documented

                         for the 2008/2009 year.

37566.89    -  All programs used in Electronic Statement of Accounts (ESOA) printing have been

                        reviewed for the 2008/2009 year.

37939.96    - The subroutines used to transmit Financial Aid award information to Accounts

                         Receivable have been modified to ensure that any transmittal activity related to

                        TEACH awards will result in zero amounts, until full processing of TEACH awards

                        becomes available.

Change Request............: 36906.75

Summary...................: CORE Relationship Maintenance Bundle

Criticality...............: Release

Status....................: Complete

Date Completed............: 4/30/2008

Impact....................:

Priority..................: C

Project...................:

Main Release ID...........:

Application...............: CORE

Module Name...............:

Mnemonic..................:

Problem/Issue.............:

Several issues and enhancement opportunities were discovered by Datatel and clients for Colleague's relationship functionality. See the Description section for more information about the issues resolved with this software update.

Resolution................:

This software update resolves a number of issues and provides enhancements for Colleague.  See the Description section for more information about the issues resolved, and the enhancements added, by this software update.

Client Impact.............:

CLIENT IMPACT

Upon implementing this software update, you will be able to manage joint labels and relationships more efficiently.

IMPLEMENTATION INSTRUCTIONS

Not applicable.

TECHNICAL IMPLEMENTATION

Not applicable.

NEW FORMS

Not applicable.

CUSTOM IMPACT

Not applicable.

SOFTWARE PARTNER

Not applicable.

Description...............:

UPDATE 4/30/2008

*****************************************

SU36906.75-1805*05 is available

*****************************************

This software update delivers many miscellaneous improvements to Colleague's relationship processing.

This software update resolves the following change requests:

16621.48, 29368.33, and 33321.52

The newly delivered Default Joint Name Format field lets the institution indicate whether they want to use a one-line joint mail label or a stacked joint mail label by default, and whether to use a joint salutation by default.  This field has been added to the Communication Processing (PID7) form.  The subroutines S.GET.MAIL.LABEL.NAME and S.GET.PREFERRED.NAME have been updated to construct joint mail labels and joint salutations as follows:

If One Line is selected on the PID7 form, the following conditions must be true for Colleague to construct a one-line joint mail label or salutation:

--The relationship must be between spouses.

--Both people must have the same last name.

--One record holder must have a prefix of "Mr." and the other must be "Mrs."

If these conditions are met, then the joint mail label and joint preferred name will be constructed as Mr. and Mrs. [Variable Name] LastName.

Technical:

Variable Name is determined by the record holder of the "Mr." record as follows:

For mail labels, Colleague looks at the PERSON.MAIL.LABEL field first. If that is null or has been manually entered, then Colleague looks at the PREFERRED.NAME field. 

For preferred names, Colleague looks only at the PREFERRED.NAME field and responds with the following.

--If the field is null or is "FI," uses the person's first name.

--If "FM," uses the person's full and middle names.

--If "II," uses the person's first and middle initials.

--If "IM," uses the person's middle name.

--If the PREFERRED.NAME is blank or manually entered, then use first name.

24875.63

When accessing the Relations Inquiry (RELI) form, all relations for the specified PERSON will be displayed.  The user may then refresh the view by populating the relationship start or end dates.

28111.89

The start and end date field labels on the Relationships (RELE) form have been corrected.

29835.67

The end date field length has been corrected on the RELE form.

31207.74

The RELE form now displays the related person's birth date, source, and person status.

36506.07

The process help for the Relationship Summary (RELS) and Person Relations (PREL) forms have been updated.

38047.96

Ending a marriage in Colleague will no longer create CONSTITUENT records automatically.

Change Request............: 31056.78

Summary...................: Web Payment Enhancements - Colleague Software Update

Criticality...............: Release

Status....................: Complete

Date Completed............: 5/5/2008

Impact....................:

Priority..................: D

Project...................:

Main Release ID...........:

Application...............: ARCR

Module Name...............: AR

Mnemonic..................:

Problem/Issue.............:

Students could not view information about their payment plans, and make payments on those plans, over the web.  Institutions could not generate late charges on payment plans as soon as they were late.  Some clients needed the ability for web payments to be posted to different GL accounts based on various factors.  Payment plan payments were overpaying charges that were paid by some other kind of payment (typically Sponsor Billing or Financial Aid).

Resolution................:

This software update provides new and updated forms and processes in Colleague and WebAdvisor, enabling the following:

- Students can now view and pay their payment plans through WebAdvisor.

- Institutions can now generate late charges on payment plans at any time.

- Institutions can now define rules that control the GL distribution of WebAdvisor payments.

- Payment plan payments no longer overpay charges paid by a higher priority payment.

Client Impact.............:

Clients can provide better customer service to their students by enabling the students to manage their payment plans online.  Clients can also charge late fees on delinquent payment plans when they are late, rather than having to wait for the student to make a payment before the late fees are charged.  Clients can now distribute WebAdvisor payments to multiple GL accounts.  Student balances are now more accurate because charges are not overpaid.

IMPLEMENTATION INSTRUCTIONS

This update is dependent on the following updates:

 - SU38476.37-4.1.0: Web Payment Enhancements - DMI Update

 - SU38032.19-485: Web Payment Enhancements - UT/Tool Update

 - SU31057.63-1805: Web Payment Enhancements - Colleague Database Update

 - SU38115.95-485: WA3 Updated support for Back button on WFMS web

 - SU30680.15-485: WebAdvisor 3.1.2 UT/TOOL updates

 - WebAdvisor 3.1.2 InstallShield installation

See the "Release Highlights: Web Payment Enhancements" documentation at www.datatel.com/documentation for implementation instructions for this release.

TECHNICAL IMPLEMENTATION

Not applicable 

NEW FORMS

Payment Plan Web Parameters (PLWP)

Post Late Plan Charges (PLPC)

WebAdvisor GL Distributions (WDST)

View My Payment Plan Schedule

Select My Payment Plan

Pay on My Payment Plan

Electronic Check Entry

Credit Card Entry

Payment Confirmation

CUSTOM IMPACT

See the "Release Highlights: Web Payment Enhancements" documentation at www.datatel.com/documentation for the forms modified by this release.

SOFTWARE PARTNER

Not applicable

Description...............:

5/5/08 -  The following software updates are available to Clients:

These software updates are all part of the Payment Plan on the Web Update and should all be loaded together.

*******************************

RP 746 - SU38476.37-4.1.0*351

RP 1832 - SU31057.63-1805*14

RP 2188 - SU38032.19-485*02

RP 1831 - SU31056.78-1805*22

******************************* 

This Web Payment Enhancements software update delivers several key enhancements to making payments in Colleague Student WebAdvisor.  This update also includes some additional enhancements to Payment Plan processing in Colleague Student.  These key enhancements include the following:

 - Students can now make payments on their payment plans through WebAdvisor.

 - Students can now view their payment plan schedules in WebAdvisor.

 - Institutions can now generate and post late charges on payment plans.

 - Institutions can now distribute payments made through Student WebAdvisor to specific general ledger (GL) cash accounts.

 - The method for allocating payment plan payments has changed so charges on payment plans are no longer overpaid.

See the "Release Highlights: Web Payment Enhancements" documentation at www.datatel.com/documentation for more information about this release.

Additional Keywords:

6273

38476.37

38032.19

31057.63

Change Request............: 31057.63

Summary...................: Web Payment Enhancements - Colleague Database Update

Criticality...............: Release

Status....................: Complete

Date Completed............: 5/5/2008

Impact....................:

Priority..................: D

Project...................:

 Main Release ID...........:

Application...............: ARCR

Module Name...............: AR

Mnemonic..................:

Problem/Issue.............:

Database changes were needed to support the Web Payment Enhancements project.

Resolution................:

Some minor database changes were made to provide the necessary functionality for the Web Payment Enhancements project.

Client Impact.............:

Clients will be able to install the Web Payment Enhancements software update (SU31056.78) after installing this update.

IMPLEMENTATION INSTRUCTIONS

Not applicable

TECHNICAL IMPLEMENTATION

Not applicable

NEW FORMS

None

CUSTOM IMPACT

Not applicable

SOFTWARE PARTNER

Not applicable

Description...............:

5/5/08 -  The following software updates are available to Clients:

These software updates are all part of the Payment Plan on the Web Update and should all be loaded together.

*******************************

RP 746 - SU38476.37-4.1.0*351

RP 1832 - SU31057.63-1805*14

RP 2188 - SU38032.19-485*02

RP 1831 - SU31056.78-1805*22

******************************* 

This software update contains the database changes needed to support the Web Payment Enhancements project.  This update must be installed prior to loading and implementing SU31056.78-1805.

See the "Release Highlights: Web Payment Enhancements" documentation at www.datatel.com/documentation for more information about this release.

Additional Keywords:

6273

38476.37

38032.19

31056.78

Change Request............: 38032.19

Summary...................: Web Payment Enhancements - UT Update

Criticality...............: Release

Status....................: Complete

Date Completed............: 5/5/2008

Impact....................:

Priority..................: C

Project...................:

Main Release ID...........:

Application...............: UT

Module Name...............: UT

Mnemonic..................:

Problem/Issue.............:

The payment confirmation form in WebAdvisor included language that was specific to VeriSign, which needed to reference PayPal instead.  Colleague also needed to produce e-mail messages in a format similar to a WebAdvisor form.

Resolution................:

This update includes new miscellaneous text items for PayPal.  It also contains new subroutines that can be used to produce formatted e-mail messages.

Client Impact.............:

Clients who use PayPal as their e-commerce provider will now have the new items needed to comply with their contract with PayPal.  In addition, Colleague applications can now generate formatted e-mail messages.

IMPLEMENTATION INSTRUCTIONS

Not applicable

TECHNICAL IMPLEMENTATION

Not applicable

NEW FORMS

None

CUSTOM IMPACT

Not applicable

SOFTWARE PARTNER

Not applicable

Description...............:

5/5/08 -  The following software updates are available to Clients:

These software updates are all part of the Payment Plan on the Web Update and should all be loaded together.

*******************************

RP 746 - SU38476.37-4.1.0*351

RP 1832 - SU31057.63-1805*14

RP 2188 - SU38032.19-485*02

RP 1831 - SU31056.78-1805*22

******************************* 

This software update contains changes to Envision needed to support the Web Payment Enhancements project.  This update must be installed prior to loading and implementing SU31056.78-1805.

This update contains new miscellaneous text items for PayPal (previously known as VeriSign).  These items, displayed in the footer of WebAdvisor payment confirmation forms,  replace the previous VeriSign items.  In addition, this update includes new subroutines needed for processing formatted e-mail messages.

See the "Release Highlights: Web Payment Enhancements" documentation at www.datatel.com/documentation for more information about this release.

Additional Keywords:

6273

38476.37

31057.63

31056.78

Change Request............: 38476.37

Summary...................: Web Payment Enhancements - DMI Update

Criticality...............: Release

Status....................: Complete

Date Completed............: 5/5/2008

Impact....................:

Priority..................: D

Project...................:

Main Release ID...........:

Application...............: ARCR

Module Name...............:

Mnemonic..................:

Problem/Issue.............:

Colleague needed to produce e-mail messages in a format similar to a WebAdvisor form.

Resolution................:

Colleague now uses the documents delivered in this software update along with the DMI transformation engine to convert raw data and metadata into a formatted document, which can then be sent as an e-mail message.

Client Impact.............:

Colleague applications can now produce formatted e-mail messages.

IMPLEMENTATION INSTRUCTIONS

Not applicable

TECHNICAL IMPLEMENTATION

Not applicable

NEW FORMS

None

CUSTOM IMPACT

Not applicable

SOFTWARE PARTNER

Not applicable

Description...............:

5/5/08 -  The following software updates are available to Clients:

These software updates are all part of the Payment Plan on the Web Update and should all be loaded together.

*******************************

RP 746 - SU38476.37-4.1.0*351

RP 1832 - SU31057.63-1805*14

RP 2188 - SU38032.19-485*02

RP 1831 - SU31056.78-1805*22

******************************* 

This software update contains new DMI components needed to support the Web Payment Enhancements project.  This update must be installed prior to loading and implementing SU31056.78-1805.

This update contains new XSLT stylesheets and transformation documents needed to produce formatted e-mail messages.

See the "Release Highlights: Web Payment Enhancements" documentation at www.datatel.com/documentation for more information about this release.

Additional Keywords:

6273

38032.19

31057.63

31056.78

Change Request............: 35940.44

Summary...................: Build Stu Basics (SB) Data (CASB) Maintenance

Criticality...............: Release

Status....................: Complete

Date Completed............: 5/8/2008

Impact....................: Low

Priority..................: C

Project...................:

Main Release ID...........:

Application...............: STSTATE

Module Name...............: CAST

Mnemonic..................: CASB

Regulatory Enhancements...:

Yes

Problem/Issue.............:

The Build Stu Basics (SB) Data (CASB) process stopped responding when doing the selection for Voc Ed students.

Resolution................:

The Build Stu Basics (SB) Data (CASB) process was updated to process selection criteria more quickly, so that DMI does not close the connection.

Technical:

The selection criteria on the Build Stu Basics (SB) Data (CASB) process has been changed from using the STUDENT.COURSES.SEC file to the STUDENT.ACAD.CRED file.

Client Impact.............:

CLIENT IMPACT

You can now successfully run the Build Stu Basics (SB) Data (CASB) process for Voc Ed students. In addition, the performance of the record selection process of the CASB process is better.

IMPLEMENTATION INSTRUCTIONS

Not applicable

TECHNICAL IMPLEMENTATION

Not applicable

NEW FORMS

Not applicable

CUSTOM IMPACT

Not applicable

SOFTWARE PARTNER

Not applicable

Description...............:

05/08/08 Update) The following software updates are now available to clients:

*********************************

SU35940.44-1805*01

*********************************

This change request was originally reported with the title, "R18 - CASB error - Getting dmi listener failed."

The Build Stu Basics (SB) Data (CASB) process hangs or dies when doing the selection for Voc Ed students.  It *appears* to be in the 'Build Student Matric.' list, but it is actually doing the select for the next part "Build Voc Ed. Student List."  The reason it hangs is due to the way the selection criteria is built (CASTL016C).  It uses the computed column SCS.STC.STATUS which is a very slow computed column.  The selection can take longer than 15 minutes, so on Release 18 it causes DMI timeouts (Select failed: Listener failed to respond).

SELECT STUDENT.COURSE.SEC WITH SCS.STC.STATUS NE '5' AND WITH SCS.START.DATE GE '06/19/2007' AND WITH SCS.START.DATE LE '12/26/2007' TO 0

There is no option for a savedlist of STUDENT.COURSE.SEC.IDS.  The savedlist field is only for PERSON.IDs.

Change Request............: 38766.59

Summary...................: FATR: enhancements to Transmit Flag and Failed Eligibility Rules

Criticality...............: Release

Status....................: Complete

Date Completed............: 5/8/2008

Impact....................: High

Priority..................: B

Project...................:

Main Release ID...........:

Application...............: ARCR

Module Name...............: AR

Mnemonic..................:

Problem/Issue.............:

This software update resolves the following issues related to the SU37690.56-1805*03 software update, which provided enhancements to the Financial Aid Transmittal Register (FATR) process:

38643.44 - AR:Problem running FATR/FATP (Issue #1) Some clients had an issue with the FATR process when running it in non-update mode.  If a student had multiple awards and one of the awards failed rule evaluation, then none of the student's awards were sent to the Batch FA Transmittal Update (FATP) process.  Clients have requested that a student's valid awards be sent to the FATP process, even if some of the student's awards fail rule evaluation.

210.1100 - FA/AR: TA.XMIT.FLAG is incorrectly maintained

38643.44 - AR:Problem running FATR/FATP (Issue #2) Some clients reported that it was possible for the FATR process to mark an award as fully transmitted, even if the award failed eligibility rules or still had untransmitted funds.

Resolution................:

38643.44 - AR:Problem running FATR/FATP (Issue #1) The Financial Aid Transmittal Register (FATR) process now sends all valid awards to the Batch FA Transmittal Update (FATP) process.  If any of a student's awards fail rule evaluation, then all of the student's evaluated awards will be printed on the FATR report. 

210.1100 - FA/AR: TA.XMIT.FLAG is incorrectly maintained

38643.44 - AR:Problem running FATR/FATP (Issue #2) An award will no longer be marked as fully transmitted if the award fails rules evaluation or has untransmitted funds.

Client Impact.............:

Clients will now be able to transmit a student's valid awards, even if some of the student's awards fail evaluation rules.  Awards will now be accurately marked as fully transmitted or not.

IMPLEMENTATION INSTRUCTIONS

Not Applicable

TECHNICAL IMPLEMENTATION

Not Applicable

NEW FORMS

Not Applicable

CUSTOM IMPACT

If you have modified any of the following processes, you will need to either implement the changes delivered with this software update into your customized software, or re-implement your customization to the software after loading this update:

ARB010

ARF010 Process Help

SOFTWARE PARTNER

Not Applicable

Description...............:

This software update resolves two issues related to the SU37690.56-1805*03 software update, which provided enhancements to the Financial Aid Transmittal Register (FATR) process.  If you have installed the SU37690.56-1805*03 software update, Datatel highly recommends that you install this update promptly.

********************************************************************************************************

05/08/2008 - The following software update has been released and is available to clients:

****************************

SU38766.59-1805*04

****************************

Change Request............: 30680.15

Summary...................: WebAdvisor 3.1.2 UT/TOOL updates for R18

Criticality...............: Release

Status....................: Complete

Date Completed............: 5/9/2008

Impact....................: Medium

Priority..................: D

Project...................:

Main Release ID...........:

Application...............: UT

Module Name...............: UT

Mnemonic..................:

Pre Install Instructions..:

The automated Post-Install subroutine for this software update performs maintenance on the WebAdvisor State Management (WWW) files.  All DMI Listeners for the environment - except for the DAS Listener - must be halted, no other users may be using the environment, and the WebAdvisor Garbage Collect (WAGC) process must be halted to prevent these files from being in use.  If the WWW files are in use when the Post-Install subroutine executes, the subroutine may produce runtime errors.

*** Special Instructions for Windows Clients: ***

In testing the Automated Post-Install Subroutine associated with this release, we sporadically encountered an error when the subroutine attempts to do a DELETE.INDEX on the WWW.STATE.ARGS file in Windows environments.  We suspect there may be a UniRPC slave issue but have been unable to isolate the problem.  In most cases, deleting the indexes for this file manually before the software update is loaded mitigates any errors that occur during installation.  We recommend you perform the following command at the colon prompt in each environment into which you load this software update.  Make sure all DMI listeners associated with the environment have been halted, that no other users are in the environment, and that the WebAdvisor Garbage Collect (WAGC) process has been halted.

   : DELETE.INDEX WWW.STATE.ARGS ALL

*** End Special Instructions ***

This restriction against active listeners for the environment also applies any time you run the WebAdvisor File Maintenance (WAFM) process or the WebAdvisor Garbage Collect (WAGC) process with the option to clear files.  Both forms now check that the application listener is not running.  You must also ensure that other listeners for the environment, like print servers, are also halted before using these processes.

Changes included on this software update limit the mnemonics for hyperlink definitions to six characters.  If you have hyperlink definitions with mnemonics longer than six characters, you will need to change these mnemonics before loading the software update.  

Hyperlinks defined using the Hyperlink Global Parameters (HGP) form in the Tool Kit should not have mnemonics longer than six characters.  Existing hyperlinks defined using the Hyperlink Control Maintenance (HLKM) form in Envision Runtime can have longer mnemonics.  Hyperlink definitions created on the Hyperlink Control Maintenance (HLKM) form in Envision Runtime (UT) that have mnemonics greater than six characters should be changed using the Hyperlink Global Parameters (HGP) form in the Tool Kit.

Problem/Issue.............:

In addition to new features delivered with WebAdvisor 3.1.2, clients reported several issues for the WebAdvisor 3.x release.  See the Description section for more information about the problems resolved with this software update.

Resolution................:

This software update resolves several AnswerNet change requests for WebAdvisor 3.x.  See the Description section for more information about the problems resolved with this software update.

Client Impact.............:

CLIENT IMPACT

WebAdvisor is easier to maintain, customize, and use. 

Datatel's software is based on single source code architecture. To maintain the full potential, value, and benefits of your Datatel software, it is critical that all software updates are loaded for both the base system and all licensed modules, regardless of whether the specific update is intended to resolve an issue on a particular database or to provide database changes for a specific module. All future Datatel software updates and support will be based on the latest delivered version of software, so you must load this specific software update in order to take advantage of future updates and enhancements.

IMPLEMENTATION INSTRUCTIONS

Not applicable.

TECHNICAL IMPLEMENTATION

Changes to WebAdvisor State Management (WWW) files.

This software update introduces three new WWW files: WWW.STATE.FVAR, WWW.STATE.LOCAL, and WWW.STATE.TX.  These files are available for maintenance using the WebAdvisor File Maintenance (WAFM) form in Envision Runtime.  These files separate out the largest of the WWW.STATE records.  The data in these records tends  to be large and irregular, which made sizing the WWW.STATE file difficult.  These new files address the issues for change requests 24304.63 and 31978.93.

PDF Reporting Enhancements.

The Field Mapping Template (WFMT) form now allows you to specify coordinates in the associated PDF document at which to render data.  Identify the target in the PDF document by specifying X and Y coordinates and an optional page number.

26206.26 - Client receives error message when using Employees Menu in WA3.x WebAdvisor now checks that items on a menu have a valid application and a valid module for the environment.  The system-maintained list of installed applications and modules provides the list of valid mnemonics against which WebAdvisor validates a menu item. 

30046.11 - Garbage collection daemon does not delete log files from _PH_

This software update includes a new form, WebAdvisor Garbage Collect File Maintenance (WAGM), to allow the system administrator to delete driver background process COMO files and execution background process COMO files.  A previous software update delivered for WebAdvisor (37138.48 - WAGC Enhancements and Maintenance) introduced two records maintained by the  WebAdvisor Garbage Collect (WAGC) form in the _PH_ directory: DMI_GC_DRIVERS and DMI_GC_EXECUTES.  These two records provide the data for populating the lists of records to delete on the WAGM form.  Background process records created by running the WAGC process prior to the installation of 37138.48 must be deleted manually.

32990.41 - R18 Oracle: SVCF missing bounds checking on SV.URL.ROOT

When associating hyperlink definitions to a SERVLETS record on the following forms, the fields now perform Hyperlink Mnemonic LookUp, and entry is limited to six characters:

Servlets Configuration (SVCF) - Servlet Root URL Hyperlink (SV.URL.ROOT)

Servlet Behavior Parameters (SVBP) - Default Return URL (SV.DEFAULT.RNT.URL)

Servlet Display Parameters (SVDP) - Contact Us Hyperlink (SV.CONTACT.US)

Hyperlink definitions created on the Hyperlink Control Maintenance (HLKM) form in Envision Runtim (UT) that have mnemonics greater than six characters should be changed using the Hyperlink Global Parameters (HGP) form in the Tool Kit.

36262.15 - HLKM open new window option does not work

NOTE: Hyperlinks should be defined on the Hyperlink Global Parameters (HGP) form in the Tool Kit.

The Open New Window field on Hyperlink Control Maintenance (HLKM) in Envision Runtime (UT) and the Link Opens New Window field on Hyperlink Global Parameters in the Tool Kit now take precedence over any programmed control.  Previously, developers could include in the URL string a "CLONE=Y" token to force a new window open.  This functionality is now controlled by the Open New Window flag.  The one exception to this rule is for "legacy" hyperlinks that contain the string starting with "com.datatel…" in the Target Server Path List.  Legacy hyperlinks always open in a new window.

For static hyperlinks defined for the template of a menu or form on the Web Form Parameter Maintenance (WFPM) form, the New Window flag take precedence over the Open New Window flag from the HGP or HLKM forms.

NEW FORMS

This software update includes a new form, WebAdvisor Garbage Collect File Maintenance (WAGM), to allow the system administrator to delete driver background process COMO files and execution background process COMO files.

CUSTOM IMPACT

As with every version of WebAdvisor starting with WebAdvisor 3.0, clients must carry forward their customizations to XSLT and CSS stylesheets into the new versions that Datatel delivers. Make sure to store these changes in the custom area of your Deployment Directory, along with any additional stylesheets of your creation. These custom stylesheets will be incorporated in the WebAdvisor WAR file when you rebuild using the Apache ant utility. 

Changes included on this software update limit the mnemonics for hyperlink definitions to six  characters.  If you have hyperlink definitions with mnemonics longer than six characters, you will need to change these mnemonics before loading the software update.  Hyperlinks defined using the Hyperlink Global Parameters (HGP) form in the Tool Kit should not have mnemonics longer than six characters.  Existing hyperlinks defined using the Hyperlink Control Maintenance (HLKM) form in Envision Runtime can have longer mnemonics. 

SOFTWARE PARTNER

The changes for this software update have been tested with supported partner products. This software update has no impact on these interfaces.

Description...............:

05/09/08 - The following software update has been released and is available to clients:

*******************************

SU30680.15-485*18

*******************************

This software update has a companion InstallShield.  Changes to the WebAdvisor servlet and to the Envision processing of reports require these two components be loaded together.

WebAdvisor 3.1.2 includes several new features to enhance the user interface for end users, including:

Changes to WebAdvisor State Management (WWW) files.

This software update introduces three new WWW files: WWW.STATE.FVAR, WWW.STATE.LOCAL, and WWW.STATE.TX.  These three new files separate out the largest of the WWW.STATE records to separate files.  Moving these files keeps the size of WWW.STATE smaller, reduces the instances of file overflow, and makes it easier to manage.  These new files resolve the issues for change requests 24304.63 and 31978.93.

PDF Reporting Enhancements.

The Field Mapping Template (WFMT) form now allows you to specify coordinates in the associated PDF document at which to render data. 

See the "Technical Implementation" section for more information about these features.

In addition, clients reported several issues for WebAdvisor 3.x, including the following:

9481.63 - WebAdvisor does not get the correct field label

WebAdvisor now correctly uses the label defined as an override for a field on a form.  If the form-specific label is not defined, WebAdvisor uses the default label for the data element from the Central Data Dictionary (CDD).  If no label is available, WebAdvisor will parse the template text associated to the data element on the form.

23600.07 - WA30: Default Return URL field on WSPM or SVCA does not work correctly

WebAdvisor now executes the URL specified by the hyperlink definition for Default Return URL when a user completes a form in WebAdvisor.

24304.63 - WWW.STATE reaches 2 gig limit/blank screen and OK button

This software update introduces three new WebAdvisor State Management files: WWW.STATE.FVAR, WWW.STATE.LOCAL, and WWW.STATE.TX.  These three new files separate out the largest of the WWW.STATE records to separate files.  Moving these files keeps the size of WWW.STATE smaller, reduces the instances of file overflow, and makes it easier to manage.  See also 31978.93.

26206.26 - Client receives error message when using Employees Menu in WA3.x

WebAdvisor now checks the application and the module of a menu item to insure that each is installed.  Menu items that reference applications that have not been installed or optional modules that have not been installed get filtered from the list when the menu is rendered.  See also 38148.67.  See the "Technical Implementation" section for more information.

28954.35 - Use of diacritical ("special") characters on WebAdvisor forms

WebAdvisor forms can now accept diacritical characters (characters with a small sign added to alter pronunciation or to distinguish between similar words) and preserve them when it passes the values to Colleague.

29760.33 - E- Mail hyperlink in WebAdvisor should be dynamic

Developers now have the ability to define e-mail addresses programmatically for MAILTO hyperlink types.

30046.11 - Garbage collection daemon does not delete log files from _PH_

This software update includes a new form, WebAdvisor Garbage Collect File Maintenance (WAGM), to allow the system administrator to delete driver background process COMO files and execution background process COMO files.  See the "Technical Implementation" section for more information.

30804.52 - Incomplete error message issued from WebAdvisor

WebAdvisor now renders the appropriate error message with argument substitution.

31978.93 - WA3x: High transaction volume cause WWW.STATE to overflow

See 24304.63.

32132.48 - WA: bad field label with "field is required" message.

WebAdvisor now uses the correct field label when required input is missing.

32990.41 - R18 Oracle: SVCF missing bounds checking on SV.URL.ROOT

The Servlets Configuration (SVCF) form now limits the Servlet Root URL Hyperlink to six characters and enforces mnemonic LookUp.  See the "Technical Implementation" section for more information.

33059.44 - WA310: SWC does not prevent window selection type when paging enabled

The Screen Window Characteristics (SWC) form now prevents window selection type when paging is enabled.

33395.41 - WA30: Field above table does not span columns

Envision Table object now spans multiple columns correctly and does not force the fields within to abnormally stretch the surrounding elements or compress its values.

33876.75 - WA: certain forms don't print from browser

Changes to the waprint.css cascading stylesheet for the WebAdvisor servlet now allow form printing from all supported browsers.  See also 35289.63.

34571.04 - WA31: Customizations to login template (LGRQT) disappear with login error

WebAdvisor now retains the reference to a custom login template when user logins result in an error.

35237.63 - WA310: AJAX Widget prevents hyperlinks opening in same window

WebAdvisor now allows hyperlinks to open in the same window when rendered with paging enabled.

35289.63 - Firefox does not print some forms correctly in WebAdvisor 3.x

See 33876.75

35807.15 - Specifying a custom Change Password template does not work

WebAdvisor now correctly recognizes and processes the customizable Change Password form.

35812.48 - Default Return URL for WA 3.1 causes an error on Change Password

WebAdvisor now correctly processes the Default Return URL after completing the Change Password form.

35990.63 - WA310: Radio buttons do not work with Accessibility Servlet Usage

WebAdvisor now correctly renders and processes radio buttons with the Accessibility Servlet Usage type.

36130.63 - WA311: Password field size not honored for Login form

WebAdvisor now correctly honors the field size for passwords from the customizable Login form.

36262.15 - HLKM open new window option does not work

WebAdvisor now honors the setting for the Open New Window field on the Hyperlink Control Maintenance (HLKM) form in Envision Runtime (UT) and the Link Opens New Window field on the Hyperlink Global Parameters (HGP) form in the Tool Kit.

37101.19 - Missing/bad dictionaries for WWW files cause problems for Garbage Collect

The WebAdvisor File Maintenance (WAFM) utility now updates the dictionaries for the following WebAdvisor State Management files:

WWW.EVENT.SEQUENCE

WWW.MENU.CACHE

WWW.QUERY.SAVELIST

WWW.STATE.ARGS

WWW.TOKENS

The other WWW files store data that is not consistently structured enough to use dictionaries.

38121.96 - WA312: JMeter 2.2 scripts need to work with JMeter 2.3

The JMeter scripts delivered for WebAdvisor performance testing now work with JMeter 2.3.

38148.67 - WebAdvisor menu processing needs to check installed optional modules

See 26206.26.

Change Request............: 37078.52

Summary...................: CF: Data Mart and Physical Inventory Update

Criticality...............: Release

Status....................: Complete

Date Completed............: 5/9/2008

Impact....................: Medium

Priority..................: A

Project...................:

Main Release ID...........:

Application...............: CF

Module Name...............: CF

Mnemonic..................:

Problem/Issue.............:

Clients reported a number of issues with Colleague Finance and Human Resources. See the Description section for an overview of the activities resolved with this release for more detailed information.

Resolution................:

This software update resolves a number of issues with Colleague Finance and Human Resources.  See the Description section for an overview of the activities resolved with this release for more detailed information.

Client Impact.............:

The physical inventory functions of Colleague Finance and the data mart functionality in Colleague Finance and Human Resources are more accurate and easier to use, as described in the Description section.

IMPLEMENTATION INSTRUCTIONS:

Not applicable.

TECHNICAL IMPLEMENTATION:

Not applicable.

NEW FORMS:

Not applicable.

CUSTOM IMPACT:

Not applicable.

SOFTWARE PARTNER:

Not applicable.

Description...............:

5/9/2008 - The following software update has been released and is available to Clients:

**************************

SU37078.52-1805*02

**************************

Update: 4/7/08 - This software is in QA, and is not ready for download.

23957.18 - PICE/PINU: Creating incomplete posting records

The Physical Inv Count Entry (PICE) form would allow a physical inventory count to be done on an inventory item where the quantity on-hand did not match the sum of the FIFO quantities. When the Update Physical Inventory (PINU) process was run, a large number of  posting records without debit or credit amounts would get created.  Also, the PICE form would allow a physical inventory count to be entered for an inventory item in an inventory store for which the Physical Inventory Setup (PINS) had not been run previously.

The PICE form has been updated to disallow entry of physical count for those inventory items where the quantity on hand does not match the sum of the FIFO quantities. The PICE form has also been updated so that the PINS process must have been run for the inventory store prior to entering the physical count for the inventory items for that inventory store on this form.

35556.93 - PGSA / EGPM no longer create SQL views

The Populate GL Summary Analysis (PGSA) process in Colleague Finance and the Export GL Payroll Data Mart (EGPM) process in Human Resources were not creating the target SQL views when the Create Target SQL View flags were marked "Yes."

The subroutine S.SEND.GL.SQL.VIEW has been updated so that the PGSA and EGPM processes will now create the target SQL views when indicated to do so.

Change Request............: 37693.07

Summary...................: Reporting Views Deployment Enhancements

Criticality...............: Release

Status....................: Complete

Date Completed............: 5/9/2008

Impact....................: Low

Priority..................: C

Project...................:

Main Release ID...........:

Application...............: UT

Module Name...............: UT

Mnemonic..................: ESVS

Problem/Issue.............:

It was found that the Deploy SQL View Scripts (DSVS) form would stop responding when deploying the CF-GL_VIEWS in a SQL Server environment.

Users wanted the ability to use the @ LookUp on the Edit SQL View Scripts (ESVS) form.

When trying to save a large SQL View script (such as CF-GL_VIEWS), the ESVS form would refuse to save the record if either of the view creation scripts exceeded 32,500 characters.

In SQL Server, the Multipart key views performed slower than they had to due to the use of a user-defined function (dbo.FIELD) instead of native functions. Queries against the views would also stop responding when they encountered record locks, which are inevitable in a production Colleague database.

Clients with custom privileges on their SQL Server views would lose their security setups each time a Multipart key view was redeployed.

Resolution................:

After installing this software update, the Deploy SQL View Scripts (DSVS) form no longer hangs, the Edit SQL View Scripts (ESVS) form supports the @ Lookup and no longer complains about the view creation scripts being too large.

SQL Server clients will also find that they no longer lose any defined privileges on their Multi-part key views, and that the performance of the views should be improved.

Client Impact.............:

CLIENT IMPACT

SQL View scripts are easier to edit and deploy.

SQL Server environments will no longer lose custom privileges on the Multipart key views, and they should perform faster.

To maintain the full potential, value, and benefits of your Datatel software, all clients are strongly encouraged to load this software update.  Because all of our software is based on single source code architecture, it is critical that all software updates are loaded for both the base system and all licensed modules - regardless of whether the specific update is intended to resolve an issue on a particular database or to provide database changes for a specific module.

All future Datatel software updates will be built for the latest delivered version of software; therefore, it is necessary for your institution to load this specific software update to take advantage of all future updates and enhancements.

IMPLEMENTATION INSTRUCTIONS

Not applicable.

TECHNICAL IMPLEMENTATION

Not applicable.

NEW FORMS

Not applicable.

CUSTOM IMPACT

SQL Server database privileges defined on existing multipart key views will no longer be lost as the views are deployed.

SOFTWARE PARTNER

Not applicable.

Description...............:

05/09/2008 - The following software update has been released