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

From SPGC Document Wiki
Jump to: navigation, search
Line 298: Line 298:
 
|PVFyyyy1.NTX
 
|PVFyyyy1.NTX
 
|PVPFPRNT+PVFUSER+DTOS(PVFDATE)
 
|PVPFPRNT+PVFUSER+DTOS(PVFDATE)
 +
|}
 +
=== SVLyyyy.DBF - SLVL File (Rank & File) ===
 +
<p> where yyyy - current year </p>
 +
{| class="wikitable" \
 +
|-
 +
! style="text-align:left;" | Field Name
 +
! Type
 +
! Width
 +
! Dec
 +
! Description
 +
|-
 +
|SVLNUMB
 +
|Character
 +
|08
 +
|
 +
|Employee No.
 +
|-
 +
|SVLEDTE
 +
|Date
 +
|08
 +
|
 +
|Date
 +
|-
 +
|SVLSLEN
 +
|Numeric
 +
|04
 +
|
 +
|SL Entitlement
 +
|-
 +
|SVLVLEN
 +
|Numeric
 +
|04
 +
|
 +
|VL Entitlement
 +
|-
 +
|SVLFLEN
 +
|Numeric
 +
|04
 +
|
 +
|FL Entitlement
 +
|-
 +
|SVLSLRE
 +
|Numeric
 +
|06
 +
|02
 +
|SL Remaining
 +
|-
 +
|SVLVLRE
 +
|Numeric
 +
|06
 +
|02
 +
|VL Remaining
 +
|-
 +
|SVLFLRE
 +
|Numeric
 +
|06
 +
|02
 +
|FL Remaining
 +
|}
 +
{| class="wikitable" \
 +
!style="text-align:left;"|Index Name
 +
!Index Key
 +
|-
 +
|SVLyyyy1.NTX
 +
|SVLNUMB
 +
|}
 +
=== COUNTER.DBF - Bartillo Counter File===
 +
{| class="wikitable" \
 +
|-
 +
! style="text-align:left;" | Field Name
 +
! Type
 +
! Width
 +
! Dec
 +
! Description
 +
|-
 +
|TMPPFNO
 +
|Numeric
 +
|08
 +
|
 +
|Purchase Form No.
 +
|-
 +
|TMPPCCD
 +
|Character
 +
|01
 +
|
 +
|Payment Class
 +
|-
 +
|TMPCOCD
 +
|Character
 +
|01
 +
|
 +
|Company
 +
|}
 +
{| class="wikitable" \
 +
!style="text-align:left;"|Index Name
 +
!Index Key
 +
|-
 +
|COUNTER1.NTX
 +
|TMPPCCD+TMPCOCD
 +
|}
 +
=== METROLOG.DBF - Log File for MetroBank Report ===
 +
{| class="wikitable" \
 +
|-
 +
! style="text-align:left;" | Field Name
 +
! Type
 +
! Width
 +
! Dec
 +
! Description
 +
|-
 +
|LOGNUMB
 +
|Character
 +
|08
 +
|
 +
|Log No.
 +
|-
 +
|LOGACCT
 +
|Character
 +
|12
 +
|
 +
|Log Account
 +
|-
 +
|LOGSLRY
 +
|Numeric
 +
|09
 +
|02
 +
|Log Salary
 +
|-
 +
|LOGDATE
 +
|Date
 +
|08
 +
|
 +
|Log Date
 +
|-
 +
|LOGTIME
 +
|Character
 +
|08
 +
|
 +
|Log Time
 +
|}
 +
{| class="wikitable" \
 +
!style="text-align:left;"|Index Name
 +
!Index Key
 +
|-
 +
|METROLOG1.NTX
 +
|LOGNUMB+DTOS(LOGDATE)
 +
|}
 +
=== PYTCHRO.DBF - Chrono Filed===
 +
{| class="wikitable" \
 +
|-
 +
! style="text-align:left;" | Field Name
 +
! Type
 +
! Width
 +
! Dec
 +
! Description
 +
|-
 +
|CRONUMB
 +
|Character
 +
|08
 +
|
 +
|Employee No.
 +
|-
 +
|CROCRNO
 +
|Character
 +
|12
 +
|
 +
|Chrono No.
 +
|}
 +
{| class="wikitable" \
 +
!style="text-align:left;"|Index Name
 +
!Index Key
 +
|-
 +
|PTCHRO1.NTX
 +
|CROCRNO
 +
|}
 +
