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_gl_555
- 36 mst_mission
- 37 mst_educatt
- 38 mst_nationality
- 39 mst_relivows
- 40 my_ctr_no
- 41 mybpibadv
- 42 ob2016
- 43 obtp2016
- 44 ok2016
- 45 ot2016
- 46 otdt2016
- 47 otpay2016
- 48 ow2016
- 49 pdm_essi2016
- 50 pdm_sppe2016
- 51 pdm2016
- 52 pdw_sppe2016
- 53 pdw2016
- 54 pmhempl
- 55 pmmcmpy
- 56 pmmacin
- 57 pmmbene
- 58 pmmcsta
- 59 pmmctzp
- 60 pmmdept
- 61 pmmicls
- 62 pmmjblv
- 63 pmmlnge
- 64 pmmloca
- 65 pmmmach
- 66 pmmmart
- 67 pmmpact
- 68 pmmposn
- 69 pmmrltp
- 70 pmmsect
- 71 pmmshf2
- 72 pmmshfv
- 73 pmmskll
- 74 pmmtaxt
- 75 pmt_ctr_no
- 76 pmtatmp
- 77 pmtchdf
- 78 pmtchrr
- 79 pmtcmdn
- 80 pmtdpdt
- 81 pmtdrvl
- 82 pmteduc
- 83 pmtemp_illness
- 84 pmtemp_reference
- 85 pmtempchildren
- 86 pmtempdependent
- 87 pmtempchildren
- 88 pmtempedu
- 89 pmtempfamily
- 90 pmtempgovexam
- 91 pmtempl
- 92 pmtempl_creation
- 93 pmtempl_deminimis
- 94 pmtempl_txcd2016
- 95 pmtemptraining
- 96 pmtempmachine
- 97 pmtemprelative
- 98 pmtempskills
- 99 pmtemptraining
- 100 pmtemve
- 101 pmtfamy
- 102 pmtfixm
- 103 pmtfrrl
- 104 pmtgvte
- 105 pmtilln
- 106 pmtvip2
- 107 pmtlgef
- 108 pmtmarr
- 109 pmtmchd
- 110 pmtmwee
- 111 pmtnoti
- 112 pmtntph
- 113 pmtprem
- 114 pmtprem
- 115 pmtprevemployer
- 116 pmtprsn_notify
- 117 pmtsemr
- 118 pmtsepa
- 119 pmtsepa_comp
- 120 pmtskhb
- 121 pmtmwee
- 122 pp2016
- 123 profile_perinfo
- 124 pvf2016
- 125 pym_holi
- 126 pymacct
- 127 pymbank
- 128 pymbran
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_gl_555
| mst_gl_555 | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| recid | int | 25 | Yes | Yes | Yes | |
| COA | varchar | 25 | No | No | No | |
| GL_888 | varchar | 25 | No | No | No | |
| GL_555 | varchar | 25 | No | No | No | |
| Name | varchar | 100 | No | No | No | |
| Account_group | varchar | 25 | No | No | No | |
mst_mission
| mst_mission | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| recid | int | 25 | Yes | Yes | Yes | |
| MS_CODE | varchar | 25 | No | No | No | |
| MS_DESC | varchar | 100 | No | No | No | |
| MS_FDESC | longtext | 0 | 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 | |
mst_nationality
| mst_nationality | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| recid | int | 25 | Yes | Yes | Yes | |
| NT_CODE | varchar | 25 | No | No | No | |
| NT_DESC | varchar | 50 | No | No | No | |
mst_relivows
| mst_relivows | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| recid | int | 25 | Yes | Yes | Yes | |
| RV_CODE | varchar | 25 | No | No | No | |
| RV_DESC | varchar | 100 | No | No | No | |
my_ctr_no
| my_ctr_no | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| pvrecid | int | 20 | Yes | Yes | Yes | |
| myyear | varchar | 4 | No | No | No | |
mybpibadv
| mst_cost_center_555 | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| recid | int | 1 | Yes | Yes | Yes | |
| atmno | varchar | 10 | No | No | No | |
| ddate | date | 0 | No | No | No | |
| dudate | date | 0 | No | No | No | |
| amount | double | 12,2 | No | No | No | |
| empname | varchar | 30 | No | No | No | |
| date_upld | datetime | 0 | No | No | No | |
| user | varchar | 15 | No | No | No | |
| company | varchar | 1 | No | No | No | |
ob2016
| ob2016 | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| OBTNUMB | varchar | 8 | Yes | Yes | Yes | |
| OBTDATE | datetime | 0 | No | No | No | |
| OBTDTME | varchar | 4 | No | No | No | |
| OBTATME | varchar | 4 | No | No | No | |
obtp2016
| obtp2016 | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| recid | int | 30 | Yes | Yes | Yes | |
| OB_ENUMB | varchar | 25 | No | No | No | |
| OB_WS_CODE | varchar | 25 | No | No | No | |
| OB_DYCODE | varchar | 3 | No | No | No | |
| OB_DYTYPE | varchar | 25 | No | No | No | |
| OB_LCCD | varchar | 25 | No | No | No | |
| OB_DPCD | varchar | 25 | No | No | No | |
| OB_COCD | varchar | 25 | No | No | No | |
| OB_CDTE | date | 0 | No | No | No | |
| OB_DTETRX | date | 0 | No | No | No | |
| OB_SAMIN | datetime | 0 | No | No | No | |
| OB_SAMOUT | datetime | 0 | No | No | No | |
| OB_SPMIN | datetime | 0 | No | No | No | |
| OB_SPMOUT | datetime | 0 | No | No | No | |
| OB_ATIME | datetime | 0 | No | No | No | |
| OB_DTIME | datetime | 0 | No | No | No | |
| OB_USER | varchar | 25 | No | No | No | |
| OB_ENCD | datetime | 0 | No | No | No | |
| OB_REMK | longtext | 0 | No | No | No | |
| OB_FLAG | varchar | 1 | No | No | No | |
ok2016
| ok2016 | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| OTWNUMB | varchar | 15 | No | No | No | |
| OTWDATE | datetime | 0 | No | No | No | |
| OTWFTME | varchar | 4 | No | No | No | |
| OTWTTME | varchar | 4 | No | No | No | |
ot2016
| ot2016 | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| OTMNUMB | varchar | 15 | No | No | No | |
| OTMDATE | datetime | 0 | No | No | No | |
| OTMFTME | varchar | 4 | No | No | No | |
| OTMTTME | varchar | 4 | No | No | No | |
otdt2016
| otdt2016 | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| recid | int | 30 | Yes | Yes | Yes | |
| OT_ENUMB | varchar | 25 | No | No | No | |
| OT_WS_CODE | varchar | 25 | No | No | No | |
| OT_DYCODE | varchar | 3 | No | No | No | |
| OT_DYTYPE | varchar | 25 | No | No | No | |
| OT_LCCD | varchar | 25 | No | No | No | |
| OT_DPCD | varchar | 25 | No | No | No | |
| OT_COCD | varchar | 25 | No | No | No | |
| OT_CDTE | date | 0 | No | No | No | |
| OT_DTETRX | date | 0 | No | No | No | |
| OT_SAMIN | datetime | 0 | No | No | No | |
| OT_SAMOUT | datetime | 0 | No | No | No | |
| OT_SPMIN | datetime | 0 | No | No | No | |
| OT_SPMOUT | datetime | 0 | No | No | No | |
| OT_STIME | datetime | 0 | No | No | No | |
| OT_ETIME | datetime | 0 | No | No | No | |
| OT_USER | varchar | 25 | No | No | No | |
| OT_ENCD | datetime | 0 | No | No | No | |
| OT_REMK | longtext | 0 | No | No | No | |
| OT_FLAG | varchar | 1 | No | No | No | |
otpay2016
| otpay2016 | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| recid | int | 25 | Yes | Yes | Yes | |
| OTP_EMPNUMB | varchar | 25 | No | No | No | |
| OTP_CDTE | date | 0 | No | No | No | |
| OTP_TFDATE | date | 0 | No | No | No | |
| OTP_TTDATE | date | 0 | No | No | No | |
| OTP_HRS | double | 10,2 | No | No | No | |
| OTP_MNS | double | 10,2 | No | No | No | |
| OTP_CODE | varchar | 25 | No | No | No | |
| OTP_COCD | varchar | 25 | No | No | No | |
| OTP_RATE | double | 10,3 | No | No | No | |
| OTP_RALLO | double | 10,3 | No | No | No | |
| OTP_AMT_RATE | double | 15,3 | No | No | No | |
| OTP_REFC | varchar | 60 | No | No | No | |
| OTP_ED_CODE | varchar | 25 | No | No | No | |
| OTP_PCMP_GRP_CODE | varchar | 25 | No | No | No | |
| OTP_DPCD | varchar | 25 | No | No | No | |
| OTP_DPCD_FLAG | varchar | 25 | No | No | No | |
| OTP_RATEC | varchar | 25 | No | No | No | |
| OTP_PYTYPE | varchar | 1 | No | No | No | |
| OTP_TXTYPE | varchar | 1 | No | No | No | |
| OTP_MFIELD | varchar | 25 | No | No | No | |
| OTP_DEFDAYS | double | 15,2 | No | No | No | |
| OTP_DEFMO | varchar | 2 | No | No | No | |
| OTP_DEFCMO | varchar | 1 | No | No | No | |
| OTP_DEFHRS | double | 15,2 | No | No | No | |
| OTP_PMRK | varchar | 1 | No | No | No | |
| OT_SFLAG | varchar | 1 | No | No | No | |
| OT_APPROVED | varchar | 1 | No | No | No | |
ow2016
| ow2016 | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| OBWNUMB | varchar | 15 | No | No | No | |
| OBWDATE | datetime | 0 | No | No | No | |
| OBWDTME | varchar | 4 | No | No | No | |
| OBWATME | varchar | 4 | No | No | No | |
pdm_essi2016
| pdm_essi2016 | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| PDMCOFF | varchar | 3 | No | No | No | |
| PDMFDTE | datetime | 0 | No | No | No | |
| PDMTDTE | datetime | 0 | No | No | No | |
| PDMPOST | varchar | 7 | No | No | No | |
| PDMAFDT | datetime | 0 | No | No | No | |
| PDMATDT | datetime | 0 | No | No | No | |
| PDMDAYS | double | 15,2 | No | No | No | |
| PDMADFD | datetime | 0 | No | No | No | |
| PDMADTD | datetime | 0 | No | No | No | |
| PDMSFDT | datetime | 0 | No | No | No | |
| PDMSTDT | datetime | 0 | No | No | No | |
pdm_sppe2016
| pdm_sppe2016 | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| PDMCOFF | varchar | 3 | No | No | No | |
| PDMFDTE | datetime | 0 | No | No | No | |
| PDMTDTE | datetime | 0 | No | No | No | |
| PDMPOST | varchar | 7 | No | No | No | |
| PDMAFDT | datetime | 0 | No | No | No | |
| PDMATDT | datetime | 0 | No | No | No | |
| PDMDAYS | double | 15,2 | No | No | No | |
| PDMADFD | datetime | 0 | No | No | No | |
| PDMADTD | datetime | 0 | No | No | No | |
| PDMSFDT | datetime | 0 | No | No | No | |
| PDMSTDT | datetime | 0 | No | No | No | |
pdm2016
| pdm2016 | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| PDMCOFF | varchar | 3 | No | No | No | |
| PDMFDTE | datetime | 0 | No | No | No | |
| PDMTDTE | datetime | 0 | No | No | No | |
| PDMPOST | varchar | 7 | No | No | No | |
| PDMAFDT | datetime | 0 | No | No | No | |
| PDMATDT | datetime | 0 | No | No | No | |
| PDMDAYS | double | 15,2 | No | No | No | |
| PDMADFD | datetime | 0 | No | No | No | |
| PDMADTD | datetime | 0 | No | No | No | |
| PDMSFDT | datetime | 0 | No | No | No | |
| PDMSTDT | datetime | 0 | No | No | No | |
pdw_sppe2016
| pdw_sppe2016 | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| PDWWEEK | varchar | 3 | No | No | No | |
| PDWFDTE | datetime | 0 | No | No | No | |
| PDWTDTE | datetime | 0 | No | No | No | |
| PDWPOST | varchar | 7 | No | No | No | |
| PDWAFDT | datetime | 0 | No | No | No | |
| PDWATDT | datetime | 0 | No | No | No | |
| PDWDAYS | double | 15,2 | No | No | No | |
| PDWADFD | datetime | 0 | No | No | No | |
| PDWADTD | datetime | 0 | No | No | No | |
| PDWSFDT | datetime | 0 | No | No | No | |
| PDWSTDT | datetime | 0 | No | No | No | |
pdw2016
| pdw2016 | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| PDWWEEK | varchar | 3 | No | No | No | |
| PDWFDTE | datetime | 0 | No | No | No | |
| PDWTDTE | datetime | 0 | No | No | No | |
| PDWPOST | varchar | 7 | No | No | No | |
| PDWAFDT | datetime | 0 | No | No | No | |
| PDWATDT | datetime | 0 | No | No | No | |
| PDWDAYS | double | 15,2 | No | No | No | |
| PDWADFD | datetime | 0 | No | No | No | |
| PDWADTD | datetime | 0 | No | No | No | |
| PDWSFDT | datetime | 0 | No | No | No | |
| PDWSTDT | datetime | 0 | No | No | No | |
pmhempl
| pmhempl | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| EMPNUMB | varchar | 15 | No | No | No | |
| EMPLNAM | varchar | 40 | No | No | No | |
| EMPFNAM | varchar | 40 | No | No | No | |
| EMPMNAM | varchar | 40 | No | No | No | |
| EMPSXCD | varchar | 1 | No | No | No | |
| EMPBDTE | datetime | 0 | No | No | No | |
| EMPPOBT | varchar | 50 | No | No | No | |
| EMPRGCD | varchar | 2 | No | No | No | |
| EMPCSCD | varchar | 1 | No | No | No | |
| EMPCADD | varchar | 40 | No | No | No | |
| EMPTOWN | varchar | 20 | No | No | No | |
| EMPCITY | varchar | 20 | No | No | No | |
| EMPCZCD | varchar | 2 | No | No | No | |
| EMPTXCD | varchar | 10 | No | No | No | |
| EMPLDTE | datetime | 0 | No | No | No | |
| EMPSSNO | varchar | 12 | No | No | No | |
| EMPTINO | varchar | 12 | No | No | No | |
| EMPHDTE | datetime | 0 | No | No | No | |
| EMPODTE | datetime | 0 | No | No | No | |
| EMPPMCD | varchar | 1 | No | No | No | |
| EMPPCCD | varchar | 1 | No | No | No | |
| EMPCOCD | varchar | 1 | No | No | No | |
| EMPLCCD | varchar | 3 | No | No | No | |
| EMPSTAT | varchar | 1 | No | No | No | |
| EMPSTDT | datetime | 0 | No | No | No | |
| EMPPINO | varchar | 12 | No | No | No | |
| EMPAVOL | tinyint | 1 | No | Yes | No | |
| EMPPVOL | tinyint | 1 | No | Yes | No | |
| EMPTDPD | varchar | 1 | No | No | No | |
| EMPCBAT | varchar | 1 | No | No | No | |
| EMPDPCD | varchar | 10 | No | No | No | |
| EMPESCD | varchar | 1 | No | No | No | |
| EMPDPCC | varchar | 10 | No | No | No | |
| EMPINCO | varchar | 1 | No | No | No | |
| EMPALLO | double | 15,5 | No | No | No | |
| EMPFEPF | varchar | 1 | No | No | No | |
| EMPHLDT | datetime | 0 | No | No | No | |
| EMPMENO | varchar | 12 | No | No | No | |
pmmcmpy
| pmmcmpy | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| recid | int | 25 | Yes | Yes | Yes | |
| CMPCOCD | varchar | 1 | No | No | No | |
| CMPNAME | varchar | 40 | No | No | No | |
| CMPSSSN | varchar | 12 | No | No | No | |
| CMPTINO | varchar | 12 | No | No | No | |
| CMPCADD | varchar | 50 | No | No | No | |
| CMPSLAC | varchar | 10 | No | No | No | |
| CMPSMEC | varchar | 10 | No | No | No | |
| CMPBKAL | varchar | 10 | No | No | No | |
| CMPOTHR | varchar | 10 | No | No | No | |
| CMPHOLD | varchar | 10 | No | No | No | |
| CMPPIBE | varchar | 10 | No | No | No | |
| CMPTELE | varchar | 10 | No | No | No | |
| CMPBMAK | varchar | 10 | No | No | No | |
| CMPCASH | varchar | 10 | No | No | No | |
| CMPTAXC | varchar | 10 | No | No | No | |
| CMPSMEP | varchar | 10 | No | No | No | |
| CMPABBR | varchar | 5 | No | No | No | |
| CMPMEDP | varchar | 10 | No | No | No | |
| CMPHACC | varchar | 3 | No | No | No | |
| CMPPACC | varchar | 3 | No | No | No | |
| CMPWACC | varchar | 3 | No | No | No | |
| CMPTACC | varchar | 3 | No | No | No | |
| CMPHLAC | varchar | 3 | No | No | No | |
| CMPSACC | varchar | 3 | No | No | No | |
| CMPBACC | varchar | 3 | No | No | No | |
| CMPOIAC | varchar | 3 | No | No | No | |
| CMPSMAC | varchar | 3 | No | No | No | |
| CMPSPAC | varchar | 3 | No | No | No | |
| CMPOSLA | varchar | 3 | No | No | No | |
| CMPADDR | varchar | 100 | No | No | No | |
| CMPPAGBR | varchar | 5 | No | No | No | |
| CMPTELNO | varchar | 15 | No | No | No | |
| CMPZIPCD | varchar | 10 | No | No | No | |
| CMPFNAME | varchar | 8 | No | No | No | |
| CMPPHILNO | varchar | 12 | No | No | No | |
| CMPPHILSIG | varchar | 60 | No | No | No | |
| CMPPHILSIGPOS | varchar | 60 | No | No | No | |
pmmacin
| pmmacin | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| ACIACCD | varchar | 3 | No | No | No | |
| ACIDESC | varchar | 20 | No | No | No | |
pmmbene
| pmmbene | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| BENBNCD | varchar | 3 | No | No | No | |
| BENDESC | varchar | 15 | No | No | No | |
pmmcsta
| pmmcsta | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| CSTCSCD | varchar | 1 | No | No | No | |
| CSTDESC | varchar | 15 | No | No | No | |
pmmctzp
| pmmctzp | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| CTZCZCD | varchar | 2 | No | No | No | |
| CTZDESC | varchar | 30 | No | No | No | |
pmmdept
| pmmdept | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| recid | int | 25 | Yes | Yes | Yes | |
| DEPDPCD | varchar | 10 | No | No | No | |
| DEPCPCD | varchar | 1 | No | No | No | |
| DEPNAME | varchar | 35 | No | No | No | |
| DEPINCO | varchar | 2 | No | No | No | |
| DEPSLWG | varchar | 8 | No | No | No | |
| DEPSSSM | varchar | 8 | No | No | No | |
| DEPABBR | varchar | 5 | No | No | No | |
| DEPCOCD | varchar | 1 | No | No | No | |
| DEPFLAG | varchar | 1 | No | No | No | |
| DEPBONS | varchar | 8 | No | No | No | |
| DEPBENE | varchar | 8 | No | No | No | |
| DEPOCDE | varchar | 3 | No | No | No | |
| DEPACTV | varchar | 1 | No | No | No | |
| DEPACTIVE | varchar | 1 | No | No | No | |
pmmicls
| pmmicls | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| ICLICCD | varchar | 3 | No | No | No | |
| ICLDESC | varchar | 15 | No | No | No | |
pmmjblv
| pmmjblv | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| JBLJLCD | varchar | 2 | No | No | No | |
| JBLDESC | varchar | 30 | No | No | No | |
pmmlnge
| pmmlnge | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| LNGCODE | varchar | 2 | No | No | No | |
| LNGDESC | varchar | 15 | No | No | No | |
pmmloca
| pmmloca | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| LOCCODE | varchar | 3 | No | No | No | |
| LOCDESC | varchar | 20 | No | No | No | |
pmmmach
| pmmmach | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| MACMCCD | varchar | 3 | No | No | No | |
| MACDESC | varchar | 25 | No | No | No | |
pmmmart
| pmmmart | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| PARPRCD | varchar | 3 | No | No | No | |
| PARDESC | varchar | 15 | No | No | No | |
pmmpact
| pmmpact | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| PACPACD | varchar | 3 | No | No | No | |
| PACDESC | varchar | 20 | No | No | No | |
pmmposn
| pmmposn | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| POSPSCD | varchar | 3 | No | No | No | |
| POSDESC | varchar | 70 | No | No | No | |
| POSJLCD | varchar | 0 | No | No | No | |
| OCODE | varchar | 3 | No | No | No | |
pmmrltp
| pmmrltp | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| RLTRLCD | varchar | 2 | No | No | No | |
| RLTDESC | varchar | 15 | No | No | No | |
| RLTSXCD | varchar | 1 | No | No | No | |
pmmsect
| pmmsect | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| SECSCCD | varchar | 2 | No | No | No | |
| SECNAME | varchar | 25 | No | No | No | |
pmmshf2
| pmmshf2 | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| SHFSFCD | varchar | 3 | No | No | No | |
| SHFRDCD | varchar | 1 | No | No | No | |
| SHFAMIN | varchar | 4 | No | No | No | |
| SHFAMOT | varchar | 4 | No | No | No | |
| SHFPMIN | varchar | 4 | No | No | No | |
| SHFPMOT | varchar | 4 | No | No | No | |
| SHFGPRD | varchar | 2 | No | No | No | |
| SHFSTAG | tinyint | 1 | No | No | No | |
pmmshfv
| pmmshfv | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| SHVSFCD | varchar | 3 | No | No | No | |
| SHVRDCD | varchar | 1 | No | No | No | |
| SHVAMIN | varchar | 4 | No | No | No | |
| SHVPMOT | varchar | 4 | No | No | No | |
pmmskll
| pmmskll | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| SKLSKCD | varchar | 2 | No | No | No | |
| SKLDESC | varchar | 20 | No | No | No | |
pmmtaxt
| pmmtaxt | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| TAXTXCD | varchar | 10 | No | No | No | |
| TAXDESC | varchar | 30 | No | No | No | |
| TAXEXEM | double | 15,2 | No | No | No | |
pmt_ctr_no
| pmt_ctr_no | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| empnumb_ctr | varchar | 15 | No | No | No | |
| empnumb_year | varchar | 4 | No | No | No | |
pmtatmp
| pmtatmp | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| ATMNUMB | varchar | 15 | No | No | No | |
| ATMBKCD | varchar | 5 | No | No | No | |
| ATMACCT | varchar | 14 | No | No | No | |
pmtchdf
| pmtchdf | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| CHDNUMB | varchar | 15 | No | No | No | |
| CHDLNAM | varchar | 15 | No | No | No | |
| CHDFNAM | varchar | 20 | No | No | No | |
| CHDMNAM | varchar | 15 | No | No | No | |
| CHDBDTE | datetime | 0 | No | No | No | |
| CHDSXCD | varchar | 1 | No | No | No | |
pmtchrr
| pmtchrr | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| CHRNUMB | varchar | 15 | No | No | No | |
| CHRLNAM | varchar | 15 | No | No | No | |
| CHRFNAM | varchar | 20 | No | No | No | |
| CHRMNAM | varchar | 15 | No | No | No | |
| CHRADDR | varchar | 30 | No | No | No | |
| CHRTELE | varchar | 12 | No | No | No | |
| CHROCCU | varchar | 15 | No | No | No | |
| CHRYRKW | double | 15,5 | No | No | No | |
pmtcmdn
| pmtcmdn | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| CMDNUMB | varchar | 15 | No | No | No | |
| CMDDATE | datetime | 0 | No | No | No | |
| CMDAWRD | varchar | 15 | No | No | No | |
pmtdpdt
| pmtdpdt | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| DPDNUMB | varchar | 15 | No | No | No | |
| DPDRLCD | varchar | 2 | No | No | No | |
| DPDLNAM | varchar | 15 | No | No | No | |
| DPDFNAM | varchar | 20 | No | No | No | |
| DPDMNAM | varchar | 15 | No | No | No | |
| DPDBDTE | datetime | 0 | No | No | No | |
| DPDSXCD | varchar | 1 | No | No | No | |
pmtdrvl
| pmtdrvl | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| DRVNUMB | varchar | 15 | No | No | No | |
| DRVLCNO | varchar | 15 | No | No | No | |
| DRVPLCE | varchar | 15 | No | No | No | |
| DRVDATE | datetime | 0 | No | No | No | |
pmteduc
| pmteduc | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| EDUNUMB | varchar | 15 | No | No | No | |
| EDUSCHL | varchar | 30 | No | No | No | |
| EDUYRGD | double | 15,5 | No | No | No | |
| EDUCOUR | varchar | 30 | No | No | No | |
| EDUHONR | varchar | 30 | No | No | No | |
pmtemp_illness
| pmtemp_illness | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| RECID | int | 10 | Yes | Yes | Yes | |
| EMPNUMB | varchar | 15 | No | Yes | No | |
| ILLDTAQUIRED | date | 0 | No | Yes | No | |
| ILLNAME | varchar | 45 | No | Yes | No | |
| ILLRMKS | varchar | 200 | No | Yes | No | |
pmtemp_reference
| pmtemp_reference | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| RECID | int | 10 | Yes | Yes | Yes | |
| EMPNUMB | varchar | 15 | No | Yes | No | |
| REFNAME | varchar | 100 | No | Yes | No | |
| REFRLTN | varchar | 30 | No | Yes | No | |
| REFTELN | varchar | 15 | No | Yes | No | |
| REFOCCU | varchar | 45 | No | Yes | No | |
pmtempchildren
| pmtempchildren | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| RECID | int | 10 | Yes | Yes | Yes | |
| EMPNUMB | varchar | 15 | No | Yes | No | |
| FAMNAME | varchar | 100 | No | Yes | No | |
| FAMRLTN | varchar | 45 | No | Yes | No | |
| FAMOCCU | varchar | 50 | No | Yes | No | |
| FAMDTOB | date | 0 | No | Yes | No | |
| FAMDTOD | date | 0 | No | No | No | |
pmtempdependent
| pmtempdependent | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| RECID | int | 10 | Yes | Yes | Yes | |
| EMPNUMB | varchar | 15 | No | Yes | No | |
| FAMNAME | varchar | 100 | No | Yes | No | |
| FAMRLTN | varchar | 45 | No | Yes | No | |
| FAMOCCU | varchar | 50 | No | Yes | No | |
| FAMDTOB | date | 0 | No | Yes | No | |
| FAMDTOD | date | 0 | No | No | No | |
pmtempchildren
| pmtempchildren | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| RECID | int | 10 | Yes | Yes | Yes | |
| EMPNUMB | varchar | 15 | No | Yes | No | |
| FAMNAME | varchar | 100 | No | Yes | No | |
| FAMRLTN | varchar | 45 | No | Yes | No | |
| FAMOCCU | varchar | 50 | No | Yes | No | |
| FAMDTOB | date | 0 | No | Yes | No | |
| FAMDTOD | date | 0 | No | No | No | |
pmtempedu
| pmtempedu | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| EMPNUMB | varchar | 15 | No | Yes | No | |
| EDUDTFRM | varchar | 4 | No | Yes | No | |
| EDUDTTO | varchar | 4 | No | Yes | No | |
| EDUDGRE | varchar | 100 | No | Yes | No | |
| EDUSCHL | varchar | 200 | No | Yes | No | |
| EDUGRAD | varchar | 2 | No | Yes | No | |
| EDUHONR | varchar | 50 | No | Yes | No | |
| EDUREMK | varchar | 200 | No | No | No | |
| EMPEDUID | int | 10 | Yes | Yes | Yes | |
pmtempfamily
| pmtempfamily | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| RECID | int | 10 | Yes | Yes | Yes | |
| EMPNUMB | varchar | 15 | No | Yes | No | |
| FAMNAME | varchar | 100 | No | Yes | No | |
| FAMRLTN | varchar | 45 | No | Yes | No | |
| FAMOCCU | varchar | 50 | No | Yes | No | |
| FAMDTOB | date | 0 | No | Yes | No | |
| FAMDTOD | date | 0 | No | No | No | |
pmtempgovexam
| pmtempgovexam | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| RECID | int | 10 | Yes | Yes | Yes | |
| EMPNUMB | varchar | 15 | No | Yes | No | |
| DTEXAM | date | 0 | No | Yes | No | |
| GOVAGENCY | varchar | 100 | No | Yes | No | |
| EXAMNAME | varchar | 100 | No | Yes | No | |
| PASSED | varchar | 2 | No | Yes | No | |
| REMARKS | varchar | 100 | No | Yes | No | |
pmtempl
| pmtempl | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| EMPNUMB | varchar | 15 | No | No | No | |
| EMPLNAM | varchar | 15 | No | No | No | |
| EMPFNAM | varchar | 20 | No | No | No | |
| EMPMNAM | varchar | 15 | No | No | No | |
| EMPSXCD | varchar | 1 | No | No | No | |
| EMPBDTE | datetime | 0 | No | No | No | |
| EMPPOBT | varchar | 15 | No | No | No | |
| EMPRGCD | varchar | 2 | No | No | No | |
| EMPCSCD | varchar | 1 | No | No | No | |
| EMPCADD | varchar | 40 | No | No | No | |
| EMPTOWN | varchar | 20 | No | No | No | |
| EMPCITY | varchar | 20 | No | No | No | |
| EMPCZCD | varchar | 2 | No | No | No | |
| EMPTXCD | varchar | 10 | No | No | No | |
| EMPLDTE | datetime | 0 | No | No | No | |
| EMPSSNO | varchar | 12 | No | No | No | |
| EMPTINO | varchar | 11 | No | No | No | |
| EMPHDTE | datetime | 0 | No | No | No | |
| EMPODTE | datetime | 0 | No | No | No | |
| EMPPMCD | varchar | 1 | No | No | No | |
| EMPPCCD | varchar | 1 | No | No | No | |
| EMPCOCD | varchar | 1 | No | No | No | |
| EMPLCCD | varchar | 3 | No | No | No | |
| EMPSTAT | varchar | 1 | No | No | No | |
| EMPSTDT | datetime | 15,2 | No | No | No | |
| EMPPINO | varchar | 12 | No | No | No | |
| EMPAVOL | tinyint | 1 | No | No | No | |
| EMPPVOL | tinyint | 1 | No | No | No | |
| EMPTDPD | varchar | 1 | No | No | No | |
| EMPCBAT | varchar | 1 | No | No | No | |
| EMPDPCD | varchar | 10 | No | No | No | |
| EMPESCD | varchar | 1 | No | No | No | |
| EMPDPCC | varchar | 10 | No | No | No | |
| EMPINCO | varchar | 1 | No | No | No | |
| EMPALLO | double | 15,2 | No | No | No | |
| EMPFEPF | varchar | 1 | No | No | No | |
| EMPHLDT | datetime | 0 | No | No | No | |
| EMPMENO | varchar | 12 | No | No | No | |
| EMPDBNK | varchar | 5 | No | No | No | |
| EMPEOCD | datetime | 0 | No | No | No | |
| EMPEOCC | varchar | 1 | No | No | No | |
| EMPADDR1 | varchar | 500 | No | No | No | |
| EMPADDR2 | varchar | 500 | No | No | No | |
| EMPADDR3 | varchar | 500 | No | No | No | |
| EMPADDR4 | varchar | 500 | No | No | No | |
| EMPATMP | varchar | 16 | No | No | No | |
| EMPTELN | varchar | 500 | No | No | No | |
| EMPBKCD | varchar | 3 | No | No | No | |
| EMPUNITHEAD | varchar | 50 | No | No | No | |
| EMPUNIT | varchar | 50 | No | No | No | |
| EMPDEMINI_AMT | double | 15,2 | No | No | No | |
pmtempl_creation
| pmtempl_creation | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| EMPNUMB | varchar | 15 | No | No | No | |
| EMPLNAM | varchar | 15 | No | No | No | |
| EMPFNAM | varchar | 20 | No | No | No | |
| EMPMNAM | varchar | 15 | No | No | No | |
| EMPSXCD | varchar | 1 | No | No | No | |
| EMPBDTE | datetime | 0 | No | No | No | |
| EMPPOBT | varchar | 15 | No | No | No | |
| EMPRGCD | varchar | 2 | No | No | No | |
| EMPCSCD | varchar | 1 | No | No | No | |
| EMPCADD | varchar | 40 | No | No | No | |
| EMPTOWN | varchar | 20 | No | No | No | |
| EMPCITY | varchar | 20 | No | No | No | |
| EMPCZCD | varchar | 2 | No | No | No | |
| EMPTXCD | varchar | 10 | No | No | No | |
| EMPLDTE | datetime | 0 | No | No | No | |
| EMPSSNO | varchar | 12 | No | No | No | |
| EMPTINO | varchar | 11 | No | No | No | |
| EMPHDTE | datetime | 0 | No | No | No | |
| EMPODTE | datetime | 0 | No | No | No | |
| EMPPMCD | varchar | 1 | No | No | No | |
| EMPPCCD | varchar | 1 | No | No | No | |
| EMPCOCD | varchar | 1 | No | No | No | |
| EMPLCCD | varchar | 3 | No | No | No | |
| EMPSTAT | varchar | 1 | No | No | No | |
| EMPSTDT | datetime | 15,2 | No | No | No | |
| EMPPINO | varchar | 12 | No | No | No | |
| EMPAVOL | tinyint | 1 | No | No | No | |
| EMPPVOL | tinyint | 1 | No | No | No | |
| EMPTDPD | varchar | 1 | No | No | No | |
| EMPCBAT | varchar | 1 | No | No | No | |
| EMPDPCD | varchar | 10 | No | No | No | |
| EMPESCD | varchar | 1 | No | No | No | |
| EMPDPCC | varchar | 10 | No | No | No | |
| EMPINCO | varchar | 1 | No | No | No | |
| EMPALLO | double | 15,2 | No | No | No | |
| EMPFEPF | varchar | 1 | No | No | No | |
| EMPHLDT | datetime | 0 | No | No | No | |
| EMPMENO | varchar | 12 | No | No | No | |
| EMPDBNK | varchar | 5 | No | No | No | |
| EMPEOCD | datetime | 0 | No | No | No | |
| EMPEOCC | varchar | 1 | No | No | No | |
| EMPADDR1 | varchar | 500 | No | No | No | |
| EMPADDR2 | varchar | 500 | No | No | No | |
| EMPADDR3 | varchar | 500 | No | No | No | |
| EMPADDR4 | varchar | 500 | No | No | No | |
| EMPATMP | varchar | 16 | No | No | No | |
| EMPTELN | varchar | 500 | No | No | No | |
| EMPBKCD | varchar | 3 | No | No | No | |
| EMPUNITHEAD | varchar | 50 | No | No | No | |
| EMPUNIT | varchar | 50 | No | No | No | |
| EMPDEMINI_AMT | double | 15,2 | No | No | No | |
pmtempl_deminimis
| pmtempl_deminimis | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| recid | int | 20 | Yes | Yes | Yes | |
| EMPNUMB | varchar | 15 | No | No | No | |
| EMPEDTE | date | 0 | No | No | No | |
| EMPAMT | double | 15,3 | No | No | No | |
| EMPMRK | varchar | 1 | No | No | No | |
pmtempl_txcd2016
| pmtempl_txcd2016 | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| EMPNUMB | varchar | 15 | No | No | No | |
| EMPTXCD | varchar | 10 | No | No | No | |
pmtemptraining
| pmtemptraining | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| RECID | int | 10 | Yes | Yes | Yes | |
| EMPNUMB | varchar | 15 | No | Yes | No | |
| LNGNAME | varchar | 45 | No | Yes | No | |
| LNGSPEAK | varchar | 15 | No | Yes | No | |
| LNGWRTE | varchar | 15 | No | Yes | No | |
| LNGREAD | varchar | 15 | No | Yes | No | |
| LNGRMKS | varchar | 200 | No | Yes | No | |
pmtempmachine
| pmtempmachine | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| RECID | int | 10 | Yes | Yes | Yes | |
| EMPNUMB | varchar | 15 | No | Yes | No | |
| LNGNAME | varchar | 45 | No | Yes | No | |
| LNGSPEAK | varchar | 15 | No | Yes | No | |
| LNGWRTE | varchar | 15 | No | Yes | No | |
| LNGREAD | varchar | 15 | No | Yes | No | |
| LNGRMKS | varchar | 200 | No | Yes | No | |
pmtemprelative
| pmtemprelative | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| RECID | int | 10 | Yes | Yes | Yes | |
| EMPNUMB | varchar | 45 | No | Yes | No | |
| EMPNAME | varchar | 200 | No | Yes | No | |
| RELPSCD | varchar | 10 | No | Yes | No | |
| RELDPCD | varchar | 10 | No | Yes | No | |
| RELRMKS | varchar | 200 | No | Yes | No | |
pmtempskills
| pmtempskills | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| RECID | int | 10 | Yes | Yes | Yes | |
| EMPNUMB | varchar | 15 | No | Yes | No | |
| SKLNAME | varchar | 50 | No | Yes | No | |
| SKLPROF | varchar | 20 | No | Yes | No | |
| SKLRMKS | varchar | 45 | No | Yes | No | |
pmtemptraining
| pmtemptraining | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| EMPID | int | 10 | Yes | Yes | Yes | |
| EMPDTFRM | date | 0 | No | Yes | No | |
| EMPDTTO | date | 0 | No | Yes | No | |
| EMPSEMNAME | varchar | 200 | No | Yes | No | |
| INTERNAL | varchar | 2 | No | Yes | No | |
| EMPCNDCTDBY | varchar | 45 | No | Yes | No | |
| EMPHRS | double | 15,2 | No | Yes | No | |
| EMPCOST | double | 15,2 | No | Yes | No | |
| EMPCMPSPNSR | varchar | 2 | No | Yes | No | |
| EMPSTATUS | varchar | 100 | No | Yes | No | |
| EMPRMK | varchar | 100 | No | Yes | No | |
| EMPNUMB | varchar | 15 | No | Yes | No | |
pmtemve
| pmtemve | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| recid | int | 25 | Yes | Yes | Yes | |
| EMVNUMB | varchar | 15 | No | No | No | |
| EMVEDTE | datetime | 0 | No | No | No | |
| EMVSCCD | varchar | 2 | No | No | No | |
| EMVSFCD | varchar | 3 | No | No | No | |
| EMVLCCD | varchar | 3 | No | No | No | |
| EMVDPCD | varchar | 10 | No | No | No | |
| EMVPSCD | varchar | 3 | No | No | No | |
| EMVBPAY | double | 15,5 | No | No | No | |
| EMVALLO | double | 15,5 | No | No | No | |
| EMVRDCD | varchar | 2 | No | No | No | |
| EMVESCD | varchar | 1 | No | No | No | |
| EMVFLAG | tinyint | 1 | No | No | No | |
| EMVPCCD | varchar | 1 | No | No | No | |
| EMVCOCD | varchar | 1 | No | No | No | |
| EMVFPER | varchar | 1 | No | No | No | |
| EMVPACD | varchar | 2 | No | No | No | |
| EMVDPCC | varchar | 10 | No | No | No | |
| EMVPADT | datetime | 0 | No | No | No | |
| EMVTDPD | varchar | 1 | No | No | No | |
| EMVBLOC | varchar | 3 | No | No | No | |
| OCODE | varchar | 3 | No | No | No | |
| EMVWSCD | varchar | 25 | No | No | No | |
pmtfamy
| pmtfamy | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| FAMNUMB | varchar | 15 | No | No | No | |
| FAMRLCD | varchar | 2 | No | No | No | |
| FAMLNAM | varchar | 15 | No | No | No | |
| FAMFNAM | varchar | 20 | No | No | No | |
| FAMMNAM | varchar | 15 | No | No | No | |
| FAMBDTE | datetime | 0 | No | No | No | |
| FAMSXCD | varchar | 1 | No | No | No | |
| FAMOCCU | varchar | 15 | No | No | No | |
| FAMCOSH | varchar | 15 | No | No | No | |
pmtfixm
| pmtfixm | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| FIXDPCD | varchar | 10 | No | No | No | |
| FIXFDTE | datetime | 0 | No | No | No | |
| FIXTDTE | datetime | 0 | No | No | No | |
| FIXMNUM | double | 15,2 | No | No | No | |
| FIXUSER | varchar | 20 | No | No | No | |
| FIXDATE | datetime | 0 | No | No | No | |
| FIXMOYR | varchar | 6 | No | No | No | |
pmtfrrl
| pmtfrrl | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| FRRNUMB | varchar | 8 | No | No | No | |
| FRRRLCD | varchar | 2 | No | No | No | |
| FRRENUM | varchar | 30 | No | No | No | |
pmtgvte
| pmtgvte | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| GVTNUMB | varchar | 15 | No | No | No | |
| GVTNTRE | varchar | 20 | No | No | No | |
| GVTDATE | varchar | 4 | No | No | No | |
| GVTRATE | double | 15,5 | No | No | No | |
pmtilln
| pmtilln | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| ILLNUMB | varchar | 15 | No | No | No | |
| ILLNTRE | varchar | 15 | No | No | No | |
| ILLREMK | varchar | 10 | No | No | No | |
pmtvip2
| pmtvip2 | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| VIPNUMB | varchar | 15 | No | No | No | |
| VIPEDTE | datetime | 0 | No | No | No | |
| VIPBPAY | double | 18,2 | No | No | No | |
| VIPALLO | double | 18,2 | No | No | No | |
pmtlgef
| pmtlgef | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| LGENUMB | varchar | 15 | No | No | No | |
| LGELACD | varchar | 2 | No | No | No | |
pmtmarr
| pmtmarr | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| MARNUMB | varchar | 15 | No | No | No | |
| MARLNAM | varchar | 15 | No | No | No | |
| MARFNAM | varchar | 20 | No | No | No | |
| MARMNAM | varchar | 15 | No | No | No | |
| MARBDTE | datetime | 0 | No | No | No | |
| MARMDTE | datetime | 0 | No | No | No | |
pmtmchd
| pmtmchd | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| MCHNUMB | varchar | 15 | No | No | No | |
| MCHCODE | varchar | 2 | No | No | No | |
pmtmwee
| pmtmwee | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| MWEENUMB | varchar | 15 | No | No | No | |
| MWEEDTE | date | 0 | No | No | No | |
| MWEBASIC | double | 15,2 | No | No | No | |
| MWEALLOW | double | 15,2 | No | No | No | |
| MWE_WO_SEQN | varchar | 4 | No | No | No | |
| MWE_WO_REGION_CODE | varchar | 25 | No | No | No | |
| MWE_WO_REGION_AREA | varchar | 25 | No | No | No | |
| MWE_WO_CLASS_CODE | varchar | 25 | No | No | No | |
| MWE_WO_PCLASS | varchar | 1 | No | No | No | |
| MWE_DATEE | datetime | 0 | No | No | No | |
| MWE_REMK | varchar | 1 | No | No | No | |
pmtnoti
| pmtnoti | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| NOTNUMB | varchar | 15 | No | No | No | |
| NOTRLCD | varchar | 2 | No | No | No | |
| NOTLNAM | varchar | 15 | No | No | No | |
| NOTFNAM | varchar | 20 | No | No | No | |
| NOTMNAM | varchar | 15 | No | No | No | |
| NOTADDR | varchar | 30 | No | No | No | |
pmtntph
| pmtntph | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| NTPNUMB | varchar | 15 | No | No | No | |
| NTPDESC | varchar | 15 | No | No | No | |
| NTPTELE | varchar | 12 | No | No | No | |
pmtprem
| pmtprem | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| PRENUMB | varchar | 15 | No | No | No | |
| PRECONM | varchar | 20 | No | No | No | |
| PRECONR | varchar | 15 | No | No | No | |
| PRESDTE | datetime | 0 | No | No | No | |
| PREPOSN | varchar | 15 | No | No | No | |
| PREJDSC | longtext | 0 | No | No | No | |
| PREGPAY | double | 15,5 | No | No | No | |
| PRETAXW | double | 15,5 | No | No | No | |
| PRE13MO | double | 15,5 | No | No | No | |
| PREPTAG | tinyint | 1 | No | Yes | No | |
pmtprem
| pmtprem | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| PRENUMB | varchar | 15 | No | No | No | |
| PRECONM | varchar | 20 | No | No | No | |
| PRECONR | varchar | 15 | No | No | No | |
| PRESDTE | datetime | 0 | No | No | No | |
| PREPOSN | varchar | 15 | No | No | No | |
| PREJDSC | longtext | 0 | No | No | No | |
| PREGPAY | double | 15,5 | No | No | No | |
| PRETAXW | double | 15,5 | No | No | No | |
| PRE13MO | double | 15,5 | No | No | No | |
| PREPTAG | tinyint | 1 | No | Yes | No | |
pmtprevemployer
| pmtprevemployer | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| RECID | int | 10 | Yes | Yes | Yes | |
| EMPNUMB | varchar | 15 | No | Yes | No | |
| PRECONR | varchar | 15 | No | Yes | No | |
| PRVDTFRM | date | 0 | No | Yes | No | |
| PRVDTTO | date | 0 | No | Yes | No | |
| PRVCMPY | varchar | 100 | No | Yes | No | |
| PRVPOSN | varchar | 45 | No | Yes | No | |
| PRVCONO | varchar | 20 | No | Yes | No | |
| PRVSLRY | double | 15,2 | No | Yes | No | |
| PRVRSON | varchar | 100 | No | Yes | No | |
pmtprsn_notify
| pmtprsn_notify | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| RECID | int | 10 | Yes | Yes | Yes | |
| EMPNUMB | varchar | 15 | No | No | No | |
| PRSNNAME | varchar | 100 | No | Yes | No | |
| PRSNRLTN | varchar | 45 | No | Yes | No | |
| PRSNTELN | varchar | 50 | No | Yes | No | |
| PRSNADDR | varchar | 200 | No | Yes | No | |
pmtsemr
| pmtsemr | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| SEMNUMB | varchar | 15 | No | No | No | |
| SEMNTRE | varchar | 40 | No | No | No | |
| SEMSDTE | datetime | 0 | No | No | No | |
| SEMEDTE | datetime | 0 | No | No | No | |
| SEMPLAC | varchar | 15 | No | No | No | |
pmtsepa
| pmtsepa | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| SEPNUMB | varchar | 15 | No | No | No | |
| SEPPSNO | varchar | 1 | No | No | No | |
| SEPDATE | datetime | 0 | No | No | No | |
| SEPRSON | varchar | 20 | No | No | No | |
| SEPNPAY | double | 15,5 | No | No | No | |
| SEPSPAY | double | 15,5 | No | No | No | |
| SEP13PY | double | 15,5 | No | No | No | |
| SEPSLPY | double | 15,5 | No | No | No | |
| SEPVLPY | double | 15,5 | No | No | No | |
| SEPADDS | double | 15,5 | No | No | No | |
| SEPNNUM | varchar | 6 | No | No | No | |
| SEPRELE | tinyint | 1 | No | Yes | No | |
| SEPTAXD | double | 15,5 | No | No | No | |
| SEPTAXW | double | 15,5 | No | No | No | |
| SEPALLO | double | 15,5 | No | No | No | |
| SEPGPAY | double | 15,5 | No | No | No | |
| SEPRDTE | datetime | 0 | No | No | No | |
| SEPRTAG | varchar | 1 | No | No | No | |
| SEPRLBY | varchar | 8 | No | No | No | |
| SEPPRNT | varchar | 1 | No | No | No | |
| SEPHLSL | double | 15,2 | No | No | No | |
| SEPMARK | varchar | 1 | No | No | No | |
| SEPCOCD | varchar | 1 | No | No | No | |
| SEPLHSL | double | 15,2 | No | No | No | |
| SEPLHSL2 | double | 15,2 | No | No | No | |
| SEPLHSL_CDTE | date | 0 | No | No | No | |
| SEPLHSL2_CDTE | date | 0 | No | No | No | |
pmtsepa_comp
| pmtsepa_comp | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| recid | int | 25 | Yes | Yes | Yes | |
| SEPNUMB | varchar | 15 | No | No | No | |
| SEPVDCD | varchar | 25 | No | No | No | |
| SEPGLCD | varchar | 25 | No | No | No | |
| SEPPDESC | varchar | 100 | No | No | No | |
| SEPAMNT | double | 15,2 | No | No | No | |
| SEPDAMT | double | 15,2 | No | No | No | |
| SEPSDSA | varchar | 1 | No | No | No | |
| SEPPSNO | varchar | 1 | No | No | No | |
| SEPPRNT | varchar | 1 | No | No | No | |
| SEPCOCD | varchar | 1 | No | No | No | |
| SEPDPCD | varchar | 25 | No | Yes | No | |
| SEPESCD | varchar | 1 | No | No | No | |
| SEPSDCD | varchar | 25 | No | No | No | |
| SEPPRIO | int | 5 | No | No | No | |
| SEPSDMCODE | varchar | 10 | No | No | No | |
| SDADATE | date | 0 | No | No | No | |
| SDABALC | double | 15,2 | No | No | No | |
| SDAUNPD | double | 15,2 | No | No | No | |
| SEPPRNT | varchar | 1 | No | No | No | |
| SEPHLSL | double | 15,2 | No | No | No | |
| SEPMARK | varchar | 1 | No | No | No | |
| SEPCOCD | varchar | 1 | No | No | No | |
| SEPLHSL | double | 15,2 | No | No | No | |
| SEPLHSL2 | double | 15,2 | No | No | No | |
| SEPLHSL_CDTE | date | 0 | No | No | No | |
| SEPLHSL2_CDTE | date | 0 | No | No | No | |
pmtskhb
| pmtskhb | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| SKHNUMB | varchar | 15 | No | No | No | |
| SKHSKCD | varchar | 2 | No | No | No | |
pmtmwee
| pmtmwee | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| MWEENUMB | varchar | 15 | No | No | No | |
| MWEEDTE | date | 0 | No | No | No | |
| MWEBASIC | double | 15,2 | No | No | No | |
| MWEALLOW | double | 15,2 | No | No | No | |
| MWE_WO_SEQN | varchar | 4 | No | No | No | |
| MWE_WO_REGION_CODE | varchar | 25 | No | No | No | |
| MWE_WO_REGION_AREA | varchar | 25 | No | No | No | |
| MWE_WO_CLASS_CODE | varchar | 25 | No | No | No | |
| MWE_WO_PCLASS | varchar | 1 | No | No | No | |
| MWE_DATEE | datetime | 0 | No | No | No | |
| MWE_REMK | varchar | 1 | No | No | No | |
pp2016
| pp2016 | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| recid | int | 30 | No | No | No | |
| PDMCOCD | varchar | 25 | No | No | No | |
| PDMCOFF | varchar | 3 | No | No | No | |
| PDMFDTE | date | 0 | No | No | No | |
| PDMTDTE | date | 0 | No | No | No | |
| PDMPOST | varchar | 1 | No | No | No | |
| PDMAFDT | datetime | 0 | No | No | No | |
| PDMATDT | datetime | 0 | No | No | No | |
| PDMDAYS | double | 15,2 | No | No | No | |
| PDMADFD | datetime | 0 | No | No | No | |
| PDMADTD | datetime | 0 | No | No | No | |
| PDMSFDT | datetime | 0 | No | No | No | |
| PDMSTDT | datetime | 0 | No | No | No | |
| PDMPCCD | varchar | 25 | No | No | No | |
profile_perinfo
| profile_perinfo | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| recid | int | 25 | Yes | Yes | Yes | |
| PR_CODENO | varchar | 25 | No | No | No | |
| PR_LNAME | varchar | 30 | No | No | No | |
| PR_FNAME | varchar | 30 | No | No | No | |
| PR_MNAME | varchar | 30 | No | No | No | |
| PR_BDAY | date | 0 | No | No | No | |
| PR_POBT | varchar | 60 | No | No | No | |
| PR_NLTY | varchar | 25 | No | No | No | |
| PR_DIOCESE | varchar | 25 | No | No | No | |
| PR_ADDR | longtext | 0 | No | No | No | |
| PR_CONTPER | longtext | 0 | No | No | No | |
| PR_CONTPER_ADDR | longtext | 0 | No | No | No | |
| PR_CONTPER_TELNO | longtext | 0 | No | No | No | |
| IMAGEBIN | longblob | 0 | No | No | No | |
| IMAGETYPE | varchar | 25 | No | No | No | |
| IMAGEFILENG | varchar | 50 | No | No | No | |
pvf2016
| pvf2016 | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| PVFRECID | varchar | 20 | Yes | Yes | Yes | |
| PVFNUMB | varchar | 15 | No | No | No | |
| PVFSDCD | varchar | 3 | No | No | No | |
| PVFPDTE | datetime | 0 | No | No | No | |
| PVFBPAY | double | 15,2 | No | No | No | |
| PVFALLO | double | 15,2 | No | No | No | |
| PVFTAGD | varchar | 1 | No | No | No | |
| PVFPDAY | double | 15,2 | No | No | No | |
| PVFHOUR | double | 15,2 | No | No | No | |
| PVFMINS | double | 15,2 | No | No | No | |
| PVFSDSA | varchar | 1 | No | No | No | |
| PVFEDTE | datetime | 0 | No | No | No | |
| PVFAMNT | double | 15,2 | No | No | No | |
| PVFDATE | datetime | 0 | No | No | No | |
| PVFNRD1 | double | 15,2 | No | No | No | |
| PVFRRD2 | double | 15,2 | No | No | No | |
| PVFRRO2 | double | 15,2 | No | No | No | |
| PVFNRD2 | double | 15,2 | No | No | No | |
| PVFNRO2 | double | 15,2 | No | No | No | |
| PVFRRO1 | double | 15,2 | No | No | No | |
| PVFNRO1 | double | 15,2 | No | No | No | |
| PVFPRNT | varchar | 1 | No | No | No | |
| PVFUSER | varchar | 10 | No | No | No | |
pym_holi
| pym_holi | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| recid | int | 20 | Yes | Yes | Yes | |
| HOLDATE | datetime | 0 | No | No | No | |
| HOLTYPE | varchar | 1 | No | No | No | |
| HOLLCCD | varchar | 25 | No | No | No | |
| HOLCOCD | varchar | 25 | No | No | No | |
| HOLDAYS | double | 15,2 | No | No | No | |
pymacct
| pymacct | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| ACCOACD | varchar | 10 | No | No | No | |
| ACCDESC | varchar | 35 | No | No | No | |
| ACCNAME | varchar | 35 | No | No | No | |
| ACCACDE | varchar | 3 | No | No | No | |
pymbank
| pymbank | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| BNKBKCD | varchar | 5 | No | No | No | |
| BNKDESC | varchar | 60 | No | No | No | |
| BNKADDR | varchar | 30 | No | No | No | |
| BNKTCSH | double | 15,2 | No | No | No | |
| BNKACDE | varchar | 3 | No | No | No | |
pymbran
| pymbran | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| BRNCODE | varchar | 5 | No | No | No | |
| BRNNAME | varchar | 35 | No | No | No | |
