In CA Jobtrac Job Management r11 Audit report GJTREZAU, what are the meanings of the field definitions?

Products

• Jobtrac

Issue/Introduction

This article explains the meaning  of the  field definitions for the  'DB TBL ID' and 'SQL_FIELD_NAME' columns on the Jobtrac GJTREZAU audit report.

 

 

Environment

Release: JOBT..00200-11-Jobtrac-Job Management
Component:

Resolution

The contents of the DB TBL ID column on the CA Jobtrac JM Audit report currently can be one of the following:

 ARG - Argument data for an event

 CCD - Condition Code data for an event

 CPM - CPM Flow data for an event

 EDT - Environmental Dependency data for an event

 EVT - Event data

 RSC - Resource data for an event

 PST - Predecessor / successor data for an event

 OPS - System Options data

 OPC - Cyclic Calendar data

 OPH - Holiday Calendar data

 SEV - Event data (on the Staging area; this will be present if a user specified an ADD/RUN command

        is used to add an event to the schedule)

 

The SQL_FIELD_NAME column will show a "group heading" in the format:

[facility] [function] [db table id]

 

 Where:

 [facility] is the facility through which the function took place: (JOBTRAC, CONSOLE, ISPF, INTERNAL)

 [function] is the function performed: (ADDED, DELETED, CHANGED)

 [db table id] is the database table ID from the previous list

 

 For example:

  ISPF      DELETED   EVT

 CONSOLE   ADDED     SEV

For a change function, the individual SQL field names with before/after data will be listed under the 'group heading'.   

As always, please contact Broadcom support for Jobtrac Job Management if you hav further questions.