Catch Point Insert/Update Into Staging Table

<< 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.)