The following tables illustrate how data for Personal Information fields flows between Employee Self-Service and Spectrum.

Spectrum Field	Spectrum Table	Spectrum Database Field	Data Flow	HRIS Field	HRIS 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	HRIS Field	HRIS 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 Database Field	Spectrum Table	Data Flow	HRIS Field	HRIS Database Field
Mailing Address
Address 1	Street_Address	PR_EMPLOYEE_MASTER_1_MC		Address 1	MailingAddress1
Address 2	Street_Address2	PR_EMPLOYEE_MASTER_1_MC		Address 2	MailingAddress2
City	Address	PR_EMPLOYEE_MASTER_1_MC		City	MailingCity
State / Province	State	PR_EMPLOYEE_MASTER_1_MC		State / Province	MailingState
Postal Code	Zip_Code	PR_EMPLOYEE_MASTER_1_MC		Zip Code	MailingZipCode

Spectrum Field	Spectrum Database Field	Spectrum Table	Data Flow	HRIS Field	HRIS Database Field
Home Address
Address 1	Domicile_Address	PR_EMPLOYEE_MASTER_1_MC		Address 1	HomeAddress1
Address 2	Domicile_Address2	PR_EMPLOYEE_MASTER_1_MC		Address 2	HomeAddress2
City	Domicile_City	PR_EMPLOYEE_MASTER_1_MC		City	HomeCity
State / Province	Domicile_State	PR_EMPLOYEE_MASTER_1_MC		State / Province	HomeState
Postal Code	Domicile_Zip_Code	PR_EMPLOYEE_MASTER_1_MC		Zip Code	HomeZipCode

Emergency Contact Fields

Spectrum Field	Spectrum Database Field	Spectrum Table	Data Flow	HRIS Field	HRIS Database Field
Contact	Emergency_Contact	PR_EMPLOYEE_MASTER_1_MC		Contact Name	EmergencyContact
Telephone	Emergency_Phone	PR_EMPLOYEE_MASTER_1_MC		Telephone Number	EmergencyPhone
Relation	Emergency_Relationship	PR_EMPLOYEE_MASTER_1_MC		Relation	EmergencyRelationship

Direct Deposit Fields

Spectrum Field	Spectrum Database Field	Spectrum Table	Data Flow	HRIS Field	HRIS Database Field
Allocation Method: Percent or Fixed amount	Auto_Deposit_Allocation	PR_EMPLOYEE_MASTER_1_MC		Allocation Method	AutoDepositAllocation

Spectrum Field	Spectrum Database Field	Spectrum Table	Data Flow	HRIS Field	HRIS Database Field
Bank Account - Priority 1
Bank Account Code	Bank_Account_Number / Encrypted_Bank_Account_Number	PR_EMPLOYEE_MASTER_1_MC		Account Number	BankAccountNumber1
Account Type	Bank_Account_Type	PR_EMPLOYEE_MASTER_1_MC		Type of Account	BankAccountType1
ABA #	ABA_Number	PR_EMPLOYEE_MASTER_1_MC		Routing Number	AbaNumber1
Status	Auto_Deposit_Flag	PR_EMPLOYEE_MASTER_1_MC		Status	AutoDepositStatus1
Rate	Auto_Deposit_Rate1	PR_EMPLOYEE_MASTER_1_MC		Amount	AutoDepositRate1

Spectrum Field	Spectrum Database Field	Spectrum Table	Data Flow	HRIS Field	HRIS Database Field
Bank Account - Priority 2
Bank Account Code	Bank_Account_Number_2 / Encrypted_Bank_Account_Number_2	PR_EMPLOYEE_MASTER_1_MC		Account Number	BankAccountNumber2
Account Type	Bank_Account_Type_2	PR_EMPLOYEE_MASTER_1_MC		Type of Account	BankAccountType2
ABA #	ABA_Number_2	PR_EMPLOYEE_MASTER_1_MC		Routing Number	AbaNumber2
Status	Auto_Deposit_Flag_2	PR_EMPLOYEE_MASTER_1_MC		Status	AutoDepositStatus2
Rate	Auto_Deposit_Rate2	PR_EMPLOYEE_MASTER_1_MC		Amount	AutoDepositRate2

Spectrum Field	Spectrum Database Field	Spectrum Table	Data Flow	HRIS Field	HRIS Database Field
Bank Account - Priority 3
Bank Account Code	Bank_Account_Number_3 / Encrypted_Bank_Account_Number_3	PR_EMPLOYEE_MASTER_1_MC		Account Number	BankAccountNumber3
Account Type	Bank_Account_Type_3	PR_EMPLOYEE_MASTER_1_MC		Type of Account	BankAccountType3
ABA #	ABA_Number_3	PR_EMPLOYEE_MASTER_1_MC		Routing Number	AbaNumber3
Status	Auto_Deposit_Flag_3	PR_EMPLOYEE_MASTER_1_MC		Status	AutoDepositStatus3
Rate	Auto_Deposit_Rate3	PR_EMPLOYEE_MASTER_1_MC		Amount	AutoDepositRate3

Spectrum Field	Spectrum Database Field	Spectrum Table	Data Flow	HRIS Field	HRIS Database Field
Bank Account - Priority 4
Bank Account Code	Bank_Account_Number_4 / Encrypted_Bank_Account_Number_4	PR_EMPLOYEE_MASTER_1_MC		Account Number	BankAccountNumber4
Account Type	Bank_Account_Type_4	PR_EMPLOYEE_MASTER_1_MC		Type of Account	BankAccountType4
ABA #	ABA_Number_4	PR_EMPLOYEE_MASTER_1_MC		Routing Number	AbaNumber4
Status	Auto_Deposit_Flag_4	PR_EMPLOYEE_MASTER_1_MC		Status	AutoDepositStatus4
Rate	Auto_Deposit_Rate4	PR_EMPLOYEE_MASTER_1_MC		Amount	AutoDepositRate4

Spectrum Field	Spectrum Database Field	Spectrum Table	Data Flow	HRIS Field	HRIS Database Field
Bank Account - Priority 5
Bank Account Code	Bank_Account_Number_5 / Encrypted_Bank_Account_Number_5	PR_EMPLOYEE_MASTER_1_MC		Account Number	BankAccountNumber5
Account Type	Bank_Account_Type_5	PR_EMPLOYEE_MASTER_1_MC		Type of Account	BankAccountType5
ABA #	ABA_Number_5	PR_EMPLOYEE_MASTER_1_MC		Routing Number	AbaNumber5
Status	Auto_Deposit_Flag_5	PR_EMPLOYEE_MASTER_1_MC		Status	AutoDepositStatus5
Rate	Auto_Deposit_Rate5	PR_EMPLOYEE_MASTER_1_MC		Amount	AutoDepositRate5