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

From SPGC Document Wiki
Jump to: navigation, search
(→‎UWmmddyy.DBF - Undertime File (Weekly))
 
(2 intermediate revisions by the same user not shown)
Line 1,235: Line 1,235:
 
|UNTDATE
 
|UNTDATE
 
|Date
 
|Date
−
|Character
 
 
|08
 
|08
 
|
 
|
Line 1,259: Line 1,258:
 
|UNTNUMB+DTOS(UNTDATE)
 
|UNTNUMB+DTOS(UNTDATE)
 
|}
 
|}
 +
 
=== OTmmddyy.DBF - Overtime File (Monthly & VIP) ===
 
=== OTmmddyy.DBF - Overtime File (Monthly & VIP) ===
 
<p>where mmddyy - cut-off date</p>
 
<p>where mmddyy - cut-off date</p>
Line 1,433: Line 1,433:
 
|
 
|
 
|End Time
 
|End Time
 +
|}
 +
 
=== OKmmddyy.DBF - Overtime File (Weekly) ===
 
=== OKmmddyy.DBF - Overtime File (Weekly) ===
 
<p> where mmddyy - cut-off date</p>
 
<p> where mmddyy - cut-off date</p>

Latest revision as of 13:45, 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)

PYSTEPS.DBF - Separated File

Field Name Type Width Dec Description
SPSNUMB Character 08 Employee Name
SPSDTHD Date 08 Dated Hired
Index Name Index Key
PYTSEPS1.NTX SPSNUMB+DTOS(SPSDTHD)

PYTTEMP.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

AHSyyyy.DBF - Annual Salary File

<p>where yyyy - current year

Field Name Type Width Dec Description
AHSNUMB Character 08 Employee No.
AHSGPAY Numeric 12 02 Gross Pay
AHSALLO Numeric 10 02 Allowance
AHS13MO Numeric 10 02 13 Month Pay
AHSSLVL Numeric 10 02 SL/VL Pay
AHSSVLR Numeric 10 02 SL/VL Remaining
AHSBONS Numeric 10 02 Bonus
AHSTAXD Numeric 10 02 Tax Due
AHSTAXW Numeric 10 02 Tax WithHeld
Index Name Index Key
AHSyyyy1.NTX AHSNUMB

DTRyyyy.DBF - Uploaded Swiper Data File

Field Name Type Width Dec Description
DTRCODE Character 03 Code
DTRDATE Character 06 Date
DTRTIME Character 04 Time
DTRTMP1 Character 02 Mode

OBmmddyy.DBF - OBTP File (Monthly & VIP)

Field Name Type Width Dec Description
OBTNUMB Character 08 Employee No.
OBTDATE Date 08 Date
OBTDTME Character 04 Departure Time
OBTATME Character 04 Arrival Time
Index Name Index Key
Ommddyy1.NTX OBTNUMB+DTOS(OBTDATE)

LMmmddyy.DBF - LOA File (Monthly & VIP)

where mmddyy - cut-off date

Field Name Type Width Dec Description
LOANUMB Character 08 Employee No.
LOADATE Date 08 Date
LOAOPTN Character 01 Option
LOACODE Character 01 Code
LOAHOUR Numeric 05 02 Applied Hours
LOAHRPD Numeric 05 02 Hours Paid
LOAASTA Logical 01 Tag Approved LOA
Index Name Index Key
Lmmddyy1.NTX LOANNUMB+DTOS(LOADATE)

UNmmddyy.DBF - Undertime File (Monthly & VIP)

where mmddyy - cut-off date

Field Name Type Width Dec Description
UNTNUMB Character 08 Employee No.
UNTDATE Date 08 Date
UNTSTME Character 04 Start Time
UNTETME Character 04 End Time
Index Name Index Key
Ummddyy1.NTX UNTNUMB+DTOS(UNTDATE)

OTmmddy.DBF - OBTP File (Weekly)

Field Name Type Width Dec Description
OTMNUMB Character 08 Employee NO.
UNTDATE Date 08 Date
UNTESTME Character 04 Departure Time
UNTETME Character 04 END TIME
Index Name Index Key
Ummddyy1.NTX UNTNUMB+DTOS(UNTDATE)

OTmmddyy.DBF - Overtime File (Monthly & VIP)

where mmddyy - cut-off date

Field Name Type Width Dec Description
OTMNUMB Character 08 Employee No.
OTMDATE Date 08 Date
OTMFTME Character 04 From Time
OTMTTME Character 04 End Time
Index Name Index Key
Tmmddyy1.NTX OTMNUMB+DTOS(OTMDATE)

OWmmddyy.DBF - OBTP File(Weekly)

