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

From SPGC Document Wiki
Jump to: navigation, search
(Created page with " Main Page > Application Development Team > DB Specs > Payroll DB == Database File == === P...")
 
Line 4: Line 4:
  
 
=== PYMTADW.DBF - Tax Additional Deduction (Weekly) ===
 
=== PYMTADW.DBF - Tax Additional Deduction (Weekly) ===
 +
{| class="wikitable" \
 +
|-
 +
! style="text-align:left;" | Field Name
 +
! Type
 +
! Width
 +
! Dec
 +
! Description
 +
|-
 +
|TAWSQNO
 +
|Character
 +
|02
 +
|
 +
|Sequence No.
 +
|-
 +
|TAWRATE
 +
|Numeric
 +
|05
 +
|02
 +
|Rate
 +
|-
 +
|TAWADED
 +
|Numeric
 +
|08
 +
|02
 +
|Additional Deduction
 +
|}
 +
{| class="wikitable" \
 +
!style="text-align:left;"|Index Name
 +
!Index Key
 +
|-
 +
|PYMTADW1.NTX
 +
|TAWSQNO
 +
|}
 +
=== PYMPUTB.DBF - Pag-ibig Table ===
 +
{| class="wikitable" \
 +
|-
 +
! style="text-align:left;" | Field Name
 +
! Type
 +
! Width
 +
! Dec
 +
! Description
 +
|-
 +
|PITLGP
 +
|Numeric
 +
|09
 +
|02
 +
|Lower Range
 +
|-
 +
|PITUPGP
 +
|Numeric
 +
|09
 +
|02
 +
|Upper Range
 +
|-
 +
|PITERCN
 +
|Numeric
 +
|05
 +
|02
 +
|ER Contribution
 +
|-
 +
|PITERFC
 +
|Numeric
 +
|07
 +
|02
 +
|Employee Fixed Contribution
 +
|-
 +
|PITEECN
 +
|Numeric
 +
|05
 +
|02
 +
|Employee Contibution
 +
|-
 +
|PITEEFC
 +
|Numeric
 +
|07
 +
|02
 +
|Employee Fixed Contribution
 +
|}
 +
{| class="wikitable" \
 +
!style="text-align:left;"|Index Name
 +
!Index Key
 +
|-
 +
|PYMPITB1.NTX
 +
|PITLWGP
 +
|}
 +
=== PYMPREM.DBF - Premium Table ===
 +
{| class="wikitable" \
 +
|-
 +
! style="text-align:left;" | Field Name
 +
! Type
 +
! Width
 +
! Dec
 +
! Description
 +
|-
 +
|PRMRRD1
 +
|Numeric
 +
|05
 +
|02
 +
|Regular Hours
 +
|-
 +
|PRMRRO1
 +
|Numeric
 +
|05
 +
|02
 +
|Regular OT
 +
|-
 +
|PRMRRD2
 +
|Numeric
 +
|05
 +
|02
 +
|Rest Day
 +
|-
 +
|PRMRRO2
 +
|Numeric
 +
|05
 +
|02
 +
|Rest Day OT
 +
|-
 +
|PRMRSD1
 +
|Numeric
 +
|05
 +
|02
 +
|Special Holiday Regular Hrs.
 +
|-
 +
|PRMRSO1
 +
|Numeric
 +
|05
 +
|02
 +
|Special Holiday Regular OT
 +
|-
 +
|PRMRSD2
 +
|Numeric
 +
|05
 +
|02
 +
|Special Holiday Rest Day
 +
|-
 +
|RMRSO2
 +
|Numeric
 +
|05
 +
|02
 +
|Special Holiday Rest Day OT
 +
|-
 +
|PRMRLD1
 +
|Numeric
 +
|05
 +
|02
 +
|Legal Holiday Regular Hrs.
 +
|-
 +
|PRMRLO1
 +
|Numeric
 +
|05
 +
|02
 +
|Legal Holiday OT
 +
|-
 +
|PRMRLD2
 +
|Numeric
 +
|05
 +
|02
 +
|Legal Holiday Rest Day Hours
 +
|-
 +
|PRMRLO2
 +
|Numeric
 +
|05
 +
|02
 +
|Legal Holiday Rest Day OT
 +
|-
 +
|PRMNRD1
 +
|Numeric
 +
|05
 +
|02
 +
|Night Shift Hours
 +
|-
 +
|PRMNRO1
 +
|Numeric
 +
|05
 +
|02
 +
|Night Shift OT
 +
|-
 +
|PRMNRD2
 +
|Numeric
 +
|05
 +
|02
 +
|Night Shift Rest Day
 +
|-
 +
|PRMNRO2
 +
|Numeric
 +
|05
 +
|02
 +
|Rest Day Night Shift OT
 +
|-
 +
|PRMNSD1
 +
|Numeric
 +
|05
 +
|02
 +
|Special Holiday Night Shift
 +
|-
 +
|PRMSO1
 +
|Numeric
 +
|05
 +
|02
 +
|Special Holiday Night Shift OT
 +
|-
 +
|RMNSD2
 +
|Numeric
 +
|05
 +
|02
 +
|Special Holiday Night Shift Rest Day
 +
|-
 +
|PRMNSO2
 +
|Numeric
 +
|05
 +
|02
 +
|Special Holiday Night Shift Rest Day OT
 +
|-
 +
|PRMNLD1
 +
|Numeric
 +
|05
 +
|02
 +
|Legal Holiday Night Shift Hours
 +
|-
 +
|PRMNLO1
 +
|Numeric
 +
|05
 +
|02
 +
|Legal Holiday Night Shift Hours OT
 +
|-
 +
|PRMNLD2
 +
|Numeric
 +
|05
 +
|02
 +
|Legal Holiday Night Shift Rest Day Hours
 +
|-
 +
|PRMNLO2
 +
|Numeric
 +
|05
 +
|02
 +
|Legal Holiday Night Shift Rest Day OT
 +
|}

