Definition of table Payrates
Employee Payrates , Table Dump Name res-0014

Alphabetical Field Summary

  • adjust-amount: (DECM) Amount of adjustment to apply to payrate for this payroll
  • adjust-pay-cnt: (INTG) Number of payrolls this adjustment has been active on
  • adjust-pay-max: (CHAR) Number of payrolls to apply adjustment
  • adjust-type: (CHAR) Type of adjustment (Normal, Contract, Retro or Backup)
  • comp-code: (INTG) Employee's assigned company
  • comp-code-description: (CHAR) A brief description of the company's purpose
  • cont-adjust: (DECM) Amount of adjustment applied for this payroll
  • cont-extra-hours: (DECM) Extra hours for this payroll
  • cont-gross: (DECM) Payrate gross for this payroll
  • cont-overtime-hours: (DECM) Overtime hours for this payroll
  • cont-regular-hours: (DECM) Number of regular hours for this payroll
  • cont-retire-hours: (DECM) Total retirement hours for this payrate and payroll
  • cur-adjust: (DECM) Amount of adjustment applied for this payroll
  • cur-adjust-type: (CHAR) Adjustment type as of last calculation
  • cur-extra-hours: (DECM) Extra hours for this payroll
  • cur-gross: (DECM) Payrate gross for this payroll
  • cur-overtime-hours: (DECM) Overtime hours for this payroll
  • cur-regular-hours: (DECM) Number of regular hours for this payroll
  • cur-retire-hours: (DECM) Total retirement hours for this payrate and payroll
  • default-regular-hours: (DECM) Default 'regular' hours for this payrate
  • default-retire-hours: (DECM) Default number of retirement hours for this payrate
  • dept-code: (INTG) Employee's assigned department code
  • dept-code-description: (CHAR) A brief description of the departments purpose
  • 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
  • exempt-fica: (LOGC) 'Yes' if payrate is exempt from FICA, otherwise 'No'
  • exempt-fit: (LOGC) 'Yes' if payrate is exempt from FIT, otherwise 'No'
  • exempt-futa: (LOGC) 'Yes' if payrate is exempt from FUTA, otherwise 'No'
  • exempt-lit: (LOGC) 'Yes' if payrate is exempt from LIT, otherwise 'No'
  • exempt-medicare: (LOGC) 'Yes' if payrate is exempt from Medicare, otherwise 'No'
  • exempt-oit: (LOGC) 'Yes' if payrate is exempt from OIT, otherwise 'No'
  • exempt-retire: (LOGC) 'Yes' if payrate is exempt from retirement, 'No' otherwise
  • exempt-sit: (LOGC) 'Yes' if payrate is exempt from SIT, otherwise 'No'
  • exempt-suta: (LOGC) 'Yes' if payrate is exempt from SUTA, otherwise 'No'
  • extra-amount: (DECM) Amount calculated amount for the extra hours on this payroll
  • extra-hours: (DECM) Extra hours for this payroll
  • for-regular-pay: (LOGC) 'Reg' to use only for regular pays, 'All' to use for all pay
  • fytd-adjust: (DECM) Amount of adjustment applied for this payroll
  • fytd-extra-hours: (DECM) FYTD Extra hours
  • fytd-gross: (DECM) FYTD Payrate gross
  • fytd-overtime-hours: (DECM) FYTD Overtime hours
  • fytd-regular-hours: (DECM) FYTD regular hours
  • fytd-retire-hours: (DECM) FYTD retirement hours
  • 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.
  • mtd-adjust: (DECM) MTD adjustment amount
  • mtd-extra-hours: (DECM) MTD Extra hours
  • mtd-gross: (DECM) MTD Payrate gross
  • mtd-overtime-hours: (DECM) MTD Overtime hours
  • mtd-regular-hours: (DECM) MTD regular hours
  • mtd-retire-hours: (DECM) MTD retirement hours
  • overtime-amount: (DECM) Amount calculated for overtime on this payroll
  • overtime-hours: (DECM) Overtime hours for this payroll
  • pay-over-cnt: (INTG) Number of payrolls to split contract limit over (salaried on
  • payroll-num: (CHAR) Payroll number.
  • payroll-year: (INTG) Payroll year associated with this record
  • qtd-adjust: (DECM) QTD adjustment amount
  • qtd-extra-hours: (DECM) QTD Extra hours
  • qtd-gross: (DECM) QTD Payrate gross
  • qtd-overtime-hours: (DECM) QTD Overtime hours
  • qtd-regular-hours: (DECM) QTD regular hours
  • qtd-retire-hours: (DECM) QTDl retirement hours
  • rate-active: (LOGC) Is this payrate active for this payroll?
  • rate-amount: (DECM) Hourly wage amount for 'Hourly' rate or per payroll amount f
  • rate-assignment-code: (CHAR) Name of assignment
  • rate-cycle-code: (CHAR) Name of this payroll cycle
  • rate-hourly: (LOGC) 'Hourly' for an hourly based payrate or 'Salary' otherwise
  • rate-limit: (DECM) Payrate/Contract limit
  • rate-name: (CHAR) Name of payrate
  • rate-num: (INTG) Payrate number
  • rate-primary: (LOGC) 'Yes' if this is considered the 'Primary' payrate
  • rate-schd-level: (CHAR) Name or label for this step/level
  • rate-schd-name: (CHAR) Name of this payroll contract schedule
  • rate-schd-step: (CHAR) Name or label for this step/level
  • rate-start-pay: (CHAR) Payroll number.
  • rate-stop-pay: (CHAR) Payroll number.
  • rate-type: (CHAR) Type of payrate (Normal, Retro or Backup)
  • regular-amount: (DECM) Amount calculated for regular hours on this payroll
  • regular-hours: (DECM) Number of regular hours for this payroll
  • retire-hours: (DECM) Total retirement hours for this payrate and payroll
  • save-accrued-fica-released: (DECM) FICA Amount Released
  • save-accrued-fica-saved: (DECM) FICA Amount Saved
  • save-accrued-rate-released: (DECM) Accrued released
  • save-accrued-rate-saved: (DECM) Accrued Savings
  • save-accrued-retire-released: (DECM) Amount released from retirement
  • save-accrued-retire-saved: (DECM) Amount saved toward retirement
  • save-cur-fica-released: (DECM) FICA Amount Released
  • save-cur-fica-saved: (DECM) FICA Amount Saved
  • save-cur-rate-released: (DECM) Cur Released
  • save-cur-rate-saved: (DECM) Cur Amount saved
  • save-cur-retire-released: (DECM) Amount released from retirement
  • save-cur-retire-saved: (DECM) Amount saved toward retirement
  • save-cycle-code: (CHAR) Name of this payroll cycle
  • save-fytd-fica-released: (DECM) FICA Amount Released
  • save-fytd-fica-saved: (DECM) FICA Amount Saved
  • save-fytd-rate-released: (DECM) FYTD Released
  • save-fytd-rate-saved: (DECM) FYTD Saved
  • save-fytd-retire-released: (DECM) Amount released from retirement
  • save-fytd-retire-saved: (DECM) Amount saved toward retirement
  • save-mtd-fica-released: (DECM) FICA Amount Released
  • save-mtd-fica-saved: (DECM) FICA Amount Saved
  • save-mtd-rate-released: (DECM) MTD Released
  • save-mtd-rate-saved: (DECM) MTD Saved
  • save-mtd-retire-released: (DECM) Amount released from retirement
  • save-mtd-retire-saved: (DECM) Amount saved toward retirement
  • save-per-payroll-amount: (DECM) Amount to accrue toward savings each payroll
  • save-qtd-fica-released: (DECM) FICA Amount Released
  • save-qtd-fica-saved: (DECM) FICA Amount Saved
  • save-qtd-rate-released: (DECM) QTD Released
  • save-qtd-rate-saved: (DECM) QTD Saved
  • save-qtd-retire-released: (DECM) Amount released from retirement
  • save-qtd-retire-saved: (DECM) Amount saved toward retirement
  • save-release-accrual: (LOGC) Yes to release entire savings accrual this pay
  • save-savings-active: (LOGC) Yes if savings (either saved or released) are active
  • save-ytd-fica-released: (DECM) FICA Amount Released
  • save-ytd-fica-saved: (DECM) FICA Amount Saved
  • save-ytd-rate-released: (DECM) YTD Released
  • save-ytd-rate-saved: (DECM) YTD Saved
  • save-ytd-retire-released: (DECM) Amount released from retirement
  • save-ytd-retire-saved: (DECM) Amount saved toward retirement
  • start-date: (DATE) Initial/starting date of employees use of the payrate
  • status-code: (CHAR) Employee's status code
  • union-member: (LOGC) Does employee belong to a union?
  • ytd-adjust: (DECM) YTD adjustment amounts
  • ytd-extra-hours: (DECM) YTD Extra hours
  • ytd-gross: (DECM) YTD Payrate gross
  • ytd-overtime-hours: (DECM) YTD Overtime hours
  • ytd-regular-hours: (DECM) YTD regular hours
  • ytd-retire-hours: (DECM) YTD retirement hours

    Alphabetical Index Summary

  • comp-code: (PRIMARY) comp-code
  • dept-code: dept-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
  • rate-assignment-code: rate-assignment-code
  • rate-cycle-code: rate-cycle-code
  • rate-name: rate-name
  • rate-num: rate-num
  • rate-schd-level: rate-schd-level
  • rate-schd-name: rate-schd-name
  • rate-schd-step: rate-schd-step
  • rate-start-pay: rate-start-pay
  • rate-stop-pay: rate-stop-pay
  • save-cycle-code: save-cycle-code
  • status-code: status-code

    Tables Payrates references

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

    Detailed Alphabetical Field Listing
    adjust-amount Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)
    Description: Amount of adjustment to apply to payrate for this payroll

    adjust-pay-cnt Data type: INTEGER
    Format: z9 (Initial Value: 0)
    Description: Number of payrolls this adjustment has been active on

    adjust-pay-max Data type: CHARACTER
    Format: x(3)
    Description: Number of payrolls to apply adjustment

    adjust-type Data type: CHARACTER
    Format: x(8)
    Description: Type of adjustment (Normal, Contract, Retro or Backup)

    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

    cont-adjust Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)
    Description: Amount of adjustment applied for this payroll

    cont-extra-hours Data type: DECIMAL (Decimals: 2)
    Format: z,zz9.99 (Initial Value: 0)
    Description: Extra hours for this payroll

    cont-gross Data type: DECIMAL (Decimals: 2)
    Format: zzz,zz9.99 (Initial Value: 0)
    Description: Payrate gross for this payroll

    cont-overtime-hours Data type: DECIMAL (Decimals: 2)
    Format: z,zz9.99 (Initial Value: 0)
    Description: Overtime hours for this payroll

    cont-regular-hours Data type: DECIMAL (Decimals: 2)
    Format: z,zz9.99 (Initial Value: 0)
    Description: Number of regular hours for this payroll

    cont-retire-hours Data type: DECIMAL (Decimals: 2)
    Format: z,zz9.99 (Initial Value: 0)
    Description: Total retirement hours for this payrate and payroll

    cur-adjust Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)
    Description: Amount of adjustment applied for this payroll

    cur-adjust-type Data type: CHARACTER
    Format: x(6)
    Description: Adjustment type as of last calculation

    cur-extra-hours Data type: DECIMAL (Decimals: 2)
    Format: z,zz9.99 (Initial Value: 0)
    Description: Extra hours for this payroll

    cur-gross Data type: DECIMAL (Decimals: 2)
    Format: zzz,zz9.99 (Initial Value: 0)
    Description: Payrate gross for this payroll

    cur-overtime-hours Data type: DECIMAL (Decimals: 2)
    Format: z,zz9.99 (Initial Value: 0)
    Description: Overtime hours for this payroll

    cur-regular-hours Data type: DECIMAL (Decimals: 2)
    Format: z,zz9.99 (Initial Value: 0)
    Description: Number of regular hours for this payroll

    cur-retire-hours Data type: DECIMAL (Decimals: 2)
    Format: z,zz9.99 (Initial Value: 0)
    Description: Total retirement hours for this payrate and payroll

    default-regular-hours Data type: DECIMAL (Decimals: 2)
    Format: zz9.99 (Initial Value: 0)
    Description: Default 'regular' hours for this payrate

    default-retire-hours Data type: DECIMAL (Decimals: 2)
    Format: zz9.99 (Initial Value: 0)
    Description: Default number of retirement hours for this payrate

    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

    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

    exempt-fica Data type: LOGICAL
    Format: Yes/No (Initial Value: no)
    Description: 'Yes' if payrate is exempt from FICA, otherwise 'No'

    exempt-fit Data type: LOGICAL
    Format: Yes/No (Initial Value: no)
    Description: 'Yes' if payrate is exempt from FIT, otherwise 'No'

    exempt-futa Data type: LOGICAL
    Format: Yes/No (Initial Value: no)
    Description: 'Yes' if payrate is exempt from FUTA, otherwise 'No'

    exempt-lit Data type: LOGICAL
    Format: Yes/No (Initial Value: no)
    Description: 'Yes' if payrate is exempt from LIT, otherwise 'No'

    exempt-medicare Data type: LOGICAL
    Format: Yes/No (Initial Value: no)
    Description: 'Yes' if payrate is exempt from Medicare, otherwise 'No'

    exempt-oit Data type: LOGICAL
    Format: Yes/No (Initial Value: no)
    Description: 'Yes' if payrate is exempt from OIT, otherwise 'No'

    exempt-retire Data type: LOGICAL
    Format: Yes/No (Initial Value: no)
    Description: 'Yes' if payrate is exempt from retirement, 'No' otherwise

    exempt-sit Data type: LOGICAL
    Format: Yes/No (Initial Value: no)
    Description: 'Yes' if payrate is exempt from SIT, otherwise 'No'

    exempt-suta Data type: LOGICAL
    Format: Yes/No (Initial Value: no)
    Description: 'Yes' if payrate is exempt from SUTA, otherwise 'No'

    extra-amount Data type: DECIMAL (Decimals: 2)
    Format: zz,zz9.99 (Initial Value: 0)
    Description: Amount calculated amount for the extra hours on this payroll

    extra-hours Data type: DECIMAL (Decimals: 2)
    Format: zz9.99 (Initial Value: 0)
    Description: Extra hours for this payroll

    for-regular-pay Data type: LOGICAL
    Format: Reg/All (Initial Value: no)
    Description: 'Reg' to use only for regular pays, 'All' to use for all pay

    fytd-adjust Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)
    Description: Amount of adjustment applied for this payroll

    fytd-extra-hours Data type: DECIMAL (Decimals: 2)
    Format: z,zz9.99 (Initial Value: 0)
    Description: FYTD Extra hours

    fytd-gross Data type: DECIMAL (Decimals: 2)
    Format: zzz,zz9.99 (Initial Value: 0)
    Description: FYTD Payrate gross

    fytd-overtime-hours Data type: DECIMAL (Decimals: 2)
    Format: z,zz9.99 (Initial Value: 0)
    Description: FYTD Overtime hours

    fytd-regular-hours Data type: DECIMAL (Decimals: 2)
    Format: z,zz9.99 (Initial Value: 0)
    Description: FYTD regular hours

    fytd-retire-hours Data type: DECIMAL (Decimals: 2)
    Format: z,zz9.99 (Initial Value: 0)
    Description: FYTD retirement hours

    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

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

    mtd-extra-hours Data type: DECIMAL (Decimals: 2)
    Format: z,zz9.99 (Initial Value: 0)
    Description: MTD Extra hours

    mtd-gross Data type: DECIMAL (Decimals: 2)
    Format: zzz,zz9.99 (Initial Value: 0)
    Description: MTD Payrate gross

    mtd-overtime-hours Data type: DECIMAL (Decimals: 2)
    Format: z,zz9.99 (Initial Value: 0)
    Description: MTD Overtime hours

    mtd-regular-hours Data type: DECIMAL (Decimals: 2)
    Format: z,zz9.99 (Initial Value: 0)
    Description: MTD regular hours

    mtd-retire-hours Data type: DECIMAL (Decimals: 2)
    Format: z,zz9.99 (Initial Value: 0)
    Description: MTD retirement hours

    overtime-amount Data type: DECIMAL (Decimals: 2)
    Format: zz,zz9.99 (Initial Value: 0)
    Description: Amount calculated for overtime on this payroll

    overtime-hours Data type: DECIMAL (Decimals: 2)
    Format: zz9.99 (Initial Value: 0)
    Description: Overtime hours for this payroll

    pay-over-cnt Data type: INTEGER
    Format: zz9 (Initial Value: 0)
    Description: Number of payrolls to split contract limit over (salaried on

    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

    qtd-adjust Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)
    Description: QTD adjustment amount

    qtd-extra-hours Data type: DECIMAL (Decimals: 2)
    Format: z,zz9.99 (Initial Value: 0)
    Description: QTD Extra hours

    qtd-gross Data type: DECIMAL (Decimals: 2)
    Format: zzz,zz9.99 (Initial Value: 0)
    Description: QTD Payrate gross

    qtd-overtime-hours Data type: DECIMAL (Decimals: 2)
    Format: z,zz9.99 (Initial Value: 0)
    Description: QTD Overtime hours

    qtd-regular-hours Data type: DECIMAL (Decimals: 2)
    Format: z,zz9.99 (Initial Value: 0)
    Description: QTD regular hours

    qtd-retire-hours Data type: DECIMAL (Decimals: 2)
    Format: z,zz9.99 (Initial Value: 0)
    Description: QTDl retirement hours

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

    rate-amount Data type: DECIMAL (Decimals: 2)
    Format: zzz,zz9.99 (Initial Value: 0)
    Description: Hourly wage amount for 'Hourly' rate or per payroll amount f

    rate-assignment-code Data type: CHARACTER
    Format: x(8)
    Description: Name of assignment
    Attributes: Index Component

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

    rate-hourly Data type: LOGICAL
    Format: Hourly/Salary (Initial Value: no)
    Description: 'Hourly' for an hourly based payrate or 'Salary' otherwise

    rate-limit Data type: DECIMAL (Decimals: 2)
    Format: zzz,zz9.99 (Initial Value: 0)
    Description: Payrate/Contract limit

    rate-name Data type: CHARACTER
    Format: x(8)
    Description: Name of payrate
    Attributes: Index Component

    rate-num Data type: INTEGER
    Format: zzz9 (Initial Value: 0)
    Description: Payrate number
    Attributes: Index Component

    rate-primary Data type: LOGICAL
    Format: Yes/No (Initial Value: no)
    Description: 'Yes' if this is considered the 'Primary' payrate

    rate-schd-level Data type: CHARACTER
    Format: x(8)
    Description: Name or label for this step/level
    Attributes: Index Component

    rate-schd-name Data type: CHARACTER
    Format: x(8)
    Description: Name of this payroll contract schedule
    Attributes: Index Component

    rate-schd-step Data type: CHARACTER
    Format: x(8)
    Description: Name or label for this step/level
    Attributes: Index Component

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

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

    rate-type Data type: CHARACTER
    Format: x(6)
    Description: Type of payrate (Normal, Retro or Backup)

    regular-amount Data type: DECIMAL (Decimals: 2)
    Format: zz,zz9.99 (Initial Value: 0)
    Description: Amount calculated for regular hours on this payroll

    regular-hours Data type: DECIMAL (Decimals: 2)
    Format: zz9.99 (Initial Value: 0)
    Description: Number of regular hours for this payroll

    retire-hours Data type: DECIMAL (Decimals: 2)
    Format: zz9.99 (Initial Value: 0)
    Description: Total retirement hours for this payrate and payroll

    save-accrued-fica-released Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)
    Description: FICA Amount Released

    save-accrued-fica-saved Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)
    Description: FICA Amount Saved

    save-accrued-rate-released Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)
    Description: Accrued released

    save-accrued-rate-saved Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)
    Description: Accrued Savings

    save-accrued-retire-released Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)
    Description: Amount released from retirement

    save-accrued-retire-saved Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)
    Description: Amount saved toward retirement

    save-cur-fica-released Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)
    Description: FICA Amount Released

    save-cur-fica-saved Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)
    Description: FICA Amount Saved

    save-cur-rate-released Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)
    Description: Cur Released

    save-cur-rate-saved Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)
    Description: Cur Amount saved

    save-cur-retire-released Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)
    Description: Amount released from retirement

    save-cur-retire-saved Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)
    Description: Amount saved toward retirement

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

    save-fytd-fica-released Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)
    Description: FICA Amount Released

    save-fytd-fica-saved Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)
    Description: FICA Amount Saved

    save-fytd-rate-released Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)
    Description: FYTD Released

    save-fytd-rate-saved Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)
    Description: FYTD Saved

    save-fytd-retire-released Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)
    Description: Amount released from retirement

    save-fytd-retire-saved Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)
    Description: Amount saved toward retirement

    save-mtd-fica-released Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)
    Description: FICA Amount Released

    save-mtd-fica-saved Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)
    Description: FICA Amount Saved

    save-mtd-rate-released Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)
    Description: MTD Released

    save-mtd-rate-saved Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)
    Description: MTD Saved

    save-mtd-retire-released Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)
    Description: Amount released from retirement

    save-mtd-retire-saved Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)
    Description: Amount saved toward retirement

    save-per-payroll-amount Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)
    Description: Amount to accrue toward savings each payroll

    save-qtd-fica-released Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)
    Description: FICA Amount Released

    save-qtd-fica-saved Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)
    Description: FICA Amount Saved

    save-qtd-rate-released Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)
    Description: QTD Released

    save-qtd-rate-saved Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)
    Description: QTD Saved

    save-qtd-retire-released Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)
    Description: Amount released from retirement

    save-qtd-retire-saved Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)
    Description: Amount saved toward retirement

    save-release-accrual Data type: LOGICAL
    Format: Yes/No (Initial Value: no)
    Description: Yes to release entire savings accrual this pay

    save-savings-active Data type: LOGICAL
    Format: Yes/No (Initial Value: no)
    Description: Yes if savings (either saved or released) are active

    save-ytd-fica-released Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)
    Description: FICA Amount Released

    save-ytd-fica-saved Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)
    Description: FICA Amount Saved

    save-ytd-rate-released Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)
    Description: YTD Released

    save-ytd-rate-saved Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)
    Description: YTD Saved

    save-ytd-retire-released Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)
    Description: Amount released from retirement

    save-ytd-retire-saved Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)
    Description: Amount saved toward retirement

    start-date Data type: DATE
    Format: 99/99/9999
    Description: Initial/starting date of employees use of the payrate

    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?

    ytd-adjust Data type: DECIMAL (Decimals: 2)
    Format: -zzz,zz9.99 (Initial Value: 0)
    Description: YTD adjustment amounts

    ytd-extra-hours Data type: DECIMAL (Decimals: 2)
    Format: z,zz9.99 (Initial Value: 0)
    Description: YTD Extra hours

    ytd-gross Data type: DECIMAL (Decimals: 2)
    Format: zzz,zz9.99 (Initial Value: 0)
    Description: YTD Payrate gross

    ytd-overtime-hours Data type: DECIMAL (Decimals: 2)
    Format: z,zz9.99 (Initial Value: 0)
    Description: YTD Overtime hours

    ytd-regular-hours Data type: DECIMAL (Decimals: 2)
    Format: z,zz9.99 (Initial Value: 0)
    Description: YTD regular hours

    ytd-retire-hours Data type: DECIMAL (Decimals: 2)
    Format: z,zz9.99 (Initial Value: 0)
    Description: YTD retirement hours

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