Mypmsdb

From SPGC Document Wiki
Revision as of 08:45, 5 October 2016 by Ojt1 (Talk | contribs) (→‎mhw2016)

Jump to: navigation, search

Main Page > Application Development Team > DB Specs > 202.2.2.52

Contents

ahs2016

ahs2016
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment Description
AHSNUMB Varchar 15 No No No Employee No.
AHSGPAY double 15,2 No No No Gross Pay
AHSALLO double 15,2 No No No Allowance
AHS13MO double 15,2 No No No 13th Month Pay
AHSSLVL double 15,2 No No No SL/VL Pay
AHSSVLR double 15,2 No No No SL/VL Remaining
AHSBONS double 15,2 No No No Bonus
AHSTAXD double 15,2 No No No Tax Due
AHSTAXW double 15,2 No No No Tax WithHeld

alphalist_log

alphalist_log
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
EMPNUMB varchar 15 No No No
EMPLNAM varchar 30 No No No
EMPFNAM varchar 30 No No No
EMPMNAM varchar 30 No No No
EMPTINO varchar 30 No No No
EMPTXCD varchar 2 No No No
EMPTAXEXEM double 15,2 No No No
EMPHDTE date 0 No No No
SEPDATE date 0 No No No
EMPBDTE date 0 No No No
EMP13TH double 15,2 No No No
EMPSLPY double 15,2 No No No
EMPUNION double 15,2 No No No
EMPAMEDE double 15,2 No No No
EMPASSSE double 15,2 No No No
EMPAGROSS double 15,2 No No No
EMPAPIBE double 15,2 No No No
EMPATAXC double 15,2 No No No
EMPATAXCDEC double 15,2 No No No
EMPSEPA varchar 1 No No No
EMPCLASSM varchar 10 No No No
TXYMNGR double 15,2 No No No
TXYTXRT double 15,2 No No No
TXYTXAD double 15,2 No No No
TAXI double 15,2 No No No
TAXEXEM double 15,2 No No No
GOV_CONTRIB double 19,2 No No No
EMPBPAY double 15,2 No No No
EMPBALL double 15,2 No No No
TAXDUE double 15,2 No No No
EMPDPCD varchar 30 No No No
EMP13THTAX double 15,2 No No No
MWE varchar 1 No No No
MWESAL double 19,2 No Yes No
_dateproc datetime 0 No Yes No

auditlogs

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

bse2016

bse2016
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
EMPNUMB varchar 15 No No No
EMP13MO double 15,2 No No No
EMPSLPY double 15,2 No No No
EMPVLPY double 15,2 No No No
EMPLPAY double 15,2 No No No
EMPBONS double 15,2 No No No
EMPGPAY double 15,2 No No No
EMPBPAY double 15,2 No No No
EMPLNAM varchar 30 No No No
EMPFNAM varchar 30 No No No
EMPMNAM varchar 30 No No No
EMPCOCD varchar 1 No No No
EMPPCCD varchar 1 No No No
EMPLCCD varchar 3 No No No
EMPDPCD varchar 10 No No No
EMPFDSL double 15,2 No No No
EMPFDVL double 15,2 No No No
EMPSLRE double 15,2 No No No
EMPVLRE double 15,2 No No No
EMPESCD varchar 1 No No No
EMPPMCD varchar 1 No No No
EMPSTAT varchar 1 No No No
EMPPYNO varchar 10 No No No
EMPHDTE date 0 No No No
EMPCTAG varchar 1 No No No
EMPBKCD varchar 5 No No No

bsm_2016sppe

bsm_2016sppe
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
HSTNUMB varchar 15 No No No
EMPNAME varchar 150 No No No
EMPCOCD varchar 1 No No No
HDTE date 0 No No No
ESCD varchar 1 No No No
TBASIC double 15,2 No No No
MMO double 15,2 No No No
13MO double 15,2 No No No
SL_PAY double 15,2 No No No
COMPNAME varchar 60 No No No
DEPT varchar 10 No No No
PCCD varchar 1 No No No
LOCA varchar 3 No No No
DEPTNAME varchar 60 No No No
EMPLNAM varchar 50 No No No
EMPFNAM varchar 50 No No No
EMPMNAM varchar 50 No No No
EMPPMCD varchar 1 No No No
EMPSTAT varchar 1 No No No
EMPBKCD varchar 5 No No No
EMPATMP varchar 25 No No No
SVLSLEN double 15,2 No No No
SLREM double 15,2 No No No
SVLVLEN double 15,2 No No No
VLREM double 15,2 No No No
DAILYTAG varchar 1 No No No

