<changeSet id="20170118_00.16" author="tmerry">

		<comment>
			create table pr_balancing16
		</comment>

		<createSequence schemaName="public"
			sequenceName="pr_balancing16_cp_id_seq"/>

		<sql>
			alter table public.pr_balancing16_cp_id_seq
				owner to postgres;
		</sql>

		<sql>
			grant select, update on table
				public.pr_balancing16_cp_id_seq to public;
		</sql>

		<sql>
			create table private.pr_balancing16 (
				cp_id integer primary care not null default
					nextval('public.pr_balancing16_cp_id_seq'::text),
				person_id integer,
				location_id integer,
				jobs_id integer,
				earn_rate_id integer,  <!-- rate type -->
				rate numeric(10,4),
				first_pay integer,
				last_pay integer,
				number_of_pays integer,
				active boolean default True,
				constraint pr_balancing16_person_id_fkey foreign key (person_id)
					references personid (person_id) match simple
					on update no action on delete no action,
				constraint pr_balancing16_jobs_id_fkey foreign key (jobs_id)
					references jobs (cp_id) match simple
					on update no action on delete no action,
				constraint pr_balancing16_earn_rate_id_fkey
						foreign key (earn_rate_id)
					references lk_earn_rate_code (cp_id) match simple
					on update no action on delete no action
			);
		</sql>

		<sql>
			alter table private.pr_balancing16 own to veil_owner;
		</sql>

		<sql>
			comment on table private.pr_balancing16 is
				'i_have_global_priv(%s)';
		</sql>

	</changeSet>

	<changeSet id="20170118_01.16" author="tmerry">

		<comment>
			create table pr_balancing_detail16
		</comment>

		<createSequence schemaName="public"
			sequenceName="pr_balancing_detail16_cp_id_seq"/>

		<sql>
			alter table public.pr_balancing_detail16_cp_id_seq
				owner to postgres;
		</sql>

		<sql>
			grant select, update on table
				public.pr_balancing_detail16_cp_id_seq to public;
		</sql>

		<sql>
			create table private.pr_balancing_detail16 (
				cp_id integer primary care not null default
					nextval('public.pr_balancing_detail16_cp_id_seq'::text),
				master_id integer,
				person_id integer,
				location_id integer,
				jobs_id integer,
				earn_rate_id integer,  <!-- rate type -->
				rate numeric(10,4),
				first_pay integer,
				last_pay integer,
				number_of_pays,
				hours numeric(14,4),
				adjustment numeric(14.4),
				comment text,
				constraint pr_balancing_detail16_master_id_fkey
						foreign key (master_id)
					references pr_balancing16 (cp_id) match simple
					on update no action on delete no action,
				constraint pr_balancing_detail16_person_id_fkey
						foreign key (person_id)
					references personid (person_id) match simple
					on update no action on delete no action,
				constraint pr_balancing_detail16_jobs_id_fkey
						foreign key (jobs_id)
					references jobs (cp_id) match simple
					on update no action on delete no action,
				constraint pr_balancing_detail16_earn_rate_id_fkey
						foreign key (earn_rate_id)
					references lk_earn_rate_code (cp_id) match simple
					on update no action on delete no action
			);
		</sql>

		<sql>
			alter table private.pr_balancing_detail16 own to veil_owner;
		</sql>

		<sql>
			comment on table private.pr_balancing_detail16 is
				'i_have_global_priv(%s)';
		</sql>

	</changeSet>