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 |