|
|
|
|
|
|
|
Contents
|
The following fields are accessed in the transmittal report. The transmittal file includes the same fields, with the exception of System Codes and Plan Codes, listed below in bold type:
|
Field Name |
Path to data field |
Table/ Field ID |
|
DRS Summary |
||
|
Record Type Identifier |
Viewable in the report |
Value = "S": WA001DRSSummary.RecordType |
|
Reporting Group Number |
Human Resources / Setup / Codes / Payroll / WESPaC Retirement / Retirement System Group Numbers |
WA001DRSSummary.RetSystemGroupNumber |
|
Reporting Period |
Human Resources / Payroll / Reporting / Retirement / DRS Transmittal File / Run |
WA001DRSSummary.ReportPeriod |
|
Report Type |
WA001DRSSummary.ReportType |
|
|
Report Version Number |
WA001DRSSummary.ReportVersion |
|
|
Expected Monthly Reports |
WA001DRSSummary.ExpMthReports |
|
|
Total Compensation |
Viewable in the report
|
WA001DRSSummary.TotalEmployeeComp |
|
Total Member Contributions |
WA001DRSSummary.TotalEmployeeContribution |
|
|
Total Employer Contributions |
WA001DRSSummary.TotalEmployerContributions |
|
|
Total Hours Reported |
WA001DRSSummary.TotalHours |
|
|
Total Records Reported |
WA001DRSSummary.TotalRecords |
|
|
Total Days Reported |
WA001DRSSummary.TotalDays |
|
|
System Code |
Included in transmittal report only: Human Resources / Profile / |
WA001RetSystem.RetSystemCode |
|
Plan Code |
WA001RetSystemPlan.RetPlan |
|
|
DRS Member: |
||
|
Record Type Identifier |
Viewable in the report |
Value = "M": WA001DRSMember.RecordType |
|
Reporting Group Number |
Human Resources / Setup / Codes / Payroll / WESPaC Retirement / Retirement System Group Numbers |
WA001DRSMember.RetSystemGroupNumber |
|
Reporting Period |
Human Resources / Payroll / Reporting / Retirement / DRS Transmittal File / Run |
WA001DRSMember.ReportPeriod |
|
Report Type |
WA001DRSMember.RetReportType |
|
|
Report Version Number |
WA001DRSMember.ReportVersion |
|
|
Social Security Number |
Human Resources / Profile / Personnel tab / Edit |
WA001DRSMember.Federal-ID-No |
|
Member Name Change Flag |
|
WA001DRSMember.NameChange |
|
Member Name |
Human Resources / Profile / Personnel tab / Edit |
WA001DRSMember.Last-Name WA001DRSMember.Name.First-Name WA001DRSMember.Middle-Name |
|
Name Extension |
Not used |
|
|
Name Title |
Human Resources / Profile / Personnel tab / Edit |
WA001DRSMember..Salutation-ID |
|
Name Suffix |
WA001DRSMember.Suffix-ID |
|
|
Address Change Flag |
|
Value = "Y": WA001DRSMember.AddressChange |
|
Address |
Human Resources / Profile / Personnel tab / Edit |
Various |
|
Gender |
WA001DRSMember.Gender
|
|
|
Birth Date |
WA001DRSMember.Birthdate |
|
|
System Code |
Included in transmittal report only: Human Resources / Profile / |
WA001RetMember.RetSystemCode |
|
Plan Code |
WA001RetMember.RetPlan |
|
|
Employment Record: |
||
|
Record Type Identifier |
Viewable in the report |
Value = "E": WA001DRSEmployment.RecordType |
|
Reporting Group Number |
Human Resources / Setup / Codes / Payroll / WESPaC Retirement / Retirement System Group Numbers |
WA001DRSEmployment.RetSystemGroupNumber |
|
Reporting Period |
Human Resources / Payroll / Reporting / Retirement / DRS Transmittal File / Run |
WA001DRSEmployment.ReportPeriod |
|
Report Type |
WA001DRSEmployment.ReportType |
|
|
Report Version No. |
WA001DRSEmployment.ReportVersion |
|
|
Social Security No. |
Human Resources / Profile / Personnel tab / Edit |
WA001DRSEmployment.Federal-ID-No |
|
Retirement System Code |
Human Resources / Profile /
|
WA001DRSEmployment.RetSystemCode |
|
Retirement Plan |
WA001DRSEmployment.RetPlan |
|
|
Retirement Type Code |
WA001DRSEmployment.RetTypeCode |
|
|
Eligibility Start Date |
WA001DRSEmployment.EligibilityStartDate |
|
|
Eligibility End Date |
WA001DRSEmployment.EligibilityEndDate |
|
|
Disability/Leave Start Date |
Viewable in the report |
Blank |
|
Disability/Leave End Date |
Blank |
|
|
Control Number |
Value = either employee's Check Location (HAAPRO-PROFILE.HPADCL-CHK-LOC-CODE) or Building Code (HAAPRO-PROFILE.HAABLD-BLD-CODE) |
|
|
Organization Display |
Human Resources / Profile / Reports / Retirement /Create DRS Transmittal |
Description associated with Control Number: WA001DRSEmployment.OrgDisplay |
|
Defined Benefit Transaction: |
||
|
Record Type Identifier |
Viewable in the report |
Value = "B": WA001DRSBenefit.RecordType |
|
Reporting Group Number |
Human Resources / Setup / Codes / Payroll / WESPaC Retirement / Retirement System Group Numbers |
WA001RetSystem.RetSystemGroupNumber |
|
Reporting Period |
Viewable in the report |
WA001DRSBenefit.ReportPeriod |
|
Report Type |
WA001DRSBenefit.ReportType |
|
|
Report Version Number |
WA001DRSBenefit.ReportVersion |
|
|
Social Security Number |
Human Resources / Profile / Personnel tab / Edit |
WA001DRSBenefit.Name.Federal-ID-No |
|
System Code |
Human Resources / Profile / |
WA001DRSBenefit.RetSystemCode |
|
Plan Code |
WA001DRSBenefit.RetPlan |
|
|
Type Code |
WA001DRSBenefit.RetTypeCode |
|
|
Earning Period |
Viewable in this report and the Retirement Activity Report |
WA001DRSBenefit.EarnPrd |
|
Status Code |
WA001DRSBenefit.RetStatusCode |
|
|
Employee Compensation |
WA001DRSBenefit.Employee Compensation |
|
|
Defined Member Contributions |
WA001DRSBenefit.Employee Contribution |
|
|
Employer Contributions |
WA001DRSBenefit.EmployerContribution |
|
|
Hours |
WA001DRSBenefit.Hours |
|
|
Days |
WA001DRSBenefit.Days |
|
|
Defined Contribution: |
||
|
Record Type Identifier |
Viewable in the report |
Value = "C": WA001DRSContributions.RecordType |
|
Reporting Group Number |
Human Resources / Setup / Codes / Payroll / WESPaC Retirement / Retirement System Group Numbers |
WA001DRSContributions.ReSysGroupNumber |
|
Reporting Period |
Human Resources / Payroll / Reporting / Retirement / DRS Transmittal File / Run |
WA001DRSContributions.ReportPeriod |
|
Report Type |
WA001DRSContributions.ReportType |
|
|
Report Version Number |
WA001DRSContributions.ReportVersion |
|
|
Social Security Number |
Human Resources / Profile / Personnel tab / Edit |
WA001DRSContributions.Federal-ID-No |
|
Retirement System Code |
Human Resources / Profile / |
WA001DRSContributions.RetSystemCode |
|
Defined Contribution |
Viewable in this report and the Retirement Activity Report |
WA001DRSContributions.Employee Contributions |
|
Taxed? |
Default answer is "No" |
WA001DRSContributions.Taxed |
|
Investment Manager |
Human Resources / Profile / |
WA001DRSContributions.RetInvMgrCode |
|
Rate Option Code |
WA001DRSContributions.RteOptionCode |
|
|
Plan Code |
Included in transmittal report only: Human Resources / Profile / |
WA001RetMember.RetPlan |
|
Plan Choice Record: |
||
|
Record Type Identifier
|
Viewable in the report |
Value = "T": WA001DRSPlanChoice.RecordType |
|
Reporting Group Number |
Human Resources / Setup / Codes / Payroll / WESPaC Retirement / Retirement System Group Numbers |
WA001DRSPlanChoice.RetSysGroupNumber |
|
Reporting Period |
Human Resources / Payroll / Reporting / Retirement / DRS Transmittal File / Run |
WA001DRSPlanChoice.ReportPeriod |
|
Report Type |
WA001DRSPlanChoice.ReportType |
|
|
Report Version Number |
WA001DRSPlanChoice.ReportVersion |
|
|
Social Security Number |
Human Resources / Profile / + Add or Edit |
WA001DRSPlanChoice.Federal-ID-No |
|
System Code |
Human Resources / Profile / |
WA001DRSPlanChoice.RetSystemCode |
|
Choice Date |
WA001DRSPlanChoice.ChoiceDate |
|
|
Plan Choice |
WA001DRSPlanChoice.ChoiceCode |
|
|
Plan Code |
Included in transmittal report only: Human Resources / Profile / |
WA001RetMember.RetPlan |
Page Updated 1/04
/