Fiscal Year End Closeout - Table Freeze Notes

Problem Description : 

Fiscal Year End Closeout IT Procedures

 Resolution : 

When sending in the ticket to place the database in restricted mode there are specific users that need to be allowed access.

BANSECR_SLIFSEY;  

BANSECR_TPITTMAN;  

BANSECR_TROYS;  

Taylor Perdue (taylorp); 

Kenny Hutto (kennyh)

Megan Davidson (megand)

Kelly Griffin (kellyg)

Britt Lifsey (brittl) - Institutional Research

iradmin - Institutional Research

degreeworks user

crystalweb - For Crystal Web and Argos Reporting

argos_update - Argos Reporting

otgmg - Banner Document Management

Additional steps for ITS to provide gurjobs functionality during the year-end closeout

grant restricted session to genlprd;

grant restricted session to banjsproxy;

grant restricted session to saisusr;

restart banjob

Below are the tables that are captured after the closeout process is completed (e.g. XX = year)

TBBDETC_20XX

TBBCTRL_20XX

TBBEACT_20XX

TBBTBDS_20XX

TBRACCD_20XX

TBRACCT_20XX

TBRAPPL_20XX

TBRDEPO_20XX

TBBMISC_20XX

TBRMISD_20XX

TBBETBD_20XX

ZURGFTT_20XX

 Revision Date : 7/2/2019