stcwp
Database
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
STCW.TR_STUDENT_H
Parameters
Name
Type
Mode
Definition
TRIGGER "STCW"."TR_STUDENT_H" AFTER INSERT OR UPDATE OR DELETE ON STUDENT REFERENCING OLD AS early NEW AS late FOR EACH row DECLARE action VARCHAR2(75); BEGIN IF INSERTING THEN action := 'INSERTING'; INSERT INTO STCW_HISTORY.STUDENT_H(STUDENT_ID, ACADEMIC_DEGREE,LEGAL_ENTITY_ID,N_ADMITTED,N_GRADUATE,MET_PROGRAMM_ID,YEAR,VERSION_ID,CUSER,CDATE,MUSER,MDATE, action) VALUES(:late.STUDENT_ID,:late.ACADEMIC_DEGREE,:late.LEGAL_ENTITY_ID,:late.N_ADMITTED,:late.N_GRADUATE,:late.MET_PROGRAMM_ID,:late.YEAR,:late.VERSION_ID,:late.CUSER,:late.CDATE,:late.MUSER,:late.MDATE, action); ELSIF UPDATING THEN action := 'UPDATING'; INSERT INTO STCW_HISTORY.STUDENT_H(STUDENT_ID, ACADEMIC_DEGREE,LEGAL_ENTITY_ID,N_ADMITTED,N_GRADUATE,MET_PROGRAMM_ID,YEAR,VERSION_ID,CUSER,CDATE,MUSER,MDATE, action) VALUES(:late.STUDENT_ID,:late.ACADEMIC_DEGREE,:late.LEGAL_ENTITY_ID,:late.N_ADMITTED,:late.N_GRADUATE,:late.MET_PROGRAMM_ID,:late.YEAR,:late.VERSION_ID,:late.CUSER,:late.CDATE,:late.MUSER,:late.MDATE, action); ELSE action := 'DELETING'; INSERT INTO STCW_HISTORY.STUDENT_H(STUDENT_ID, ACADEMIC_DEGREE,LEGAL_ENTITY_ID,N_ADMITTED,N_GRADUATE,MET_PROGRAMM_ID,YEAR,VERSION_ID,CUSER,CDATE,MUSER,MDATE, action) VALUES(:early.STUDENT_ID,:early.ACADEMIC_DEGREE,:early.LEGAL_ENTITY_ID,:early.N_ADMITTED,:early.N_GRADUATE,:early.MET_PROGRAMM_ID,:early.YEAR,:early.VERSION_ID,:early.CUSER,:early.CDATE,:early.MUSER,:early.MDATE, action); END IF; END;