By adding default constraint you can achieve this goal.
ALTER TABLE Attendance
ADD CONSTRAINT df_Constraint_Attendance_Date
DEFAULT GETUTCDATE() FOR [Date]
GO
ALTER TABLE Attendance
ADD CONSTRAINT df_Constraint_Attendance_Status
DEFAULT 'P' FOR [Status]
GO
INSERT INTO Attendance (Emp_Id) VALUES(1)