CREATE PROCEDURE [MIG_CREATE_ENTRIES_IN_PROJ_CONFIG_PREF_NAMES_MAPPING_Sp]
AS BEGIN
	-- The purpose of this stored procedure is to create the data for table [MIG_PROJ_CONFIG_PREF_NAMES_MAPPING] table.


	DELETE FROM MIG_PROJ_CONFIG_PREF_NAMES_MAPPING

	INSERT INTO MIG_PROJ_CONFIG_PREF_NAMES_MAPPING(Class, Field, DataType, Label, Domain, DefaultValue, LegacyPrefName) 
	VALUES		 ('', 'proj', 'String', 'Project', 'pdproj', '', '')
				,('ITEM', 'c101', 'Enumerated', 'Check-In Item Child Items', 'pdvlt.ckin', 'pdvlt.ckin.keep.all.links', 'CHILD_LINKS_IN')
				,('ITEM', 'c102', 'Enumerated', 'Check-Out Item Child Items', 'pdvlt.cout', 'pdvlt.cout.copy.all.links', 'CHILD_LINKS')
				,('ITEM', 'c103', 'Enumerated', 'Check-In Item Parent Items', 'pdvlt.ckin', 'pdvlt.ckin.keep.all.links', 'PARENT_LINKS_IN')
				,('ITEM', 'c104', 'Enumerated', 'Check-Out Item Parent Items', 'pdvlt.cout', 'pdvlt.cout.copy.all.links', 'PARENT_LINKS')
				,('ITEM', 'c105', 'Enumerated', 'Check-In Item Related Documents', 'pdvlt.ckin', 'pdvlt.ckin.chk.in.all.objs', 'RELATED_DOCS_IN')
				,('ITEM', 'c106', 'Enumerated', 'Check-Out Item Related Documents', 'pdvlt.cout', 'pdvlt.cout.chk.out.all.obj', 'RELATED_DOCS')
				,('ITEM', 'c107', 'Enumerated', 'Check-In Item Related Drawings', 'pdvlt.ckin', 'pdvlt.ckin.chk.in.all.objs', 'RELATED_DRAWING_IN')
				,('ITEM', 'c108', 'Enumerated', 'Check-Out Item Related Drawings', 'pdvlt.cout', 'pdvlt.cout.chk.out.all.obj', 'RELATED_DRAWING')
				,('ITEM', 'c109', 'Enumerated', 'Check-In Item Related Folders', 'pdvlt.ckin', 'pdvlt.ckin.keep.all.links', 'RELATED_FLDR_IN')
				,('ITEM', 'c110', 'Enumerated', 'Check-Out Item Related Folders', 'pdvlt.cout', 'pdvlt.cout.copy.all.links', 'RELATED_FLDR')
				,('ITEM', 'c111', 'Enumerated', 'Check-In Item Related Materials', 'pdvlt.ckin', 'pdvlt.ckin.keep.all.links', 'RELATED_MTRL_IN')
				,('ITEM', 'c112', 'Enumerated', 'Check-Out Item Related Materials', 'pdvlt.cout', 'pdvlt.cout.copy.all.links', 'RELATED_MTRL')
				,('ITEM', 'c113', 'Enumerated', 'Check-In Item Related Notes', 'pdvlt.ckin', 'pdvlt.ckin.keep.all.links', 'RELATED_NOTES_IN')
				,('ITEM', 'c114', 'Enumerated', 'Check-Out Item Related Notes', 'pdvlt.cout', 'pdvlt.cout.copy.all.links', 'RELATED_NOTES')
				,('ITEM', 'c115', 'Enumerated', 'Check-In Item Related Subcontractors', 'pdvlt.ckin', 'pdvlt.ckin.keep.all.links', 'RELATED_SUB_IN')
				,('ITEM', 'c116', 'Enumerated', 'Check-Out Item Related Subcontractors', 'pdvlt.cout', 'pdvlt.cout.copy.all.links', 'RELATED_SUB')
				,('ITEM', 'c117', 'Enumerated', 'Item Child Status', 'pdyesno', 'pdyesno.no', 'ITM_SON_STATUS')
				,('ITEM', 'c119', 'Enumerated', 'Check-In Item Related Business Processes', 'pdvlt.ckin', 'pdvlt.ckin.keep.all.links', 'RELATED_EOS_IN')
				,('ITEM', 'c120', 'Enumerated', 'Check-Out Item Related Business Processes', 'pdvlt.cout', 'pdvlt.cout.copy.all.links', 'RELATED_EOS')
				,('ITEM', 'c121', 'Enumerated', 'Check-In Item Related Business Process Route Step', 'pdvlt.ckin', 'pdvlt.ckin.keep.all.links', 'RELATED_EUS_IN')
				,('ITEM', 'c122', 'Enumerated', 'Check-Out Item Related Businsess Process Route Step Item', 'pdvlt.cout', 'pdvlt.cout.copy.all.links', 'RELATED_EUS')
				,('ITEM', 'c123', 'Enumerated', 'Check-Out Configuration for Local Alternative Items', 'pdvlt.cout', 'pdvlt.cout.copy.all.links', '')
				,('ITEM', 'c124', 'Enumerated', 'Check-Out Configuration for Item Category Data', 'pdvlt.cout', 'pdvlt.cout.copy.all.links', '')
				,('ITEM', 'c125', 'Enumerated', 'Check-Out Configuration for Item Reference Designators', 'pdvlt.cout', 'pdvlt.cout.copy.all.links', '')
				,('DOC', 'c201', 'Enumerated', 'Check-In Document Child Documents', 'pdvlt.ckin', 'pdvlt.ckin.chk.in.all.objs', 'CHILD_LINKS_IN')
				,('DOC', 'c202', 'Enumerated', 'Check-Out Document Child Documents', 'pdvlt.cout', 'pdvlt.cout.copy.all.links', 'CHILD_LINKS')
				,('DOC', 'c203', 'Enumerated', 'Check-In Document Reference Documents', 'pdvlt.ckin', 'pdvlt.ckin.keep.all.links', 'LOGICAL_LINK_IN')
				,('DOC', 'c204', 'Enumerated', 'Check-Out Document Reference Documents', 'pdvlt.cout', 'pdvlt.cout.copy.all.links', 'LOGICAL_LINK')
				,('DOC', 'c205', 'Enumerated', 'Check-In Document Parent Documents', 'pdvlt.ckin', 'pdvlt.ckin.keep.all.links', 'PARENT_LINKS_IN')
				,('DOC', 'c206', 'Enumerated', 'Check-Out Document Parent Documents', 'pdvlt.cout', 'pdvlt.cout.copy.all.links', 'PARENT_LINKS')
				,('DOC', 'c207', 'Enumerated', 'Check-In Document Related Files', 'pdvlt.ckin', 'pdvlt.ckin.chk.in.all.objs', 'RELATED_FILE_IN')
				,('DOC', 'c208', 'Enumerated', 'Check-Out Document Related Files', 'pdvlt.cout', 'pdvlt.cout.chk.out.all.obj', 'RELATED_FILE')
				,('DOC', 'c209', 'Enumerated', 'Check-In Document Related Folders', 'pdvlt.ckin', 'pdvlt.ckin.keep.all.links', 'RELATED_FLDR_IN')
				,('DOC', 'c210', 'Enumerated', 'Check-Out Document Related Folders', 'pdvlt.cout', 'pdvlt.cout.copy.all.links', 'RELATED_FLDR')
				,('DOC', 'c211', 'Enumerated', 'Check-In Document Related Items', 'pdvlt.ckin', 'pdvlt.ckin.chk.in.all.objs', 'RELATED_ITEM_IN')
				,('DOC', 'c212', 'Enumerated', 'Check-Out Document Related Items', 'pdvlt.cout', 'pdvlt.cout.chk.out.all.obj', 'RELATED_ITEM')
				,('DOC', 'c213', 'Enumerated', 'Check-In Document Related Models', 'pdvlt.ckin', 'pdvlt.ckin.keep.all.links', 'RELATED_MODEL_IN')
				,('DOC', 'c214', 'Enumerated', 'Check-Out Document Related Models', 'pdvlt.cout', 'pdvlt.cout.copy.all.links', 'RELATED_MODEL')
				,('DOC', 'c215', 'Enumerated', 'Check-In Document Related Notes', 'pdvlt.ckin', 'pdvlt.ckin.keep.all.links', 'RELATED_NOTES_IN')
				,('DOC', 'c216', 'Enumerated', 'Check-Out Document Related Notes', 'pdvlt.cout', 'pdvlt.cout.copy.all.links', 'RELATED_NOTES')
				,('DOC', 'c217', 'Enumerated', 'Check-In Document Driver Documents', 'pdvlt.ckin', 'pdvlt.ckin.keep.all.links', 'RELATED_REF_DRIVER_IN')
				,('DOC', 'c218', 'Enumerated', 'Check-Out Document Driver Documents', 'pdvlt.cout', 'pdvlt.cout.copy.all.links', 'RELATED_REF_DRIVER')
				,('DOC', 'c219', 'Enumerated', 'Check-In Document Impacted  Documents', 'pdvlt.ckin', 'pdvlt.ckin.keep.all.links', 'RELATED_REF_IMPACTED_IN')
				,('DOC', 'c220', 'Enumerated', 'Check-Out Document Impacted  Documents', 'pdvlt.cout', 'pdvlt.cout.copy.all.links', 'RELATED_REF_IMPACTED')
				,('DOC', 'c221', 'Enumerated', 'Document Child Status', 'pdyesno', 'pdyesno.no', 'DOC_SON_STATUS')
				,('DOC', 'c223', 'Enumerated', 'Check-In Document Related Materials', 'pdvlt.ckin', 'pdvlt.ckin.keep.all.links', 'RELATED_MTRL_IN')
				,('DOC', 'c224', 'Enumerated', 'Check-Out Document Related Materials', 'pdvlt.cout', 'pdvlt.cout.copy.all.links', 'RELATED_MTRL')
				,('DOC', 'c225', 'Enumerated', 'Check-In Document Related Business Processes', 'pdvlt.ckin', 'pdvlt.ckin.keep.all.links', 'RELATED_EOS_IN')
				,('DOC', 'c226', 'Enumerated', 'Check-Out Document Related Business Processes', 'pdvlt.cout', 'pdvlt.cout.copy.all.links', 'RELATED_EOS')
				,('DOC', 'c227', 'Enumerated', 'Check-In Document Related Business Process Route Step', 'pdvlt.ckin', 'pdvlt.ckin.keep.all.links', 'RELATED_EUS_IN')
				,('DOC', 'c228', 'Enumerated', 'Check-Out Document Related Business Process Route Step', 'pdvlt.cout', 'pdvlt.cout.copy.all.links', 'RELATED_EUS')
				,('DOC', 'c229', 'Enumerated', 'Check-Out Configuration for Document Category Data', 'pdvlt.cout', 'pdvlt.cout.copy.all.links', '')
				,('DOC', 'c230', 'Enumerated', 'Check-Out Configuration for Document TAA', 'pdvlt.cout', 'pdvlt.cout.copy.all.links', '')
				,('DOC', 'c231', 'Enumerated', 'Check-Out Configuration for Document Distribution Lists', 'pdvlt.cout', 'pdvlt.cout.copy.all.links', '')
				,('FOLDER', 'c301', 'Enumerated', 'Check-In Folder Child Folders', 'pdvlt.ckin', 'pdvlt.ckin.keep.all.links', 'CHILD_LINKS_IN')
				,('FOLDER', 'c302', 'Enumerated', 'Check-Out Folder Child Folders', 'pdvlt.cout', 'pdvlt.cout.copy.all.links', 'CHILD_LINKS')
				,('FOLDER', 'c303', 'Enumerated', 'Check-In Folder Reference Folders', 'pdvlt.ckin', 'pdvlt.ckin.keep.all.links', 'LOGICAL_LINK_IN')
				,('FOLDER', 'c304', 'Enumerated', 'Check-Out Folder Reference Folders', 'pdvlt.cout', 'pdvlt.cout.copy.all.links', 'LOGICAL_LINK')
				,('FOLDER', 'c305', 'Enumerated', 'Check-In Folder Parent Folders', 'pdvlt.ckin', 'pdvlt.ckin.keep.all.links', 'PARENT_LINKS_IN')
				,('FOLDER', 'c306', 'Enumerated', 'Check-Out Folder Parent Folders', 'pdvlt.cout', 'pdvlt.cout.copy.all.links', 'PARENT_LINKS')
				,('FOLDER', 'c307', 'Enumerated', 'Check-In Folder Related Documents', 'pdvlt.ckin', 'pdvlt.ckin.keep.all.links', 'RELATED_DOCS_IN')
				,('FOLDER', 'c308', 'Enumerated', 'Check-Out Folder Related Documents', 'pdvlt.cout', 'pdvlt.cout.copy.all.links', 'RELATED_DOCS')
				,('FOLDER', 'c309', 'Enumerated', 'Check-In Folder Related Items', 'pdvlt.ckin', 'pdvlt.ckin.keep.all.links', 'RELATED_ITEM_IN')
				,('FOLDER', 'c310', 'Enumerated', 'Check-Out Folder Related Items', 'pdvlt.cout', 'pdvlt.cout.copy.all.links', 'RELATED_ITEM')
				,('FOLDER', 'c311', 'Enumerated', 'Folder Child Status', 'pdyesno', 'pdyesno.no', 'FLD_SON_STATUS')
				,('FOLDER', 'c313', 'Enumerated', 'Check-In Folder Related Materials', 'pdvlt.ckin', 'pdvlt.ckin.keep.all.links', 'RELATED_MTRL_IN')
				,('FOLDER', 'c314', 'Enumerated', 'Check-Out Folder Related Materials', 'pdvlt.cout', 'pdvlt.cout.copy.all.links', 'RELATED_MTRL')
				,('MATERIAL', 'c401', 'Enumerated', 'Check-In Material Related Items', 'pdvlt.ckin', 'pdvlt.ckin.keep.all.links', 'RELATED_ITEM_IN')
				,('MATERIAL', 'c402', 'Enumerated', 'Check-Out Material Related Items', 'pdvlt.cout', 'pdvlt.cout.copy.all.links', 'RELATED_ITEM')
				,('MATERIAL', 'c403', 'Enumerated', 'Check-In Material Related Documents', 'pdvlt.ckin', 'pdvlt.ckin.keep.all.links', 'RELATED_DOCS_IN')
				,('MATERIAL', 'c404', 'Enumerated', 'Check-Out Material Related Documents', 'pdvlt.cout', 'pdvlt.cout.copy.all.links', 'RELATED_DOCS')
				,('MATERIAL', 'c405', 'Enumerated', 'Check-In Material Related Folders', 'pdvlt.ckin', 'pdvlt.ckin.keep.all.links', 'RELATED_FLDR_IN')
				,('MATERIAL', 'c406', 'Enumerated', 'Check-Out Material Related Folders', 'pdvlt.cout', 'pdvlt.cout.copy.all.links', 'RELATED_FLDR')
				,('MATERIAL', 'c407', 'Enumerated', 'Check-In Material Related Business Processes', 'pdvlt.ckin', 'pdvlt.ckin.keep.all.links', 'RELATED_EOS_IN')
				,('MATERIAL', 'c408', 'Enumerated', 'Check-Out Material Related Business Processes', 'pdvlt.cout', 'pdvlt.cout.copy.all.links', 'RELATED_EOS')
				,('MATERIAL', 'c409', 'Enumerated', 'Check-In Material Related Business Process Route Step', 'pdvlt.ckin', 'pdvlt.ckin.keep.all.links', 'RELATED_EUS_IN')
				,('MATERIAL', 'c410', 'Enumerated', 'Check-Out Material Related Business Process Route Step', 'pdvlt.cout', 'pdvlt.cout.copy.all.links', 'RELATED_EUS')
				,('MATERIAL', 'c411', 'Enumerated', 'Check-Out Configuration for Material Category Data', 'pdvlt.cout', 'pdvlt.cout.copy.all.links', '')
	
END

-- exec MIG_CREATE_ENTRIES_IN_PROJ_CONFIG_PREF_NAMES_MAPPING_Sp
-- SELECT * FROM MIG_PROJ_CONFIG_PREF_NAMES_MAPPING




