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
|
PVFyyyy.DBF - Payroll Verification File
where yyyy - current year
| Field Name
|
Type
|
Width
|
Dec
|
Description
|
| PVFNUMB
|
Character
|
08
|
|
Employee No.
|
| PVFSDCD
|
Character
|
03
|
|
SDSA Code
|
| PVFPDTE
|
Date
|
08
|
|
Date
|
| PVFBPAY
|
Numeric
|
10
|
02
|
Basic Pay
|
| PVFALLO
|
Numeric
|
08
|
02
|
Allowance
|
| PVFTAGD
|
Character
|
01
|
|
Tagging
|
| PVFPDAY
|
Numeric
|
02
|
|
No. of Days
|
| PVFHOUR
|
Numeric
|
02
|
|
No. of Hours
|
| PVFMINS
|
Numeric
|
02
|
|
Minutes
|
| PVFSDSA
|
Character
|
01
|
|
SDSA Code
|
| PVFEDTE
|
Date
|
08
|
|
Effectivity Date
|
| PVFAMNT
|
Numeric
|
08
|
02
|
Amount
|
| PVFDATE
|
Date
|
08
|
|
Date
|
| PVFNRD1
|
Numeric
|
06
|
02
|
Night Shift Regular Hours
|
| PVFRRD2
|
Numeric
|
06
|
02
|
Rest Day
|
| PVFRRO2
|
Numeric
|
06
|
02
|
Rest Day OT
|
| PVFNRD2
|
Numeric
|
06
|
02
|
Night Shift Rest Day
|
| PVFNRO2
|
Numeric
|
06
|
02
|
Rest Day Night Shift OT
|
| PVFRRO1
|
Numeric
|
06
|
02
|
Regular OT
|
| PVFNRO1
|
Numeric
|
06
|
02
|
Night Shift OT
|
| PVFPRNT
|
Character
|
01
|
|
Print
|
| PVFUSER
|
Character
|
10
|
|
Username
|
| Index Name
|
Index Key
|
| PVFyyyy1.NTX
|
PVPNUMB+DTOS(PVFDTE)+PVFSDCD
|
| PVFyyyy1.NTX
|
PVPFPRNT+PVFUSER+DTOS(PVFDATE)
|
