Table Description
Trading Status: The status of trading of a concern role at any one time over the lifetime of their registration with the organization.
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::TradingStatus::TradingStatus
Controlling File: core\model\Packages\Concern\TradingStatus_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (6)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
concernRoleIDdetailsnoUnique reference number assigned by the system to a Concern Role record.CONCERN_ROLE_ID SVR_INT64
startDatedetails Date on which the Employer commenced trading for that Trading NameCURAM_DATE SVR_DATE
endDatedetails Date on which the Employer ceased trading for that trading nameCURAM_DATE SVR_DATE
statusCodedetails Code value to denote the Trading Status of the Employer.RECORD_STATUS_CODERecordStatusSVR_STRING<10>
tradingStatusIDkeynoUnique reference number assigned by the systemTRADING_STATUS_ID SVR_INT64
tradingStatusCodedetails The code value that displays the current status of the TradingStatus recordTRADING_STATUS_CODETradingStatusSVR_STRING<10>
Foreign Keys (1)
ChildParent
TradingStatus.concernRoleIDConcernRole.concernRoleID
Indices (2)
Index NameAttributes
TradingStatusIndexconcernRoleID, statusCode, endDate, startDate
IND_1765360660tradingStatusCode
Operations (9)
OperationStereotypeOptionsDescriptionSQL
insertinsert Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
readread Standard Operation 
searchStatusByConcernRolensreadmulti Retrieves a list of trading status details for the specified employer. 
searchForDuplicateStatusnsmulti This method will search for a duplicate trading status based on the status and the dates of the trading statusSQL
searchForStatusByConcernRolensreadmulti Searches for all instances of a specified trading status for a specified concern role. 
readByDateForConcernRoleIDns Searches for the trading status record based on the concern role ID for a particular dateSQL
searchActiveStatusByConcernRolensreadmulti Retrieves a list of active trading status details for the specified employer. 
readLatestClosedRecordForConcernRoleAndStatusns This method returns the trading status record with the latest end date for the given concern role id and status code.SQL
Related Pages (39)
Add Prospect Employer (AddProspectEmployer_registerWizard)
Sample Benefit Overpayment Evidence (BenefitSampleOverpayment_viewEvidence)
Add Member (CHIPProduct_addAssistanceGroupMember)
Confirm Benefit Group Member (CHIPProduct_confirmAddBenefitGroupMember)
Remove Member (CHIPProduct_removeAssistanceGroupMember)
Remove Member (CHIPProduct_removeBenefitGroupMember)
Program Summary (Eligibility_createProgram)
Delete Trading Status (Employer_cancelTradingStatus)
New Trading Status (Employer_createTradingStatus)
Employer_homeDetails
Employer_homeDetailsPreview
Trading Status (Employer_listTradingStatus)
Edit Trading Status (Employer_modifyTradingStatusFromList)
Edit Trading Status (Employer_modifyTradingStatusFromView)
Register Employer (Employer_register)
View Trading Status (Employer_viewTradingStatus)
Check Retroactive Medicaid Eligibility (HCRRetroactiveMedicaid_confirmCheckEligibilty)
Renew Program (ISP_confirmProgramRenewal)
Retroactive Program Summary (ISP_createRetroactiveProgram)
Renew Program (ISP_renewProductDeliveryConfirmation)
New Certification (ISPProduct_createCertification)
Edit Certification (ISPProduct_modifyCertificationFromList)
Edit Certification (ISPProduct_modifyCertificationFromView)
Medical Assistance with Spend Down Program Summary (ISPSpendDown_createProgram)
Create Program (ISPSpendDown_createRetroactiveProgram)
End Deduction (Participant_endDeduction)
New Certification (ProductDelivery_createCertification)
Edit Certification (ProductDelivery_modifyCertificationFromList)
Edit Certification (ProductDelivery_modifyCertificationFromView)
Authorize (ProgramRecommendation_confirmAuthorize)
Authorize (ProgramRecommendation_listHouseholdMembersForMA)
Register Employer (ProspectEmployer_duplicateCheckWizard)
Home (ProspectEmployer_homeTabDetails)
ProspectEmployer_homeTabDetailsPreview
Trading Status (ProspectEmployer_listTradingStatus)
Register Prospect Employer (ProspectEmployer_register)
Register Prospect Employer as Employer (ProspectEmployer_registerAsEmployer)
Register Prospect Employer as Employer (ProspectEmployer_registerAsEmployerWizard)
Register Employer (RegisterEmployer_registerWizard)