tbl_arrears

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('tbl_arrears_id_seq'::regclass)
employeeid varchar 500 null
tbl_employee.employeeid Implied Constraint R
payelementid int8 19 null
tbl_employeepayelement.payelementid Implied Constraint R
payelementcode varchar 100 null
arrearsamount numeric 0 null
arrearsstatus varchar 50 null
arrearscalculatedmonth int8 19 null
arrearscalculatedyear int8 19 null
paymentmonth int8 19 √ null
paymentyear int8 19 √ null
payeffect varchar 100 null
employeepayelementid int8 19 √ null
liabilitygroupname varchar 100 √ null
approverejectreason varchar 500 √ null
createdby varchar 50 √ null
createddate timestamp 29,6 √ null
modifiedby varchar 50 √ null
modifieddate timestamp 29,6 √ null
salary_structure_id int8 19 √ null
salary_type varchar 50 √ 'SALARY'::character varying

Indexes

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

Relationships

Close relationships within degrees of separation