Difference between revisions of "Mypaydb"

Revision as of 15:38, 24 June 2016 (view source) Agcarrera (Talk | contribs) ← Older edit		Revision as of 16:01, 24 June 2016 (view source) Agcarrera (Talk | contribs) (→‎hst2016) Newer edit →
Line 4,156:		Line 4,156:
	! Auto Increment		! Auto Increment
	|-		|-
−	|recid	+	|HSTNUMB
−	|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		|varchar
−	|30	+	|15
	|No		|No
	|No		|No
	|No		|No
	|-		|-
−	|DT_LCCD	+	|HSTCDTE
−	|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		|datetime
	|0		|0
Line 4,247:		Line 4,170:
	|No		|No
	|-		|-
−	|DT_SAMOUT	+	|HSTMPAY
−	|datetime	+
−	|0	+
−	|No	+
−	|No	+
−	|No	+
−	|-	+
−	|DT_SPMIN	+
−	|datetime	+
−	|0	+
−	|No	+
−	|No	+
−	|No	+
−	|-	+
−	|DT_SPMOUT	+
−	|datetime	+
−	|0	+
−	|No	+
−	|No	+
−	|No	+
−	|-	+
−	|DT_GPERD	+
	|double		|double
	|15,2		|15,2
Line 4,275:		Line 4,177:
	|No		|No
	|-		|-
−	|DT_NSSTART	+	|HSTMALL
−	|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		|double
	|15,2		|15,2
Line 4,352:		Line 4,184:
	|No		|No
	|-		|-
−	|DT_AMIN	+	|HSTBPAY
−	|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		|double
	|15,2		|15,2
Line 4,429:		Line 4,191:
	|No		|No
	|-		|-
−	|DT_PMLATES	+	|HSTBALL
	|double		|double
	|15,2		|15,2
Line 4,436:		Line 4,198:
	|No		|No
	|-		|-
−	|DT_UNDERT	+	|HSTGPAY
	|double		|double
	|15,2		|15,2
Line 4,443:		Line 4,205:
	|No		|No
	|-		|-
−	|DT_UTFILE	+	|HSTSSSR
	|double		|double
	|15,2		|15,2
Line 4,450:		Line 4,212:
	|No		|No
	|-		|-
−	|DT_ATHRS	+	|HSTSSSE
	|double		|double
	|15,2		|15,2
Line 4,457:		Line 4,219:
	|No		|No
	|-		|-
−	|DT_ABS	+	|HSTTAXC
	|double		|double
	|15,2		|15,2
Line 4,464:		Line 4,226:
	|No		|No
	|-		|-
−	|DT_REQTHRS	+	|HSTECCM
	|double		|double
	|15,2		|15,2
Line 4,471:		Line 4,233:
	|No		|No
	|-		|-
−	|DT_NS_HRS	+	|HSTPIBE
	|double		|double
	|15,2		|15,2
Line 4,478:		Line 4,240:
	|No		|No
	|-		|-
−	|DT_AM_NS_HRS	+	|HSTPIBR
	|double		|double
	|15,2		|15,2
Line 4,485:		Line 4,247:
	|No		|No
	|-		|-
−	|DT_ROTAM	+	|HSTMEDE
	|double		|double
	|15,2		|15,2
Line 4,492:		Line 4,254:
	|No		|No
	|-		|-
−	|DT_ROTPM	+	|HSTMEDR
	|double		|double
	|15,2		|15,2
Line 4,499:		Line 4,261:
	|No		|No
	|-		|-
−	|DT_USER	+	|HSTTDED
−	|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		|double
	|15,2		|15,2
Line 4,548:		Line 4,268:
	|No		|No
	|-		|-
−	|DT_OTPM_PD	+	|HSTADON
	|double		|double
	|15,2		|15,2
Line 4,555:		Line 4,275:
	|No		|No
	|-		|-
−	|DT_AMLATES_DED	+	|HSTNSPY
	|double		|double
	|15,2		|15,2
Line 4,562:		Line 4,282:
	|No		|No
	|-		|-
−	|DT_UNDERT_DED	+	|HSTOTNS
	|double		|double
	|15,2		|15,2
Line 4,569:		Line 4,289:
	|No		|No
	|-		|-
