-- -- Selected TOC Entries: -- \connect - postgres LOAD '/usr/lib/pgsql/modules/uniqid.so'; CREATE FUNCTION uniqidin(opaque) RETURNS opaque AS '/usr/lib/pgsql/modules/uniqid.so' LANGUAGE 'c'; CREATE FUNCTION uniqidout(opaque) RETURNS opaque AS '/usr/lib/pgsql/modules/uniqid.so' LANGUAGE 'c'; CREATE TYPE uniqueidentifier ( internallength = 16, externallength = -1, input = uniqidin, output = uniqidout ); CREATE FUNCTION uniqideq(uniqueidentifier,uniqueidentifier) RETURNS bool AS '/usr/lib/pgsql/modules/uniqid.so' LANGUAGE 'C'; CREATE OPERATOR = ( leftarg = uniqueidentifier, rightarg = uniqueidentifier, procedure = uniqideq, negator = <>, commutator = =, restrict = eqsel, join = eqjoinsel, sort1 = <, sort2 = <, hashes ); CREATE FUNCTION uniqidne(uniqueidentifier,uniqueidentifier) RETURNS bool AS '/usr/lib/pgsql/modules/uniqid.so' LANGUAGE 'C'; CREATE OPERATOR <> ( leftarg = uniqueidentifier, rightarg = uniqueidentifier, procedure = uniqidne, negator = =, commutator = <>, restrict = neqsel, join = neqjoinsel ); CREATE FUNCTION uniqidlt(uniqueidentifier,uniqueidentifier) RETURNS bool AS '/usr/lib/pgsql/modules/uniqid.so' LANGUAGE 'C'; CREATE OPERATOR < ( leftarg = uniqueidentifier, rightarg = uniqueidentifier, procedure = uniqidlt, negator = >=, commutator = >, restrict = scalarltsel, join = scalarltjoinsel ); CREATE FUNCTION uniqidle(uniqueidentifier,uniqueidentifier) RETURNS bool AS '/usr/lib/pgsql/modules/uniqid.so' LANGUAGE 'C'; CREATE OPERATOR <= ( leftarg = uniqueidentifier, rightarg = uniqueidentifier, procedure = uniqidle, negator = <, commutator = <=, restrict = scalarltsel, join = scalarltjoinsel ); CREATE FUNCTION uniqidgt(uniqueidentifier,uniqueidentifier) RETURNS bool AS '/usr/lib/pgsql/modules/uniqid.so' LANGUAGE 'C'; CREATE OPERATOR > ( leftarg = uniqueidentifier, rightarg = uniqueidentifier, procedure = uniqidgt, negator = <=, commutator = <, restrict = scalargtsel, join = scalargtjoinsel ); CREATE FUNCTION uniqidge(uniqueidentifier,uniqueidentifier) RETURNS bool as '/usr/lib/pgsql/modules/uniqid.so' language 'C'; CREATE OPERATOR >= ( leftarg = uniqueidentifier, rightarg = uniqueidentifier, procedure = uniqidge, negator = <, commutator = <=, restrict = scalargtsel, join = scalargtjoinsel ); CREATE FUNCTION uniqidcmp(uniqueidentifier,uniqueidentifier) RETURNS integer AS '/usr/lib/pgsql/modules/uniqid.so' LANGUAGE 'C'; CREATE OPERATOR <=> ( leftarg = uniqueidentifier, rightarg = uniqueidentifier, procedure = uniqidcmp ); /* set up the indexing infrastructure for btrees - first the operator class */ insert into pg_opclass (opcname, opcdeftype) select 'uniqueidentifier_ops', oid from pg_type where typname = 'uniqueidentifier'; /* next the operators for particular strategies */ create table btree_opstrategy_tmp ( oprname name, oprstrategy int2); copy btree_opstrategy_tmp from stdin; < 1 <= 2 = 3 >= 4 > 5 \. insert into pg_amop (amopid, amopclaid, amopopr, amopstrategy) select am.oid, opcl.oid, op.oid, bos.oprstrategy from pg_am am, pg_opclass opcl, btree_opstrategy_tmp bos, pg_operator op, pg_type typ where am.amname = 'btree' and opcl.opcname = 'uniqueidentifier_ops' and op.oprleft = typ.oid and op.oprright = typ.oid and typ.typname = 'uniqueidentifier' and op.oprname = bos.oprname; drop table btree_opstrategy_tmp; /* finally, the support routine */ insert into pg_amproc (amid, amopclaid, amproc, amprocnum) select a.oid, b.oid, c.oid, 1 from pg_am a, pg_opclass b, pg_proc c where a.amname = 'btree' and b.opcname = 'uniqueidentifier_ops' and c.proname = 'uniqidcmp'; CREATE FUNCTION newid() RETURNS uniqueidentifier AS '/usr/lib/pgsql/modules/uniqid.so' LANGUAGE 'C'; -- -- TOC Entry ID 7 (OID 1621509) -- -- Name: ben_plan Type: TABLE Owner: postgres -- CREATE TABLE "ben_plan" ( "ben_plan_id" uniqueidentifier NOT NULL, "ben_plan_no" smallint NOT NULL, "ben_plan_halid" integer NOT NULL, Constraint "ben_plan_pkey" Primary Key ("ben_plan_id") ); -- -- TOC Entry ID 8 (OID 1621524) -- -- Name: coverage_step Type: TABLE Owner: postgres -- CREATE TABLE "coverage_step" ( "ben_plan_id" uniqueidentifier NOT NULL, "cvgstep_id" uniqueidentifier NOT NULL, "cvgstep_desc" character varying(150) NOT NULL, "cvgstep_per_emp_flat_amt" integer, "mdfy_dt" timestamp with time zone NOT NULL, Constraint "coverage_step_pkey" Primary Key ("ben_plan_id", "cvgstep_id") ); -- -- TOC Entry ID 9 (OID 1621541) -- -- Name: cvg_rptd Type: TABLE Owner: postgres -- CREATE TABLE "cvg_rptd" ( "emp_grp_id" uniqueidentifier NOT NULL, "ben_plan_id" uniqueidentifier NOT NULL, "grp_rate_id" uniqueidentifier NOT NULL, "rate_step_id" uniqueidentifier NOT NULL, "rptg_prd_end_dt" date NOT NULL, "rptg_seq_id" uniqueidentifier NOT NULL, "rptg_session_id" uniqueidentifier, "cvg_rptd_sts_cd" smallint, "cvg_rptd_except_sts_cd" smallint, "cvg_rptd_except_desc" character varying(150), "mdfy_dt" timestamp with time zone NOT NULL, Constraint "cvg_rptd_pkey" Primary Key ("emp_grp_id", "ben_plan_id", "grp_rate_id", "rate_step_id", "rptg_seq_id", "rptg_prd_end_dt") ); -- -- TOC Entry ID 10 (OID 1621564) -- -- Name: emp_grp Type: TABLE Owner: postgres -- CREATE TABLE "emp_grp" ( "emp_grp_id" uniqueidentifier NOT NULL, "emp_grp_halid" integer NOT NULL, "emp_grp_nm" character varying(100) NOT NULL, "emp_grp_typ" smallint NOT NULL, "mdfy_dt" timestamp with time zone NOT NULL, Constraint "emp_grp_pkey" Primary Key ("emp_grp_id") ); -- -- TOC Entry ID 11 (OID 1621581) -- -- Name: grp_rate Type: TABLE Owner: postgres -- CREATE TABLE "grp_rate" ( "emp_grp_id" uniqueidentifier NOT NULL, "ben_plan_id" uniqueidentifier NOT NULL, "grp_rate_id" uniqueidentifier NOT NULL, "grp_rate_eff_dt" date NOT NULL, "grp_rate_term_dt" date, Constraint "grp_rate_pkey" Primary Key ("emp_grp_id", "ben_plan_id", "grp_rate_id") ); -- -- TOC Entry ID 12 (OID 1621598) -- -- Name: grp_rate_step Type: TABLE Owner: postgres -- CREATE TABLE "grp_rate_step" ( "emp_grp_id" uniqueidentifier NOT NULL, "ben_plan_id" uniqueidentifier NOT NULL, "grp_rate_id" uniqueidentifier NOT NULL, "rate_step_id" uniqueidentifier NOT NULL, "rate_fmt_flat_amt" numeric(9,2), "rate_fmt_salary_pct" numeric(6,4), "rate_fmt_dollars_per_ten_cvg" numeric(7,4), "rate_fmt_dollars_per_thou_cvg" numeric(7,4), "mdfy_dt" timestamp with time zone NOT NULL, Constraint "grp_rate_step_pkey" Primary Key ("emp_grp_id", "ben_plan_id", "grp_rate_id", "rate_step_id") ); -- -- TOC Entry ID 13 (OID 1621619) -- -- Name: mo_cvg_rptd Type: TABLE Owner: postgres -- CREATE TABLE "mo_cvg_rptd" ( "emp_grp_id" uniqueidentifier NOT NULL, "ben_plan_id" uniqueidentifier NOT NULL, "grp_rate_id" uniqueidentifier NOT NULL, "rate_step_id" uniqueidentifier NOT NULL, "rptg_prd_end_dt" date NOT NULL, "rptg_seq_id" uniqueidentifier NOT NULL, "mo_cvg_rptd_emp_count" integer, Constraint "mo_cvg_rptd_pkey" Primary Key ("emp_grp_id", "ben_plan_id", "grp_rate_id", "rate_step_id", "rptg_seq_id", "rptg_prd_end_dt") ); -- -- TOC Entry ID 14 (OID 1621638) -- -- Name: pay_prd_cvg_rptd Type: TABLE Owner: postgres -- CREATE TABLE "pay_prd_cvg_rptd" ( "emp_grp_id" uniqueidentifier NOT NULL, "ben_plan_id" uniqueidentifier NOT NULL, "grp_rate_id" uniqueidentifier NOT NULL, "rate_step_id" uniqueidentifier NOT NULL, "rptg_seq_id" uniqueidentifier NOT NULL, "rptg_prd_end_dt" date NOT NULL, "pay_prd_rptd_contribtry_earn" numeric(9,2), "pay_prd_rptd_emp_count" integer, Constraint "pay_prd_cvg_rptd_pkey" Primary Key ("emp_grp_id", "ben_plan_id", "grp_rate_id", "rate_step_id", "rptg_seq_id", "rptg_prd_end_dt") ); -- -- TOC Entry ID 15 (OID 1621658) -- -- Name: rate_step Type: TABLE Owner: postgres -- CREATE TABLE "rate_step" ( "rate_step_id" uniqueidentifier NOT NULL, "rate_step_nm" character varying(100), "rate_step_desc" character varying(150), Constraint "rate_step_pkey" Primary Key ("rate_step_id") ); -- -- TOC Entry ID 16 (OID 1621673) -- -- Name: rptg_seq Type: TABLE Owner: postgres -- CREATE TABLE "rptg_seq" ( "rptg_seq_id" uniqueidentifier NOT NULL, "rptg_seq_typ_id" uniqueidentifier NOT NULL, "rptg_seq_start_dt" date, "rptg_seq_semimo_2nd_start_dt" date, Constraint "rptg_seq_pkey" Primary Key ("rptg_seq_id") ); -- -- TOC Entry ID 17 (OID 1621689) -- -- Name: rptg_seq_typ Type: TABLE Owner: postgres -- CREATE TABLE "rptg_seq_typ" ( "rptg_seq_typ_id" uniqueidentifier NOT NULL, "rptg_seq_typ_nm" character varying(15) NOT NULL, "rptg_seq_typ_desc" character varying(150), "is_pay_prd_seq_ind" boolean NOT NULL, Constraint "rptg_seq_typ_pkey" Primary Key ("rptg_seq_typ_id") ); -- -- TOC Entry ID 18 (OID 1621705) -- -- Name: stepped_cvg_rptd Type: TABLE Owner: postgres -- CREATE TABLE "stepped_cvg_rptd" ( "cvgstep_id" uniqueidentifier NOT NULL, "emp_grp_id" uniqueidentifier NOT NULL, "grp_rate_id" uniqueidentifier NOT NULL, "rate_step_id" uniqueidentifier NOT NULL, "rptg_seq_id" uniqueidentifier NOT NULL, "ben_plan_id" uniqueidentifier NOT NULL, "rptg_prd_end_dt" date NOT NULL, "step_cvg_rptd_emp_count" integer NOT NULL, "step_cvg_rptd_cvg_amt" integer, Constraint "stepped_cvg_rptd_pkey" Primary Key ("emp_grp_id", "ben_plan_id", "grp_rate_id", "rate_step_id", "rptg_seq_id", "rptg_prd_end_dt", "cvgstep_id") ); -- -- TOC Entry ID 5 (OID 1621726) -- -- Name: rptg_session_rptg_session_c_seq Type: SEQUENCE Owner: postgres -- CREATE SEQUENCE "rptg_session_rptg_session_c_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ; -- -- TOC Entry ID 19 (OID 1621745) -- -- Name: rptg_session Type: TABLE Owner: postgres -- CREATE TABLE "rptg_session" ( "rptg_session_id" uniqueidentifier NOT NULL, "rptg_session_confirm_no" integer DEFAULT nextval('"rptg_session_rptg_session_c_seq"'::text) NOT NULL, "rptg_mdfy_dt" timestamp with time zone NOT NULL, Constraint "rptg_session_pkey" Primary Key ("rptg_session_id") ); -- -- Data for TOC Entry ID 42 (OID 1621509) -- -- Name: ben_plan Type: TABLE DATA Owner: postgres -- INSERT INTO "ben_plan" VALUES ('51E79587-D136-D411-B5F4-0050DA5FD075',1,3); INSERT INTO "ben_plan" VALUES ('60E89587-D136-D411-B5F4-0050DA5FD075',3,10); INSERT INTO "ben_plan" VALUES ('72E99587-D136-D411-B5F4-0050DA5FD075',4,12); INSERT INTO "ben_plan" VALUES ('A0E79587-D136-D411-B5F4-0050DA5FD075',5,6); -- -- Data for TOC Entry ID 43 (OID 1621524) -- -- Name: coverage_step Type: TABLE DATA Owner: postgres -- INSERT INTO "coverage_step" VALUES ('51E79587-D136-D411-B5F4-0050DA5FD075','73B7259C-3A46-D511-8A0A-00508B0E83B6','Ages: All; ',50000,'2000-05-31 16:22:18+00'); INSERT INTO "coverage_step" VALUES ('60E89587-D136-D411-B5F4-0050DA5FD075','75B7259C-3A46-D511-8A0A-00508B0E83B6','Ages: All: 2 X Basic Annual Earnings; Min. $65000; Max. n/a',NULL,'2000-05-31 17:00:56+00'); INSERT INTO "coverage_step" VALUES ('72E99587-D136-D411-B5F4-0050DA5FD075','77B7259C-3A46-D511-8A0A-00508B0E83B6','Ages: Up to 64, inclusive; ',10000,'2000-05-31 20:53:01+00'); INSERT INTO "coverage_step" VALUES ('72E99587-D136-D411-B5F4-0050DA5FD075','78B7259C-3A46-D511-8A0A-00508B0E83B6','Ages: 65 to 69, inclusive; ',5000,'2000-05-31 20:53:01+00'); INSERT INTO "coverage_step" VALUES ('A0E79587-D136-D411-B5F4-0050DA5FD075','74B7259C-3A46-D511-8A0A-00508B0E83B6','Ages: All; ',50000,'2000-05-31 16:28:43+00'); -- -- Data for TOC Entry ID 44 (OID 1621541) -- -- Name: cvg_rptd Type: TABLE DATA Owner: postgres -- INSERT INTO "cvg_rptd" VALUES ('DB1F2BCA-9272-D411-B712-0008C78CB1FE','51E79587-D136-D411-B5F4-0050DA5FD075','F7E6C60D-1979-11D5-AE7D-001083FD6A84','CF2A3EC7-E0E3-11D3-A9BB-0060B06823C3','2001-04-30','3743CB52-2D46-11D5-8A09-00508B0E83B6',NULL,0,0,NULL,'2001-05-23 14:15:45+00'); INSERT INTO "cvg_rptd" VALUES ('DB1F2BCA-9272-D411-B712-0008C78CB1FE','51E79587-D136-D411-B5F4-0050DA5FD075','F7E6C60D-1979-11D5-AE7D-001083FD6A84','CF2A3EC7-E0E3-11D3-A9BB-0060B06823C3','2000-12-15','53014F33-197B-11D5-AE7D-001083FD6A84','3743CC60-2D46-11D5-8A09-00508B0E83B6',1,0,'no exception','2001-05-02 07:01:00+00'); INSERT INTO "cvg_rptd" VALUES ('DB1F2BCA-9272-D411-B712-0008C78CB1FE','51E79587-D136-D411-B5F4-0050DA5FD075','F7E6C60D-1979-11D5-AE7D-001083FD6A84','CF2A3EC7-E0E3-11D3-A9BB-0060B06823C3','2001-01-31','3743CB52-2D46-11D5-8A09-00508B0E83B6','407C3A98-4A22-11D5-895B-00C04FA05897',1,0,NULL,'2001-05-16 17:38:26+00'); INSERT INTO "cvg_rptd" VALUES ('DB1F2BCA-9272-D411-B712-0008C78CB1FE','A0E79587-D136-D411-B5F4-0050DA5FD075','F7E6C60E-1979-11D5-AE7D-001083FD6A84','CF2A3EC7-E0E3-11D3-A9BB-0060B06823C3','2001-01-31','3743CB52-2D46-11D5-8A09-00508B0E83B6','407C3A98-4A22-11D5-895B-00C04FA05897',1,0,NULL,'2001-05-16 17:38:26+00'); INSERT INTO "cvg_rptd" VALUES ('DB1F2BCA-9272-D411-B712-0008C78CB1FE','A0E79587-D136-D411-B5F4-0050DA5FD075','F7E6C60E-1979-11D5-AE7D-001083FD6A84','CF2A3EC7-E0E3-11D3-A9BB-0060B06823C3','2001-04-30','3743CB52-2D46-11D5-8A09-00508B0E83B6',NULL,0,0,NULL,'2001-05-23 13:52:31+00'); INSERT INTO "cvg_rptd" VALUES ('DB1F2BCA-9272-D411-B712-0008C78CB1FE','A0E79587-D136-D411-B5F4-0050DA5FD075','F7E6C60E-1979-11D5-AE7D-001083FD6A84','CF2A3EC7-E0E3-11D3-A9BB-0060B06823C3','2000-12-15','53014F33-197B-11D5-AE7D-001083FD6A84','3743CC60-2D46-11D5-8A09-00508B0E83B6',1,0,'no exception','2001-05-02 07:01:00+00'); -- -- Data for TOC Entry ID 45 (OID 1621564) -- -- Name: emp_grp Type: TABLE DATA Owner: postgres -- INSERT INTO "emp_grp" VALUES ('D51F2BCA-9272-D411-B712-0008C78CB1FE',1133,'1133 Union 1 at Organization A (Agrmt A 4/2000)',1,'2000-08-15 23:53:45+00'); INSERT INTO "emp_grp" VALUES ('DB1F2BCA-9272-D411-B712-0008C78CB1FE',1134,'1134 Union 2 at Organization A (Agrmt A 4/2000)',1,'2000-08-15 23:54:36+00'); INSERT INTO "emp_grp" VALUES ('E71F2BCA-9272-D411-B712-0008C78CB1FE',1135,'1135 Union 1 at Organization B (Agrmt A 4/2000)',1,'2000-08-15 23:55:44+00'); -- -- Data for TOC Entry ID 46 (OID 1621581) -- -- Name: grp_rate Type: TABLE DATA Owner: postgres -- INSERT INTO "grp_rate" VALUES ('D51F2BCA-9272-D411-B712-0008C78CB1FE','51E79587-D136-D411-B5F4-0050DA5FD075','F7E6C608-1979-11D5-AE7D-001083FD6A84','2000-04-01',NULL); INSERT INTO "grp_rate" VALUES ('DB1F2BCA-9272-D411-B712-0008C78CB1FE','51E79587-D136-D411-B5F4-0050DA5FD075','F7E6C60D-1979-11D5-AE7D-001083FD6A84','2000-04-01',NULL); INSERT INTO "grp_rate" VALUES ('E71F2BCA-9272-D411-B712-0008C78CB1FE','51E79587-D136-D411-B5F4-0050DA5FD075','F7E6C612-1979-11D5-AE7D-001083FD6A84','2000-04-01',NULL); INSERT INTO "grp_rate" VALUES ('DB1F2BCA-9272-D411-B712-0008C78CB1FE','A0E79587-D136-D411-B5F4-0050DA5FD075','F7E6C60E-1979-11D5-AE7D-001083FD6A84','2000-04-01',NULL); -- -- Data for TOC Entry ID 47 (OID 1621598) -- -- Name: grp_rate_step Type: TABLE DATA Owner: postgres -- INSERT INTO "grp_rate_step" VALUES ('D51F2BCA-9272-D411-B712-0008C78CB1FE','51E79587-D136-D411-B5F4-0050DA5FD075','F7E6C608-1979-11D5-AE7D-001083FD6A84','CF2A3EC7-E0E3-11D3-A9BB-0060B06823C3',NULL,NULL,NULL,'0.1025','2000-08-23 21:19:32+00'); INSERT INTO "grp_rate_step" VALUES ('DB1F2BCA-9272-D411-B712-0008C78CB1FE','51E79587-D136-D411-B5F4-0050DA5FD075','F7E6C60D-1979-11D5-AE7D-001083FD6A84','CF2A3EC7-E0E3-11D3-A9BB-0060B06823C3',NULL,NULL,NULL,'0.1355','2000-08-23 21:20:16+00'); INSERT INTO "grp_rate_step" VALUES ('E71F2BCA-9272-D411-B712-0008C78CB1FE','51E79587-D136-D411-B5F4-0050DA5FD075','F7E6C612-1979-11D5-AE7D-001083FD6A84','CF2A3EC7-E0E3-11D3-A9BB-0060B06823C3',NULL,NULL,NULL,'0.1875','2000-08-23 21:19:55+00'); INSERT INTO "grp_rate_step" VALUES ('DB1F2BCA-9272-D411-B712-0008C78CB1FE','A0E79587-D136-D411-B5F4-0050DA5FD075','F7E6C60E-1979-11D5-AE7D-001083FD6A84','CF2A3EC7-E0E3-11D3-A9BB-0060B06823C3',NULL,NULL,NULL,'0.0321','2001-02-28 22:31:00+00'); -- -- Data for TOC Entry ID 48 (OID 1621619) -- -- Name: mo_cvg_rptd Type: TABLE DATA Owner: postgres -- -- -- Data for TOC Entry ID 49 (OID 1621638) -- -- Name: pay_prd_cvg_rptd Type: TABLE DATA Owner: postgres -- -- -- Data for TOC Entry ID 50 (OID 1621658) -- -- Name: rate_step Type: TABLE DATA Owner: postgres -- INSERT INTO "rate_step" VALUES ('CF2A393A-E0E3-11D3-A9BB-0060B06823C3','Single',NULL); INSERT INTO "rate_step" VALUES ('CF2A393B-E0E3-11D3-A9BB-0060B06823C3','One dependant',NULL); INSERT INTO "rate_step" VALUES ('CF2A393C-E0E3-11D3-A9BB-0060B06823C3','More than one dependant',NULL); INSERT INTO "rate_step" VALUES ('CF2A3EC7-E0E3-11D3-A9BB-0060B06823C3','Not Applicable',NULL); -- -- Data for TOC Entry ID 51 (OID 1621673) -- -- Name: rptg_seq Type: TABLE DATA Owner: postgres -- INSERT INTO "rptg_seq" VALUES ('53014F2B-197B-11D5-AE7D-001083FD6A84','53014F20-197B-11D5-AE7D-001083FD6A84','2000-01-01',NULL); INSERT INTO "rptg_seq" VALUES ('53014F2C-197B-11D5-AE7D-001083FD6A84','53014F20-197B-11D5-AE7D-001083FD6A84','2000-01-02',NULL); INSERT INTO "rptg_seq" VALUES ('53014F2D-197B-11D5-AE7D-001083FD6A84','53014F20-197B-11D5-AE7D-001083FD6A84','2000-01-03',NULL); INSERT INTO "rptg_seq" VALUES ('53014F2E-197B-11D5-AE7D-001083FD6A84','53014F20-197B-11D5-AE7D-001083FD6A84','2000-01-04',NULL); INSERT INTO "rptg_seq" VALUES ('53014F2F-197B-11D5-AE7D-001083FD6A84','53014F20-197B-11D5-AE7D-001083FD6A84','2000-01-05',NULL); INSERT INTO "rptg_seq" VALUES ('53014F22-197B-11D5-AE7D-001083FD6A84','53014F20-197B-11D5-AE7D-001083FD6A84','2000-01-06',NULL); INSERT INTO "rptg_seq" VALUES ('53014F23-197B-11D5-AE7D-001083FD6A84','53014F20-197B-11D5-AE7D-001083FD6A84','2000-01-07',NULL); INSERT INTO "rptg_seq" VALUES ('53014F24-197B-11D5-AE7D-001083FD6A84','53014F20-197B-11D5-AE7D-001083FD6A84','2000-01-08',NULL); INSERT INTO "rptg_seq" VALUES ('53014F25-197B-11D5-AE7D-001083FD6A84','53014F20-197B-11D5-AE7D-001083FD6A84','2000-01-09',NULL); INSERT INTO "rptg_seq" VALUES ('53014F26-197B-11D5-AE7D-001083FD6A84','53014F20-197B-11D5-AE7D-001083FD6A84','2000-01-10',NULL); INSERT INTO "rptg_seq" VALUES ('53014F27-197B-11D5-AE7D-001083FD6A84','53014F20-197B-11D5-AE7D-001083FD6A84','2000-01-11',NULL); INSERT INTO "rptg_seq" VALUES ('53014F28-197B-11D5-AE7D-001083FD6A84','53014F20-197B-11D5-AE7D-001083FD6A84','2000-01-12',NULL); INSERT INTO "rptg_seq" VALUES ('53014F29-197B-11D5-AE7D-001083FD6A84','53014F20-197B-11D5-AE7D-001083FD6A84','2000-01-13',NULL); INSERT INTO "rptg_seq" VALUES ('53014F2A-197B-11D5-AE7D-001083FD6A84','53014F20-197B-11D5-AE7D-001083FD6A84','2000-01-14',NULL); INSERT INTO "rptg_seq" VALUES ('53014F30-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-01','2000-01-13'); INSERT INTO "rptg_seq" VALUES ('53014F31-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-01','2000-01-14'); INSERT INTO "rptg_seq" VALUES ('53014F32-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-01','2000-01-15'); INSERT INTO "rptg_seq" VALUES ('53014F33-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-01','2000-01-16'); INSERT INTO "rptg_seq" VALUES ('53014F34-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-01','2000-01-17'); INSERT INTO "rptg_seq" VALUES ('53014F35-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-02','2000-01-14'); INSERT INTO "rptg_seq" VALUES ('53014F36-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-02','2000-01-15'); INSERT INTO "rptg_seq" VALUES ('53014F37-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-02','2000-01-16'); INSERT INTO "rptg_seq" VALUES ('53014F38-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-02','2000-01-17'); INSERT INTO "rptg_seq" VALUES ('53014F39-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-02','2000-01-18'); INSERT INTO "rptg_seq" VALUES ('53014F3A-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-03','2000-01-15'); INSERT INTO "rptg_seq" VALUES ('53014F3B-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-03','2000-01-16'); INSERT INTO "rptg_seq" VALUES ('53014F3C-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-03','2000-01-17'); INSERT INTO "rptg_seq" VALUES ('53014F3D-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-03','2000-01-18'); INSERT INTO "rptg_seq" VALUES ('53014F3E-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-03','2000-01-19'); INSERT INTO "rptg_seq" VALUES ('53014F3F-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-04','2000-01-16'); INSERT INTO "rptg_seq" VALUES ('53014F40-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-04','2000-01-17'); INSERT INTO "rptg_seq" VALUES ('53014F41-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-04','2000-01-18'); INSERT INTO "rptg_seq" VALUES ('53014F42-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-04','2000-01-19'); INSERT INTO "rptg_seq" VALUES ('53014F43-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-04','2000-01-20'); INSERT INTO "rptg_seq" VALUES ('53014F44-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-05','2000-01-17'); INSERT INTO "rptg_seq" VALUES ('53014F45-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-05','2000-01-18'); INSERT INTO "rptg_seq" VALUES ('53014F46-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-05','2000-01-19'); INSERT INTO "rptg_seq" VALUES ('53014F47-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-05','2000-01-20'); INSERT INTO "rptg_seq" VALUES ('53014F48-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-05','2000-01-21'); INSERT INTO "rptg_seq" VALUES ('53014F49-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-06','2000-01-18'); INSERT INTO "rptg_seq" VALUES ('53014F4A-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-06','2000-01-19'); INSERT INTO "rptg_seq" VALUES ('53014F4B-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-06','2000-01-20'); INSERT INTO "rptg_seq" VALUES ('53014F4C-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-06','2000-01-21'); INSERT INTO "rptg_seq" VALUES ('53014F4D-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-06','2000-01-22'); INSERT INTO "rptg_seq" VALUES ('53014F4E-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-07','2000-01-19'); INSERT INTO "rptg_seq" VALUES ('53014F4F-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-07','2000-01-20'); INSERT INTO "rptg_seq" VALUES ('53014F50-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-07','2000-01-21'); INSERT INTO "rptg_seq" VALUES ('53014F51-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-07','2000-01-22'); INSERT INTO "rptg_seq" VALUES ('53014F52-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-07','2000-01-23'); INSERT INTO "rptg_seq" VALUES ('53014F53-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-08','2000-01-20'); INSERT INTO "rptg_seq" VALUES ('53014F54-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-08','2000-01-21'); INSERT INTO "rptg_seq" VALUES ('53014F55-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-08','2000-01-22'); INSERT INTO "rptg_seq" VALUES ('53014F56-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-08','2000-01-23'); INSERT INTO "rptg_seq" VALUES ('53014F57-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-08','2000-01-24'); INSERT INTO "rptg_seq" VALUES ('53014F58-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-09','2000-01-21'); INSERT INTO "rptg_seq" VALUES ('53014F59-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-09','2000-01-22'); INSERT INTO "rptg_seq" VALUES ('53014F5A-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-09','2000-01-23'); INSERT INTO "rptg_seq" VALUES ('53014F5B-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-09','2000-01-24'); INSERT INTO "rptg_seq" VALUES ('53014F5C-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-09','2000-01-25'); INSERT INTO "rptg_seq" VALUES ('53014F5D-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-10','2000-01-22'); INSERT INTO "rptg_seq" VALUES ('53014F5E-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-10','2000-01-23'); INSERT INTO "rptg_seq" VALUES ('53014F5F-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-10','2000-01-24'); INSERT INTO "rptg_seq" VALUES ('53014F60-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-10','2000-01-25'); INSERT INTO "rptg_seq" VALUES ('53014F61-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-10','2000-01-26'); INSERT INTO "rptg_seq" VALUES ('53014F62-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-11','2000-01-23'); INSERT INTO "rptg_seq" VALUES ('53014F63-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-11','2000-01-24'); INSERT INTO "rptg_seq" VALUES ('53014F64-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-11','2000-01-25'); INSERT INTO "rptg_seq" VALUES ('53014F65-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-11','2000-01-26'); INSERT INTO "rptg_seq" VALUES ('53014F66-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-11','2000-01-27'); INSERT INTO "rptg_seq" VALUES ('53014F67-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-12','2000-01-24'); INSERT INTO "rptg_seq" VALUES ('53014F68-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-12','2000-01-25'); INSERT INTO "rptg_seq" VALUES ('53014F69-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-12','2000-01-26'); INSERT INTO "rptg_seq" VALUES ('53014F6A-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-12','2000-01-27'); INSERT INTO "rptg_seq" VALUES ('53014F6B-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-12','2000-01-28'); INSERT INTO "rptg_seq" VALUES ('53014F6C-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-13','2000-01-25'); INSERT INTO "rptg_seq" VALUES ('53014F6D-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-13','2000-01-26'); INSERT INTO "rptg_seq" VALUES ('53014F6E-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-13','2000-01-27'); INSERT INTO "rptg_seq" VALUES ('53014F6F-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-13','2000-01-28'); INSERT INTO "rptg_seq" VALUES ('53014F70-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-14','2000-01-26'); INSERT INTO "rptg_seq" VALUES ('53014F71-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-14','2000-01-27'); INSERT INTO "rptg_seq" VALUES ('53014F72-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-14','2000-01-28'); INSERT INTO "rptg_seq" VALUES ('53014F73-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-15','2000-01-27'); INSERT INTO "rptg_seq" VALUES ('53014F74-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-15','2000-01-28'); INSERT INTO "rptg_seq" VALUES ('53014F75-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-16','2000-01-28'); INSERT INTO "rptg_seq" VALUES ('3743CB52-2D46-11D5-8A09-00508B0E83B6','3743CB51-2D46-11D5-8A09-00508B0E83B6','2000-01-01',NULL); -- -- Data for TOC Entry ID 52 (OID 1621689) -- -- Name: rptg_seq_typ Type: TABLE DATA Owner: postgres -- INSERT INTO "rptg_seq_typ" VALUES ('53014F21-197B-11D5-AE7D-001083FD6A84','Semi-monthly','pay semi-monthly','t'); INSERT INTO "rptg_seq_typ" VALUES ('53014F20-197B-11D5-AE7D-001083FD6A84','Bi-weekly','pay bi-weekly','t'); INSERT INTO "rptg_seq_typ" VALUES ('3743CB51-2D46-11D5-8A09-00508B0E83B6','Monthly','Coverage Month','f'); -- -- Data for TOC Entry ID 53 (OID 1621705) -- -- Name: stepped_cvg_rptd Type: TABLE DATA Owner: postgres -- INSERT INTO "stepped_cvg_rptd" VALUES ('73B7259C-3A46-D511-8A0A-00508B0E83B6','DB1F2BCA-9272-D411-B712-0008C78CB1FE','F7E6C60D-1979-11D5-AE7D-001083FD6A84','CF2A3EC7-E0E3-11D3-A9BB-0060B06823C3','53014F33-197B-11D5-AE7D-001083FD6A84','51E79587-D136-D411-B5F4-0050DA5FD075','2000-12-15',10,NULL); INSERT INTO "stepped_cvg_rptd" VALUES ('73B7259C-3A46-D511-8A0A-00508B0E83B6','DB1F2BCA-9272-D411-B712-0008C78CB1FE','F7E6C60D-1979-11D5-AE7D-001083FD6A84','CF2A3EC7-E0E3-11D3-A9BB-0060B06823C3','3743CB52-2D46-11D5-8A09-00508B0E83B6','51E79587-D136-D411-B5F4-0050DA5FD075','2001-01-31',10,NULL); INSERT INTO "stepped_cvg_rptd" VALUES ('73B7259C-3A46-D511-8A0A-00508B0E83B6','DB1F2BCA-9272-D411-B712-0008C78CB1FE','F7E6C60D-1979-11D5-AE7D-001083FD6A84','CF2A3EC7-E0E3-11D3-A9BB-0060B06823C3','3743CB52-2D46-11D5-8A09-00508B0E83B6','51E79587-D136-D411-B5F4-0050DA5FD075','2001-04-30',44,NULL); -- -- Data for TOC Entry ID 54 (OID 1621745) -- -- Name: rptg_session Type: TABLE DATA Owner: postgres -- INSERT INTO "rptg_session" VALUES ('3743CC60-2D46-11D5-8A09-00508B0E83B6',1,'2001-05-01 07:01:00+00'); INSERT INTO "rptg_session" VALUES ('407C3A98-4A22-11D5-895B-00C04FA05897',2,'2001-05-16 17:38:26+00'); -- -- TOC Entry ID 20 (OID 1621509) -- -- Name: "idx_ben_plan_ak1" Type: INDEX Owner: postgres -- CREATE UNIQUE INDEX "idx_ben_plan_ak1" on "ben_plan" using btree ( "ben_plan_halid" "int4_ops" ); -- -- TOC Entry ID 21 (OID 1621564) -- -- Name: "idx_emp_grp_ak1" Type: INDEX Owner: postgres -- CREATE UNIQUE INDEX "idx_emp_grp_ak1" on "emp_grp" using btree ( "emp_grp_halid" "int4_ops" ); -- -- TOC Entry ID 22 (OID 1621564) -- -- Name: "idx_emp_grp_ak2" Type: INDEX Owner: postgres -- CREATE UNIQUE INDEX "idx_emp_grp_ak2" on "emp_grp" using btree ( "emp_grp_nm" "varchar_ops", "emp_grp_typ" "int2_ops" ); -- -- TOC Entry ID 23 (OID 1621581) -- -- Name: "idx_grp_rate_ak1" Type: INDEX Owner: postgres -- CREATE UNIQUE INDEX "idx_grp_rate_ak1" on "grp_rate" using btree ( "emp_grp_id" "uniqueidentifier_ops", "ben_plan_id" "uniqueidentifier_ops", "grp_rate_eff_dt" "date_ops" ); -- -- TOC Entry ID 24 (OID 1621658) -- -- Name: "idx_rate_step_ak1" Type: INDEX Owner: postgres -- CREATE UNIQUE INDEX "idx_rate_step_ak1" on "rate_step" using btree ( "rate_step_nm" "varchar_ops" ); -- -- TOC Entry ID 25 (OID 1621689) -- -- Name: "idx_rptg_seq_typ_ak1" Type: INDEX Owner: postgres -- CREATE UNIQUE INDEX "idx_rptg_seq_typ_ak1" on "rptg_seq_typ" using btree ( "rptg_seq_typ_nm" "varchar_ops" ); -- -- TOC Entry ID 26 (OID 1621745) -- -- Name: "rptg_session_rptg_session_c_key" Type: INDEX Owner: postgres -- CREATE UNIQUE INDEX "rptg_session_rptg_session_c_key" on "rptg_session" using btree ( "rptg_session_confirm_no" "int4_ops" ); -- -- TOC Entry ID 85 (OID 1621919) -- -- Name: "RI_ConstraintTrigger_1621918" Type: TRIGGER Owner: postgres -- CREATE CONSTRAINT TRIGGER "fk_rptgseq_rptgseqtyp" AFTER INSERT OR UPDATE ON "rptg_seq" FROM "rptg_seq_typ" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('fk_rptgseq_rptgseqtyp', 'rptg_seq', 'rptg_seq_typ', 'UNSPECIFIED', 'rptg_seq_typ_id', 'rptg_seq_typ_id'); -- -- TOC Entry ID 88 (OID 1621921) -- -- Name: "RI_ConstraintTrigger_1621920" Type: TRIGGER Owner: postgres -- CREATE CONSTRAINT TRIGGER "fk_rptgseq_rptgseqtyp" AFTER DELETE ON "rptg_seq_typ" FROM "rptg_seq" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('fk_rptgseq_rptgseqtyp', 'rptg_seq', 'rptg_seq_typ', 'UNSPECIFIED', 'rptg_seq_typ_id', 'rptg_seq_typ_id'); -- -- TOC Entry ID 89 (OID 1621923) -- -- Name: "RI_ConstraintTrigger_1621922" Type: TRIGGER Owner: postgres -- CREATE CONSTRAINT TRIGGER "fk_rptgseq_rptgseqtyp" AFTER UPDATE ON "rptg_seq_typ" FROM "rptg_seq" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('fk_rptgseq_rptgseqtyp', 'rptg_seq', 'rptg_seq_typ', 'UNSPECIFIED', 'rptg_seq_typ_id', 'rptg_seq_typ_id'); -- -- TOC Entry ID 62 (OID 1621925) -- -- Name: "RI_ConstraintTrigger_1621924" Type: TRIGGER Owner: postgres -- CREATE CONSTRAINT TRIGGER "fk_cvgrptd_rptgseq" AFTER INSERT OR UPDATE ON "cvg_rptd" FROM "rptg_seq" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('fk_cvgrptd_rptgseq', 'cvg_rptd', 'rptg_seq', 'UNSPECIFIED', 'rptg_seq_id', 'rptg_seq_id'); -- -- TOC Entry ID 86 (OID 1621927) -- -- Name: "RI_ConstraintTrigger_1621926" Type: TRIGGER Owner: postgres -- CREATE CONSTRAINT TRIGGER "fk_cvgrptd_rptgseq" AFTER DELETE ON "rptg_seq" FROM "cvg_rptd" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('fk_cvgrptd_rptgseq', 'cvg_rptd', 'rptg_seq', 'UNSPECIFIED', 'rptg_seq_id', 'rptg_seq_id'); -- -- TOC Entry ID 87 (OID 1621929) -- -- Name: "RI_ConstraintTrigger_1621928" Type: TRIGGER Owner: postgres -- CREATE CONSTRAINT TRIGGER "fk_cvgrptd_rptgseq" AFTER UPDATE ON "rptg_seq" FROM "cvg_rptd" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('fk_cvgrptd_rptgseq', 'cvg_rptd', 'rptg_seq', 'UNSPECIFIED', 'rptg_seq_id', 'rptg_seq_id'); -- -- TOC Entry ID 63 (OID 1621931) -- -- Name: "RI_ConstraintTrigger_1621930" Type: TRIGGER Owner: postgres -- CREATE CONSTRAINT TRIGGER "fk_cvgrptd_grpratestep" AFTER INSERT OR UPDATE ON "cvg_rptd" FROM "grp_rate_step" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('fk_cvgrptd_grpratestep', 'cvg_rptd', 'grp_rate_step', 'UNSPECIFIED', 'emp_grp_id', 'emp_grp_id', 'ben_plan_id', 'ben_plan_id', 'grp_rate_id', 'grp_rate_id', 'rate_step_id', 'rate_step_id'); -- -- TOC Entry ID 77 (OID 1621933) -- -- Name: "RI_ConstraintTrigger_1621932" Type: TRIGGER Owner: postgres -- CREATE CONSTRAINT TRIGGER "fk_cvgrptd_grpratestep" AFTER DELETE ON "grp_rate_step" FROM "cvg_rptd" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('fk_cvgrptd_grpratestep', 'cvg_rptd', 'grp_rate_step', 'UNSPECIFIED', 'emp_grp_id', 'emp_grp_id', 'ben_plan_id', 'ben_plan_id', 'grp_rate_id', 'grp_rate_id', 'rate_step_id', 'rate_step_id'); -- -- TOC Entry ID 78 (OID 1621935) -- -- Name: "RI_ConstraintTrigger_1621934" Type: TRIGGER Owner: postgres -- CREATE CONSTRAINT TRIGGER "fk_cvgrptd_grpratestep" AFTER UPDATE ON "grp_rate_step" FROM "cvg_rptd" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('fk_cvgrptd_grpratestep', 'cvg_rptd', 'grp_rate_step', 'UNSPECIFIED', 'emp_grp_id', 'emp_grp_id', 'ben_plan_id', 'ben_plan_id', 'grp_rate_id', 'grp_rate_id', 'rate_step_id', 'rate_step_id'); -- -- TOC Entry ID 73 (OID 1621937) -- -- Name: "RI_ConstraintTrigger_1621936" Type: TRIGGER Owner: postgres -- CREATE CONSTRAINT TRIGGER "fk_benplan_grprate" AFTER INSERT OR UPDATE ON "grp_rate" FROM "ben_plan" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('fk_benplan_grprate', 'grp_rate', 'ben_plan', 'UNSPECIFIED', 'ben_plan_id', 'ben_plan_id'); -- -- TOC Entry ID 55 (OID 1621939) -- -- Name: "RI_ConstraintTrigger_1621938" Type: TRIGGER Owner: postgres -- CREATE CONSTRAINT TRIGGER "fk_benplan_grprate" AFTER DELETE ON "ben_plan" FROM "grp_rate" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('fk_benplan_grprate', 'grp_rate', 'ben_plan', 'UNSPECIFIED', 'ben_plan_id', 'ben_plan_id'); -- -- TOC Entry ID 56 (OID 1621941) -- -- Name: "RI_ConstraintTrigger_1621940" Type: TRIGGER Owner: postgres -- CREATE CONSTRAINT TRIGGER "fk_benplan_grprate" AFTER UPDATE ON "ben_plan" FROM "grp_rate" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('fk_benplan_grprate', 'grp_rate', 'ben_plan', 'UNSPECIFIED', 'ben_plan_id', 'ben_plan_id'); -- -- TOC Entry ID 74 (OID 1621943) -- -- Name: "RI_ConstraintTrigger_1621942" Type: TRIGGER Owner: postgres -- CREATE CONSTRAINT TRIGGER "fk_empgrp_grprate" AFTER INSERT OR UPDATE ON "grp_rate" FROM "emp_grp" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('fk_empgrp_grprate', 'grp_rate', 'emp_grp', 'UNSPECIFIED', 'emp_grp_id', 'emp_grp_id'); -- -- TOC Entry ID 71 (OID 1621945) -- -- Name: "RI_ConstraintTrigger_1621944" Type: TRIGGER Owner: postgres -- CREATE CONSTRAINT TRIGGER "fk_empgrp_grprate" AFTER DELETE ON "emp_grp" FROM "grp_rate" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('fk_empgrp_grprate', 'grp_rate', 'emp_grp', 'UNSPECIFIED', 'emp_grp_id', 'emp_grp_id'); -- -- TOC Entry ID 72 (OID 1621947) -- -- Name: "RI_ConstraintTrigger_1621946" Type: TRIGGER Owner: postgres -- CREATE CONSTRAINT TRIGGER "fk_empgrp_grprate" AFTER UPDATE ON "emp_grp" FROM "grp_rate" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('fk_empgrp_grprate', 'grp_rate', 'emp_grp', 'UNSPECIFIED', 'emp_grp_id', 'emp_grp_id'); -- -- TOC Entry ID 81 (OID 1621949) -- -- Name: "RI_ConstraintTrigger_1621948" Type: TRIGGER Owner: postgres -- CREATE CONSTRAINT TRIGGER "fk_cvgrptd_mocvgrptd" AFTER INSERT OR UPDATE ON "mo_cvg_rptd" FROM "cvg_rptd" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('fk_cvgrptd_mocvgrptd', 'mo_cvg_rptd', 'cvg_rptd', 'UNSPECIFIED', 'emp_grp_id', 'emp_grp_id', 'ben_plan_id', 'ben_plan_id', 'grp_rate_id', 'grp_rate_id', 'rate_step_id', 'rate_step_id', 'rptg_seq_id', 'rptg_seq_id', 'rptg_prd_end_dt', 'rptg_prd_end_dt'); -- -- TOC Entry ID 64 (OID 1621951) -- -- Name: "RI_ConstraintTrigger_1621950" Type: TRIGGER Owner: postgres -- CREATE CONSTRAINT TRIGGER "fk_cvgrptd_mocvgrptd" AFTER DELETE ON "cvg_rptd" FROM "mo_cvg_rptd" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('fk_cvgrptd_mocvgrptd', 'mo_cvg_rptd', 'cvg_rptd', 'UNSPECIFIED', 'emp_grp_id', 'emp_grp_id', 'ben_plan_id', 'ben_plan_id', 'grp_rate_id', 'grp_rate_id', 'rate_step_id', 'rate_step_id', 'rptg_seq_id', 'rptg_seq_id', 'rptg_prd_end_dt', 'rptg_prd_end_dt'); -- -- TOC Entry ID 65 (OID 1621953) -- -- Name: "RI_ConstraintTrigger_1621952" Type: TRIGGER Owner: postgres -- CREATE CONSTRAINT TRIGGER "fk_cvgrptd_mocvgrptd" AFTER UPDATE ON "cvg_rptd" FROM "mo_cvg_rptd" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('fk_cvgrptd_mocvgrptd', 'mo_cvg_rptd', 'cvg_rptd', 'UNSPECIFIED', 'emp_grp_id', 'emp_grp_id', 'ben_plan_id', 'ben_plan_id', 'grp_rate_id', 'grp_rate_id', 'rate_step_id', 'rate_step_id', 'rptg_seq_id', 'rptg_seq_id', 'rptg_prd_end_dt', 'rptg_prd_end_dt'); -- -- TOC Entry ID 79 (OID 1621955) -- -- Name: "RI_ConstraintTrigger_1621954" Type: TRIGGER Owner: postgres -- CREATE CONSTRAINT TRIGGER "fk_ratestep_grpratestep" AFTER INSERT OR UPDATE ON "grp_rate_step" FROM "rate_step" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('fk_ratestep_grpratestep', 'grp_rate_step', 'rate_step', 'UNSPECIFIED', 'rate_step_id', 'rate_step_id'); -- -- TOC Entry ID 83 (OID 1621957) -- -- Name: "RI_ConstraintTrigger_1621956" Type: TRIGGER Owner: postgres -- CREATE CONSTRAINT TRIGGER "fk_ratestep_grpratestep" AFTER DELETE ON "rate_step" FROM "grp_rate_step" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('fk_ratestep_grpratestep', 'grp_rate_step', 'rate_step', 'UNSPECIFIED', 'rate_step_id', 'rate_step_id'); -- -- TOC Entry ID 84 (OID 1621959) -- -- Name: "RI_ConstraintTrigger_1621958" Type: TRIGGER Owner: postgres -- CREATE CONSTRAINT TRIGGER "fk_ratestep_grpratestep" AFTER UPDATE ON "rate_step" FROM "grp_rate_step" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('fk_ratestep_grpratestep', 'grp_rate_step', 'rate_step', 'UNSPECIFIED', 'rate_step_id', 'rate_step_id'); -- -- TOC Entry ID 80 (OID 1621961) -- -- Name: "RI_ConstraintTrigger_1621960" Type: TRIGGER Owner: postgres -- CREATE CONSTRAINT TRIGGER "fk_grprate_grpratestep" AFTER INSERT OR UPDATE ON "grp_rate_step" FROM "grp_rate" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('fk_grprate_grpratestep', 'grp_rate_step', 'grp_rate', 'UNSPECIFIED', 'emp_grp_id', 'emp_grp_id', 'ben_plan_id', 'ben_plan_id', 'grp_rate_id', 'grp_rate_id'); -- -- TOC Entry ID 75 (OID 1621963) -- -- Name: "RI_ConstraintTrigger_1621962" Type: TRIGGER Owner: postgres -- CREATE CONSTRAINT TRIGGER "fk_grprate_grpratestep" AFTER DELETE ON "grp_rate" FROM "grp_rate_step" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('fk_grprate_grpratestep', 'grp_rate_step', 'grp_rate', 'UNSPECIFIED', 'emp_grp_id', 'emp_grp_id', 'ben_plan_id', 'ben_plan_id', 'grp_rate_id', 'grp_rate_id'); -- -- TOC Entry ID 76 (OID 1621965) -- -- Name: "RI_ConstraintTrigger_1621964" Type: TRIGGER Owner: postgres -- CREATE CONSTRAINT TRIGGER "fk_grprate_grpratestep" AFTER UPDATE ON "grp_rate" FROM "grp_rate_step" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('fk_grprate_grpratestep', 'grp_rate_step', 'grp_rate', 'UNSPECIFIED', 'emp_grp_id', 'emp_grp_id', 'ben_plan_id', 'ben_plan_id', 'grp_rate_id', 'grp_rate_id'); -- -- TOC Entry ID 59 (OID 1621967) -- -- Name: "RI_ConstraintTrigger_1621966" Type: TRIGGER Owner: postgres -- CREATE CONSTRAINT TRIGGER "fk_benplan_cvgstep" AFTER INSERT OR UPDATE ON "coverage_step" FROM "ben_plan" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('fk_benplan_cvgstep', 'coverage_step', 'ben_plan', 'UNSPECIFIED', 'ben_plan_id', 'ben_plan_id'); -- -- TOC Entry ID 57 (OID 1621969) -- -- Name: "RI_ConstraintTrigger_1621968" Type: TRIGGER Owner: postgres -- CREATE CONSTRAINT TRIGGER "fk_benplan_cvgstep" AFTER DELETE ON "ben_plan" FROM "coverage_step" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('fk_benplan_cvgstep', 'coverage_step', 'ben_plan', 'UNSPECIFIED', 'ben_plan_id', 'ben_plan_id'); -- -- TOC Entry ID 58 (OID 1621971) -- -- Name: "RI_ConstraintTrigger_1621970" Type: TRIGGER Owner: postgres -- CREATE CONSTRAINT TRIGGER "fk_benplan_cvgstep" AFTER UPDATE ON "ben_plan" FROM "coverage_step" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('fk_benplan_cvgstep', 'coverage_step', 'ben_plan', 'UNSPECIFIED', 'ben_plan_id', 'ben_plan_id'); -- -- TOC Entry ID 90 (OID 1621973) -- -- Name: "RI_ConstraintTrigger_1621972" Type: TRIGGER Owner: postgres -- CREATE CONSTRAINT TRIGGER "fk_cvgrptd_steppedcvgrptd" AFTER INSERT OR UPDATE ON "stepped_cvg_rptd" FROM "cvg_rptd" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('fk_cvgrptd_steppedcvgrptd', 'stepped_cvg_rptd', 'cvg_rptd', 'UNSPECIFIED', 'emp_grp_id', 'emp_grp_id', 'ben_plan_id', 'ben_plan_id', 'grp_rate_id', 'grp_rate_id', 'rate_step_id', 'rate_step_id', 'rptg_seq_id', 'rptg_seq_id', 'rptg_prd_end_dt', 'rptg_prd_end_dt'); -- -- TOC Entry ID 66 (OID 1621975) -- -- Name: "RI_ConstraintTrigger_1621974" Type: TRIGGER Owner: postgres -- CREATE CONSTRAINT TRIGGER "fk_cvgrptd_steppedcvgrptd" AFTER DELETE ON "cvg_rptd" FROM "stepped_cvg_rptd" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('fk_cvgrptd_steppedcvgrptd', 'stepped_cvg_rptd', 'cvg_rptd', 'UNSPECIFIED', 'emp_grp_id', 'emp_grp_id', 'ben_plan_id', 'ben_plan_id', 'grp_rate_id', 'grp_rate_id', 'rate_step_id', 'rate_step_id', 'rptg_seq_id', 'rptg_seq_id', 'rptg_prd_end_dt', 'rptg_prd_end_dt'); -- -- TOC Entry ID 67 (OID 1621977) -- -- Name: "RI_ConstraintTrigger_1621976" Type: TRIGGER Owner: postgres -- CREATE CONSTRAINT TRIGGER "fk_cvgrptd_steppedcvgrptd" AFTER UPDATE ON "cvg_rptd" FROM "stepped_cvg_rptd" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('fk_cvgrptd_steppedcvgrptd', 'stepped_cvg_rptd', 'cvg_rptd', 'UNSPECIFIED', 'emp_grp_id', 'emp_grp_id', 'ben_plan_id', 'ben_plan_id', 'grp_rate_id', 'grp_rate_id', 'rate_step_id', 'rate_step_id', 'rptg_seq_id', 'rptg_seq_id', 'rptg_prd_end_dt', 'rptg_prd_end_dt'); -- -- TOC Entry ID 91 (OID 1621979) -- -- Name: "RI_ConstraintTrigger_1621978" Type: TRIGGER Owner: postgres -- CREATE CONSTRAINT TRIGGER "fk_steppedcvgrptg_cvgstep" AFTER INSERT OR UPDATE ON "stepped_cvg_rptd" FROM "coverage_step" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('fk_steppedcvgrptg_cvgstep', 'stepped_cvg_rptd', 'coverage_step', 'UNSPECIFIED', 'ben_plan_id', 'ben_plan_id', 'cvgstep_id', 'cvgstep_id'); -- -- TOC Entry ID 60 (OID 1621981) -- -- Name: "RI_ConstraintTrigger_1621980" Type: TRIGGER Owner: postgres -- CREATE CONSTRAINT TRIGGER "fk_steppedcvgrptg_cvgstep" AFTER DELETE ON "coverage_step" FROM "stepped_cvg_rptd" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('fk_steppedcvgrptg_cvgstep', 'stepped_cvg_rptd', 'coverage_step', 'UNSPECIFIED', 'ben_plan_id', 'ben_plan_id', 'cvgstep_id', 'cvgstep_id'); -- -- TOC Entry ID 61 (OID 1621983) -- -- Name: "RI_ConstraintTrigger_1621982" Type: TRIGGER Owner: postgres -- CREATE CONSTRAINT TRIGGER "fk_steppedcvgrptg_cvgstep" AFTER UPDATE ON "coverage_step" FROM "stepped_cvg_rptd" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('fk_steppedcvgrptg_cvgstep', 'stepped_cvg_rptd', 'coverage_step', 'UNSPECIFIED', 'ben_plan_id', 'ben_plan_id', 'cvgstep_id', 'cvgstep_id'); -- -- TOC Entry ID 82 (OID 1621985) -- -- Name: "RI_ConstraintTrigger_1621984" Type: TRIGGER Owner: postgres -- CREATE CONSTRAINT TRIGGER "fk_cvgrptd_payprdcvgrptd" AFTER INSERT OR UPDATE ON "pay_prd_cvg_rptd" FROM "cvg_rptd" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('fk_cvgrptd_payprdcvgrptd', 'pay_prd_cvg_rptd', 'cvg_rptd', 'UNSPECIFIED', 'emp_grp_id', 'emp_grp_id', 'ben_plan_id', 'ben_plan_id', 'grp_rate_id', 'grp_rate_id', 'rate_step_id', 'rate_step_id', 'rptg_seq_id', 'rptg_seq_id', 'rptg_prd_end_dt', 'rptg_prd_end_dt'); -- -- TOC Entry ID 68 (OID 1621987) -- -- Name: "RI_ConstraintTrigger_1621986" Type: TRIGGER Owner: postgres -- CREATE CONSTRAINT TRIGGER "fk_cvgrptd_payprdcvgrptd" AFTER DELETE ON "cvg_rptd" FROM "pay_prd_cvg_rptd" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('fk_cvgrptd_payprdcvgrptd', 'pay_prd_cvg_rptd', 'cvg_rptd', 'UNSPECIFIED', 'emp_grp_id', 'emp_grp_id', 'ben_plan_id', 'ben_plan_id', 'grp_rate_id', 'grp_rate_id', 'rate_step_id', 'rate_step_id', 'rptg_seq_id', 'rptg_seq_id', 'rptg_prd_end_dt', 'rptg_prd_end_dt'); -- -- TOC Entry ID 69 (OID 1621989) -- -- Name: "RI_ConstraintTrigger_1621988" Type: TRIGGER Owner: postgres -- CREATE CONSTRAINT TRIGGER "fk_cvgrptd_payprdcvgrptd" AFTER UPDATE ON "cvg_rptd" FROM "pay_prd_cvg_rptd" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('fk_cvgrptd_payprdcvgrptd', 'pay_prd_cvg_rptd', 'cvg_rptd', 'UNSPECIFIED', 'emp_grp_id', 'emp_grp_id', 'ben_plan_id', 'ben_plan_id', 'grp_rate_id', 'grp_rate_id', 'rate_step_id', 'rate_step_id', 'rptg_seq_id', 'rptg_seq_id', 'rptg_prd_end_dt', 'rptg_prd_end_dt'); -- -- TOC Entry ID 70 (OID 1621991) -- -- Name: "RI_ConstraintTrigger_1621990" Type: TRIGGER Owner: postgres -- CREATE CONSTRAINT TRIGGER "fk_rptgsession_cvgrptd" AFTER INSERT OR UPDATE ON "cvg_rptd" FROM "rptg_session" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('fk_rptgsession_cvgrptd', 'cvg_rptd', 'rptg_session', 'UNSPECIFIED', 'rptg_session_id', 'rptg_session_id'); -- -- TOC Entry ID 92 (OID 1621993) -- -- Name: "RI_ConstraintTrigger_1621992" Type: TRIGGER Owner: postgres -- CREATE CONSTRAINT TRIGGER "fk_rptgsession_cvgrptd" AFTER DELETE ON "rptg_session" FROM "cvg_rptd" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('fk_rptgsession_cvgrptd', 'cvg_rptd', 'rptg_session', 'UNSPECIFIED', 'rptg_session_id', 'rptg_session_id'); -- -- TOC Entry ID 93 (OID 1621995) -- -- Name: "RI_ConstraintTrigger_1621994" Type: TRIGGER Owner: postgres -- CREATE CONSTRAINT TRIGGER "fk_rptgsession_cvgrptd" AFTER UPDATE ON "rptg_session" FROM "cvg_rptd" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('fk_rptgsession_cvgrptd', 'cvg_rptd', 'rptg_session', 'UNSPECIFIED', 'rptg_session_id', 'rptg_session_id'); -- -- TOC Entry ID 6 (OID 1621726) -- -- Name: rptg_session_rptg_session_c_seq Type: SEQUENCE SET Owner: -- SELECT setval ('"rptg_session_rptg_session_c_seq"', 2, 't');