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 |