Skip to content

To Add New Scorecard

skyhit edited this page Jun 4, 2018 · 1 revision
INSERT INTO tcs_catalog:informix.scorecard
(scorecard_id, scorecard_status_id, scorecard_type_id, project_category_id, name, version, min_score, max_score, create_user, create_date, modify_user, modify_date, version_number)
VALUES(30000420, 1, 2, 39, 'scorecard code 1', '1.0', 75, 100, '132456', '2008-11-27 14:17:32.573', '132456', '2008-11-27 14:17:32.573', 0);
INSERT INTO tcs_catalog:informix.scorecard
(scorecard_id, scorecard_status_id, scorecard_type_id, project_category_id, name, version, min_score, max_score, create_user, create_date, modify_user, modify_date, version_number)
VALUES(30000421, 1, 2, 39, 'scorecard code 2', '1.0', 75, 100, '132456', '2008-11-27 14:17:32.573', '132456', '2008-11-27 14:17:32.573', 0);
INSERT INTO tcs_catalog:informix.scorecard
(scorecard_id, scorecard_status_id, scorecard_type_id, project_category_id, name, version, min_score, max_score, create_user, create_date, modify_user, modify_date, version_number)
VALUES(30000422, 1, 2, 39, 'scorecard code 3', '1.0', 75, 100, '132456', '2008-11-27 14:17:32.573', '132456', '2008-11-27 14:17:32.573', 0);
Clone this wiki locally