Overview
This command will list the audit type with its respective auditors associated with a certain audit.
Related tables
Table
|
Description
|
Primary key (PK)
|
Connection tables
|
AUAUDIT
|
Stores the audit data
|
CDAUDIT
|
AUAUDITAUDITOR
ADCOMPANY
AUAUDITORG
|
AUAUDITAUDITOR
|
Stores the data of the auditor associated with the audit
|
CDAUDIT
CDAUDITAUDITOR
|
AUAUDIT
AUINTERNALAUDITOR AUEXTERNALAUDITOR
|
ADCOMPANY
|
Stores the data of the company/business unit
|
CDCOMPANY
|
AUAUDIT
AUAUDITORG
|
AUINTERNALAUDITOR
|
Stores the data of the internal auditor
|
CDINTERNALAUDITOR
|
AUAUDITAUDITOR
ADALLUSERS
|
ADALLUSERS
|
Stores the user data
|
CDUSER
|
AUINTERNALAUDITOR
|
AUAUDITORG
|
Stores the audit organization data
|
CDAUDITORG
|
AUAUDIT
ADCOMPANY
|
AUEXTERNALAUDITOR
|
Stores the data of external auditors from an audit organization
|
CDAUDITORG
CDEXTERNALAUDITOR
|
AUAUDITAUDITOR
|
Oracle/Postgres/SQL Server
SELECT
AUAUDIT.IDAUDIT,
AUAUDIT.NMAUDIT,
AUAUDIT.FGAUDITORGTYPE,
AUAUDITAUDITOR.FGTEAMLEADER,
ADCOMPANY.IDCOMMERCIAL,
ADCOMPANY.NMCOMPANY,
ADALLUSERS.IDUSER,
ADALLUSERS.NMUSER,
AUEXTERNALAUDITOR.IDEXTERNALAUDITOR,
AUEXTERNALAUDITOR.NMEXTERNALAUDITOR
FROM
AUAUDIT
INNER JOIN AUAUDITAUDITOR ON (AUAUDIT.CDAUDIT = AUAUDITAUDITOR.CDAUDIT)
LEFT JOIN AUINTERNALAUDITOR ON (AUINTERNALAUDITOR.CDINTERNALAUDITOR = AUAUDITAUDITOR.CDINTERNALAUDITOR)
LEFT JOIN ADALLUSERS ON (ADALLUSERS.CDUSER = AUINTERNALAUDITOR.CDINTAUDITORUSER)
LEFT JOIN AUAUDITORG ON (AUAUDITORG.CDAUDITORG = AUAUDIT.CDAUDITORG)
LEFT JOIN ADCOMPANY ON (ADCOMPANY.CDCOMPANY = AUAUDITORG.CDAUDITORG OR ADCOMPANY.CDCOMPANY = AUAUDIT.CDAUDITEECOMPANIES) /* NOTE1 */
LEFT JOIN AUEXTERNALAUDITOR ON (AUEXTERNALAUDITOR.CDAUDITORG = AUAUDITAUDITOR.CDAUDITORG AND AUEXTERNALAUDITOR.CDEXTERNALAUDITOR = AUAUDITAUDITOR.CDEXTERNALAUDITOR)
WHERE
AUAUDIT.IDAUDIT = 'AUDIT_ID' /* NOTE2 */
|
Notes
▪1: If the audit is configured for an auditor business unit, it will return the business unit information; if it is configured for an audit organization, it will return the organization information. ▪2: 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
|
AUAUDIT.FGAUDITORGTYPE
|
|
10 – Company
20 – Audit business unit
30 – Audit organization
|
3
|
ADCOMPANY.IDCOMMERCIAL
ADCOMPANY.NMCOMPANY
|
VARCHAR(50) NULL
VARCHAR(255) NULL
|
|
4
|
AUAUDITAUDITOR.FGTEAMLEADER
|
|
|
5
|
ADALLUSERS.IDUSER
ADALLUSERS.NMUSER
AUEXTERNALAUDITOR.IDEXTERNALAUDITOR
AUEXTERNALAUDITOR.NMEXTERNALAUDITOR
|
VARCHAR(50) NULL
VARCHAR(255) NULL
VARCHAR(50) NULL
VARCHAR(255) NULL
|
If the audit is configured for an audit organization, the AUEXTERNALAUDITOR fields will be filled out; otherwise, the ADALLUSERS fields will be filled out.
|
|
