Skip to main content

Oklahoma State Reporting

Tip

Only releases with enhancements or resolved issues for this module have content below.

New Columns for OK TRS Monthly Report

There are three new editable columns included on the OTRS Monthly tab of the OK OTRS Monthly report on the State Reporting Snapshot Data window:

  • Email Address (employee’s email address, recommended to be personal address to avoid access issues when TRS members move between employers)

  • Date of Hire (date of first employment)

  • Date of Termination (date of separation, not prior to the last day the employee worked)

This data will be required for FY 2026 monthly reporting.

Updates for UDS Summer End of Term Reports

To accommodate the changes to the UDS Summer End of Term Reports for 2024, we made several enhancements to the Institutional Reporting Definitions window, the Regulatory Reporting window, and the State Reporting Snapshots window.

Institutional Reporting Window
  • The "Current Instructional Program" reporting definition is changed to "Instructional Program Code". Its Parent Report AppID is changed from -51 to -48, which moves it from OK UDS Degree Conferred to OK UDS Common. Its Display Order is changed from 11 to 10.

  • The "Program Code Option ID" reporting definition is changed to "Option ID - Instructional Program Code". Its Parent Report AppID is changed from -54 to -48, which moves it from OK UDS Degree Conferred to OK UDS Common. Its Display Order is changed from 2 to 11.

  • A new reporting definition is added to OK UDS Common: Instructional Program Code Prefix.

    • Table and column: major_minor_def.major_cde

    • Description column: major_minor_desc

    • Display Order: 12

    • External Field Values: 1-digit codes enetered and mapped by the school. Not provided by DDU.

  • Changes to External Field Values

    • Original Admission Type at This Level

      • Added new value Q - Bridge Program

      • Deactivated these values:

        • K - Admission Exception

        • V - Cooperative Alliance

        • W Concurrently Enrolled High School Student Enrolled in Technical

    • Method of Delivery

      • Added new value 06 - Hybrid or MIxed Mode

      • Added new value 07 - Flexible Attendance

      • Deactivated value 04 - Satellite/Microwave

    • Prior Learning Assessment

      • Added new value WORK - Work or Occupational

    • Promotion Data

      • Added new value A - Adjunct

State Reporting Snapshots and Regulatory Reporting Windows

There are changes for Record Types D, F, and S.

Record D - Degree Conferred
  • Now collects Program Code 1 (strpt_ok_uds_degree_conf_data.program_code_1) and Program Code 2 (strpt_ok_uds_degree_conf_data.program_code_2) from their new locations in OK UDS Common.

  • Added new element 14 - Instructional Program Code Prefix (strpt_ok_uds_degree_conf_data.program_code_1_prefix)

    • Collected using the degree-history.major_1 to look up the IRD OK UDS Common "Instructional Program Code Prefix" external value

    • Added to Maintain Snapshot window, Degree Conferred tab as "Instructional Program Code Prefix 1"

  • Added new element 15 - Double Major Instructional Program Code Prefix (strpt_ok_uds_degree_conf_data.program_code_2_prefix)

    • Collected using the degree-history.major_2 to look up the IRD OK UDS Common "Instructional Program Code Prefix" external value

    • If there is no Major 2, this field is null.

    • Added to Maintain Snapshot window, Degree Conferred tab as "Instructional Program Code Prefix 2"

Record F - Financial Aid
  • Added new element 49 - Cost of Attendance (strpt_ok_financial_aid_data.cost_of_attendance)

    • Collected for JFA users from Cost of Attendance. Collected for PowerFAIDS users from stu_ay_sum_data.tot_budet.

    • Added to Maintain Snapshot window as "Cost of Attendance"

    • On Web Import file

      • Names are removed.

      • If, null, value is 000000

      • Value is rounded to nearest dollar.

      • Values are filled with zeros to 6 digits and no decimal.

