Mypaydb

Main Page > Application Development Team > DB Specs > 202.2.2.52

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
AHSTAXW	double	15,2	No	No	No
EMPBALL	double	15,2	No	No	No
TAXDUE	double	15,2	No	No	No
EMPDPCD	varchar	30	No	No	No
EMP13THTAX	double	15,2	No	No	No
MWE	varchar	1	No	No	No
MWESAL	double	19,2	No	Yes	No
_dateproc	datetime	0	No	Yes	No

alphalist_log_mwe

alphalist_log_mwe
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	varbinary	10	No	No	No
EMPSEPADTE	date	0	No	No	No
EMPBDTE	date	15	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
EMPREGION	varchar	15	No	No	No
HOLPAY	double	15,2	No	No	No
OTPAY	double	15,2	No	No	No
NSDPAY	double	15,2	No	No	No
RATEDAY	double	15,2	No	No	No
RATEMO	double	19,2	No	No	No
RATEYR	double	15,2	No	No	No
EMPDPCD	varchar	30	No	No	No
MWEGROSS	double	15,2	No	No	No
MWESAL	double	15,2	No	Yes	No
MWEFLAG	varchar	1	No	No	No
DATEPROC	datetime	0	No	No	No

attlogs_upld

attlogs_upld
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
recid	int	25	Yes	Yes	Yes
ATTL_USER	varchar	25	No	No	No
ATTL_FILE	varchar	100	No	No	No
ATTL_DATE	datetime	0	No	No	No
ATTL_OFILE	varchar	100	No	No	No
ATTL_RMARK	varchar	25	No	No	No

bankdtl

bankdtl
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
recid	int	25	No	Yes	No
BNKBKCD	Varchar	3	No	No	No
BNKCOCD	Varchar	25	No	No	No
BNKPCLASS	varchar	25	No	No	No
BNKACCTTYPE	varchar	25	No	No	No
BNKACCT	varchar	25	No	No	No
BNKACCT_13MO	varchar	25	No	No	No
BNKCONTPERSON	varchar	150	No	No	No
BNKCONTPOSITION	varchar	150	No	No	No
BNKADDR	varchar	150	No	No	No
BNKDISBCODE	varchar	15	No	No	No
BNKDISBNAME	varchar	150	No	No	No
RPT_CHECK_REVIEWED	varchar	150	No	No	No
RPT_CHECK_REVIEWED_POSI	varchar	150	No	No	No
RPT_NOTED	varchar	150	No	No	No
RPT_NOTED_POSI	varchar	150	No	No	No
RPT_APPROVED	varchar	150	No	No	No
RPT_APPROVED_POSI	varchar	150	No	No	No
RPT_FINAL_APPROVED	varchar	150	No	No	No
RPT_FINAL_APPROVED_POSI	varchar	150	No	No	No

birtax2316_2016

