Difference between revisions of "DB Specs"

From SPGC Document Wiki
Jump to: navigation, search
Line 1: Line 1:
−
== [[mypaydb|mypaydb]] ==
+
==alphalist_log==
 +
{| class="wikitable" \
 +
!colspan="7" | alphalist_log
 +
|-
 +
! 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
 +
|15,2
 +
|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
 +
|15,2
 +
|No
 +
|Yes
 +
|No
 +
|}

Revision as of 15:09, 23 June 2016

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 15,2 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 - 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 - 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 - EMP13THTAX double 15,2 No No No
MWE varchar 1 No No No
MWESAL double 19,2 No Yes No
_dateproc datetime 15,2 No Yes No
Retrieved from "http://115.85.30.86:286/spgcwiki/index.php?title=DB_Specs&oldid=834"