delete from DocumentDetection where CodeLabel like 'D-%';
DBCC CHECKIDENT('DocumentDetection', RESEED, 0);
insert into DocumentDetection (CodeLabel,FileCode,Description,DetectionMethod,ViewOrientation,PageLimit,ReferenceMap) values ('D-0000C','0C','Type C',1,1,1,NULL);
insert into DocumentDetection (CodeLabel,FileCode,Description,DetectionMethod,ViewOrientation,PageLimit,ReferenceMap) values ('D-0003B','3B','Nursing Home Type Patient (Acute Care)',1,1,1,NULL);
insert into DocumentDetection (CodeLabel,FileCode,Description,DetectionMethod,ViewOrientation,PageLimit,ReferenceMap) values ('D-000PS','PS','Psychiatric',1,1,1,NULL);
insert into DocumentDetection (CodeLabel,FileCode,Description,DetectionMethod,ViewOrientation,PageLimit,ReferenceMap) values ('D-000RE','RE','Rehabilitation',1,1,1,NULL);
insert into DocumentDetection (CodeLabel,FileCode,Description,DetectionMethod,ViewOrientation,PageLimit,ReferenceMap) values ('D-000NE','NE','Neonate',1,1,1,NULL);
insert into DocumentDetection (CodeLabel,FileCode,Description,DetectionMethod,ViewOrientation,PageLimit,ReferenceMap) values ('D-000CC','CC','Critical care',1,1,1,NULL);
insert into DocumentDetection (CodeLabel,FileCode,Description,DetectionMethod,ViewOrientation,PageLimit,ReferenceMap) values ('D-000AC','AC','Accident',1,1,1,NULL);
insert into DocumentDetection (CodeLabel,FileCode,Description,DetectionMethod,ViewOrientation,PageLimit,ReferenceMap) values ('D-000HC','HC','Home Care',1,1,1,NULL);
insert into DocumentDetection (CodeLabel,FileCode,Description,DetectionMethod,ViewOrientation,PageLimit,ReferenceMap) values ('D-000IC','IC','Intensive Care',1,1,1,NULL);
insert into DocumentDetection (CodeLabel,FileCode,Description,DetectionMethod,ViewOrientation,PageLimit,ReferenceMap) values ('D-000WC','WC','Wound Care',1,1,1,NULL);
insert into DocumentDetection (CodeLabel,FileCode,Description,DetectionMethod,ViewOrientation,PageLimit,ReferenceMap) values ('D-000SU','SU','Special Unit',1,1,1,NULL);
insert into DocumentDetection (CodeLabel,FileCode,Description,DetectionMethod,ViewOrientation,PageLimit,ReferenceMap) values ('D-000EL','EL','Election Form',1,1,1,NULL);
insert into DocumentDetection (CodeLabel,FileCode,Description,DetectionMethod,ViewOrientation,PageLimit,ReferenceMap) values ('D-000PE','PE','PEA Certificate',1,1,1,NULL);
insert into DocumentDetection (CodeLabel,FileCode,Description,DetectionMethod,ViewOrientation,PageLimit,ReferenceMap) values ('D-000OS','OS','Overseas Certificate',1,1,1,NULL);
insert into DocumentDetection (CodeLabel,FileCode,Description,DetectionMethod,ViewOrientation,PageLimit,ReferenceMap) values ('D-000NS','NS','Non schedule 5 prosthesis',1,1,1,NULL);
insert into DocumentDetection (CodeLabel,FileCode,Description,DetectionMethod,ViewOrientation,PageLimit,ReferenceMap) values ('D-000SP','SP','Spinal surgery/neurocomplex',1,1,1,NULL);
insert into DocumentDetection (CodeLabel,FileCode,Description,DetectionMethod,ViewOrientation,PageLimit,ReferenceMap) values ('D-000LY','LY','Lymphedema',1,1,1,NULL);
insert into DocumentDetection (CodeLabel,FileCode,Description,DetectionMethod,ViewOrientation,PageLimit,ReferenceMap) values ('D-000DE','DE','Dental',1,1,1,NULL);
insert into DocumentDetection (CodeLabel,FileCode,Description,DetectionMethod,ViewOrientation,PageLimit,ReferenceMap) values ('D-000MU','MU','Multiple Admission (Chemotherapy and Dialysis)',1,1,1,NULL);
insert into DocumentDetection (CodeLabel,FileCode,Description,DetectionMethod,ViewOrientation,PageLimit,ReferenceMap) values ('D-000DO','DO','Day only for Dialysis',1,1,1,NULL);
insert into DocumentDetection (CodeLabel,FileCode,Description,DetectionMethod,ViewOrientation,PageLimit,ReferenceMap) values ('D-000RD','RD','Rehabilitation Discharge/Separation',1,1,1,NULL);
insert into DocumentDetection (CodeLabel,FileCode,Description,DetectionMethod,ViewOrientation,PageLimit,ReferenceMap) values ('D-000AD','AD','Ambulatory Discharge/Separation',1,1,1,NULL);
insert into DocumentDetection (CodeLabel,FileCode,Description,DetectionMethod,ViewOrientation,PageLimit,ReferenceMap) values ('D-000ED','ED','Early Discharge/Separation',1,1,1,NULL);
insert into DocumentDetection (CodeLabel,FileCode,Description,DetectionMethod,ViewOrientation,PageLimit,ReferenceMap) values ('D-000EX','EX','Expected Date of confinement',1,1,1,NULL);
insert into DocumentDetection (CodeLabel,FileCode,Description,DetectionMethod,ViewOrientation,PageLimit,ReferenceMap) values ('D-000EC','EC','Emergency Caesar',1,1,1,NULL);
insert into DocumentDetection (CodeLabel,FileCode,Description,DetectionMethod,ViewOrientation,PageLimit,ReferenceMap) values ('D-000FL','FL','Failed Labour',1,1,1,NULL);
insert into DocumentDetection (CodeLabel,FileCode,Description,DetectionMethod,ViewOrientation,PageLimit,ReferenceMap) values ('D-000MB','MB','Mother and Baby',1,1,1,NULL);
insert into DocumentDetection (CodeLabel,FileCode,Description,DetectionMethod,ViewOrientation,PageLimit,ReferenceMap) values ('D-000OO','OO','Obstetric Outlier',1,1,1,NULL);
insert into DocumentDetection (CodeLabel,FileCode,Description,DetectionMethod,ViewOrientation,PageLimit,ReferenceMap) values ('D-000AE','AE','Antenatal Education',1,1,1,NULL);
insert into DocumentDetection (CodeLabel,FileCode,Description,DetectionMethod,ViewOrientation,PageLimit,ReferenceMap) values ('D-000OU','OU','Outlier',1,1,1,NULL);
insert into DocumentDetection (CodeLabel,FileCode,Description,DetectionMethod,ViewOrientation,PageLimit,ReferenceMap) values ('D-000DR','DR','Exceptional Drug (non HPPA medication)',1,1,1,NULL);
insert into DocumentDetection (CodeLabel,FileCode,Description,DetectionMethod,ViewOrientation,PageLimit,ReferenceMap) values ('D-000OT','OT','Other',1,1,99,NULL);
insert into DocumentDetection (CodeLabel,FileCode,Description,DetectionMethod,ViewOrientation,PageLimit,ReferenceMap) values ('D-MP0OT','MC','Miscellaneous ',1,1,99,NULL);
insert into DocumentDetection (CodeLabel,FileCode,Description,DetectionMethod,ViewOrientation,PageLimit,ReferenceMap) values ('D-ML0OT','MC','Miscellaneous ',1,2,99,NULL);
insert into DocumentDetection (CodeLabel,FileCode,Description,DetectionMethod,ViewOrientation,PageLimit,ReferenceMap) values ('D-ML1OT','CF','Claim Form',1,2,1,NULL);
insert into DocumentDetection (CodeLabel,FileCode,Description,DetectionMethod,ViewOrientation,PageLimit,ReferenceMap) values ('D-MP0EL','CE','Continuous Election',1,1,1,NULL);
insert into DocumentDetection (CodeLabel,FileCode,Description,DetectionMethod,ViewOrientation,PageLimit,ReferenceMap) values ('D-MP2OT','PR','Prosthetic Supply',1,1,1,NULL);
insert into DocumentDetection (CodeLabel,FileCode,Description,DetectionMethod,ViewOrientation,PageLimit,ReferenceMap) values ('D-ML2OT','PR','Prosthetic Supply',1,2,1,NULL);
insert into DocumentDetection (CodeLabel,FileCode,Description,DetectionMethod,ViewOrientation,PageLimit,ReferenceMap) values ('D-0000B','0B','Type B',1,1,1,NULL);
insert into DocumentDetection (CodeLabel,FileCode,Description,DetectionMethod,ViewOrientation,PageLimit,ReferenceMap) values ('D-MP3OT','CP','Transition Care Program Agreement',1,1,3,NULL);