birtax2316_2016
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
recid	int	20	Yes	Yes	Yes
EMPTINNO	Varchar	15	No	No	No
EMPCOCD	Varchar	3	No	No	No
EMPMWE_FLAG	varchar	3	No	No	No
EMPSEP_FLAG	varchar	3	No	No	No
EMPTXCD	varchar	10	No	No	No
EMPNAME	varchar	150	No	No	No
EMPADDR	varchar	150	No	No	No
EMPBDAY	date	0	No	No	No
MINWAGE_PER_DATE	double	15,2	No	No	No
MINWAGE_PER_MONTH	double	15,2	No	No	No
EMPLOYER_NAME	varchar	150	No	No	No
EMPLOYER_ADDR	varchar	150	No	No	No
P4GPAY_PRES	double	15,2	No	No	No
P4NONTX_EXMPT	double	15,2	No	No	No
P4TX_COMP_PRES	double	15,2	No	No	No
P4TX_COMP_PREV	double	15,2	No	No	No
P4GROSS_TAX_COMP	double	15,2	No	No	No
P4TOT_EXEMPT	double	15,2	No	No	No
P4PREMIUM_MEDE	double	15,2	No	No	No
P4NET_TAX_COMP	double	15,2	No	Yes	No
P4TAX_DUE	double	15,2	No	No	No
P4TAXWITH_PRES	double	15,2	No	No	No
P4TEXWITH_PREV	double	15,2	No	No	No
P4_ADJUSTED_TAX_AMNT	double	15,2	No	No	No
NTBPAY	double	15,2	No	No	No
NTHOLPAY	double	15,2	No	No	No
NTOTPAY	double	15,2	No	No	No
NTNTPAY	double	15,2	No	No	No
NTHAZPAY	double	15,2	No	No	No
NTMPAY13	double	15,2	No	No	No
NTDEMINIMIS	double	15,2	No	No	No
NTGOV_CONT	double	15,2	No	No	No
NTOTHER_COMP	double	15,2	No	No	No
NTNONTAX_COMP	double	15,2	No	No	No
TXBPAY	double	15,2	No	No	No
TXREPRESENTATION	double	15,2	No	No	No
TXTRANSPO	double	15,2	No	No	No
TXCOLA	double	15,2	No	No	No
TXHOUSE_ALLO	double	15,2	No	No	No
TXCOMMISION	double	15,2	No	No	No
TXPROF_SHARING	double	15,2	No	No	No
TXDIRECTOR_FEE	double	15,2	No	No	No
TXMPAY13	double	15,2	No	No	No
TXHAZPAY	double	15,2	No	No	No
TXOTPAY	double	15,2	No	No	No
TXTAX_COMP	double	150	No	No	No
PERIOD_FROM	date	0	No	No	No
PERIOD_TO	date	0	No	No	No
EMPNUMB	varchar	15	No	No	No
EMPPCCD	varchar	2	No	No	No
EMPTAXREF	double	15,2	No	No	No

bonus_simul2016

bonus_simul2016
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
AHS13MO	double	15,2	No	No	No
AHSBONS	double	15,2	No	No	No
AHSSLRE	double	15,2	No	No	No
AHSVLRE	double	15,2	No	No	No
AHSSLPY	double	15,2	No	No	No
AHSVLPY	double	15,2	No	No	No
AHSLTAG	tinyint	1	No	No	No
AHSCTAG	varchar	1	No	No	No
AHSLPAY	double	15,2	No	No	No
AHSPYNO	varchar	10	No	No	No
AHSSTAT	varchar	1	No	No	No
AHSPMCD	varchar	1	No	No	No
AHSESCD	varchar	1	No	No	No
AHSPCCD	varchar	1	No	No	No
AHSBKCD	varchar	5	No	No	No
AHSCOCD	varchar	1	No	No	No
AHSLCCD	varchar	3	No	No	No
AHSFDVL	double	15,2	No	No	No
AHSFDSL	double	15,2	No	No	No
AHSBPAY	double	15,2	No	No	No
AHSDPCD	varchar	10	No	No	No

bonus2016

bonus2016
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
AHS13MO	double	15,2	No	No	No
AHSBONS	double	15,2	No	No	No
AHSSLRE	double	15,2	No	No	No
AHSVLRE	double	15,2	No	No	No
AHSSLPY	double	15,2	No	No	No
AHSVLPY	double	15,2	No	No	No
AHSLTAG	tinyint	1	No	No	No
AHSCTAG	varchar	1	No	No	No
AHSLPAY	double	15,2	No	No	No
AHSPYNO	varchar	10	No	No	No
AHSSTAT	varchar	1	No	No	No
AHSPMCD	varchar	1	No	No	No
AHSESCD	varchar	1	No	No	No
AHSPCCD	varchar	1	No	No	No
AHSBKCD	varchar	5	No	No	No
AHSCOCD	varchar	1	No	No	No
AHSLCCD	varchar	3	No	No	No
AHSFDVL	double	15,2	No	No	No
AHSFDSL	double	15,2	No	No	No
AHSBPAY	double	15,2	No	No	No
AHSDPCD	varchar	10	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	double	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

