Mypmsdb
From SPGC Document Wiki
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 | |
bsw_2016sppe
| bsw_2016sppe | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| HSTNUMB | 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 | |
