Itk

Main Page > Application Development Team > DB Specs > 202.2.2.52

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_TBL	varchar	60	No	Yes	No
LOG_DATE	date	0	No	No	No
LOG_TIME	varchar	10	No	No	No
LOG_ENUMB	varchar	15	No	No	No
LOG_KEYREC	varchar	60	No	No	No
LOG_FIELD	varchar	20	No	No	No
LOG_OLDVAL	varchar	30	No	Yes	No
LOG_NEWVAL	varchar	30	No	Yes	No
LOG_CHANGE	varchar	1	No	Yes	No
LOG_IPADDR	varchar	20	No	No	No
LOG_PRNT	varchar	1	No	Yes	No
LOG_SQLEXEC	longtext	0	No	Yes	No

dailymhr2015

dailymhr2015
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
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	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	varchar	1	No	No	No
MHRSPLLV	double	15,2	No	No	No
MHRLCCD	varchar	25	No	No	No
MHRDDSL	MHRTDPD	25	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
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	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	varchar	1	No	No	No
MHRSPLLV	double	15,2	No	No	No
MHRLCCD	varchar	25	No	No	No
MHRTDPD	varchar	25	No	No	No

dtt2015

dtt2015
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_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	1	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

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_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	1	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

employee

employee
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
recid	int	25	Yes	Yes	Yes
EMPNUMB	varchar	25	No	No	No
AEMPNUMB	varchar	25	No	No	No
EMPLNAM	varchar	30	No	No	No
EMPFNAM	varchar	30	No	No	No
EMPMNAM	varchar	30	No	No	No
EMPSXCD	varchar	1	No	No	No
EMPBDTE	date	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	date	0	No	No	No
EMPSSNO	varchar	25	No	No	No
EMPTINO	varchar	25	No	No	No
EMPHDTE	date	0	No	No	No
EMPODTE	date	0	No	No	No
EMPPMCD	varchar	1	No	No	No
EMPPCCD	varchar	1	No	No	No
EMPCOCD	datetime	0	No	No	No
EMPLCCD	varchar	25	No	No	No
EMPPSCD	varchar	25	No	No	No
EMPSTAT	varchar	1	No	No	No
EMPSTDT	date	0	No	No	No
EMPPINO	varchar	12	No	No	No
EMPAVOL	tinyint	1	No	No	No
EMPPVOL	tinyint	1	No	No	No
EMPTDPD	varchar	1	No	No	No
EMPCBAT	varchar	1	No	No	No
EMPDPCD	varchar	25	No	No	No
EMPESCD	varchar	1	No	No	No
EMPDPCC	varchar	10	No	No	No
EMPINCO	varchar	1	No	No	No
EMPBPAY	double	15,2	No	No	No
EMPALLO	double	15,2	No	No	No
EMPFEPF	varchar	1	No	No	No
EMPHLDT	date	0	No	No	No
EMPMENO	varchar	25	No	No	No
EMPDBNK	varchar	5	No	No	No
EMPEOCD	date	0	No	No	No
EMPEOCC	varchar	1	No	No	No
EMPADDR1	varchar	150	No	No	No
EMPADDR2	varchar	150	No	No	No
EMPADDR3	varchar	150	No	No	No
EMPADDR4	varchar	150	No	No	No
EMPATMP	varchar	16	No	No	No
EMPTELN	varchar	150	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
EMPREC_UPLD	varchar	1	No	No	No
EMPREC_PSTD	varchar	1	No	No	No
EMPREGN	varchar	25	No	No	No
EMPREGNAREA	varchar	25	No	No	No
EMPPACD	varchar	25	No	No	No
EMPWSCD	varchar	25	No	No	No
EMPFPER	varchar	25	No	No	No
EMPPYEF	date	0	No	No	No
EMPBLOC	varchar	25	No	No	No
EMPORDRD	varchar	1	No	No	No
EMPORGRD	varchar	1	No	No	No
EMPUSER	varchar	10	No	No	No
EMP_UPLD_USER	varchar	10	No	No	No
EMP_UPLD_DPROC	datetime	0	No	No	No
EMPENCD	datetime	0	No	No	No

lvdt2015

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

lvdt2016

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

mhr_2015

mhr_2015
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

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

mst_attlogs

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

obtp2015

obtp2015
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
recid	int	30	Yes	Yes	No
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	varchar	0	No	No	No
FP_DPCD	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

obtp2016

obtp2016
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
recid	int	30	Yes	Yes	No
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	varchar	0	No	No	No
FP_DPCD	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

otdt2015

otdt2015
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
recid	int	30	Yes	Yes	No
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	varchar	0	No	No	No
FP_DPCD	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_STIME	datetime	0	No	No	No
OB_ETIME	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

otdt2016

otdt2016
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
recid	int	30	Yes	Yes	No
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	varchar	0	No	No	No
FP_DPCD	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_STIME	datetime	0	No	No	No
OB_ETIME	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

otpay2015

otpay2015
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
recid	int	25	Yes	Yes	No
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	10,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

otpay2016

otpay2016
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
recid	int	25	Yes	Yes	No
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	10,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

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

posting_logs

posting_logs
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
recid	int	30	Yes	Yes	No
COMPANY	varchar	25	No	No	No
SITE	varchar	25	No	No	No
PCLASS	varchar	25	No	No	No
MODULE	varchar	60	No	No	No
MPERIOD	date	0	No	No	No
DATEP	datetime	25	No	No	No
USERN	varchar	25	No	No	No

undt2015

undt2015
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
recid	int	30	Yes	Yes	No
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	varchar	0	No	No	No
FP_DPCD	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_FTIME	datetime	0	No	No	No
OB_TTIME	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

undt2016

undt2016
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
recid	int	30	Yes	Yes	No
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	varchar	0	No	No	No
FP_DPCD	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_FTIME	datetime	0	No	No	No
OB_TTIME	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

Main Page > Application Development Team > DB Specs > 202.2.2.52