Sample Oracle SQL Insert Statements

This includes a sample of Oracle SQL insert statements when creating a timed alert with the available R1 server constants. To run one of these insert statements, log in to the Civic Platform database server from SQL*Plus for Oracle as user Accela.

TIMEALERT_JOB for Oracle

INSERT INTO R1SERVER_CONSTANT
(SERV_PROV_CODE, CONSTANT_NAME, CONSTANT_VALUE, DESCRIPTION, VISIBLE, REC_DATE, REC_FUL_NAM, REC_STATUS) 
VALUES('STANDARDDATA' , 'TIMEALERT_JOB' , 'Y' , 'Time Alert Job' ,'N' , SYSDATE ,'ADMIN' , 'A')

TIME_ALERT_MONITOR_INTERVAL for Oracle

INSERT INTO R1SERVER_CONSTANT 
(SERV_PROV_CODE, CONSTANT_NAME, CONSTANT_VALUE, DESCRIPTION, VISIBLE, REC_DATE, REC_FUL_NAM, REC_STATUS) VALUES('The Specific Agency', 'TIME_ALERT_MONITOR_INTERVAL' , '900' , 'Time Alert Monitor Interval' , 'N' , SYSDATE , 'ADMIN' , 'A')

JOB_MANAGER_DEAD_TIME for Oracle

INSERT INTO R1SERVER_CONSTANT 
(SERV_PROV_CODE, CONSTANT_NAME, CONSTANT_VALUE, DESCRIPTION, VISIBLE, REC_DATE, REC_FUL_NAM, REC_STATUS) VALUES('STANDARDDATA' , 'JOB_MANAGER_DEAD_TIME' , '24' , 'Time Alert  Dead Time' , 'N' , SYSDATE , 'ADMIN' , 'A')

TIMEALERT_FLAG for Oracle

INSERT INTO R1SERVER_CONSTANT
(SERV_PROV_CODE, CONSTANT_NAME, CONSTANT_VALUE, DESCRIPTION, VISIBLE, REC_DATE, REC_FUL_NAM, REC_STATUS) VALUES('The Specific Agency', 'TIMEALERT_FLAG' , 'Y' , 'Time  Alert Flag' ,  'N' , SYSDATE , 'ADMIN' , 'A')

TIMEALERT_MONITOR_SR_INTERVAL for Oracle

INSERT INTO R1SERVER_CONSTANT 
(SERV_PROV_CODE, CONSTANT_NAME, CONSTANT_VALUE, DESCRIPTION, VISIBLE, REC_DATE, REC_FUL_NAM, REC_STATUS) VALUES ('The Specific Agency' , 'TIMEALERT_MONITOR_SR_INTERVAL_H' , '360' ,  'Time Alert Monitor SR Interval' , 'N' , SYSDATE , 'ADMIN' ,  'A')