Good afternoon-
Thank you to those of you I met at the MACRAO meeting in Billings last week for the opportunity to share with you some of the things I’m working on in IT at OCHE. For those on this list I haven’t yet met, I look forward to seeing you at another event in the future.
I mentioned at the meeting that I am using a new software product called JIRA to track projects and issues related to the Student and Finance Data Warehouses. It is my hope that all requests for service will be routed and tracked for future reference. If you are responsible for any area of the Student Warehouse on your campus, please get in touch with me directly at jthunstrom@mso.umt.edu. I’ll get an account set up for you and provide you with some additional information to get you up and running with it. I would appreciate any information regarding others on your campus who may need accounts that wouldn’t be on this listserv as well.
I also mentioned that UM has requested a change to the way International Students are being coded. This request is cataloged in JIRA as issue SDW-4. Two of the changes require adding a column to accurately reflect the Nation Code in the Grad and Admissions tables. I would very much appreciate any feedback to determine if these changes would be appropriate for all campuses. Ideally, we could standardize around the codes, but I am open to being campus specific if need be. The most important thing is having accurate information available in the warehouse.
One other topic of discussion was in-state status exception coding for Veterans. I mentioned the possible use of the SGRVETN table (Veteran’s tab on SGASTDN) to record participation in the program. My thought at this point would be to have a record with an agreed upon code in the table (Z perhaps?) using the 999999 term code, which would allow other chapter information to be stored in the table on a term by term basis if necessary. If the student is deemed ineligible at some point, the record would be removed from the table. Any thoughts on whether this would work for your campuses?
Thank you and sorry for the long-winded initial post…
John
John Thunstrom
MUS IT Director
Office of the Commissioner of Higher Education
(406) 544-3822