Table: dbo.Csa_Staff_Map_To_Acs_Staff
This table stores the staff Id/staff name mappings for CSA staff.
Columns
NameTypeConstraintsDescription
csa_staff_map_to_acs_staff_KEYint (4)NOT NULLPrimary Key for this table.
staff_idnvarchar (20)NOT NULLStaff id from csa.
first_namenvarchar (40)NOT NULLFirst name of the csa staff.
last_namenvarchar (60)NOT NULLLast name of the csa staff.
staff_KEYint (4)NOT NULLACS staff key
Primary key
NameColumnsDescription
PK_Csa_Staff_Map_To_Acs_Staffcsa_staff_map_to_acs_staff_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Csa_Staff_Map_To_Acs_Staff__Staff__staff_KEYstaff_KEYStaff (staff_KEY)

Schema diagram