The following tables illustrate how data for Personal Information fields flows between HR Management and 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