=== MHWyyyy.DBF - Man hour File (Weekly)===
 +
<p>where yyyy - current </p>
 +
{| class="wikitable" \
 +
|-
 +
! style="text-align:left;" | Field Name
 +
! Type
 +
! Width
 +
! Dec
 +
! Description
 +
|-
 +
|MHWNUMB
 +
|Character
 +
|08
 +
|
 +
|Employee No.
 +
|-
 +
|MHWCDTE
 +
|Date
 +
|08
 +
|
 +
|Out Date
 +
|-
 +
|MHWTRDY
 +
|Numeric
 +
|07
 +
|02
 +
|Tardy
 +
|-
 +
|MHWUTME
 +
|Numeric
 +
|06
 +
|02
 +
|Undertime
 +
|-
 +
|MHWSLLV
 +
|Numeric
 +
|06
 +
|02
 +
|Filed SL
 +
|-
 +
|MHWVLLV
 +
|Numeric
 +
|06
 +
|02
 +
|Filed VL
 +
|-
 +
|MHWULOA
 +
|Numeric
 +
|06
 +
|02
 +
|Unpaid LOA
 +
|-
 +
|MHWWOLV
 +
|Numeric
 +
|06
 +
|02
 +
|Without LOA
 +
|-
 +
|MHWDLOA
 +
|Numeric
 +
|06
 +
|02
 +
|Dissapproved
 +
|-
 +
|MHWOTHR
 +
|Numeric
 +
|06
 +
|02
 +
|Others
 +
|-
 +
|MHWDAYS
 +
|Numeric
 +
|02
 +
|
 +
|No. of Days
 +
|-
 +
|MHWESCD
 +
|Character
 +
|01
 +
|
 +
|Employment Status
 +
|-
 +
|MHWRRD1
 +
|Numeric
 +
|06
 +
|02
 +
|Regular Hours
 +
|-
 +
|MHWRRO1
 +
|Numeric
 +
|06
 +
|02
 +
|Regular OT
 +
|-
 +
|MHWNRD1
 +
|Numeric
 +
|06
 +
|02
 +
|Night Shift Hours
 +
|-
 +
|MHWNRO1
 +
|Numeric
 +
|06
 +
|02
 +
|Night Shift OT
 +
|-
 +
|MHWRRD2
 +
|Numeric
 +
|06
 +
|02
 +
|Rest Day
 +
|-
 +
|MHWRRO2
 +
|Numeric
 +
|06
 +
|02
 +
|Rest Day OT
 +
|-
 +
|MHWNRO2
 +
|Numeric
 +
|06
 +
|02
 +
|Rest Day Night Shift OT
 +
|-
 +
|MHWRSD1
 +
|Numeric
 +
|06
 +
|02
 +
|Special Holiday Regular Hours
 +
|-
 +
|MHWRSO1
 +
|Numeric
 +
|06
 +
|02
 +
|Special Holiday Regular OT
 +
|-
 +
|MHWNSD1
 +
|Numeric
 +
|06
 +
|02
 +
|Special Holiday Night Shift
 +
|-
 +
|MHWRSD2
 +
|Numeric
 +
|06
 +
|02
 +
|Special Holiday Rest Day
 +
|-
 +
|MHWRSO2
 +
|Numeric
 +
|06
 +
|02
 +
|Special Holiday Rest Day OT
 +
|-
 +
|MHWNSO1
 +
|Numeric
 +
|06
 +
|02
 +
|Special Holiday Night Shift OT
 +
|-
 +
|MHWNSD2
 +
|Numeric
 +
|06
 +
|02
 +
|Special Holiday Night Shift Rest Day
 +
|-
 +
|MHWNSO2
 +
|Numeric
 +
|06
 +
|02
 +
|Special Holiday Night Shift Rest Day OT
 +
|-
 +
|MHWRLD1
 +
|Numeric
 +
|06
 +
|02
 +
|Legal Holiday Regular Hours
 +
|-
 +
|MHWRSO1
 +
|Numeric
 +
|06
 +
|02
 +
|Legal Holiday OT
 +
|-
 +
|MHWNLD1
 +
|Numeric
 +
|06
 +
|02
 +
|Legal Holiday Night Shift Hours
 +
|-
 +
|MHWRLD2
 +
|Numeric
 +
|06
 +
|02
 +
|Legal Holiday Rest Day Hours
 +
|-
 +
|MHWRLO2
 +
|Numeric
 +
|06
 +
|02
 +
|Legal Holiday Rest Day OT
 +
|-
 +
|MHWNRD2
 +
|Numeric
 +
|06
 +
|02
 +
|Night Shift Rest Day1 
 +
|-
 +
|MHWLHOL
 +
|Numeric
 +
|06
 +
|02
 +
|Legal Holiday
 +
|-
 +
|MHWSHOL
 +
|Numeric
 +
|06
 +
|02
 +
|Special Holiday
 +
|-
 +
|MHWTHOL
 +
|Numeric
 +
|06
 +
|02
 +
|
 +
|-
 +
|MHWRLEG
 +
|Numeric
 +
|06
 +
|02
 +
|Rest Day Legal Holiday
 +
|-
 +
|MHWRSPC
 +
|Numeric
 +
|06
 +
|02
 +
|Rest Day Special Holiday
 +
|-
 +
|MHWFPER
 +
|Character
 +
|01
 +
|
 +
|Field Personnel
 +
|-
 +
|MHWADSL
 +
|Numeric
 +
|06
 +
|02
 +
|SL Adjustment
 +
|-
 +
|MHWADVL
 +
|Numeric
 +
|06
 +
|02
 +
|VL Adjustment
 +
|-
 +
|MHWDDSL
 +
|Numeric
 +
|06
 +
|02
 +
|SL Deduction
 +
|-
 +
|MHWDDVL
 +
|Numeric
 +
|06
 +
|02
 +
|VL Deduction
 +
|-
 +
|MHWADFL
 +
|Numeric
 +
|06
 +
|02
 +
|Faternal Leave Adjustment
 +
|}
 +
{| class="wikitable" \
 +
!style="text-align:left;"|Index Name
 +
!Index Key
 +
|-
 +
|MHWyyyy1.NTX
 +
|MHWNUMB+DTOS(MHWCDTE)
 +
|-
 +
|MHWyyyy2.NTX
 +
|DTOS(MHWCDTE)+MHWNUMB
 +
|}
 +
