---
title: "SQL-012: clsDebitCardEnrollmentRequest insert"
summary: Inserts a debit card enrollment request record into DEBIT_CARD_ENROLLMENT_REQUEST.
status: draft
owner: SAIF
last_reviewed: 2026-07-24
library: SAIF.Business.Payment.EFT
reference_type: package
---

# SQL-012: clsDebitCardEnrollmentRequest insert

Inserts a new debit card enrollment request record with 29 parameters covering cardholder identity, address, card dates, and audit fields.

## Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-012 |
| **Operation type** | Create |
| **Execution method** | Inline SQL |
| **Database** | Oracle* |
| **Schema** | [unqualified]** |
| **Command type** | Text |
| **Business object** | `clsDebitCardEnrollmentRequest` |
| **Criteria property** | `InsertSQL` |
| **Lifecycle method** | `BeforeInsert / AfterInsert` |


## Parameters

| Parameter | Direction | Type | Max length | Description |
| --- | --- | --- | --- | --- |
| :CardholderIDNum | Input | Decimal | — | Binds `CardholderIDNum` |
| :EnrollStatusCode | Input | String | 5 | Binds `EnrollStatusCode` |
| :NewEnrollFlag | Input | String | 1 | Binds `IIf(IsNewEnrollment, "Y", "N").ToString`* |
| :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) | INSERT | ENROLL_REQUEST_SEQ_NUM, ENROLL_STATUS_CODE, NEW_ENROLL_FLAG, CARDHOLDER_ID_NUM, FULL_NAME, SECOND_FULL_NAME, CARD_ENROLL_DATE, CARD_ACTIVE_DATE, CARD_TERM_DATE, CLAIM_ADDRESS_TYPE_CODE, ADDRESS_LINE1, ADDRESS_LINE2, CITY_NAME, STATE_CODE, ZIP_CODE, CREATE_DATE, CREATE_USER, UPDATE_DATE, UPDATE_USER, UPDATE_SEQ_NUM, and more |

## Sample SQL

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

Row-count check: `If RowsAffected <> 1 Then Me.AddErrorMessage("InsertError", "Insert Failed") Else MarkOld() End If`

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

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

> **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.Payment.EFT\clsDebitCardEnrollmentRequest.vb`