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 |
INSERT | See sample SQL. |
Sample 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
- Synchronize an audit with WCIS policy-period changes
- Save a premium audit
- Audit lifecycle status transitions
Business rules¶
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