Business Process Tracking Tables

Column	Data Type	Constraint
`id`	VARCHAR(40)	NOT NULL
(primary key)	The unique identifier associated with the business process stage reached dataset.
`owner_id`	VARCHAR(40)	NOT NULL
	The ID of the `RepositoryItem` that is assigned a marker when this stage is reached.
`process_start_time`	TIMESTAMP	NOT NULL
	The time a `RepositoryItem` obtains a marker for a business process stage.
`event_time`	TIMESTAMP	NOT NULL
	The time the stage is reached.
`bp_name`	VARCHAR(225)	NOT NULL
	The business process name.
`bp_stage`	VARCHAR(225)	NULL
	The business process stage name.
`is_transient`	NUMERIC (1,0)	NOT NULL
	Indicates if the user who reached the business stage is logged in.
`bp_stage_sequence`	INTEGER	NOT NULL
	The index of this stage in the business process.

Column	Data Type	Constraint
`marker_id`	VARCHAR(40)	NOT NULL
(primary key)	The unique identifier associated with the marker.
`profile_id`	VARCHAR(40)	NOT NULL
(primary key)	The ID of the Profile for that has a marker.
`marker_key`	VARCHAR(100)	NOT NULL
	The name of the business process associated with the marker.
`marker_value`	VARCHAR(100)	NULL
	The name of the business process stage associated with the marker.
`marker_data`	VARCHAR(100)	NULL
	This column is not currently in use.
`creation_date`	TIMESTAMP	NULL
	The date the business process stage is reached and the marker is assigned to the Profile.
`version`	INTEGER	NOT NULL
	The marker repository version number. This information is managed and used internally by the repository.
`marker_type`	INTEGER	NULL
	This column is not currently in use.

ATG Personalization Programming Guide