---
title: "SQL-080: clsDebitCardEnrollmentRequest update"
summary: Updates a debit card enrollment request record in DEBIT_CARD_ENROLLMENT_REQUEST.
status: draft
owner: SAIF
last_reviewed: 2026-07-24
library: SAIF.Business.Payment.EFT
reference_type: package
---

# SQL-080: clsDebitCardEnrollmentRequest update

Updates a debit card enrollment request record in DEBIT_CARD_ENROLLMENT_REQUEST.

## Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-080 |
| **Operation type** | Update |
| **Execution method** | Inline SQL |
| **Database** | Oracle* |
| **Schema** | [unqualified]** |
| **Command type** | Text |
| **Business object** | `clsDebitCardEnrollmentRequest` |
| **Criteria property** | `UpdateSQL` |
| **Lifecycle method** | `BeforeUpdate / AfterUpdate` |


## Parameters

| Parameter | Direction | Type | Max length | Description |
| --- | --- | --- | --- | --- |
| :EnrollStatusCode | Input | String | 5 | Binds `EnrollStatusCode` |
| :NewEnrollFlag | Input | String | 1 | Binds `IIf(IsNewEnrollment, "Y", "N").ToString`* |
| :CardholderIDNum | Input | Decimal | — | Binds `CardholderIDNum` |
| :CreateDate | Input | Date | — | Binds `CreateDate` |
| :CreateUser | Input | String | 30 | Binds `CreateUser` |
| :UpdateDate | Input | Date | — | Binds `UpdateDate` |
| :UpdateUser | Input | String | 30 | Binds `UpdateUser` |
| :UpdateSeqNum | Input | Decimal | — | Binds `UpdateSeqNum` |
| :FullName | Input | String | 50 | Binds `m_FullName`* |
| :SecondFullName | Input | String | 50 | Binds `m_SecondFullName`* |
| :CardEnrollDate | Input | Date | — | Binds `m_CardEnrollDate`* |
| :CardActiveDate | Input | Date | — | Binds `m_CardActiveDate`* |
| :CardTerminationDate | Input | Date | — | Binds `m_CardTerminationDate`* |
| :ClaimAddressTypeCode | Input | String | 5 | Binds `m_ClaimAddressTypeCode`* |
| :ClaimAddressUpdateDate | Input | Date | — | Binds `m_ClaimAddressUpdateDate`* |
| :ClaimPersonUpdateDate | Input | Date | — | Binds `m_ClaimPersonUpdateDate` |
| :AddressLine1 | Input | String | 40 | Binds `m_AddressLine1`* |
| :AddressLine2 | Input | String | 40 | Binds `m_AddressLine2`* |
| :CityName | Input | String | 30 | Binds `m_CityName`* |
| :StateCode | Input | String | 2 | Binds `m_StateCode`* |
| :ZipCode | Input | String | 5 | Binds `m_ZipCode`* |
| :ZipCodeExt | Input | String | 4 | Binds `m_ZipCodeExt`* |
| :IsoCountryCode | Input | String | 3 | Binds `m_IsoCountryCode`* |
| :HomePhoneNum | Input | String | 23 | Binds `m_HomePhoneNum`* |
| :BirthDate | Input | Date | — | Binds `m_BirthDate`* |
| :PrimaryTaxID | Input | String | 50 | Binds `m_PrimaryTaxID`* |
| :ParticipantID | Input | String | 10 | Binds `m_ParticipantID`* |
| :EnrollRequestSeqNum | Input | Long | — | Binds `EnrollRequestSeqNum` |

## Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [DEBIT_CARD_ENROLLMENT_REQUEST](../database-tables.md#debit_card_enrollment_request) | Write | — |

## Sample SQL

```sql
Update DEBIT_CARD_ENROLLMENT_REQUEST
Set ENROLL_STATUS_CODE = :EnrollStatusCode,
  NEW_ENROLL_FLAG = :NewEnrollFlag,
  CARDHOLDER_ID_NUM = :CardholderIDNum,
  FULL_NAME = :FullName,
  SECOND_FULL_NAME = :SecondFullName,
  CARD_ENROLL_DATE = :CardEnrollDate,
  CARD_ACTIVE_DATE = :CardActiveDate,
  CARD_TERM_DATE = :CardTerminationDate,
  CLAIM_ADDRESS_TYPE_CODE = :ClaimAddressTypeCode,
  CLAIM_ADDRESS_UPDATE_DATE = :ClaimAddressUpdateDate,
  CLAIM_PERSON_UPDATE_DATE = :ClaimPersonUpdateDate,
  ADDRESS_LINE1 = :AddressLine1,
  ADDRESS_LINE2 = :AddressLine2,
  CITY_NAME = :CityName,
  STATE_CODE = :StateCode,
  ZIP_CODE = :ZipCode,
  ZIP_CODE_EXT = :ZipCodeExt,
  ISO_COUNTRY_CODE = :IsoCountryCode,
  HOME_PHONE_NUM = :HomePhoneNum,
  BIRTH_DATE = :BirthDate,
  PRIMARY_TAX_ID = :PrimaryTaxID,
  PARTICIPANT_ID = :ParticipantID,
  CREATE_DATE = :CreateDate,
  CREATE_USER = :CreateUser,
  UPDATE_DATE = :UpdateDate,
  UPDATE_USER = :UpdateUser,
  UPDATE_SEQ_NUM = :UpdateSeqNum
Where ENROLL_REQUEST_SEQ_NUM = :EnrollRequestSeqNum
```

## Operations and processes
- [Debit card enrollment](../operations/debit-card-enrollment.md)*

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

## Business rules
- [BR-EFT-05: Insert/update must affect exactly 1 row](../business-rules.md#br-eft-05-insertupdate-operations-require-exactly-one-affected-row)

## Sources
- `Business\SAIF.Business.Payment.EFT\clsDebitCardEnrollmentRequest.vb`