Main Page > Application Development Team > DB Specs > 202.2.2.52
ahs2017
| ahs2016
|
| Column Name
|
Data Type
|
Length
|
Is PrimaryKey
|
Is Not Null
|
Auto Increment
|
Description
|
| AHSNUMB
|
Varchar
|
15
|
No
|
No
|
No
|
Employee No.
|
| AHSGPAY
|
double
|
15,2
|
No
|
No
|
No
|
Gross Pay
|
| AHSALLO
|
double
|
15,2
|
No
|
No
|
No
|
Allowance
|
| AHS13MO
|
double
|
15,2
|
No
|
No
|
No
|
13th Month Pay
|
| AHSSLVL
|
double
|
15,2
|
No
|
No
|
No
|
SL/VL Pay
|
| AHSSVLR
|
double
|
15,2
|
No
|
No
|
No
|
SL/VL Remaining
|
| AHSBONS
|
double
|
15,2
|
No
|
No
|
No
|
Bonus
|
| AHSTAXD
|
double
|
15,2
|
No
|
No
|
No
|
Tax Due
|
| AHSTAXW
|
double
|
15,2
|
No
|
No
|
No
|
Tax WithHeld
|
attk_essi2017
| attk_essi2017
|
| Column Name
|
Data Type
|
Length
|
Is PrimaryKey
|
Is Not Null
|
Auto Increment
|
Description
|
| EMPNUMB
|
Varchar
|
15
|
No
|
No
|
No
|
|
| AAM
|
Date Time
|
15
|
No
|
No
|
No
|
|
| APM
|
Date Time
|
None
|
No
|
No
|
No
|
|
| OAM
|
Date Time
|
None
|
No
|
No
|
No
|
|
| OPM
|
Date Time
|
None
|
No
|
No
|
No
|
|
| OFLAG
|
varchar
|
10
|
No
|
No
|
No
|
|
| LVHR
|
double
|
15,2
|
No
|
No
|
No
|
|
| LVCODE
|
varchar
|
10
|
No
|
No
|
No
|
|
| LVOPTN
|
varchar
|
1
|
No
|
No
|
No
|
|
| CWSTAG
|
varchar
|
10
|
No
|
No
|
No
|
|
| UNTAG
|
varchar
|
10
|
No
|
No
|
No
|
|
| LATES_AM
|
double
|
15,2
|
No
|
No
|
No
|
|
| LATES_AP
|
double
|
15,2
|
No
|
No
|
No
|
|
| THOURS
|
double
|
15,2
|
No
|
No
|
No
|
|
| ACT_HOURS
|
double
|
15,2
|
No
|
No
|
No
|
|
| NDED
|
double
|
15,2
|
No
|
No
|
No
|
|
| OHOURS
|
double
|
15,2
|
No
|
No
|
No
|
|
| DAYCODE
|
varchar
|
10
|
No
|
No
|
No
|
|
attk_sppe2017
| attk_sppe2017
|
| Column Name
|
Data Type
|
Length
|
Is PrimaryKey
|
Is Not Null
|
Auto Increment
|
Description
|
| EMPNUMB
|
Varchar
|
15
|
No
|
No
|
No
|
|
| AAM
|
Date Time
|
15
|
No
|
No
|
No
|
|
| APM
|
Date Time
|
None
|
No
|
No
|
No
|
|
| OAM
|
Date Time
|
None
|
No
|
No
|
No
|
|
| OPM
|
Date Time
|
None
|
No
|
No
|
No
|
|
| OFLAG
|
varchar
|
10
|
No
|
No
|
No
|
|
| LVHR
|
double
|
15,2
|
No
|
No
|
No
|
|
| LVCODE
|
varchar
|
10
|
No
|
No
|
No
|
|
| LVOPTN
|
varchar
|
1
|
No
|
No
|
No
|
|
| CWSTAG
|
varchar
|
10
|
No
|
No
|
No
|
|
| UNTAG
|
varchar
|
10
|
No
|
No
|
No
|
|
| LATES_AM
|
double
|
15,2
|
No
|
No
|
No
|
|
| LATES_AP
|
double
|
15,2
|
No
|
No
|
No
|
|
| THOURS
|
double
|
15,2
|
No
|
No
|
No
|
|
| ACT_HOURS
|
double
|
15,2
|
No
|
No
|
No
|
|
| NDED
|
double
|
15,2
|
No
|
No
|
No
|
|
| OHOURS
|
double
|
15,2
|
No
|
No
|
No
|
|
| DAYCODE
|
varchar
|
10
|
No
|
No
|
No
|
|
bonus2017
| bonus2017
|
| Column Name
|
Data Type
|
Length
|
Is PrimaryKey
|
Is Not Null
|
Auto Increment
|
Description
|
| 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
|
|
