Help

Data Flow for Personal Information

Modified: 9 Oct 2026 Viewpoint HR Management for Spectrum Administration Human Resources HR and Employee Help

The following tables illustrate how data for Personal Information fields flows between HR Management and Spectrum.

Employee Name Fields

Note: The Personal Pronouns and Preferred Name fields are saved to HR Management only and do not currently sync back to Spectrum.
Spectrum Field Spectrum Table Spectrum Database Field Data Flow Employee Self-Service Field Employee Self-Service Database Field
First Name PR_EMPLOYEE_MASTER_3_MC Legal_First_Name First Name FirstName
Middle PR_EMPLOYEE_MASTER_3_MC Legal_Middle_Name Middle Name MiddleName
Last Name PR_EMPLOYEE_MASTER_3_MC Legal_Last_Name Last Name LastName
Suffix PR_EMPLOYEE_MASTER_3_MC Legal_Suffix Suffix Suffix

Phone and Email Fields

Spectrum Field Spectrum Table Spectrum Database Field Data Flow Employee Self-Service Field Employee Self-Service Database Field
Personal Phone PR_EMPLOYEE_MASTER_1_MC Phone Home Phone PersonalPhoneNumber
Personal Email PR_EMPLOYEE_MASTER_3_MC Employee_Personal_ Email Personal Email Address PersonalEmailAddress
Work Mobile Phone PR_EMPLOYEE_MASTER_3_MC / PA_PHONE_MASTER Employee_Mobile_Phone / Phone_Number Work Mobile Phone OfficePhoneNumber
Work Extension PR_EMPLOYEE_MASTER_3_MC / PA_PHONE_MASTER Employee_Extension / Phone_Ext Work Extension OfficePhoneNumberExtension
Work Email PR_EMPLOYEE_MASTER_3_MC Employee_Email Work Email Address WorkEmailAddress

Address Fields

Spectrum Field Spectrum Table Spectrum Database Field Data Flow Employee Self-Service Field Employee Self-Service Database Field
Mailing Address
Address 1 PR_EMPLOYEE_MASTER_1_MC Street_Address Address 1 MailingAddress1
Address 2 PR_EMPLOYEE_MASTER_1_MC Street_Address2 Address 2 MailingAddress2
City PR_EMPLOYEE_MASTER_1_MC Address City MailingCity
State / Province PR_EMPLOYEE_MASTER_1_MC State State / Province MailingState
Postal Code PR_EMPLOYEE_MASTER_1_MC Zip_Code Zip Code MailingZipCode
Spectrum Field Spectrum Table Spectrum Database Field Data Flow Employee Self-Service Field Employee Self-Service Database Field
Home Address
Address 1 PR_EMPLOYEE_MASTER_1_MC Domicile_Address Address 1 HomeAddress1
Address 2 PR_EMPLOYEE_MASTER_1_MC Domicile_Address2 Address 2 HomeAddress2
City PR_EMPLOYEE_MASTER_1_MC Domicile_City City HomeCity
State / Province PR_EMPLOYEE_MASTER_1_MC Domicile_State State / Province HomeState
Postal Code PR_EMPLOYEE_MASTER_1_MC Domicile_Zip_Code Zip Code HomeZipCode

Emergency Contact Fields

Spectrum Field Spectrum Table Spectrum Database Field Data Flow Employee Self-Service Field Employee Self-Service Database Field
Contact PR_EMPLOYEE_MASTER_1_MC Emergency_Contact Contact Name EmergencyContact
Telephone PR_EMPLOYEE_MASTER_1_MC Emergency_Phone Telephone Number EmergencyPhone
Relation PR_EMPLOYEE_MASTER_1_MC Emergency_Relationship Relation EmergencyRelationship

Direct Deposit Fields