=== INSyyyy.DBF - Insurance Premium Table ===
 +
<p>where yyyy - current year
 +
{| class="wikitable" \
 +
|-
 +
! style="text-align:left;" | Field Name
 +
! Type
 +
! Width
 +
! Dec
 +
! Description
 +
|-
 +
|INSNUMB
 +
|Character
 +
|08
 +
|
 +
|Employee No.
 +
|-
 +
|INSYEAR
 +
|Character
 +
|04
 +
|
 +
|Year
 +
|-
 +
|INSMNTH
 +
|Character
 +
|02
 +
|
 +
|Month
 +
|-
 +
|INSAMNT
 +
|Numeric
 +
|07
 +
|02
 +
|Amount
 +
|}
 +
{| class="wikitable" \
 +
!style="text-align:left;"|Index Name
 +
!Index Key
 +
|-
 +
|INSyyyy1.NTX
 +
|INSNUMB+INSYEAR
 +
|}
 +
=== BONUSyy.DBF - Bonus File===
 +
{| class="wikitable" \
 +
|-
 +
! style="text-align:left;" | Field Name
 +
! Type
 +
! Width
 +
! Dec
 +
! Description
 +
|-
 +
|AHSNUMB
 +
|Character
 +
|08
 +
|
 +
|Employee No.
 +
|-
 +
|AHSGPAY
 +
|Numeric
 +
|12
 +
|02
 +
|Gross Pay
 +
|-
 +
|AHS13MO
 +
|Numeric
 +
|10
 +
|02
 +
|13 Month Pay
 +
|-
 +
|AHSBONS
 +
|Numeric
 +
|10
 +
|02
 +
|Bonus
 +
|-
 +
|AHSSLRE
 +
|Numeric
 +
|06
 +
|02
 +
|SL Remaining
 +
|-
 +
|AHSVLRE
 +
|Numeric
 +
|06
 +
|02
 +
|VL Remaining
 +
|-
 +
|AHSSLPY
 +
|Numeric
 +
|10
 +
|02
 +
|SL Pay
 +
|-
 +
|AHSVLPY
 +
|Numeric
 +
|10
 +
|02
 +
|VL Pay
 +
|-
 +
|AHSLTAG
 +
|Logical
 +
|01
 +
|
 +
|Posting Flag
 +
|-
 +
|AHSLPAY
 +
|Numeric
 +
|10
 +
|02
 +
|Total Leave Pay
 +
|-
 +
|AHSPYNO
 +
|Character
 +
|10
 +
|Payslip No.
 +
|
 +
|-
 +
|AHSSTAT
 +
|Character
 +
|01
 +
|
 +
|Status
 +
|-
 +
|AHSPMCD
 +
|Character
 +
|01
 +
|
 +
|Payment Mode
 +
|-
 +
|AHSESCD
 +
|Character
 +
|01
 +
|
 +
|Employment Status
 +
|-
 +
|AHSPCCD
 +
|Character
 +
|01
 +
|
 +
|Payment Class
 +
|-
 +
|AHSBKCD
 +
|Character
 +
|05
 +
|
 +
|Bank Code
 +
|-
 +
|AHSCOCD
 +
|Character
 +
|01
 +
|
 +
|Comany Code
 +
|-
 +
|AHSLCCD
 +
|Character
 +
|03
 +
|
 +
|Location Code
 +
|-
 +
|AHSFDVL
 +
|Numeric
 +
|06
 +
|02
 +
|Filed VL
 +
|-
 +
|AHSFDSL
 +
|Numeric
 +
|06
 +
|02
 +
|
 +
|-
 +
|AHSBPAY
 +
|Numeric
 +
|12
 +
|02
 +
|Basic Pay
 +
|-
 +
|AHSCDPCD
 +
|Character
 +
|10
 +
|
 +
|Tax WithHeld
 +
|}
 +
{| class="wikitable" \
 +
!style="text-align:left;"|Index Name
 +
!Index Key
 +
|-
 +
|AHSyyyy1.NTX
 +
|AHSNUMB
 
|}
 
