TimeTrex Time and Attendance

I'm writing a quick pygtk-psycopg2 application to punch people in and out. The punch and punch_control tables are fairly straight forward except for the punch_control.user_date_id column

Anyone know what this is exactly or how its generated?

If you are trying to write data directly to the database you are doing it wrong, you should use the API instead as it will do all the heavy lifting (including dealing with punch_control records) for you.

I don't think there is an API for python.

TimeTrex's API works with SOAP and JSON (similar to REST), so it works from any language, including Javascript.