Trigger Naming Conventions

This table contains the trigger naming convention for each database type:

Database

Object Name

Object Attribute

Oracle

Fxxxx_CFRA_RDA

Row Level Delete Trigger

Fxxxx_CFRA_RIA

Row Level Insert Trigger

N/A

Fxxxx_CFRA_RUA

Row Level Update Trigger

N/A

Fxxxx_CFRA_SUA

Statement Level Update Trigger

N/A

Fxxxx_CFRA_SUB

Statement Level Update Trigger

N/A

Fxxxx_ADT_CFRA_PKG

Package

N/A

F95xxxxx_CFRS_RIUB

Signature/Audit Header/Audit Detail Table Insert and Update Triggers

N/A

DB2 for i and DB2 for Linux, UNIX, and Windows database

Fxxxx_CFRA_RDA

Row Level Delete Trigger

Fxxxx_CFRA_RIA

Row Level Insert Trigger

N/A

Fxxxx_CFRA_RUA

Row Level Update Trigger

N/A

F95xxxxx_CFRS_RIB

Signature / Audit Header / Audit Detail Table Insert Triggers

N/A

F95xxxxx_CFRS_RUB

Signature / Audit Header / Audit Detail Table Update Triggers

N/A

SQL Server

Fxxxx_CFRA_RDB

Statement Level Delete Trigger

Fxxxx_CFRA_RIB

Statement Level Insert Trigger

N/A

Fxxxx_CFRA_RUB

Statement Level Update Trigger

N/A

F95xxxxx_CFRS_RIB

Signature/Audit Header/Audit Detail Table Insert and Update Triggers

N/A