|}

Revision as of 10:06, 17 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)

SVLyyyy.DBF - SLVL File (Rank & File)

where yyyy - current year

Field Name Type Width Dec Description
SVLNUMB Character 08 Employee No.
SVLEDTE Date 08 Date
SVLSLEN Numeric 04 SL Entitlement
SVLVLEN Numeric 04 VL Entitlement
SVLFLEN Numeric 04 FL Entitlement
SVLSLRE Numeric 06 02 SL Remaining
SVLVLRE Numeric 06 02 VL Remaining
SVLFLRE Numeric 06 02 FL Remaining
Index Name Index Key
SVLyyyy1.NTX SVLNUMB

COUNTER.DBF - Bartillo Counter File

Field Name Type Width Dec Description
TMPPFNO Numeric 08 Purchase Form No.
TMPPCCD Character 01 Payment Class
TMPCOCD Character 01 Company
Index Name Index Key
COUNTER1.NTX TMPPCCD+TMPCOCD

METROLOG.DBF - Log File for MetroBank Report

Field Name Type Width Dec Description
LOGNUMB Character 08 Log No.
LOGACCT Character 12 Log Account
LOGSLRY Numeric 09 02 Log Salary
LOGDATE Date 08 Log Date
LOGTIME Character 08 Log Time
Index Name Index Key
METROLOG1.NTX LOGNUMB+DTOS(LOGDATE)

PYTCHRO.DBF - Chrono Filed

Field Name Type Width Dec Description
CRONUMB Character 08 Employee No.
CROCRNO Character 12 Chrono No.
Index Name Index Key
PTCHRO1.NTX CROCRNO

MHWyyyy.DBF - Man hour File (Weekly)

where yyyy - current

