Definition of table Quarter-Retire

Quarterly Retirement Records , Table Dump Name res-0018

Alphabetical Field Summary

calendar-year: (INTG) Calendar year associated with this record

comment: (CHAR) Any comments regarding this quarter (this is not reported)

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

div-code: (INTG) Employee's assigned division

div-code-description: (CHAR) A brief description of the division's purpose

ecc-code: (CHAR) ECC Code

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

exception-amount: (DECM) Total exceptions amount for this quarter (if any)

federal-basic: (DECM) Federal Basic Retirement amount for this quarter

federal-gross: (DECM) Retirement gross federal basic is calculated on

gross-amount: (DECM) Total Gross for employee for this quarter

hire-date: (DATE) Date employee hired (blank if not reporting this quarter)

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

pay-rate: (DECM) Employees hourly rate or salary

prior-period: (LOGC) 'Yes' if quarterly info includes prior quarter figures

qtr-num: (INTG) Quarter of calendar year this record records

retire-amount: (DECM) Retirement Plan (MIP) Amount for this quarter

retire-code: (CHAR) Retirement code name

retire-hours: (DECM) Total retirement hours for this quarter

state-basic: (DECM) State Basic Retirement amount for this quarter

state-gross: (DECM) Retirement Gross state basic is calculated on

status-code: (CHAR) Employee's status code

term-code: (INTG) Termination code, if terminated this quarter

term-date: (DATE) Date employee terminated employment (if in this quarter)

union-member: (LOGC) Does employee belong to a union?

Alphabetical Index Summary

calendar-year: (PRIMARY) calendar-year

comp-code: comp-code

dept-code: dept-code

div-code: div-code

ecc-code: ecc-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

qtr-num: qtr-num

retire-code: retire-code

status-code: status-code

Tables Quarter-Retire 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

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
calendar-year Data type: INTEGER
Format: 9999 (Initial Value: 0)
Description: Calendar year associated with this record
Attributes: Index Component

comment Data type: CHARACTER
Format: x(40)
Description: Any comments regarding this quarter (this is not reported)

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

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

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

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

exception-amount Data type: DECIMAL (Decimals: 2)
Format: -zzz,zz9.99 (Initial Value: 0)
Description: Total exceptions amount for this quarter (if any)

federal-basic Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Description: Federal Basic Retirement amount for this quarter

federal-gross Data type: DECIMAL (Decimals: 2)
Format: -zzz,zz9.99 (Initial Value: 0)
Description: Retirement gross federal basic is calculated on

gross-amount Data type: DECIMAL (Decimals: 2)
Format: -zzz,zz9.99 (Initial Value: 0)
Description: Total Gross for employee for this quarter

hire-date Data type: DATE
Format: 99/99/9999
Description: Date employee hired (blank if not reporting this quarter)

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

pay-rate Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Description: Employees hourly rate or salary

prior-period Data type: LOGICAL
Format: Yes/No (Initial Value: no)
Description: 'Yes' if quarterly info includes prior quarter figures

qtr-num Data type: INTEGER
Format: 9 (Initial Value: 0)
Description: Quarter of calendar year this record records
Attributes: Index Component

retire-amount Data type: DECIMAL (Decimals: 2)
Format: -zzz,zz9.99 (Initial Value: 0)
Description: Retirement Plan (MIP) Amount for this quarter

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

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

state-basic Data type: DECIMAL (Decimals: 2)
Format: zzz,zz9.99 (Initial Value: 0)
Description: State Basic Retirement amount for this quarter

state-gross Data type: DECIMAL (Decimals: 2)
Format: -zzz,zz9.99 (Initial Value: 0)
Description: Retirement Gross state basic is calculated on

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

term-code Data type: INTEGER
Format: 99 (Initial Value: 0)
Description: Termination code, if terminated this quarter

term-date Data type: DATE
Format: 99/99/9999
Description: Date employee terminated employment (if in this quarter)

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