Difference between revisions of "Mypmsdb"

Revision as of 14:25, 30 September 2016 (view source) Ojt1 (Talk | contribs) (→‎pmtvip2) ← Older edit		Revision as of 08:31, 3 October 2016 (view source) Ojt1 (Talk | contribs) (→‎pmtempl) Newer edit →
Line 8,850:		Line 8,850:
	! Is Not Null		! Is Not Null
	! Auto Increment		! Auto Increment
		+	! Description
	|-		|-
	|EMPNUMB		|EMPNUMB
Line 8,857:		Line 8,858:
	|No		|No
	|No		|No
		+	|Employee No.
	|-		|-
	|EMPLNAM		|EMPLNAM
Line 8,864:		Line 8,866:
	|No		|No
	|No		|No
		+	|LastName
	|-		|-
	|EMPFNAM		|EMPFNAM
Line 8,871:		Line 8,874:
	|No		|No
	|No		|No
		+	|FirstName
	|-		|-
	|EMPMNAM		|EMPMNAM
Line 8,878:		Line 8,882:
	|No		|No
	|No		|No
		+	|MiddleName
	|-		|-
	|EMPSXCD		|EMPSXCD
Line 8,885:		Line 8,890:
	|No		|No
	|No		|No
		+	|Sex Code
	|-		|-
	|EMPBDTE		|EMPBDTE
Line 8,892:		Line 8,898:
	|No		|No
	|No		|No
		+	|Birthdate
	|-		|-
	|EMPPOBT		|EMPPOBT
Line 8,899:		Line 8,906:
	|No		|No
	|No		|No
		+	|Place of Birth
	|-		|-
	|EMPRGCD		|EMPRGCD
Line 8,906:		Line 8,914:
	|No		|No
	|No		|No
		+	|Religion Code
	|-		|-
	|EMPCSCD		|EMPCSCD
Line 8,913:		Line 8,922:
	|No		|No
	|No		|No
		+	|Civil Status
	|-		|-
	|EMPCADD		|EMPCADD
Line 8,920:		Line 8,930:
	|No		|No
	|No		|No
		+	|Address
	|-		|-
	|EMPTOWN		|EMPTOWN
Line 8,927:		Line 8,938:
	|No		|No
	|No		|No
		+	|Town
	|-		|-
	|EMPCITY		|EMPCITY
Line 8,934:		Line 8,946:
	|No		|No
	|No		|No
		+	|City
	|-		|-
	|EMPCZCD		|EMPCZCD
Line 8,941:		Line 8,954:
	|No		|No
	|No		|No
		+	|Citizenship Code
	|-		|-
	|EMPTXCD		|EMPTXCD
Line 8,948:		Line 8,962:
	|No		|No
	|No		|No
		+	|Tax Code
	|-		|-
	|EMPLDTE		|EMPLDTE
Line 8,955:		Line 8,970:
	|No		|No
	|No		|No
		+	|Tax Status Effectivity Date
	|-		|-
	|EMPSSNO		|EMPSSNO
Line 8,962:		Line 8,978:
	|No		|No
	|No		|No
		+	|SSS No.
	|-		|-
	|EMPTINO		|EMPTINO
Line 8,969:		Line 8,986:
	|No		|No
	|No		|No
		+	|TIN No.
	|-		|-
	|EMPHDTE		|EMPHDTE
Line 8,976:		Line 8,994:
	|No		|No
	|No		|No
		+	|Date Hired
	|-		|-
	|EMPODTE		|EMPODTE
Line 8,983:		Line 9,002:
	|No		|No
	|No		|No
		+	|Orientation Date
	|-		|-
	|EMPPMCD		|EMPPMCD
Line 8,990:		Line 9,010:
	|No		|No
	|No		|No
		+	|Payment Code
	|-		|-
	|EMPPCCD		|EMPPCCD
Line 8,997:		Line 9,018:
	|No		|No
	|No		|No
		+	|Payment Class
	|-		|-
	|EMPCOCD		|EMPCOCD
Line 9,004:		Line 9,026:
	|No		|No
	|No		|No
		+	|Company Code
	|-		|-
	|EMPLCCD		|EMPLCCD
Line 9,011:		Line 9,034:
	|No		|No
	|No		|No
		+	|Location Code
	|-		|-
	|EMPSTAT		|EMPSTAT
Line 9,018:		Line 9,042:
	|No		|No
	|No		|No
		+	|Tag for Active
	|-		|-
	|EMPSTDT		|EMPSTDT
