TE A-16_Employee Log.xlsx

This is an Employee Log template designed to track personnel assigned to a base operations contract at USAG Stuttgart. The spreadsheet is structured to document employee information including status (onboard or terminated), company affiliation (prime contractor or subcontractor), position title, technical trade/certifications, department assignment, and access requirements. The template captures time confirmation details such as 24/7 access versus limited hours (0600-2000), sign-in requirements, and FPCON clearance levels (Charlie or Bravo). A comprehensive training section tracks completion dates for mandatory certifications including annual Safety, AT1, and OPSEC training, plus one-time requirements for IWATCH, Evacuation Coordinator, Energy Monitor, and Building Coordinator certifications. The log also requires documentation of CAC (Common Access Card) status and NEW or RENEWAL designation for access credentials.

The second section functions as an Access Roster tied to the base operations contract, requiring submission to DPW (Directorate of Public Works). This portion documents individual access authorizations including project number/work description, specific installation access locations (Patch, Kelley, RB, Panzer, or SAAF), hours worked, days of the week, GCC issuance date, and BACO90 compliance status. The template is populated with two example entries: a Carpenter Shop Lead from subcontractor SKE and a Senior Electrician from prime contractor Centerra. This form serves as the administrative tool for maintaining compliance with personnel security, training, and facility access requirements under the Base Operations USAG Stuttgart contract.