tbl_systemworkflow

1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('tbl_systemworkflow_id_seq'::regclass)
cmpid int4 10 null
tbl_companymaster.companyid fk__tbl_syste__cmpid__5751971b R
compensatoryoff varchar 10 √ null
loanrestriction bool 1 √ null
maximumloanpersitepercentage numeric 0 √ null
additionalloanmonths int4 10 √ null
workinghoursattendanceflag bool 1 √ null
workinghoursattendancerangestartquater1 numeric 0 √ null
workinghoursattendancerangestartquater2 numeric 0 √ null
workinghoursattendancerangestartquater3 numeric 0 √ null
workinghoursattendancerangestartquater4 numeric 0 √ null
workinghoursattendancerangestartquater5 numeric 0 √ null
workinghoursattendancerangestartquater6 numeric 0 √ null
workinghoursattendancerangestartquater7 numeric 0 √ null
workinghoursattendancerangestartquater8 numeric 0 √ null
workinghoursattendancequater1 numeric 0 √ null
workinghoursattendancequater2 numeric 0 √ null
workinghoursattendancequater3 numeric 0 √ null
workinghoursattendancequater4 numeric 0 √ null
halfdaycoffallow bool 1 √ null
coffworkinghoursqueater1 numeric 0 √ null
coffworkinghoursqueater2 numeric 0 √ null
coffworkinghoursqueater3 numeric 0 √ null
coffworkinghoursqueater4 numeric 0 √ null
coffhoursqueter1 numeric 0 √ null
coffhoursqueter2 numeric 0 √ null
atulot bool 1 √ null
otslabhrs1 numeric 0 √ null
otslabhrs2 numeric 0 √ null
otslabhrs3 numeric 0 √ null
otslabhrs4 numeric 0 √ null
otslabhrs5 numeric 0 √ null
otslabhrs6 numeric 0 √ null
otslabhrs7 numeric 0 √ null
otslabhrs8 numeric 0 √ null
otslabhrs9 numeric 0 √ null
otslabhrs10 numeric 0 √ null
otslabhrs11 numeric 0 √ null
otslabhrs12 numeric 0 √ null
otslabhrs13 numeric 0 √ null
otslabhrs14 numeric 0 √ null
otslabhrs15 numeric 0 √ null
otslabhrs16 numeric 0 √ null
otslabhrs17 numeric 0 √ null
otslabhrs18 numeric 0 √ null
otslabhrs19 numeric 0 √ null
otslabhrs20 numeric 0 √ null
otslabhrs21 numeric 0 √ null
otslabhrs22 numeric 0 √ null
otslabhrs23 numeric 0 √ null
otslabhrs24 numeric 0 √ null
otslabhrs25 numeric 0 √ null
otslabhrs26 numeric 0 √ null
otslabhrs27 numeric 0 √ null
otslabhrs28 numeric 0 √ null
otslabhrs29 numeric 0 √ null
otslabhrs30 numeric 0 √ null
otslabhrs31 numeric 0 √ null
otslabhrs32 numeric 0 √ null
otslabhrs33 numeric 0 √ null
otslabhrs34 numeric 0 √ null
otslabhrs35 numeric 0 √ null
otslabhrs36 numeric 0 √ null
otslabhrs37 numeric 0 √ null
otslabhrs38 numeric 0 √ null
otslabhrs39 numeric 0 √ null
otslabhrs40 numeric 0 √ null
otslabhrs41 numeric 0 √ null
otslabhrs42 numeric 0 √ null
otslabhrs43 numeric 0 √ null
otslabhrs44 numeric 0 √ null
otslabhrs45 numeric 0 √ null
otslabhrs46 numeric 0 √ null
otslabhrs47 numeric 0 √ null
otslabhrs48 numeric 0 √ null
otslabhrs49 numeric 0 √ null
otslabhrs50 numeric 0 √ null
otslabhrs51 numeric 0 √ null
otslabhrs52 numeric 0 √ null
otslabhrs53 numeric 0 √ null
otslabhrs54 numeric 0 √ null
otslabhrs55 numeric 0 √ null
otslabhrs56 numeric 0 √ null
otslabhrs57 numeric 0 √ null
otslabhrs58 numeric 0 √ null
otslabhrs59 numeric 0 √ null
otslabhrs60 numeric 0 √ null
otslabhrs61 numeric 0 √ null
otslabhrs62 numeric 0 √ null
otslabhrs63 numeric 0 √ null
otslabhrs64 numeric 0 √ null
otslabhrs65 numeric 0 √ null
otslabhrs66 numeric 0 √ null
otslabhrs67 numeric 0 √ null
otslabhrs68 numeric 0 √ null
otslabhrs69 numeric 0 √ null
otslabhrs70 numeric 0 √ null
otslabhrs71 numeric 0 √ null
otslabhrs72 numeric 0 √ null
otslabhrs73 numeric 0 √ null
otslabhrs74 numeric 0 √ null
otslabhrs75 numeric 0 √ null
otslabhrs76 numeric 0 √ null
lateandearlycombine bool 1 √ null
magicretaotsalab bool 1 √ null
othoursovertimequater1 numeric 0 √ null
othoursovertimequater2 numeric 0 √ null
othoursovertimequater3 numeric 0 √ null
othoursovertimequater4 numeric 0 √ null
overtimeattendancerangestartquater1 numeric 0 √ null
overtimeattendancerangestartquater2 numeric 0 √ null
overtimeattendancerangestartquater3 numeric 0 √ null
overtimeattendancerangestartquater4 numeric 0 √ null
overtimeattendancerangestartquater5 numeric 0 √ null
overtimeattendancerangestartquater6 numeric 0 √ null
overtimeattendancerangestartquater7 numeric 0 √ null
overtimeattendancerangestartquater8 numeric 0 √ null
overtimeattendancerangestartquater9 numeric 0 √ null
coffautoadjust bool 1 √ null
coffoutdated bool 1 √ null
setmenu varchar 1000 √ null
atulautodirectbonusdeduction20percent bool 1 √ null
minimumworkinghourstomarkattendace bool 1 √ null
minimumworkinghourstofuldaypresnt numeric 0 √ null
minimumworkinghourstohalfdaypresent numeric 0 √ null
allemployeeidsint bool 1 √ null
bool 1 √ null
clleaveapplicationeligiblityperiodinmonth numeric 0 √ null
slleaveapplicationeligiblityinprobation numeric 0 √ null
plleaveapplicationeligiblityinprobation numeric 0 √ null
maximumleaveallowindays numeric 0 √ null
netsalaryminus bool 1 √ null
asianleaventitiled bool 1 √ null
sendwichapplicable bool 1 √ null
topslatecomingpolicy bool 1 √ null
isapprovedcoffentitledatthetimeofsalaryproccess bool 1 √ null
categoryforcoffentitlement varchar 500 √ null
cofffromot bool 1 √ null
maximumnoofdaysconsiderasovertime int4 10 √ null
allowadminpannelaccess bool 1 √ null
rolename varchar 500 √ null
imageurl varchar 500 √ null
offdaysworkingasarrear bool 1 √ null
maxdays numeric 0 √ null
reportingpersoncanappliycancelleaveapplicationforemployee bool 1 √ null
reportingpersonrolename varchar 500 √ null
retentionperiodinmonth int4 10 √ null
retentionshowinsalary bool 1 √ null
krishattendancepolicy bool 1 √ null
topsleavebalancepolicyafterprobationconfirmation bool 1 √ null
masterpagetopbackgroundimage bool 1 √ null
masterpageforvolansys bool 1 √ null
displayemployeeprofiledetailsforreportingperson bool 1 √ null
displayemployeereportingperson bool 1 √ null
displayonlypdf bool 1 √ null
emailformartforcompnayurl varchar 500 √ null
emailformartforcompnayname varchar 500 √ null
emailformatforpowerbyurl varchar 500 √ null
emailformatforpowerbyname varchar 500 √ null
emailformatforfacebook varchar 500 √ null
emailformatfortwitter varchar 500 √ null
knackattendancewarning bool 1 √ null
potenzaattendancepolicy bool 1 √ null
offdaydeductinsalary bool 1 √ null
znlattendancewarning bool 1 √ null
znlpenalty bool 1 √ null
knackpfbonuslimitset bool 1 √ null
knack bool 1 √ null
applylockonapproval bool 1 √ null
lockonapprovalafterdayofmonth int4 10 √ null
emailnoficationurlforapproval varchar 500 √ null
isreportingpersonhaverighttoeditemployeedetail bool 1 √ null
leaveentitlementinprobation bool 1 √ null
employeeselectiongiventoreportingperson bool 1 √ null
znlhalfdayaattendancepolicy bool 1 √ null
znlhalfdayaattendancehours numeric 0 √ null
znlhalfdayaattendancehours1 numeric 0 √ null
ldapauthention bool 1 √ null
hourlypaymentmethods bool 1 √ null
actualhour numeric 0 √ null
atul bool 1 √ null
magicrete bool 1 √ null
asian bool 1 √ null
tops bool 1 √ null
allowfirstpuchofdayasoutpunchofpreviousday bool 1 √ null
timefrom varchar 50 √ null
timeto varchar 50 √ null
nextdayoutshiftbeforeshifthourspunchdetecthours numeric 0 √ null
punchmissingemailsendtohr bool 1 √ null
gatepassoutpunchtimeallowlessthenequaltominutes numeric 0 √ null
gatepassoutpunchtimeallowgreaterthenequaltominutes numeric 0 √ null
minimumtimedurationrequiredtoconsiderasnextpunchinminute numeric 0 √ null
paidsandwich bool 1 √ null
paidholidaysandwich bool 1 √ null
paidoffsandwich bool 1 √ null
uppaidsandwich bool 1 √ null
unpaidholidaysandwich bool 1 √ null
unpaidoffdaysandwich bool 1 √ null
coffhalfhour varchar 10 √ null
cofffullhour varchar 10 √ null
notallowhalfdayleaveforsaturday varchar 50 √ null
minimumworkinghourstopresentforsaturday numeric 0 √ null
earlygoingrequestlimit int4 10 √ null
latecomingrequestlimit int4 10 √ null
coffspaymentapplicable varchar 20 √ null
coffspaymentmode varchar 20 √ null
coffspaymentpercentage numeric 0 √ null
earlygoingrequesthourlimit numeric 0 √ null
latecomingrequesthourlimit numeric 0 √ null
travel varchar 50 √ null
tdsempid varchar 500 √ null
departmentwiseleaveallocation bool 1 √ null
paycaderwiseleaveallocation bool 1 √ null
leaveinprobation numeric 0 √ null
rebateincomeamountlimit numeric 0 √ null
rebateus87amount numeric 0 √ null
maxallowlatecoming int4 10 √ null
fnfmaxpfamountppf numeric 0 √ null
applylatecomingpolicy bool 1 √ null
fnfleaveencashforstatutory bool 1 √ null
accountemailid varchar 100 √ null
maxloginattempt int4 10 √ 3
sessiontimeout int4 10 √ 30
ltafromdate timestamp 29,6 √ null
ltaenddate timestamp 29,6 √ null
maxallowlta int4 10 √ 2
allowuploadphoto bool 1 √ null
standarddeduction numeric 0 √ null
attendanceprocessnotification bool 1 √ false
withcompliancesalaryslip bool 1 √ false
showleavedetailwithsalaryslip bool 1 √ false
educationcess numeric 0 √ null
temp1 numeric 0 √ null
temp2 numeric 0 √ null
temp3 bool 1 √ null
temp4 bool 1 √ null
jumbourl varchar 500 √ null
emgagejumbourl varchar 500 √ null
admincompanyurl varchar 500 √ null
tracking_allowed bool 1 false
multi_punch_allowed bool 1 false
expense_allowed bool 1 false
tracking_interval int4 10 √ 5
payslipurl varchar 100 √ null
google_map_distance_calculation bool 1 √ false
timesheetonpunchinout int4 10 √ null
sass_enabled bool 1 √ false
allowbackdateshift bool 1 √ true
showtenantimage bool 1 √ null
networkinghours bool 1 √ false
loginpageimageurl varchar 200 √ null
attendenceschedulerallow bool 1 false
approvalviaemail bool 1 false
tds_gst_in_expense bool 1 √ null
trackingnotificationtitle varchar 100 √ null
trackingnotificationdescription varchar 100 √ null
defaultidleradius numeric 0 √ null
fetchlocationname bool 1 √ false
holidaydisplayyearconfig varchar 255 √ '''CALENDAR'''::character varying
overtimeconfig varchar 50 √ null
albumsize int4 10 √ 10
sendnewpassword bool 1 √ true
pendingnotificationfrequency varchar 20 √ null
requireddocuments varchar 500 √ null
quicklinks text 2147483647 √ null
companywisefinancialyear bool 1 true
financialyearclosebuttonshowdays numeric 0 √ null
salarybatchconfig varchar 100 √ null
dateofjoinlimit int4 10 √ null
albumphotosize int4 10 √ 20
post_salary_slip_with_email bool 1 false
post_salary_slip_pdf_in_email bool 1 false
resetpayrollemails text 2147483647 √ null
resetpayrollsheetwithemail bool 1 false
mail_batch_size int4 10 √ null
companylivemonthyear date 13 √ null
cancel_leave_request_after varchar 100 √ null
cancel_leave_request_on varchar 100 √ null
api_permissions text 2147483647 √ null
joining_form_public_url bool 1 true
is_expense_date_configuration bool 1 √ false
libreoffice_paths text 2147483647 √ '/usr/lib/libreoffice,/usr/lib64/libreoffice,/usr/share/libreoffice,/opt/libreoffice/program,C:\Program Files\LibreOffice'::text
include_egr_lcr_in_ot bool 1 √ true
offday_shift varchar 20 √ null
support_config text 2147483647 √ '[]'::character varying
is_ctc_gross_round_off bool 1 √ null
send_auto_probation_mail_to varchar 2147483647 √ '1,2,3'::character varying
days_to_initiate_review numeric 0 √ 0
hide_project_tasks bool 1 √ null
make_pair_of_punch bool 1 false

Indexes

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

Relationships

Close relationships within degrees of separation