bsm2016

bsm2016
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
EMPNUMB varchar 15 No No No
EMP13MO double 15,2 No No No
EMPSLPY double 15,2 No No No
EMPVLPY double 15,2 No No No
EMPLPAY double 15,2 No No No
EMPBONS double 15,2 No No No
EMPGPAY double 15,2 No No No
EMPBPAY double 15,2 No No No
EMPLNAM varchar 30 No No No
EMPFNAM varchar 30 No No No
EMPMNAM varchar 30 No No No
EMPCOCD varchar 1 No No No
EMPPCCD varchar 1 No No No
EMPLCCD varchar 3 No No No
EMPDPCD varchar 10 No No No
EMPFDSL double 15,2 No No No
EMPFDVL double 15,2 No No No
EMPSLRE double 15,2 No No No
EMPVLRE double 15,2 No No No
EMPESCD varchar 1 No No No
EMPPMCD varchar 1 No No No
EMPSTAT varchar 1 No No No
EMPPYNO varchar 10 No No No
EMPHDTE date 0 No No No
EMPCTAG varchar 1 No No No
EMPBKCD varchar 5 No No No

bsw_2016sppe

bsw_2016sppe
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
HSTNUMB varchar 15 No No No
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

bwe2016

bwe2016
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

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 Description
MHWNUMB varchar 15 No No No Employee No.
MHWCDTE datetime 0 No No No Out Date
MHWTRDY double 15,2 No No No Tardy
MHWUTME double 15,2 No No No Undertime
MHWSLLV double 15,2 No No No Filed SL
MHWVLLV double 15,2 No No No Filed VL
MHWULOA double 15,2 No No No Unpaid LOA
MHWWOLV double 15,2 No No No Without LOA
MHWDLOA double 15,2 No No No Disapproved
MHWOTHR double 15,2 No No No Others
MHWDAYS double 15,2 No No No No.of Days
MHWESCD varchar 1 No No No Employment Status
MHWRRD1 double 15,2 No No No Regular Hours
MHWRRO1 double 15,2 No No No Regular OT
MHWNRD1 double 15,2 No No No Night Shift Hours
MHWNRO1 double 15,2 No No No Night Shift OT
MHWRRD2 double 15,2 No No No Rest Day
MHWRRO2 double 15,2 No No No Rest Day OT
MHWNRO2 double 15,2 No No No Rest Day Night Shift OT
MHWRSD1 double 15,2 No No No Special Holiday Regular Hours
MHWRSO1 double 15,2 No No No Special Holiday Regular OT
MHWNSD1 double 15,2 No No No Special Holiday Night Shift
MHWRSD2 double 15,2 No No No Special Holiday Rest Day
MHWRSO2 double 15,2 No No No Special Holdiay Rest Day OT
MHWNSO1 double 15,2 No No No Special Holiday Night Shift OT
MHWNSD2 double 15,2 No No No Special Holiday Night Shift Rest Day
MHWNSO2 double 15,2 No No No Special Holiday Night Shift Rest Day OT
MHWRLD1 double 15,2 No No No Legal Holiday Regular Hours
MHWRLO1 double 15,2 No No No Legal Holiday OT
MHWNLD1 double 15,2 No No No Legal Holiday Night Shift Hours
MHWRLD2 double 15,2 No No No Legal Holiday Rest Day Hours
MHWRLO2 double 15,2 No No No Legal Holiday Rest Day OT
MHWNLO1 double 15,2 No No No Legal Holiday Night Shitf Hours OT
MHWNLD2 double 15,2 No No No Legal Holiday Night Shift Rest Day Hours
MHWNLO2 double 15,2 No No No Legal Holiday Night Shift Rest Day OT
MHWNRD2 double 15,2 No No No Night Shift Rest Day
MHWLHOL double 15,2 No No No Legal Holiday
MHWSHOL double 15,2 No No No Special Holiday
MHWTHOL double 15,2 No No No
MHWRLEG double 15,2 No No No Rest Day Legal Holiday
MHWRSPC double 15,2 No No No Rest Day Special Holiday
MHWFPER varchar 1 No No No Field Personnel
MHWADSL double 15,2 No No No SL Adjustment
MHWADVL double 15,2 No No No VL Adjustment
MHWDDSL double 15,2 No No No SL Deduction
MHWDDVL double 15,2 No No No VL Deduction
MHWADFL double 15,2 No No No Faternal Leave Adjustment

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 Description
EMPNUMB varchar 15 No No No Employee No.
EMPLNAM varchar 40 No No No Last Name
EMPFNAM varchar 40 No No No First Name
EMPMNAM varchar 40 No No No Middle Name
EMPSXCD varchar 1 No No No Sex Code
EMPBDTE datetime 0 No No No Birth Date
EMPPOBT varchar 50 No No No Place of Birth
EMPRGCD varchar 2 No No No Religion Code
EMPCSCD varchar 1 No No No Civil Status
EMPCADD varchar 40 No No No Address
EMPTOWN varchar 20 No No No Town
EMPCITY varchar 20 No No No City
EMPCZCD varchar 2 No No No Citizenship
EMPTXCD varchar 10 No No No Tax Code
EMPLDTE datetime 0 No No No Tax Status Effectivity Date
EMPSSNO varchar 12 No No No SSS No.
EMPTINO varchar 12 No No No Tin No.
EMPHDTE datetime 0 No No No Date Hired
EMPODTE datetime 0 No No No Orientation Date
EMPPMCD varchar 1 No No No Payment Code
EMPPCCD varchar 1 No No No Payment Class
EMPCOCD varchar 1 No No No Company Code
EMPLCCD varchar 3 No No No Location Code
EMPSTAT varchar 1 No No No Tag for Active
EMPSTDT datetime 0 No No No Date Hold
EMPPINO varchar 12 No No No Pagibig No.
EMPAVOL tinyint 1 No Yes No Tag Below 4,000
EMPPVOL tinyint 1 No Yes No Tag Above 4,000
EMPTDPD varchar 1 No No No Tag for Daily Paid
EMPCBAT varchar 1 No No No Tag for CBA
EMPDPCD varchar 10 No No No Department Code
EMPESCD varchar 1 No No No Employment Status
EMPDPCC varchar 10 No No No Department Charging
EMPINCO varchar 10 No No No Internal Company
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 Description
recid int 25 Yes Yes Yes
CMPCOCD varchar 1 Yes Yes Yes Company Code
CMPNAME Varchar 40 No No No Company Name
CMPSSSN Varchar 12 No No No SSS Number
CMPTINO varchar 12 No No No TIN Number
CMPCADD varchar 50 No No No Address
CMPSLAC varchar 10 No No No Salaries, Wages
CMPSMEC varchar 10 No No No SSS/MED/EC
CMPBKAL varchar 10 No No No Kalookan Bank
CMPOTHR varchar 10 No No No Other Income
CMPHOLD varchar 10 No No No Hold Amount
CMPPIBE varchar 10 No No No Pagibig Acct
CMPTELE varchar 10 No No No Telegraphic
CMPBMAK varchar 10 No No No Makati Bank
CMPCASH varchar 10 No No No Cash Account
CMPTAXC varchar 10 No No No Tax Acct Code
CMPSMEP varchar 10 No No No SSS/MED/EC/PIB
CMPABBR varchar 5 No No No Company Abbr.
CMPMEDP varchar 10 No No No MED/EC/Payable
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 Description
ACIACCD varchar 3 No No No Code
ACIDESC varchar 20 No No No Description

