1.3.3 Installing the Audit Triggers

Based on your database platform, find the appropriate trigger files under the Scripts folder and create triggers as listed in the table that follows. These are SQL files and should be run against your database using your query tool of choice. These trigger files have been tested on these databases using the release level specified by Oracle for PeopleSoft release 9.2 and therefore are certified for any database release level that is the same or higher. If you are running on a database release level prior to the one specified in the table, these trigger files may not be applicable. Consult with your database administrator before running these trigger files.

For Microsoft SQL Server database platform:

Table	Trigger File
ACAD_DEGR	SSR_MSS_ACAD_DEGR_TR.SQL
ACAD_DEGR_HONS	SSR_MSS_ACAD_DEGR_HONS_TR.SQL
ACAD_DEGR_PLAN	SSR_MSS_ACAD_DEGR_PLAN_TR.SQL
ACAD_DEGR_SPLN	SSR_MSS_ACAD_DEGR_SPLN_TR.SQL
ES_SECURITY_TBL	SSR_MSS_ES_SEC_TBL_TR.SQL
ES_SECURITY_DTL	SSR_MSS_ES_SEC_DTL_TR.SQL
STDNT_ENRL	SSR_MSS_GRADE_TR.SQL

For Oracle database platform:

Table	Trigger File
ACAD_DEGR	SSR_ORA_ACAD_DEGR_TR.SQL
ACAD_DEGR_HONS	SSR_ORA_ACAD_DEGR_HONS_TR.SQL
ACAD_DEGR_PLAN	SSR_ORA_ACAD_DEGR_PLAN_TR.SQL
ACAD_DEGR_SPLN	SSR_ORA_ACAD_DEGR_SPLN_TR.SQL
ES_SECURITY_TBL	SSR_ORA_ES_SEC_TBL_TR.SQL
ES_SECURITY_DTL	SSR_ORA_ES_SEC_DTL_TR.SQL
STDNT_ENRL	SSR_ORA_GRADE_TR.SQL