Table Description
Prospect Employer: An employer who has either supplied insufficient information to be registered as an employer participant, or alternatively, the organization does not wish to register the prospect employer as an employer participant in their system.

Example

ACME Industries employs 100 permanent staff and 30 casual staff. ACME industries trades under the name 'Global Engineering' and operates in the 'construction' industry sector.
Relationship Diagram
Click the diagram to manipulate and zoom. Traverse the diagram using Click-and-Drag motions.
Model Details
Location in Model: Logical View::MetaModel::Curam::Core::Reference Model::Concern::Entity Objects::ProspectEmployer::ProspectEmployer
Controlling File: core\model\Packages\Concern\Prospect Employer_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
LAST_UPDATED_FIELDyes
Attributes (17)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
concernRoleIDkeynoUnique reference number assigned by the system to a Concern Role record.CONCERN_ROLE_ID SVR_INT64
registeredNamedetails The name, label or Business identity associated with the Employer which is legally registered with the appropriate Government agency and through which the Employer is addressed.REGISTERED_NAME SVR_STRING<131>
tradingNamedetails The name, label or Business identity associated with the Employer and under which they trade.TRADING_NAME SVR_STRING<131>
industryTypedetails Code value to denote the core Industry in which the Employer trades.INDUSTRY_TYPE_CODEIndustryTypeSVR_STRING<10>
companyTypedetails Code value to denote the type of company.COMPANY_TYPE_CODECompanyTypeSVR_STRING<10>
businessDescdetails Free text registered which describes in detail the general nature of the business conducted by the EmployerBUSINESS_DESCRIPTION SVR_STRING<100>
specialInterestCodedetails Code value to denote a Special interest Indication.SPECIAL_INTEREST_CODESpecialInterestSVR_STRING<10>
exemptionInddetails An indicator to denote if an EOP Return is exempted or not for submission to the Organization.CURAM_INDICATOR SVR_BOOLEAN
statusCodedetails Code value to indicate the current statusRECORD_STATUS_CODERecordStatusSVR_STRING<10>
commentsdetails Free text registered by the User.COMMENTS SVR_STRING<300>
primaryAlternateIDdetails The primary alternate reference number for this employer.ALTERNATE_ID SVR_STRING<18>
numberPermanentStaffdetails An estimated number of permanent staff for the employer.NUMBER_PERMANENT_STAFF SVR_INT32
numberCasualStaffdetails An estimated number of casual staff for the employer.NUMBER_CASUAL_STAFF SVR_INT32
pinNumberdetails Employer's Personal Identification Number (PIN). This Personal Information Number allows them to identify themselves to a number of online Curam services. CUSTOMER_PIN_NUMBER SVR_STRING<4>
employerConcernRoleIDdetailsyesThe related employer concernRoleID if this entity is also been registered as an employerCONCERN_ROLE_ID SVR_INT64
upperTradingNamedetails The trading name of the Prospect Employer stored in upper case format to facilitate Prospect Employer search functionality in a case independent manner on the prospect employer's trading name.TRADING_NAME SVR_STRING<131>
upperRegisteredNamedetails The registered name of the Prospect Employer stored in upper case format to facilitate Prospect Employer search functionality in a case independent manner on the Prospect Employer's registered name.REGISTERED_NAME SVR_STRING<131>
Foreign Keys (2)
ChildParent
ProspectEmployer.concernRoleIDConcernRole.concernRoleID
ProspectEmployer.employerConcernRoleIDEmployer.concernRoleID
Indices (3)
Index NameAttributes
prospectEmployerIndexprimaryAlternateID
upperTradingNameIndex1upperTradingName
IND__1429943778employerConcernRoleID
Operations (8)
OperationStereotypeOptionsDescriptionSQL
insertinsertPOST_DATA_ACCESS: yes
PRE_DATA_ACCESS: yes
Standard Operation 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
POST_DATA_ACCESS: yes
PRE_DATA_ACCESS: yes
Standard Operation 
readSummaryDetailsnsmultiPRE_DATA_ACCESS: yes
 		Retrieves summary details, including name and address, about the specified prospect employerSQL
searchByNameOrAddressnsmultiPRE_DATA_ACCESS: yes
 		Searches the database for summary details of a prospect employer based on the key specified.SQL
