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
Sample 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
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
Sources
Business\SAIF.Business.Payment.EFT\clsDebitCardEnrollmentRequest.vb