tbl_payrolladjustmentshistory

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('tbl_payrolladjustmentshistory_id_seq'::regclass)
payrolladjustmentsid int8 19 √ null
employeeid varchar 500 √ null
tbl_employee.employeeid Implied Constraint R
adjustmentamount numeric 0 √ null
payeffect varchar 20 √ null
adjustmentmonth int4 10 √ null
adjustmentyear int4 10 √ null
payelementcode varchar 350 √ null
notes varchar 500 √ null
psmonth int4 10 √ null
psyear int4 10 √ null
approvedby varchar 50 √ null
releasestatus varchar 50 √ null
originalimpact varchar 50 √ null
payelementid int8 19 null
tbl_employeepayelement.payelementid Implied Constraint R
salarytype varchar 50 √ '''SALARY'''::character varying
employeepayelementid int8 19 √ null
deductionid int8 19 √ null
approveddate timestamp 29,6 √ null
approverejectreason varchar 500 √ null
createdby varchar 50 √ null
createddate timestamp 29,6 √ null
modifiedby varchar 50 √ null
modifieddate timestamp 29,6 √ null
actamount numeric 0 √ null
isdeleted bool 1 √ null

Indexes

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

Relationships

Close relationships within degrees of separation