File(s) located at R:\PAY\COM\DB2

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

PMMSECT.DBF - Section Master File

Field Name	Type	Width	Dec	Description
SECSCCD	Character	02		Section Code
SECNAME	Character	25		Section Name

Index Name	Index Key
PMMSECT1.NTX	SECSCCD
PMMSECT2.NTX	SECNAME

PMMSHF2.DBF - Shift Schedule Master File (Rank and File)

Field Name	Type	Width	Dec	Description
SHFSFCD	Character	02		Shift Code
SHFRDCD	Character	01		Restday Code
SHFAMIN	Character	04		AM In
SHFAMOT	Character	04		AM Out
SHFPMIN	Character	04		PM In
SHFPMOT	Character	04		PM Out
SHFGPRD	Character	02		Grace Period
SHFSTAG	Logical	01		Night Shift Tag

Index Name	Index Key
PMMSHF21.NTX	SHVSFCD+SHFRDCD

PMMSHF.DBF - Shift Schedule Master File (VIP)

Field Name	Type	Width	Dec	Description
SHVSFCD	Character	02		Shift Code
SHVRDCD	Character	01		Restday Code
SHVAMIN	Character	04		AM In
SHVPMOT	Character	04		PM Out

Index Name	Index Key
PMMSHFV1.NTX	SHVSFCD+SHVRDCD

PMMLOG.DBF - Log File

Field Name	Type	Width	Dec	Description
LOGUSER	Character	08		User Code
LOGDATE	Character	08		Log Date
LOGTIMI	Character	08		Time In
LOGTIMO	Character	08		Time Out

Index Name	Index Key
PMMLOGF1.NTX	LOGUSER+DTOS(LOGDATE)+LOGTIMI

PYMBANK.DBF - Bank Master File

Field Name	Type	Width	Dec	Description
BNKBKCD	Character	05		Bank Code
BNKDESC	Character	30		Description
BNKTCSH	Character	30		Address
BNKACDE	Numberic	13	02
BNKACDE	Character	03		Account Code

Index Name	Index Key
PYMBANK1.NTX	BNKBKCD
PYMBANK2.NTX	BNKDESC

PMMTAXT.DBF - Tax Status File

Field Name	Type	Width	Dec	Description
TAXTXCD	Character	04		Tax Code
TAXDESC	Character	30		Description
TAXEXEM	Numeric	09	02	Exemption

Index Name	Index Key
PMMTAXT1.NTX	TAXTXCD
PMMTAXT2.NTX	TAXDESC

PMTNUMB.DBF - Employee Number Sequence File

Field Name	Type	Width	Dec	Description
EMPNO	Character	08		Old Emp. No
NMBNUMB	Character	08		Employee Number
NMBLNAM	Character	15		Last Name
NMBFNAM	Character	20		First Name
NMBMNAM	Character	15		Middle Name
NMBPCCD	Character	01		Pay Class
NMBCOCD	Character	01		Company Code
NMBLCCD	Character	03		Location Code
NMBDPCD	Character	03		Department Code
NMBHDTE	Date	08		Date Hired
NMBENDT	Date	08		-	NMBPRNT	Character	01		Printing Status
NMBCNTR	Numeric	03		Counter

Index Name	Index Key
PMTNUMB1.NTX	NMBNUMB
PMTNUM2.NTX	NMBPRNT+DTOS(NMBENDT)+NMBNUMB Main Page > Application Development Team > DB Specs > Payroll DB