SQL-019: Pk82350 eft isauthorizedforeft

This document describes SQL-019, the pk82350 eft isauthorizedforeft statement or call used by SAIF.Business.

Classification

Field	Value
SQL ID	SQL-019
Operation type	Read
Execution method	Stored procedure
Database	Oracle
Schema	WCIS_DBA
Command type	StoredProcedure
Business object	ClaimServices
Criteria property	N/A
Lifecycle method	worker/person EFT auth overloads

Parameters

Parameter	Direction	Type	Max length	Description
:inclaimnum	Input	String	8	Optional claim-number overload parameter.

Table	Access	Columns used
PAYMENT_AUTHORIZATION	SELECT	CUSTOMER_SECOND_ID, CUSTOMER_TYPE_CODE, AUTHORIZATION_TYPE_CODE, AUTH_DATE, REVOKE_DATE, BANK_ACCOUNT_SEQ_NUM, PAYMENT_AUTHORIZATION_SEQ_NUM

Sample SQL

pk82350_eft.isauthorizedforeft(:inclaimid|:inclaimnum, :inpersonid?, :inauthtypecode, :indate, :PARMOUT)

Operations and processes

• Claim authorization and visibility checks
• EFT authorization support

Business rules

• PROC-RULE-016: Pending-inclusive authorization checks bypass bank-account status and prenote gating.
• PROC-RULE-017: Non-pending authorization checks require an active bank account and successful prenote when prenote is required.
• PROC-RULE-018: Beneficiary EFT authorizations must be effective, unreversed, and backed by an active bank account.
• PROC-RULE-019: Provider EFT authorization checks use the same pending-versus-active gating as person authorization checks.
• PROC-RULE-020: Active-authorization counts honor the same pending and prenote rules as sequence lookups.
• PROC-RULE-021: Only non-terminated debit card enrollments count as active enrollments.

Sources

• Business\SAIF.Business\ClaimServices.vb