bsw2016

bsw2016
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	3	No	No	No
EMPLNAM	varchar	50	No	No	No
EMPLNAM	double	15,2	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

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	3	No	No	No
EMPLNAM	varchar	50	No	No	No
EMPLNAM	double	15,2	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

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

ccback

ccback
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
mymodule	varchar	20	No	No	No
myremark	varchar	1	No	No	No
myuser	varchar	10	No	No	No
mydate	datetime	0	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

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

dtr_allow_entry_maintenance

dtr_allow_entry_maintenance
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
DTRAEMRCODE	varchar	20	No	No	No
DTRAEMRDESC	varchar	40	No	No	No

dtr2016

dtr2016
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
DTRCODE	Varchar	3	No	No	No
EMPLNAM	Varchar	30	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

dtrallow2016

dtrallow2016
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
DTRAENUMB	Varchar	15	No	No	No
DTRACDTE	date	0	No	No	No
DTRADATE	date	0	No	No	No
DTRARCODE	varchar	25	No	No	No
DTRAOR	varchar	100	No	No	No
DTRAUSER	varchar	10	No	No	No
DTRAENCD	datetime	0	No	No	No
DTRAFLAG	varchar	1	No	No	No
DTRAABY	varchar	10	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	25	No	No	No
DT_DYTYPE	varchar	30	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_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_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_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
DTWNUMB	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

empfix_allo

empfix_allo
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
EMPNUMB	Varchar	15	No	Yes	No
AMOUNT	double	15,2	No	Yes	No
USERID	varchar	45	No	Yes	No
DTENCODED	datetime	0	No	Yes	No

esapgl_empl

esapgl_empl
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
recid	int	30	Yes	Yes	Yes
EMPNUMB	varchar	15	No	No	No
EMPLNAM	varchar	35	No	No	No
EMPFNAM	varchar	35	No	No	No
EMPMNAM	varchar	35	No	No	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	No	No	No
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	No	No	No
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

hstmwe2016

hstmwe2016
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
HSTNUMB	varchar	15	No	No	No
HSTCDTE	date	0	No	No	No
HSTPCCD	varchar	1	No	No	No
HSTCOCD	varchar	1	No	No	No
HSTESCD	varchar	1	No	No	No
HSTTAXC	double	15,2	No	No	No
HSTMD	varchar	1	No	No	No
HSTMWE	varchar	1	No	No	No

ins2016

ins2016
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
recid	int	25	Yes	Yes	Yes
LNSNUMB	varchar	15	No	No	No
LNSSDCD	varchar	3	No	No	No
LNSDATE	datetime	0	No	No	No
LNSAMNT	double	15,2	No	No	No
LNSBALC	double	15,2	No	No	No
LNSUNPD	datetime	0	No	No	No

lns2016

lns2016
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
recid	int	25	Yes	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	No	No
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	No	No
LOACOFF	date	0	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
LOAHOUR	double	15,2	No	No	No
LOAHRPD	double	15,2	No	No	No
LOAASTA	tinyint	1	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	date	0	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

mhr2016

mhr2016
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
MHRNUMB	varchar	15	No	No	No
MHRCDTE	datetime	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
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
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

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	double	15,2	No	No	No
MHWRSO1	double	15,2	No	No	No
MHWNSD1	double	15,2	No	No	No
MHWRSD2	double	15,2	No	No	No
MHWRSO2	double	15,2	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

mnhr_log2016

MHRRSO2

mnhr_log2016
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
MHRNUMB	varchar	15	No	No	No
DTRDATE	date	0	No	No	No
DAYCODE	varchar	2	No	No	No
MHRCDTE	datetime	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
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
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

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
FP_INOUT	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_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_cost_center_comp

