|
|
| Line 450: |
Line 450: |
| | | | | | |
| | |Desciption | | |Desciption |
| | + | |} |
| | + | {| class="wikitable" \ |
| | + | !style="text-align:left;"|Index Name |
| | + | !Index Key |
| | + | |- |
| | + | |PMMBENE1.NTX |
| | + | |BENBNCD |
| | + | |- |
| | + | |PMMBENE2.NTX |
| | + | |BENDESC |
| | + | |} |
Latest revision as of 12:27, 13 January 2017
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
|
PMMTOWN.DBF - Town Master File
| Field Name
|
Type
|
Width
|
Dec
|
Description
|
| TWNTNCD
|
Character
|
03
|
|
Code
|
| TWNDESC
|
Character
|
20
|
|
Descriptiom
|
| TWNCTCD
|
Character
|
03
|
|
City Code
|
| Index Name
|
Index Key
|
| PMMTOWN1.NTX
|
TWNTNCD
|
| PMMTOWN2.NTX
|
TWNDESC
|
PMMSKLL.DBF - Skill File
| Field Name
|
Type
|
Width
|
Dec
|
Description
|
| SKLSKCD
|
Character
|
02
|
|
Code
|
| SKLDESC Character
|
Character
|
20
|
|
Description
|
| Index Name
|
Index Key
|
| PMMSKLL1.NTX
|
SKLSKCD
|
| PMMSKLL2.NTX
|
SKLDESC
|
PMMBENE.DBF - Benefit File
| Field Name
|
Type
|
Width
|
Dec
|
Description
|
| BENBNCD
|
Character
|
03
|
|
Code
|
| BENDESC
|
Character
|
20
|
|
Desciption
|
| Index Name
|
Index Key
|
| PMMBENE1.NTX
|
BENBNCD
|
| PMMBENE2.NTX
|
BENDESC
|
