tbl_processsalary

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
processsalaryid bigserial 19 √ nextval('tbl_processsalary_processsalaryid_seq'::regclass)
employeeid varchar 20 √ null
tbl_employee_previous_pf.employeeid Implied Constraint R
monthlyattendanceid int4 10 √ null
payslipmonth int4 10 √ null
psyear int4 10 √ null
psdays int4 10 √ null
attendance numeric 0 √ '0'::numeric
computationtype varchar 40 √ null
adddeduction varchar 12 √ null
actamount numeric 0 √ '0'::numeric
pssalary numeric 0 √ '0'::numeric
arrearamount numeric 0 √ '0'::numeric
employercont numeric 0 √ '0'::numeric
employerppf numeric 0 √ '0'::numeric
admincharge numeric 0 √ '0'::numeric
otheramount numeric 0 √ '0'::numeric
effectlable varchar 15 √ null
processdate timestamp 29,6 √ null
processby varchar 20 √ null
isarrear bool 1 √ false
createddate timestamp 29,6 √ null
createdby varchar 100 √ null
modifieddate timestamp 29,6 √ null
modifiedby varchar 100 √ null
isimport bool 1 √ false
payelementid int8 19 √ null
tbl_employeepayelement.payelementid Implied Constraint R
salarytype varchar 50 √ '''SALARY'''::character varying
employeepayelementid int8 19 √ null
isdefault bool 1 √ false
entityid int8 19 √ null
salary_structure_id int8 19 √ null

Indexes

Constraint Name Type Sort Column(s)
tbl_processsalary_pk_tbl_processsalary Primary key Asc processsalaryid
ix_tbl_processsalary_employeeid_payslipmonth_psyear Performance Asc/Asc/Asc employeeid + payslipmonth + psyear
ix_tbl_processsalary_monthlyattendanceid Performance Asc monthlyattendanceid

Relationships

Close relationships within degrees of separation