Mypmsdb
From SPGC Document Wiki
Contents
- 1 ahs2016
- 2 alphalist_log
- 3 auditlogs
- 4 bse2016
- 5 bsm2016
- 6 bsw_2016sppe
- 7 cm2016
- 8 cw2016
- 9 cws2016
- 10 dailymhr2016
- 11 dt2016
- 12 dtr2016
- 13 dtt2016
- 14 dw2016
- 15 emphold_alogs
- 16 fp_id
- 17 fpid
- 18 hst2016
- 19 ins2016
- 20 lns2016
- 21 lv2016
- 22 lvdt2016
- 23 lw2016
- 24 mbtc_cc
- 25 mbtc_log
- 26 mbtc_outc
- 27 mfileuploaded
- 28 mhr_2016
- 29 mhw2016
- 30 mst_attlogs
- 31 mst_cost_center
- 32 mst_cost_center_555
- 33 mst_ctr_no
- 34 mst_diocese
- 35 mst_educatt
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 | |
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 | |
| 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 | 1 | 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 | |
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 | |
cws2016
| cws2016 | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| CWSNUMB | varchar | 15 | No | No | No | |
| CWSDATE | datetime | 0 | No | No | No | |
| CWSFSTM | varchar | 4 | No | No | No | |
| CWSESTM | varchar | 4 | No | No | No | |
| CWSSTME | varchar | 4 | No | No | No | |
| CWSETME | varchar | 4 | No | No | No | |
| CWSATAG | varchar | 1 | No | No | No | |
| CWSSFCD | varchar | 3 | No | No | No | |
dailymhr2016
| dailymhr2016 | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| recid | int | 20 | Yes | Yes | Yes | |
| MHRNUMB | varchar | 25 | No | No | No | |
| MHRCDTE | date | 0 | No | No | No | |
| MHRDATE | date | 0 | No | No | No | |
| MHRTRDY | double | 15,2 | No | No | No | |
| MHRUTME | double | 15,2 | No | No | No | |
| MHRSLLV | double | 15,2 | No | No | No | |
| MHRVLLV | double | 15,2 | No | No | No | |
| MHRULOA | double | 15,2 | No | No | No | |
| MHROTHR | double | 15,2 | No | No | No | |
| MHRDAYS | double | 15,2 | No | No | No | |
| MHRCOCD | varchar | 25 | No | No | No | |
| MHRDPCD | varchar | 25 | No | No | No | |
| MHRDPCD_FLAG | varchar | 25 | No | No | No | |
| MHRRATEC | varchar | 25 | No | No | No | |
| MHRPYTYPE | varchar | 1 | No | No | No | |
| MHRTXTYPE | varchar | 50 | No | No | No | |
| MHRDEFDAYS | double | 15,2 | No | No | No | |
| MHRDEFMO | varchar | 2 | No | No | No | |
| MHRDEFCMO | varchar | 1 | No | No | No | |
| MHRDEFHRS | double | 15,2 | No | No | No | |
| MHRESCD | varchar | 1 | No | No | No | |
| MHRRRD1 | double | 15,2 | No | No | No | |
| MHRRRO1 | double | 15,2 | No | No | No | |
| MHRNRD1 | double | 15,2 | No | No | No | |
| MHRNRO1 | double | 15,2 | No | No | No | |
| MHRRRD2 | double | 15,2 | No | No | No | |
| MHRRRO2 | double | 15,2 | No | No | No | |
| MHRNRO2 | double | 15,2 | No | No | No | |
| MHRRSD1 | double | 15,2 | No | No | No | |
| MHRRSO1 | double | 15,2 | No | No | No | |
| MHRNSD1 | double | 15,2 | No | No | No | |
| MHRRSD2 | double | 15,2 | No | No | No | |
| MHRRSO2 | double | 15,2 | No | No | No | |
| MHRNSO1 | double | 15,2 | No | No | No | |
| MHRNSD2 | double | 15,2 | No | No | No | |
| MHRNSO2 | double | 15,2 | No | No | No | |
| MHRRLD1 | double | 15,2 | No | No | No | |
| MHRRLO1 | double | 15,2 | No | No | No | |
| MHRNLD1 | double | 15,2 | No | No | No | |
| MHRRLD2 | double | 15,2 | No | No | No | |
| MHRRLO2 | double | 15,2 | No | No | No | |
| MHRNLO1 | double | 15,2 | No | No | No | |
| MHRNLD2 | double | 15,2 | No | No | No | |
| MHRNLO2 | double | 15,2 | No | No | No | |
| MHRNRD2 | double | 15,2 | No | No | No | |
| MHRLHOL | double | 15,2 | No | No | No | |
| MHRSHOL | double | 15,2 | No | No | No | |
| MHRTHOL | double | 15,2 | No | No | No | |
| MHRRLEG | double | 15,2 | No | No | No | |
| MHRRSPC | double | 15,2 | No | No | No | |
| MHRFPER | varchar | 1 | No | No | No | |
| MHRADSL | double | 15,2 | No | No | No | |
| MHRADVL | double | 15,2 | No | No | No | |
| MHRDDSL | double | 15,2 | No | No | No | |
| MHRDDVL | double | 15,2 | No | No | No | |
| MHRADFL | double | 15,2 | No | No | No | |
| MHRSPLLV | double | 15,2 | No | No | No | |
| MHRLCCD | varchar | 25 | No | No | No | |
| MHRTDPD | varchar | 25 | 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 | |
dtr2016
| dtr2016 | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| DTRCODE | varchar | 3 | 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 | |
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 | 3 | No | No | No | |
| DT_DYTYPE | varchar | 25 | 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_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_VPMIN | datetime | 0 | No | No | No | |
| DT_VPMOUT | 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_FLAG | 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 | |
| DTWNUMB | varchar | 15 | No | No | No | |
| DTWUSER | varchar | 8 | No | No | No | |
| DTWDATE | datetime | 0 | No | No | No | |
| DTWAMIN | varchar | 4 | No | No | No | |
| DTWAMOT | varchar | 4 | No | No | No | |
| DTWPMIN | varchar | 4 | No | No | No | |
| DTWPMOT | varchar | 4 | No | No | No | |
| DTW_AMI | varchar | 4 | No | No | No | |
| DTW_AMO | varchar | 4 | No | No | No | |
| DTW_PMI | varchar | 4 | No | No | No | |
| DTW_PMO | varchar | 4 | No | No | No | |
| DTWSFCD | varchar | 2 | No | No | No | |
emphold_alogs
| emphold_alogs | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| EMPNUMB | varchar | 15 | No | Yes | No | |
| HOLDRSN | varchar | 200 | No | Yes | No | |
| USERNAME | varchar | 20 | No | Yes | No | |
| TMPSTMP | datetime | 0 | No | Yes | No | |
fp_id
| fp_id | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| recid | int | 20 | Yes | Yes | Yes | |
| FPIDENUMB | varchar | 25 | No | No | No | |
| FPID | varchar | 25 | No | No | No | |
| FPLCCD | varchar | 25 | No | No | No | |
fpid
| fpid | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| FPENUMB | varchar | 15 | Yes | Yes | Yes | |
| FPID | varchar | 12 | No | No | No | |
| FPREMK | varchar | 1 | No | No | No | |
hst2016
| hst2016 | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| HSTNUMB | varchar | 15 | Yes | Yes | Yes | |
| HSTCDTE | datetime | 0 | No | No | No | |
| HSTMPAY | double | 15,2 | No | No | No | |
| HSTMALL | double | 15,2 | No | No | No | |
| HSTBPAY | double | 15,2 | No | No | No | |
| HSTBALL | double | 15,2 | No | No | No | |
| HSTGPAY | double | 15,2 | No | No | No | |
| HSTSSSR | double | 15,2 | No | No | No | |
| HSTSSSE | double | 15,2 | No | No | No | |
| HSTTAXC | double | 15,2 | No | No | No | |
| HSTECCM | double | 15,2 | No | No | No | |
| HSTPIBE | double | 15,2 | No | No | No | |
| HSTPIBR | double | 15,2 | No | No | No | |
| HSTMEDE | double | 15,2 | No | No | No | |
| HSTMEDR | double | 15,2 | No | No | No | |
| HSTTDED | double | 15,2 | No | No | No | |
| HSTADON | double | 15,2 | No | No | No | |
| HSTNSPY | double | 15,2 | No | No | No | |
| HSTOTNS | double | 15,2 | No | No | No | |
| HSTOTPY | double | 15,2 | No | No | No | |
| HSTSLPY | double | 15,2 | No | No | No | |
| HSTVLPY | double | 15,2 | No | No | No | |
| HSTDOPY | double | 15,2 | No | No | No | |
| HSTLHPY | double | 15,2 | No | No | No | |
| HSTSHPY | double | 15,2 | No | No | No | |
| HSTCOFF | varchar | 3 | No | No | No | |
| HSTCOCD | varchar | 1 | No | No | No | |
| HSTPCCD | varchar | 1 | No | No | No | |
| HSTHOLD | varchar | 1 | No | No | No | |
| HSTPYNO | varchar | 9 | No | No | No | |
| HSTDPCD | varchar | 10 | No | No | No | |
| HSTLCCD | varchar | 3 | No | No | No | |
| HSTPMCD | varchar | 1 | No | No | No | |
| HSTPSNO | varchar | 1 | No | No | No | |
| HSTBKCD | varchar | 5 | No | No | No | |
| HSTESCD | varchar | 1 | No | No | No | |
| HSTFLPY | double | 15,2 | No | No | No | |
| HSTTDPD | varchar | 1 | No | No | No | |
ins2016
| ins2016 | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| INSNUMB | varchar | 15 | Yes | Yes | Yes | |
| INSYEAR | varchar | 4 | No | No | No | |
| INSMNTH | varchar | 2 | No | No | No | |
| INSAMNT | double | 15,2 | No | No | No | |
lns2016
| lns2016 | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| recid | int | 25 | No | Yes | Yes | |
| LNSNUMB | varchar | 15 | No | No | No | |
| LNSSDCD | varchar | 3 | No | No | No | |
| LNSDATE | datetime | 0 | No | No | No | |
| LNSDDTE | datetime | 0 | No | No | No | |
| LNSAMNT | double | 15,2 | No | No | No | |
| LNSBALC | double | 15,2 | No | No | No | |
| LNSUNPD | double | 15,2 | No | No | No | |
lv2016
| lv2016 | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| LOANUMB | varchar | 15 | No | Yes | Yes | |
| LOADATE | datetime | 0 | No | No | No | |
| LOAOPTN | varchar | 1 | No | No | No | |
| LOACODE | varchar | 1 | No | No | No | |
| LOAHOUR | double | 15,5 | No | No | No | |
| LOAHRPD | double | 15,5 | No | No | No | |
| LOAASTA | tinyint | 1 | No | Yes | No | |
| LOACOFF | date | 0 | No | No | No | |
lvdt2016
| lvdt2016 | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| recid | int | 30 | Yes | Yes | Yes | |
| LV_ENUMB | varchar | 25 | No | No | No | |
| LV_WS_CODE | varchar | 25 | No | No | No | |
| LV_DYCODE | varchar | 3 | No | No | No | |
| LV_DYTYPE | varchar | 30 | No | No | No | |
| EMPTXCD | varchar | 25 | No | No | No | |
| LV_LCCD | varchar | 25 | No | No | No | |
| LV_DPCD | varchar | 25 | No | No | No | |
| LV_COCD | varchar | 25 | No | No | No | |
| LV_CDTE | date | 0 | No | No | No | |
| LV_DTETRX | date | 0 | No | No | No | |
| LV_SAMIN | datetime | 0 | No | No | No | |
| LV_SAMOUT | datetime | 0 | No | No | No | |
| LV_SPMIN | datetime | 0 | No | No | No | |
| LV_SPMOUT | datetime | 0 | No | No | No | |
| LV_TYPE | varchar | 25 | No | No | No | |
| LV_OPTN | varchar | 25 | No | No | No | |
| LV_APHRS | double | 15,2 | No | No | No | |
| LV_PDHRS | double | 15,2 | No | No | No | |
| LV_USER | varchar | 25 | No | No | No | |
| LV_ENCD | datetime | 0 | No | No | No | |
| LV_APP | varchar | 1 | No | No | No | |
| LV_REMK | longtext | 0 | No | No | No | |
| LV_FLAG | varchar | 1 | No | No | No | |
lw2016
| lw2016 | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| LOWNUMB | varchar | 15 | No | No | No | |
| LOWDATE | datetime | 0 | No | No | No | |
| LOWOPTN | varchar | 1 | No | No | No | |
| LOWCODE | varchar | 1 | No | No | No | |
| LOWHOUR | double | 15,2 | No | No | No | |
| LOWHRPD | double | 15,2 | No | No | No | |
| LOWASTA | tinyint | 1 | No | No | No | |
mbtc_cc
| mbtc_cc | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| recid | int | 25 | No | Yes | Yes | |
| cc_cocd | varchar | 4 | No | No | No | |
| cc_cardno | varchar | 20 | No | No | No | |
| cc_desc | varchar | 50 | No | No | No | |
| cc_accno | varchar | 20 | No | No | No | |
| cc_dbank | varchar | 5 | No | No | No | |
| cc_bankc | varchar | 5 | No | No | No | |
| cc_dup | date | 0 | No | No | No | |
| cc_release | varchar | 1 | No | No | No | |
| cc_drelease | date | 0 | No | No | No | |
| cc_tag | varchar | 1 | No | No | No | |
| cc_dtag | date | 0 | No | No | No | |
| cc_active | varchar | 1 | No | No | No | |
| cc_bankn | varchar | 25 | No | No | No | |
| cc_pmcd | varchar | 1 | No | No | No | |
mbtc_log
| mbtc_log | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| cc_enumb | varchar | 15 | No | No | No | |
| cc_cardno | varchar | 20 | No | No | No | |
| cc_desc | varchar | 50 | No | No | No | |
| cc_accno | varchar | 20 | No | No | No | |
| cc_encdt | datetime | 0 | No | No | No | |
| cc_user | varchar | 10 | No | No | No | |
| cc_cocd | varchar | 4 | No | No | No | |
mbtc_outc
| mbtc_outc | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| cc_outcg | varchar | 10 | No | No | No | |
| cc_accno | varchar | 20 | No | No | No | |
| cc_cocd | varchar | 4 | No | No | No | |
| cc_print | varchar | 1 | No | No | No | |
| cc_bankn | varchar | 25 | No | No | No | |
mfileuploaded
| mfileuploaded | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| recid | int | 20 | Yes | Yes | Yes | |
| mfile | varchar | 50 | No | No | No | |
| mcontent | longtext | 0 | No | No | No | |
| mdateuploaded | datetime | 0 | No | No | No | |
mhr_2016
| mhr_2016 | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| recid | int | 20 | Yes | Yes | Yes | |
| MHRNUMB | varchar | 25 | No | No | No | |
| MHRCDTE | date | 0 | No | No | No | |
| MHRTRDY | double | 15,2 | No | No | No | |
| MHRUTME | double | 15,2 | No | No | No | |
| MHRSLLV | double | 15,2 | No | No | No | |
| MHRVLLV | double | 15,2 | No | No | No | |
| MHRULOA | double | 15,2 | No | No | No | |
| MHRWOLV | double | 15,2 | No | No | No | |
| MHRDLOA | double | 15,2 | No | No | No | |
| MHROTHR | double | 15,2 | No | No | No | |
| MHRDAYS | double | 15,2 | No | No | No | |
| MHRCOCD | varchar | 25 | No | No | No | |
| MHRDPCD | varchar | 25 | No | No | No | |
| MHRDPCD_FLAG | varchar | 25 | No | No | No | |
| MHRRATEC | varchar | 25 | No | No | No | |
| MHRPYTYPE | varchar | 1 | No | No | No | |
| MHRTXTYPE | varchar | 1 | No | No | No | |
| MHRDEFDAYS | double | 15,2 | No | No | No | |
| MHRDEFMO | varchar | 2 | No | No | No | |
| MHRDEFCMO | varchar | 1 | No | No | No | |
| MHRDEFHRS | double | 15,2 | No | No | No | |
| MHRESCD | varchar | 1 | No | No | No | |
| MHRRRD1 | double | 15,2 | No | No | No | |
| MHRRRO1 | double | 15,2 | No | No | No | |
| MHRNRD1 | double | 15,2 | No | No | No | |
| MHRNRO1 | double | 15,2 | No | No | No | |
| MHRRRD2 | double | 15,2 | No | No | No | |
| MHRRRO2 | double | 15,2 | No | No | No | |
| MHRNRO2 | double | 15,2 | No | No | No | |
| MHRRSD1 | double | 15,2 | No | No | No | |
| MHRRSO1 | double | 15,2 | No | No | No | |
| MHRNSD1 | double | 15,2 | No | No | No | |
| MHRRSD2 | double | 15,2 | No | No | No | |
| MHRRSO2 | double | 15,2 | No | No | No | |
| MHRNSO1 | double | 15,2 | No | No | No | |
| MHRNSD2 | double | 15,2 | No | No | No | |
| MHRNSO2 | double | 15,2 | No | No | No | |
| MHRRLD1 | double | 15,2 | No | No | No | |
| MHRRLO1 | double | 15,2 | No | No | No | |
| MHRNLD1 | double | 15,2 | No | No | No | |
| MHRRLD2 | double | 15,2 | No | No | No | |
| MHRRLO2 | double | 15,2 | No | No | No | |
| MHRNLO1 | double | 15,2 | No | No | No | |
| MHRNLD2 | double | 15,2 | No | No | No | |
| MHRNLO2 | double | 15,2 | No | No | No | |
| MHRNRD2 | double | 15,2 | No | No | No | |
| MHRLHOL | double | 15,2 | No | No | No | |
| MHRSHOL | double | 15,2 | No | No | No | |
| MHRTHOL | double | 15,2 | No | No | No | |
| MHRRLEG | double | 15,2 | No | No | No | |
| MHRRSPC | double | 15,2 | No | No | No | |
| MHRFPER | varchar | 1 | No | No | No | |
| MHRADSL | double | 15,2 | No | No | No | |
| MHRADVL | double | 15,2 | No | No | No | |
| MHRDDSL | double | 15,2 | No | No | No | |
| MHRDDVL | double | 15,2 | No | No | No | |
| MHRADFL | double | 15,2 | No | No | No | |
| MHRSPLLV | double | 15,2 | No | No | No | |
| MHRLCCD | varchar | 25 | No | No | No | |
| MHRTDPD | varchar | 25 | No | No | No | |
mhw2016
| mhw2016 | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| MHWNUMB | varchar | 15 | No | No | No | |
| MHWCDTE | datetime | 0 | No | No | No | |
| MHWTRDY | double | 15,2 | No | No | No | |
| MHWUTME | double | 15,2 | No | No | No | |
| MHWSLLV | double | 15,2 | No | No | No | |
| MHWVLLV | double | 15,2 | No | No | No | |
| MHWULOA | double | 15,2 | No | No | No | |
| MHWWOLV | double | 15,2 | No | No | No | |
| MHWDLOA | double | 15,2 | No | No | No | |
| MHWOTHR | double | 15,2 | No | No | No | |
| MHWDAYS | double | 15,2 | No | No | No | |
| MHWESCD | varchar | 1 | No | No | No | |
| MHWRRD1 | double | 15,2 | No | No | No | |
| MHWRRO1 | double | 15,2 | No | No | No | |
| MHWNRD1 | double | 15,2 | No | No | No | |
| MHWNRO1 | double | 15,2 | No | No | No | |
| MHWRRD2 | double | 15,2 | No | No | No | |
| MHWRRO2 | double | 15,2 | No | No | No | |
| MHWNRO2 | double | 15,2 | No | No | No | |
| MHWRSD1 | varchar | 2 | No | No | No | |
| MHWRSO1 | varchar | 1 | No | No | No | |
| MHWRSD2 | double | 15,2 | No | No | No | |
| MHWRSO2 | varchar | 1 | No | No | No | |
| MHWNSO1 | double | 15,2 | No | No | No | |
| MHWNSD2 | double | 15,2 | No | No | No | |
| MHWNSO2 | double | 15,2 | No | No | No | |
| MHWRLD1 | double | 15,2 | No | No | No | |
| MHWRLO1 | double | 15,2 | No | No | No | |
| MHWNLD1 | double | 15,2 | No | No | No | |
| MHWRLD2 | double | 15,2 | No | No | No | |
| MHWRLO2 | double | 15,2 | No | No | No | |
| MHWNLO1 | double | 15,2 | No | No | No | |
| MHWNLD2 | double | 15,2 | No | No | No | |
| MHWNLO2 | double | 15,2 | No | No | No | |
| MHWNRD2 | double | 15,2 | No | No | No | |
| MHWLHOL | double | 15,2 | No | No | No | |
| MHWSHOL | double | 15,2 | No | No | No | |
| MHWTHOL | double | 15,2 | No | No | No | |
| MHWRLEG | double | 15,2 | No | No | No | |
| MHWRSPC | double | 15,2 | No | No | No | |
| MHWFPER | varchar | 1 | No | No | No | |
| MHWADSL | double | 15,2 | No | No | No | |
| MHWADVL | double | 15,2 | No | No | No | |
| MHWDDSL | double | 15,2 | No | No | No | |
| MHWDDVL | double | 15,2 | No | No | No | |
| MHWADFL | double | 15,2 | No | No | No | |
mst_attlogs
| mst_attlogs | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| recid | int | 30 | Yes | Yes | Yes | |
| FP_ID | varchar | 25 | No | No | No | |
| FP_TRXDATE | datetime | 0 | No | No | No | |
| FP_SITE | varchar | 25 | No | No | No | |
| MYF3 | varchar | 1 | No | No | No | |
| MYF5 | varchar | 1 | No | No | No | |
| MYF6 | varchar | 1 | No | No | No | |
| FP_IDNO | varchar | 25 | No | No | No | |
| FP_EMPNAME | varchar | 200 | No | No | No | |
| FP_DPCD | varchar | 25 | No | No | No | |
| FP_COCD | varchar | 25 | No | No | No | |
| FP_LCCD | varchar | 25 | No | No | No | |
| FP_USER | varchar | 25 | No | No | No | |
| FP_DTEUP | datetime | 0 | No | No | No | |
mst_cost_center
| mst_cost_center | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| recid | int | 25 | Yes | Yes | Yes | |
| COCD | varchar | 25 | No | No | No | |
| NEW_DPCD | varchar | 25 | No | No | No | |
| NEW_DESC | varchar | 100 | No | No | No | |
| BUS_CENTER | varchar | 25 | No | No | No | |
| OLD_DPCD | varchar | 25 | No | No | No | |
| OLD_DESC | varchar | 100 | No | No | No | |
mst_cost_center_555
| mst_cost_center_555 | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| recid | int | 25 | Yes | Yes | Yes | |
| Controlling_Area | varchar | 25 | No | No | No | |
| Cost_Center_Code_888 | varchar | 25 | No | No | No | |
| Cost_Center_Code_555 | varchar | 25 | No | No | No | |
| Cost_Center_Name | varchar | 100 | No | No | No | |
| Person_Responsible | varchar | 150 | No | No | No | |
| Profit_Center | varchar | 25 | No | No | No | |
| Department_new | varchar | 100 | No | No | No | |
mst_ctr_no
| mst_ctr_no | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| ctr_no | varchar | 15 | No | No | No | |
| ctr_err_no | varchar | 15 | No | No | No | |
| ctr_no_year | varchar | 4 | No | No | No | |
mst_diocese
| mst_diocese | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| recid | int | 25 | Yes | Yes | Yes | |
| DS_CODE | varchar | 25 | No | No | No | |
| DS_NAME | varchar | 100 | No | No | No | |
mst_educatt
| mst_educatt | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| recid | int | 25 | Yes | Yes | Yes | |
| EA_CODE | varchar | 25 | No | No | No | |
| EA_DESC | varchar | 100 | No | No | No | |