removeremovePOST_DATA_ACCESS: yes
Standard Operation 
convertDetailsToUpper  Method to convert the prospect employer details to upper. 
searchByPrimaryAltIDreadmulti Returns a list of Prospect Employers by primary alternate id. 
Related Pages (112)
Register Prospect (AddProspectPerson_registerForPDCWizard)
Register Prospect (AddProspectPerson_registerWizard)
Match Client (Application_matchClientConfirmation)
Add Client (Application_registerPersonAndAddAsClient)
Register Person (Application_registerProspectPersonAsPerson)
AssessmentDelivery_details
Register Person (BenefitSample_registerPerson)
Register Person and Create Case (Case_registerPersonAndCreateIntegratedCase)
Register Person and Create Case (Case_registerPersonAndCreateIntegratedCasePDC)
Register Prospect Person and Create a Case (Case_registerProspectPersonAndCreateIntegratedCase)
Register Prospect Person and Create an Integrated Case (Case_registerProspectPersonAndCreateIntegratedCasePDC)
- (CHIPDecision_context)
Reception Contact (ClientContactWizard_issueDetails)
Add Client (CommonIntake_addClient)
CommonIntake_applicationCaseHomeContextPanel
Register Client (CommonIntake_registerClient)
Create Client Contact (Contact_register)
Create Client Contact (Contact_registerFromPersonSearch)
DefaultIC_tabDetails
DefaultIC_tabDetailsPreview
- (DefaultICProduct_tabDetails)
DefaultICProduct_tabDetailsPreview
- (EmergencyMedicaidDecision_context)
- (ESIDecision_context)
New Absent Parent Evidence (EVD_addToCaseAbsentParentEvidence_sa)
New Household Member Evidence (EVD_createHouseholdMemberEvidence_sa)
Edit Absent Parent Evidence (EVD_incomingModifyAbsentParentEvidence)
Edit Absent Parent Evidence (EVD_modifyAbsentParentEvidence)
- (ExemptionDecision_context)
Edit Alternative Identifier (ExternalParty_modifyAlternateIDFromList)
Edit Alternative Identifier (ExternalParty_modifyAlternateIDFromView)
Add Member (HCRAddMemberWizard_summary)
Register Person (ICSample_registerPerson)
Register Person (IncomeScreening_registerHouseholdMember)
Register Prospect Person (IncomeScreening_registerHouseholdProspect)
Register Person (IncomeScreening_registerPerson)
Register Prospect Person (IncomeScreening_registerProspect)
Register Person (IncomeSupportScreening_registerPerson)
Register Person (IncomeSupportScreening_registerPersonForHouseholdEvidence)
Register Prospect (IncomeSupportScreening_registerProspect)
Register Prospect (IncomeSupportScreening_registerProspectForHouseholdEvidence)
Register Prospect Person as Person (Individual_registerProspectAsPerson)
- (InsuranceAssistanceDecision_context)
Related Persons (Intake_listRelatedPerson)
Register Person (Intake_personFullRegistration)
Person Search Results (Intake_personSearchResult)
Register Prospect Person as Person (Intake_registerProspectAsPerson)
Register Client for Intake (Intake_registerProspectPerson)
Register Prospect Person as Person (Intake_registerProspectPersonAsPerson)
Register Prospect Person (Intake_registerProspectPersons)
Register Prospect Person (Intake_registerProspectPersons_Reset)
Register Prospect Person (Intake_registerProspectPersons_Reset1)
Register Prospect Person (Intake_registerProspectPersons1)
Register Person (IntakeShortCuts_registerPerson)
Add Prospect Person (IntakeShortCuts_registerProspectPerson)
IntegratedCase_tabDetails
IntegratedCase_tabDetailsPreview
- (Investigation_homeTabDetails)
Investigation_homeTabDetailsPreview
Register Person (InvestigationSample_registerPerson)
Register Person (InvestigationSample_registerPersonForPDC)
Add Household Member (ISAddMemberWizard_summaryDetails)
Register Person (ISP_registerPerson)
Basic Intake Information (ISPIntakeInformation_createFromScreening)
Re-add a Member (ISReAddMemberWizard_submit)
Register Person (LiabilitySample_registerPerson)
OutcomePlan_outcomePlanDetails
) (OutcomePlan_viewActionContextPanel)
) (OutcomePlan_viewExpectedOutcomeContextPanel)
) (OutcomePlan_viewFactorContextPanel)
) (OutcomePlanGoal_clientGoalContextPanelDetails)
) (OutcomePlanGoal_planGoalContextPanelDetails)
) (OutcomePlanReferral_viewContextPanel)
) (OutcomePlanService_viewContextPanel)
New Alternative Identifier (Participant_createAlternateID)
Merge Duplicate (Participant_mergeAlternativeIDs)
Edit Alternative Identifier (Participant_modifyAlternateID)
Edit Alternative Identifier (Participant_modifyAlternateIDFromList)
Edit Alternative Identifier (Participant_modifyAlternateIDFromView)
Register Person (Person_register)
Register Person (Person_registerForPDC)
- (ProductDelivery_tabDetails)
ProductDelivery_tabDetailsPreview
Register Prospect (Prospect_register)
Confirm Registration (Prospect_registerPersonFromProspect)
Register Employer (ProspectEmployer_duplicateCheckWizard)
Confirm Prospect Employer Not Already Registered as Employer (ProspectEmployer_duplicateEmployerRegistrationCheck)
View Prospect Employer Details (ProspectEmployer_evidenceView)
Prospect Employer (ProspectEmployer_evidenceViewObject)
Home (ProspectEmployer_home)
Edit Prospect Employer (ProspectEmployer_modifyProspectEmployer)
Register Prospect Employer as Employer (ProspectEmployer_registerAsEmployer)
Register Prospect Employer as Employer (ProspectEmployer_registerAsEmployerWizard)
Prospect Employer Home (ProspectEmployerRegisteredAsEmployer_home)
Register Prospect Person (ProspectPerson_register)
Register Prospect Person as Person (ProspectPerson_registerAsPerson)
Register Prospect Person as Person (ProspectPerson_registerAsPersonForPDCWizard)
Register Prospect Person as Person (ProspectPerson_registerAsPersonWizard)
Step 5: Register Person (ProviderManagement_duplicateRegisterPersonAsProvider)
Step 5: Register Person (ProviderManagement_registerPersonAsProvider)
Register As Person (ProviderManagement_registerProviderAsPersonFrmProviderHome)
- (ProviderManagement_viewProviderInvestigationTabDetails)
) (ProviderManagement_viewReferralSummaryDetails)
) (ProviderManagement_viewServiceSummaryDetails)
Quick Registration (Quick_register)
Register Person (RegisterPerson_registerForPDCWizard)
Register Person (RegisterPerson_registerWizard)
Application (RightsAndResponsibilitiesForCase)
Application (RightsAndResponsibilitiesForCaseSubmit)
- (StateBasicPlanDecision_context)
- (StreamlineMedicaidDecision_context)
- (UQHPDecision_context)