--- title: Insert Pa Audit Data summary: SQL-004 status: draft owner: Technical Writer last_reviewed: 2026-07-31 library: SAIF.Business.Policy.Audit.Premium reference_type: package --- # SQL-004: Insert Pa Audit Data This statement supports the premium-audit library by insert Pa Audit Data. ## Classification | Field | Value | | --- | --- | | **SQL ID** | SQL-004 | | **Operation type** | Insert | | **Execution method** | IDataRequest.SQLStatement (CommandType.Text) | | **Database** | Oracle | | **Schema** | [unqualified]** | | **Command type** | Text | | **Business object** | `clsAudit` | | **Criteria property** | `InsertSQL` | | **Lifecycle method** | `BeforeInsert / AfterInsert` | ## Parameters | Parameter | Direction | Type | Max length | Description | | --- | --- | --- | --- | --- | | `:AppealHearingDate` | Input | bound from `m_AppealHearingDate` | — | Bound in `clsAudit.BeforeInsert` (line 2424) | | `:AppealNoticeDate` | Input | bound from `m_AppealNoticeDate` | — | Bound in `clsAudit.BeforeInsert` (line 2425) | | `:AppealRequestDate` | Input | bound from `m_AppealRequestDate` | — | Bound in `clsAudit.BeforeInsert` (line 2426) | | `:AppointmentDate` | Input | bound from `combinedDate` | — | Bound in `clsAudit.BeforeInsert` (line 2429) | | `:AssignmentDate` | Input | bound from `m_AssignmentDate` | — | Bound in `clsAudit.BeforeInsert` (line 2431) | | `:AssignmentWeightCount` | Input | bound from `AssignmentWeightCount` | — | Bound in `clsAudit.BeforeInsert` (line 2432) | | `:AuditHoursCount` | Input | bound from `m_AuditHoursCount` | — | Bound in `clsAudit.BeforeInsert` (line 2433) | | `:AuditHours` | Input | bound from `m_AuditHours` | — | Bound in `clsAudit.BeforeInsert` (line 2434) | | `:AuditMethodCode` | Input | bound from `m_AuditMethodCode` | — | Bound in `clsAudit.BeforeInsert` (line 2435) | | `:AppointmentLocationSeqNum` | Input | bound from `m_AppointmentLocationSeqNum` | — | Bound in `clsAudit.BeforeInsert` (line 2476) | | `:TravelHours` | Input | bound from `m_TravelHours` | — | Bound in `clsAudit.BeforeInsert` (line 2436) | | `:MiscHours` | Input | bound from `m_MiscHours` | — | Bound in `clsAudit.BeforeInsert` (line 2437) | | `:AuditInstructionsText` | Input | bound from `m_AuditInstructionsText` | 4000 | Bound in `clsAudit.BeforeInsert` (line 2438) | | `:AuditOfficeCode` | Input | bound from `m_AuditOfficeCode` | 5 | Bound in `clsAudit.BeforeInsert` (line 2439) | | `:CancelDate` | Input | bound from `m_CancelDate` | — | Bound in `clsAudit.BeforeInsert` (line 2441) | | `:CompletedDate` | Input | bound from `m_CompletedDate` | — | Bound in `clsAudit.BeforeInsert` (line 2442) | | `:CreateDate` | Input | bound from `CreateDate` | — | Bound in `clsAudit.BeforeInsert` (line 2443) | | `:CreateUser` | Input | bound from `CreateUser` | 30 | Bound in `clsAudit.BeforeInsert` (line 2444) | | `:DisputedAmount` | Input | bound from `m_DisputedAmount` | — | Bound in `clsAudit.BeforeInsert` (line 2445) | | `:DueDate` | Input | bound from `m_DueDate` | — | Bound in `clsAudit.BeforeInsert` (line 2446) | | `:ProgramDueDate` | Input | bound from `m_ProgramDueDate` | — | Bound in `clsAudit.BeforeInsert` (line 2447) | | `:EndDate` | Input | bound from `EndDate` | — | Bound in `clsAudit.BeforeInsert` (line 2448) | | `:FollowupDate` | Input | bound from `m_FollowupDate` | — | Bound in `clsAudit.BeforeInsert` (line 2449) | | `:AuditorID` | Input | bound from `AuditorID` | 10 | Bound in `clsAudit.BeforeInsert` (line 2440) | | `:AuditSeqNum` | Input | bound from `m_AuditSeqNum` | — | Bound in `clsAudit.BeforeInsert` (line 2480) | | `:CancelReasonCode` | Input | bound from `m_CancelReasonCode` | 5 | Bound in `clsAudit.BeforeInsert` (line 2450) | | `:ReasonCode` | Input | bound from `AuditReasonCode` | 5 | Bound in `clsAudit.BeforeInsert` (line 2451) | | `:ReviewStatusCode` | Input | bound from `m_ReviewStatusCode` | 5 | Bound in `clsAudit.BeforeInsert` (line 2452) | | `:RevisesSeqNum` | Input | bound from `m_RevisesSeqNum` | — | Bound in `clsAudit.BeforeInsert` (line 2453) | | `:SelectionCategoryGroupCode` | Input | bound from `SelectionCategoryGroupCode` | 5 | Bound in `clsAudit.BeforeInsert` (line 2454) | | `:StatusCode` | Input | bound from `StatusCode` | 5 | Bound in `clsAudit.BeforeInsert` (line 2455) | | `:TestAuditAppealCode` | Input | bound from `m_TestAuditAppealCode` | 5 | Bound in `clsAudit.BeforeInsert` (line 2456) | | `:TestAuditResponseCode` | Input | bound from `m_TestAuditResponseCode` | 5 | Bound in `clsAudit.BeforeInsert` (line 2457) | | `:TestAuditResultCode` | Input | bound from `m_TestAuditResultCode` | 5 | Bound in `clsAudit.BeforeInsert` (line 2458) | | `:TestAuditTypeCode` | Input | bound from `m_TestAuditTypeCode` | 5 | Bound in `clsAudit.BeforeInsert` (line 2459) | | `:TypeCode` | Input | bound from `PremiumAuditTypeCode` | 5 | Bound in `clsAudit.BeforeInsert` (line 2460) | | `:WaiverReasonCode` | Input | bound from `m_WaiverReasonCode` | 5 | Bound in `clsAudit.BeforeInsert` (line 2461) | | `:PolicyNumber` | Input | bound from `PolicyNumber` | — | Bound in `clsAudit.BeforeInsert` (line 2462) | | `:ReviewDate` | Input | bound from `m_ReviewDate` | — | Bound in `clsAudit.BeforeInsert` (line 2463) | | `:SchedulingInProgressFlag` | Input | bound from `m_SchedulingInProgressFlag` | 1 | Bound in `clsAudit.BeforeInsert` (line 2464) | | `:SelectionStdPremAmount` | Input | bound from `m_SelectionStdPremAmount` | — | Bound in `clsAudit.BeforeInsert` (line 2465) | | `:StartDate` | Input | bound from `StartDate` | — | Bound in `clsAudit.BeforeInsert` (line 2466) | | `:SubmittedDate` | Input | bound from `m_SubmittedDate` | — | Bound in `clsAudit.BeforeInsert` (line 2467) | | `:TestAuditorName` | Input | bound from `m_TestAuditorName` | 30 | Bound in `clsAudit.BeforeInsert` (line 2468) | | `:TestAuditDifferenceAmount` | Input | bound from `m_TestAuditDifferenceAmount` | — | Bound in `clsAudit.BeforeInsert` (line 2469) | | `:UpdateDate` | Input | bound from `m_UpdateDate` | — | Bound in `clsAudit.BeforeInsert` (line 2470) | | `:UpdateSeqNum` | Input | bound from `UpdateSeqNum` | — | Bound in `clsAudit.BeforeInsert` (line 2471) | | `:UpdateUser` | Input | bound from `m_UpdateUser` | 30 | Bound in `clsAudit.BeforeInsert` (line 2472) | | `:WaiverEndDate` | Input | bound from `m_WaiverEndDate` | — | Bound in `clsAudit.BeforeInsert` (line 2473) | | `:WaiverStartDate` | Input | bound from `m_WaiverStartDate` | — | Bound in `clsAudit.BeforeInsert` (line 2474) | | `:WarningLetterDate` | Input | bound from `m_WarningLetterDate` | — | Bound in `clsAudit.BeforeInsert` (line 2475) | | `:WorkbookStatusCode` | Input | bound from `SmartWorkbookStatusCode(m_WorkbookStatus` | — | Bound in `clsAudit.BeforeInsert` (line 2477) | | `:WorkbookFileName` | Input | bound from `m_workbookFileName` | 65 | Bound in `clsAudit.BeforeInsert` (line 2478) | | `:WorkbookImageSeqNum` | Input | bound from `m_workbookImageSeqNum` | — | Bound in `clsAudit.BeforeInsert` (line 2479) | ## Tables | Table | Access | Columns used | | --- | --- | --- | | [`PA_AUDIT`](../database-tables.md#pa_audit) | INSERT | See sample SQL. | ## Sample SQL ```sql INSERT INTO PA_AUDIT ( APPEAL_HEARING_DATE, APPEAL_NOTICE_DATE, APPEAL_REQUEST_DATE, APPOINTMENT_DATE, ASSIGNMENT_DATE, ASSIGNMENT_WEIGHT_COUNT, AUDIT_HOURS_COUNT, AUDIT_HOURS, PA_METHOD_CODE, APPOINTMENT_LOC_SEQ_NUM, TRAVEL_HOURS, MISC_HOURS, AUDIT_INSTRUCTIONS_TEXT, AUDIT_OFFICE_CODE, CANCEL_DATE, COMPLETED_DATE, CREATE_DATE, CREATE_USER, DISPUTED_AMOUNT, DUE_DATE, PROGRAM_DUE_DATE, END_DATE, FOLLOWUP_DATE, PA_AUDITOR_ID, PA_AUDIT_SEQ_NUM, PA_CANCEL_REASON_CODE, PA_REASON_CODE, PA_REVIEW_STATUS_CODE, PA_REVISES_SEQ_NUM, PA_SLCTN_CATEGORY_GROUP_CODE, PA_STATUS_CODE, PA_TEST_AUDIT_APPEAL_CODE, PA_TEST_AUDIT_RESPONSE_CODE, PA_TEST_AUDIT_RESULT_CODE, PA_TEST_AUDIT_TYPE_CODE, PA_TYPE_CODE, PA_WAIVER_REASON_CODE, POLICY_NUM, REVIEW_DATE, SCHEDULING_INPROGRESS_FLAG, SELECTION_STD_PREM_AMOUNT, START_DATE, SUBMITTED_DATE, TEST_AUDITOR_NAME, TEST_AUDIT_DIFFERENCE_AMOUNT, UPDATE_DATE, UPDATE_SEQ_NUM, UPDATE_USER, WAIVER_END_DATE, WAIVER_START_DATE, WARNING_LETTER_DATE, WORKBOOK_STATUS_CODE, WORKBOOK_FILE_NAME, WORKBOOK_IMAGE_SEQ_NUM ) VALUES ( :AppealHearingDate, :AppealNoticeDate, :AppealRequestDate, :AppointmentDate, :AssignmentDate, :AssignmentWeightCount, :AuditHoursCount, :AuditHours, :AuditMethodCode, :AppointmentLocationSeqNum, :TravelHours, :MiscHours, :AuditInstructionsText, :AuditOfficeCode, :CancelDate, :CompletedDate, :CreateDate, :CreateUser, :DisputedAmount, :DueDate, :ProgramDueDate, :EndDate, :FollowupDate, :AuditorID, :AuditSeqNum, :CancelReasonCode, :ReasonCode, :ReviewStatusCode, :RevisesSeqNum, :SelectionCategoryGroupCode, :StatusCode, :TestAuditAppealCode, :TestAuditResponseCode, :TestAuditResultCode, :TestAuditTypeCode, :TypeCode, :WaiverReasonCode, :PolicyNumber, :ReviewDate, :SchedulingInProgressFlag, :SelectionStdPremAmount, :StartDate, :SubmittedDate, :TestAuditorName, :TestAuditDifferenceAmount, :UpdateDate, :UpdateSeqNum, :UpdateUser, :WaiverEndDate, :WaiverStartDate, :WarningLetterDate, :WorkbookStatusCode, :WorkbookFileName, :WorkbookImageSeqNum ) ``` ## Operations and processes - [Assign an audit to an auditor](../operations/assign-an-audit-to-an-auditor.md) - [Synchronize an audit with WCIS policy-period changes](../operations/synchronize-an-audit-with-wcis-policy-period-changes.md) - [Save a premium audit](../operations/save-a-premium-audit.md) - [Audit lifecycle status transitions](../operations/audit-lifecycle-status-transitions.md) ## Business rules - [BR-020](../business-rules.md#br-020-ineligible-policy-types-cannot-be-audited) - [BR-021](../business-rules.md#br-021-duplicate-audits-are-blocked) - [BR-032](../business-rules.md#br-032-rows-affected-must-equal-one) - [BR-035](../business-rules.md#br-035-nonzerodecimalrequired-auditseqnum) - [BR-036](../business-rules.md#br-036-nonzerodecimalrequired-policynumber) - [BR-037](../business-rules.md#br-037-textrequired) - [BR-057](../business-rules.md#br-057-validupdatableaudit) > **Note:** Statements marked with * were inferred from code structure, naming conventions, or > contextual evidence where direct confirmation was not available in source artifacts. Statements > marked with ** could not be confirmed; treat as unknown until verified. ## Sources - `Business/SAIF.Business.Policy.Audit.Premium/clsAudit.vb:4800`