Record S - Student
  • Now collects Program Code 1 (strpt_ok_uds_student_data.current_program_1) and Program Code 2 (strpt_ok_uds_student_data.current_program_2) from their new locations in OK UDS Common.

  • Added new element 55 - Option ID - Instructional Program Code #1 (strpt_ok_uds_student_data.option_id_program_code_1)

    • Collected using the degree_history.major_1 to look up the IRD OK UDS Common "Option ID - Instructional Program Code" external value

    • Added to the Maintain Snapshot window as "Option ID - Instructional Program Code #1"

  • Added new element 56 - Option ID - Instructional Program Code #2 (strpt_ok_uds_student_data.option_id_program_code_1)

    • Collected using the degree_history.major_2 to look up the IRD OK UDS Common "Option ID - Instructional Program Code" external value

    • If there is no Major 2, the field is null.

    • Added to the Maintain Snapshot window as "Option ID - Instructional Program Code #1"

  • Added new element 57 -Instructional Program Code #1 (strpt_ok_uds_student_data.option_id_program_code_1_prefix)

    • Collected using the degree_history.major_1 to look up the IRD OK UDS Common "Instructional Program Code Prefix" external value

    • Added to the Maintain Snapshot window, Student Details tab as "Instructional Program Code #1 Prefix"

  • Added new element 58 -Instructional Program Code #2 (strpt_ok_uds_student_data.option_id_program_code_2_prefix)

    • Collected using the degree_history.major_2 to look up the IRD OK UDS Common "Instructional Program Code Prefix" external value

    • If there is no Major 2, this field is null.

    • Added to the Maintain Snapshot window, Student Details tab as "Instructional Program Code #2 Prefix"

2023.3

The Oklahoma UDS Term Report will now get High School Graduation Year from a different field on the Organization Tracking for Student window, Additional Info tab.

  • Formerly: Graduation Year (ad_org_tracking.yr_of_graduation)

  • Now: Graduation Date (ad_org_tracking.graduation_date)

    Organization Tracking for Student window with callouts to show that High School Graduation Year now comes from the Graduation Date field

We made the change because the year needs to be a calendar year rather than an academic year.

Issue

Description

RN49491

The Oklahoma UDS snapshot reported State and County as unknown if there was no STUDENT_MASTER record.

RN49321

The OK FAID PUB report experienced several data collection issues that are now resolved: No data was collected into the OK FAID PUB tab of the snapshot; Some students receiving aid were not included as expected; Pell Grants and Federal Direct Loan amounts may have been incorrect.

RN50366

The OK Miscellaneous Claims report did not work properly for invoices to the state fund code 701.

RN50568

In some cases the Oklahoma UDS TERM report was not collecting the correct Degree History record for the reporting period.

Issue

Description

RN43868

The Oklahoma UDS Professional Staff Report export file only included 3 Building Code characters when it should have included 7.

RN44890

On the Oklahoma UDS Degree Conferred report, when there was no data in Major_2, Program_Code_2 was blank instead of displaying 000s.

Oklahoma State Reporting with JFA

You can now produce the OK FAID PUB report with financial aid data, including housing status, from Jenzabar Financial Aid (JFA). State Reporting Snapshots for the OK FAID PUB report include a new prompt to select the Financial Aid System type that your institution uses. It pulls most of the data based on the funds posted to student accounts and determines Housing based on how it is defined on the student’s active ISIR.

You can access the OK FAID PUB report guide on MyJenzabar’s State Reporting section.

Issue

Description

RN31834

The OK Misc Claims report did not work properly for the state code of 723.

RN32162

The OTRS Monthly report reported a lower case O in the DateOfEligibility tag.

RN33585

For employees with multiple positions, the OTRS Monthly report did not always list their positions in the correct priority order. As a result, the data collection process potentially displayed the data from the incorrect position.

Issue

Description

RN26269

For loan funds where the student had multiple disbursement dates in the same period of enrollment, only one date was reported.

RN27691

Oklahoma State Report Enrollment and Multi Room files: When the Time of Day for classes is null the web import file is being set to 0000 for that field and should be set to 9999.

New Checkbox: Opted Out of TRS