mst_cost_center_comp
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
recid	int	11	Yes	Yes	Yes
COCD_DUE	varchar	25	No	No	No
DPCD	varchar	25	No	No	No
COCD	varchar	25	No	No	No
DPCD_MAP	varchar	25	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_gl_account

mst_gl_account
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_GLCD	varchar	25	No	No	No
NEW_DESC	varchar	100	No	No	No
OLD_GLCD	varchar	25	No	No	No
OLD_DESC	varchar	100	No	No	No

mst_worksched

mst_worksched
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
recid	int	30	Yes	Yes	Yes
WS_CODE	varchar	25	No	No	No
WS_DESC	varchar	50	No	No	No
WS_DYCODE	varchar	25	No	No	No
WS_AMIN	varchar	6	No	No	No
WS_AMOUT	varchar	6	No	No	No
WS_PMIN	varchar	6	No	No	No
WS_PMOUT	varchar	6	No	No	No
WS_GPERD	double	15,2	No	No	No
WS_NSSTART	varchar	6	No	No	No
WS_NSEND	varchar	6	No	No	No
WS_MHC_GROUP	varchar	1	No	No	No
WS_MINS_AUTO_AMHDAY	double	15,2	No	No	No
WS_MINS_AUTO_AMWDAY	double	15,2	No	No	No
WS_MINS_MIN_OT	double	15,2	No	No	No
WS_MINS_AUTO_PMHDAY	double	15,2	No	No	No
WS_MINS_AUTO_PMWDAY	double	15,2	No	No	No
WS_MINS_CBA	double	15,2	No	No	No
WS_MINS_CBF	varchar	1	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

oasdsa

oasdsa
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	SDADCDT	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	Yes	Yes

ob2016

ob2016
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
OBTNUMB	varchar	8	No	No	No
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	varchar	1	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	1	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

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

pmhrfempl

pmhrfempl
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	30	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
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	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
EMPDPROC	datetime	0	No	No	No

pmmcmpy

pmmcmpy
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment	Description
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	Yes	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

pmmdept

pmmdept
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment	Description
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

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

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	Last Name
EMPFNAM	varchar	20	No	No	No	First Name
EMPMNAM	varchar	15	No	No	No	Middle Name
EMPSXCD	varchar	1	No	No	No	Sex Code
EMPBDTE	datetime	0	No	No	No	Birth Date
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	0	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

pmtemve

pmtemve
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment	Description
recid	int	25	Yes	Yes	Yes
EMVNUMB	varchar	15	No	No	No	Employee No.
EMVEDTE	datetime	0	No	No	No	Effectivity Date
EMVSCCD	varchar	2	No	No	No	Section Code
EMVSFCD	varchar	3	No	No	No	Shift Code
EMVLCCD	varchar	3	No	No	No	Location
EMVDPCD	varchar	10	No	No	No	Department Code
EMVPSCD	varchar	3	No	No	No	Position Code
EMVBPAY	double	15,5	No	No	No	Basic Pay
EMVALLO	double	15,5	No	No	No	Allowance
EMVRDCD	varchar	2	No	No	No	Rest Day Code
EMVESCD	varchar	1	No	No	No	Employment Status
EMVFLAG	tinyint	1	No	No	No	Flag
EMVPCCD	varchar	1	No	No	No	Payment Class
EMVCOCD	varchar	1	No	No	No	Company Code
EMVFPER	varchar	1	No	No	No	Flag for Field Personnel
EMVPACD	varchar	2	No	No	No	PAM Code
EMVPADT	datetime	0	No	No	No	PAM Effective Date
EMVTDPD	varchar	1	No	No	No	Pay for Daily Paid
EMVBLOC	varchar	3	No	No	No
OCODE	varchar	3	No	No	No	Old Department Code

pmtsepa

pmtsepa
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
SEPSLPY	double	15,5	Yes	Yes	Yes
SEPVLPY	double	15,5	No	No	No
SEPADDS	15,5	0	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
OCODE	varchar	3	No	No	No

posting_logs

