SQL-076: Update Pa Audit Data

This statement supports the premium-audit library by update Pa Audit Data.

Classification

Field	Value
SQL ID	SQL-076
Operation type	Update
Execution method	IDataRequest.SQLStatement (CommandType.Text)
Database	Oracle
Schema	[unqualified]**
Command type	Text
Business object	clsAudit
Criteria property	UpdateSQL
Lifecycle method	BeforeUpdate / AfterUpdate

Parameters

Parameter	Direction	Type	Max length	Description
:AuditOfficeCode	Input	bound from m_AuditOfficeCode	5	Bound in clsAudit.BeforeUpdate (line 2539)
:EndDate	Input	bound from EndDate	—	Bound in clsAudit.BeforeUpdate (line 2540)
:AuditorID	Input	bound from AuditorID	10	Bound in clsAudit.BeforeUpdate (line 2541)
:ReasonCode	Input	bound from AuditReasonCode	5	Bound in clsAudit.BeforeUpdate (line 2542)
:SelectionCategoryGroupCode	Input	bound from SelectionCategoryGroupCode	5	Bound in clsAudit.BeforeUpdate (line 2543)
:TypeCode	Input	bound from PremiumAuditTypeCode	5	Bound in clsAudit.BeforeUpdate (line 2544)
:PolicyNum	Input	bound from PolicyNumber	—	Bound in clsAudit.BeforeUpdate (line 2545)
:StartDate	Input	bound from StartDate	—	Bound in clsAudit.BeforeUpdate (line 2546)
:AppealHearingDate	Input	bound from m_AppealHearingDate	—	Bound in clsAudit.BeforeUpdate (line 2547)
:AppealNoticeDate	Input	bound from m_AppealNoticeDate	—	Bound in clsAudit.BeforeUpdate (line 2548)
:AppealRequestDate	Input	bound from m_AppealRequestDate	—	Bound in clsAudit.BeforeUpdate (line 2549)
:AppointmentDate	Input	bound from combinedDate	—	Bound in clsAudit.BeforeUpdate (line 2552)
:AppointmentLocationSeqNum	Input	bound from m_AppointmentLocationSeqNum	—	Bound in clsAudit.BeforeUpdate (line 2554)
:AssignmentDate	Input	bound from m_AssignmentDate	—	Bound in clsAudit.BeforeUpdate (line 2555)
:AuditHoursCount	Input	bound from m_AuditHoursCount	—	Bound in clsAudit.BeforeUpdate (line 2556)
:AuditHours	Input	bound from m_AuditHours	—	Bound in clsAudit.BeforeUpdate (line 2557)
:AuditMethodCode	Input	bound from m_AuditMethodCode	—	Bound in clsAudit.BeforeUpdate (line 2558)
:TravelHours	Input	bound from m_TravelHours	—	Bound in clsAudit.BeforeUpdate (line 2559)
:MiscHours	Input	bound from m_MiscHours	—	Bound in clsAudit.BeforeUpdate (line 2560)
:FollowupDate	Input	bound from m_FollowupDate	—	Bound in clsAudit.BeforeUpdate (line 2561)
:AuditInstructionsText	Input	bound from m_AuditInstructionsText	4000	Bound in clsAudit.BeforeUpdate (line 2562)
:CancelDate	Input	bound from m_CancelDate	—	Bound in clsAudit.BeforeUpdate (line 2563)
:CompletedDate	Input	bound from m_CompletedDate	—	Bound in clsAudit.BeforeUpdate (line 2564)
:DisputedAmount	Input	bound from m_DisputedAmount	—	Bound in clsAudit.BeforeUpdate (line 2565)
:DueDate	Input	bound from m_DueDate	—	Bound in clsAudit.BeforeUpdate (line 2566)
:ProgramDueDate	Input	bound from m_ProgramDueDate	—	Bound in clsAudit.BeforeUpdate (line 2567)
:CancelReasonCode	Input	bound from m_CancelReasonCode	5	Bound in clsAudit.BeforeUpdate (line 2568)
:ReviewStatusCode	Input	bound from m_ReviewStatusCode	5	Bound in clsAudit.BeforeUpdate (line 2569)
:RevisesSeqNum	Input	bound from m_RevisesSeqNum	—	Bound in clsAudit.BeforeUpdate (line 2570)
:TestAuditAppealCode	Input	bound from m_TestAuditAppealCode	5	Bound in clsAudit.BeforeUpdate (line 2571)
:TestAuditResponseCode	Input	bound from m_TestAuditResponseCode	5	Bound in clsAudit.BeforeUpdate (line 2572)
:TestAuditResultCode	Input	bound from m_TestAuditResultCode	5	Bound in clsAudit.BeforeUpdate (line 2573)
:TestAuditTypeCode	Input	bound from m_TestAuditTypeCode	5	Bound in clsAudit.BeforeUpdate (line 2574)
:WaiverReasonCode	Input	bound from m_WaiverReasonCode	5	Bound in clsAudit.BeforeUpdate (line 2575)
:ReviewDate	Input	bound from m_ReviewDate	—	Bound in clsAudit.BeforeUpdate (line 2576)
:SchedulingInProgressFlag	Input	bound from m_SchedulingInProgressFlag	1	Bound in clsAudit.BeforeUpdate (line 2577)
:SelectionStdPremAmount	Input	bound from m_SelectionStdPremAmount	—	Bound in clsAudit.BeforeUpdate (line 2578)
:SubmittedDate	Input	bound from m_SubmittedDate	—	Bound in clsAudit.BeforeUpdate (line 2579)
:TestAuditorName	Input	bound from m_TestAuditorName	30	Bound in clsAudit.BeforeUpdate (line 2580)
:TestAuditDifferenceAmount	Input	bound from m_TestAuditDifferenceAmount	—	Bound in clsAudit.BeforeUpdate (line 2581)
:UpdateDate	Input	bound from m_UpdateDate	—	Bound in clsAudit.BeforeUpdate (line 2582)
:UpdateUser	Input	bound from m_UpdateUser	30	Bound in clsAudit.BeforeUpdate (line 2583)
:WaiverEndDate	Input	bound from m_WaiverEndDate	—	Bound in clsAudit.BeforeUpdate (line 2584)
:WaiverStartDate	Input	bound from m_WaiverStartDate	—	Bound in clsAudit.BeforeUpdate (line 2585)
:WarningLetterDate	Input	bound from m_WarningLetterDate	—	Bound in clsAudit.BeforeUpdate (line 2586)
:AssignmentWeightCount	Input	bound from AssignmentWeightCount	—	Bound in clsAudit.BeforeUpdate (line 2587)
:WorkbookStatusCode	Input	bound from SmartWorkbookStatusCode(m_WorkbookStatus	—	Bound in clsAudit.BeforeUpdate (line 2589)
:WorkbookFileName	Input	bound from m_workbookFileName	65	Bound in clsAudit.BeforeUpdate (line 2590)
:WorkbookImageSeqNum	Input	bound from m_workbookImageSeqNum	—	Bound in clsAudit.BeforeUpdate (line 2591)
:StatusCode	Input	bound from StatusCode	5	Bound in clsAudit.BeforeUpdate (line 2588)
:AuditSeqNum	Input	bound from m_AuditSeqNum	—	Bound in clsAudit.BeforeUpdate (line 2592)
:UpdateSeqNum	Input	bound from UpdateSeqNum	—	Bound in clsAudit.BeforeUpdate (line 2593)

Tables

Table	Access	Columns used
PA_AUDIT	UPDATE	See sample SQL.

Sample SQL

UPDATE
  PA_AUDIT
SET
  AUDIT_OFFICE_CODE = :AuditOfficeCode,
  END_DATE = :EndDate,
  PA_AUDITOR_ID = :AuditorID,
  PA_REASON_CODE = :ReasonCode,
  PA_SLCTN_CATEGORY_GROUP_CODE = :SelectionCategoryGroupCode,
  PA_TYPE_CODE = :TypeCode,
  POLICY_NUM = :PolicyNum,
  START_DATE = :StartDate,
  APPEAL_HEARING_DATE = :AppealHearingDate,
  APPEAL_NOTICE_DATE = :AppealNoticeDate,
  APPEAL_REQUEST_DATE = :AppealRequestDate,
  APPOINTMENT_DATE = :AppointmentDate,
  APPOINTMENT_LOC_SEQ_NUM = :AppointmentLocationSeqNum,
  ASSIGNMENT_DATE = :AssignmentDate,
  AUDIT_HOURS_COUNT = :AuditHoursCount,
  AUDIT_HOURS = :AuditHours,
  PA_METHOD_CODE = :AuditMethodCode,
  TRAVEL_HOURS = :TravelHours,
  MISC_HOURS = :MiscHours,
  FOLLOWUP_DATE = :FollowupDate,
  AUDIT_INSTRUCTIONS_TEXT = :AuditInstructionsText,
  CANCEL_DATE = :CancelDate,
  COMPLETED_DATE = :CompletedDate,
  DISPUTED_AMOUNT = :DisputedAmount,
  DUE_DATE = :DueDate,
  PROGRAM_DUE_DATE = :ProgramDueDate,
  PA_CANCEL_REASON_CODE = :CancelReasonCode,
  PA_REVIEW_STATUS_CODE = :ReviewStatusCode,
  PA_REVISES_SEQ_NUM = :RevisesSeqNum,
  PA_TEST_AUDIT_APPEAL_CODE = :TestAuditAppealCode,
  PA_TEST_AUDIT_RESPONSE_CODE = :TestAuditResponseCode,
  PA_TEST_AUDIT_RESULT_CODE = :TestAuditResultCode,
  PA_TEST_AUDIT_TYPE_CODE = :TestAuditTypeCode,
  PA_WAIVER_REASON_CODE = :WaiverReasonCode,
  REVIEW_DATE = :ReviewDate,
  SCHEDULING_INPROGRESS_FLAG = :SchedulingInProgressFlag,
  SELECTION_STD_PREM_AMOUNT = :SelectionStdPremAmount,
  SUBMITTED_DATE = :SubmittedDate,
  TEST_AUDITOR_NAME = :TestAuditorName,
  TEST_AUDIT_DIFFERENCE_AMOUNT = :TestAuditDifferenceAmount,
  UPDATE_DATE = :UpdateDate,
  UPDATE_USER = :UpdateUser,
  WAIVER_END_DATE = :WaiverEndDate,
  WAIVER_START_DATE = :WaiverStartDate,
  WARNING_LETTER_DATE = :WarningLetterDate,
  ASSIGNMENT_WEIGHT_COUNT = :AssignmentWeightCount,
  WORKBOOK_STATUS_CODE = :WorkbookStatusCode,
  WORKBOOK_FILE_NAME = :WorkbookFileName,
  WORKBOOK_IMAGE_SEQ_NUM = :WorkbookImageSeqNum,
  PA_STATUS_CODE = :StatusCode,
  UPDATE_SEQ_NUM = UPDATE_SEQ_NUM + 1
WHERE
  PA_AUDIT_SEQ_NUM = :AuditSeqNum
  AND UPDATE_SEQ_NUM = :UpdateSeqNum

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

• BR-020
• BR-021
• BR-032
• BR-035
• BR-036
• BR-037
• BR-057

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