Definition of table Distributions
Employee Distributions , Table Dump Name res-0010

Alphabetical Field Summary

  • comp-code: (INTG) Employee's assigned company
  • comp-code-description: (CHAR) A brief description of the company's purpose
  • dept-code: (INTG) Employee's assigned department code
  • dept-code-description: (CHAR) A brief description of the departments purpose
  • dist-acct-num: (CHAR) Expense account to distribute to
  • dist-active: (LOGC) Distribution Active?
  • dist-code: (CHAR) Distibution Code letter
  • dist-cur-amount: (DECM) Current distribution amount for this payroll
  • dist-fytd-amount: (DECM) FYTD Amount for this distribution
  • dist-mtd-amount: (DECM) MTD amount for distribution
  • dist-percent: (DECM) Percentage to distribute to account
  • dist-qtd-amount: (DECM) QTD Amount for this distribution
  • dist-ytd-amount: (DECM) YTD Amount for this distribution
  • div-code: (INTG) Employee's assigned division
  • div-code-description: (CHAR) A brief description of the division's purpose
  • emp-active: (LOGC) Is employee currently active?
  • emp-fte: (DECM) Employee's Full Time Equivilency (0.00 to 1.00)
  • emp-group: (CHAR) An employee grouping classification
  • emp-id: (CHAR) Employee ID (if used)
  • emp-name: (CHAR) Employee's name in "LAST NAME, FIRST NAME M" order
  • emp-pic: (CHAR) Employee's PIC (assigned by State)
  • emp-sex: (LOGC) Employee's sex
  • emp-ssn: (CHAR) Employee's SSN
  • ethnic-code: (CHAR) Employee's ethnicity code
  • is-applicant: (LOGC) Yes if this entry is for an applicant
  • job-code: (CHAR) Employee's job code
  • job-code-description: (CHAR) A brief description of the job
  • loc-code: (CHAR) Employee's Primary Location
  • loc-code-description: (CHAR) A brief description of the job
  • marital-code: (CHAR) Employee's Marital status
  • master-check-num: (INTG) Check number
  • master-cycle-code: (CHAR) Name of this payroll cycle
  • master-ecc-code: (CHAR) ECC Code
  • master-pay-active: (LOGC) Is this employee active for this payroll?
  • master-pay-group: (CHAR) Name of this employee payroll group
  • master-pay-regular: (LOGC) 'Regular' or 'Supplemental' payroll
  • master-retire-code: (CHAR) Retirement code name
  • master-start-pay: (CHAR) Starting Payroll number.
  • master-stop-pay: (CHAR) Ending Payroll number.
  • payroll-num: (CHAR) Payroll number.
  • payroll-year: (INTG) Payroll year associated with this record
  • status-code: (CHAR) Employee's status code
  • union-member: (LOGC) Does employee belong to a union?

    Alphabetical Index Summary

  • comp-code: (PRIMARY) comp-code
  • dept-code: dept-code
  • dist-acct-num: dist-acct-num
  • dist-active: dist-active
  • dist-code: dist-code
  • div-code: div-code
  • emp-group: emp-group
  • emp-id: emp-id
  • emp-name: emp-name
  • emp-ssn: emp-ssn
  • ethnic-code: ethnic-code
  • is-applicant: is-applicant
  • job-code: job-code
  • loc-code: loc-code
  • marital-code: marital-code
  • master-check-num: master-check-num
  • master-cycle-code: master-cycle-code
  • master-ecc-code: master-ecc-code
  • master-pay-group: master-pay-group
  • master-retire-code: master-retire-code
  • master-start-pay: master-start-pay
  • master-stop-pay: master-stop-pay
  • payroll-num: payroll-num
  • payroll-year: payroll-year
  • status-code: status-code

    Tables Distributions references

  • Contacts - Employee Contacts
  • Counters - Employee Gross and Tax Counters
  • Deductions - Employee Deductions
  • Degree - Employee Degrees
  • Dependents - Employee Dependents
  • Events - Employee Events
  • Notes - Employee Notes
  • Payrates - Employee Payrates
  • Payrate_Distributions - Payrate Related Distributions
  • Retirement - Per Payroll Retirement
  • Taxes - Employee Tax Setup (no counters)
  • W2 - Employee W2 information

    Detailed Alphabetical Field Listing
    comp-code Data type: INTEGER
    Format: 99 (Initial Value: 0)
    Description: Employee's assigned company
    Attributes: Index Component

    comp-code-description Data type: CHARACTER
    Format: x(28)
    Description: A brief description of the company's purpose

    dept-code Data type: INTEGER
    Format: 9999 (Initial Value: 0)
    Description: Employee's assigned department code
    Attributes: Index Component

    dept-code-description Data type: CHARACTER
    Format: x(28)
    Description: A brief description of the departments purpose

    dist-acct-num Data type: CHARACTER
    Format: x(30)
    Description: Expense account to distribute to
    Attributes: Index Component

    dist-active Data type: LOGICAL
    Format: Yes/No (Initial Value: no)
    Description: Distribution Active?
    Attributes: Index Component

    dist-code Data type: CHARACTER
    Format: x
    Description: Distibution Code letter
    Attributes: Index Component

    dist-cur-amount Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)
    Description: Current distribution amount for this payroll

    dist-fytd-amount Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)
    Description: FYTD Amount for this distribution

    dist-mtd-amount Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)
    Description: MTD amount for distribution

    dist-percent Data type: DECIMAL (Decimals: 2)
    Format: zz9.99% (Initial Value: 0)
    Description: Percentage to distribute to account

    dist-qtd-amount Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)
    Description: QTD Amount for this distribution

    dist-ytd-amount Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)
    Description: YTD Amount for this distribution

    div-code Data type: INTEGER
    Format: 9999 (Initial Value: 0)
    Description: Employee's assigned division
    Attributes: Index Component

    div-code-description Data type: CHARACTER
    Format: x(28)
    Description: A brief description of the division's purpose

    emp-active Data type: LOGICAL
    Format: Yes/No (Initial Value: no)
    Description: Is employee currently active?

    emp-fte Data type: DECIMAL (Decimals: 2)
    Format: 9.99 (Initial Value: 0)
    Description: Employee's Full Time Equivilency (0.00 to 1.00)

    emp-group Data type: CHARACTER
    Format: x(8)
    Description: An employee grouping classification
    Attributes: Index Component

    emp-id Data type: CHARACTER
    Format: 999999
    Description: Employee ID (if used)
    Attributes: Index Component

    emp-name Data type: CHARACTER
    Format: x(30)
    Description: Employee's name in "LAST NAME, FIRST NAME M" order
    Attributes: Index Component

    emp-pic Data type: CHARACTER
    Format: x(10)
    Description: Employee's PIC (assigned by State)

    emp-sex Data type: LOGICAL
    Format: Male/Female (Initial Value: no)
    Description: Employee's sex

    emp-ssn Data type: CHARACTER
    Format: xxx-xx-xxxx
    Description: Employee's SSN
    Attributes: Index Component

    ethnic-code Data type: CHARACTER
    Format: x(8)
    Description: Employee's ethnicity code
    Attributes: Index Component

    is-applicant Data type: LOGICAL
    Format: Yes/No (Initial Value: no)
    Description: Yes if this entry is for an applicant
    Attributes: Index Component

    job-code Data type: CHARACTER
    Format: x(8)
    Description: Employee's job code
    Attributes: Index Component

    job-code-description Data type: CHARACTER
    Format: x(28)
    Description: A brief description of the job

    loc-code Data type: CHARACTER
    Format: x(8)
    Description: Employee's Primary Location
    Attributes: Index Component

    loc-code-description Data type: CHARACTER
    Format: x(28)
    Description: A brief description of the job

    marital-code Data type: CHARACTER
    Format: x(8)
    Description: Employee's Marital status
    Attributes: Index Component

    master-check-num Data type: INTEGER
    Format: 999999 (Initial Value: 0)
    Description: Check number
    Attributes: Index Component

    master-cycle-code Data type: CHARACTER
    Format: x(8)
    Description: Name of this payroll cycle
    Attributes: Index Component

    master-ecc-code Data type: CHARACTER
    Format: x(8)
    Description: ECC Code
    Attributes: Index Component

    master-pay-active Data type: LOGICAL
    Format: Yes/No (Initial Value: no)
    Description: Is this employee active for this payroll?

    master-pay-group Data type: CHARACTER
    Format: x(8)
    Description: Name of this employee payroll group
    Attributes: Index Component

    master-pay-regular Data type: LOGICAL
    Format: Regular/Supplemental (Initial Value: no)
    Description: 'Regular' or 'Supplemental' payroll

    master-retire-code Data type: CHARACTER
    Format: x(8)
    Description: Retirement code name
    Attributes: Index Component

    master-start-pay Data type: CHARACTER
    Format: x(5) (Initial Value: First)
    Description: Starting Payroll number.
    Attributes: Index Component

    master-stop-pay Data type: CHARACTER
    Format: x(4) (Initial Value: Last)
    Description: Ending Payroll number.
    Attributes: Index Component

    payroll-num Data type: CHARACTER
    Format: x(4)
    Description: Payroll number.
    Attributes: Index Component

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

    status-code Data type: CHARACTER
    Format: x(8)
    Description: Employee's status code
    Attributes: Index Component

    union-member Data type: LOGICAL
    Format: Yes/No (Initial Value: no)
    Description: Does employee belong to a union?

    Created on 08/13/2012 by DBHTML V1.2