pmmbene

pmmbene
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment Description
BENBNCD varchar 3 No No No Code
BENDESC varchar 15 No No No Description

pmmcsta

pmmcsta
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment Description
CSTCSCD varchar 1 No No No Code
CSTDESC varchar 15 No No No Description

pmmctzp

pmmctzp
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment Description
CTZCZCD varchar 2 No No No Code
CTZDESC varchar 30 No No No Description

pmmdept

pmmdept
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment Description
recid int 25 Yes Yes Yes
DEPDPCD varchar 10 No No No Department Code
DEPCPCD varchar 1 No No No Company Code
DEPNAME varchar 35 No No No Department Name
DEPINCO varchar 2 No No No Internal Comp.
DEPSLWG varchar 8 No No No Salaries/Wages
DEPSSSM varchar 8 No No No SSS/MED/EC
DEPABBR varchar 5 No No No Abbreviation
DEPCOCD varchar 1 No No No Company Code
DEPFLAG varchar 1 No No No Flag for Remit.
DEPBONS varchar 8 No No No Bonus Account
DEPBENE varchar 8 No No No Benifits Acct.
DEPOCDE varchar 3 No No No Old Department
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 Description
ICLICCD varchar 3 No No No Infraction Code
ICLDESC varchar 15 No No No Description

pmmjblv

pmmjblv
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment Description
JBLJLCD varchar 2 No No No Job Level Code
JBLDESC varchar 30 No No No Description

pmmjblv_essi

