Difference between revisions of "Myquota"

From SPGC Document Wiki
Jump to: navigation, search
 
(7 intermediate revisions by the same user not shown)
Line 1: Line 1:
 +
[[Main_Page | Main Page]] > [[Application_Development_Team | Application Development Team]] > [[DB_Specs | DB Specs]] > [[202.2.2.52 | 202.2.2.52]]
 +
 
==hst2016==
 
==hst2016==
 
{| class="wikitable" \
 
{| class="wikitable" \
Line 533: Line 535:
 
! Auto Increment
 
! Auto Increment
 
|-
 
|-
−
|QTACODE
+
|QTANUMB
 +
|varchar
 +
|15
 +
|No
 +
|No
 +
|No
 +
|-
 +
|QTACDTE
 +
|date
 +
|0
 +
|No
 +
|No
 +
|No
 +
|-
 +
|QTARP01
 
|varchar
 
|varchar
 
|5
 
|5
 +
|No
 +
|No
 +
|No
 +
|-
 +
|QTARO01
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|-
 +
|QTARP02
 +
|varchar
 +
|5
 +
|No
 +
|No
 +
|No
 +
|-
 +
|QTARO02
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|-
 +
|QTARP03
 +
|varchar
 +
|5
 +
|No
 +
|No
 +
|No
 +
|-
 +
|QTARO03
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|-
 +
|QTARP04
 +
|varchar
 +
|5
 +
|No
 +
|No
 +
|No
 +
|-
 +
|QTARO04
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|-
 +
|QTARP05
 +
|varchar
 +
|5
 +
|No
 +
|No
 +
|No
 +
|-
 +
|QTARO05
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|-
 +
|QTARP06
 +
|varchar
 +
|5
 +
|No
 +
|No
 +
|No
 +
|-
 +
|QTARO06
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|-
 +
|QTAOP01
 +
|varchar
 +
|5
 +
|No
 +
|No
 +
|No
 +
|-
 +
|QTAOO01
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|-
 +
|QTAOP02
 +
|varchar
 +
|5
 +
|No
 +
|No
 +
|No
 +
|-
 +
|QTAOO02
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|-
 +
|QTAOP03
 +
|varchar
 +
|5
 +
|No
 +
|No
 +
|No
 +
|-
 +
|QTAOO03
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|-
 +
|QTAOP04
 +
|varchar
 +
|5
 +
|No
 +
|No
 +
|No
 +
|-
 +
|QTAOO04
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|-
 +
|QTAOP05
 +
|varchar
 +
|5
 +
|No
 +
|No
 +
|No
 +
|-
 +
|QTAOO05
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|-
 +
|QTAOP06
 +
|varchar
 +
|5
 +
|No
 +
|No
 +
|No
 +
|-
 +
|QTAOO06
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|-
 +
|QTAHP01
 +
|varchar
 +
|5
 +
|No
 +
|No
 +
|No
 +
|-
 +
|QTAHO01
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|-
 +
|QTAHP02
 +
|varchar
 +
|5
 +
|No
 +
|No
 +
|No
 +
|-
 +
|QTAHO02
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|-
 +
|QTAHP03
 +
|varchar
 +
|5
 +
|No
 +
|No
 +
|No
 +
|-
 +
|QTAHO03
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|-
 +
|QTAHP04
 +
|varchar
 +
|5
 +
|No
 +
|No
 +
|No
 +
|-
 +
|QTAHO04
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|-
 +
|QTAHP05
 +
|varchar
 +
|5
 +
|No
 +
|No
 +
|No
 +
|-
 +
|QTAHO05
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|-
 +
|QTAHP06
 +
|varchar
 +
|5
 +
|No
 +
|No
 +
|No
 +
|-
 +
|QTAHO06
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|}
 +
 +
==quota_entry==
 +
{| class="wikitable" \
 +
!colspan="7" |quota_entry
 +
|-
 +
! style="text-align:left;" | Column Name
 +
! Data Type
 +
! Length
 +
! Is PrimaryKey
 +
! Is Not Null
 +
! Auto Increment
 +
|-
 +
|emp_no
 +
|varchar
 +
|15
 
|Yes
 
|Yes
 
|Yes
 
|Yes
 
|No
 
|No
 
|-
 
|-
−
|QTAEDTE
+
|actual_date
 
|date
 
|date
 
|0
 
|0
Line 547: Line 827:
 
|No
 
|No
 
|-
 
|-
−
|QTAREG
+
|day_type
−
|bigint
+
|varchar
−
|20
+
|10
 
|No
 
|No
 
|No
 
|No
 
|No
 
|No
 
|-
 
|-
−
|QTARTEQT
+
|reg_quota_code1
 +
|varchar
 +
|10
 +
|No
 +
|No
 +
|No
 +
|-
 +
|reg_actual_quota1
 
|double
 
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|-
 +
|reg_quota_code1_amt
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|-
 +
|reg_quota_code2
 +
|varchar
 +
|10
 +
|No
 +
|No
 +
|No
 +
|-
 +
|reg_actual_quota2
 +
|15,2
 
|0
 
|0
 
|No
 
|No
Line 561: Line 869:
 
|No
 
|No
 
|-
 
|-
−
|QTARTEPC
+
|reg_quota_code2_amt
 
|double
 
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|-
 +
|reg_quota_code3
 +
|varchar
 +
|10
 +
|No
 +
|No
 +
|No
 +
|-
 +
|reg_actual_quota3
 +
|15,2
 
|0
 
|0
 
|No
 
|No
 
|No
 
|No
 +
|No
 +
|-
 +
|reg_quota_code3_amt
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|-
 +
|reg_quota_code4
 +
|varchar
 +
|10
 +
|No
 +
|No
 +
|No
 +
|-
 +
|reg_actual_quota4
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|-
 +
|reg_quota_code4_amt
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|-
 +
|reg_quota_code_ot1
 +
|varchar
 +
|10
 +
|No
 +
|No
 +
|No
 +
|-
 +
|reg_actual_quota_ot1
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|-
 +
|reg_quota_code1_amt_ot
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|-
 +
|reg_quota_code_ot2
 +
|varchar
 +
|10
 +
|No
 +
|No
 +
|No
 +
|-
 +
|reg_actual_quota_ot2
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|-
 +
|reg_quota_code2_amt_ot
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|-
 +
|reg_quota_code_ot3
 +
|varchar
 +
|10
 +
|No
 +
|No
 +
|No
 +
|-
 +
|reg_actual_quota_ot3
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|-
 +
|reg_quota_code3_amt_ot
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|-
 +
|reg_quota_code_ot4
 +
|varchar
 +
|10
 +
|No
 +
|No
 +
|No
 +
|-
 +
|reg_actual_quota_ot4
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|-
 +
|reg_quota_code4_amt_ot
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|-
 +
|location
 +
|varchar
 +
|5
 +
|Yes
 +
|Yes
 
|No
 
|No
 
|}
 
|}
 +
 +
