Summary Table
Categories |
Total Count |
PII |
0 |
URL |
0 |
DNS |
0 |
EKL |
0 |
IP |
0 |
PORT |
0 |
VsID |
0 |
CF |
0 |
AI |
0 |
VPD |
0 |
PL |
0 |
Other |
0 |
File Content
INSERT INTO SeocConfig(currProgram, currProgramVersion, inMaintenanceBy)
VALUES ('PC3/Choice', 1, '');
insert into ServiceLine (id, description, serviceLineAbbr)VALUES (101, 'Medical Specialty Care', 'ABR');
insert into ServiceLine (id, description, serviceLineAbbr)VALUES (102, 'Physical Medicine & Rehabilitation', 'ABR');
insert into ServiceLine (id, description, serviceLineAbbr)VALUES (103, 'Rehabilitative Services', 'ABR');
insert into ServiceLine (id, description, serviceLineAbbr)VALUES (104, 'Infertility Care', 'ABR');
insert into ServiceLine (id, description, serviceLineAbbr) VALUES (105, 'Lab & Pathology Service', 'ABR');
--insert into ServiceLine (id, description, serviceLineAbbr) VALUES (106, 'Medical Specialty Services', 'ABR');
insert into ServiceLine (id, description, serviceLineAbbr) VALUES (107, 'Radiology', 'ABR');
insert into ServiceLine (id, description, serviceLineAbbr) VALUES (108, 'Surgical Specialty Care', 'ABR');
--insert into ServiceLine (id, description, serviceLineAbbr) VALUES (109, 'Physical Medicine & Rehabilitation1', 'ABR');
insert into ServiceLine (id, description, serviceLineAbbr) VALUES (110, 'Primary Care', 'ABR');
insert into ServiceLine (id, description, serviceLineAbbr, discontinued) VALUES (111, 'Psychology', 'ABR', true);
insert into ServiceLine (id, description, serviceLineAbbr) VALUES (112, 'Dental', 'ABR');
-- Inserting data for lookup table clinicalServiceLookup
insert into ClinicalService (id, description) VALUES (101, '12-Pulmonary');
insert into ClinicalService (id, description) VALUES (102, '13-Optometry');
insert into ClinicalService (id, description) VALUES (103, '14-Acupuncture');
insert into ClinicalService (id, description) VALUES (104, '15-General Medicine');
insert into ClinicalService (id, description, discontinued) VALUES (105, '16-Psychiatry', true);
-- Inserting data for lookup table categoryOfCareLookup
insert into CategoryOfCare (id, description, serviceLineId)VALUES (101, 'Pulmonary', 101);
insert into CategoryOfCare (id, description, serviceLineId)VALUES (102, 'Optometry', 102);
insert into CategoryOfCare (id, description, serviceLineId)VALUES (103, 'Acupuncture', 102);
insert into CategoryOfCare (id, description, serviceLineId)VALUES (104, 'Pulmonary11', 103);
insert into CategoryOfCare (id, description, serviceLineId)VALUES (105, 'Optometry11', 101);
insert into CategoryOfCare (id, description, serviceLineId)VALUES (106, 'Acupuncture11', 104);
insert into CategoryOfCare (id, description, serviceLineId)VALUES (107, 'Pulmonary12', 105);
insert into CategoryOfCare (id, description, serviceLineId)VALUES (108, 'Optometry12', 101);
insert into CategoryOfCare (id, description, serviceLineId)VALUES (109, 'Acupuncture12', 107);
insert into CategoryOfCare (id, description, serviceLineId)VALUES (110, 'Psychology Care', 111);
insert into CategoryOfCare (id, description, serviceLineId, discontinued)VALUES (111, 'Dental Care', 112, true);
-- Inserting data for status codes
insert into Status (id, description) VALUES (1, 'In-Progress');
insert into Status (id, description) VALUES (2, 'Active');
insert into Status (id, description) VALUES (3, 'Discontinued');
insert into Status (id, description) VALUES (4, 'Date Hold');
-- Inserting data for lookup table qasp
insert into Qasp (id, description) VALUES (1, 'QASP1');
insert into Qasp (id, description) VALUES (2, 'QASP2');
insert into Qasp (id, description) VALUES (3, 'QASP3');
insert into Qasp (id, description, discontinued) VALUES (4, 'QASP4', true);
--Inserting data for BillingCodes
insert into BillingCode(id, billingCode, codeType, description, precertRqd, deactivated)
VALUES(1, 'code101', 'CPT', 'description1', 0, 0);
insert into BillingCode(id, billingCode, codeType, description, precertRqd, deactivated)
VALUES(2, 'code102', 'CPT', 'description2', 0, 0);
insert into BillingCode(id, billingCode, codeType, description, precertRqd, deactivated)
VALUES(3, 'code103', 'CPT', 'description3', 1, 0);
insert into BillingCode(id, billingCode, codeType, description, precertRqd, deactivated)
VALUES(4, 'code104', 'CPT', 'description4', 1, 0);
insert into BillingCode(id, billingCode, codeType, description, precertRqd, deactivated)
VALUES(5, 'code105', 'CPT', 'description5', 1, 0);
insert into BillingCode(id, billingCode, codeType, description, precertRqd, deactivated)
VALUES(6, 'code106', 'CPT', 'description6', 1, 0);
insert into BillingCode(id, billingCode, codeType, description, precertRqd, deactivated)
VALUES(7, 'code107', 'CPT', 'description7', 1, 0);
insert into BillingCode(id, billingCode, codeType, description, precertRqd, deactivated)
VALUES(8, 'code108', 'CPT', 'description8', 1, 0);
insert into BillingCode(id, billingCode, codeType, description, precertRqd, deactivated)
VALUES(9, 'code109', 'CPT', 'description9', 1, 1);
--Insert data into HPTC table
insert into Hptc(hptc, classification, specialization, grouping)
VALUES('hptc101', 'TYPE1', '', 'GROUP1');
insert into Hptc(hptc, classification, specialization, grouping)
VALUES('hptc102', 'TYPE1', 'SPEC1', 'GROUP1');
insert into Hptc(hptc, classification, specialization, grouping)
VALUES('hptc103', 'TYPE2', 'SPEC1', '');
insert into Hptc(hptc, classification, specialization, grouping)
VALUES('hptc104', '', 'SPEC2', 'GROUP1');
insert into Hptc(hptc, classification, specialization, grouping)
VALUES('hptc105', 'TYPE1', 'SPEC1', 'GROUP2');
insert into Hptc(hptc, classification, specialization, grouping)
VALUES('hptc106', 'TYPE2', 'SPEC2', 'GROUP2');
-- Inserting data for table SEOC
--
--Discontinued
Insert into SEOC (
id,
seocKey,
name,
versionNumber,
effectiveDate,
endDate,
disclaimer,
duration,
description,
rev,
categoryOfCareId,
serviceLineId,
statusId,
qaspId,
proceduralOverview,
maxAllowableVisits,
activatedTimestamp,
activatedBy,
discontinuedTimestamp,
discontinuedBy)
VALUES(
1,
1,
'Acupuncture Initial SEOC 1.0.1',
'1.0.0',
parsedatetime('17-01-2018', 'dd-MM-yyyy'),
parsedatetime('19-01-2018', 'dd-MM-yyyy'),
'** Additional modalities such as cupping require VA approval.',
5,
'Description of Seoc MSC_ACUPUNCTURE_1.0.1',
1,
102,
102,
3,
1,
'procedural overview',
12,
parsedatetime('17-01-2018', 'dd-MM-yyyy'),
'xyz',
parsedatetime('19-01-2018', 'dd-MM-yyyy'),
'xyz',
);
--Active
Insert into SEOC (
id,
seocKey,
name,
versionNumber,
effectiveDate,
endDate,
disclaimer,
duration,
description,
rev,
categoryOfCareId,
serviceLineId,
statusId,
qaspId,
proceduralOverview,
maxAllowableVisits,
activatedTimestamp,
activatedBy,
discontinuedTimestamp,
discontinuedBy)
VALUES(
2,
2,
'Acupuncture Initial SEOC 1.0.2',
'1.0.2',
parsedatetime('17-01-2018', 'dd-MM-yyyy'),
NULL,
'** Additional modalities such as cupping require VA approval.',
5,
'Description of Seoc MSC_ACUPUNCTURE_1.0.1',
1,
103,
102,
1,
2,
'procedural overview',
10,
NULL,
NULL,
NULL,
NULL
);
--Active
Insert into SEOC (
id,
seocKey,
name,
versionNumber,
effectiveDate,
endDate,
disclaimer,
duration,
description,
rev,
categoryOfCareId,
serviceLineId,
statusId,
qaspId,
proceduralOverview,
maxAllowableVisits,
activatedTimestamp,
activatedBy,
discontinuedTimestamp,
discontinuedBy)
VALUES(
3,
3,
'Pulmonary SEOC 1.0.1',
'1.1.2',
parsedatetime('17-01-2018', 'dd-MM-yyyy'),
NULL,
'** Additional consultations needed relevant to the patient complaint/condition require VA review and approval.',
3,
'Description of Seoc MSC_PULMONARY_1.0.1',
1,
101,
101,
2,
3,
'procedural overview',
20,
parsedatetime('18-01-2018', 'dd-MM-yyyy'),
'System',
NULL,
NULL
);
--Discontinued
Insert into SEOC (
id,
seocKey,
name,
versionNumber,
effectiveDate,
endDate,
disclaimer,
duration,
description,
rev,
categoryOfCareId,
serviceLineId,
statusId,
qaspId,
proceduralOverview,
maxAllowableVisits,
activatedTimestamp,
activatedBy,
discontinuedTimestamp,
discontinuedBy)
VALUES(
4,
4,
'Optometry SEOC 1.0.0',
parsedatetime('17-01-2018', 'dd-MM-yyyy'),
parsedatetime('19-01-2018', 'dd-MM-yyyy'),
NULL,
'"*** Eyeglasses are not authorized with this referral. Eyeglass prescriptions, if indicated, will be"',
3,
'Description of Seoc MSC_OPTOMETRY_1.0.0',
1,
101,
101,
3,
1,
'procedural\n overview\n\r',
15,
parsedatetime('17-01-2018', 'dd-MM-yyyy'),
'System',
parsedatetime('19-01-2018', 'dd-MM-yyyy'),
'System'
);
--Active
Insert into SEOC (
id,
seocKey,
name,
versionNumber,
effectiveDate,
endDate,
disclaimer,
duration,
description,
rev,
categoryOfCareId,
serviceLineId,
statusId,
qaspId,
proceduralOverview,
maxAllowableVisits,
activatedTimestamp,
activatedBy,
discontinuedTimestamp,
discontinuedBy)
VALUES(
5,
5,
'try SEOC 1.0.2',
parsedatetime('17-01-2018', 'dd-MM-yyyy'),
NULL,
NULL,
'"*** Eyeglasses are not authorized with this referral. Eyeglass prescriptions, if indicated, will be"',
3,
'Description of Seoc MSC_OPTOMETRY_1.0.0',
1,
101,
101,
2,
1,
'procedural overview',
15,
parsedatetime('17-01-2018', 'dd-MM-yyyy'),
'System',
NULL,
NULL
);
--Active
Insert into SEOC (
id,
seocKey,
name,
versionNumber,
effectiveDate,
endDate,
disclaimer,
duration,
description,
rev,
categoryOfCareId,
serviceLineId,
statusId,
qaspId,
proceduralOverview,
maxAllowableVisits,
activatedTimestamp,
activatedBy,
discontinuedTimestamp,
discontinuedBy)
VALUES(
6,
18,
'SEOC Retrieve Sample',
'1.2.2',
parsedatetime('17-01-2018', 'dd-MM-yyyy'),
NULL,
'"*** Eyeglasses are not authorized with this referral. Eyeglass prescriptions, if indicated, will be"',
3,
'Description of Seoc MSC_OPTOMETRY_1.0.0',
1,
101,
101,
2,
1,
'procedural overview',
15,
parsedatetime('17-01-2018', 'dd-MM-yyyy'),
'System',
NULL,
NULL
);
--Active
Insert into SEOC (
id,
seocKey,
name,
versionNumber,
effectiveDate,
endDate,
disclaimer,
duration,
description,
rev,
categoryOfCareId,
serviceLineId,
statusId,
qaspId,
proceduralOverview,
maxAllowableVisits,
activatedTimestamp,
activatedBy,
discontinuedTimestamp,
discontinuedBy)
VALUES(
7,
11,
'SEOC Retrieve Sample',
'1.1.1',
parsedatetime('17-01-2018', 'dd-MM-yyyy'),
NULL,
'"*** Eyeglasses are not authorized with this referral. Eyeglass prescriptions, if indicated, will be"',
3,
'Description of Seoc MSC_OPTOMETRY_1.0.0',
1,
109,
107,
2,
1,
'procedural overview',
15,
parsedatetime('17-01-2018', 'dd-MM-yyyy'),
'System',
NULL,
NULL
);
--Active
Insert into SEOC (
id,
seocKey,
name,
versionNumber,
effectiveDate,
endDate,
disclaimer,
duration,
description,
rev,
categoryOfCareId,
serviceLineId,
statusId,
qaspId,
proceduralOverview,
maxAllowableVisits,
activatedTimestamp,
activatedBy,
discontinuedTimestamp,
discontinuedBy)
VALUES(
8,
12,
'SEOC Name – Long Dash',
'1.2.1',
parsedatetime('17-01-2018', 'dd-MM-yyyy'),
NULL,
'"*** “Eyeglasses are not authorized with this referral.” ‘Eyeglass prescriptions, if indicated, will be’"',
3,
'Description of Seoc MSC_OPTOMETRY_1.0.0' || CHAR(1) || CHAR(2) || CHAR(3) || CHAR(4) || CHAR(5) || CHAR(6) || CHAR(21) || CHAR(23) || CHAR(160),
1,
109,
107,
2,
1,
'procedural overview \n\r 1.first \r \n 2.second \r\n 3.third \r\n\n 4.fourth',
15,
parsedatetime('17-01-2018', 'dd-MM-yyyy'),
'System',
NULL,
NULL
);
Insert into SEOC (
id,
seocKey,
name,
versionNumber,
effectiveDate,
endDate,
disclaimer,
duration,
description,
rev,
categoryOfCareId,
serviceLineId,
statusId,
qaspId,
proceduralOverview,
maxAllowableVisits,
activatedTimestamp,
activatedBy,
discontinuedTimestamp,
discontinuedBy)
VALUES(
9,
2,
'Acupuncture Initial SEOC 1.0.2',
'1.0.2',
NULL,
NULL,
'** Additional modalities such as cupping require VA approval.',
5,
'Description of Seoc MSC_ACUPUNCTURE_1.0.1',
1,
103,
102,
1,
2,
'procedural overview',
10,
NULL,
NULL,
NULL,
NULL
);
--**Insert service data for SEOC(Acupuncture Initial SEOC 1.0.1)
Insert into Service (Id, seocId, description,frequency,frequencyType,visits, codeRequired,codedBy,codedTimestamp )
VALUES(1, 1, 'Service1', 5, 'days', 4, 'YES', 'AV', parsedatetime('17-01-2018', 'dd-MM-yyyy'));
-- Service Billing Code
Insert into ServiceBillingCode(billingCodeId, serviceId)
VALUES(1, 1);
Insert into ServiceBillingCode(billingCodeId, serviceId)
VALUES(2, 1);
Insert into ServiceBillingCode(billingCodeId, serviceId)
VALUES(3, 1);
Insert into Service (Id, seocId, description,frequency,frequencyType,visits, codeRequired,codedBy,codedTimestamp )
VALUES(2, 1, 'Service2', 5, 'days', 4, 'YES', 'AV', parsedatetime('17-01-2018', 'dd-MM-yyyy'));
-- Service Billing Code
Insert into ServiceBillingCode(billingCodeId, serviceId)
VALUES(2, 2);
Insert into ServiceBillingCode(billingCodeId, serviceId)
VALUES(3, 2);
Insert into Service (Id, seocId, description,frequency,frequencyType,visits, codeRequired,codedBy,codedTimestamp )
VALUES(3, 1, 'Service3', 5, 'days', 4, 'YES', 'AV', parsedatetime('17-01-2018', 'dd-MM-yyyy'));
-- Service Clinical Service Code
Insert into ServiceClinicalService(clinicalServiceId, serviceId)
VALUES(103, 1);
Insert into ServiceClinicalService(clinicalServiceId, serviceId)
VALUES(103, 2);
Insert into ServiceClinicalService(clinicalServiceId, serviceId)
VALUES(103, 3);
--**Insert service data for SEOC(Acupuncture Initial SEOC 1.0.2)
Insert into Service (Id, seocId, description,frequency,frequencyType,visits, codeRequired,codedBy,codedTimestamp )
VALUES(4, 2, 'Service4', 5, 'days', 4, 'NO', 'AV', parsedatetime('17-01-2018', 'dd-MM-yyyy'));
-- Service Billing Code
Insert into ServiceBillingCode(billingCodeId, serviceId)
VALUES(1, 4);
Insert into ServiceBillingCode(billingCodeId, serviceId)
VALUES(2, 4);
Insert into ServiceBillingCode(billingCodeId, serviceId)
VALUES(3, 4);
-- Service Clinical Service Code
Insert into ServiceClinicalService(clinicalServiceId, serviceId)
VALUES(103, 4);
--**Insert service data for SEOC(Pulmonary SEOC 1.0.1)
Insert into Service (Id, seocId, description,frequency,frequencyType,visits, codeRequired,codedBy,codedTimestamp )
VALUES(5, 3, 'Service5', 5, 'days', 4, 'YES', 'AV', parsedatetime('17-01-2018', 'dd-MM-yyyy'));
-- Service Billing Code
Insert into ServiceBillingCode(billingCodeId, serviceId)
VALUES(5, 5);
-- Service Clinical Service Code
Insert into ServiceClinicalService(clinicalServiceId, serviceId)
VALUES(103, 5);
Insert into ServiceClinicalService(clinicalServiceId, serviceId)
VALUES(104, 5);
--**Insert service data for SEOC(Optometry SEOC 1.0.0)
Insert into Service (Id, seocId, description,frequency,frequencyType,visits, codeRequired,codedBy,codedTimestamp )
VALUES(6, 4, 'Service6', 5, 'days', 4, 'NO', 'AV', parsedatetime('17-01-2018', 'dd-MM-yyyy'));
-- Service Clinical Service Code
Insert into ServiceClinicalService(clinicalServiceId, serviceId)
VALUES(102, 6);
--**Insert service data for SEOC(SEOC Retrieve Sample)
Insert into Service (Id, seocId, description,frequency,frequencyType,visits, codeRequired,codedBy,codedTimestamp )
VALUES(7, 6, 'Service7', 5, 'days', 4, 'NO', 'AV', parsedatetime('17-01-2018', 'dd-MM-yyyy'));
-- Service Billing Code
Insert into ServiceBillingCode(billingCodeId, serviceId)
VALUES(3, 7);
-- Service Clinical Service Code
Insert into ServiceClinicalService(clinicalServiceId, serviceId)
VALUES(103, 7);
--**Insert service data for SEOC(SEOC Retrieve Sample)
Insert into Service (Id, seocId, description,frequency,frequencyType,visits, codeRequired,codedBy,codedTimestamp )
VALUES(8, 7, 'Service7', 5, 'days', 4, 'NO', 'AV', parsedatetime('17-01-2018', 'dd-MM-yyyy'));
-- Service Billing Code
Insert into ServiceBillingCode(billingCodeId, serviceId)
VALUES(6, 8);
-- Service Clinical Service Code
Insert into ServiceClinicalService(clinicalServiceId, serviceId)
VALUES(103, 8);
---Insert Data into Event table
Insert into Event (Id, action, description)
VALUES(1, 'Save', 'Save draft SEOC (new or revised) from VA Community Care: SEOC');
Insert into Event (Id, action, description)
VALUES(2, 'Delete', 'Delete draft SEOC from VA Community Care: SEOC Administrator');
Insert into Event (Id, action, description)
VALUES(3, 'Activate', 'Activate draft SEOC (new or revised) from VA Community Care: SEOC Administrator');
Insert into Event (Id, action, description)
VALUES(4, 'Discontinue', 'Discontinue active SEOC from VA Community Care: SEOC Administrator');
Insert into Event (Id, action, description)
VALUES(5, 'Reverse', 'Reverse Date Hold SEOC from VA Community Care: SEOC Administrator');
--Insert Data into User table
Insert into SeocUser (Id,userName, vaUserId, role, deactivatedDate, createDate, modifiedDate)
VALUES(1, 'User1', 'System', 'Administrator', parsedatetime('17-01-2018', 'dd-MM-yyyy'), parsedatetime('17-01-2018', 'dd-MM-yyyy'), null);
Insert into SeocUser (Id,userName, vaUserId, role, deactivatedDate, createDate, modifiedDate)
VALUES(2, 'User2', 'DAV\System', 'Administrator', null, parsedatetime('17-01-2018', 'dd-MM-yyyy'), null);
Insert into SeocUser (Id,userName, vaUserId, role, deactivatedDate, createDate, modifiedDate)
VALUES(3, 'User3', 'DAV\System3', 'Administrator', parsedatetime('17-01-2018', 'dd-MM-yyyy'), parsedatetime('17-01-2018', 'dd-MM-yyyy'), null);
Insert into SeocUser (Id,userName, vaUserId, role, deactivatedDate, createDate, modifiedDate)
VALUES(4, 'User4', 'DAV\System4', 'Administrator', parsedatetime('17-01-2018', 'dd-MM-yyyy'), parsedatetime('17-01-2018', 'dd-MM-yyyy'), null);
Insert into SeocUser (Id,userName, vaUserId, role, deactivatedDate, createDate, modifiedDate)
VALUES(5, 'User4', 'DAV\System4', 'Administrator', null, parsedatetime('17-01-2018', 'dd-MM-yyyy'), null);
-- Insert data to establish seoc, hptc relationship
Insert into SeocHptc(seocId, hptc) VALUES(1, 'hptc101');
Insert into SeocHptc(seocId, hptc) VALUES(1, 'hptc102');
Insert into SeocHptc(seocId, hptc) VALUES(2, 'hptc101');
Insert into SeocHptc(seocId, hptc) VALUES(2, 'hptc104');
Insert into SeocHptc(seocId, hptc) VALUES(2, 'hptc105');
Insert into SeocHptc(seocId, hptc) VALUES(3, 'hptc101');
Insert into SeocHptc(seocId, hptc) VALUES(3, 'hptc106');
--Insert data into HPTC clinical service table
insert into ServiceHptc(hptc, medicareCode)
VALUES('hptc101', '12');
insert into ServiceHptc(hptc, medicareCode)
VALUES('hptc102', '12');
insert into ServiceHptc(hptc, medicareCode)
VALUES('hptc103', '12');
insert into ServiceHptc(hptc, medicareCode)
VALUES('hptc101', '13');
insert into ServiceHptc(hptc, medicareCode)
VALUES('hptc101', '14');
insert into ServiceHptc(hptc, medicareCode)
VALUES('hptc102', '13');
insert into ServiceHptc(hptc, medicareCode)
VALUES('hptc103', '13');
insert into ServiceHptc(hptc, medicareCode)
VALUES('hptc105', '14');
insert into ServiceHptc(hptc, medicareCode)
VALUES('hptc105', '15');
insert into ServiceHptc(hptc, medicareCode)
VALUES('hptc106', '15');