table salarycomponent

create table ht_salarycomponent(

ht_salarycomponent_id varchar(32) not null,
ad_client_id varchar(32) not null,
ad_org_id varchar(32) not null,
isactive character(1) not null default 'Y',
created timestamp without time zone not null default now(),
createdby varchar(32) not null,
updated timestamp without time zone not null default now(),
updatedby varchar(32) not null,
first_name varchar(32) not null,
last_name varchar(32) not null,
description varchar(2000) null,
isearning character(1) not null default 'Y',
 constraint ht_sc_isactive_check check (isactive = any (array['Y' ::bpchar, 'N'::bpchar])),
 constraint ht_sc_key primary key (ht_salarycomponent_id),
 constraint ht_sc_ad_org foreign key (ad_org_id) references ad_org (ad_org_id),
 constraint ht_sc_ad_client foreign key (ad_client_id) references ad_client (ad_client_id),
 constraint ht_sc_isearning_check check (isearning = any (array['Y'::bpchar, 'N'::bpchar]))
);