Main Page > Application Development Team > DB Specs > Payroll DB
Database File
PMMCITY.DBF - Master File
| Field Name
|
Type
|
Width
|
Dec
|
Description
|
| CTYCTCD
|
Character
|
03
|
|
City Code
|
| CTYDESC
|
Character
|
20
|
|
Description
|
| CTYPVCD
|
Character
|
03
|
|
Province Code
|
| CTYZPCD
|
Character
|
08
|
|
Zip Code
|
| Index Name
|
Index Key
|
| PMMCITY1.NTX
|
CTYCTCD
|
| PMMCITY2.NTX
|
CTYDESC
|
PMMLNGE.DBF - Language Master File
| Field Name
|
Type
|
Width
|
Dec
|
Description
|
| LNGCODE
|
Character
|
02
|
|
Code
|
| LNGDESC
|
Character
|
01
|
|
Description
|
| Index Name
|
Index Key
|
| PMMLNGE1.NTX
|
LNGCODE
|
| PMMLNGE2.NTX
|
LNGDESC
|
PMMPRVM.DBF - Province File
| Field Name
|
Type
|
Width
|
Dec
|
Description
|
| PRVPVCD
|
Character
|
03
|
|
Province Code
|
| PRVDESC
|
Character
|
30
|
|
Description
|
| Index Name
|
Index Key
|
| PMMLNGE1.NTX
|
PRVPVCD
|
| PMMLNGE2.NTX
|
PRVDESC
|
PMMACIN.DBF - Action Againts Infraction File
| Field Name
|
Type
|
Width
|
Dec
|
Description
|
| ACIACD
|
Character
|
|
03
|
Code
|
| ACIDESC
|
Character
|
20
|
|
Description
|
| Index Name
|
Index Key
|
| PMMACIN1.NTX
|
ACIACCD
|
| PMMACIN2.NTX
|
ACIDESC
|
PMMCSTA.DBF - Civil Status File
| Field Name
|
Type
|
Width
|
Dec
|
Description
|
| CSTCSCD
|
Character
|
01
|
|
Code
|
| CSTDESC
|
Character
|
10
|
|
Description
|
| Index Name
|
Index Key
|
| PMMCSTA1.NTX
|
CSTCSCD
|
| PMMCSTA2.NTX
|
CSTDESC
|
PMMMACH.DBF - Office Machines File
| Field Name
|
Type
|
Width
|
Dec
|
Description
|
| MACMCCD
|
Character
|
02
|
|
Code
|
| MACDESC
|
Character
|
25
|
|
Description
|
| Index Name
|
Index Key
|
| PMMMACH1.NTX
|
MACMCCD
|
| PMMMACH2.NTX
|
MACDESC
|
PMMCTZP.DBF - Citizenship File
| Field Name
|
Type
|
Width
|
Dec
|
Description
|
| CTZCZCD
|
Character
|
02
|
|
Code
|
| CTZDESC
|
Character
|
10
|
|
Description
|
| Index Name
|
Index Key
|
| PMMCTZP1.NTX
|
CTZCZCD
|
| PMMCTZP2.NTX
|
CTZDESC
|
PMMMART.DBF - PAM Rating File
| Field Name
|
Type
|
Width
|
Dec
|
Description
|
| PARPRCD
|
Character
|
02
|
|
Code
|
| PARDESC
|
Character
|
20
|
|
Description
|
| Index Name
|
Index Key
|
| PMMMART1.NTX
|
PARPRCD
|
| PMMMART2.NTX
|
PARDESC
|
PMMACT.DBF - PAM Action File
| Field Name
|
Type
|
Width
|
Dec
|
Description
|
| PACPACD
|
Character
|
02
|
|
Code
|
| PACDESC
|
Character
|
20
|
|
Description
|
| Index Name
|
Index Key
|
| PMMPACT1.NTX
|
PACPACD
|
| PMMPACT2.NTX
|
PACDESC
|
PMMRELG.DBF - Relationship File
| Field Name
|
Type
|
Width
|
Dec
|
Description
|
| RELRGCD
|
Character
|
02
|
|
Code
|
| RELDESC
|
Character
|
20
|
|
Description
|
| Index Name
|
Index Key
|
| PMMRELG1.NTX
|
RELRGCD
|
| PMMRELG2.NTX
|
RELDESC
|
PMMRLTP.DBF - Relationship File
| Field Name
|
Type
|
Width
|
Dec
|
Description
|
| RLTRLCD
|
Character
|
02
|
|
Code
|
| RLTDESC
|
Character
|
15
|
|
Description
|
| RLTSXCD
|
Character
|
01
|
|
Sex Code
|
| Index Name
|
Index Key
|
| PMMRLTP1.NTX
|
RLTRLCD
|
| PMMRLT2.NTX
|
RLTDESC
|
