Mypmsdb

From SPGC Document Wiki

Revision as of 17:56, 29 June 2016 by Agcarrera (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Jump to: navigation, search

Contents

1 ahs2016
2 alphalist_log
3 auditlogs
4 bse2016
5 bsm2016
6 bsw_2016sppe
7 cm2016
8 cw2016
9 cws2016
10 dailymhr2016
11 dt2016
12 dtr2016
13 dtt2016
14 dw2016
15 emphold_alogs
16 fp_id
17 fpid
18 hst2016

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

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

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

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