Field name

Data type

Length

Description

stat_id

AutoNumber, Primary Key

n/a

Unique Serial Number to identify a record

idp_id

Number (Long Integer)

n/a

Foreign key from the table IDP_USER

idp_colorcode

Number (Long Integer)

n/a

The color code of the record

stat_action

Text

150

The action name to build the stats

stat_station

Text

150

The name of the station responsible for the insert

stat_table

Text

75

The name of the table where the IDP info came from ( IDP_USER table by default or your own table)

stat_insdate

Date/Time

n/a

Insertion date of the record

Sec_id

Number (Long Integer)

n/a

Foreign key from the IDP_SECURITY table