Line 9,025:		Line 9,050:
	|No		|No
	|No		|No
		+	|Date Hold
	|-		|-
	|EMPPINO		|EMPPINO
Line 9,032:		Line 9,058:
	|No		|No
	|No		|No
		+	Pagibig No.
	|-		|-
	|EMPAVOL		|EMPAVOL
Line 9,039:		Line 9,066:
	|No		|No
	|No		|No
		+	|Tag Below 4,000
	|-		|-
	|EMPPVOL		|EMPPVOL
Line 9,046:		Line 9,074:
	|No		|No
	|No		|No
		+	|Tag Above 4,000
	|-		|-
	|EMPTDPD		|EMPTDPD
Line 9,053:		Line 9,082:
	|No		|No
	|No		|No
		+	|Tag for Daily Paid
	|-		|-
	|EMPCBAT		|EMPCBAT
Line 9,060:		Line 9,090:
	|No		|No
	|No		|No
		+	|Tag for CBA
	|-		|-
	|EMPDPCD		|EMPDPCD
Line 9,067:		Line 9,098:
	|No		|No
	|No		|No
		+	|Department Code
	|-		|-
	|EMPESCD		|EMPESCD
Line 9,074:		Line 9,106:
	|No		|No
	|No		|No
		+	|Employment Status
	|-		|-
	|EMPDPCC		|EMPDPCC
Line 9,081:		Line 9,114:
	|No		|No
	|No		|No
		+	|Department Charging
	|-		|-
	|EMPINCO		|EMPINCO
Line 9,088:		Line 9,122:
	|No		|No
	|No		|No
		+	|Internal Company
	|-		|-
	|EMPALLO		|EMPALLO
Line 9,095:		Line 9,130:
	|No		|No
	|No		|No
		+	|Allowance
	|-		|-
	|EMPFEPF		|EMPFEPF
Line 9,102:		Line 9,138:
	|No		|No
	|No		|No
		+	|Tag for Downloaded EPF
	|-		|-
	|EMPHLDT		|EMPHLDT

---

Revision as of 08:31, 3 October 2016

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
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
MHWNUMB	varchar	15	No	No	No
MHWCDTE	datetime	0	No	No	No
MHWTRDY	double	15,2	No	No	No
MHWUTME	double	15,2	No	No	No
MHWSLLV	double	15,2	No	No	No
MHWVLLV	double	15,2	No	No	No
MHWULOA	double	15,2	No	No	No
MHWWOLV	double	15,2	No	No	No
MHWDLOA	double	15,2	No	No	No
MHWOTHR	double	15,2	No	No	No
MHWDAYS	double	15,2	No	No	No
MHWESCD	varchar	1	No	No	No
MHWRRD1	double	15,2	No	No	No
MHWRRO1	double	15,2	No	No	No
MHWNRD1	double	15,2	No	No	No
MHWNRO1	double	15,2	No	No	No
MHWRRD2	double	15,2	No	No	No
MHWRRO2	double	15,2	No	No	No
MHWNRO2	double	15,2	No	No	No
MHWRSD1	varchar	2	No	No	No
MHWRSO1	varchar	1	No	No	No
MHWRSD2	double	15,2	No	No	No
MHWRSO2	varchar	1	No	No	No
MHWNSO1	double	15,2	No	No	No
MHWNSD2	double	15,2	No	No	No
MHWNSO2	double	15,2	No	No	No
MHWRLD1	double	15,2	No	No	No
MHWRLO1	double	15,2	No	No	No
MHWNLD1	double	15,2	No	No	No
MHWRLD2	double	15,2	No	No	No
MHWRLO2	double	15,2	No	No	No
MHWNLO1	double	15,2	No	No	No
MHWNLD2	double	15,2	No	No	No
MHWNLO2	double	15,2	No	No	No
MHWNRD2	double	15,2	No	No	No
MHWLHOL	double	15,2	No	No	No
MHWSHOL	double	15,2	No	No	No
MHWTHOL	double	15,2	No	No	No
MHWRLEG	double	15,2	No	No	No
MHWRSPC	double	15,2	No	No	No
MHWFPER	varchar	1	No	No	No
MHWADSL	double	15,2	No	No	No
MHWADVL	double	15,2	No	No	No
MHWDDSL	double	15,2	No	No	No
MHWDDVL	double	15,2	No	No	No
MHWADFL	double	15,2	No	No	No

