domingo, 31 de julio de 2016

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

















No hay comentarios:

Publicar un comentario

Blogger Widgets