Difference between revisions of "File(s) located at R:\PAY\PMS\DB2"

From SPGC Document Wiki
Jump to: navigation, search
Line 362: Line 362:
 
|RLTDESC
 
|RLTDESC
 
|}
 
|}
 +
=== PMMTOWN.DBF - Town Master File ===
 +
{| class="wikitable" \
 +
|-
 +
! style="text-align:left;" | Field Name
 +
! Type
 +
! Width
 +
! Dec
 +
! Description
 +
|-
 +
|TWNTNCD
 +
|Character
 +
|03
 +
|
 +
|Code
 +
|-
 +
|TWNDESC
 +
|Character
 +
|20
 +
|
 +
|Descriptiom
 +
|-
 +
|TWNCTCD
 +
|Character
 +
|03
 +
|
 +
|City Code
 +
|}
 +
{| class="wikitable" \
 +
!style="text-align:left;"|Index Name
 +
!Index Key
 +
|-
 +
|PMMTOWN1.NTX
 +
|TWNTNCD
 +
|-
 +
|PMMTOWN2.NTX
 +
|TWNDESC
 +
|}
 +
=== PMMSKLL.DBF - Skill File ===
 +
{| class="wikitable" \
 +
|-
 +
! style="text-align:left;" | Field Name
 +
! Type
 +
! Width
 +
! Dec
 +
! Description
 +
|-
 +
|SKLSKCD
 +
|Character
 +
|02
 +
|
 +
|Code
 +
|-
 +
|SKLDESC Character
 +
|Character
 +
|20
 +
|
 +
|Description
 +
|}
 +
{| class="wikitable" \
 +
!style="text-align:left;"|Index Name
 +
!Index Key
 +
|-
 +
|PMMSKLL1.NTX
 +
|SKLSKCD
 +
|-
 +
|PMMSKLL2.NTX
 +
|SKLDESC
 +
|}
 +
=== PMMBENE.DBF - Benefit File ===
 +
{| class="wikitable" \
 +
|-
 +
! style="text-align:left;" | Field Name
 +
! Type
 +
! Width
 +
! Dec
 +
! Description
 +
|-
 +
|BENBNCD
 +
|Character
 +
|03
 +
|
 +
|Code
 +
|-
 +
|BENDESC
 +
|Character
 +
|20
 +
|
 +
|Desciption

Revision as of 09:45, 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
Retrieved from "http://115.85.30.86:286/spgcwiki/index.php?title=File(s)_located_at_R:%5CPAY%5CPMS%5CDB2&oldid=4484"