Definition of table pay-profile
Payroll System Profile , Table Dump Name pay-prof

Alphabetical Field Summary

  • ap-cash-acct-num: (CHAR) Cash Account used for creating AP disbursements
  • bank-aba: (CHAR) Bank ABA/Routing # for payroll checks
  • bank-acct: (CHAR) Bank Acct # for Payroll Checks
  • calendar-year: (INTG) Calendar year associated with this record
  • cash-acct-num: (CHAR) Cash account used for creating checks
  • cash-check-run: (INTG) Check run to create disbursement for
  • cash-disburse: (LOGC) Yes to automatically create disbursements
  • cash-ent-id: (CHAR) Vendor ID to create disbursement for
  • check-mod: (CHAR) Name of the check printing module
  • check-num: (INTG) Next Check number to print
  • county-code: (CHAR) State assigned county code
  • disabled-companies: (CHAR) List of companies which are disabled
  • disabled-departments: (CHAR) List of departments which are disabled
  • disabled-divisions: (CHAR) List of departments which are disabled
  • distrib-futa: (LOGC) Yes to enable distributions/disbursements of FUTA
  • distrib-retire: (LOGC) Yes to enable distributions/disbursements of Retirement
  • distrib-savings: (LOGC) Yes to Disribute summers savings accruals to FAS
  • distrib-suta: (LOGC) Yes to enable distributions/disbursements of SUTA
  • distribute-gl: (LOGC) 'Yes' to automatically distribute salaries & liabilities to
  • district-code: (CHAR) State assigned district #
  • enable-fica: (LOGC) Yes to enable FICA taxes, No to disable them
  • enable-fit: (LOGC) Yes to enable federal taxes, No to disable them
  • enable-futa: (LOGC) Yes to enable FUTA taxes, No to disable them
  • enable-lit: (LOGC) Yes to enable local (i.e. city) taxes, No to disable them
  • enable-medicare: (LOGC) Yes to enable Medicare Taxes, No to disable them
  • enable-oit: (LOGC) Yes to enable 'Other' income taxes, No to disable them
  • enable-retire: (LOGC) Yes to enable basic retirement, No to disable it
  • enable-sit: (LOGC) Yes to enable State Taxes, No to disable them
  • enable-suta: (LOGC) Yes to enable SUTA Taxes, No to disable them
  • extern-guid: (CHAR) External Global Unique ID for this record
  • extra-multiplier: (DECM) Extra wage multiplier
  • federal-retire-acct-num: (CHAR) Liability account to distribute basic federal retirement tax
  • federal-retire-check-run: (INTG) Check run to create disbursement for
  • federal-retire-disburse: (LOGC) Yes to automatically create disbursements
  • federal-retire-ent-id: (CHAR) Vendor ID to create disbursement for
  • fein: (CHAR) Districts FEIN #
  • fica-acct-num: (CHAR) Liability account to distribute FICA taxes to
  • fica-check-run: (INTG) Check run to create disbursement for
  • fica-disburse: (LOGC) Yes to automatically create disbursements
  • fica-ent-id: (CHAR) Vendor ID to create disbursement for
  • fica-limit: (DECM) FICA Wage Limit
  • fica-max-tax: (DECM) Maximum FICA tax possible given the wage limit & percentage
  • fica-percent: (DECM) FICA Tax Percentage
  • fit-name: (CHAR) Name of the default tax table for Federal taxes
  • futa-acct-num: (CHAR) Liability account to distribute FUTA taxes to
  • futa-check-run: (INTG) Check run to create disbursement for
  • futa-disburse: (LOGC) Yes to automatically create disbursements
  • futa-ent-id: (CHAR) Vendor ID to create disbursement for
  • futa-limit: (DECM) FUTA Wage Limit
  • futa-max-tax: (DECM) Maximum FUTA tax possible given the wage limit & percentage
  • futa-percent: (DECM) FUTA Tax Percentage
  • image-path: (CHAR) Image path for download based form printers
  • journal-code: (CHAR) GL Journal to record Payroll distributions under
  • lit-name: (CHAR) Name of default tax table to use for this tax
  • medicare-acct-num: (CHAR) Liability account to distribute Medicare taxes to
  • medicare-check-run: (INTG) Check run to create disbursement for
  • medicare-disburse: (LOGC) Yes to automatically create disbursements
  • medicare-ent-id: (CHAR) Vendor ID to create disbursement for
  • medicare-limit: (DECM) Medicare Wage Limit
  • medicare-max-tax: (DECM) Maximum Medicare tax possible given the wage limit & percent
  • medicare-percent: (DECM) Medicare Tax Percentage
  • oit-name: (CHAR) Name of default tax table for use with this tax
  • overtime-multiplier: (DECM) Overtime Wage multiplier
  • pay-accr-desc[5]: (CHAR) Description of this payroll accrual definition
  • pay-accr-group-code[5]: (CHAR) Accrual Group Code for this payroll accrual definition
  • primary-key: (INTG) Unique, Primary key for record
  • retirement-id: (CHAR) State Retirement Number
  • savings-acct-num: (CHAR) Liability Account Summer Savings accrues in
  • sit-name: (CHAR) Name of default tax table to use for state tax
  • site-addr[2]: (CHAR) District's administration building street address
  • site-city: (CHAR) District's administration buildings city
  • site-phone: (CHAR) District's administration building phone # and extension
  • site-state: (CHAR) District's administration building state
  • site-state-fips: (CHAR) Enter 2 digit State FIPS Code
  • site-zip: (CHAR) District's administration building zip code
  • state-retire-acct-num: (CHAR) Liability account to distribute state basic retirement taxes
  • state-retire-cei: (DECM) Cost of Education Index %age
  • state-retire-check-run: (INTG) Check run to create disbursement for
  • state-retire-disburse: (LOGC) Yes to automatically create disbursements
  • state-retire-ent-id: (CHAR) Vendor ID to create disbursement for
  • state-retire-insure: (DECM) State Retirement Health Coverage Matching %age
  • state-retire-match: (DECM) State Retirement Matching %age
  • state-unemp-num: (CHAR) Enter State Unemployment Insurace Account Number
  • suta-acct-num: (CHAR) Liability account to distribute SUTA taxes to
  • suta-check-run: (INTG) Check run to create disbursement for
  • suta-disburse: (LOGC) Yes to automatically create disbursements
  • suta-ent-id: (CHAR) Vendor ID to create disbursement for
  • suta-limit: (DECM) SUTA Wage Limit
  • suta-max-tax: (DECM) Maximum SUTA tax possible given the wage limit & percentage
  • suta-percent: (DECM) SUTA Tax Percentage
  • using-laser-check: (LOGC) Yes if using laser checks for payroll
  • w2-control-num: (INTG) Next Control # to assign for a W2
  • w2-mod: (CHAR) Name of W2 Form Printer Module

    Alphabetical Index Summary

  • extern-guid: extern-guid
  • pay-profile: (UNIQUE, PRIMARY) calendar-year

    Alphabetical Trigger Summary

  • CREATE: Overridable, Procedure is tr-c-ppf.p
  • DELETE: Overridable, Procedure is tr-d-ppf.p
  • REPLICATION-CREATE: Procedure is rp-c-ppf.p
  • REPLICATION-DELETE: Procedure is rp-d-ppf.p
  • REPLICATION-WRITE: Procedure is rp-u-ppf.p
  • WRITE: Overridable, Procedure is tr-u-ppf.p

    Other tables who reference pay-profile

  • aca-benefit-plan - ACA Benefit Plan codes
  • aca-category-code - (no description available)
  • aca-coverage-code - ACA Coverage Codes
  • aca-safe-harbor-code - (no description available)
  • district-1094c - (no description available)
  • emp-1095c - Employee 1095c filing record
  • emp-aca - (no description available)
  • emp-quarter - Employee Quarterly Retirement reporting records
  • emp-w2 - Employee W2 Info
  • pay-schd - Payroll Schedule for a year One entry per
  • tax-table - Federal, State and Local tax tables

    Tables pay-profile references

  • emp-w2 - Employee W2 Info


    Detailed Alphabetical Field Listing
    ap-cash-acct-num Data type: CHARACTER
    Format: x(30)
    Help: Cash Account used for creating AP disbursements

    bank-aba Data type: CHARACTER
    Format: x(8)
    Help: Bank ABA/Routing # for payroll checks

    bank-acct Data type: CHARACTER
    Format: x(25)
    Help: Bank Acct # for Payroll Checks

    calendar-year Data type: INTEGER
    Format: 9999 (Initial Value: 0)
    Description: Calendar year associated with this record
    Attributes: Index Component

    cash-acct-num Data type: CHARACTER
    Format: x(30)
    Help: Cash account used for creating checks

    cash-check-run Data type: INTEGER
    Format: zzz (Initial Value: 0)
    Help: Check run to create disbursement for

    cash-disburse Data type: LOGICAL
    Format: Yes/No (Initial Value: No)
    Help: Yes to automatically create disbursements

    cash-ent-id Data type: CHARACTER
    Format: x(6)
    Help: Vendor ID to create disbursement for

    check-mod Data type: CHARACTER
    Format: x(16)
    Help: Name of the check printing module

    check-num Data type: INTEGER
    Format: zzzzz9 (Initial Value: 0)
    Help: Next Check number to print

    county-code Data type: CHARACTER
    Format: x(6)
    Help: State assigned county code

    disabled-companies Data type: CHARACTER
    Format: x(50)
    Help: List of companies which are disabled

    disabled-departments Data type: CHARACTER
    Format: x(50)
    Help: List of departments which are disabled

    disabled-divisions Data type: CHARACTER
    Format: x(50)
    Help: List of departments which are disabled

    distrib-futa Data type: LOGICAL
    Format: Yes/No (Initial Value: No)
    Help: Yes to enable distributions/disbursements of FUTA

    distrib-retire Data type: LOGICAL
    Format: Yes/No (Initial Value: No)
    Help: Yes to enable distributions/disbursements of Retirement

    distrib-savings Data type: LOGICAL
    Format: Yes/No (Initial Value: No)
    Help: Yes to Disribute summers savings accruals to FAS

    distrib-suta Data type: LOGICAL
    Format: Yes/No (Initial Value: No)
    Help: Yes to enable distributions/disbursements of SUTA

    distribute-gl Data type: LOGICAL
    Format: Yes/No (Initial Value: No)
    Help: 'Yes' to automatically distribute salaries & liabilities to

    district-code Data type: CHARACTER
    Format: x(6)
    Help: State assigned district #

    enable-fica Data type: LOGICAL
    Format: Yes/No (Initial Value: Yes)
    Help: Yes to enable FICA taxes, No to disable them

    enable-fit Data type: LOGICAL
    Format: Yes/No (Initial Value: Yes)
    Help: Yes to enable federal taxes, No to disable them

    enable-futa Data type: LOGICAL
    Format: Yes/No (Initial Value: Yes)
    Help: Yes to enable FUTA taxes, No to disable them

    enable-lit Data type: LOGICAL
    Format: Yes/No (Initial Value: Yes)
    Help: Yes to enable local (i.e. city) taxes, No to disable them

    enable-medicare Data type: LOGICAL
    Format: Yes/No (Initial Value: Yes)
    Help: Yes to enable Medicare Taxes, No to disable them

    enable-oit Data type: LOGICAL
    Format: Yes/No (Initial Value: No)
    Help: Yes to enable 'Other' income taxes, No to disable them

    enable-retire Data type: LOGICAL
    Format: Yes/No (Initial Value: Yes)
    Help: Yes to enable basic retirement, No to disable it

    enable-sit Data type: LOGICAL
    Format: Yes/No (Initial Value: Yes)
    Help: Yes to enable State Taxes, No to disable them

    enable-suta Data type: LOGICAL
    Format: Yes/No (Initial Value: Yes)
    Help: Yes to enable SUTA Taxes, No to disable them

    extern-guid Data type: CHARACTER
    Format: x(32)
    Description: External Global Unique ID for this record
    Attributes: Index Component

    extra-multiplier Data type: DECIMAL (Decimals: 2)
    Format: zz9.99 (Initial Value: 2.0)
    Help: Extra wage multiplier

    federal-retire-acct-num Data type: CHARACTER
    Format: x(30)
    Help: Liability account to distribute basic federal retirement tax

    federal-retire-check-run Data type: INTEGER
    Format: zzz (Initial Value: 0)
    Help: Check run to create disbursement for

    federal-retire-disburse Data type: LOGICAL
    Format: Yes/No (Initial Value: No)
    Help: Yes to automatically create disbursements

    federal-retire-ent-id Data type: CHARACTER
    Format: x(6)
    Help: Vendor ID to create disbursement for

    fein Data type: CHARACTER
    Format: 99-9999999
    Help: Districts FEIN #

    fica-acct-num Data type: CHARACTER
    Format: x(30)
    Help: Liability account to distribute FICA taxes to

    fica-check-run Data type: INTEGER
    Format: zzz (Initial Value: 0)
    Help: Check run to create disbursement for

    fica-disburse Data type: LOGICAL
    Format: Yes/No (Initial Value: No)
    Help: Yes to automatically create disbursements

    fica-ent-id Data type: CHARACTER
    Format: x(6)
    Help: Vendor ID to create disbursement for

    fica-limit Data type: DECIMAL (Decimals: 2)
    Format: zzz,zz9.99 (Initial Value: 0)
    Help: FICA Wage Limit

    fica-max-tax Data type: DECIMAL (Decimals: 2)
    Format: zzz,zz9.99 (Initial Value: 0)
    Description: Maximum FICA tax possible given the wage limit & percentage

    fica-percent Data type: DECIMAL (Decimals: 3)
    Format: zz9.999% (Initial Value: 0)
    Help: FICA Tax Percentage

    fit-name Data type: CHARACTER
    Format: x(8)
    Help: Name of the default tax table for Federal taxes

    futa-acct-num Data type: CHARACTER
    Format: x(30)
    Help: Liability account to distribute FUTA taxes to

    futa-check-run Data type: INTEGER
    Format: zzz (Initial Value: 0)
    Help: Check run to create disbursement for

    futa-disburse Data type: LOGICAL
    Format: Yes/No (Initial Value: No)
    Help: Yes to automatically create disbursements

    futa-ent-id Data type: CHARACTER
    Format: x(6)
    Help: Vendor ID to create disbursement for

    futa-limit Data type: DECIMAL (Decimals: 2)
    Format: zzz,zz9.99 (Initial Value: 0)
    Help: FUTA Wage Limit

    futa-max-tax Data type: DECIMAL (Decimals: 2)
    Format: zzz,zz9.99 (Initial Value: 0)
    Description: Maximum FUTA tax possible given the wage limit & percentage

    futa-percent Data type: DECIMAL (Decimals: 3)
    Format: zz9.999% (Initial Value: 0)
    Help: FUTA Tax Percentage

    image-path Data type: CHARACTER
    Format: x(32)
    Help: Image path for download based form printers

    journal-code Data type: CHARACTER
    Format: x(6)
    Help: GL Journal to record Payroll distributions under

    lit-name Data type: CHARACTER
    Format: x(8)
    Help: Name of default tax table to use for this tax

    medicare-acct-num Data type: CHARACTER
    Format: x(30)
    Help: Liability account to distribute Medicare taxes to

    medicare-check-run Data type: INTEGER
    Format: zzz (Initial Value: 0)
    Help: Check run to create disbursement for

    medicare-disburse Data type: LOGICAL
    Format: Yes/No (Initial Value: No)
    Help: Yes to automatically create disbursements

    medicare-ent-id Data type: CHARACTER
    Format: x(6)
    Help: Vendor ID to create disbursement for

    medicare-limit Data type: DECIMAL (Decimals: 2)
    Format: zzz,zz9.99 (Initial Value: 0)
    Help: Medicare Wage Limit

    medicare-max-tax Data type: DECIMAL (Decimals: 2)
    Format: zzz,zz9.99 (Initial Value: 0)
    Description: Maximum Medicare tax possible given the wage limit & percent

    medicare-percent Data type: DECIMAL (Decimals: 3)
    Format: zz9.999% (Initial Value: 0)
    Help: Medicare Tax Percentage

    oit-name Data type: CHARACTER
    Format: x(8)
    Help: Name of default tax table for use with this tax

    overtime-multiplier Data type: DECIMAL (Decimals: 2)
    Format: zz9.99 (Initial Value: 1.5)
    Help: Overtime Wage multiplier

    pay-accr-desc Data type: CHARACTER (Extent: 5)
    Format: x(20)
    Help: Description of this payroll accrual definition

    pay-accr-group-code Data type: CHARACTER (Extent: 5)
    Format: x(8)
    Help: Accrual Group Code for this payroll accrual definition

    primary-key Data type: INTEGER
    Format: zzzzzzzzz9
    Help: Unique, Primary key for record

    retirement-id Data type: CHARACTER
    Format: x(9)
    Help: State Retirement Number

    savings-acct-num Data type: CHARACTER
    Format: x(30)
    Help: Liability Account Summer Savings accrues in

    sit-name Data type: CHARACTER
    Format: x(8)
    Help: Name of default tax table to use for state tax

    site-addr Data type: CHARACTER (Extent: 2)
    Format: x(32)
    Help: District's administration building street address

    site-city Data type: CHARACTER
    Format: x(20)
    Help: District's administration buildings city

    site-phone Data type: CHARACTER
    Format: (xxx) 999-9999 ~xxxxx
    Help: District's administration building phone # and extension

    site-state Data type: CHARACTER
    Format: !!
    Help: District's administration building state

    site-state-fips Data type: CHARACTER
    Format: 99
    Help: Enter 2 digit State FIPS Code

    site-zip Data type: CHARACTER
    Format: x(10)
    Help: District's administration building zip code

    state-retire-acct-num Data type: CHARACTER
    Format: x(30)
    Help: Liability account to distribute state basic retirement taxes

    state-retire-cei Data type: DECIMAL (Decimals: 3)
    Format: zz9.999% (Initial Value: 0)
    Help: Cost of Education Index %age

    state-retire-check-run Data type: INTEGER
    Format: zzz (Initial Value: 0)
    Help: Check run to create disbursement for

    state-retire-disburse Data type: LOGICAL
    Format: Yes/No (Initial Value: No)
    Help: Yes to automatically create disbursements

    state-retire-ent-id Data type: CHARACTER
    Format: x(6)
    Help: Vendor ID to create disbursement for

    state-retire-insure Data type: DECIMAL (Decimals: 3)
    Format: zz9.999% (Initial Value: 0)
    Help: State Retirement Health Coverage Matching %age

    state-retire-match Data type: DECIMAL (Decimals: 3)
    Format: zz9.999% (Initial Value: 0)
    Help: State Retirement Matching %age

    state-unemp-num Data type: CHARACTER
    Format: x(9)
    Help: Enter State Unemployment Insurace Account Number

    suta-acct-num Data type: CHARACTER
    Format: x(30)
    Help: Liability account to distribute SUTA taxes to

    suta-check-run Data type: INTEGER
    Format: zzz (Initial Value: 0)
    Help: Check run to create disbursement for

    suta-disburse Data type: LOGICAL
    Format: Yes/No (Initial Value: No)
    Help: Yes to automatically create disbursements

    suta-ent-id Data type: CHARACTER
    Format: x(6)
    Help: Vendor ID to create disbursement for

    suta-limit Data type: DECIMAL (Decimals: 2)
    Format: zzz,zz9.99 (Initial Value: 0)
    Help: SUTA Wage Limit

    suta-max-tax Data type: DECIMAL (Decimals: 2)
    Format: zzz,zz9.99 (Initial Value: 0)
    Description: Maximum SUTA tax possible given the wage limit & percentage

    suta-percent Data type: DECIMAL (Decimals: 3)
    Format: zz9.999% (Initial Value: 0)
    Help: SUTA Tax Percentage

    using-laser-check Data type: LOGICAL
    Format: Yes/No (Initial Value: No)
    Help: Yes if using laser checks for payroll

    w2-control-num Data type: INTEGER
    Format: zzzzz9 (Initial Value: 0)
    Help: Next Control # to assign for a W2

    w2-mod Data type: CHARACTER
    Format: x(20)
    Help: Name of W2 Form Printer Module

    Created on 12/28/2020 by DBHTML V1.2