tbl_candidate_pay_element

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('tbl_candidate_pay_element_id_seq'::regclass)
candidate_offer_id int8 19 null
pay_element_code varchar 50 null
element_amount numeric 18,2 null
computation_type varchar 20 √ null
add_deduction varchar 12 √ null
is_active bool 1 √ null
salary_type varchar 50 √ null
element_id int8 19 null
is_delete bool 1 null
calculation_type varchar 50 null
section_name varchar 50 null
value_amount numeric 18,2 √ null
value_percentage numeric 5,2 √ null
value_pay_element_id int8 19 √ null
createdby varchar 50 null
createddate timestamp 29,6 null
modifiedby varchar 50 null
modifieddate timestamp 29,6 null
annual_element_amount numeric 0 √ null

The calculated annual monetary value of this pay element.
Example: 300000
Format: Numeric
Logic: This is the output amount, typically (“element_amount” * 12).

Indexes

Constraint Name Type Sort Column(s)
pk_tbl_candidate_pay_element Primary key Asc id

Relationships

Close relationships within degrees of separation