punch column map question

[lfrazier]

Hello TimeTrex,

I am doing some punch imports and have a question about what the key values are for type_id and status_id.

example: instead of using IN or OUT for status_id, I would like to use the actual number equivalents.

Also, for type_id, what values are available?

Thanks,

Lloyd

[shaunw]

Status_ID:
10 = In
20 = Out

Type_ID:
10 = Normal
20 = Lunch
30 = Break

If you are using the import punch script, these values won't work though, you need to use the names instead of the integer values.

[lfrazier]

Hi Shaun,

thanks for the quick response. I did not realize that numerical values were not used.

I have a final question. What about transfers? What alpha values are used for status_id and type_id for transfers?

Thanks,

Lloyd

[shaunw]

The import script doesn't support transfer punches natively, but transfer punches are just an out punch and an in punch at the exact same time, there is really nothing special about them.