Spectrum Field Spectrum Table Spectrum Database Field Data Flow Employee Self-Service Field Employee Self-Service Database Field
Allocation Method: Percent or Fixed amount PR_EMPLOYEE_MASTER_1_MC Auto_Deposit_Allocation Allocation Method AutoDepositAllocation
Spectrum Field Spectrum Table Spectrum Database Field Data Flow Employee Self-Service Field Employee Self-Service Database Field
Bank Account - Priority 1
Bank Account Code PR_EMPLOYEE_MASTER_1_MC Bank_Account_Number / Encrypted_Bank_Account_Number Account Number BankAccountNumber1
Account Type PR_EMPLOYEE_MASTER_1_MC Bank_Account_Type Type of Account BankAccountType1
ABA # PR_EMPLOYEE_MASTER_1_MC ABA_Number Routing Number AbaNumber1
Status PR_EMPLOYEE_MASTER_1_MC Auto_Deposit_Flag Status AutoDepositStatus1
Rate PR_EMPLOYEE_MASTER_1_MC Auto_Deposit_Rate1 Amount AutoDepositRate1
Spectrum Field Spectrum Table Spectrum Database Field Data Flow Employee Self-Service Field Employee Self-Service Database Field
Bank Account - Priority 2
Bank Account Code PR_EMPLOYEE_MASTER_1_MC Bank_Account_Number_2 / Encrypted_Bank_Account_Number_2 Account Number BankAccountNumber2
Account Type PR_EMPLOYEE_MASTER_1_MC Bank_Account_Type_2 Type of Account BankAccountType2
ABA # PR_EMPLOYEE_MASTER_1_MC ABA_Number_2 Routing Number AbaNumber2
Status PR_EMPLOYEE_MASTER_1_MC Auto_Deposit_Flag_2 Status AutoDepositStatus2
Rate PR_EMPLOYEE_MASTER_1_MC Auto_Deposit_Rate2 Amount AutoDepositRate2
Spectrum Field Spectrum Table Spectrum Database Field Data Flow Employee Self-Service Field Employee Self-Service Database Field
Bank Account - Priority 3
Bank Account Code PR_EMPLOYEE_MASTER_1_MC Bank_Account_Number_3 / Encrypted_Bank_Account_Number_3 Account Number BankAccountNumber3
Account Type PR_EMPLOYEE_MASTER_1_MC Bank_Account_Type_3 Type of Account BankAccountType3
ABA # PR_EMPLOYEE_MASTER_1_MC ABA_Number_3 Routing Number AbaNumber3
Status PR_EMPLOYEE_MASTER_1_MC Auto_Deposit_Flag_3 Status AutoDepositStatus3
Rate PR_EMPLOYEE_MASTER_1_MC Auto_Deposit_Rate3 Amount AutoDepositRate3
Spectrum Field Spectrum Table Spectrum Database Field Data Flow Employee Self-Service Field Employee Self-Service Database Field
Bank Account - Priority 4
Bank Account Code PR_EMPLOYEE_MASTER_1_MC Bank_Account_Number_4 / Encrypted_Bank_Account_Number_4 Account Number BankAccountNumber4
Account Type PR_EMPLOYEE_MASTER_1_MC Bank_Account_Type_4 Type of Account BankAccountType4
ABA # PR_EMPLOYEE_MASTER_1_MC ABA_Number_4 Routing Number AbaNumber4
Status PR_EMPLOYEE_MASTER_1_MC Auto_Deposit_Flag_4 Status AutoDepositStatus4
Rate PR_EMPLOYEE_MASTER_1_MC Auto_Deposit_Rate4 Amount AutoDepositRate4
Spectrum Field Spectrum Table Spectrum Database Field Data Flow Employee Self-Service Field Employee Self-Service Database Field
Bank Account - Priority 5
Bank Account Code PR_EMPLOYEE_MASTER_1_MC Bank_Account_Number_5 / Encrypted_Bank_Account_Number_5 Account Number BankAccountNumber5
Account Type PR_EMPLOYEE_MASTER_1_MC Bank_Account_Type_5 Type of Account BankAccountType5
ABA # PR_EMPLOYEE_MASTER_1_MC ABA_Number_5 Routing Number AbaNumber5
Status PR_EMPLOYEE_MASTER_1_MC Auto_Deposit_Flag_5 Status AutoDepositStatus5
Rate PR_EMPLOYEE_MASTER_1_MC Auto_Deposit_Rate5 Amount AutoDepositRate5
Submit
Previous
Next