mst_attlogs

mst_attlogs
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
recid	int	30	Yes	Yes	Yes
FP_ID	varchar	25	No	No	No
FP_TRXDATE	datetime	0	No	No	No
FP_SITE	varchar	25	No	No	No
MYF3	varchar	1	No	No	No
MYF5	varchar	1	No	No	No
MYF6	varchar	1	No	No	No
FP_IDNO	varchar	25	No	No	No
FP_EMPNAME	varchar	200	No	No	No
FP_DPCD	varchar	25	No	No	No
FP_COCD	varchar	25	No	No	No
FP_LCCD	varchar	25	No	No	No
FP_USER	varchar	25	No	No	No
FP_DTEUP	datetime	0	No	No	No

mst_cost_center

mst_cost_center
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
recid	int	25	Yes	Yes	Yes
COCD	varchar	25	No	No	No
NEW_DPCD	varchar	25	No	No	No
NEW_DESC	varchar	100	No	No	No
BUS_CENTER	varchar	25	No	No	No
OLD_DPCD	varchar	25	No	No	No
OLD_DESC	varchar	100	No	No	No

mst_cost_center_555

mst_cost_center_555
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
recid	int	25	Yes	Yes	Yes
Controlling_Area	varchar	25	No	No	No
Cost_Center_Code_888	varchar	25	No	No	No
Cost_Center_Code_555	varchar	25	No	No	No
Cost_Center_Name	varchar	100	No	No	No
Person_Responsible	varchar	150	No	No	No
Profit_Center	varchar	25	No	No	No
Department_new	varchar	100	No	No	No

mst_ctr_no

mst_ctr_no
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
ctr_no	varchar	15	No	No	No
ctr_err_no	varchar	15	No	No	No
ctr_no_year	varchar	4	No	No	No

mst_diocese

mst_diocese
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
recid	int	25	Yes	Yes	Yes
DS_CODE	varchar	25	No	No	No
DS_NAME	varchar	100	No	No	No

mst_gl_555

mst_gl_555
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
recid	int	25	Yes	Yes	Yes
COA	varchar	25	No	No	No
GL_888	varchar	25	No	No	No
GL_555	varchar	25	No	No	No
Name	varchar	100	No	No	No
Account_group	varchar	25	No	No	No

mst_mission

mst_mission
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
recid	int	25	Yes	Yes	Yes
MS_CODE	varchar	25	No	No	No
MS_DESC	varchar	100	No	No	No
MS_FDESC	longtext	0	No	No	No

mst_educatt

mst_educatt
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
recid	int	25	Yes	Yes	Yes
EA_CODE	varchar	25	No	No	No
EA_DESC	varchar	100	No	No	No

mst_nationality

mst_nationality
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
recid	int	25	Yes	Yes	Yes
NT_CODE	varchar	25	No	No	No
NT_DESC	varchar	50	No	No	No

mst_relivows

mst_relivows
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
recid	int	25	Yes	Yes	Yes
RV_CODE	varchar	25	No	No	No
RV_DESC	varchar	100	No	No	No

my_ctr_no

my_ctr_no
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
pvrecid	int	20	Yes	Yes	Yes
myyear	varchar	4	No	No	No

mybpibadv

mst_cost_center_555
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
recid	int	1	Yes	Yes	Yes
atmno	varchar	10	No	No	No
ddate	date	0	No	No	No
dudate	date	0	No	No	No
amount	double	12,2	No	No	No
empname	varchar	30	No	No	No
date_upld	datetime	0	No	No	No
user	varchar	15	No	No	No
company	varchar	1	No	No	No

ob2016

ob2016
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
OBTNUMB	varchar	8	Yes	Yes	Yes
OBTDATE	datetime	0	No	No	No
OBTDTME	varchar	4	No	No	No
OBTATME	varchar	4	No	No	No

obtp2016

obtp2016
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
recid	int	30	Yes	Yes	Yes
OB_ENUMB	varchar	25	No	No	No
OB_WS_CODE	varchar	25	No	No	No
OB_DYCODE	varchar	3	No	No	No
OB_DYTYPE	varchar	25	No	No	No
OB_LCCD	varchar	25	No	No	No
OB_DPCD	varchar	25	No	No	No
OB_COCD	varchar	25	No	No	No
OB_CDTE	date	0	No	No	No
OB_DTETRX	date	0	No	No	No
OB_SAMIN	datetime	0	No	No	No
OB_SAMOUT	datetime	0	No	No	No
OB_SPMIN	datetime	0	No	No	No
OB_SPMOUT	datetime	0	No	No	No
OB_ATIME	datetime	0	No	No	No
OB_DTIME	datetime	0	No	No	No
OB_USER	varchar	25	No	No	No
OB_ENCD	datetime	0	No	No	No
OB_REMK	longtext	0	No	No	No
OB_FLAG	varchar	1	No	No	No

