Overview
This command will list the audits and their planned and actual execution dates associated with a certain audit plan.
Related tables
Table
|
Description
|
Primary key (PK)
|
Connection tables
|
AUPLAN
|
Stores the audit plan data
|
CDPLAN
|
AUPLAN
AUPLANEXECMODEL
AUAUDITSTEP
|
AUPLANEXECMODEL
|
Stores plan source and configuration data
|
CDPLANEXECMODEL
|
AUPLAN
AUPLANEXECMODEL
AUAUDITSTEP
|
AUAUDIT
|
Stores the audit data
|
CDAUDIT
|
AUPLAN
AUPLANEXECMODEL
AUAUDITSTEP
|
AUAUDITSTEP
|
Stores the audit step data
|
CDAUDIT
FGAUDITSTEP
|
AUAUDIT
|
Oracle/Postgres/SQL Server
SELECT
AUPLAN.IDPLAN,
AUPLAN.NMPLAN,
AUAUDIT.IDAUDIT,
AUAUDIT.NMAUDIT,
AUAUDITSTEP.DTPLANNEDSTARTDT,
AUAUDITSTEP.DTPLANNEDENDDATE,
AUAUDITSTEP.DTACTUALSTARTDT,
AUAUDITSTEP.DTACTUALENDDATE
FROM
AUPLAN
INNER JOIN AUPLANEXECMODEL ON (AUPLANEXECMODEL.CDPLAN = AUPLAN.CDPLAN)
INNER JOIN AUAUDIT ON (AUAUDIT.CDPLANEXECMODEL = AUPLANEXECMODEL.CDPLANEXECMODEL)
INNER JOIN AUAUDITSTEP ON (AUAUDITSTEP.CDAUDIT = AUAUDIT.CDAUDIT AND AUAUDITSTEP.FGAUDITSTEP = 4 /* NOTE1 */)
WHERE
AUPLAN.IDPLAN = 'AUDIT_PLAN_ID' /* NOTE2 */
|
Notes
▪1: FGAUDITSTEP represents each audit step: 2 for planning, 3 for preparation, 4 for execution, and 5 for closure. ▪2: ID # of the audit plan that will be used to filter.
Fields used on the view screen
#
|
Field ID
|
Type
|
Description
|
1
|
AUPLAN.IDPLAN
AUPLAN.NMPLAN
|
VARCHAR(50) NULL
VARCHAR(255) NULL
|
|
2
|
AUAUDIT.IDAUDIT
|
VARCHAR(50) NULL
|
|
3
|
AUAUDIT.NMAUDIT
|
VARCHAR(255) NULL
|
|
4
|
AUAUDITSTEP.DTPLANNEDSTARTDT
|
DATETIME
|
|
5
|
AUAUDITSTEP.DTPLANNEDENDDATE
|
DATETIME
|
|
6
|
AUAUDITSTEP.DTACTUALSTARTDT
|
DATETIME
|
|
7
|
AUAUDITSTEP.DTACTUALENDDATE
|
DATETIME
|
|
|