Table: dbo.Client_Staff_Intercept_Credentials
Table for InterceptEFT credentials for client staff.
Columns
NameTypeConstraintsDescription
staff_KEYint (4)NOT NULLKey to staff owning these credetials.
intercept_loginnvarchar (50)NOT NULLLogin for InterceptEFT
intercept_pinnvarchar (50)NOT NULLPIN for InterceptEFT
intercept_multifactor_authorizationnvarchar (100)NOT NULLMultifactor authorization for InterceptEFT
encrypted_intercept_passwordnvarchar (-1)NOT NULLA field to store the encrypted password for National Payment Corporation authentication.
Primary key
NameColumnsDescription
PK_Client_Staff_Intercept_Credentials$staff_KEYstaff_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Client_Staff_Intercept_Credentials__Staff__staff_KEYstaff_KEYStaff (staff_KEY)

Schema diagram