−	|DT_OTREG_PD	+	|HSTOTPY
	|double		|double
	|15,2		|15,2
Line 4,576:		Line 4,296:
	|No		|No
	|-		|-
−	|DT_REG_HRS_PD	+	|HSTSLPY
	|double		|double
	|15,2		|15,2
Line 4,583:		Line 4,303:
	|No		|No
	|-		|-
−	|DT_NS_HRS_PD	+	|HSTVLPY
	|double		|double
	|15,2		|15,2
Line 4,590:		Line 4,310:
	|No		|No
	|-		|-
−	|DT_THRSWS	+	|HSTDOPY
	|double		|double
	|15,2		|15,2
Line 4,597:		Line 4,317:
	|No		|No
	|-		|-
−	|DT_AMLATES_MIN	+	|HSTLHPY
	|double		|double
	|15,2		|15,2
Line 4,604:		Line 4,324:
	|No		|No
	|-		|-
−	|DT_UNDERT_MIN	+	|HSTSHPY
	|double		|double
	|15,2		|15,2
Line 4,611:		Line 4,331:
	|No		|No
	|-		|-
−	|DT_EMP_RDORG	+	|HSTCOFF
	|varchar		|varchar
	|3		|3
Line 4,618:		Line 4,338:
	|No		|No
	|-		|-
−	|DT_EMP_RDORD	+	|HSTCOCD
	|varchar		|varchar
−	|3	+	|1
	|No		|No
	|No		|No
	|No		|No
	|-		|-
−	|DT_EMP_OTSUN	+	|HSTPCCD
	|varchar		|varchar
	|1		|1
Line 4,632:		Line 4,352:
	|No		|No
	|-		|-
−	|DT_EMP_OTHOL	+	|HSTHOLD
	|varchar		|varchar
	|1		|1
Line 4,639:		Line 4,359:
	|No		|No
	|-		|-
−	|DT_EMP_OTREG	+	|HSTPYNO
	|varchar		|varchar
−	|1	+	|9
	|No		|No
	|No		|No
	|No		|No
	|-		|-
−	|DT_PYTYPE	+	|HSTDPCD
	|varchar		|varchar
−	|1	+	|10
	|No		|No
	|No		|No
	|No		|No
	|-		|-
−	|DT_TXTYPE	+	|HSTLCCD
	|varchar		|varchar
−	|1	+	|3
	|No		|No
	|No		|No
	|No		|No
	|-		|-
−	|DT_ERATEC	+	|HSTPMCD
	|varchar		|varchar
−	|25	+	|1
	|No		|No
	|No		|No
	|No		|No
	|-		|-
−	|DT_NODYYR	+	|HSTPSNO
−	|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		|varchar
−	|25	+	|1
	|No		|No
	|No		|No
	|No		|No
	|-		|-
−	|DT_LVP_DYS	+	|HSTBKCD
−	|double	+
−	|15,2	+
−	|No	+
−	|No	+
−	|No	+
−	|-	+
−	|DT_LVP_HRS	+
−	|double	+
−	|15,2	+
−	|No	+
−	|No	+
−	|No	+
−	|-	+
−	|DT_CS	+
	|varchar		|varchar
−	|25	+	|5
	|No		|No
	|No		|No
	|No		|No
	|-		|-
−	|DT_REGD_X8	+	|HSTESCD
−	|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		|varchar
	|1		|1
Line 4,751:		Line 4,408:
	|No		|No
	|-		|-
−	|DT_OT_IN	+	|HSTFLPY
−	|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		|double
	|15,2		|15,2
Line 4,793:		Line 4,415:
	|No		|No
	|-		|-
−	|DT_AUTO_AMWDAY	+	|HSTTDPD
−	|double	+
−	|15,2	+
−	|No	+
−	|No	+
−	|No	+
−	|-	+
−	|DT_MINS_MIN_OT	+
−	|double	+
−	|15,2	+
−	|No	+
−	|No	+
−	|No	+
−	|-	+
−	|DT_MFLAG_DAY	+
	|varchar		|varchar
	|1		|1
Line 4,813:		Line 4,421:
	|No		|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
−	|}
−
	|}		|}

---

Revision as of 16:01, 24 June 2016

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