Do I need to add something to my insert statement?
Nope, nothing. This is totally database side. Anytime you use a program, QA or manually insert a record; this trigger will fire.