CREATE PROCEDURE MIG_CREATE_ENTRIES_IN_MIG_STANDARD_DOC_TYPE_MAPPING_Sp
AS
BEGIN

	DELETE from MIG_STANDARD_DOC_TYPE_MAPPING

	INSERT INTO MIG_STANDARD_DOC_TYPE_MAPPING
	(
		VALUE_ID, SHORT_DESCR, LN_DOC_TYPE, LN_DESC
	)
	VALUES
	('0', 'COMMON', 'COMMON', 'Common'), 
	('1', 'ASSEMBLY DRAWING', 'ASM_DRAWING', 'Assembly Drawing'), 
	('2', 'CONTRACT', 'CONTRACT', 'Contract'), 
	('3', 'REPORT', 'REPORT', 'Report'), 
	('4', 'ELECTRICAL DRAWING', 'ELECT_DRAWING', 'Electrical Drawing'), 
	('5', 'DETAIL DRAWING', 'DETAIL_DRAWING', 'Detail Drawing'), 
	('6', 'TECHNOLOGICAL FLOW', 'TECH_FLOW', 'Technological Flow'), 
	('7', 'FINANCIAL BALANCE', 'FINAN_BALANCE', 'Financial Balance'), 
	('8', 'PRELIMINARY DESIGN', 'PRELIM_DESIGN', 'Preliminary Design'), 
	('9', 'ELECTRIC CHART', 'ELECT_CHART', 'Electric Chart'), 
	('10', 'PAINTING SPECIFICATIONS', 'PAINT_SPECS', 'Painting Specifications'), 
	('11', 'PROCUREMENT SPECIFICATIONS', 'PROC_SPECS', 'Procurement Specifications'), 
	('12', 'MAINTENANCE SPECIFICATIONS', 'MAINT_SPECS', 'Maintenance Specifications'), 
	('13', 'Q.A. SPECIFICATIONS', 'QA_SPECS', 'QA Specifications'), 
	('14', 'UG Part', 'UG_PART', 'Siemens NX Part'), 
	('15', 'UG Assembly', 'UG_ASSEMBLY', 'Siemens NX Assembly'), 
	('16', 'UG Drawing', 'UG_DRAWING', 'Siemens NX Drawing'), 
	('17', 'PE Part', 'PE_PART', 'Creo Part'), 
	('18', 'PE Assembly', 'PE_ASSEMBLY', 'Creo Assembly'), 
	('19', 'PE Drawing', 'PE_DRAWING', 'Creo Drawing'), 
	('20', 'PE Layout', 'PE_LAYOUT', 'Creo Layout'), 
	('21', 'PE Format', 'PE_FORMAT', 'Creo Format'), 
	('22', 'PE Other', 'PE_OTHER', 'Creo Others'), 
	--('23', 'RoHS', '', ''),							--TODO:: This entry is missing in "pd" standard data-dumps.
	('24', 'RoHS Specification Sheet', 'ROHS_SPEC_SHT', 'RoHS Specification Sheet'), 
	('25', 'EDA ASSEMBLY', 'EDA_ASSEMBLY', 'EDA Assembly'), 
	('26', 'EDA FABRICATION', 'EDA_FABRI', 'EDA Fabrication'), 
	('27', 'EDA INNOVATION', 'EDA_INNOV', 'EDA Innovation'), 
	('28', 'SE Drawing', 'SE_DRAWING', 'SolidEdge Drawing'), 
	('29', 'SE Assembly', 'SE_ASSEMBLY', 'SolidEdge Assembly'), 
	('30', 'SE Part', 'SE_PART', 'SolidEdge Part'), 
	('31', 'SE Weldment', 'SE_WELD', 'SolidEdge Weldment'), 
	('32', 'SE Sheetmetal', 'SE_SHTMTL', 'SolidEdge Sheetmetal'), 
	('33', 'STD File', 'STD_FILE', 'STD File'), 
	('34', 'CFG File', 'CFG_FILE', 'CFG File'), 
	('35', 'STR File', 'STR_FILE', 'STR File'), 
	('37', 'UG Other', 'UG_OTHER', 'Siemens NX Other'), 
	('38', 'CT Drawing', 'CT_DRAWING', 'Catia Drawing'), 
	('39', 'CT Assembly', 'CT_ASSEMBLY', 'Catia Assembly'), 
	('40', 'CT Part', 'CT_PART', 'Catia Part')
END




-- exec MIG_CREATE_ENTRIES_IN_MIG_STANDARD_DOC_TYPE_MAPPING_Sp
-- SELECT * FROM MIG_STANDARD_DOC_TYPE_MAPPING ORDER BY VALUE_ID