 insert into CATISSUE_RELATED_TABLES_MAP values ( 31 , 73 , 'IDENTIFIER','PARTICIPANT_ID');
 insert into CATISSUE_RELATED_TABLES_MAP values ( 10 , 27 , 'IDENTIFIER','COLLECTION_PROTOCOL_ID');
 insert into CATISSUE_RELATED_TABLES_MAP values ( 31 , 27 , 'IDENTIFIER','PARTICIPANT_ID');
-insert into CATISSUE_RELATED_TABLES_MAP values ( 3 , 35 , 'IDENTIFIER','SITE_ID');
+/* Changes related to model change, replaced 35 with 92 Virender Mehta 12th Oct 2007*/
+insert into CATISSUE_RELATED_TABLES_MAP values ( 3 , 92 , 'IDENTIFIER','SITE_ID');
+/* Changes related to model change, replaced second_table_id from 35 to 92 Virender Mehta 12th Oct 2007*/
 insert into CATISSUE_RELATED_TABLES_MAP values ( 11 , 35 , 'IDENTIFIER','COLLECTION_PROTOCOL_EVENT_ID');
 insert into CATISSUE_RELATED_TABLES_MAP values ( 27 , 35 , 'IDENTIFIER','COLLECTION_PROTOCOL_REG_ID');
 insert into CATISSUE_RELATED_TABLES_MAP values ( 21 , 33 , 'IDENTIFIER','STORAGE_CONTAINER_IDENTIFIER');

insert into CATISSUE_QUERY_TABLE_DATA  ( TABLE_ID, TABLE_NAME, DISPLAY_NAME, ALIAS_NAME, PRIVILEGE_ID, FOR_SQI) values ( 35, 'CATISSUE_SPECIMEN_COLL_GROUP', 'Specimen Collection Group', 'SpecimenCollectionGroup',2,1);
insert into CATISSUE_INTERFACE_COLUMN_DATA ( IDENTIFIER, TABLE_ID, COLUMN_NAME , ATTRIBUTE_TYPE ) values ( 209, 35, 'IDENTIFIER', 'bigint');
insert into CATISSUE_INTERFACE_COLUMN_DATA ( IDENTIFIER, TABLE_ID, COLUMN_NAME , ATTRIBUTE_TYPE ) values ( 320, 35, 'NAME', 'varchar');
insert into CATISSUE_INTERFACE_COLUMN_DATA ( IDENTIFIER, TABLE_ID, COLUMN_NAME , ATTRIBUTE_TYPE ) values ( 210, 35, 'CLINICAL_DIAGNOSIS', 'varchar');
insert into CATISSUE_INTERFACE_COLUMN_DATA ( IDENTIFIER, TABLE_ID, COLUMN_NAME , ATTRIBUTE_TYPE ) values ( 211, 35, 'CLINICAL_STATUS', 'varchar');
insert into CATISSUE_INTERFACE_COLUMN_DATA ( IDENTIFIER, TABLE_ID, COLUMN_NAME , ATTRIBUTE_TYPE ) values ( 212, 35, 'ACTIVITY_STATUS', 'varchar');
insert into CATISSUE_INTERFACE_COLUMN_DATA ( IDENTIFIER, TABLE_ID, COLUMN_NAME , ATTRIBUTE_TYPE ) values ( 213, 35, 'SITE_ID', 'bigint');
insert into CATISSUE_INTERFACE_COLUMN_DATA ( IDENTIFIER, TABLE_ID, COLUMN_NAME , ATTRIBUTE_TYPE ) values ( 214, 35, 'COLLECTION_PROTOCOL_EVENT_ID', 'bigint');
insert into CATISSUE_INTERFACE_COLUMN_DATA ( IDENTIFIER, TABLE_ID, COLUMN_NAME , ATTRIBUTE_TYPE ) values ( 215, 35, 'SURGICAL_PATHOLOGY_NUMBER', 'varchar');
insert into CATISSUE_INTERFACE_COLUMN_DATA ( IDENTIFIER, TABLE_ID, COLUMN_NAME , ATTRIBUTE_TYPE ) values ( 216, 35, 'COLLECTION_PROTOCOL_REG_ID', 'bigint');

/*Bug#3549 Inserting value for ATTRIBUTE_ORDER in specimen coll grp*/
INSERT INTO CATISSUE_SEARCH_DISPLAY_DATA (RELATIONSHIP_ID, COL_ID, DISPLAY_NAME, DEFAULT_VIEW_ATTRIBUTE,ATTRIBUTE_ORDER) VALUES (30, 320, 'Name',1,1);
INSERT INTO CATISSUE_SEARCH_DISPLAY_DATA (RELATIONSHIP_ID, COL_ID, DISPLAY_NAME, DEFAULT_VIEW_ATTRIBUTE,ATTRIBUTE_ORDER) VALUES (30, 209, 'Identifier',1,12);

/* Changes related to Model Change, Replacing relationship_id from 30 to 137 Virender Mehta 12th Oct 2007*/
INSERT INTO CATISSUE_SEARCH_DISPLAY_DATA (RELATIONSHIP_ID, COL_ID, DISPLAY_NAME, DEFAULT_VIEW_ATTRIBUTE,ATTRIBUTE_ORDER) VALUES (137, 210, 'Clinical Diagnosis',1,7);
INSERT INTO CATISSUE_SEARCH_DISPLAY_DATA (RELATIONSHIP_ID, COL_ID, DISPLAY_NAME, DEFAULT_VIEW_ATTRIBUTE,ATTRIBUTE_ORDER) VALUES (137, 211, 'Clinical Status',1,8);
/* Changes related to Model Change, Replacing relationship_id from 30 to 137 Virender Mehta 12th Oct 2007*/

/*INSERT INTO CATISSUE_SEARCH_DISPLAY_DATA (RELATIONSHIP_ID, COL_ID, DISPLAY_NAME, DEFAULT_VIEW_ATTRIBUTE) VALUES (30, 212, 'Activity Status',1);*/
INSERT INTO CATISSUE_SEARCH_DISPLAY_DATA (RELATIONSHIP_ID, COL_ID, DISPLAY_NAME,ATTRIBUTE_ORDER) VALUES (48, 224, 'Collection Protocol Title',11);

INSERT INTO CATISSUE_SEARCH_DISPLAY_DATA (RELATIONSHIP_ID, COL_ID, DISPLAY_NAME, DEFAULT_VIEW_ATTRIBUTE,ATTRIBUTE_ORDER) VALUES (31, 57, 'Study Calendar Event Point', 1,9);
