« AP Direct Deposit | Main | ACH in SIS »
July 29, 2008
Table trigger summary
Admissions/Tuition Promise
st_saradap_update_row
st_saradap_insert_row
These set the rate code for incoming students
sarappd_insert_row
This sets the cohort code on students when the admit decision is positive. The endterm field gets populated from a cron job... szpecht.
Capp
insert_sgrsatt_from saradap
insert_sgrsatt_from sgbstdn
insert_sgrsatt_from_shrtram
insert_sgrsatt_from_sordegr
These deal with transfer students and populates the student attribute table with the appropriate attribute for Capp (AAOT,ASOT,ASOC)
Direct Deposit/AP
st_spraddr_insert_row
This syncs the 4 tables necessary for ap direct deposit to work on a person who updates an address. It syncs the atyp and seqno if it is a ap direct deposit vendor.
ID creation
st_spriden_update_row
st_spriden_insert_row
The big daddy. The insert one is a recursive trigger. It populates the ssn field on spbpers if the insert is coming from a student form. It checks against swbpidm to tell if it is an insert or an update. If it's a new record, a swbpidm entry gets inserted A new V number is generated from a sequence and gets inserted into spriden on the second half of the recursion.
Posted by wendlerb at July 29, 2008 2:45 PM
Comments
Post a comment
Thanks for signing in, . Now you can comment. (sign out)
(If you haven't left a comment here before, you may need to be approved by the site owner before your comment will appear. Until then, it won't appear on the entry. Thanks for waiting.)