Oklahoma clients have a new Opted Out of TRS checkbox available on the HR Employee Master via Payroll and Personnel windows, Details tabs. This option identifies employees that opted out of TRS and ensures they are included in the OK OTRS monthly report. As a part of this enhancement, the report includes the following new columns:

  • Hours Per Week Worked identifies the number of hours the employee typically worked in a week.

  • First Date to Report identifies the first day the employee worked/will work. This is only required for first month contributions of the employment year.

  • Optional Position indicates if the employee's position is TRS membership optional. Y indicates optional membership and N indicates mandatory membership.

  • Position Description explains the employee's position.

Issue

Description

RN23976

For the UDS Enrollment report, when a section had no building code, the output file was incorrect.

RN23978

For the UDS Enrollment report, when a section was assigned a room code with no building code, the output file incorrectly reported the room code.

Issue

Description

RN20220

Reference the Accounts Payable section for detailed information.Accounts Payable

RN20221

Reference the General Ledger section for detailed information.General Ledger

RN21245

On the Open Books report, direct deposit warrant numbers were incorrectly formatted.

Issue

Description

208457

In the OK UDS Degree Conferred snapshot > Maintain Snapshot Data, changes to the Student and Student Details tabs didn't prompt the user to save if they navigated from the tabs without saving.

RN11333

When an OK 500MISC snapshot was created with a claim number greater than 2147483648, the web import file for that snapshot ID was blank.

Changes to OK MISC Claims Report

New Product/Sub-Account Codes

The OK Misc Claims report has been updated to include Product/Sub-Account Codes. This update will meet the requirements for OMES Statewide accounting manual §3.9.1 stating that higher education agencies must use one of the ten new, two-digit codes to identify activities for reporting of agency special account (ASA) class fundings.

Use the Institutional Reporting Definitions window to  map the GL Account code associated with the Product/Sub-Account Code values. After mapping, the OK Misc Claims report process will include the Product/Sub-Account Code number in the output for paid invoices to any State Account Codes associated to the GL Account codes defined here.

Institutional Reporting Definition window. OK Oklahoma BU Reports, Oklahoma Misc Claims expanded options, Product/Sub-account code.

Changes to OK Misc 500/PFT Snapshot

State Reporting Snapshot Data window | Details tab

The data on the Details tab of OK 500 Misc/PFT snapshots is now collected in a work file, and users can make changes to it. After collecting the data/creating the snapshot using the State Reporting Snapshots window, click Maintain Snapshot Data. On the State Reporting Snapshot Data window, choose the Details tab, and edit, add, or delete data as needed.

Tip

The only row that can't be edited is ID Number.

State Reporting Snapshot Data window, Detail tab.
State Reporting Snapshot Data window | Summary tab

On the Summary tab, collection parameters have been added to the header and users can now add and delete rows.

State Reporting Snapshot Data window with options to add and delete rows shown.
Regulatory Reporting Window

The 500 Misc/PFT snapshot is now separated into two parts: Misc 500 and PFT.

Regulatory Reporting window, MISC500 report.
Regulatory Reporting window, PFT report.

The Regulatory Reporting window has been updated to use the work file for the InfoMaker report and the export view.

Issue

Description

173482

On the Maintain Snapshot window for the OK OTRS YEARLY report, deleting rows would fail and cause an error.

177974

On the Maintain Snapshot window, the OK OTRS YEARLY state report period begin date and period end date values did not display.

201240

Oklahoma Open Book Report needed to have the Warrant number changed to start with 2 plus zeros.

Issue

Description

193230

The Oklahoma Open Books State Report returned errors due to position status.

Update to OK Misc Claims Report

The OK Misc Claims report has been updated to include the CFDA/Chartfield number. Use the Institutional Reporting Definitions window to enter the External Field Values for the CFDA/Chartfield values used at your institution. Next, map to the GL Account code associated with the CFDA/Chartfield value. Once these values are entered and mapped, the OK Misc Claims report process will include the CFDA/Chartfield number in the output for paid invoices to any State Account Codes associated to the GL account codes defined here.

Institutional Reporting Definitions window, OK Oklahoma BU Reports expanded options.

