|
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 |