Table Description

HouseholdWorkParticipation: Household Work Participation Summary Entity. >
Model Details
Location in Model: Logical View::MetaModel::Curam::IncomeSupportBI::Service Layer::Entity::Summary Table::HouseholdWorkParticipation::HouseholdWorkParticipation
Controlling File: IncomeSupportBI\model\Packages\Service Layer\Entity\Summary Table\HouseholdWorkParticipation\HouseholdWorkParticipation.efx
Attributes (14)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
creationDateTimedetailsnoDateTime when this record was created.CURAM_DATETIME SVR_DATETIME
lastUpdateddetailsnoDateTime when this record was last updated.CURAM_DATETIME SVR_DATETIME
pdCaseIDdetails The product delivery case ID.CASE_ID SVR_INT64
monthdetailsnoRepresents a calendar month - stored as a date field using the first day of the month, e.g. Jan 1 2010.  The data-mart can be used to query based on the standard calendar or the federal calendar.CURAM_DATE SVR_DATE
activeOutcomePlandetailsyesThis indicates whether outcome plan(s) are available for this unit for all work eligible’s in the unit.CURAM_INDICATOR SVR_BOOLEAN
numberOfWorkEligiblesdetails The number of work eligible people in the unit.NUMBER_OF_WORK_ELIGIBLES SVR_INT32
familyFederalCodedetails  FAMILY_FEDERAL_CODEFamilyFederalCodeSVR_STRING<10>
overAllParticipationdetails  PARTICIPATION_STATUSParticipationStatusSVR_STRING<10>
twoParentParticipationdetails  PARTICIPATION_STATUSParticipationStatusSVR_STRING<10>
disregardedFromTwoParentdetails  DISREGARD_STATUSDisregardStatusSVR_STRING<10>
disregardedFromOveralldetails  DISREGARD_STATUSDisregardStatusSVR_STRING<10>
neededEduOverAllCompliancedetails  EDUCATION_COMPONENT_NEEDEducationComponentNeedSVR_STRING<10>
neededEduTwoParentCompliancedetails  EDUCATION_COMPONENT_NEEDEducationComponentNeedSVR_STRING<10>
householdWorkParticipationIDkeyno HOUSEHOLD_WORK_PARTICIPATION_ID SVR_INT64
Indices (1)
Index NameAttributes
IND_1976184877pdCaseID
Operations (7)
OperationStereotypeOptionsDescriptionSQL
insertinsert Standard Operation 
modifymodify Standard Operation 
readread Standard Operation 
removeremove Standard Operation 
searchByPDCaseIDreadmulti This method returns the records for the given pdcaseid. 
createAllHouseHoldWorkParticipationbatchinsert Inserts the records in batch 
listHouseholdWorkParticipationRecordsnsmulti  SQL
Related Pages (0)