tbl_employeetdsmaster

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('tbl_employeetdsmaster_id_seq'::regclass)
tbl_employeetdsdeclarationdocuments.employeetdsmasterid fk_employeetdsdeclarationdocuments_employeetdsmasterid R
tbl_employeetdsdeclarations.employeetdsmasterid fk_employeetdsdeclarations_employeetdsmasterid R
tbl_employeetdsmasterhistory.employeetdsmasterid fk_employeetdsmasterhistory_employeetdsmasterid R
tbl_employeetdspreviousemployer.employeetdsmasterid fk_employeetdspreviousemployer_employeetdsmasterid R
employeeid varchar 500 null
tbl_employee.employeeid Implied Constraint R
financialyearid int8 19 null
regime varchar 3 null
totalgrosssalary numeric 0 null
paidgrosssalary numeric 0 null
projectedgrosssalary numeric 0 null
totaltaxablesalary numeric 0 null
paidtaxablesalary numeric 0 null
projectedtaxablesalary numeric 0 null
standarddeduction numeric 0 null
nettaxablesalary numeric 0 null
totalotherincome numeric 0 null
totalotherincomeexemption numeric 0 √ null
nettaxableincome numeric 0 null
previousemployertaxableincome numeric 0 √ null
previousemployerpt numeric 0 √ null
previousemployerpf numeric 0 √ null
previousemployerpaidtax numeric 0 √ null
totalincometax numeric 0 null
healthandeducationcess numeric 0 null
surcharge numeric 0 null
taxcredit87a numeric 0 null
totalincometaxliability numeric 0 null
paidincometax numeric 0 null
monthlyincometax numeric 0 null
remainingincometax numeric 0 null
totaltaxmonth int4 10 null
paidtaxmonth int4 10 null
remainingtaxmonth int4 10 null
paidpt numeric 0 √ null
projectedpt numeric 0 √ null
totalpt numeric 0 √ null
paidpf numeric 0 √ null
projectedpf numeric 0 √ null
totalpf numeric 0 √ null
totalgratuity numeric 0 √ null
exemptedgratuity numeric 0 √ null
taxablegratuity numeric 0 √ null
totalnps80ccd2 numeric 0 √ null
exemptednps80ccd2 numeric 0 √ null
taxablenps80ccd2 numeric 0 √ null
paidhra numeric 0 √ null
projectedhra numeric 0 √ null
totalhra numeric 0 √ null
paidbasicda numeric 0 √ null
projectedbasicda numeric 0 √ null
totalbasicda numeric 0 √ null
basicdametro numeric 0 √ null
basicdanonmetro numeric 0 √ null
section10and17limit numeric 0 √ null
section10and17declarationamount numeric 0 null
section10and17documentamount numeric 0 null
section10and17approveddocumentamount numeric 0 null
section10and17qualifiedamount numeric 0 null
sectionotherincomelimit numeric 0 √ null
sectionotherincomedeclarationamount numeric 0 null
sectionotherincomedocumentamount numeric 0 null
sectionotherincomeapproveddocumentamount numeric 0 null
sectionotherincomequalifiedamount numeric 0 null
section6alimit numeric 0 √ null
section6adeclarationamount numeric 0 null
section6adocumentamount numeric 0 null
section6aapproveddocumentamount numeric 0 null
section6aqualifiedamount numeric 0 null
section80climit numeric 0 √ null
section80cdeclarationamount numeric 0 null
section80cdocumentamount numeric 0 null
section80capproveddocumentamount numeric 0 null
section80cqualifiedamount numeric 0 null
section80glimit numeric 0 √ null
section80gdeclarationamount numeric 0 null
section80gdocumentamount numeric 0 null
section80gapproveddocumentamount numeric 0 null
section80gqualifiedamount numeric 0 null
allsectionlimit numeric 0 √ null
allsectiondeclarationamount numeric 0 null
allsectiondocumentamount numeric 0 null
allsectionapproveddocumentamount numeric 0 null
allsectionqualifiedamount numeric 0 null
pendingdocumentcount int4 10 √ null
status varchar 20 null
remarks varchar 500 √ null
hostelallowanceeligiblechildren int4 10 √ null
childeducationeligiblechildren int4 10 √ null
employeeageatendoffyear int4 10 √ null
parentabove60atendoffyear int4 10 √ null
parentbelow60atendoffyear int4 10 √ null
residenttype varchar 9 √ null
questionnaires varchar 2147483647 √ null
declarationlimits varchar 2147483647 √ null
salarydata varchar 2147483647 √ null
salarydatapaid varchar 2147483647 √ null
salarydataprojection varchar 2147483647 √ null
fnfdata varchar 2147483647 √ null
lastrejecteddocuments text 2147483647 √ null
createdby varchar 50 √ null
createddate timestamp 29,6 √ null
modifiedby varchar 50 √ null
modifieddate timestamp 29,6 √ null
numeric 0 √ null
projected_vpf numeric 0 √ null
total_vpf numeric 0 √ null
taxablepfnpssuperannuation numeric 0 √ null
is_form_16_released bool 1 √ null

Indexes

Constraint Name Type Sort Column(s)
tbl_employeetdsmaster_pk_tbl_employeetdsmaster Primary key Asc id
tbl_employeetdsmaster_unique_employeeidandfinancialyearid Must be unique Asc/Asc employeeid + financialyearid

Relationships

Close relationships within degrees of separation