I have some data that is populated every two weeks. Each employee who falls into this catagory needs to have a specific ID assigned to them. The ID must state the location they work, the year of the transaction, the first 3 letters of the last name, and the last four of their SSN. See the data...