posting_logs
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
recid	int	30	Yes	Yes	Yes
COMPANY	varchar	25	No	No	No
SITE	varchar	25	No	No	No
PCLASS	varchar	25	No	No	No
MODULE	varchar	60	No	Yes	No
MPERIOD	date	0	No	No	No
DATEP	datetime	0	No	No	No
USERN	varchar	25	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	date	0	No	No	No
PDMATDT	date	0	No	No	No
PDMDAYS	double	15,2	No	No	No
PDMDAYS	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

pvf2016

pvf2016
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
PVFRECID	varchar	20	No	No	No
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
BNKBKCD	varchar	5	No	No	No
BNKDESC	varchar	30	No	No	No
BNKADDR	varchar	30	No	No	No
BNKTCSH	double	15,2	No	No	No
BNKACDE	varchar	3	No	No	No

pymbcnt

pymbcnt
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
BCNBKCD	varchar	5	No	No	No
BCNPSON	varchar	30	No	No	No
BCNPOSI	varchar	20	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

pymftbl

pymftbl
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
FTBCOCD	varchar	1	No	No	No
FTBSSSR	double	15,2	No	No	No
FTBSSSE	double	15,2	No	No	No
FTBMEDR	double	15,2	No	No	No
FTBMEDE	double	15,2	No	Yes	No
FTBECCM	double	15,2	No	No	No
FTBPIBR	double	15,2	No	No	No
FTBPIBE	double	15,2	No	No	No
FTBGPAY	double	15,2	No	No	No
FTBTAXC	double	15,2	No	No	No

pymhbnkadvc

pymhbnkadvc
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
recid	int	11	No	Yes	Yes
BNKCD	varchar	5	No	Yes	No
CMPNAM	varchar	1	No	No	No
CMPADD	varchar	80	No	No	No
BNKCPER	varchar	30	No	No	No
BNKCPPOS	varchar	30	No	No	No
BNKNAM	varchar	30	No	No	No
BNKADD	varchar	80	No	No	No
BNKACCT	varchar	30	No	No	No
BNKPCD	varchar	2	No	No	No
BNKTYPE	varchar	2	No	No	No

pymholi

pymholi
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	3	No	No	No
HOLDAYS	double	15,5	No	No	No

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

pympitb

pympitb
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment	Description
PITLWGP	double	15,2	No	No	No	Lower Range
PITUPGP	double	15,2	No	No	No	Upper Range
PITERCN	double	15,2	No	No	No	ER Contribution
PITERFC	double	15,2	No	No	No	Employer Fixed Contribution
PITEECN	double	15,2	No	No	No	Employee Contribution
PITEEFC	double	15,2	No	No	No	Employee Fixed Contribution

pymprem

pymprem
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment	Description
PRMRRD1	double	15,2	No	No	No	Regular Hours
PRMRRO1	double	15,2	No	No	No	Regular OT
PRMRRD2	double	15,2	No	No	No	Rest Day
PRMRRO2	double	15,2	No	No	No	Rest Day OT
PRMRSD1	double	15,2	No	No	No	Special Holiday Regular Hrs.
PRMRSO1	double	15,2	No	No	No	Special Holiday Regular OT
PRMRSD2	double	15,2	No	No	No	Special Holiday Rest Day
PRMRSO2	double	15,2	No	No	No	Special Holiday Rest Day OT
PRMRLD1	double	15,2	No	No	No	Legal Holiday Regular Hrs.
PRMRLO1	double	15,2	No	No	No	Legal Holiday OT
PRMRLD2	double	15,2	No	No	No	Legal Holiday Rest Day Hours
PRMRLO2	double	15,2	No	No	No	Legal Holiday Rest Day OT
PRMNRD1	double	15,2	No	No	No	Night Shift Hours
PRMNRO1	double	15,2	No	No	No	Night Shift OT
PRMNRD2	double	15,2	No	No	No	Night Shift Rest Day
PRMNRO2	double	15,2	No	No	No	Rest Day Night Shift OT
PRMNSD1	double	15,2	No	No	No	Special Holiday Night Shift
PRMNSO1	double	15,2	No	No	No	Special Holiday Night Shift OT
PRMNSD2	double	15,2	No	No	No	Special Holiday Night Shift Rest Day
PRMNSO2	double	15,2	No	No	No	Special Holiday Night Shift Rest Day OT
PRMNLD1	double	15,2	No	No	No	Legal Holiday Night Shift Hours
PRMNLO1	double	15,2	No	No	No	Legal Holiday Night Shift Hours OT
PRMNLD2	double	15,2	No	No	No	Legal Holiday Night Shift Rest Day Hours
PRMNLO2	double	15,2	No	No	No	Legal Holiday Night Shift Rest Day OT

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_newgl

