Related Topics

Retirement History Report

Contents

1 Overview

2 Sample Reports

3 How-to

4 Fields

 

4 Fields

The following fields are used in the DRS transmittal file:

Field Name

Path to data field

Table/ field ID

DRS Member:

Member ID

Human Resources / Profile / Personnel tab / Edit

WA001DRSMember.Federal-ID

Member Name

WA001DRSMember.Last-Name

WA001DRSMember.First-Name

WA001DRSMember.Middle-Name

Member Address

Various

Member Title

WA001DRSMember.Salutation-ID

Social Security Number

WA001DRSMember.Federal-ID-No

Suffix ID (Jr., Sr., & etc.)

WA001DRSMember.Suffix-ID

Birth Date

WA001DRSMember.Birthdate

Gender

WA001DRSMember.Gender

Employment Record:

Retirement System Code

Human Resources / Profile / / Retirement / Membership

WA001DRSEmployment.RetSystemCode

Retirement Plan

WA001DRSEmployment.RetPlan

Retirement Type Code

WA001DRSEmploymentRetTypeCode

Eligibility Start Date

WA001DRSEmployment.EligibilityStartDate

Eligibility End Date

WA001DRSEmployment.EligibilityEndDate

Control Number

Human Resources / Profile / Reports / Retirement / Create DRS Transmittal

 

WA001DRSEmployment.ControlNumber

Organization Display

WA001DRSEmployment.OrgDisplay

Report Period

WA001DRSEmployment.ReportPeriod

Defined Benefit Record:

Retirement System Code

Human Resources / Profile / Reports / Retirement / Create DRS Transmittal

WA001DRSDefBenefit.RetSystemCode

Retirement Plan Code

WA001DRSDefBenefit.RetPlanCode

Retirement Type Code

WA001DRSDefBenefit.RetTypeCode

Pay Code

WA001RetTransactions.MiscChar

Report Period

WA001DRSDefBenefit.ReportPeriod

Retirement Status Code

Human Resources / Setup / Codes / Payroll / Pay Codes

WA001DRSDefBenefit.RetStatusCode

Compensation

Calculated data

WA001DRSDefBenefit.EmployeeCompensation

Employee Contribution

Calculated data

WA001DRSDefBenefit.EmployeeContribution

Employer Contribution

Calculated data

WA001DRSDefBenefit.EmployerContribution

Hours

Calculated data

WA001DRSDefBenefit.Hours

Days

Calculated data

WA001DRSDefBenefit.Days

‘*’ Adjustments

Indicates an adjustment exists in the total that was not reported to DRS through the transmittal process.

WA001RetTransactions.MiscLogical

Defined Contribution:

Retirement System Code

Human Resources / Profile / / Retirement / Membership

WA001DRSContributions.RetSystemCode

Taxed?

Default answer is "No"

WA001DRSContributions.Taxed

Investment Manager

Human Resources / Profile / / Retirement / Membership

WA001DRSContributions.RetInvMgrCode

Rate Option Code

WA001DRSContributions.RetOptionCode

Report Period

Human Resources / Profile / Reports / Retirement / Create DRS Transmittal

WA001DRSContributions.ReportPeriod

Plan Choice Record:

Retirement System Code

Human Resources / Profile / / Retirement / Membership

WA001DRSPlanChoice.RetSystemCode

Retirement Choice Date

WA001DRSPlanChoice.RetChoiceDate

Retirement Choice Code

WA001DRSPlanChoice.RetChoiceCode

Page Updated 8/09

Top