==svl2004==
 +
{| class="wikitable" \
 +
!colspan="7" | svl2004
 +
|-
 +
! style="text-align:left;" | Column Name
 +
! Data Type
 +
! Length
 +
! Is PrimaryKey
 +
! Is Not Null
 +
! Auto Increment
 +
|-
 +
|QTANUMB
 +
|varchar
 +
|15
 +
|No
 +
|No
 +
|No
 +
|-
 +
|QTACDTE
 +
|date
 +
|0
 +
|No
 +
|No
 +
|No
 +
|-
 +
|QTARP01
 +
|varchar
 +
|5
 +
|No
 +
|No
 +
|No
 +
|-
 +
|QTARO01
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|-
 +
|QTARP02
 +
|varchar
 +
|5
 +
|No
 +
|No
 +
|No
 +
|-
 +
|QTARO02
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|-
 +
|QTARP03
 +
|varchar
 +
|5
 +
|No
 +
|No
 +
|No
 +
|-
 +
|QTARO03
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|-
 +
|QTARP04
 +
|varchar
 +
|5
 +
|No
 +
|No
 +
|No
 +
|-
 +
|QTARO04
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|-
 +
|QTARP05
 +
|varchar
 +
|5
 +
|No
 +
|No
 +
|No
 +
|-
 +
|QTARO05
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|-
 +
|QTARP06
 +
|varchar
 +
|5
 +
|No
 +
|No
 +
|No
 +
|-
 +
|QTARO06
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|-
 +
|QTAOP01
 +
|varchar
 +
|5
 +
|No
 +
|No
 +
|No
 +
|-
 +
|QTAOO01
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|-
 +
|QTAOP02
 +
|varchar
 +
|5
 +
|No
 +
|No
 +
|No
 +
|-
 +
|QTAOO02
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|-
 +
|QTAOP03
 +
|varchar
 +
|5
 +
|No
 +
|No
 +
|No
 +
|-
 +
|QTAOO03
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|-
 +
|QTAOP04
 +
|varchar
 +
|5
 +
|No
 +
|No
 +
|No
 +
|-
 +
|QTAOO04
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|-
 +
|QTAOP05
 +
|varchar
 +
|5
 +
|No
 +
|No
 +
|No
 +
|-
 +
|QTAOO05
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|-
 +
|QTAOP06
 +
|varchar
 +
|5
 +
|No
 +
|No
 +
|No
 +
|-
 +
|QTAOO06
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|-
 +
|QTAHP01
 +
|varchar
 +
|5
 +
|No
 +
|No
 +
|No
 +
|-
 +
|QTAHO01
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|-
 +
|QTAHP02
 +
|varchar
 +
|5
 +
|No
 +
|No
 +
|No
 +
|-
 +
|QTAHO02
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|-
 +
|QTAHP03
 +
|varchar
 +
|5
 +
|No
 +
|No
 +
|No
 +
|-
 +
|QTAHO03
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|-
 +
|QTAHP04
 +
|varchar
 +
|5
 +
|No
 +
|No
 +
|No
 +
|-
 +
|QTAHO04
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|-
 +
|QTAHP05
 +
|varchar
 +
|5
 +
|No
 +
|No
 +
|No
 +
|-
 +
|QTAHO05
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|-
 +
|QTAHP06
 +
|varchar
 +
|5
 +
|No
 +
|No
 +
|No
 +
|-
 +
|QTAHO06
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|}
 +
 +
