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)
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. |
RN20221 | Reference the General Ledger section for detailed information. |
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.

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 | Summary tab
On the Summary tab, collection parameters have been added to the header and users can now add and delete rows.

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


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.

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.

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. |