Main Page > Application Development Team > DB Specs > Payroll DB
Database File
PYMPYMT.DBF - SDSA Payment File
| Field Name
|
Type
|
Width
|
Dec
|
Description
|
| PYMNUMB
|
Character
|
08
|
|
Employee No.
|
| PYMSDCD
|
Character
|
03
|
|
SDSA Code
|
| PYMSDDT
|
Date
|
08
|
|
Deduction Date
|
| PYMDATE
|
Date
|
08
|
|
Payment Date
|
| PYMAMNT
|
Numeric
|
10
|
02
|
Payment Amount
|
| Index Name
|
Index Key
|
| PYMPYMT1.NTX
|
PYNUMB+DTOS(PYMDATE)+PYMSDCD+DTOS(PYMSDDT)
|
PYTSEPS.DBF - Temporary Chrono
| Field Name
|
Type
|
Width
|
Dec
|
Description
|
| TMPSCDE
|
Character
|
01
|
|
Code
|
| TMPIDNO
|
Character
|
09
|
|
ID No.
|
| TMPTERM
|
Character
|
01
|
|
Term
|
| TMPDATE
|
Character
|
06
|
|
Date
|
| TMPDAY
|
Character
|
01
|
|
Day
|
| TMPTIME
|
Character
|
04
|
|
Time
|
| TMPLCDE
|
Character
|
01
|
|
|
| TMPREMK
|
Character
|
20
|
|
Remarks
|
| Index Name
|
Index Key
|
| PYTTEMP1.NTX
|
TMPDATE+TMPIDNO+TMPTIME+TMPLCDE
|
PYTFIXP.DBF - Fix Pag-ibig Contribution
| Field Name
|
Type
|
Width
|
Dec
|
Description
|
| FIXNUMB
|
Character
|
08
|
|
Employee No.
|
| FIXFLAG
|
Logical
|
01
|
|
Flag
|
| FIXAMNT
|
Numeric
|
07
|
02
|
Fix Amount
|
| Index Name
|
Index Key
|
| PYTFIXP1.NTX
|
FIXNUMB
|
