| Table: dbo.Csa_Staff_Map_To_Acs_Staff | |||
| This table stores the staff Id/staff name mappings for CSA staff. | |||
| Columns | |||
| Name | Type | Constraints | Description |
| csa_staff_map_to_acs_staff_KEY | int (4) | NOT NULL | Primary Key for this table. |
| staff_id | nvarchar (20) | NOT NULL | Staff id from csa. |
| first_name | nvarchar (40) | NOT NULL | First name of the csa staff. |
| last_name | nvarchar (60) | NOT NULL | Last name of the csa staff. |
| staff_KEY | int (4) | NOT NULL | ACS staff key |
| Primary key | |||
| Name | Columns | Description | |
| PK_Csa_Staff_Map_To_Acs_Staff | csa_staff_map_to_acs_staff_KEY | ||
| Foreign keys | |||
| Name | Columns | Referenced table | Description |
| FK_Csa_Staff_Map_To_Acs_Staff__Staff__staff_KEY | staff_KEY | Staff (staff_KEY) | |