ok2016

ok2016
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
OTWNUMB	varchar	15	No	No	No
OTWDATE	datetime	0	No	No	No
OTWFTME	varchar	4	No	No	No
OTWTTME	varchar	4	No	No	No

ot2016

ot2016
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
OTMNUMB	varchar	15	No	No	No
OTMDATE	datetime	0	No	No	No
OTMFTME	varchar	4	No	No	No
OTMTTME	varchar	4	No	No	No

otdt2016

otdt2016
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
recid	int	30	Yes	Yes	Yes
OT_ENUMB	varchar	25	No	No	No
OT_WS_CODE	varchar	25	No	No	No
OT_DYCODE	varchar	3	No	No	No
OT_DYTYPE	varchar	25	No	No	No
OT_LCCD	varchar	25	No	No	No
OT_DPCD	varchar	25	No	No	No
OT_COCD	varchar	25	No	No	No
OT_CDTE	date	0	No	No	No
OT_DTETRX	date	0	No	No	No
OT_SAMIN	datetime	0	No	No	No
OT_SAMOUT	datetime	0	No	No	No
OT_SPMIN	datetime	0	No	No	No
OT_SPMOUT	datetime	0	No	No	No
OT_STIME	datetime	0	No	No	No
OT_ETIME	datetime	0	No	No	No
OT_USER	varchar	25	No	No	No
OT_ENCD	datetime	0	No	No	No
OT_REMK	longtext	0	No	No	No
OT_FLAG	varchar	1	No	No	No

otpay2016

otpay2016
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
recid	int	25	Yes	Yes	Yes
OTP_EMPNUMB	varchar	25	No	No	No
OTP_CDTE	date	0	No	No	No
OTP_TFDATE	date	0	No	No	No
OTP_TTDATE	date	0	No	No	No
OTP_HRS	double	10,2	No	No	No
OTP_MNS	double	10,2	No	No	No
OTP_CODE	varchar	25	No	No	No
OTP_COCD	varchar	25	No	No	No
OTP_RATE	double	10,3	No	No	No
OTP_RALLO	double	10,3	No	No	No
OTP_AMT_RATE	double	15,3	No	No	No
OTP_REFC	varchar	60	No	No	No
OTP_ED_CODE	varchar	25	No	No	No
OTP_PCMP_GRP_CODE	varchar	25	No	No	No
OTP_DPCD	varchar	25	No	No	No
OTP_DPCD_FLAG	varchar	25	No	No	No
OTP_RATEC	varchar	25	No	No	No
OTP_PYTYPE	varchar	1	No	No	No
OTP_TXTYPE	varchar	1	No	No	No
OTP_MFIELD	varchar	25	No	No	No
OTP_DEFDAYS	double	15,2	No	No	No
OTP_DEFMO	varchar	2	No	No	No
OTP_DEFCMO	varchar	1	No	No	No
OTP_DEFHRS	double	15,2	No	No	No
OTP_PMRK	varchar	1	No	No	No
OT_SFLAG	varchar	1	No	No	No
OT_APPROVED	varchar	1	No	No	No

ow2016

ow2016
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
OBWNUMB	varchar	15	No	No	No
OBWDATE	datetime	0	No	No	No
OBWDTME	varchar	4	No	No	No
OBWATME	varchar	4	No	No	No

pdm_essi2016

pdm_essi2016
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
PDMCOFF	varchar	3	No	No	No
PDMFDTE	datetime	0	No	No	No
PDMTDTE	datetime	0	No	No	No
PDMPOST	varchar	7	No	No	No
PDMAFDT	datetime	0	No	No	No
PDMATDT	datetime	0	No	No	No
PDMDAYS	double	15,2	No	No	No
PDMADFD	datetime	0	No	No	No
PDMADTD	datetime	0	No	No	No
PDMSFDT	datetime	0	No	No	No
PDMSTDT	datetime	0	No	No	No

pdm_sppe2016

