Difference between revisions of "File(s) located at R:\PAY\PAY\DBF"

From SPGC Document Wiki
Jump to: navigation, search
(Created page with " Main Page > Application Development Team > DB Specs > Payroll DB == Database File == === P...")
 
Line 146: Line 146:
 
|PYTFIXP1.NTX
 
|PYTFIXP1.NTX
 
|FIXNUMB
 
|FIXNUMB
 +
|}
 +
=== PVFyyyy.DBF - Payroll Verification File ===
 +
<p>where yyyy - current year </p>
 +
{| class="wikitable" \
 +
|-
 +
! style="text-align:left;" | 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
 +
|}
 +
{| class="wikitable" \
 +
!style="text-align:left;"|Index Name
 +
!Index Key
 +
|-
 +
|PVFyyyy1.NTX
 +
|PVPNUMB+DTOS(PVFDTE)+PVFSDCD
 +
|-
 +
|PVFyyyy1.NTX
 +
|PVPFPRNT+PVFUSER+DTOS(PVFDATE)
 
|}
 
|}

Revision as of 17:31, 13 January 2017

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)
Retrieved from "http://115.85.30.86:286/spgcwiki/index.php?title=File(s)_located_at_R:%5CPAY%5CPAY%5CDBF&oldid=4496"