Table Description
ISP Eligibility Date Range Processing: A date range for each eligibility determination request for a case.

The eligibility date range processing entity is used to store the date ranges for each eligibility determination request. Each entry represents a date range for one iteration of the eligibility determination process.

Example

An eligibility determination request is initiated to check eligibility for all medical assistance programs on an integrated case for the current system date. In this instance a single record is inserted with a from and to date equal to the current system date.

A retroactive eligibility determination request is initiated to check eligibility for all medical assistance programs on an integrated case for 3 retroactive periods based on an initial request of 1-April-2005. In this instance 3 records are inserted for each of the 3 retroactive periods with from and to date ranges of 1-Jan-2005 to 31-Jan-2005, 1-Feb-2005 to 28-Feb-2005 and 1-Mar-2005 to 31-Mar-2005 respectively. The eligibility determination processing will then iterate through each of the date ranges to determine household eligibility for each of the requested date ranges.

Model Details
Location in Model: Logical View::MetaModel::Curam::Income Support Product::Service Layer::entity::Processing::ISPEligibilityDateRangeProc::ISPEligibilityDateRangeProc
Controlling File: ISProduct\model\Service Layer\entity\Processing\ISPEligibilityDateRangeProc\ISPEligibilityDateRangeProc_cat.efx
Attributes (5)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
eligibilityDateRangeIDkeynoSystem generated unique identifier for an ISPEligibilityDateRangeProc.INTERNAL_ID SVR_INT64
requestInstanceIdentifierdetails System generated unique identifier used in ISPEligibilityDateRangeProc record processing.INTERNAL_ID SVR_INT64
currentPeriodCountdetails A loop count variable for the Eligibility Date Range.COUNT SVR_INT64
toDatedetails Latest date in Eligibility Date Range.CURAM_DATE SVR_DATE
fromDatedetails Earliest date in Eligibility Date Range.CURAM_DATE SVR_DATE
Indices (2)
Index NameAttributes
IND__2071509716requestInstanceIdentifier
IND__1129582506currentPeriodCount
Operations (5)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: eligibilityDateRangeID
Standard Operation 
readread Standard Operation 
modifymodify Standard Operation 
readDetailsByReqInstanceIdentifierAndCurrentCountnsread Reads one row of details keyed by the requestInstanceIdentifier and the currentPeriodCount. 
readMaxCurrentPeriodCountByReqInstIdentifiernsNO_SQL: no
 
Returns the max value of currentPeriodCount field for the provided requestInstanceIdentifier.SQL
Related Pages (14)