pmmjblv_essi
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
JBLJLCD varchar 2 No No No
JBLDESC varchar 30 No No No
CASHBOND_AMNT double 15,2 No No No
SDSACODE varchar 3 No No No

pmmlnge

pmmlnge
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment Desctiption
LNGCODE varchar 2 No No No Code
LNGDESC varchar 15 No No No Description

pmmloca

pmmloca
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment Description
LOCCODE varchar 3 No No No Location Code
LOCDESC varchar 20 No No No Description

pmmmach

pmmmach
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment Description
MACMCCD varchar 3 No No No Code
MACDESC varchar 25 No No No Description

pmmmart

pmmmart
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment Description
PARPRCD varchar 3 No No No Code
PARDESC varchar 15 No No No Description

pmmpact

pmmpact
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment Description
PACPACD varchar 3 No No No Code
PACDESC varchar 20 No No No Description

pmmposn

pmmposn
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment Description
POSPSCD varchar 3 No No No Position Code
POSDESC varchar 70 No No No Description
POSJLCD varchar 0 No No No Job Level Code
OCODE varchar 3 No No No Old Posn.Code

pmmrelg

pmmrelg
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment Description
RELRGCD varchar 2 No No No Code
RELDESC varchar 20 No No No Description

pmmrltp

pmmrltp
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment Description
RLTRLCD varchar 2 No No No Code
RLTDESC varchar 15 No No No Description
RLTSXCD varchar 1 No No No Sex Code

pmmsect

pmmsect
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment Description
SECSCCD varchar 2 No No No Section Code
SECNAME varchar 25 No No No Section Name

pmmshf2

pmmshf2
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment Description
SHFSFCD varchar 3 No No No Shift Code
SHFRDCD varchar 1 No No No Resday Code
SHFAMIN varchar 4 No No No AM In
SHFAMOT varchar 4 No No No AM Out
SHFPMIN varchar 4 No No No PM In
SHFPMOT varchar 4 No No No PM Out
SHFGPRD varchar 2 No No No Grace Period
SHFSTAG tinyint 1 No No No Night Shift Tag

pmmshfv

pmmshfv
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment Description
SHVSFCD varchar 3 No No No Shift Code
SHVRDCD varchar 1 No No No Rest Day Code
SHVAMIN varchar 4 No No No AM In
SHVPMOT varchar 4 No No No PM Out

pmmskll

pmmskll
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment Description
SKLSKCD varchar 2 No No No Code
SKLDESC varchar 20 No No No Description

pmmtaxt

pmmtaxt
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment Description
TAXTXCD varchar 10 No No No Tax Code
TAXDESC varchar 30 No No No Description
TAXEXEM double 15,2 No No No Exemption

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 Description
CHDNUMB varchar 15 No No No Employee No.
CHDLNAM varchar 15 No No No Last Name
CHDFNAM varchar 20 No No No First Name
CHDMNAM varchar 15 No No No Middle Name
CHDBDTE datetime 0 No No No Birth Date
CHDSXCD varchar 1 No No No Sex Code

pmtchrr

pmtchrr
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment Description
CHRNUMB varchar 15 No No No Employee No.
CHRLNAM varchar 15 No No No Last Name
CHRFNAM varchar 20 No No No First Name
CHRMNAM varchar 15 No No No Middle Name
CHRADDR varchar 30 No No No Address
CHRTELE varchar 12 No No No Telephone No.
CHROCCU varchar 15 No No No Occupation
CHRYRKW double 15,5 No No No Year Worked

pmtcmdn

pmtcmdn
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment Description
CMDNUMB varchar 15 No No No Employee No.
CMDDATE datetime 0 No No No Commendation Date
CMDAWRD varchar 15 No No No Award Received

pmtdpdt

pmtdpdt
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment Description
DPDNUMB varchar 15 No No No Employee No.
DPDRLCD varchar 2 No No No Relationship Code
DPDLNAM varchar 15 No No No Last Name
DPDFNAM varchar 20 No No No First Name
DPDMNAM varchar 15 No No No Middle Name
DPDBDTE datetime 0 No No No Birth Date
DPDSXCD varchar 1 No No No Sex Code

pmtdrvl

pmtdrvl
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment Description
DRVNUMB varchar 15 No No No Employee No.
DRVLCNO varchar 15 No No No License No.
DRVPLCE varchar 15 No No No Place Issued
DRVDATE datetime 0 No No No Date Issued

pmteduc

pmteduc
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment Desciption
EDUNUMB varchar 15 No No No Employee No.
EDUSCHL varchar 30 No No School No
EDUYRGD double 15,5 No No No Year Graduated
EDUCOUR varchar 30 No No No Course
EDUHONR varchar 30 No No No Honor Received

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_license

