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	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¶

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*

Business rules¶

BR-EFT-05: Insert/update 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