pymsdmf_newgl
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	15	No	No	No
PYMSDDT	date	0	No	No	No
PYMDATE	varchar	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

pymsbnkadvc

pymsbnkadvc
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
recid	int	11	No	Yes	Yes
BNKCD	varchar	5	No	No	No
BNKSIGNA	varchar	40	No	No	No
BNKSIGNAPOS	varchar	30	No	No	No
BNKDOCPOS	varchar	60	No	Yes	No
CMPNAM	varchar	30	No	No	No
BNKPCD	varchar	2	No	No	No
BNKTYPE	varchar	2	No	No	No

pymsdmf

pymsdmf
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
recid	int	25	Yes	Yes	Yes
SDMCOMP	varchar	24	No	No	No
SDMSDCD	varchar	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
SDMCODE_PRIO	int	3	No	No	No
SDMNGLCD	varchar	10	No	No	No

pymseqn

pymseqn
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
M01SEQN	int	5	No	No	No
M02SEQN	int	5	No	No	No
M03SEQN	int	5	No	No	No
M04SEQN	int	5	No	No	No
E01SEQN	int	5	No	No	No
E02SEQN	int	5	No	No	No
E03SEQN	int	5	No	No	No
E04SEQN	int	5	No	No	No
D01SEQN	int	8	No	No	No
D02SEQN	int	8	No	No	No
D03SEQN	int	8	No	No	No
D04SEQN	int	8	No	No	No

pymslvl

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

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

pymslvo
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

pymssst

pymssst
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
SSSLWGP	double	15,2	No	No	No
SSSUPGP	double	15,2	No	No	No
SSSSLCR	double	15,2	No	No	No
SSSERCN	double	15,2	No	No	No
SSSERMN	double	15,2	No	No	No
SSSEREC	double	15,2	No	No	No
SSSEECN	double	15,2	No	No	No
SSSEEMN	double	15,2	No	No	No

pymtadd

pymtadd
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
TADSQNO	varchar	2	No	No	No
TADADED	double	15,2	No	No	No
TADRATE	double	15,2	No	No	No

pymtadw

pymtadw
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment	Description
TAWSQNO	varchar	2	No	No	No	Sequence No.
TAWRATE	double	15,2	No	No	No	Rate
TAWADED	double	15,2	No	No	No	Additional Deduction

pymtaxy

pymtaxy
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
TXYMNGR	double	15,2	No	No	No
TXYMXGR	double	15,2	No	No	No
TXYTXAD	double	15,2	No	No	No
TXYTXRT	double	15,2	No	No	No

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

pymtsrw

pymtsrw
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
TSWSQNO	varchar	2	No	No	No
TSWTXCD	varchar	10	No	No	No
TSWSLRY	double	15,2	No	No	No

pymttbl

pymttbl
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
TBLLATE	double	15,2	No	No	No
TBLMNOT	double	15,2	No	No	No
TBLTRDY	varchar	3	No	No	No
TBLWOLV	varchar	3	No	No	No
TBLDLOA	varchar	3	No	No	No
TBLMNHF	double	15,2	No	No	No

pymudue