pmtemp_license
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
RECID int 10 Yes Yes Yes
EMPNUMB varchar 15 No Yes No
LICCNTRY varchar 45 No Yes No
LICTYPE varchar 45 No Yes No
LICNUMBER varchar 45 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 Description
EMPNUMB varchar 15 No No No Employee No.
EMPLNAM varchar 15 No No No LastName
EMPFNAM varchar 20 No No No FirstName
EMPMNAM varchar 15 No No No MiddleName
EMPSXCD varchar 1 No No No Sex Code
EMPBDTE datetime 0 No No No Birthdate
EMPPOBT varchar 15 No No No Place of Birth
EMPRGCD varchar 2 No No No Religion Code
EMPCSCD varchar 1 No No No Civil Status
EMPCADD varchar 40 No No No Address
EMPTOWN varchar 20 No No No Town
EMPCITY varchar 20 No No No City
EMPCZCD varchar 2 No No No Citizenship Code
EMPTXCD varchar 10 No No No Tax Code
EMPLDTE datetime 0 No No No Tax Status Effectivity Date
EMPSSNO varchar 12 No No No SSS No.
EMPTINO varchar 11 No No No TIN No.
EMPHDTE datetime 0 No No No Date Hired
EMPODTE datetime 0 No No No Orientation Date
EMPPMCD varchar 1 No No No Payment Code
EMPPCCD varchar 1 No No No Payment Class
EMPCOCD varchar 1 No No No Company Code
EMPLCCD varchar 3 No No No Location Code
EMPSTAT varchar 1 No No No Tag for Active
EMPSTDT datetime 15,2 No No No Date Hold
EMPPINO varchar 12 No No No Pagibig No.
EMPAVOL tinyint 1 No No No Tag Below 4,000
EMPPVOL tinyint 1 No No No Tag Above 4,000
EMPTDPD varchar 1 No No No Tag for Daily Paid
EMPCBAT varchar 1 No No No Tag for CBA
EMPDPCD varchar 10 No No No Department Code
EMPESCD varchar 1 No No No Employment Status
EMPDPCC varchar 10 No No No Department Charging
EMPINCO varchar 1 No No No Internal Company
EMPALLO double 15,2 No No No Allowance
EMPFEPF varchar 1 No No No Tag for Downloaded EPF
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

pmtemplang

pmtemplang
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 Description
FAMNUMB varchar 15 No No No Employee No.
FAMRLCD varchar 2 No No No Relationhip Code
FAMLNAM varchar 15 No No No Last Name
FAMFNAM varchar 20 No No No First Name
FAMMNAM varchar 15 No No No Middle Name
FAMBDTE datetime 0 No No No Birth Date
FAMSXCD varchar 1 No No No Sex Code
FAMOCCU varchar 15 No No No Occupation
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 Description
FRRNUMB varchar 8 No No No Employee No.
FRRRLCD varchar 2 No No No Relation Code
FRRENUM varchar 30 No No No Name

pmtgvte

pmtgvte
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment Description
GVTNUMB varchar 15 No No No Emplyee No
GVTNTRE varchar 20 No No No Nature of Exam
GVTDATE varchar 4 No No No Examination Date
GVTRATE double 15,5 No No No Rate

pmtilln

pmtilln
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment Description
ILLNUMB varchar 15 No No No Employee No.
ILLNTRE varchar 15 No No No Nature of Illness
ILLREMK varchar 10 No No No Remarks

pmtinfr

pmtinfr
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment Description
INFNUMB varchar 15 No No No Employee No.
INFDATE datetime 0 No No No Infraction Date
INFICCD varchar 2 No No No Infracion Classification Code
INFACCD varchar 3 No No No Action Against Infraction Code

pmtvip2

pmtvip2
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment Description
VIPNUMB varchar 15 No No No Employee No.
VIPEDTE datetime 0 No No No Effectivity Date
VIPBPAY double 18,2 No No No Basic Pay
VIPALLO double 18,2 No No No Allowance

pmtlgef

pmtlgef
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment Description
LGENUMB varchar 15 No No No Employee No.
LGELACD varchar 2 No No No Language Code

pmtmarr

pmtmarr
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment Description
MARNUMB varchar 15 No No No Employee No.
MARLNAM varchar 15 No No No Last Name
MARFNAM varchar 20 No No No First Name
MARMNAM varchar 15 No No No Middle Name
MARBDTE datetime 0 No No No Birth Date
MARMDTE datetime 0 No No No Marriage Date