pdm_sppe2016
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
PDMCOFF	varchar	3	No	No	No
PDMFDTE	datetime	0	No	No	No
PDMTDTE	datetime	0	No	No	No
PDMPOST	varchar	7	No	No	No
PDMAFDT	datetime	0	No	No	No
PDMATDT	datetime	0	No	No	No
PDMDAYS	double	15,2	No	No	No
PDMADFD	datetime	0	No	No	No
PDMADTD	datetime	0	No	No	No
PDMSFDT	datetime	0	No	No	No
PDMSTDT	datetime	0	No	No	No

pdm2016

pdm2016
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
PDMCOFF	varchar	3	No	No	No
PDMFDTE	datetime	0	No	No	No
PDMTDTE	datetime	0	No	No	No
PDMPOST	varchar	7	No	No	No
PDMAFDT	datetime	0	No	No	No
PDMATDT	datetime	0	No	No	No
PDMDAYS	double	15,2	No	No	No
PDMADFD	datetime	0	No	No	No
PDMADTD	datetime	0	No	No	No
PDMSFDT	datetime	0	No	No	No
PDMSTDT	datetime	0	No	No	No

pdw_sppe2016

pdw_sppe2016
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
PDWWEEK	varchar	3	No	No	No
PDWFDTE	datetime	0	No	No	No
PDWTDTE	datetime	0	No	No	No
PDWPOST	varchar	7	No	No	No
PDWAFDT	datetime	0	No	No	No
PDWATDT	datetime	0	No	No	No
PDWDAYS	double	15,2	No	No	No
PDWADFD	datetime	0	No	No	No
PDWADTD	datetime	0	No	No	No
PDWSFDT	datetime	0	No	No	No
PDWSTDT	datetime	0	No	No	No

pdw2016

pdw2016
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
PDWWEEK	varchar	3	No	No	No
PDWFDTE	datetime	0	No	No	No
PDWTDTE	datetime	0	No	No	No
PDWPOST	varchar	7	No	No	No
PDWAFDT	datetime	0	No	No	No
PDWATDT	datetime	0	No	No	No
PDWDAYS	double	15,2	No	No	No
PDWADFD	datetime	0	No	No	No
PDWADTD	datetime	0	No	No	No
PDWSFDT	datetime	0	No	No	No
PDWSTDT	datetime	0	No	No	No

pmhempl

pmhempl
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
EMPNUMB	varchar	15	No	No	No
EMPLNAM	varchar	40	No	No	No
EMPFNAM	varchar	40	No	No	No
EMPMNAM	varchar	40	No	No	No
EMPSXCD	varchar	1	No	No	No
EMPBDTE	datetime	0	No	No	No
EMPPOBT	varchar	50	No	No	No
EMPRGCD	varchar	2	No	No	No
EMPCSCD	varchar	1	No	No	No
EMPCADD	varchar	40	No	No	No
EMPTOWN	varchar	20	No	No	No
EMPCITY	varchar	20	No	No	No
EMPCZCD	varchar	2	No	No	No
EMPTXCD	varchar	10	No	No	No
EMPLDTE	datetime	0	No	No	No
EMPSSNO	varchar	12	No	No	No
EMPTINO	varchar	12	No	No	No
EMPHDTE	datetime	0	No	No	No
EMPODTE	datetime	0	No	No	No
EMPPMCD	varchar	1	No	No	No
EMPPCCD	varchar	1	No	No	No
EMPCOCD	varchar	1	No	No	No
EMPLCCD	varchar	3	No	No	No
EMPSTAT	varchar	1	No	No	No
EMPSTDT	datetime	0	No	No	No
EMPPINO	varchar	12	No	No	No
EMPAVOL	tinyint	1	No	Yes	No
EMPPVOL	tinyint	1	No	Yes	No
EMPTDPD	varchar	1	No	No	No
EMPCBAT	varchar	1	No	No	No
EMPDPCD	varchar	10	No	No	No
EMPESCD	varchar	1	No	No	No
EMPDPCC	varchar	10	No	No	No
EMPINCO	varchar	1	No	No	No
EMPALLO	double	15,5	No	No	No
EMPFEPF	varchar	1	No	No	No
EMPHLDT	datetime	0	No	No	No
EMPMENO	varchar	12	No	No	No

pmmcmpy

