EmplID | int(4) |
|
|
|
PayGrupID | int(1) |
|
|
|
ListOrdr | int(4) |
|
|
|
DprtID | int(4) |
|
|
|
DOB | varchar(10) |
|
|
|
TNon | varchar(1) |
|
|
|
ESICBrch | varchar(10) |
|
|
|
ESICNo | varchar(10) |
|
|
|
DEPTID | varchar(6) |
|
|
|
DsigID | varchar(6) |
|
|
|
EC | varchar(4) |
|
|
|
PFNo | varchar(13) |
|
|
|
BankAcctNo | varchar(10) |
|
|
|
PAN | varchar(12) |
|
|
|
Titl | varchar(5) |
|
|
|
EmplName | varchar(37) |
|
|
|
Designation | varchar(50) |
|
|
|
BASIC | int(5) |
|
|
|
GradPay | varchar(5) |
|
|
|
Dj | varchar(15) |
|
|
|
DL | varchar(10) |
|
|
|
Scal | varchar(40) |
|
|
|
M_INC | varchar(2) |
|
|
|
REMARK1 | varchar(59) |
|
|
|
REMARK2 | varchar(10) |
|
|
|
REMARK3 | varchar(10) |
|
|
|
SOC_MEM | varchar(4) |
|
|
|
SEX | varchar(1) |
|
|
|
QUARTERS | varchar(1) |
|
|
|
PAY_REV | varchar(1) |
|
|
|
BYBUS | varchar(1) |
|
|
|
UNIT_F | varchar(2) |
|
|
|
GPFADV | varchar(5) |
|
|
|
FADV | varchar(4) |
|
|
|
HBA_INS | varchar(2) |
|
|
|
MCA_INS | varchar(3) |
|
|
|
COMP_INS | varchar(4) |
|
|
|
CY_INS | varchar(4) |
|
|
|
MCAINT_INS | varchar(4) |
|
|
|
HBAINT_INS | varchar(10) |
|
|
|
XF | varchar(1) |
|
|
|
FLAG_PAY | varchar(1) |
|
|
|
FLAG_T | varchar(8) |
|
|
|
FLAG_C | varchar(1) |
|
|
|
SF | varchar(8) |
|
|
|
HBA_IBB | varchar(1) |
|
|
|
MC | varchar(1) |
|
|
|
BASIC_RTD | varchar(1) |
|
|
|
DATE_TIME | varchar(30) |
|
|
|
PDATE_HBA | varchar(10) |
|
|
|
PDATE_MCA | varchar(10) |
|
|
|
PDATE_CY | varchar(10) |
|
|
|
PDATE_FAD | varchar(11) |
|
|
|
PDATE_GPF | varchar(10) |
|
|
|
DOJ | varchar(9) |
|
|
|
IT_FLAG | varchar(1) |
|
|
|
OLDACC | varchar(4) |
|
|
|
WPLACE | varchar(4) |
|
|
|
emailid | varchar(10) |
|
|
|
uniccode | varchar(10) |
|
|
|