<< Click to Display Table of Contents >> Navigation: Modules > Workflow Automation > Workflows > Threads > Work Log > Variables > Catch Point Insert/Update Into Staging Table |
When a workflow thread is created as a result of one of the Catch Point Screens inserting or updating a record in the asset staging table, the following variables are forwarded:
Variable |
Value |
V1 |
iStageNo - primary key value of the staging table record |
V2 |
cpNo (catch point number) of catch point that caused the insert or update |
V3 |
Number of software records saved (if any) |
V4 |
Number of component records saved (if any) |
V5 |
Life cycle status (if sourced by the catch point screen) |
V6 |
Asset serial number (if sourced by the catch point screen) |
V7 |
Asset manufacturer (if sourced by the catch point screen) |
V8 |
Device name (if sourced by the catch point screen) |
VR |
Email address (if sourced by the catch point screen) |
VA |
(not assigned) |
Additionally, the primary table identifier will be the assets table, and the primary key for the primary table will be the AssetID that matches the record in the staging table (if a record currently exists in the Assets table that matches the one in the staging table. For newly inserted staging records, a corresponding asset record may not yet exist, in which case the key value forwarded will be 0.)