Business Production Implementation Checklist V 1.30

Business Production Implementation Checklist v 1.30

Application(Ex: Banner, Infoed):

Prepared by:

Submitted by:

Description of changes:

Change Request number (Banner only), ex. sis_20170330a: Close once checklist completed (?): Yes No

Project document folder(s):

Nature of changes – please indicate all that apply:

New functions: Web/SelfService Client/INB Batch

Enhancements: Web/SelfService Client/INB Batch

Bug fixes: Web/SelfService Client/INB Batch

Other (explain):

Risk assessment:

Risk level: Low Medium High

Assessed by:

Brief description of risks and mitigation plans (required if Medium or High risk):

Supplementary approvals/signoffs, as necessary – indicate approver name & date of approval:

Tables/views created or altered. Include table name (Solution Architect)

New audit tables and triggers. Include table name (Team lead / delegate)

User interface, documentation/helps, menus (ICS)

Sign-off to go into production - required for Medium/High risk

Orange Flag items:YES NO

Must only be done during Banner downtime unless deemed otherwise by CEC.

GZKUTIL, SZKMUTT, SZKUTIL, SZKCONS, TWBKWBIS, BZGKHTML, TWBKLOGN, EFKCUST, HZSKTAIL, HZSKALOG, G$_NLS, G$_DATE_PKG

Implementation dates:

Instance / DB name / Planned / Actual / BP name
Dev – Hyperic deployments only
QA
Production

For BP use only:

Date / BP name
TBAN
Zark – CR
Zark - Mod

Instructions/Notes:

Please specify the order of execution of the different components by numbering them where applicable.
Database objects (packages, procedures, functions, etc…)
In Banner BP creates public synonyms and standard execute grants on ALUMNI, BANIMGR, BSACIMGR, FAISMGR, FIMSMGR, GENERAL, PAYROLL, POSNCTL, SATURN, TAISMGR, WTAILOR, BAN_DEFAULT_M and BAN_DEFAULT_Q
Please create CC oneshots for any other grants required and include them in the Programs section.
Object Name / Schema/SQLSRVR DB name / Revision / TBAN if Banner / Comments / Tested in SQL Plus?
Y / N
☐ / ☐ / ☐ /
☐ / ☐ / ☐ /
☐ / ☐ / ☐ /
☐ / ☐ / ☐ /
☐ / ☐ / ☐ /
☐ / ☐ / ☐ /
☐ / ☐ / ☐ /
☐ / ☐ / ☐ /
☐ / ☐ / ☐ /
☐ / ☐ / ☐ /
☐ / ☐ / ☐ /
☐ / ☐ / ☐ /
☐ / ☐ / ☐ /
Programs
Name examples: pzcc123.sql, szcc123.sql, view_szvmeal.sql, grant_szvmeal.sql.
Code should include all relevant statements (synonyms, grants, constraints, column comments, etc…) Include whenever sqlerror continue or whenever sqlerror exit failure where appropriate.
Data oneshots can be included here with module docs e.g. szons123.sql, szons123_module.doc
DWH implications? If modifying a table, request BP job OZRDWOBJ. Inform DWH team.
Program name / Revision / DB name / TBAN if Banner / Comments / Tested in
SQL Plus?
Y / N
☐ / ☐ / ☐ /
☐ / ☐ / ☐ /
☐ / ☐ / ☐ /
☐ / ☐ / ☐ /
☐ / ☐ / ☐ /
Audit tables & triggers
If creating an audit table or creating or modifying a trigger, request BP job OZPAUDTB (all parms required)
Parameters / Values
Schema name
Table name
Create audit table Y/N
Include large columns (data type CLOB, BLOB and BFILE) Y/N / N
Tablespace name for audit table / BANAUDIT
Tablespace name for index table / BANINDX
Create Audit trigger Y/N
Insert code for "ignore trigger" facility / N
List generated code Y/N / Y
TO activity date - YYYYMMDD HH24:MI:SS
Client forms (fmx), Banner executables (C, PRO-C)
Form name / Revision / Comments
Hyperic deployments
Group/Cluster / Select Group /
Application / Select Application
Build/deploy details / Git Release No.
Git Project
Git Hash
Java Version
Retrieve WAR file from Artifactory? Yes No
Build command? ant maven
Dev Instructions / If one or more boxes are checked, DBA’s mustbe informed prior to implementation!
New Application ☐
Stop/Start ☐ Rebuild adapter ☐
Scripts ☐ External Config changes ☐
QA Instructions / If one or more boxes are checked, DBA’s mustbe informed prior to implementation!
New Application ☐
Stop/Start ☐ Rebuild adapter ☐
Scripts ☐ External Config changes ☐
Prod Instructions / If one or more boxes are checked, DBA’s mustbe informed prior to implementation!
New Application ☐
Stop/Start ☐ Rebuild adapter ☐
Scripts ☐ External Config changes ☐
Web Tailor procedure definitions
BP jobs will run in Audit mode (rollback) followed by Update (commit)
Please provide parameter values – ALL ARE REQUIRED
BP jobs / Parameters / Values / Count of rows expected
GZOWTCOPY
(gzowtcopy.sql)
copy data from source to target database by activity dates / target db
source db
Proc name
table twgbwmnu - Y/N
table twgrmenu- Y/N
table twgrinfo- Y/N
table twgrwmrl - Y/N
table nls_lang_text - Y/N
FROM activity date - YYYYMMDD HH24:MI:SS
TO activity date - YYYYMMDD HH24:MI:SS
GZOWTINFO
(gzowtinfo.sql)
copy new label by label name / target db
source db
Proc name
twgrinfo label name
twgrinfo label sequence
twgrinfo update English text
twgrinfo update French
GZOWTINFD
(gzowtinfd.sql)
delete label by label name / target db
Proc name
twgrinfo label name
twgrinfo label sequence
GZOWTDEL
(gzowtdel.sql)
delete data from target database / target db
Proc name
table twgbwmnu - Y/N
table twgrmenu- Y/N
table twgrinfo- Y/N
table twgrwmrl - Y/N
table nls_lang_text - Y/N
FROM activity date - YYYYMMDD HH24:MI:SS
TO activity date - YYYYMMDD HH24:MI:SS
Other Web Tailor oneshot programs / Program name / Revision & Comments
ICS activities
Requester to pre-arrange with BP and ICS when timing is important
Other