Customer Service and Conservation (CSC) :,,
,,
Sl. No.,BarCode Value,Form Name
CREATE TABLE CS_BARCODE
(
idCS INT,
FormId NVARCHAR(64) not null
FormName NVARCHAR(64) not null
CONSTRAINT pk_CS_id PRIMARY KEY(idCS)
);
GO
INSERT INTO dbo.CS_BARCODE
(idCS,FormId,FormName)
values (
1,'METCS0101','Full Maturity Release')
INSERT INTO dbo.CS_BARCODE
(idCS,FormId,FormName)
values (
2,'METCS0201','Partial Maturity Payment Ins.')
INSERT INTO dbo.CS_BARCODE
(idCS,FormId,FormName)
values (
3,'METCS0301','Request for Surrender')
INSERT INTO dbo.CS_BARCODE
(idCS,FormId,FormName)
values (
4,'METCS0401','Loan Application Form')
INSERT INTO dbo.CS_BARCODE
(idCS,FormId,FormName)
values (
5,'METCS0501','Medical Form - CSC')
INSERT INTO dbo.CS_BARCODE
(idCS,FormId,FormName)
values (
6,'METCS0601','Service Call Ckeck List')
INSERT INTO dbo.CS_BARCODE
(idCS,FormId,FormName)
values (
7,'METCS0701','Request to Change')
INSERT INTO dbo.CS_BARCODE
(idCS,FormId,FormName)
values (
8,'METCS0801','Application for Reinstatement - Juvenile')
INSERT INTO dbo.CS_BARCODE
(idCS,FormId,FormName)
values (
9,'METCS0901','Rider Change')
INSERT INTO dbo.CS_BARCODE
(idCS,FormId,FormName)
values (
10,'METCS1001','Mode & Others Change')
INSERT INTO dbo.CS_BARCODE
(idCS,FormId,FormName)
values (
11,'METCS1101','FA Change')
INSERT INTO dbo.CS_BARCODE
(idCS,FormId,FormName)
values (
12,'METCS1201','Plan/Term Change')
INSERT INTO dbo.CS_BARCODE
(idCS,FormId,FormName)
values (
13,'METCS1301','Name/Signature/Age Change')
INSERT INTO dbo.CS_BARCODE
(idCS,FormId,FormName)
values (
14,'METCS1401','Beneficiary Change')
INSERT INTO dbo.CS_BARCODE
(idCS,FormId,FormName)
values (
15,'METCS1501','Duplicate Document')
INSERT INTO dbo.CS_BARCODE
(idCS,FormId,FormName)
values (
16,'METCS1601','Correspondence')
INSERT INTO dbo.CS_BARCODE
(idCS,FormId,FormName)
values (
17,'METCS1701','Reinstatement by Re-Date')
INSERT INTO dbo.CS_BARCODE
(idCS,FormId,FormName)
values (
18,'METCS1801','DPS Reinstatement - RINBY1')
INSERT INTO dbo.CS_BARCODE
(idCS,FormId,FormName)
values (
19,'METCS1901','Additional Documents')
INSERT INTO dbo.CS_BARCODE
(idCS,FormId,FormName)
values (
20,'METCS2001','Document Received')
INSERT INTO dbo.CS_BARCODE
(idCS,FormId,FormName)
values (
23,'METCS2901','Refund Form')
INSERT INTO dbo.CS_BARCODE
(idCS,FormId,FormName)
values (
22,'METCS2201','Document Received for Policy Cancelation')
INSERT INTO dbo.CS_BARCODE
(idCS,FormId,FormName)
values (
22,'METCS2201','Document Received for Policy Cancelation')