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

From SPGC Document Wiki
Jump to: navigation, search
 
(6 intermediate revisions by the same user not shown)
Line 1: Line 1:
−
==File(s) located at R:\PAY\COM\DBF==
+
[[Main_Page | Main Page]] > [[Application_Development_Team | Application Development Team]] > [[DB_Specs | DB Specs]] > [[PAYROLL_DB | Payroll DB]]
 +
 
 +
==Database File==
 
===PMHATMP.DBF - ATM File (Separted)===
 
===PMHATMP.DBF - ATM File (Separted)===
 
{| class="wikitable" \
 
{| class="wikitable" \
Line 908: Line 910:
 
|EMPPCCD+EMPINCO+EMPPMCD+EMPLCCD+EMPESCD+EMPLNAM+EMPFNAM
 
|EMPPCCD+EMPINCO+EMPPMCD+EMPLCCD+EMPESCD+EMPLNAM+EMPFNAM
 
|}
 
|}
 +
=== PMHEMPL.DBF - Employee Hold File===
 +
{| class="wikitable" \
 +
|-
 +
! style="text-align:left;" | Field Name
 +
! Type
 +
! Width
 +
! Dec
 +
! Description
 +
|-
 +
|EMPNUMB
 +
|Character
 +
|08
 +
|
 +
|Employee No.
 +
|-
 +
|EMPLNAM
 +
|Character
 +
|15
 +
|
 +
|Last Name
 +
|-
 +
|EMPFNAM
 +
|Character
 +
|20
 +
|
 +
|First Name
 +
|-
 +
|EMPMNAM
 +
|Character
 +
|15
 +
|
 +
|Middle Name
 +
|-
 +
|EMPSXCD
 +
|Character
 +
|01
 +
|
 +
|Sex Code
 +
|-
 +
|EMPBDTE
 +
|Date
 +
|08
 +
|
 +
|Birth Date
 +
|-
 +
|EMPPOBT
 +
|Character
 +
|15
 +
|
 +
|Place of Birth
 +
|-
 +
|EMPRGCD
 +
|Character
 +
|02
 +
|
 +
|Religion Code
 +
|-
 +
|EMPCSCD
 +
|Character
 +
|01
 +
|
 +
|Civil Status
 +
|-
 +
|EMPCADD
 +
|Character
 +
|40
 +
|
 +
|Address
 +
|-
 +
|EMPTOWN
 +
|Character
 +
|20
 +
|
 +
|Town
 +
|-
 +
|EMPCITY
 +
|Character
 +
|20
 +
|
 +
|City
 +
|-
 +
|EMPCZCD
 +
|Character
 +
|02
 +
|
 +
|Citizenship Code
 +
|-
 +
|EMPTXCD
 +
|Character
 +
|04
 +
|
 +
|Tax Code
 +
|-
 +
|EMPLDTE
 +
|Date
 +
|08
 +
|
 +
|Tax Status Effectivity Date
 +
|-
 +
|EMPSSNO
 +
|Character
 +
|12
 +
|
 +
|SSS No.
 +
|-
 +
|EMPTINO
 +
|Character
 +
|12
 +
|
 +
|TIN No.
 +
|-
 +
|EMPHDTE
 +
|Date
 +
|08
 +
|
 +
|Date Hired
 +
|-
 +
|EMPODTE
 +
|Character
 +
|08
 +
|
 +
|Orentation Date
 +
|-
 +
|EMPPMCD
 +
|Character
 +
|01
 +
|
 +
|Payment Code
 +
|-
 +
|EMPPCCD
 +
|Character
 +
|01
 +
|
 +
|Payment Class
 +
|-
 +
|EMPCOCD
 +
|Character
 +
|01
 +
|
 +
|Company Code
 +
|-
 +
|EMPLCCD
 +
|Character
 +
|03
 +
|
 +
|Location Code
 +
|-
 +
|EMPSTAT
 +
|Character
 +
|01
 +
|
 +
|Tag for Active
 +
|-
 +
|EMPSTDT
 +
|Date
 +
|08
 +
|
 +
|Date Hold
 +
|-
 +
|EMPPINO
 +
|Character
 +
|12
 +
|
 +
|Pag-ibig No.
 +
|-
 +
|EMPAVOL
 +
|Logical
 +
|01
 +
|
 +
|Tag Below 4,000
 +
|-
 +
|EMPPVOL
 +
|Logical
 +
|01
 +
|
 +
|Tag Above 4,000
 +
|-
 +
|EMPTDPD
 +
|Character
 +
|01
 +
|
 +
|Tag for Daily Paid
 +
|-
 +
|EMPCBAT
 +
|Character
 +
|01
 +
|
 +
|Tag for CBA
 +
|-
 +
|EMPDPCD
 +
|Character
 +
|10
 +
|
 +
|Department Code
 +
|-
 +
|EMPESCD
 +
|Character
 +
|01
 +
|
 +
|Employment Status
 +
|-
 +
|EMPDPCC
 +
|Character
 +
|10
 +
|
 +
|Department Charging
 +
|-
 +
|EMPINCO
 +
|Character
 +
|01
 +
|
 +
|Internal Company
 +
|}
 +
{| class="wikitable" \
 +
!style="text-align:left;"|Index Name
 +
!Index Key
 +
|-
 +
|PMHEMPL1.NTX
 +
|EMPNUMB
 +
|-
 +
|PMHEMPL2.NTX
 +
|EMPLNAM+EMPFNAM
 +
|-
 +
|PMHEMPL3.NTX
 +
|EMPCOCD+EMPPCCD+EMPLCCD+EMPLNAM+EMPFNAM
 +
|-
 +
|PMHEMPL4.NTX
 +
|EMPCOCD+EMPPCCD+EMPLCCD+EMPNUMB
 +
|}
 +
 +