pmmcmpy
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
recid	int	25	Yes	Yes	Yes
CMPCOCD	varchar	1	No	No	No
CMPNAME	varchar	40	No	No	No
CMPSSSN	varchar	12	No	No	No
CMPTINO	varchar	12	No	No	No
CMPCADD	varchar	50	No	No	No
CMPSLAC	varchar	10	No	No	No
CMPSMEC	varchar	10	No	No	No
CMPBKAL	varchar	10	No	No	No
CMPOTHR	varchar	10	No	No	No
CMPHOLD	varchar	10	No	No	No
CMPPIBE	varchar	10	No	No	No
CMPTELE	varchar	10	No	No	No
CMPBMAK	varchar	10	No	No	No
CMPCASH	varchar	10	No	No	No
CMPTAXC	varchar	10	No	No	No
CMPSMEP	varchar	10	No	No	No
CMPABBR	varchar	5	No	No	No
CMPMEDP	varchar	10	No	No	No
CMPHACC	varchar	3	No	No	No
CMPPACC	varchar	3	No	No	No
CMPWACC	varchar	3	No	No	No
CMPTACC	varchar	3	No	No	No
CMPHLAC	varchar	3	No	No	No
CMPSACC	varchar	3	No	No	No
CMPBACC	varchar	3	No	No	No
CMPOIAC	varchar	3	No	No	No
CMPSMAC	varchar	3	No	No	No
CMPSPAC	varchar	3	No	No	No
CMPOSLA	varchar	3	No	No	No
CMPADDR	varchar	100	No	No	No
CMPPAGBR	varchar	5	No	No	No
CMPTELNO	varchar	15	No	No	No
CMPZIPCD	varchar	10	No	No	No
CMPFNAME	varchar	8	No	No	No
CMPPHILNO	varchar	12	No	No	No
CMPPHILSIG	varchar	60	No	No	No
CMPPHILSIGPOS	varchar	60	No	No	No

pmmacin

pmmacin
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment	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
recid	int	25	Yes	Yes	Yes
DEPDPCD	varchar	10	No	No	No
DEPCPCD	varchar	1	No	No	No
DEPNAME	varchar	35	No	No	No
DEPINCO	varchar	2	No	No	No
DEPSLWG	varchar	8	No	No	No
DEPSSSM	varchar	8	No	No	No
DEPABBR	varchar	5	No	No	No
DEPCOCD	varchar	1	No	No	No
DEPFLAG	varchar	1	No	No	No
DEPBONS	varchar	8	No	No	No
DEPBENE	varchar	8	No	No	No
DEPOCDE	varchar	3	No	No	No
DEPACTV	varchar	1	No	No	No
DEPACTIVE	varchar	1	No	No	No

pmmicls

pmmicls
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment	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
CHDNUMB	varchar	15	No	No	No
CHDLNAM	varchar	15	No	No	No
CHDFNAM	varchar	20	No	No	No
CHDMNAM	varchar	15	No	No	No
CHDBDTE	datetime	0	No	No	No
CHDSXCD	varchar	1	No	No	No

pmtchrr

pmtchrr
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
CHRNUMB	varchar	15	No	No	No
CHRLNAM	varchar	15	No	No	No
CHRFNAM	varchar	20	No	No	No
CHRMNAM	varchar	15	No	No	No
CHRADDR	varchar	30	No	No	No
CHRTELE	varchar	12	No	No	No
CHROCCU	varchar	15	No	No	No
CHRYRKW	double	15,5	No	No	No

pmtcmdn

pmtcmdn
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
CMDNUMB	varchar	15	No	No	No
CMDDATE	datetime	0	No	No	No
CMDAWRD	varchar	15	No	No	No

pmtdpdt

pmtdpdt
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
DPDNUMB	varchar	15	No	No	No
DPDRLCD	varchar	2	No	No	No
DPDLNAM	varchar	15	No	No	No
DPDFNAM	varchar	20	No	No	No
DPDMNAM	varchar	15	No	No	No
DPDBDTE	datetime	0	No	No	No
DPDSXCD	varchar	1	No	No	No

pmtdrvl

pmtdrvl
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
DRVNUMB	varchar	15	No	No	No
DRVLCNO	varchar	15	No	No	No
DRVPLCE	varchar	15	No	No	No
DRVDATE	datetime	0	No	No	No

pmteduc

pmteduc
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
EDUNUMB	varchar	15	No	No	No
EDUSCHL	varchar	30	No	No	No
EDUYRGD	double	15,5	No	No	No
EDUCOUR	varchar	30	No	No	No
EDUHONR	varchar	30	No	No	No

