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