INSERT INTO EPL_STATUS (STATUS_ID,STATUS_NAME,STATUS_DESC,CREATED_BY, CREATED_DTM) VALUES (1,'Update File Initiated','File Creation Process Has Been Initiated','Initial Load',sysdate);
INSERT INTO EPL_STATUS (STATUS_ID,STATUS_NAME,STATUS_DESC,CREATED_BY, CREATED_DTM) VALUES (2,'Update File Created ','All changes to drug information in PPS-N have been collected into a file and placed on the file system','Initial Load',sysdate);
INSERT INTO EPL_STATUS (STATUS_ID,STATUS_NAME,STATUS_DESC,CREATED_BY, CREATED_DTM) VALUES (3,'Update File Transmitted to Test FTP','Transmission of the Created file to the test FTP location has been completed','Initial Load',sysdate);
INSERT INTO EPL_STATUS (STATUS_ID,STATUS_NAME,STATUS_DESC,CREATED_BY, CREATED_DTM) VALUES (4,'National Test VistA Installation Started','The Test VistA instance has started the update file process','Initial Load',sysdate);
INSERT INTO EPL_STATUS (STATUS_ID,STATUS_NAME,STATUS_DESC,CREATED_BY, CREATED_DTM) VALUES (5,'National Test VistA Installation Completed','The Test VistA instance has processed the update file and is ready for testing. A user may now access the Update approval functionality of PPS-N','Initial Load',sysdate);
INSERT INTO EPL_STATUS (STATUS_ID,STATUS_NAME,STATUS_DESC,CREATED_BY, CREATED_DTM) VALUES (6,'Approved by Test','A user has marked this update as Approved in the update management area of PPS-N','Initial Load',sysdate);
INSERT INTO EPL_STATUS (STATUS_ID,STATUS_NAME,STATUS_DESC,CREATED_BY, CREATED_DTM) VALUES (7,'Rejected by Test','A user has marked this update as Rejected in the update management area of PPS-N','Initial Load',sysdate);
INSERT INTO EPL_STATUS (STATUS_ID,STATUS_NAME,STATUS_DESC,CREATED_BY, CREATED_DTM) VALUES (8,'Update File Transmitted to Production FTP','Transmission of the approved file to the production FTP location has been completed','Initial Load',sysdate);
INSERT INTO EPL_STATUS (STATUS_ID,STATUS_NAME,STATUS_DESC,CREATED_BY, CREATED_DTM) VALUES (99,'NDF Update Process Error','An error occurred during NDF update file process','Initial Load',sysdate);
COMMIT;