Overview
This command will list the requirements of an audit and its evaluation information such as weight, value, and conformity level.
Related tables
Table
|
Description
|
Primary key (PK)
|
Connection tables
|
AUAUDIT
|
Stores the audit data
|
CDAUDIT
|
AUSCOPESTRUCT
|
AUSCOPESTRUCT
|
Stores the audit structure data
|
CDSTRUCT
|
AUAUDIT
|
AUCONFORMITYLEVEL
|
Stores the conformity level data
|
CDAUDITEVALCRIT
CDAUDITEVALCRITREV CDCONFORMITYLEVEL
|
AUSCOPESTRUCT
|
Oracle/Postgres/SQL Server
SELECT
AUAUDIT.IDAUDIT,
AUAUDIT.NMAUDIT,
AUSCOPESTRUCT.FGSTRUCTTYPE,
AUSCOPESTRUCT.IDSTRUCT,
AUSCOPESTRUCT.NMSTRUCT,
AUSCOPESTRUCT.VLWEIGHT,
AUSCOPESTRUCT.VLPOINTS,
AUSCOPESTRUCT.VLCONFORMITYPERCENT,
AUCONFORMITYLEVEL.IDCONFORMITYLEVEL,
AUCONFORMITYLEVEL.NMCONFORMITYLEVEL
FROM
AUAUDIT
INNER JOIN AUSCOPESTRUCT ON (AUSCOPESTRUCT.CDSCOPEDEFINITION = AUAUDIT.CDSCOPEDEFINITION)
LEFT JOIN AUCONFORMITYLEVEL ON (
AUSCOPESTRUCT.CDAUDITEVALCRIT = AUCONFORMITYLEVEL.CDAUDITEVALCRIT
AND AUSCOPESTRUCT.CDAUDITEVALCRITREV = AUCONFORMITYLEVEL.CDAUDITEVALCRITREV
AND AUCONFORMITYLEVEL.CDCONFORMITYLEVEL = AUSCOPESTRUCT.CDCONFORMITYLEVEL
)
WHERE
AUSCOPESTRUCT.FGSELECTED = 1
AND AUSCOPESTRUCT.FGSTRUCTTYPE IN (1, 2, 3)
AND AUAUDIT.IDAUDIT = 'AUDIT_ID' /* NOTE1 */
|
Notes
▪1: ID # of the audit that will be used to filter.
Fields used on the view screen
#
|
Field ID
|
Type
|
Description
|
1
|
AUAUDIT.IDAUDIT
AUAUDIT.NMAUDIT
|
VARCHAR(50) NULL
VARCHAR(255) NULL
|
|
2
|
AUSCOPESTRUCT.FGSTRUCTTYPE
|
NUMERIC(2)
|
1– Reference requirement
2– Guidance requirement
3– Lowest level requirement
4– Verification item grouper
5– Verification item
6– Audit test
7– Audit test sample
8– Audit test question grouper
9– Audit test question template
10– Audit test question grouper
11– Audit test question
12– Company
13– Business unit
14– Risk
15– Control
16– Control test
17– Control test sample
19– Control test question template
20– Control test question grouper
21– Control test question
22– Process
23– Process activity
24– Element
25– Unselected requirement
|
3
|
AUSCOPESTRUCT.VLPOINTS
|
NUMERIC(28, 12) NULL
|
|
4
|
AUCONFORMITYLEVEL.IDCONFORMITYLEVEL
AUCONFORMITYLEVEL.NMCONFORMITYLEVEL
|
VARCHAR(50) NULL
VARCHAR(255) NULL
|
|
5
|
AUSCOPESTRUCT.VLCONFORMITYPERCENT
|
NUMERIC(28, 12) NULL
|
|
6
|
AUSCOPESTRUCT.VLWEIGHT
|
NUMERIC(28, 12) NULL
|
|
|