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 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