Data Flow for Personal Information

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

Employee Name Fields

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