REPORTS

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')