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 |