Table: dbo.XactPay_Employee_SSN_History
Table containing the SSN history for XactPay employees
Columns
NameTypeConstraintsDescription
xactpay_employee_ssn_history_KEYint (4)NOT NULLPrimary key for this table.
employee_KEYint (4)NOT NULLThe associated employee.
modified_datedatetime (8, 3)NOT NULLThe date the SSN was changed.
previous_SSNnvarchar (22)NOT NULLThe previous SSN value before the change.
transmittedbit (1)NOT NULLWhether or not this change has been transmitted to XactPay
Primary key
NameColumnsDescription
PK_XactPay_Employee_SSN_Historyxactpay_employee_ssn_history_KEY
Unique constraints
NameColumnsDescription
UK_XactPay_Employee_SSN_History$employee_KEY$modified_date$previous_SSNemployee_KEY, modified_date, previous_SSN
Foreign keys
NameColumnsReferenced tableDescription
FK_XactPay_Employee_SSN_History__Employee__employee_KEYemployee_KEYEmployee (employee_KEY)

Schema diagram