pmtemp_illness

pmtemp_illness
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
RECID	int	10	Yes	Yes	Yes
EMPNUMB	varchar	15	No	Yes	No
ILLDTAQUIRED	date	0	No	Yes	No
ILLNAME	varchar	45	No	Yes	No
ILLRMKS	varchar	200	No	Yes	No

pmtemp_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
FAMNUMB	varchar	15	No	No	No
FAMRLCD	varchar	2	No	No	No
FAMLNAM	varchar	15	No	No	No
FAMFNAM	varchar	20	No	No	No
FAMMNAM	varchar	15	No	No	No
FAMBDTE	datetime	0	No	No	No
FAMSXCD	varchar	1	No	No	No
FAMOCCU	varchar	15	No	No	No
FAMCOSH	varchar	15	No	No	No

pmtfixm

pmtfixm
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
FIXDPCD	varchar	10	No	No	No
FIXFDTE	datetime	0	No	No	No
FIXTDTE	datetime	0	No	No	No
FIXMNUM	double	15,2	No	No	No
FIXUSER	varchar	20	No	No	No
FIXDATE	datetime	0	No	No	No
FIXMOYR	varchar	6	No	No	No

pmtfrrl

pmtfrrl
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
FRRNUMB	varchar	8	No	No	No
FRRRLCD	varchar	2	No	No	No
FRRENUM	varchar	30	No	No	No

pmtgvte

pmtgvte
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
GVTNUMB	varchar	15	No	No	No
GVTNTRE	varchar	20	No	No	No
GVTDATE	varchar	4	No	No	No
GVTRATE	double	15,5	No	No	No

pmtilln

pmtilln
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
ILLNUMB	varchar	15	No	No	No
ILLNTRE	varchar	15	No	No	No
ILLREMK	varchar	10	No	No	No

pmtinfr

pmtinfr
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
INFNUMB	varchar	15	No	No	No
INFDATE	datetime	0	No	No	No
INFICCD	varchar	2	No	No	No
INFACCD	varchar	3	No	No	No

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
LGENUMB	varchar	15	No	No	No
LGELACD	varchar	2	No	No	No

pmtmarr

pmtmarr
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
MARNUMB	varchar	15	No	No	No
MARLNAM	varchar	15	No	No	No
MARFNAM	varchar	20	No	No	No
MARMNAM	varchar	15	No	No	No
MARBDTE	datetime	0	No	No	No
MARMDTE	datetime	0	No	No	No

pmtmchd

pmtmchd
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
MCHNUMB	varchar	15	No	No	No
MCHCODE	varchar	2	No	No	No

pmtmwee

pmtmwee
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
MWEENUMB	varchar	15	No	No	No
MWEEDTE	date	0	No	No	No
MWEBASIC	double	15,2	No	No	No
MWEALLOW	double	15,2	No	No	No
MWE_WO_SEQN	varchar	4	No	No	No
MWE_WO_REGION_CODE	varchar	25	No	No	No
MWE_WO_REGION_AREA	varchar	25	No	No	No
MWE_WO_CLASS_CODE	varchar	25	No	No	No
MWE_WO_PCLASS	varchar	1	No	No	No
MWE_DATEE	datetime	0	No	No	No
MWE_REMK	varchar	1	No	No	No

pmtnoti

pmtnoti
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
NOTNUMB	varchar	15	No	No	No
NOTRLCD	varchar	2	No	No	No
NOTLNAM	varchar	15	No	No	No
NOTFNAM	varchar	20	No	No	No
NOTMNAM	varchar	15	No	No	No
NOTADDR	varchar	30	No	No	No

pmtntph

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

pmtprem

pmtprem
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
PRENUMB	varchar	15	No	No	No
PRECONM	varchar	20	No	No	No
PRECONR	varchar	15	No	No	No
PRESDTE	datetime	0	No	No	No
PREPOSN	varchar	15	No	No	No
PREJDSC	longtext	0	No	No	No
PREGPAY	double	15,5	No	No	No
PRETAXW	double	15,5	No	No	No
PRE13MO	double	15,5	No	No	No
PREPTAG	tinyint	1	No	Yes	No

pmtprevemployer