pmtmchd

pmtmchd
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment Description
MCHNUMB varchar 15 No No No Employee No.
MCHCODE varchar 2 No No No Machine Code

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 Description
NOTNUMB varchar 15 No No No Employee No.
NOTRLCD varchar 2 No No No Relationship Code
NOTLNAM varchar 15 No No No Last Name
NOTFNAM varchar 20 No No No First Name
NOTMNAM varchar 15 No No No Middle Name
NOTADDR varchar 30 No No No Address

pmtntph

pmtntph
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment Description
NTPNUMB varchar 15 No No No Employee No.
NTPDESC varchar 15 No No No Name
NTPTELE varchar 12 No No No Telephone No.

pmtprem

pmtprem
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment Description
PRENUMB varchar 15 No No No Employee No.
PRECONM varchar 20 No No No Company Name
PRECONR varchar 15 No No No Company Address
PRESDTE datetime 0 No No No Start Date
PREPOSN varchar 15 No No No Position
PREJDSC longtext 0 No No No Job Description
PREGPAY double 15,5 No No No Gross Pay
PRETAXW double 15,5 No No No Tax WithHeld
PRE13MO double 15,5 No No No Month Pay
PREPTAG tinyint 1 No Yes No Logical Value

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 Description
SEMNUMB varchar 15 No No No Employee No.
SEMNTRE varchar 40 No No No Nature of Seminar
SEMSDTE datetime 0 No No No Start Date
SEMEDTE datetime 0 No No No End Date
SEMPLAC varchar 15 No No No Place

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

pmtskhb

pmtskhb
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment Description
SKHNUMB varchar 15 No No No Employee No.
SKHSKCD varchar 2 No No No Description

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 Yes Yes Yes
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 Description
ACCOACD varchar 10 No No No Account Code
ACCDESC varchar 35 No No No Description
ACCNAME varchar 35 No No No Account Name
ACCACDE varchar 3 No No No Old Acct. Code

pymbank

pymbank
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment Description
BNKBKCD varchar 5 No No No Bank Code
BNKDESC varchar 60 No No No Description
BNKADDR varchar 30 No No No Address
BNKTCSH double 15,2 No No No 02
BNKACDE varchar 3 No No No Account Code

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

pymcoac

pymcoac
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment Description
CACCOCD varchar 1 No No Company Code No
CACBKCD varchar 5 No No No Bank Code
CACACCT varchar 17 No No No Account Code

pymholi

pymholi
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment Description
RECID int 20 Yes Yes Yes
HOLDATE datetime 0 No No No Holiday Date
HOLTYPE varchar 1 No No No Holiday Type
HOLLCCD varchar 3 No No No Location
HOLDAYS double 15,5 No No No No.of Days

pymot

pymot
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
recid int 25 Yes Yes Yes
OT_CODE varchar 20 No No No
OT_COCD varchar 15 No No No
OT_DESC varchar 60 No No No
OT_SDESC varchar 60 No No No
OT_RATE double 10,3 No No No
OT_AMT_RATE double 15,3 No No No
OT_ED_CODE varchar 25 No No No
OT_PCMP_GRP_CODE varchar 25 No No No
OT_ACTIVE varchar 1 No No No
OT_MFIELD varchar 25 No No No
OT_FORMULA varchar 15 No No No
OT_REMK varchar 25 No No No
OT_PREM double 10,3 No No No

pympymt

pympymt
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
recid int 25 Yes Yes Yes
PYMNUMB varchar 15 No No No
PYMSDCD varchar 3 No No No
PYMSDDT date 0 No No No
PYMDATE date 0 No No No
PYMAMNT double 15,2 No No No
PYMREFDCN varchar 40 No No No
PYMREMARK varchar 40 No No No
PYMPERD_LOG date 0 No No No
PYMUSER varchar 10 No No No
PYMDLOG datetime 0 No No No

pymsdmf

pymsdmf
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
SDMSDCD int 3 No No No
SDMDESC varchar 30 No No No
SDMSDTP varchar 1 No No No
SDMSDSA varchar 1 No No No
SDMOACD varchar 10 No No No
SDMCODE varchar 3 No No No
SDMCOTP varchar 1 No No No
SDMFLAG varchar 1 No No No
SDMACDE varchar 3 No No No

pymslvl

pymslvl
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
SVLEDTE date 0 No No No
SVLETLE double 15,2 No No No

pymslvo

pymslvo
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
SVOEDTE date 0 No No No
SVOETLE double 15,2 No No No

pymslvv

