Main Page > Application Development Team > DB Specs > Payroll DB
Database File
PMMCMPY.DBF - Company Master File
| Field Name
|
Type
|
Width
|
Dec
|
Description
|
| CMPCOCD
|
Character
|
01
|
|
Company Code
|
| CMPNAME
|
Character
|
35
|
|
Company Name
|
| CMPSSSN
|
Character
|
12
|
|
SSS Number
|
| CMPTINO
|
Character
|
12
|
|
TIN Number
|
| CMPCADD
|
Character
|
10
|
|
Address
|
| CMPSLAC
|
Character
|
10
|
|
Salaries, Wages
|
| CMPSMEC
|
Character
|
10
|
|
SSS/MED/EC
|
| CMPBKAL
|
Character
|
10
|
|
Kalookan Bank
|
| CMPOTHR
|
Character
|
10
|
|
Other Income
|
| CMPHOLD
|
Character
|
10
|
|
Hold Amount
|
| CMPPIBE
|
Character
|
10
|
|
Pag-ibig Acct
|
| CMPTELE
|
Character
|
10
|
|
Telegraphic
|
| CMPBMAK
|
Character
|
10
|
|
Makati Bank
|
| CMPCASH
|
Character
|
10
|
|
Cash Account
|
| CMPTAXC
|
Character
|
10
|
|
Tax Acct Code
|
| CMPSMEP
|
Character
|
10
|
|
SSS/MED/EC/PIB
|
| CMPABBR
|
Character
|
05
|
|
Company Abbr.
|
| CMPMEDP
|
Character
|
10
|
|
MED/EC Payable
|
| CMPHACC
|
Character
|
03
|
|
|
| CMPWACC
|
Character
|
03
|
|
|
| CMPTACC
|
Character
|
03
|
|
|
| CMPHLAC
|
Character
|
03
|
|
|
| CMPSACC
|
Character
|
03
|
|
|
| CMPBACC
|
Character
|
03
|
|
|
| CMPOIAC
|
Character
|
03
|
|
|
| CMPSMAC
|
Character
|
03
|
|
|
| CMPSPAC
|
Character
|
03
|
|
|
| CMPOSLA
|
Character
|
03
|
|
|
| Index Name
|
Index Key
|
| PMMCMPY1.NTX
|
CMPCOCD
|
| PMMCMPY2.NTX
|
CMPNAME
|
PMMDEPT.DBF - Department Master File
| Field Name
|
Type
|
Width
|
Dec
|
Description
|
| DEPPDPC
|
Character
|
10
|
|
Department Code
|
| DEPCPCD
|
Character
|
01
|
|
Company Code
|
| DEPNAME
|
Character
|
35
|
|
Department Name
|
| DEPINCO
|
Character
|
02
|
|
Internal Comp.
|
| DEPSLWG
|
Character
|
08
|
|
Salaries, Wages
|
| DEPSSSM
|
Character
|
08
|
|
SSS/MED/EC
|
| DEPABBR
|
Character
|
05
|
|
Abbreviation
|
| DEPCOCD
|
Character
|
01
|
|
Company Code
|
| DEPFLAG
|
Character
|
01
|
|
Flag for Remit
|
| DEPBONS
|
Character
|
08
|
|
Bonus Account
|
| DEPBENE
|
Character
|
08
|
|
Benefits Acct.
|
| DEPOCDE
|
Character
|
03
|
|
Old Department
|
| Index Name
|
Index Key
|
| PMMDEPT1.NTX1
|
DEPDPCD+DEPCPCD
|
| PMMDEPT2.NTX
|
DEPNAME
|
| PMMDEPT3.NTX
|
DEPOCDE
|
PMMPOSN.DBF - Position Master File
| Field Name
|
Type
|
Width
|
Dec
|
Description
|
| POSPSCD
|
Character
|
03
|
|
Position Code
|
| POSDESC
|
Character
|
20
|
|
Drescription
|
| POSJLCD
|
Character
|
03
|
|
Job Level Code
|
| POSJOSC
|
Memo
|
10
|
|
Job Section
|
| OCODE
|
Character
|
03
|
|
Old Posn. Code
|
| Index Name
|
Index Key
|
| PMMPOSN1.NTX
|
POSPSCD
|
| PMMPOSN2.NTX
|
POSDESC
|
PYMPCLS.DBF - Length of Service Table
| Field Name
|
Type
|
Width
|
Dec
|
Description
|
| PCLPRBY
|
Numeric
|
02
|
|
Probationary
|
| PCLCON1
|
Numeric
|
02
|
|
Cont. 1 months
|
| PCLCON2
|
Numeric
|
02
|
|
Cont. 2 months
|
| PCLCON3
|
Numeric
|
02
|
|
Cont. 3 months
|
PYMACCT.DBF - Account Master File
| Field Name
|
Type
|
Width
|
Dec
|
Description\
|
| ACCOACD
|
Character
|
10
|
|
Account Code
|
| ACCDESC
|
Character
|
35
|
|
Description
|
| ACCNAME
|
Character
|
35
|
|
Account Name
|
| ACCACDE
|
Character
|
03
|
|
Old Acct. Code
|
| Index Name
|
Index Key
|
| PYMACCT1.NTX
|
ACCOACD
|
| PYMACCT2.NTX
|
ICLDESC
|
PYMCOAC.DBF - Company Account Allocation File
| Field Name
|
Type
|
Width
|
Dec
|
Description
|
| CACCOCD
|
Character
|
01
|
|
Company Code
|
| CACBKCD
|
Character
|
05
|
|
Bank Code
|
| CACACCT
|
Character
|
12
|
|
Account Code
|
| Index Name
|
Index Key
|
| PYMCOAC1.NTX
|
PYMCOAC+CACBKCD
|
PMMICLS.DBF - Infraction Classification File
| Field Name
|
Type
|
Width
|
Dec
|
Description
|
| ICLICCD
|
Character
|
02
|
|
Infraction Code
|
| ICLDESC
|
Character
|
158
|
|
Description
|
| Index Name
|
Index Key
|
| PMMICLS1.NTX
|
ICLICCD
|
| PMMICLS2.NTX
|
ICLDESC
|
PMMJBLV.DBF - Job Level File
| Field Name
|
Type
|
Width
|
Dec
|
Description
|
| JBLJLCD
|
Character
|
02
|
|
Job Level Code
|
| JBLDESC
|
Character
|
20
|
|
Description
|
| Index Name
|
Index Key
|
| PMMJBLV1.NTX
|
JBLJLCD
|
| PMMJBLV2.NTX
|
JBLDESC
|
PMMLOCA.DBF - Location Master File
| Field Name
|
Type
|
Width
|
Dec
|
Description
|
| LOCCODE
|
Character
|
03
|
|
Location Code
|
| LOCDESC
|
Character
|
20
|
|
Description
|
| Index Name
|
Index Key
|
| PMMLOCA1.NTX
|
LOCCODE
|
| PMMLOCA2.NTX
|
LOCDESC
|