Revision as of 13:03, 13 January 2017

Main Page > Application Development Team > DB Specs > Payroll DB

Database File

PYMTADW.DBF - Tax Additional Deduction (Weekly)

Field Name Type Width Dec Description
TAWSQNO Character 02 Sequence No.
TAWRATE Numeric 05 02 Rate
TAWADED Numeric 08 02 Additional Deduction
Index Name Index Key
PYMTADW1.NTX TAWSQNO

PYMPUTB.DBF - Pag-ibig Table

Field Name Type Width Dec Description
PITLGP Numeric 09 02 Lower Range
PITUPGP Numeric 09 02 Upper Range
PITERCN Numeric 05 02 ER Contribution
PITERFC Numeric 07 02 Employee Fixed Contribution
PITEECN Numeric 05 02 Employee Contibution
PITEEFC Numeric 07 02 Employee Fixed Contribution
Index Name Index Key
PYMPITB1.NTX PITLWGP

PYMPREM.DBF - Premium Table

Field Name Type Width Dec Description
PRMRRD1 Numeric 05 02 Regular Hours
PRMRRO1 Numeric 05 02 Regular OT
PRMRRD2 Numeric 05 02 Rest Day
PRMRRO2 Numeric 05 02 Rest Day OT
PRMRSD1 Numeric 05 02 Special Holiday Regular Hrs.
PRMRSO1 Numeric 05 02 Special Holiday Regular OT
PRMRSD2 Numeric 05 02 Special Holiday Rest Day
RMRSO2 Numeric 05 02 Special Holiday Rest Day OT
PRMRLD1 Numeric 05 02 Legal Holiday Regular Hrs.
PRMRLO1 Numeric 05 02 Legal Holiday OT
PRMRLD2 Numeric 05 02 Legal Holiday Rest Day Hours
PRMRLO2 Numeric 05 02 Legal Holiday Rest Day OT
PRMNRD1 Numeric 05 02 Night Shift Hours
PRMNRO1 Numeric 05 02 Night Shift OT
PRMNRD2 Numeric 05 02 Night Shift Rest Day
PRMNRO2 Numeric 05 02 Rest Day Night Shift OT
PRMNSD1 Numeric 05 02 Special Holiday Night Shift
PRMSO1 Numeric 05 02 Special Holiday Night Shift OT
RMNSD2 Numeric 05 02 Special Holiday Night Shift Rest Day
PRMNSO2 Numeric 05 02 Special Holiday Night Shift Rest Day OT
PRMNLD1 Numeric 05 02 Legal Holiday Night Shift Hours
PRMNLO1 Numeric 05 02 Legal Holiday Night Shift Hours OT
PRMNLD2 Numeric 05 02 Legal Holiday Night Shift Rest Day Hours
PRMNLO2 Numeric 05 02 Legal Holiday Night Shift Rest Day OT
Retrieved from "http://115.85.30.86:286/spgcwiki/index.php?title=File(s)_located_at_R:%5CPAY%5CPAY%5CDB2&oldid=4488"