| |
AVAILABLE FIELDS |
|
|
| |
ActualDate |
Date |
|
| |
ActualDateTime |
Date |
Includes time component |
| |
Amount |
Numeric |
|
| |
Assessment |
Numeric |
|
| |
AuditBusiness |
Numeric |
|
| |
AuditBusinessText |
Text (50) |
|
| |
AuditFee |
Numeric |
|
| |
AuditPerson |
Numeric |
|
| |
AuditPersonText |
Text (50) |
|
| |
BaseCodeOfPractice |
Numeric |
|
| |
BaseCodeOfPracticeOffSiteHours |
Numeric |
|
| |
BaseCodeOfPracticeOnSiteHours |
Numeric |
|
| |
BaseCodeOfPracticeText |
Text (50) |
|
| |
CertificateSentBy |
Numeric |
|
| |
CertificateSentByText |
Text (50) |
|
| |
CertificateSentDate |
Date |
|
| |
CertificationLevel |
Numeric |
|
| |
CertificationLevelText |
Text (50) |
|
| |
CodeOfPractice |
Numeric |
|
| |
CodeOfPracticeOffSiteHours |
Numeric |
|
| |
CodeOfPracticeOnSiteHours |
Numeric |
|
| |
CodeOfPracticeText |
Text (50) |
|
| |
ContactBusiness |
Numeric |
|
| |
ContactBusinessText |
Text (50) |
|
| |
ContactPerson |
Numeric |
|
| |
ContactPersonText |
Text (50) |
|
| |
EndDate |
Date |
|
| |
EndDateTime |
Date |
Includes time component |
| |
ExtensionMonths |
Numeric |
|
| |
Grade |
Numeric |
As per SETUP_AUDIT_GRADE_MANAGE |
| |
GradeText |
Text (50) |
|
| |
Id |
Numeric |
|
| |
InvoiceReference |
Text (50) |
|
| |
Manager |
Numeric |
|
| |
ManagerText |
Text (50) |
|
| |
MembershipStatus |
Numeric |
|
| |
MembershipStatusText |
Text (50) |
|
| |
MinimumIssueCount |
Numeric |
|
| |
Notes |
Text (2000) |
|
| |
OpenIssueCount |
Numeric |
|
| |
Outcome |
Text - Long |
|
| |
ProcessingStatus |
Numeric |
|
| |
ProcessingStatusDate |
Date |
Most recent processing item |
| |
ProcessingStatusNotes |
Text (50) |
Most recent processing item |
| |
ProcessingStatusText |
Text (50) |
|
| |
RemoteAuditDate |
Date |
|
| |
RemoteAuditorContactPerson |
Numeric |
|
| |
RemoteAuditorContactPersonText |
Text |
|
| |
RemoteComponentType |
Numeric |
|
| |
RemoteComponentTypeText |
Text |
|
| |
RemoteDuration |
Date |
|
| |
ReviewDate |
Date |
|
| |
QualifyingTraineeFirstName |
Text (100) |
|
| |
QualifyingTraineeSurName |
Text (100) |
|
| |
QualifyingTrainingDate |
Date |
|
| |
QuotedAmount |
Numeric |
|
| |
Reference |
Text (50) |
|
| |
ResultStatus |
Numeric |
|
| |
ResultStatusDate |
Date |
|
| |
ResultStatusDateTime |
Date |
Includes time component |
| |
ResultStatusText |
Text (50) |
|
| |
ReviewType |
Numeric |
|
| |
ReviewTypeText |
Text (50) |
|
| |
ScheduledDate |
Date |
|
| |
ScheduledDateTime |
Date |
Includes time component |
| |
SiteInspectionHours |
Numeric |
|
| |
Status |
Numeric |
|
| |
StatusDate |
Date |
Most recent history item |
| |
StatusNotes |
Text (50) |
Most recent history item |
| |
StatusText |
Text (50) |
|
| |
Subscription |
Numeric |
|
| |
SubscriptionText |
Text (50) |
|
| |
TeamLeaderContactPerson |
Numeric |
|
| |
TeamLeaderContactPersonText |
Text (50) |
|
| |
Title |
Text (50) |
|
| |
TotalHours |
Numeric |
|
| |
TotalIssueCount |
Numeric |
|
| |
TotalTimeHours |
Numeric |
|
| |
TrainerContactBusiness |
Numeric |
|
| |
TrainingDate |
Date |
|
| |
TrainingDuration |
Numeric |
|
| |
TrainingRating |
Numeric |
|
| |
TrainingNotes |
Text (2000) |
|
| |
TravelAmount |
Numeric |
|
| |
TravelTimeCost |
Numeric |
|
| |
Type |
Numeric |
|
| |
TypeText |
Text (50) |
|
| |
WitnessStatus |
Numeric |
As per SETUP_AUDIT_WITNESS_STATUS_SEARCH |
| |
WitnessStatusText |
Text (50) |
|
| |
|
|
|
| |
Audit Fields |
|
Click here for more information |