Update to OK UDS (S) Student Report

  • The Citizenship-Country field has been updated to use three-character country codes.

  • A new field, Exclusion from Student Cohort, is available. Exit reasons that are acceptable for excluding a student include death, totally or permanently disabled, left to serve in the armed forced (or called up to active duty), left to serve with a foreign aid service of the federal government (Peace Corps), or left to serve on official church missions. This uses the same logic as is used for the IPEDS reporting where the Exit Reason for the current student division has an ALT Value 1 in ('04', '05', '06', '07'). Right-click on the Exit Reason column on the Student Division tab and choose Maintenance Screen to access those values.

  • Tribal code descriptions have been updated to be in line with those approved by the National Conference of the State Legislature.

  • Athletic Waiver is now included as an option for Financial Aid. If the Athletic Waiver (6) or Athletic Scholarship (R) option is selected for Financial Aid, the Intercollegiate Sports field must have a value that is not ‘Z’. In the State Reporting Snapshot Data window, the data in these columns turns red if they do not match up.

Caution

This alert does not prevent you from submitting bad data.

Update to OK UDS Enrollment (E) Report

  • The Co-Requisite Course field is now a drop-down menu with the following options:

    • S Math, Statistical

    • G Math, General Education

    • M Math, Modeling and Functions

    • A Math, College Algebra

    • E English

    • R Reading

    • N No/Not Applicable

    • Y Old Value: Yes

    Data is collected from the Catalog record in the Catalog window: Reporting Data tab: Education Success Type and Education Success Level fields. Update your Institutional Reporting Definitions Mapping for this field as needed.

  • The Country field for the Course location has been updated to use three-character country codes.

Update to OK UDS Enrollment Multiples (M) Report

The Country field for the Course location has been updated to use three-character country codes.

Update to OK UDS Professional Staff (P) Report

Reduction in Force (7) is now included as an option for Reason for Leaving. Update your Institutional Reporting Definitions Mapping for this field as needed.

Institutional Reporting Definition window, OK Oklahoma UDS Reports, OK UDS Professional Staff expanded options.

Issue

Description

164356

Employee rows can now be added and updated to OK OTRS Monthly snapshot (Maintain Snapshot Data window, OTRS Adjusted Monthly tab).

175893

Salary cents were not included in the OK State New Hire report.

178177

When opening a previously collected OTRS Monthly state report snapshot, the previously defined parameters did not appear.

Issue

Description

120315

In the Oklahoma State Reporting Filing Wizard Misc Claim/Clearing Check, if the Submitting Agency contained letters it caused problems when it was submitted. Since the OK submitting agency will always be numeric in this report, a data validation was added so that only digits could be entered.

121659

On the Tribal subtab of the Biograph window, if there were multiple rows in the bottom section, using a mouse to scroll between rows did not change the associated row in the top section.

144206

When employer fringe benefit amounts with an odd number of cents need to be split into multiple categories, a penny rounding issue could occur in the OK PFT report, resulting in the total in the summary line not matching the total of the detail amounts. Changes have been made in the data collection process to watch the rounding and make sure totals match.

165649

An RV row was added to the EX Payroll module to meet OK W-2 filing requirements.

166555

Oklahoma Financial Aid Report snapshots did not allow updates on the Maintain Snapshot Data window. Changes can now be saved to the Oklahoma Financial Aid Report snapshot on the Maintain Snapshot Data window.

168885

The OK FAID PUB report was coded to include a hard-coded check for the 2016 award year, which was causing it to report housing incorrectly. It is now corrected to reference the Financial Aid Award Year prompt.

171290

When a Vendor Name was longer than 40 characters an error occurred during the update to the ST_OK_VENDOR_LOAD table. Error will no longer appear and any changes to the vendor name after the 40th character will not trigger a name change to be reported.

171388

OK 500MISC report formatted zip incorrectly if the zip was entered with a dash in it.

172480

The Oklahoma New Hire Report was not including workstudy positions and was not removing the dash from zip codes.

Issue

Description

158444

If the Vendor FEIN starts with zero, the leading zero was not appearing on the Vendor Load report. Now the leading zero appears on the Vendor tab and the process makes sure it is prefixed as needed on the Vendor Load report and output file.

New Hire Report

