Skip to content

Load the legacy task code table

Loads the entire LEGACY_TASK_CODE reference table via an inline, unfiltered SELECT *.

Field Value
Operation ID OP-16
Trigger Factory call to GetLegacyTaskCodeCollection
Inputs none
Outputs Populated clsLegacyTaskCodeCollection
Primary components clsLegacyTaskCodeCollection.GetLegacyTaskCodeCollection, BeforeRetrieve, AfterRetrieve
Entry point SAIF.Business.Tasks.Claim/clsLegacyTaskCodeCollection.vb

Steps

  1. Factory builds a Criteria(dpi) and calls dpi.DataAccessLayer.RetrieveObject(criteria).
  2. BeforeRetrieve creates the data request and assigns MyCriteria.RetrieveSQL (SQL-002, LEGACY_TASK_CODE — read-only per BR-LTC-01).
  3. AfterRetrieve casts the result to IDataReader and, for each row, creates a clsLegacyTaskCode, calls Load (which Fills Create_Date, Create_User, Date_Days_Num, Legacy_Task_Code, Notepad_Flag, Task_Category_Code, Text_Days_Num, Task_Text, Update_Date, Update_User, Use_Rundate_Flag, builds a Criteria, and MarkOld()s the row), then adds it to the list.

Process flow

flowchart TD
    Start(["GetLegacyTaskCodeCollection<br>called"]) --> S1["Build Criteria,<br>RetrieveObject"]
    S1 --> S2["BeforeRetrieve assigns<br>RetrieveSQL"]
    S2 --> S3["Execute SELECT * FROM<br>legacy_task_code"]
    S3 --> Loop{For each row}
    Loop --> S4["Create clsLegacyTaskCode,<br>Load/Fill, MarkOld"]
    S4 --> Loop
    Loop -->|Done| EndOk([Populated collection])

Failure and edge-case behavior

  • No branches or error handling; the collection is read-only — all write SQL properties throw ApplicationException(clsConstants.Messages.InvalidSQLProperty) (BR-LTC-01).

Sources

  • SAIF.Business.Tasks.Claim/clsLegacyTaskCodeCollection.vb
  • SAIF.Business.Tasks.Claim/clsLegacyTaskCode.vb