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

From SPGC Document Wiki
Jump to: navigation, search
(Created page with " Main Page > Application Development Team > DB Specs > Payroll DB == Database File == === P...")
 
Line 64: Line 64:
 
|Character
 
|Character
 
|01
 
|01
 +
|
 +
|Description
 +
|}
 +
{| class="wikitable" \
 +
!style="text-align:left;"|Index Name
 +
!Index Key
 +
|-
 +
|PMMLNGE1.NTX
 +
|LNGCODE
 +
|-
 +
|PMMLNGE2.NTX
 +
|LNGDESC
 +
|}
 +
=== PMMPRVM.DBF - Province File ===
 +
{| class="wikitable" \
 +
|-
 +
! style="text-align:left;" | Field Name
 +
! Type
 +
! Width
 +
! Dec
 +
! Description
 +
|-
 +
|PRVPVCD
 +
|Character
 +
|03
 +
|
 +
|Province Code
 +
|-
 +
|PRVDESC
 +
|Character
 +
|30
 
|
 
|
 
|Description
 
|Description
Line 76: Line 107:
 
|PMMLNGE2.NTX
 
|PMMLNGE2.NTX
 
|PRVDESC
 
|PRVDESC
 +
|}
 +
=== PMMACIN.DBF - Action Againts Infraction File ===
 +
{| class="wikitable" \
 +
|-
 +
! style="text-align:left;" | Field Name
 +
! Type
 +
! Width
 +
! Dec
 +
! Description
 +
|-
 +
|ACIACD
 +
|Character
 +
|
 +
|03
 +
|Code
 +
|-
 +
|ACIDESC
 +
|Character
 +
|20
 +
|
 +
|Description
 +
|}
 +
{| class="wikitable" \
 +
!style="text-align:left;"|Index Name
 +
!Index Key
 +
|-
 +
|PMMACIN1.NTX
 +
|ACIACCD
 +
|-
 +
|PMMACIN2.NTX
 +
|ACIDESC
 +
|}
 +
=== PMMCSTA.DBF - Civil Status File===
 +
{| class="wikitable" \
 +
|-
 +
! style="text-align:left;" | Field Name
 +
! Type
 +
! Width
 +
! Dec
 +
! Description
 +
|-
 +
|CSTCSCD
 +
|Character
 +
|01
 +
|
 +
|Code
 +
|-
 +
|CSTDESC
 +
|Character
 +
|10
 +
|
 +
|Description
 +
|}
 +
{| class="wikitable" \
 +
!style="text-align:left;"|Index Name
 +
!Index Key
 +
|-
 +
|PMMCSTA1.NTX
 +
|CSTCSCD
 +
|-
 +
|PMMCSTA2.NTX
 +
|CSTDESC
 +
|}
 +
=== PMMMACH.DBF - Office Machines File ===
 +
{| class="wikitable" \
 +
|-
 +
! style="text-align:left;" | Field Name
 +
! Type
 +
! Width
 +
! Dec
 +
! Description
 +
|-
 +
|MACMCCD
 +
|Character
 +
|02
 +
|
 +
|Code
 +
|-
 +
|MACDESC
 +
|Character
 +
|25
 +
|
 +
|Description
 +
|}
 +
{| class="wikitable" \
 +
!style="text-align:left;"|Index Name
 +
!Index Key
 +
|-
 +
|PMMMACH1.NTX
 +
|MACMCCD
 +
|-
 +
|PMMMACH2.NTX
 +
|MACDESC
 +
|}
 +
=== PMMCTZP.DBF - Citizenship File ===
 +
{| class="wikitable" \
 +
|-
 +
! style="text-align:left;" | Field Name
 +
! Type
 +
! Width
 +
! Dec
 +
! Description
 +
|-
 +
|CTZCZCD
 +
|Character
 +
|02
 +
|
 +
|Code
 +
|-
 +
|CTZDESC
 +
|Character
 +
|10
 +
|
 +
|Description
 +
|}
 +
{| class="wikitable" \
 +
!style="text-align:left;"|Index Name
 +
!Index Key
 +
|-
 +
|PMMCTZP1.NTX
 +
|CTZCZCD
 +
|-
 +
|PMMCTZP2.NTX
 +
|CTZDESC
 +
|}
 +
=== PMMMART.DBF - PAM Rating File ===
 +
{| class="wikitable" \
 +
|-
 +
! style="text-align:left;" | Field Name
 +
! Type
 +
! Width
 +
! Dec
 +
! Description
 +
|-
 +
|PARPRCD
 +
|Character
 +
|02
 +
|
 +
|Code
 +
|-
 +
|PARDESC
 +
|Character
 +
|20
 +
|
 +
|Description
 +
|}
 +
{| class="wikitable" \
 +
!style="text-align:left;"|Index Name
 +
!Index Key
 +
|-
 +
|PMMMART1.NTX
 +
|PARPRCD
 +
|-
 +
|PMMMART2.NTX
 +
|PARDESC
 +
|}
 +
=== PMMACT.DBF - PAM Action File ===
 +
{| class="wikitable" \
 +
|-
 +
! style="text-align:left;" | Field Name
 +
! Type
 +
! Width
 +
! Dec
 +
! Description
 +
|-
 +
|PACPACD
 +
|Character
 +
|02
 +
|
 +
|Code
 +
|-
 +
|PACDESC
 +
|Character
 +
|20
 +
|
 +
|Description
 +
|}
 +
{| class="wikitable" \
 +
!style="text-align:left;"|Index Name
 +
!Index Key
 +
|-
 +
|PMMPACT1.NTX
 +
|PACPACD
 +
|-
 +
|PMMPACT2.NTX
 +
|PACDESC
 +
|}
 +
=== PMMRELG.DBF - Relationship File===
 +
{| class="wikitable" \
 +
|-
 +
! style="text-align:left;" | Field Name
 +
! Type
 +
! Width
 +
! Dec
 +
! Description
 +
|-
 +
|RELRGCD
 +
|Character
 +
|02
 +
|
 +
|Code
 +
|-
 +
|RELDESC
 +
|Character
 +
|20
 +
|
 +
|Description
 +
|}
 +
{| class="wikitable" \
 +
!style="text-align:left;"|Index Name
 +
!Index Key
 +
|-
 +
|PMMRELG1.NTX
 +
|RELRGCD
 +
|-
 +
|PMMRELG2.NTX
 +
|RELDESC
 +
|}
 +
=== PMMRLTP.DBF - Relationship File ===
 +
{| class="wikitable" \
 +
|-
 +
! style="text-align:left;" | Field Name
 +
! Type
 +
! Width
 +
! Dec
 +
! Description
 +
|-
 +
|RLTRLCD
 +
|Character
 +
|02
 +
|
 +
|Code
 +
|-
 +
|RLTDESC
 +
|Character
 +
|15
 +
|
 +
|Description
 +
|-
 +
|RLTSXCD
 +
|Character
 +
|01
 +
|
 +
|Sex Code
 +
|}
 +
{| class="wikitable" \
 +
!style="text-align:left;"|Index Name
 +
!Index Key
 +
|-
 +
|PMMRLTP1.NTX
 +
|RLTRLCD
 +
|-
 +
|PMMRLT2.NTX
 +
|RLTDESC
 
|}
 
|}

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