Updates have been made to the Oklahoma New Hire report. The STRPT_OK_NEW_HIRE_DATA table was added to the database to capture and store the Oklahoma New Hire report data. Logic was also modified to more accurately capture the salary and hourly report data.

Issue

Description

139758

OK OESC Unemployment Report - Snapshot process needed to prompt for the state tax unemployment limit and unemployment tax rate and use those in the calculations. These parameters were added to the Snapshot Criteria window for this report code and default with the limit that has been entered on the Tax Table and the rate entered on Benefits Control for the snapshot benefit code. Snapshot data is collected into a new table (STRPT_OK_OESC_UNEMP_DATA) from which the file is generated.  The view (STRPT_OK_OESC_UNEMP_EXPORT_V) that generates the file was also modified to pull from the new table.

159402

OK New Hire report - The State of Hire was incorrectly coming from the employee address. This was changed to default to Oklahoma.

159549

OK UDS Professional Staff report - Citizenship Status was being reported with C, R, N values instead of the 1, 2, 3 values that needed to be reported.

Updates for the OK UDS Reports

OK UDS Term
Change in Data Collection

The data collection for the Cumulative Hours Earned, Cumulative GPA, and Retention GPA were updated to be pulled from the STUD_TERM_SUM_DIV table (Student Inquiry window | Summaries tab | Division subtab).

Courses Reported as Corequisites Only if Also Marked as Developmental

For Oklahoma State Reporting only, a course is reported as a corequisite only when both of these conditions are true:

  • The course is marked as a Corequisite here in the Prerequisite, Corequisite, and Prohibited Courses window | Corequisite tab.

  • The course is marked as a Developmental Course in the Student Registration window| Registration tab | Student Course Details subtab.

Thus, on the State Reporting Snapshot Data window, for Oklahoma reports, the Corequisite Course Flag checkbox will be selected only if the two conditions above are true.

OK UDS Degrees Conferred Report Now Generates Record 'S'

According to state requirements, when a student is not taking courses and a degree is conferred, Record ‘S’ must be submitted. Because of this, the OK UDS Degrees Conferred report purpose code now generates a Record 'S' along with its original Record 'D'. Data is only populated for Record 'S' if a student has a degree conferred but they did not take any courses between the Report Begin and Report End Dates. If Record 'S' is not needed because no student matches the criteria, the record will still be generated but will not contain data.

The OK UDS Degrees Conferred - Record 'S' pulls several data elements typically captured in the Student Enrollment File - Record 'S' for the OK UDS Term report. If you have recently set up the data required to generate the OK UDS Term Student report, you may have minimal data entry or data verification needed to successfully generate the OK UDS Degrees Conferred - Record 'S'.

Additional data entry and institutional reporting definition mapping are required for this new record. The steps required to generate this report are outlined in the OK UDS Degrees Conferred Report Guide available in the Oklahoma State Reporting Resource Center on MyJenzabar.net.

Issue

Description

120726

In the Associate Benefits with Retirement Eligible Compensation window, users were receiving an error when adding and deleting an associated record in the same window session.

121048

In the Benefits Control window, it was possible to mark more than one benefit as both a retirement benefit and included in retirement compensation. Validation was added to the Header tab to warn the user when a fringe benefit that was already included in retirement compensation was marked as a retirement benefit.

123344

In the Organizational Position window, users were unable to delete a position with Oklahoma-specific data.

145058

In the Calendar Year Tax report, the incorrect county code displayed.

145062

In the Calendar Year Tax report, tags had the incorrect case and tax numbers included the leading zeros.

147478

The following changes were made: processing was changed to use the sum of gross pay instead of base pay; processing now works with negative gross pay which can occur when a void has been done after the payroll has been submitted; country description now trims J1 Desktop value to a max of 40 characters.

147885

When auxiliary checks with fund code 723 were processed, the Misc Claims report had the wrong warrant type and warrant number.

151239

The data collection process for UDS Term Student reporting was collecting all students with Candidacy data in the report. We now exclude any student that is not in either the Undergraduate or Graduate division as defined on the candidacy record. The new logic will look at the IPEDS Division column in the Division Definition window and include only the Undergraduate and Graduate students.