SQL-044: clsDebitCardEnrollmentRequestCollection retrieve

Retrieves debit card enrollment requests filtered by cardholder ID, enrollment status, and new enrollment flag.

Classification

Field	Value
SQL ID	SQL-044
Operation type	Read
Execution method	Inline SQL
Database	Oracle*
Schema	[unqualified]**
Command type	Text
Business object	clsDebitCardEnrollmentRequestCollection
Criteria property	RetrieveSQL
Lifecycle method	BeforeRetrieve / AfterRetrieve

Parameters

Parameter	Direction	Type	Max length	Description
:CardholderIDNum\	Input	Decimal	—	Binds \MyCriteria.CardholderIDNum*
:EnrollStatusCode\	Input	String	5	Binds \MyCriteria.EnrollStatusCode*
:NewEnrollFlag\	Input	String	1	Binds \MyCriteria.NewEnrollFlag*

Tables

Table	Access	Columns used
DEBIT_CARD_ENROLLMENT_REQUEST	—	—

Sample SQL

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

Note: the WHERE clause is built conditionally at runtime — each of the three predicates (CARDHOLDER_ID_NUM, ENROLL_STATUS_CODE, NEW_ENROLL_FLAG) is included only when the corresponding criteria property is populated, and the trailing AND/WHERE is trimmed when unused.*

Operations and processes

• Debit card enrollment*

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\clsDebitCardEnrollmentRequestCollection.vb