pymslvv
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
SVVEDTE date 0 No No No
SVVETLE double 15,2 No No No

pymtaxy

pymtaxy
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment Description
TXYMNGR double 15,2 No No No Minimum Gross
TXYMXGR double 15,2 No No No Maximum Gross
TXYTXAD double 15,2 No No No Tax Deduction
TXYTXRT double 15,2 No No No Rate

pymtsrg

pymtsrg
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
TSRSQNO varchar 2 No No No
TSRTXCD varchar 10 No No No
TSRSLRY double 15,2 No No No

pytchro

pytchro
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
CRONUMB varchar 8 No No No
CROCRNO varchar 12 No No No

pytsdsa

pytsdsa
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
SDARECID int 20 No Yes Yes
SDANUMB varchar 15 No No No
SDADATE datetime 0 No No No
SDASDCD varchar 3 No No No
SDASAMT double 15,2 No No No
SDAINST double 15,2 No No No
SDAEDTE datetime 0 No No No
SDABALC double 15,2 No No No
SDAUNPD double 15,2 No No No
SDAREMK varchar 10 No No No
SDAINNO double 15,2 No No No
SDADCNO varchar 15 No No No
SDADCDT datetime 0 No No No
SDASDTP varchar 1 No No No
SDASDSA varchar 1 No No No
SDATAGD varchar 1 No No No
SDAPRNT varchar 1 No No No
SDAUSER varchar 10 No No No
SDAPOST varchar 1 No No No
SDAENDT datetime 0 No No No
SDATRAN varchar 1 No No No
SDALAMT double 15,2 No No No
SDAPVRECID int 20 No No No

sdsaupload

sdsaupload
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
SDARECID int 20 Yes Yes Yes
SDANUMB varchar 15 No No No
SDADATE datetime 0 No No No
SDASDCD varchar 3 No No No
SDASAMT double 15,2 No No No
SDAINST double 15,2 No No No
SDAEDTE datetime 0 No No No
SDABALC double 15,2 No No No
SDAUNPD double 15,2 No No No
SDAREMK varchar 10 No No No
SDAINNO double 15,2 No No No
SDADCNO varchar 30 No No No
SDADCDT datetime 0 No No No
SDASDTP varchar 1 No No No
SDASDSA varchar 1 No No No
SDATAGD varchar 1 No No No
SDAPRNT varchar 1 No No No
SDAUSER varchar 10 No No No
SDAPOST varchar 1 No No No
SDAENDT datetime 0 No No No
SDATRAN varchar 1 No No No
SDALAMT double 15,2 No No No
SDAPVRECID varchar 20 No No No
SDACLASS varchar 3 No Yes No
SDAMARK varchar 1 No Yes No

slvlrecon2016

slvlrecon2016
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
LVAB_RECID int 20 No Yes Yes
LVAB_ENUMB varchar 15 No No No
LVAB_EDATE date 0 No No No
LVAB_SL double 15,2 No No No
LVAB_VL double 15,2 No No No
LVAB_USER varchar 10 No No No
PAYPERIOD date 0 No No No

sss_templ

sss_templ
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
recid int 20 Yes Yes Yes
SAL_LOW double 15,2 No No No
SAL_HIGH double 20,2 No No No
MO_SAL_CREDIT double 15,2 No No No
ER double 15,2 No No No
EE double 15,2 No No No
TOTAL double 15,2 No No No
EC_ER_ECCM double 15,2 No No No
ER_TOTAL double 15,2 No No No
ER_EC_TOTAL double 15,2 No No No
SE_VM_OFW_TOTAL double 15,2 No No No

svl2016

svl2016
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment Description
SVLNUMB varchar 15 No No No Employee No.
SVLEDTE datetime 0 No No No Date
SVLSLEN double 15,2 No No No SL Entitlement
SVLVLEN double 15,2 No No No VL Entitlement
SVLFLEN double 15,2 No No No FL Emtitlement
SVLSLRE double 15,2 No No No SL Remaining
SVLVLRE double 15,2 No No No VL Remaining
SVLFLRE double 15,2 No No No FL Remaining

syslogs

syslogs
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
recid int 30 Yes Yes Yes
errid varchar 25 No No No
LOG_USER varchar 25 No Yes No
LOG_MODULE varchar 25 No Yes No
LOG_DATE datetime 0 No Yes No
LOG_ENUMB varchar 25 No Yes No
LOG_FIELD varchar 25 No Yes No
LOG_OLDVAL varchar 25 No Yes No
LOG_NEWVAL varchar 25 No Yes No
LOG_SQLEXEC longtext 0 No No No
LOG_CHANGE varchar 25 No Yes No
LOG_IPADDR varchar 25 No Yes No
LOG_PRNT varchar 25 No Yes No