[[Main_Page | Main Page]] > [[Application_Development_Team | Application Development Team]] > [[DB_Specs | DB Specs]] > [[PAYROLL_DB | Payroll DB]]

Latest revision as of 14:34, 12 January 2017

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

Database File

PMHATMP.DBF - ATM File (Separted)

Field Name Type Width Dec Description
ATMNUMB Character 08 Employee No.
ATMBKCD Character 05 Bank Code
ATMACCT Character 12 Account No.
Index Name Index Key
PMHATMP1.NTX ATMNUMB+ATMBKCD

PMTVIP2.DBF - VIP Second Salary File

Field Name Type Width Dec Description
VIPNUMB Character 08 Employee No.
VIPEDTE Date 08 Effectively date
VIPBPAY Numeric 10 02 Basic Pay
VIPALLO Numeric 08 02 Allowance
Index Name Index Key
PMTVIP21.NTX VIPNUMB+DTOS(VIPEDTE)

PMTTELE.DBF - Tellphone File

Field Name Type Width Dec Description
TELNUMB Character 08 Employee No.
TELTELN Character 12 Telephone No.
Index Name Index Key
PMTTELE.NTX TELNUMB

PMDyyyy.DBF = Periodic File (Monthly)

where : yyyy - current year

Field Name Type Width Dec Description
PDMCOFF Character 03 Cut-off Month
PDMFDTE Date 08 From Date
PDMTDTE Date 08 To Date
PDMPOST Character 07 Mark for position
PDMAFDT Date 08 Assume from Date
PDMATDT Date 08 Assume to Date
PDMDAYS Numeric 02 No. of Days
PDMADFD Date 08 Assume From Date Daily
PDMADTD Date 08 Assume to Date Daily
Index Name Index Key
PDMyyyy1.NTX DTOS(PDMCOFF+DTOS(PDMFDTE)

PMTTHST.DBF - Tax Status History File

Field Name Type Width Dec Description
THSNUMB Character 08 Employee No.
THSTXCD Character 04 Tax Status Code
THSLDTE Date 08 Effectively Date
Index Name Index Key
PMTTHST1.NTX THSNUMB+THSTXCD

PMWyyyy.DBF = Periodic File (Weekly)

where : yyyy - current year

Field Name Type Width Dec Description
PDWWEEK Character 03 Cut-off Month
PDWFDTE Date 08 From Date
PDWTDTE Date 08 To Date
PDWPOST Character 07 Mark for Posting
PDWAFDT Date 08 Assume from Date
PDWATDT Date 08 Assume from Date
PDWDAYS Numeric 02 No. of Days
PDWADFD Date 08 Assume from Date Daily
PDWADTD Date 08 Assume to Date Daily
Index Name Index Key
PDWyyyy1.NTX DTOS(PDWFDTE)
PDWyyyy2.NTX PDWWEEK+DTOS(PDWFDTE)

PYMTTBL.DBF - Table for Allowable Late and Overtime

Field Name Type Width Dec Description
TBLLATE Numeric 03 Late
TBLMNOT Numeric 03 Minimum OT
TBLTRDY Character 03 Tardy
TBLWOLV Character 03 Without LOA
TBLDLOA Character 03 Disapproved LOA
TBLMNHF Numeric 02

PYMCOAC.DBF - Company Account File

Field Name Type Width Dec Description
CACCOCD Character 01 Company Code
CACBKCD Character 05 Bank Code
CACACCT Character 12 Account No.
Index Name Index Key
PYMCOAC1.NTX CACCOCD+CACBKCD

PMTATMP.DBF - ATM Master File

Field Name Type Width Dec Description
ATMNUMB Character 08 Employee No.
ATMBKCD Character 05 Bank Code
ATMACCT Character 12 Account No.
Index Name Index Key
PMTATMP1.NTX ATMNUMB+ATMBKCD

PMTSEPA.DBF - Separated Employee File

Field Name Type Width Dec Description
SEPNUMB Character 08 Employee No.
SEPPSNO Character 01 Payslip Code
SEPDATE Date 08 Separation Date
SEPRSON Character 20 Reason
SEPNPAY Numeric 10 02 Net Pay
SEPSPAY Numeric 10 02
SEP13PY Numeric 10 02 13th Month Pay
SEPSPLY Numeric 10 02 SL Pay
SEPVLPY Numeric 10 02 VL Pay
SEPADDS Numeric 10 02
SEPNNUM Character 06
SEPRELE Logical 01 Tag for Release
SEPTAXD Numeric 08 02 Tax Due
SEPTAXW Numeric 08 02 Tax WithHeld
SEPALLO Numeric 08 02 Allowance
SEPGPAY Numeric 08 02 Gross Pay
SEPRDTE Date 08 Released Date
SEPRTAG Character 01 Released Tag
SEPRLBY Character 08 Released By
SEPPRNT Character 01 Tag if Printed
Index Name Index Key
PMTSEPA1.NTX SEPNUMB+SEPPSNO
PMTSEPA2.NTX SEPRELE

PMTEMVE.DBF - Employee Movement File

Field Name Type Width Dec Description
EMVNUMB Character 08 Employee No
EMVEDTE Date 08 Effectivity Date
EMVSCCD Character 02 Section Code
EMVSFCD Character 02 Shift Code
EMVLCCD Character 03 Location
EMVDPCD Character 10 Department Code
EMVPSCD Character 03 Position Code
EMVBPAY Numeric 10 02 Basic Pay
EMVALLO Numeric 08 02 Allowance
EMVRDCD Character 02 Rest Day Code
EMVESCD Character 01 Employment Status
EMVPCCD Character 01 Payment Class
EMVCOCD Character 01 Company Code
EMVFPER Character 01 Flag for Field Personnel
EMVPACD Character 02 PAM Code
EMVDPCC Character 10 Department Charging
EMVPADT Date 08 PAM Effectively Date
EMVTDPD Character 01 Pay for Daily Paid
OCODE Character 03 Old Department Code
Index Name Index Key
PMTEMVE1.NTX EMVNUMB+DTOS(EMVEDTE)

PMTEMPL.DBF - Employee Master File

Field Name Type Width Dec Description
EMPNUMB Character 08 Employee No.
EMPLNAM Character 15 Last Name
EMPFNAM Character 20 First Name
EMPMNAM Character 15 Middle Name
EMPSXCD Character 01 Sex Code
EMPBDTE Date 08 Birth Date
EMPPOBT Character 15 Place of Birth
EMPRGCD Character 02 Religion Code
EMPCSCD Character 01 Civil Status
EMPCADD Character 40 Address
EMPTOWN Character 20 Town
EMPCITY Character 20 City
EMPCZCD Character 02 Citezenship Code
EMPTXCD Character 04 Tax Code
EMPLDTE Date 08 Tax Status Effectivity Date
EMPSSNO Character 12 SSS No.
EMPTINO Character 12 Tin No.
EMPHDTE Date 08 Date Hired
EMPODTE Date 08 Orientation Date
EMPPMCD Character 01 Payment Code
EMPPCCD Character 01 Payment Class
EMPCOCD Character 01 Company Code
EMPLCCD Character 03 Location Code
EMPSTAT Character 01 Tag for Active
EMSTDT Date 08 Date Hold
EMPPINO Character 12 Pag-ibig No.
EMPAVOL Logical 01 Tag Below 4,000
EMPPVOL Logical 01 Tag Above 4,000
EMPTDPD Character 01 Tag for Daily Paid
EMPCBAT Character 01 Tag for CBA
EMPDPCD Character 10 Department Code
EMPESCD Character 01 Employment Status
EMPDPCC Character 10 Department Charging
EMPINCO Character 01 Internal Company
EMPALLO Numeric 12 02 Allowance
EMPFEPF Character 01 Tag for Downloaded EPF
Index Name Index Key
PMTEMPL1.NTX EMPNUMB
PMTEMPL2.NTX EMPLNAM+EMPFNAM
PMTEMPL3.NTX EMPINCO+EMPPCD+EMPLCCD+EMPLNAM+EMPFNAM
PMTEMPL4.NTX EMPINCO+EMPPCCD+EMPLCCD+EMPNUMB
PMTEMPL5.NTX EMPPCCD+EMPINCO+EMPPMCD+EMPLCCD+EMPESCD+EMPLNAM+EMPFNAM

PMHEMPL.DBF - Employee Hold File

Field Name Type Width Dec Description
EMPNUMB Character 08 Employee No.
EMPLNAM Character 15 Last Name
EMPFNAM Character 20 First Name
EMPMNAM Character 15 Middle Name
EMPSXCD Character 01 Sex Code
EMPBDTE Date 08 Birth Date
EMPPOBT Character 15 Place of Birth
EMPRGCD Character 02 Religion Code
EMPCSCD Character 01 Civil Status
EMPCADD Character 40 Address
EMPTOWN Character 20 Town
EMPCITY Character 20 City
EMPCZCD Character 02 Citizenship Code
EMPTXCD Character 04 Tax Code
EMPLDTE Date 08 Tax Status Effectivity Date
EMPSSNO Character 12 SSS No.
EMPTINO Character 12 TIN No.
EMPHDTE Date 08 Date Hired
EMPODTE Character 08 Orentation Date
EMPPMCD Character 01 Payment Code
EMPPCCD Character 01 Payment Class
EMPCOCD Character 01 Company Code
EMPLCCD Character 03 Location Code
EMPSTAT Character 01 Tag for Active
EMPSTDT Date 08 Date Hold
EMPPINO Character 12 Pag-ibig No.
EMPAVOL Logical 01 Tag Below 4,000
EMPPVOL Logical 01 Tag Above 4,000
EMPTDPD Character 01 Tag for Daily Paid
EMPCBAT Character 01 Tag for CBA
EMPDPCD Character 10 Department Code
EMPESCD Character 01 Employment Status
EMPDPCC Character 10 Department Charging
EMPINCO Character 01 Internal Company
Index Name Index Key
PMHEMPL1.NTX EMPNUMB
PMHEMPL2.NTX EMPLNAM+EMPFNAM
PMHEMPL3.NTX EMPCOCD+EMPPCCD+EMPLCCD+EMPLNAM+EMPFNAM
PMHEMPL4.NTX EMPCOCD+EMPPCCD+EMPLCCD+EMPNUMB

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

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