where mmddyy - cut-off date

Field Name Type Width Dec Description
OBWNUMB Character 08 Employee No.
OBWDATE Date 08 Date
OBWDTME Character 04 Departure Time
OBWATME Character 04 Arrival Time
Index Name Index Key
Ommddyy3.NTX OBWNUMB+DTOS(OBWDATE)

LWmmddyy.DBF

where mmddyy - cut-off date

Field Name Type Width Dec Description
LOWNUMB Character 08 Employee No.
LOWDATE Date 08 Date
LOWOPTN Character 01 Option
LOWCODE Character 01 Code
LOWHOUR Numeric 05 02 Applied Hours
LOWHRPD Numeric 05 02 Hours Paid
LOWASTA Logical 01 Flag for Approved
Index Name Index Key
Lmmddyy3.NTX LOWNUMB+DTOS(LOWDATE)

UWmmddyy.DBF - Undertime File (Weekly)

where mmddyy - cut-off date

Field Name Type Width Dec Description
UNWNUMB Character 08 Employee No.
UNWDATE Date 08 Date
UNWSTME Character 04 Start Time
UNWETME Character 04 End Time

OKmmddyy.DBF - Overtime File (Weekly)

<p> where mmddyy - cut-off date

Field Name Type Width Dec Description
OTWNUMB Character 08 Employee No.
OTWDATE Date 08 Date
OTWFTME Character 04 Start Time
UNWETME Character 04 End Time
Index Name Index Key
Tmmddyy3.NTX OTWNUMB+DTOS(OTWDATE)

DWmmddyy.DBF - DTR File (Weekly)

where mmddyy - cut-off date

Field Name Type Width Dec Description
DTWNUMB Character 08 Employee No.
DTWUSER Character 08 Username
DTWDATE Date 08 Date
DTWAMIN Character 04 AM In
DTWAMOT Character 04 AM Out
DTWPMIN Character 04 PM In
DTWPMOT Character 04 PM Out
DTW_AMI Character 04 Swiper AM In
DTW_AMO Character 04 AM Out
DTW_PMI Character 04 Swiper PM In
DTW_PMO Character 04 Swiper PM Out
DTWSFCD Character 02 Shift Code
Index Name Index Key
Wmmddyy1.NTX DTWNUMB+DTOS(DTWDATE)

DTmmddyy.DBF - DTR File (Monthly)

where mmddyy - cut-off date

Field Name Type Width Dec Description
DTRNUMB Character 08 Employee No.
DTRUSER Character 08 Username
DTRDATE Date 08 Date
DTRAMIN Character 04 AM In
DTRAMOT Character 04 AM Out
DTRPMIN Character 04 PM In
DTRPMOT Character 04 PM Out
DTR_AMI Character 04 Swiper AM In
DTR_AMO Character 04 Swiper AM Out
DTR_PMI Character 04 PM In
DTR_PMO Character 04 Swiper PM Out
DTRSFCD Character 02 Shift Code
Index Name Index Key
Dmmddyy1.NTX DTRNUMB+DTOS(DTRDATE)

LVmmddyy.DBF - WA File (VIP)

where mmddyy - cut-off date

Field Name Type Width Dec Description
LOVNUMB Character 08 Employee No.
LOVDATE Date 08 Date
LOVOPTN Character 01 Option
LOVCODE Character 01 Code
LOVHOUR Numeric 05 02 Applied Hours
LOVHRPD Numeric 05 02 Hours Paid
LOVASTA Logical 01 Tag Approved LOA
Index Name Index Key
Lmmddyy5.NTX LOVNUMB+DTOS(LOVDATE)

OVmmddyy.DBF - OBTP File(VIP)

where mmddyy - cut-off date

Field Name Type Width Dec Description
OBVNUMB Character 08 Employee No.
OBVDATE Date 08 Departure Time
OBVDTME Character 04 Departure Time
OBVATME Character 04 Arrival Time
Index Name Index Key
Ommddyy5.NTX OBVNUMB+DTOS(LOVDATE)

DVmmddyy.DBF - DTR File (VIP)

where mmddyy - cut-off date

Field Name Type Width
DTVNUMB Character 08
DTVUSER Character 08
DTVDATE Date 08
DTVAMIN Character 04
DTV-AMOT Character 04
DTV-AMI Character 04
DTV-PMO Character 04
DTVSFCD Character 02
Index Name Index Key
Vmmddyy1.NTX DTVNUMB+DTOS(DTVDATE)
Retrieved from "http://115.85.30.86:286/spgcwiki/index.php?title=File(s)_located_at_R:%5CPAY%5CPAY%5CDBF&oldid=4505"