pymudue
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
DUECODE	varchar	3	No	No	No
DUEAMNT	double	15,2	No	No	No
DUEEDTE	date	0	No	No	No
DUEDCNO	varchar	30	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

pytfixp

pytfixp
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
FIXNUMB	varchar	15	No	No	No
FIXFLAG	tinyint	1	No	No	No
FIXAMNT	double	15,2	No	No	No

pytmerc

pytmerc
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
MRCCOCD	varchar	1	No	No	No
MRCCDTE	datetime	0	No	No	No
MRCRCNO	varchar	20	No	No	No
MRCDATE	datetime	0	No	No	No
MRCAMNT	double	15,2	No	No	No

pytssrc

pytssrc
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
PRCCOCD	varchar	1	No	No	No
PRCCDTE	datetime	0	No	No	No
PRCRCNO	varchar	20	No	No	No
PRCDATE	datetime	0	No	No	No
PRCAMNT	double	15,2	No	No	No

pytsdln

pytsdln
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
SDLCOCD	varchar	1	No	No	No
SDLCDTE	datetime	0	No	No	No
SDLRCNO	varchar	20	No	No	No
SDLDATE	datetime	0	No	No	No
SDLAMNT	double	15,2	No	No	No
SDLSDCD	varchar	3	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	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	int	20	No	No	No

pytsdsa_bk

pytsdsa_bk
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	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	int	20	No	No	No

pytssrc

pytssrc
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
recid	int	25	Yes	Yes	Yes
SRCCOCD	varchar	1	No	No	No
SRCCDTE	datetime	0	No	No	No
SRCRCNO	varchar	20	No	No	No
SRCDATE	datetime	0	No	No	No
SRCAMNT	double	15,2	No	No	No

pyttxrc

pyttxrc
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
TRCCDTE	datetime	0	No	No	No
TRCRCNO	varchar	20	No	No	No
TRCDATE	datetime	0	No	No	No
TRCAMNT	double	15,2	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

slvladj2016

slvladj2016
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
LVAB_RECID	int	10	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_ASSUMSL	double	15,2	No	No	No
LVAB_ASSUMVL	double	15,2	No	No	No
LVAB_FATERNAL	double	15,2	No	No	No
LVAB_USER	varchar	10	No	No	No
PAYPERIOD	date	0	No	No	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
EE_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

sssc2016

sssc2016
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
ctrno	double	8,2	Yes	Yes	Yes
ctryr	varchar	4	No	No	No

svl2016

svl2016
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
SVLNUMB	varchar	15	Yes	Yes	Yes
SVLEDTE	datetime	0	No	No	No
SVLSLEN	double	15,2	No	No	No
SVLVLEN	double	15,2	No	No	No
SVLFLEN	double	15,2	No	No	No
SVLSLRE	double	15,2	No	No	No
SVLVLRE	double	15,2	No	No	No
SVLFLRE	double	15,2	No	No	No

syslogs

syslogs
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
recid	int	30	Yes	Yes	Yes
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

tblempfixallo

tblempfixallo
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
FXEMPNUMB	varchar	15	No	Yes	No
FXAMOUNT	double	15,2	No	Yes	No
FXTMPSTMP	datetime	0	No	Yes	No
FXUSER	varchar	45	No	Yes	No

tkf2016

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

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	1	No	No	No
UN_FLAG	varchar	1	No	No	No

unibio28u2016

unibio28u2016
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
FPENUMB	varchar	45	No	No	No
FPID	varchar	45	No	No	No
FPDATE	datetime	0	No	No	No
FPIO	varchar	3	No	No	No
OLDBARID	varchar	36	No	No	No

unionduesqb

unionduesqb
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
EMPNUMB	varchar	15	No	No	No

uw2016

uw2016
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
UNWNUMB	varchar	15	No	No	No
UNWDATE	datetime	0	No	No	No
UNWSTME	varchar	4	No	No	No
UNWETME	varchar	4	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