[[Main_Page | Main Page]] > [[Application_Development_Team | Application Development Team]] > [[DB_Specs | DB Specs]] > [[202.2.2.52 | 202.2.2.52]]

Latest revision as of 09:20, 1 September 2016

Main Page > Application Development Team > DB Specs > 202.2.2.52

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


pmtempl

pmtempl
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
EMPNUMB varchar 15 Yes Yes No
EMPLNAM varchar 15 No No No
EMPFNAM varchar 20 No No No
EMPMNAM varchar 15 No No No
EMPTXCD varchar 15 No No No
EMPNUMB varchar 10 No No No
EMPSSNO varchar 12 No No No
EMPTINO varchar 11 No No No
EMPPMCD varchar 1 No No No
EMPCOCD varchar 1 No No No
EMPLCCD varchar 3 No No No
EMPSTAT varchar 1 No No No
EMPPINO varchar 12 No No No
EMPDPCD varchar 10 No No No
QTACODE varchar 10 No No No

pmtproc

pmtproc
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
PROCODE varchar 5 No No No
PRODESC varchar 35 No No No
PROGRPC varchar 3 No No No
PROABBR varchar 5 No No No

pmtproc_mey

pmtproc_mey
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
PROCODE varchar 5 No No No
PRODESC varchar 35 No No No
PROGRPC varchar 3 No No No
PROABBR varchar 5 No No No

pmtqota

pmtqota
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
QTACODE varchar 5 Yes Yes No
QTAEDTE date 0 No No No
QTAREG bigint 20 No No No
QTARTEQT double 0 No No No
QTARTEPC double 0 No No No

qta2016_20160301

