Difference between revisions of "Mypaydb"

From SPGC Document Wiki
Jump to: navigation, search
(→‎dtt2016)
Line 3,882: Line 3,882:
 
|-
 
|-
 
|DT_CB
 
|DT_CB
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|}
 +
 +
==dw2016==
 +
{| class="wikitable" \
 +
!colspan="7" | dw2016
 +
|-
 +
! style="text-align:left;" | Column Name
 +
! Data Type
 +
! Length
 +
! Is PrimaryKey
 +
! Is Not Null
 +
! Auto Increment
 +
|-
 +
|EMPNUMB
 +
|Varchar
 +
|15
 +
|No
 +
|No
 +
|No
 +
|-
 +
|EMPLNAM
 +
|Varchar
 +
|30
 +
|No
 +
|No
 +
|No
 +
|-
 +
|EMPFNAM
 +
|Varchar
 +
|30
 +
|No
 +
|No
 +
|No
 +
|-
 +
|EMPMNAM
 +
|varchar
 +
|30
 +
|No
 +
|No
 +
|No
 +
|-
 +
|EMPTINO
 +
|varchar
 +
|30
 +
|No
 +
|No
 +
|No
 +
|-
 +
|EMPTXCD
 +
|varchar
 +
|2
 +
|No
 +
|No
 +
|No
 +
|-
 +
|EMPTAXEXEM
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|-
 +
|EMPHDTE
 +
|date
 +
|0
 +
|No
 +
|No
 +
|No
 +
|-
 +
|SEPDATE
 +
|date
 +
|0
 +
|No
 +
|No
 +
|No
 +
|-
 +
|EMPBDTE
 +
|date
 +
|0
 +
|No
 +
|No
 +
|No
 +
|-
 +
|EMP13TH
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|-
 +
|EMPSLPY
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|-
 +
|EMPUNION
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|-
 +
|EMPAMEDE
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|-
 +
|EMPASSSE
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|-
 +
|EMPAGROSS
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|-
 +
|EMPAPIBE
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|-
 +
|EMPATAXC
 
|double
 
|double
 
|15,2
 
|15,2

Revision as of 14:56, 24 June 2016

ahs2016

ahs2016
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
AHSNUMB Varchar 15 No No No
AHSGPAY double 15,2 No No No
AHSALLO double 15,2 No No No
AHS13MO double 15,2 No No No
AHSSLVL double 15,2 No No No
AHSSVLR double 15,2 No No No
AHSBONS double 15,2 No No No
AHSTAXD double 15,2 No No No
AHSTAXW double 15,2 No No No

alphalist_log

alphalist_log
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
EMPNUMB Varchar 15 No No No
EMPLNAM Varchar 30 No No No
EMPFNAM Varchar 30 No No No
EMPMNAM varchar 30 No No No
EMPTINO varchar 30 No No No
EMPTXCD varchar 2 No No No
EMPTAXEXEM double 15,2 No No No
EMPHDTE date 0 No No No
SEPDATE date 0 No No No
EMPBDTE date 0 No No No
EMP13TH double 15,2 No No No
EMPSLPY double 15,2 No No No
EMPUNION double 15,2 No No No
EMPAMEDE double 15,2 No No No
EMPASSSE double 15,2 No No No
EMPAGROSS double 15,2 No No No
EMPAPIBE double 15,2 No No No
EMPATAXC double 15,2 No No No
EMPATAXCDEC double 15,2 No No No
EMPSEPA varchar 1 No No No
EMPCLASSM varchar 10 No No No
TXYMNGR double 15,2 No No No
TXYTXRT double 15,2 No No No
TXYTXAD double 15,2 No No No
TAXI double 15,2 No No No
TAXEXEM double 15,2 No No No
GOV_CONTRIB double 19,2 No No No
EMPBPAY double 15,2 No No No
AHSTAXW double 15,2 No No No
EMPBALL double 15,2 No No No
TAXDUE double 15,2 No No No
EMPDPCD varchar 30 No No No
EMP13THTAX double 15,2 No No No
MWE varchar 1 No No No
MWESAL double 19,2 No Yes No
_dateproc datetime 0 No Yes No

alphalist_log_mwe

alphalist_log_mwe
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
EMPNUMB Varchar 15 No No No
EMPLNAM varchar 30 No No No
EMPFNAM varchar 30 No No No
EMPMNAM varchar 30 No No No
EMPTINO varchar 30 No No No
EMPTXCD varchar 2 No No No
EMPTAXEXEM double 15,2 No No No
EMPHDTE varbinary 10 No No No
EMPSEPADTE date 0 No No No
EMPBDTE date 15 No No No
EMP13TH double 15,2 No No No
EMPSLPY double 15,2 No No No
EMPUNION double 15,2 No No No
EMPAMEDE double 15,2 No No No
EMPASSSE double 15,2 No No No
EMPAGROSS double 15,2 No No No
EMPAPIBE double 15,2 No No No
EMPATAXC double 15,2 No No No
EMPATAXCDEC double 15,2 No No No
EMPSEPA varchar 1 No No No
EMPCLASSM varchar 10 No No No
TXYMNGR double 15,2 No No No
TXYTXRT double 15,2 No No No
TXYTXAD double 15,2 No No No
TAXI double 15,2 No No No
TAXEXEM double 15,2 No No No
GOV_CONTRIB double 19,2 No No No
EMPBPAY double 15,2 No No No
EMPBALL double 15,2 No No No
TAXDUE double 15,2 No No No
EMPREGION varchar 15 No No No
HOLPAY double 15,2 No No No
OTPAY double 15,2 No No No
NSDPAY double 15,2 No No No
RATEDAY double 15,2 No No No
RATEMO double 19,2 No No No
RATEYR double 15,2 No No No
EMPDPCD varchar 30 No No No
MWEGROSS double 15,2 No No No
MWESAL double 15,2 No Yes No
MWEFLAG varchar 1 No No No
DATEPROC datetime 0 No No No

attlogs_upld

attlogs_upld
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
recid int 25 Yes Yes Yes
ATTL_USER varchar 25 No No No
ATTL_FILE varchar 100 No No No
ATTL_DATE datetime 0 No No No
ATTL_OFILE varchar 100 No No No
ATTL_RMARK varchar 25 No No No

bankdtl

bankdtl
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
recid int 25 No Yes No
BNKBKCD Varchar 3 No No No
BNKCOCD Varchar 25 No No No
BNKPCLASS varchar 25 No No No
BNKACCTTYPE varchar 25 No No No
BNKACCT varchar 25 No No No
BNKACCT_13MO varchar 25 No No No
BNKCONTPERSON varchar 150 No No No
BNKCONTPOSITION varchar 150 No No No
BNKADDR varchar 150 No No No
BNKDISBCODE varchar 15 No No No
BNKDISBNAME varchar 150 No No No
RPT_CHECK_REVIEWED varchar 150 No No No
RPT_CHECK_REVIEWED_POSI varchar 150 No No No
RPT_NOTED varchar 150 No No No
RPT_NOTED_POSI varchar 150 No No No
RPT_APPROVED varchar 150 No No No
RPT_APPROVED_POSI varchar 150 No No No
RPT_FINAL_APPROVED varchar 150 No No No
RPT_FINAL_APPROVED_POSI varchar 150 No No No

birtax2316_2016

birtax2316_2016
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
recid int 20 Yes Yes Yes
EMPTINNO Varchar 15 No No No
EMPCOCD Varchar 3 No No No
EMPMWE_FLAG varchar 3 No No No
EMPSEP_FLAG varchar 3 No No No
EMPTXCD varchar 10 No No No
EMPNAME varchar 150 No No No
EMPADDR varchar 150 No No No
EMPBDAY date 0 No No No
MINWAGE_PER_DATE double 15,2 No No No
MINWAGE_PER_MONTH double 15,2 No No No
EMPLOYER_NAME varchar 150 No No No
EMPLOYER_ADDR varchar 150 No No No
P4GPAY_PRES double 15,2 No No No
P4NONTX_EXMPT double 15,2 No No No
P4TX_COMP_PRES double 15,2 No No No
P4TX_COMP_PREV double 15,2 No No No
P4GROSS_TAX_COMP double 15,2 No No No
P4TOT_EXEMPT double 15,2 No No No
P4PREMIUM_MEDE double 15,2 No No No
P4NET_TAX_COMP double 15,2 No Yes No
P4TAX_DUE double 15,2 No No No
P4TAXWITH_PRES double 15,2 No No No
P4TEXWITH_PREV double 15,2 No No No
P4_ADJUSTED_TAX_AMNT double 15,2 No No No
NTBPAY double 15,2 No No No
NTHOLPAY double 15,2 No No No
NTOTPAY double 15,2 No No No
NTNTPAY double 15,2 No No No
NTHAZPAY double 15,2 No No No
NTMPAY13 double 15,2 No No No
NTDEMINIMIS double 15,2 No No No
NTGOV_CONT double 15,2 No No No
NTOTHER_COMP double 15,2 No No No
NTNONTAX_COMP double 15,2 No No No
TXBPAY double 15,2 No No No
TXREPRESENTATION double 15,2 No No No
TXTRANSPO double 15,2 No No No
TXCOLA double 15,2 No No No
TXHOUSE_ALLO double 15,2 No No No
TXCOMMISION double 15,2 No No No
TXPROF_SHARING double 15,2 No No No
TXDIRECTOR_FEE double 15,2 No No No
TXMPAY13 double 15,2 No No No
TXHAZPAY double 15,2 No No No
TXOTPAY double 15,2 No No No
TXTAX_COMP double 150 No No No
PERIOD_FROM date 0 No No No
PERIOD_TO date 0 No No No
EMPNUMB varchar 15 No No No
EMPPCCD varchar 2 No No No
EMPTAXREF double 15,2 No No No

bonus_simul2016

bonus_simul2016
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
AHSNUMB Varchar 15 No No No
AHSGPAY double 15,2 No No No
AHS13MO double 15,2 No No No
AHSBONS double 15,2 No No No
AHSSLRE double 15,2 No No No
AHSVLRE double 15,2 No No No
AHSSLPY double 15,2 No No No
AHSVLPY double 15,2 No No No
AHSLTAG tinyint 1 No No No
AHSCTAG varchar 1 No No No
AHSLPAY double 15,2 No No No
AHSPYNO varchar 10 No No No
AHSSTAT varchar 1 No No No
AHSPMCD varchar 1 No No No
AHSESCD varchar 1 No No No
AHSPCCD varchar 1 No No No
AHSBKCD varchar 5 No No No
AHSCOCD varchar 1 No No No
AHSLCCD varchar 3 No No No
AHSFDVL double 15,2 No No No
AHSFDSL double 15,2 No No No
AHSBPAY double 15,2 No No No
AHSDPCD varchar 10 No No No

bonus2016

bonus2016
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
AHSNUMB Varchar 15 No No No
AHSGPAY double 15,2 No No No
AHS13MO double 15,2 No No No
AHSBONS double 15,2 No No No
AHSSLRE double 15,2 No No No
AHSVLRE double 15,2 No No No
AHSSLPY double 15,2 No No No
AHSVLPY double 15,2 No No No
AHSLTAG tinyint 1 No No No
AHSCTAG varchar 1 No No No
AHSLPAY double 15,2 No No No
AHSPYNO varchar 10 No No No
AHSSTAT varchar 1 No No No
AHSPMCD varchar 1 No No No
AHSESCD varchar 1 No No No
AHSPCCD varchar 1 No No No
AHSBKCD varchar 5 No No No
AHSCOCD varchar 1 No No No
AHSLCCD varchar 3 No No No
AHSFDVL double 15,2 No No No
AHSFDSL double 15,2 No No No
AHSBPAY double 15,2 No No No
AHSDPCD varchar 10 No No No

bse2016

bse2016
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
EMPNUMB Varchar 15 No No No
EMP13MO double 15,2 No No No
EMPSLPY double 15,2 No No No
EMPVLPY double 15,2 No No No
EMPLPAY double 15,2 No No No
EMPBONS double 15,2 No No No
EMPGPAY double 15,2 No No No
EMPBPAY double 15,2 No No No
EMPLNAM varchar 30 No No No
EMPFNAM varchar 30 No No No
EMPMNAM varchar 30 No No No
EMPCOCD varchar 1 No No No
EMPPCCD varchar 1 No No No
EMPLCCD varchar 3 No No No
EMPDPCD varchar 10 No No No
EMPFDSL double 15,2 No No No
EMPFDVL double 15,2 No No No
EMPSLRE double 15,2 No No No
EMPVLRE double 15,2 No No No
EMPESCD varchar 1 No No No
EMPPMCD varchar 1 No No No
EMPSTAT varchar 1 No No No
EMPPYNO varchar 10 No No No
EMPHDTE date 0 No No No
EMPCTAG varchar 1 No No No
EMPBKCD varchar 5 No No No

bsm_2016sppe

bsm_2016sppe
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
HSTNUMB Varchar 15 No No No
EMPNAME varchar 150 No No No
EMPCOCD varchar 1 No No No
HDTE date 0 No No No
ESCD varchar 1 No No No
TBASIC double 15,2 No No No
MMO double 15,2 No No No
13MO double 15,2 No No No
SL_PAY double 15,2 No No No
COMPNAME varchar 60 No No No
DEPT varchar 10 No No No
PCCD varchar 1 No No No
LOCA varchar 3 No No No
DEPTNAME varchar 60 No No No
EMPLNAM varchar 50 No No No
EMPFNAM double 50 No No No
EMPMNAM varchar 50 No No No
EMPPMCD varchar 1 No No No
EMPSTAT varchar 1 No No No
EMPBKCD varchar 5 No No No
EMPATMP varchar 25 No No No
SVLSLEN double 15,2 No No No
SLREM double 15,2 No No No
SVLVLEN double 15,2 No No No
VLREM double 15,2 No No No
DAILYTAG varchar 1 No No No

bsm2016

bsm2016
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
EMPNUMB Varchar 15 No No No
EMP13MO double 15,2 No No No
EMPSLPY double 15,2 No No No
EMPVLPY double 15,2 No No No
EMPLPAY double 15,2 No No No
EMPBONS double 15,2 No No No
EMPGPAY double 15,2 No No No
EMPBPAY double 15,2 No No No
EMPLNAM varchar 30 No No No
EMPFNAM varchar 30 No No No
EMPMNAM varchar 30 No No No
EMPCOCD varchar 1 No No No
EMPPCCD varchar 1 No No No
EMPLCCD varchar 3 No No No
EMPDPCD varchar 10 No No No
EMPFDSL double 15,2 No No No
EMPFDVL double 15,2 No No No
EMPSLRE double 15,2 No No No
EMPVLRE double 15,2 No No No
EMPESCD varchar 1 No No No
EMPPMCD varchar 1 No No No
EMPSTAT varchar 1 No No No
EMPPYNO varchar 10 No No No
EMPHDTE date 0 No No No
EMPCTAG varchar 1 No No No
EMPBKCD varchar 5 No No No

bsw2016

bsw2016
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
HSTNUMB varchar 15 No No No
EMPNAME varchar 150 No No No
EMPCOCD varchar 1 No No No
HDTE date 0 No No No
ESCD varchar 1 No No No
TBASIC double 15,2 No No No
MMO double 15,2 No No No
13MO double 15,2 No No No
SL_PAY double 15,2 No No No
COMPNAME varchar 60 No No No
DEPT varchar 10 No No No
PCCD varchar 1 No No No
LOCA varchar 3 No No No
DEPTNAME varchar 3 No No No
EMPLNAM varchar 50 No No No
EMPLNAM double 15,2 No No No
EMPFNAM varchar 50 No No No
EMPMNAM varchar 50 No No No
EMPPMCD varchar 1 No No No
EMPSTAT varchar 1 No No No
EMPBKCD varchar 5 No No No
EMPATMP varchar 25 No No No
SVLSLEN double 15,2 No No No
SLREM double 15,2 No No No
SVLVLEN double 15,2 No No No
VLREM double 15,2 No No No
DAILYTAG varchar 1 No No No

bsw_2016sppe

bsw_2016sppe
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
HSTNUMB varchar 15 No No No
EMPNAME varchar 150 No No No
EMPCOCD varchar 1 No No No
HDTE date 0 No No No
ESCD varchar 1 No No No
TBASIC double 15,2 No No No
MMO double 15,2 No No No
13MO double 15,2 No No No
SL_PAY double 15,2 No No No
COMPNAME varchar 60 No No No
DEPT varchar 10 No No No
PCCD varchar 1 No No No
LOCA varchar 3 No No No
DEPTNAME varchar 3 No No No
EMPLNAM varchar 50 No No No
EMPLNAM double 15,2 No No No
EMPFNAM varchar 50 No No No
EMPMNAM varchar 50 No No No
EMPPMCD varchar 1 No No No
EMPSTAT varchar 1 No No No
EMPBKCD varchar 5 No No No
EMPATMP varchar 25 No No No
SVLSLEN double 15,2 No No No
SLREM double 15,2 No No No
SVLVLEN double 15,2 No No No
VLREM double 15,2 No No No
DAILYTAG varchar 1 No No No

bwe2016

bwe2016
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
EMPNUMB varchar 15 No No No
EMP13MO double 15,2 No No No
EMPSLPY double 15,2 No No No
EMPVLPY double 15,2 No No No
EMPLPAY double 15,2 No No No
EMPBONS double 15,2 No No No
EMPGPAY double 15,2 No No No
EMPBPAY double 15,2 No No No
EMPLNAM varchar 30 No No No
EMPFNAM varchar 30 No No No
EMPMNAM varchar 30 No No No
EMPCOCD varchar 1 No No No
EMPPCCD varchar 1 No No No
EMPLCCD varchar 3 No No No
EMPDPCD varchar 10 No No No
EMPFDSL double 15,2 No No No
EMPFDVL double 15,2 No No No
EMPSLRE double 15,2 No No No
EMPVLRE double 15,2 No No No
EMPESCD varchar 1 No No No
EMPPMCD varchar 1 No No No
EMPSTAT varchar 1 No No No
EMPPYNO varchar 10 No No No
EMPHDTE date 0 No No No
EMPCTAG varchar 1 No No No
EMPBKCD varchar 5 No No No

ccback

ccback
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
mymodule varchar 20 No No No
myremark varchar 1 No No No
myuser varchar 10 No No No
mydate datetime 0 No No No

cm2016

cm2016
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
CWMNUMB Varchar 15 No No No
CWMDATE datetime 0 No No No
CWMFSTM varchar 4 No No No
CWMESTM varchar 4 No No No
CWMSTME varchar 4 No No No
CWMETME varchar 4 No No No
CWMATAG varchar 1 No No No
CWMSFCD varchar 2 No No No

cw2016

cw2016
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
CWMNUMB Varchar 15 No No No
CWMDATE datetime 0 No No No
CWMFSTM varchar 4 No No No
CWMESTM varchar 4 No No No
CWMSTME varchar 4 No No No
CWMETME varchar 4 No No No
CWMATAG varchar 1 No No No
CWMSFCD varchar 2 No No No

dt2016

dt2016
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
DTRNUMB varchar 15 No No No
DTRUSER varchar 10 No No No
DTRDATE datetime 0 No No No
DTRAMIN varchar 4 No No No
DTRAMOT varchar 4 No No No
DTRPMIN varchar 4 No No No
DTRPMOT varchar 4 No No No
DTR_AMI varchar 4 No No No
DTR_AMO varchar 4 No No No
DTR_PMI varchar 4 No No No
DTR_PMO varchar 4 No No No
DTRSFCD varchar 3 No No No

dtr_allow_entry_maintenance

dtr_allow_entry_maintenance
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
DTRAEMRCODE varchar 20 No No No
DTRAEMRDESC varchar 40 No No No

dtr2016

dtr2016
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
DTRCODE Varchar 3 No No No
EMPLNAM Varchar 30 No No No
DTRDATE Varchar 6 No No No
DTRTIME varchar 4 No No No
DTRTMP1 varchar 2 No No No
DTRSHFT varchar 1 No No No
DTRCRNO varchar 12 No No No
DTRREMK varchar 1 No No No
DTRDATETIME datetime 0 No No No

dtrallow2016

dtrallow2016
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
DTRAENUMB Varchar 15 No No No
DTRACDTE date 0 No No No
DTRADATE date 0 No No No
DTRARCODE varchar 25 No No No
DTRAOR varchar 100 No No No
DTRAUSER varchar 10 No No No
DTRAENCD datetime 0 No No No
DTRAFLAG varchar 1 No No No
DTRAABY varchar 10 No No No

dtt2016

dtt2016
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
recid int 30 Yes Yes Yes
DT_ENUMB Varchar 25 No No No
DT_WS_CODE Varchar 25 No No No
DT_DYCODE Varchar 25 No No No
DT_DYTYPE varchar 30 No No No
DT_LCCD Varchar 25 No No No
DT_DPCD Varchar 25 No No No
DT_COCD Varchar 25 No No No
DT_FPID Varchar 25 No No No
DT_PCCD Varchar 25 No No No
DT_TDPD Varchar 25 No No No
DT_DTETRX date 0 No No No
DT_SAMIN datetime 0 No No No
DT_SAMOUT datetime 0 No No No
DT_SPMIN datetime 0 No No No
DT_SPMOUT datetime 0 No No No
DT_GPERD double 15,2 No No No
DT_NSSTART datetime 0 No No No
DT_NSEND datetime 0 No No No
DT_AAMIN datetime 0 No No No
DT_AAMOUT datetime 0 No No No
DT_APMIN datetime 0 No No No
DT_APMOUT datetime 0 No No No
DT_ACBOUT datetime 0 No No No
DT_ACBIN datetime 0 No No No
DT_CBOUT datetime 0 No No No
DT_CBIN datetime 0 No No No
DT_CBLATES double 15,2 No No No
DT_AMIN datetime 0 No No No
DT_AMOUT datetime 0 No No No
DT_PMIN datetime 0 No No No
DT_PMOUT datetime 0 No No No
DT_AM_IN datetime 0 No No No
DT_AM_OUT datetime 0 No No No
DT_PM_IN datetime 0 No No No
DT_PM_OUT datetime 0 No No No
DT_VAMIN datetime 0 No No No
DT_VAMOUT datetime 0 No No No
DT_AMLATES double 15,2 No No No
DT_PMLATES double 15,2 No No No
DT_UNDERT double 15,2 No No No
DT_UTFILE double 15,2 No No No
DT_ATHRS double 15,2 No No No
DT_ABS double 15,2 No No No
DT_REQTHRS double 15,2 No No No
DT_NS_HRS double 15,2 No No No
DT_AM_NS_HRS double 15,2 No No No
DT_ROTAM double 15,2 No No No
DT_ROTPM double 15,2 No No No
DT_USER varchar 25 No No No
DT_DATEP datetime 0 No No No
DT_REMK varchar 25 No No No
DT_NDFLAG varchar 1 No No No
DT_COMPLETE varchar 1 No No No
DT_MHC_GRP varchar 1 No No No
DT_OTAM_PD double 15,2 No No No
DT_OTPM_PD double 15,2 No No No
DT_AMLATES_DED double 15,2 No No No
DT_UNDERT_DED double 15,2 No No No
DT_OTREG_PD double 15,2 No No No
DT_REG_HRS_PD double 15,2 No No No
DT_NS_HRS_PD double 15,2 No No No
DT_THRSWS double 15,2 No No No
DT_AMLATES_MIN double 15,2 No No No
DT_UNDERT_MIN double 15,2 No No No
DT_EMP_RDORG varchar 3 No No No
DT_EMP_RDORD varchar 3 No No No
DT_EMP_OTSUN varchar 1 No No No
DT_EMP_OTHOL varchar 1 No No No
DT_EMP_OTREG varchar 1 No No No
DT_PYTYPE varchar 1 No No No
DT_TXTYPE varchar 1 No No No
DT_ERATEC varchar 25 No No No
DT_NODYYR double 15,2 No No No
DT_NOHRDY double 15,2 No No No
DT_THRSWS_PD double 15,2 No No No
DT_CDTE date 0 No No No
DT_LV_CODE varchar 25 No No No
DT_LVP_DYS double 15,2 No No No
DT_LVP_HRS double 15,2 No No No
DT_CS varchar 25 No No No
DT_REGD_X8 double 15,2 No No No
DT_REGD_PHOL date 0 No No No
DT_REGD_PHOL_HRS_PD double 15,2 No No No
DT_CSHIFT varchar 1 No No No
DT_OT_IN datetime 0 No No No
DT_OT_OUT datetime 0 No No No
DT_OT_S datetime 0 No No No
DT_OT_E datetime 0 No No No
DT_WS_GPERD double 10,2 No No No
DT_AUTO_AMHDAY double 15,2 No No No
DT_AUTO_AMWDAY double 15,2 No No No
DT_MINS_MIN_OT double 15,2 No No No
DT_MFLAG_DAY varchar 1 No No No
DT_AUTO_PMHDAY double 15,2 No No No
DT_AUTO_PMWDAY double 15,2 No No No
DT_CB double 15,2 No No No

dw2016

dw2016
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
EMPNUMB Varchar 15 No No No
EMPLNAM Varchar 30 No No No
EMPFNAM Varchar 30 No No No
EMPMNAM varchar 30 No No No
EMPTINO varchar 30 No No No
EMPTXCD varchar 2 No No No
EMPTAXEXEM double 15,2 No No No
EMPHDTE date 0 No No No
SEPDATE date 0 No No No
EMPBDTE date 0 No No No
EMP13TH double 15,2 No No No
EMPSLPY double 15,2 No No No
EMPUNION double 15,2 No No No
EMPAMEDE double 15,2 No No No
EMPASSSE double 15,2 No No No
EMPAGROSS double 15,2 No No No
EMPAPIBE double 15,2 No No No
EMPATAXC double 15,2 No No No
Retrieved from "http://115.85.30.86:286/spgcwiki/index.php?title=Mypaydb&oldid=895"