Texas State Reporting

178860

Instructors whose courses were cancelled still showed up in the TX CBM008 snapshot, which generated an error from the state.

195963

For CBM004 and CBM008 snapshots for the same current and prior terms, the flex courses that ended within the prior term were included in the CBM004 snapshot and not in the CBM008 snapshot. The state requested that CBM008 also include the faculty for the courses listed in the CBM004.

204290

The TX CBM004 - CTC Snapshot for courses marked with a State Location Code 'A' - Auxiliary Location printed Zip codes in Item #12B in the Student Detail tab.

207049

The ID Number column for existing rows could be edited from the Maintain Snapshot Data Detail tab in the CBM009 CTC Report.

RN9603

The export to Excel was not working on the TX CTC CBM002 or the CBM00S.

195985

CBM001 was not excluding students who took only courses that were cancelled, resulting in a mismatch between CBM001 and CBM004.

198140

Students who have dropped or withdrawn were incorrectly included in the End of Course Enrollment (Item #14).

198200

The CTCCBM00C Continuing Education Course Type entry was a duplicate of CTCCBM00C Course Type.

198211

CBM00A and CBM00C - If the user tried to delete a row from the Courses or Students tab without first deleting the corresponding Detail rows, they got a database error.

200290

The CBM00A output file was displaying Y/N values for Non-disclosure instead of a 0 or 2.

201023

CBM00A - Dropped courses were being included in the list of courses used to calculate the student's Contact Hour Load.

168502

When a new employee was reported with an RE New Member contribution for 3 months in the TRS RP report, the Federal/Grant, Educational General and Non-educational General column amounts should have been zero. The logic has was updated to only report the RE New Member contribution and not the other categories for new employees.

174876

If information (other than TRS Position Code) about an employee's position changed from one reported snapshot to a new snapshot in the TRS report, the changes do not show up on the ED45.

175937

The Total Hours Attempted in the FADB report now excludes Dropped courses and includes Transfer courses in the count.

176155

A mismatch between CBM002 Items #20/#24 (Math), #40/#44 (Reading), and #60/#64 (Writing) for the EOUT TSI Student Status area status codes has been corrected.

178634

Error message appeared when the option to add a row was unavailable with multiple CBM reports.

176968

Student and Parent AGI were incorrectly reported in the FADB report.

177952

The default data for Selective Service, Exempt has been corrected (Institutional Reporting Definitions, TX THECB, THECB Grants and Special Programs, FADB Report, Selective Service field).

178390

The CBM002 export view has been updated to report a 0 for the ABE score if the associated TSI score was above the cutoff threshold.

179244

The FADB field now uses logic consistent with how the CBM001 report populates the same Transfer In or First Time in College data. THECB reconciles FADB student data against CBM report data and so this should resolve any unexpected conflicts. Plus, the previous logic may have caused issues where not all students identified to be reported were successfully calculated with FADB data as expected. This was due to the presence of multiple schools being assigned to the same Org Code.

179320

The Ministry Related field In the TX FADB report was set to 1 (Yes) when it should have been 0 (No).

179770

Texas State Reporting licensed customers were not able to customize the advising worksheet.

180272

Mismatch between CBM002 Items #20/#24 (Math), #40/#44 (Reading), and #60/#64 (Writing). Not all TSI Student Status area status codes were evaluated for the different items.

172474

TX CBM002 Item 23/43/63 fields were supposed to report all who participated but was reporting those who participated and satisfied TSI obligation as code 2.

174773

The Direct Loan amounts reported by TX FADB were not correct. They have been corrected.

163856

A database error occurred during the data collection when an hourly employee was paid from multiple accounts with different pay rates. The system now uses the pay rate from the timecard for the position with the lowest pay sequence number.

163904

When zip code information was deleted for previously reported employees, the TRS ED snapshot for that employee showed no information.

164005

TX TRS ED report- When an address was changed, not all address fields were filled in as required for the report. Now, If any address fields have changed data, all address fields that have data will display, including the ones that were changed and any others that contain data.

164366

TX TRS RP report- When an employee had multiple TRS position codes, the MC, SC & NM benefit amounts were split between the TRS position codes incorrectly. This has been corrected.

167404

When payroll is run more than once per month and an additional position is added between payruns with the same position code as another current position, a database error was generated. A change to the alternate key of the IR_TX_TRSTM_POS_CONTRACT_DATA which is filled during the snapshot data collection solved the problem.

143902

TX TRS ED20 and ED25 - Address changes were being reported even if they had previously been reported. Data collection logic was changed for identifying which data needed to be reported for a new employee or if a data item had changed.

146244

TX FADB report - EXP_FAMILY_CONT_9MO (#37) and EXP_FAMILY_CONT (#27) required 7 nines when students did not have a valid NEED_ANALYSIS instead of the 6 nines previously populated in the report file.

147578

TX FADB report - Ministry Related Degree (#56) previously populated with ‘N’ values instead of 0.

147582

TX FADB report - Categorical Aid (#49) was not populating the calculated amount.

147585

TX FADB report - When a student did not file a FAFSA/TASFA, the report only populated 6 nines on the report file in their record. STUDENT_AGI (#6) and PARENT_AGI (#7) report items were expanded to support a 7 digit value when required.

147712

TX FADB report - Semester Initial State Grant Award (#57) was not calculating.

153772

TX TRS RP20 report - Person and position did not appear in the snapshot when there was a second salary history row with an effective date prior to the end of the reporting period. The joins in the snapshot data collection were changed to use the timecard sal_rvw_seq row that was in place when the payroll was run.

154576

TX FADB report - The gross disbursement amount calculation for report items Direct PLUS (#85), Direct Subsidized (#86), and Direct Unsubsidized (#88) reported some loans incorrectly. The calculation was modified to include only the eligible disbursements.

154712

TX FADB report - Error messages appeared when values in the snapshot data tabs were updated and saved due to a problem with the Selective Service Registration drop-down.

155413

TXCBM00S - When Ed Success Levels of 7 & 8 were both applied to a catalog course, the course appeared twice in the report.

156087

TX FADB report - The Enrollment Status (#42) incorrectly evaluated the credit hour ranges to determine status.

156089

TX FADB Report - The three Tuition & Fees fields (#107-Fall, #108-Spring, #109-Summer) were still reducing the total charged by any allocated tuition exemptions/waivers processed via Accounts Receivable. The calculation logic was updated to reflect logic we provided in the workaround provided for Report Cycle 1 and will now reflect the eligible tuition & fees charged.

156096

TX FADB Report -  The TEOG Award Type (#70) and TEOG SAP Status (#111) was not being added to the snapshot for TEOG Recipients.

159403

TX CBM002 - The ABE scores (items 80, 81, and 82) were not being populated on the snapshot.

163856

A database error occurred during the data collection when an hourly employee was paid from multiple accounts with different pay rates. The system now uses the pay rate from the timecard for the position with the lowest pay sequence number.

163904

When zip code information was deleted for previously reported employees, the TRS ED snapshot for that employee showed no information.

139756

If the database was not set to auto trim trailing spaces, Source and Destination Org Codes need to be trimmed of trailing spaces, Functional Acknowledgement Needed values should be 0 or 1, and Courses are repeated because of a missing join.

145387

The EPUB TSI codes were being referenced inconsistently, resulting in code mismatches between items #20 and #24.

145214

In the FADB report, the three Total Tuition and Mandatory Fees fields, including, #107-for Fall, #108-for Spring, and #109-for Summer, were calculated incorrectly. We were erroneously including Open Items allocations and Tuition Exemptions which would reduce the original charge amounts.  Our calculation would then further reduce the amount based on any TX tuition exemptions we were reporting as we understood THECB to indicate that tuition and fees should be reduced by those. THECB has clarified that they want the amount of tuition and fees to not be reduced by any state tuition exemptions received. Our calculation has been corrected to now report each student's tuition and fees charged.

146225

In the FADB report, the Three Attempted Hours field may not have populated. The FADB report now collects attempted hours for students based on the hours in student course history for each Jenzabar term that maps to the state defined term in the FADB Terms Institutional Reporting Definition. It will include any hours for courses with a transaction status of current or history and with credit types that are not excluded from Part-Time/Full-Time. We will no longer collect hours from PowerFAIDS since all students reported on the FADB report may not have a record there.

146243

The FADB Report now executes with improved efficiency.

146248

The four SAP Status fields now populate as expected for students that receive on of these funds. The four fields include TXGR SAP Status (#110), TEOG SAP Status (#111), TEG SAP Status (#112), and TOP TEN SAP Status (#113).

146252

In the FADB report, several drop-downs in the Maintain Snapshot Data window were displaying multiple rows for the same code.

146253

In the FADB report, the Maintain Snapshot Data window was showing incorrect values in the drop-down choices for field 70 TEOG Award Type.

146350

If an employee's position start date was changed between the pay run and when TRS reports were run to a date after the reporting month the position was not being included.

146703

The Program Level (#22) now checks the student's degree history archive record prior to or on the census date of the earliest term a student attends in the award year selected instead of the start date. Additionally, program level will be set to blank if no degree history archive record can be found for the student before or on the census date of the earliest term a student attends in the award year selected. Previously, such records were set to 0, which indicates a student is non-degree seeking. Setting program level to blank allows schools to clearly know which records have some data issue that requires review.

147711

In the FADB report, the Justification and Hardship fields were not populated when data was set in the Scholarship Recipient table for multiple years.

147714

In the FADB report, the TASFA Date was not being reported correctly.

147590

A new ATHLETIC State Fund Code is now available and needs to be assigned to each financial aid fund that needs to be counted in the Athletic Scholarship (#64) field. A workaround for the First Report Cycle required schools to create their own ATHLETIC state fund code and to update the field via a script. We recommend you delete your local ATHLETIC state fund code and assign the new default ATHLETIC state fund code to your funds.

147686

In the FADB report the Classification field (#33) was not set correctly.

150137

The EDI transcript file generated from J1 Desktop could not be opened with the Quick n Easy utility. This was caused by having the Override Institution code OS in a Session N1 name line without institution name or code for local Sessions.