qta2016_20160301
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
QTANUMB varchar 15 No No No
QTACDTE date 0 No No No
QTARP01 varchar 5 No No No
QTARO01 double 15,2 No No No
QTARP02 varchar 5 No No No
QTARO02 double 15,2 No No No
QTARP03 varchar 5 No No No
QTARO03 double 15,2 No No No
QTARP04 varchar 5 No No No
QTARO04 double 15,2 No No No
QTARP05 varchar 5 No No No
QTARO05 double 15,2 No No No
QTARP06 varchar 5 No No No
QTARO06 double 15,2 No No No
QTAOP01 varchar 5 No No No
QTAOO01 double 15,2 No No No
QTAOP02 varchar 5 No No No
QTAOO02 double 15,2 No No No
QTAOP03 varchar 5 No No No
QTAOO03 double 15,2 No No No
QTAOP04 varchar 5 No No No
QTAOO04 double 15,2 No No No
QTAOP05 varchar 5 No No No
QTAOO05 double 15,2 No No No
QTAOP06 varchar 5 No No No
QTAOO06 double 15,2 No No No
QTAHP01 varchar 5 No No No
QTAHO01 double 15,2 No No No
QTAHP02 varchar 5 No No No
QTAHO02 double 15,2 No No No
QTAHP03 varchar 5 No No No
QTAHO03 double 15,2 No No No
QTAHP04 varchar 5 No No No
QTAHO04 double 15,2 No No No
QTAHP05 varchar 5 No No No
QTAHO05 double 15,2 No No No
QTAHP06 varchar 5 No No No
QTAHO06 double 15,2 No No No

quota_entry

quota_entry
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
emp_no varchar 15 Yes Yes No
actual_date date 0 No No No
day_type varchar 10 No No No
reg_quota_code1 varchar 10 No No No
reg_actual_quota1 double 15,2 No No No
reg_quota_code1_amt double 15,2 No No No
reg_quota_code2 varchar 10 No No No
reg_actual_quota2 15,2 0 No No No
reg_quota_code2_amt double 15,2 No No No
reg_quota_code3 varchar 10 No No No
reg_actual_quota3 15,2 0 No No No
reg_quota_code3_amt double 15,2 No No No
reg_quota_code4 varchar 10 No No No
reg_actual_quota4 double 15,2 No No No
reg_quota_code4_amt double 15,2 No No No
reg_quota_code_ot1 varchar 10 No No No
reg_actual_quota_ot1 double 15,2 No No No
reg_quota_code1_amt_ot double 15,2 No No No
reg_quota_code_ot2 varchar 10 No No No
reg_actual_quota_ot2 double 15,2 No No No
reg_quota_code2_amt_ot double 15,2 No No No
reg_quota_code_ot3 varchar 10 No No No
reg_actual_quota_ot3 double 15,2 No No No
reg_quota_code3_amt_ot double 15,2 No No No
reg_quota_code_ot4 varchar 10 No No No
reg_actual_quota_ot4 double 15,2 No No No
reg_quota_code4_amt_ot double 15,2 No No No
location varchar 5 Yes Yes No

svl2004

svl2004
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
QTANUMB varchar 15 No No No
QTACDTE date 0 No No No
QTARP01 varchar 5 No No No
QTARO01 double 15,2 No No No
QTARP02 varchar 5 No No No
QTARO02 double 15,2 No No No
QTARP03 varchar 5 No No No
QTARO03 double 15,2 No No No
QTARP04 varchar 5 No No No
QTARO04 double 15,2 No No No
QTARP05 varchar 5 No No No
QTARO05 double 15,2 No No No
QTARP06 varchar 5 No No No
QTARO06 double 15,2 No No No
QTAOP01 varchar 5 No No No
QTAOO01 double 15,2 No No No
QTAOP02 varchar 5 No No No
QTAOO02 double 15,2 No No No
QTAOP03 varchar 5 No No No
QTAOO03 double 15,2 No No No
QTAOP04 varchar 5 No No No
QTAOO04 double 15,2 No No No
QTAOP05 varchar 5 No No No
QTAOO05 double 15,2 No No No
QTAOP06 varchar 5 No No No
QTAOO06 double 15,2 No No No
QTAHP01 varchar 5 No No No
QTAHO01 double 15,2 No No No
QTAHP02 varchar 5 No No No
QTAHO02 double 15,2 No No No
QTAHP03 varchar 5 No No No
QTAHO03 double 15,2 No No No
QTAHP04 varchar 5 No No No
QTAHO04 double 15,2 No No No
QTAHP05 varchar 5 No No No
QTAHO05 double 15,2 No No No
QTAHP06 varchar 5 No No No
QTAHO06 double 15,2 No No No

Main Page > Application Development Team > DB Specs > 202.2.2.52

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