pmtprevemployer
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
RECID	int	10	Yes	Yes	Yes
EMPNUMB	varchar	15	No	Yes	No
PRECONR	varchar	15	No	Yes	No
PRVDTFRM	date	0	No	Yes	No
PRVDTTO	date	0	No	Yes	No
PRVCMPY	varchar	100	No	Yes	No
PRVPOSN	varchar	45	No	Yes	No
PRVCONO	varchar	20	No	Yes	No
PRVSLRY	double	15,2	No	Yes	No
PRVRSON	varchar	100	No	Yes	No

pmtprsn_notify

pmtprsn_notify
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
RECID	int	10	Yes	Yes	Yes
EMPNUMB	varchar	15	No	No	No
PRSNNAME	varchar	100	No	Yes	No
PRSNRLTN	varchar	45	No	Yes	No
PRSNTELN	varchar	50	No	Yes	No
PRSNADDR	varchar	200	No	Yes	No

pmtsemr

pmtsemr
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
SEMNUMB	varchar	15	No	No	No
SEMNTRE	varchar	40	No	No	No
SEMSDTE	datetime	0	No	No	No
SEMEDTE	datetime	0	No	No	No
SEMPLAC	varchar	15	No	No	No

pmtsepa

pmtsepa
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
SEPNUMB	varchar	15	No	No	No
SEPPSNO	varchar	1	No	No	No
SEPDATE	datetime	0	No	No	No
SEPRSON	varchar	20	No	No	No
SEPNPAY	double	15,5	No	No	No
SEPSPAY	double	15,5	No	No	No
SEP13PY	double	15,5	No	No	No
SEPSLPY	double	15,5	No	No	No
SEPVLPY	double	15,5	No	No	No
SEPADDS	double	15,5	No	No	No
SEPNNUM	varchar	6	No	No	No
SEPRELE	tinyint	1	No	Yes	No
SEPTAXD	double	15,5	No	No	No
SEPTAXW	double	15,5	No	No	No
SEPALLO	double	15,5	No	No	No
SEPGPAY	double	15,5	No	No	No
SEPRDTE	datetime	0	No	No	No
SEPRTAG	varchar	1	No	No	No
SEPRLBY	varchar	8	No	No	No
SEPPRNT	varchar	1	No	No	No
SEPHLSL	double	15,2	No	No	No
SEPMARK	varchar	1	No	No	No
SEPCOCD	varchar	1	No	No	No
SEPLHSL	double	15,2	No	No	No
SEPLHSL2	double	15,2	No	No	No
SEPLHSL_CDTE	date	0	No	No	No
SEPLHSL2_CDTE	date	0	No	No	No

pmtsepa_comp

pmtsepa_comp
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
recid	int	25	Yes	Yes	Yes
SEPNUMB	varchar	15	No	No	No
SEPVDCD	varchar	25	No	No	No
SEPGLCD	varchar	25	No	No	No
SEPPDESC	varchar	100	No	No	No
SEPAMNT	double	15,2	No	No	No
SEPDAMT	double	15,2	No	No	No
SEPSDSA	varchar	1	No	No	No
SEPPSNO	varchar	1	No	No	No
SEPPRNT	varchar	1	No	No	No
SEPCOCD	varchar	1	No	No	No
SEPDPCD	varchar	25	No	Yes	No
SEPESCD	varchar	1	No	No	No
SEPSDCD	varchar	25	No	No	No
SEPPRIO	int	5	No	No	No
SEPSDMCODE	varchar	10	No	No	No
SDADATE	date	0	No	No	No
SDABALC	double	15,2	No	No	No
SDAUNPD	double	15,2	No	No	No

pmtskhb

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

pmtmwee

pmtmwee
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
MWEENUMB	varchar	15	No	No	No
MWEEDTE	date	0	No	No	No
MWEBASIC	double	15,2	No	No	No
MWEALLOW	double	15,2	No	No	No
MWE_WO_SEQN	varchar	4	No	No	No
MWE_WO_REGION_CODE	varchar	25	No	No	No
MWE_WO_REGION_AREA	varchar	25	No	No	No
MWE_WO_CLASS_CODE	varchar	25	No	No	No
MWE_WO_PCLASS	varchar	1	No	No	No
MWE_DATEE	datetime	0	No	No	No
MWE_REMK	varchar	1	No	No	No

pp2016

pp2016
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
recid	int	30	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
ACCOACD	varchar	10	No	No	No
ACCDESC	varchar	35	No	No	No
ACCNAME	varchar	35	No	No	No
ACCACDE	varchar	3	No	No	No

pymbank

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

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
SVLNUMB	varchar	15	No	No	No
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
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