Field Name Type Width Dec Description
MHWNUMB Character 08 Employee No.
MHWCDTE Date 08 Out Date
MHWTRDY Numeric 07 02 Tardy
MHWUTME Numeric 06 02 Undertime
MHWSLLV Numeric 06 02 Filed SL
MHWVLLV Numeric 06 02 Filed VL
MHWULOA Numeric 06 02 Unpaid LOA
MHWWOLV Numeric 06 02 Without LOA
MHWDLOA Numeric 06 02 Dissapproved
MHWOTHR Numeric 06 02 Others
MHWDAYS Numeric 02 No. of Days
MHWESCD Character 01 Employment Status
MHWRRD1 Numeric 06 02 Regular Hours
MHWRRO1 Numeric 06 02 Regular OT
MHWNRD1 Numeric 06 02 Night Shift Hours
MHWNRO1 Numeric 06 02 Night Shift OT
MHWRRD2 Numeric 06 02 Rest Day
MHWRRO2 Numeric 06 02 Rest Day OT
MHWNRO2 Numeric 06 02 Rest Day Night Shift OT
MHWRSD1 Numeric 06 02 Special Holiday Regular Hours
MHWRSO1 Numeric 06 02 Special Holiday Regular OT
MHWNSD1 Numeric 06 02 Special Holiday Night Shift
MHWRSD2 Numeric 06 02 Special Holiday Rest Day
MHWRSO2 Numeric 06 02 Special Holiday Rest Day OT
MHWNSO1 Numeric 06 02 Special Holiday Night Shift OT
MHWNSD2 Numeric 06 02 Special Holiday Night Shift Rest Day
MHWNSO2 Numeric 06 02 Special Holiday Night Shift Rest Day OT
MHWRLD1 Numeric 06 02 Legal Holiday Regular Hours
MHWRSO1 Numeric 06 02 Legal Holiday OT
MHWNLD1 Numeric 06 02 Legal Holiday Night Shift Hours
MHWRLD2 Numeric 06 02 Legal Holiday Rest Day Hours
MHWRLO2 Numeric 06 02 Legal Holiday Rest Day OT
MHWNRD2 Numeric 06 02 Night Shift Rest Day1
MHWLHOL Numeric 06 02 Legal Holiday
MHWSHOL Numeric 06 02 Special Holiday
MHWTHOL Numeric 06 02
MHWRLEG Numeric 06 02 Rest Day Legal Holiday
MHWRSPC Numeric 06 02 Rest Day Special Holiday
MHWFPER Character 01 Field Personnel
MHWADSL Numeric 06 02 SL Adjustment
MHWADVL Numeric 06 02 VL Adjustment
MHWDDSL Numeric 06 02 SL Deduction
MHWDDVL Numeric 06 02 VL Deduction
MHWADFL Numeric 06 02 Faternal Leave Adjustment
Index Name Index Key
MHWyyyy1.NTX MHWNUMB+DTOS(MHWCDTE)
MHWyyyy2.NTX DTOS(MHWCDTE)+MHWNUMB

INSyyyy.DBF - Insurance Premium Table

where yyyy - current year

Field Name Type Width Dec Description
INSNUMB Character 08 Employee No.
INSYEAR Character 04 Year
INSMNTH Character 02 Month
INSAMNT Numeric 07 02 Amount
Index Name Index Key
INSyyyy1.NTX INSNUMB+INSYEAR

BONUSyy.DBF - Bonus File

Field Name Type Width Dec Description
AHSNUMB Character 08 Employee No.
AHSGPAY Numeric 12 02 Gross Pay
AHS13MO Numeric 10 02 13 Month Pay
AHSBONS Numeric 10 02 Bonus
AHSSLRE Numeric 06 02 SL Remaining
AHSVLRE Numeric 06 02 VL Remaining
AHSSLPY Numeric 10 02 SL Pay
AHSVLPY Numeric 10 02 VL Pay
AHSLTAG Logical 01 Posting Flag
AHSLPAY Numeric 10 02 Total Leave Pay
AHSPYNO Character 10 Payslip No.
AHSSTAT Character 01 Status
AHSPMCD Character 01 Payment Mode
AHSESCD Character 01 Employment Status
AHSPCCD Character 01 Payment Class
AHSBKCD Character 05 Bank Code
AHSCOCD Character 01 Comany Code
AHSLCCD Character 03 Location Code
AHSFDVL Numeric 06 02 Filed VL
AHSFDSL Numeric 06 02
AHSBPAY Numeric 12 02 Basic Pay
AHSCDPCD Character 10 Tax WithHeld
Index Name Index Key
AHSyyyy1.NTX AHSNUMB

Retrieved from "http://115.85.30.86:286/spgcwiki/index.php?title=File(s)_located_at_R:%5CPAY%5CPAY%5CDBF&oldid=4497"