Difference between revisions of "Mypmsdb"

From SPGC Document Wiki
Jump to: navigation, search
(→‎bsm2016)
(→‎bsm2016)
Line 840: Line 840:
 
! Auto Increment
 
! Auto Increment
 
|-
 
|-
−
|HSTNUMB
+
|EMPNUMB
 
|varchar
 
|varchar
 
|15
 
|15
Line 847: Line 847:
 
|No
 
|No
 
|-
 
|-
−
|EMPNAME
+
|EMP13MO
−
|varchar
+
|double
−
|150
+
|15,2
 
|No
 
|No
 
|No
 
|No
 
|No
 
|No
 
|-
 
|-
−
|EMPCOCD
+
|EMPSLPY
−
|varchar
+
|double
−
|1
+
|15,2
 
|No
 
|No
 
|No
 
|No
 
|No
 
|No
 
|-
 
|-
−
|HDTE
+
|EMPVLPY
−
|date
+
|double
−
|0
+
|15,2
 
|No
 
|No
 
|No
 
|No
 
|No
 
|No
 
|-
 
|-
−
|ESCD
+
|EMPLPAY
−
|varchar
+
|double
−
|1
+
|15,2
 
|No
 
|No
 
|No
 
|No
 
|No
 
|No
 
|-
 
|-
−
|TBASIC
+
|EMPBONS
 
|double
 
|double
 
|15,2
 
|15,2
Line 882: Line 882:
 
|No
 
|No
 
|-
 
|-
−
|MMO
+
|EMPGPAY
 
|double
 
|double
 
|15,2
 
|15,2
Line 889: Line 889:
 
|No
 
|No
 
|-
 
|-
−
|13MO
+
|EMPBPAY
 
|double
 
|double
 
|15,2
 
|15,2
Line 896: Line 896:
 
|No
 
|No
 
|-
 
|-
−
|SL_PAY
+
|EMPLNAM
−
|double
+
|varchar
−
|15,2
+
|30
 
|No
 
|No
 
|No
 
|No
 
|No
 
|No
 
|-
 
|-
−
|COMPNAME
+
|EMPFNAM
 
|varchar
 
|varchar
−
|60
+
|30
 
|No
 
|No
 
|No
 
|No
 
|No
 
|No
 
|-
 
|-
−
|DEPT
+
|EMPMNAM
 
|varchar
 
|varchar
−
|10
+
|30
 
|No
 
|No
 
|No
 
|No
 
|No
 
|No
 
|-
 
|-
−
|PCCD
+
|EMPCOCD
 
|varchar
 
|varchar
 
|1
 
|1
Line 924: Line 924:
 
|No
 
|No
 
|-
 
|-
−
|LOCA
+
|EMPPCCD
 
|varchar
 
|varchar
−
|3
+
|1
 
|No
 
|No
 
|No
 
|No
 
|No
 
|No
 
|-
 
|-
−
|DEPTNAME
+
|EMPLCCD
 
|varchar
 
|varchar
−
|60
+
|3
 
|No
 
|No
 
|No
 
|No
 
|No
 
|No
 
|-
 
|-
−
|EMPLNAM
+
|EMPDPCD
 
|varchar
 
|varchar
−
|50
+
|10
 
|No
 
|No
 
|No
 
|No
 
|No
 
|No
 
|-
 
|-
−
|EMPFNAM
+
|EMPFDSL
−
|varchar
+
|double
−
|50
+
|15,2
 
|No
 
|No
 
|No
 
|No
 
|No
 
|No
 
|-
 
|-
−
|EMPMNAM
+
|EMPFDVL
−
|varchar
+
|double
−
|50
+
|15,2
 
|No
 
|No
 
|No
 
|No
 
|No
 
|No
 
|-
 
|-
−
|EMPPMCD
+
|EMPSLRE
−
|varchar
+
|double
−
|1
+
|15,2
 
|No
 
|No
 
|No
 
|No
 
|No
 
|No
 
|-
 
|-
−
|EMPSTAT
+
|EMPVLRE
−
|varchar
+
|double
−
|1
+
|15,2
 
|No
 
|No
 
|No
 
|No
 
|No
 
|No
 
|-
 
|-
−
|EMPBKCD
+
|EMPESCD
 
|varchar
 
|varchar
−
|5
+
|1
 
|No
 
|No
 
|No
 
|No
 
|No
 
|No
 
|-
 
|-
−
|EMPATMP
+
|EMPPMCD
 
|varchar
 
|varchar
−
|25
+
|1
 
|No
 
|No
 
|No
 
|No
 
|No
 
|No
 
|-
 
|-
−
|SVLSLEN
+
|EMPSTAT
−
|double
+
|varchar
−
|15,2
+
|1
 
|No
 
|No
 
|No
 
|No
 
|No
 
|No
 
|-
 
|-
−
|SLREM
+
|EMPPYNO
−
|double
+
|varchar
−
|15,2
+
|10
 
|No
 
|No
 
|No
 
|No
 
|No
 
|No
 
|-
 
|-
−
|SVLVLEN
+
|EMPHDTE
−
|double
+
|date
−
|15,2
+
|0
 
|No
 
|No
 
|No
 
|No
 
|No
 
|No
 
|-
 
|-
−
|VLREM
+
|EMPCTAG
−
|double
+
|varchar
−
|15,2
+
|1
 
|No
 
|No
 
|No
 
|No
 
|No
 
|No
 
|-
 
|-
−
|DAILYTAG
+
|EMPBKCD
 
|varchar
 
|varchar
−
|1
+
|5
 
|No
 
|No
 
|No
 
|No
 
|No
 
|No
 
|}
 
|}

Revision as of 10:44, 29 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
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

auditlogs

auditlogs
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
LOG_USER varchar 10 No No No
LOG_MODULE varchar 20 No No No
LOG_DATE date 0 No No No
LOG_TBL varchar 20 No No No
LOG_KEYREC varchar 10 No No No
LOG_TIME varchar 10 No No No
LOG_ENUMB varchar 15 No No No
LOG_FIELD varchar 20 No No No
LOG_OLDVAL varchar 30 No No No
LOG_NEWVAL varchar 30 No No No
LOG_CHANGE varchar 1 No No No
LOG_IPADDR varchar 20 No No No
LOG_PRNT varchar 1 No No No
LOG_SQLEXEC longtext 0 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 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

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
Retrieved from "http://115.85.30.86:286/spgcwiki/index.php?title=Mypmsdb&oldid=1110"