tbl_company_contribution_process_salary

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
company_contribution_process_salary_id bigserial 19 √ nextval('tbl_company_contribution_proc_company_contribution_process__seq'::regclass)
employeeid varchar 500 √ null
tbl_employee.employeeid Implied Constraint R
month int4 10 √ null
year int4 10 √ null
computation_type varchar 110 √ null
pay_effect varchar 12 √ null
act_amount numeric 0 √ '0'::numeric
ps_salary numeric 0 √ '0'::numeric
process_date timestamp 29,6 √ null
pay_element_id int8 19 √ null
salary_type varchar 50 √ 'SALARY'::character varying
employee_pay_element_id int8 19 √ null
entity_id int8 19 √ null
in_fnf bool 1 false
salary_structure_id int8 19 √ null
createddate timestamp 29,6 √ null
createdby varchar 100 √ null
modifieddate timestamp 29,6 √ null
modifiedby varchar 100 √ null

Indexes

Constraint Name Type Sort Column(s)
tbl_company_contribution_process_salary_pk Primary key Asc company_contribution_process_salary_id

Relationships

Close relationships within degrees of separation