tblsequence

tblsequence
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
idtblsequence int 10 Yes Yes Yes
posasc1 int 10 No Yes No
posasc2 int 10 No Yes No
posno int 10 No Yes No

threshold

threshold
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
recid int 30 Yes Yes Yes
COCD varchar 25 No No No
MO_RATE double 20,2 No No No
DL_RATE double 15,2 No No No
WK_MAX_OT double 15,2 No No No
WK_MAX_GROSS double 15,2 No No No
SM_MAX_OT double 15,2 No No No
SM_MAX_GROSS double 15,2 No No No
ENCD datetime 0 No No No
USERN varchar 25 No No No

tkf2016

tkf2016
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
MHENUMB varchar 15 Yes Yes Yes
MHCDTE date 0 No No No
MHCOCD varchar 1 No No No
MHPCCD varchar 1 No No No
MHUSER varchar 10 No No No
MHDATEE datetime 0 No No No
MHDPCD varchar 10 No No No
MHPOSTED varchar 1 No No No

trxsdsa

trxsdsa
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
recid int 30 Yes Yes Yes
recid_sdsa varchar 30 No No No
LNSNUMB varchar 15 No No No
LNSSDCD varchar 3 No No No
LNSDATE datetime 0 No No No
LNSCOFF varchar 3 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
LNSPSNO varchar 1 No No No
LNSTAXABLE varchar 1 No No No
LNSSDSA varchar 1 No No No
LNSPOSTED varchar 1 No No No
LNSFIXDED varchar 1 No No No

ucpbsample

ucpbsample
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
EMPNMBER varchar 255 No No No
EMPNAME varchar 255 No No No
CRDNMBER varchar 255 No No No
ACNTNMBER varchar 255 No No No

un2016

un2016
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
UNTNUMB varchar 15 No No No
UNTDATE datetime 0 No No No
UNTSTME varchar 4 No No No
UNTETME varchar 4 No No No

undt2016

undt2016
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
recid int 30 Yes Yes Yes
UN_ENUMB varchar 25 No No No
UN_WS_CODE varchar 25 No No No
UN_DYCODE varchar 3 No No No
UN_DYTYPE varchar 25 No No No
UN_LCCD varchar 25 No No No
UN_DPCD varchar 25 No No No
UN_COCD varchar 25 No No No
UN_CDTE date 0 No No No
UN_DTETRX date 0 No No No
UN_SAMIN datetime 0 No No No
UN_SAMOUT datetime 0 No No No
UN_SPMIN datetime 0 No No No
UN_SPMOUT datetime 0 No No No
UN_FTIME datetime 0 No No No
UN_TTIME datetime 0 No No No
UN_USER varchar 25 No No No
UN_ENCD datetime 0 No No No
UN_REMK longtext 0 No No No
UN_FLAG varchar 1 No No No

uw2016

uw2016
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
UNTNUMB varchar 15 No No No
UNTDATE datetime 0 No No No
UNTSTME varchar 4 No No No
UNTETME varchar 4 No No No

wo

wo
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
recid int 20 Yes Yes Yes
WO_COCD varchar 4 No No No
WO_SEQN varchar 4 No No No
WO_REGION varchar 25 No No No
WO_REGAREA varchar 25 No No No
WO_CCLASS varchar 25 No No No
WO_PCLASS varchar 1 No No No
WO_BASIC double 15,2 No No No
WO_ALLO double 15,2 No No No
WO_REMK varchar 1 No No No

wo_class

wo_class
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
recid int 20 Yes Yes Yes
WO_CLASS_CODE varchar 25 No No No
WO_CLASS_NAME varchar 40 No No No

wo_region

wo_region
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
WO_SEQN varchar 4 No No No
WO_REGION_CODE varchar 25 No No No
WO_REGION_NAME varchar 50 No No No
WO_REMK varchar 1 No No No

wo_region_area

wo_region_area
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
WO_SEQN varchar 4 No No No
WO_REGION_CODE varchar 25 No No No
WO_REGION_AREA varchar 25 No No No
WO_AREA_NAME longtext 0 No No No
WO_REMK varchar 1 No No No

year_co

year_co
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
yco_year varchar 4 No No No
yco_post varchar 1 No No No

Main Page > Application Development Team > DB Specs > 202.2.2.52

Retrieved from "http://115.85.30.86:286/spgcwiki/index.php?title=Mypmsdb&oldid=4282"