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

From SPGC Document Wiki
Jump to: navigation, search
 
(6 intermediate revisions by the same user not shown)
Line 281: Line 281:
 
|PMMDEPT2.NTX
 
|PMMDEPT2.NTX
 
|DEPNAME
 
|DEPNAME
 +
|-
 +
|PMMDEPT3.NTX
 +
|DEPOCDE
 
|}
 
|}
 +
=== PMMPOSN.DBF - Position Master File===
 +
{| class="wikitable" \
 +
|-
 +
! style="text-align:left;" | 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
 +
|}
 +
{| class="wikitable" \
 +
!style="text-align:left;"|Index Name
 +
!Index Key
 +
|-
 +
|PMMPOSN1.NTX
 +
|POSPSCD
 +
|-
 +
|PMMPOSN2.NTX
 +
|POSDESC
 +
|}
 +
=== PYMPCLS.DBF - Length of Service Table ===
 +
{| class="wikitable" \
 +
|-
 +
! style="text-align:left;" | 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 ===
 +
{| class="wikitable" \
 +
|-
 +
! style="text-align:left;" | 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
 +
|}
 +
{| class="wikitable" \
 +
!style="text-align:left;"|Index Name
 +
!Index Key
 +
|-
 +
|PYMACCT1.NTX
 +
|ACCOACD
 +
|-
 +
|PYMACCT2.NTX
 +
|ICLDESC
 +
|}
 +
=== PYMCOAC.DBF - Company Account Allocation File===
 +
{| class="wikitable" \
 +
|-
 +
! style="text-align:left;" | Field Name
 +
! Type
 +
! Width
 +
! Dec
 +
! Description
 +
|-
 +
|CACCOCD
 +
|Character
 +
|01
 +
|
 +
|Company Code
 +
|-
 +
|CACBKCD
 +
|Character
 +
|05
 +
|
 +
|Bank Code
 +
|-
 +
|CACACCT
 +
|Character
 +
|12
 +
|
 +
|Account Code
 +
|}
 +
{| class="wikitable" \
 +
!style="text-align:left;"|Index Name
 +
!Index Key
 +
|-
 +
|PYMCOAC1.NTX
 +
|PYMCOAC+CACBKCD
 +
|}
 +
=== PMMICLS.DBF - Infraction Classification File ===
 +
{| class="wikitable" \
 +
|-
 +
! style="text-align:left;" | Field Name
 +
! Type
 +
! Width
 +
! Dec
 +
! Description
 +
|-
 +
|ICLICCD
 +
|Character
 +
|02
 +
|
 +
|Infraction Code
 +
|-
 +
|ICLDESC
 +
|Character
 +
|158
 +
|
 +
|Description
 +
|}
 +
{| class="wikitable" \
 +
!style="text-align:left;"|Index Name
 +
!Index Key
 +
|-
 +
|PMMICLS1.NTX
 +
|ICLICCD
 +
|-
 +
|PMMICLS2.NTX
 +
|ICLDESC
 +
|}
 +
=== PMMJBLV.DBF - Job Level File ===
 +
{| class="wikitable" \
 +
|-
 +
! style="text-align:left;" | Field Name
 +
! Type
 +
! Width
 +
! Dec
 +
! Description
 +
|-
 +
|JBLJLCD
 +
|Character
 +
|02
 +
|
 +
|Job Level Code
 +
|-
 +
|JBLDESC
 +
|Character
 +
|20
 +
|
 +
|Description
 +
|}
 +
{| class="wikitable" \
 +
!style="text-align:left;"|Index Name
 +
!Index Key
 +
|-
 +
|PMMJBLV1.NTX
 +
|JBLJLCD
 +
|-
 +
|PMMJBLV2.NTX
 +
|JBLDESC
 +
|}
 +
=== PMMLOCA.DBF - Location Master File===
 +
{| class="wikitable" \
 +
|-
 +
! style="text-align:left;" | Field Name
 +
! Type
 +
! Width
 +
! Dec
 +
! Description
 +
|-
 +
|LOCCODE
 +
|Character
 +
|03
 +
|
 +
|Location Code
 +
|-
 +
|LOCDESC
 +
|Character
 +
|20
 +
|
 +
|Description
 +
|}
 +
{| class="wikitable" \
 +
!style="text-align:left;"|Index Name
 +
!Index Key
 +
|-
 +
|PMMLOCA1.NTX
 +
|LOCCODE
 +
|-
 +
|PMMLOCA2.NTX
 +
|LOCDESC
 +
|}
 +
=== PMMSECT.DBF - Section Master File ===
 +
{| class="wikitable" \
 +
|-
 +
! style="text-align:left;" | Field Name
 +
! Type
 +
! Width
 +
! Dec
 +
! Description
 +
|-
 +
|SECSCCD
 +
|Character
 +
|02
 +
|
 +
|Section Code
 +
|-
 +
|SECNAME
 +
|Character
 +
|25
 +
|
 +
|Section Name
 +
|}
 +
{| class="wikitable" \
 +
!style="text-align:left;"|Index Name
 +
!Index Key
 +
|-
 +
|PMMSECT1.NTX
 +
|SECSCCD
 +
|-
 +
|PMMSECT2.NTX
 +
|SECNAME
 +
|}
 +
=== PMMSHF2.DBF - Shift Schedule Master File (Rank and File) ===
 +
{| class="wikitable" \
 +
|-
 +
! style="text-align:left;" | 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
 +
|}
 +
{| class="wikitable" \
 +
!style="text-align:left;"|Index Name
 +
!Index Key
 +
|-
 +
|PMMSHF21.NTX
 +
|SHVSFCD+SHFRDCD
 +
|}
 +
=== PMMSHF.DBF - Shift Schedule Master File (VIP) ===
 +
{| class="wikitable" \
 +
|-
 +
! style="text-align:left;" | 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
 +
|}
 +
{| class="wikitable" \
 +
!style="text-align:left;"|Index Name
 +
!Index Key
 +
|-
 +
|PMMSHFV1.NTX
 +
|SHVSFCD+SHVRDCD
 +
|}
 +
=== PMMLOG.DBF - Log File===
 +
{| class="wikitable" \
 +
|-
 +
! style="text-align:left;" | 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
 +
|}
 +
{| class="wikitable" \
 +
!style="text-align:left;"|Index Name
 +
!Index Key
 +
|-
 +
|PMMLOGF1.NTX
 +
|LOGUSER+DTOS(LOGDATE)+LOGTIMI
 +
|}
 +
=== PYMBANK.DBF - Bank Master File ===
 +
{| class="wikitable" \
 +
|-
 +
! style="text-align:left;" | 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
 +
|}
 +
{| class="wikitable" \
 +
!style="text-align:left;"|Index Name
 +
!Index Key
 +
|-
 +
|PYMBANK1.NTX
 +
|BNKBKCD
 +
|-
 +
|PYMBANK2.NTX
 +
|BNKDESC
 +
|}
 +
=== PMMTAXT.DBF - Tax Status File ===
 +
{| class="wikitable" \
 +
|-
 +
! style="text-align:left;" | Field Name
 +
! Type
 +
! Width
 +
! Dec
 +
! Description
 +
|-
 +
|TAXTXCD
 +
|Character
 +
|04
 +
|
 +
|Tax Code
 +
|-
 +
|TAXDESC
 +
|Character
 +
|30
 +
|
 +
|Description
 +
|-
 +
|TAXEXEM
 +
|Numeric
 +
|09
 +
|02
 +
|Exemption
 +
|}
 +
{| class="wikitable" \
 +
!style="text-align:left;"|Index Name
 +
!Index Key
 +
|-
 +
|PMMTAXT1.NTX
 +
|TAXTXCD
 +
|-
 +
|PMMTAXT2.NTX
 +
|TAXDESC
 +
|}
 +
=== PMTNUMB.DBF - Employee Number Sequence File ===
 +
{| class="wikitable" \
 +
|-
 +
! style="text-align:left;" | 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
 +
|
 +
|Encoding Date|-
 +
|NMBPRNT
 +
|Character
 +
|01
 +
|
 +
|Printing Status
 +
|-
 +
|NMBCNTR
 +
|Numeric
 +
|03
 +
|
 +
|Counter
 +
|}
 +
{| class="wikitable" \
 +
!style="text-align:left;"|Index Name
 +
!Index Key
 +
|-
 +
|PMTNUMB1.NTX
 +
|NMBNUMB
 +
|-
 +
|PMTNUM2.NTX
 +
|NMBPRNT+DTOS(NMBENDT)+NMBNUMB
 +
|}
 +
[[Main_Page | Main Page]] > [[Application_Development_Team | Application Development Team]] > [[DB_Specs | DB Specs]] > [[PAYROLL_DB | Payroll DB]]

Latest revision as of 18:00, 12 January 2017

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

Retrieved from "http://115.85.30.86:286/spgcwiki/index.php?title=File(s)_located_at_R:%5CPAY%5CCOM%5CDB2&oldid=4480"