Table Description
Code Table Header: A lookup table which maps codes stored in various database columns to textual descriptions of those codes.

Curam allows a level of indirection when storing commonly-used values on the database. A short code is stored on the database column, and a code table is used to translate this short code into a textual description appropriate for a user. Code tables can be customized to allow different localized translations to be available.

Each translation for a Code Table Header is stored as a Code Table Item. A Code Table Header may specify one code as the default for the code table.

Example

User Ronan Rooney (an English-speaker) opens a screen which instructs him to choose a weekday from a list. The screen presents the list Monday, Tuesday, Wednesday, Thursday and Friday. Ronan Rooney chooses Wednesday and Curam stores his choice as the code DAY3.

User Pierre (a French-speaker) opens the same screen but is presented with the list `Lundi`, `Mardi`, `Mercredi`, `Jeudi`, and `Vendredi`. Pierre chooses `Mercredi` (= Wednesday) and Curam stores his choice as the code DAY3.

Technical Notes

The timeEntered column is used to implement a caching mechanism between the Curam client and server.

For more information see the Curam Server Developer's Guide.

Relationship Diagram
Click the diagram to manipulate and zoom. Traverse the diagram using Click-and-Drag motions.
Attributes (6)
AttributeKeyNullableDescriptionDDL Type
tableNameYesNoThe name of the code table.SVR_STRING<25>
timeEntered NoA timestamp for synchronization purposes. The caching system requires that this field is not null.SVR_DATETIME
defaultCode  The default code of the code table.SVR_STRING<10>
parentCodetable  The name of the parent codetable in the hierarchy. This value is optional.SVR_STRING<25>
versionNo No SVR_INT32
lastWritten   SVR_DATETIME
Foreign Keys (3)
ChildParent
CodeTableItem.tableNameCodeTableHeader.tableName
CodeTableViewCode.tableNameCodeTableHeader.tableName
CodeTableView.tableNameCodeTableHeader.tableName
Indices (1)
Index NameAttributes
IND__1196241434parentCodetable
Related Pages (110)
Home (AdminCustomHome)
Application Search (Application_searchPopup)
Compare (AssessmentDelivery_compareAssessments)
Compare (AssessmentDelivery_compareAssessmentsModal)
Answers (AssessmentDelivery_viewAssessmentAnswersFromAssessmentHome)
Home (AssessmentDelivery_viewAssessmentAnswersFromInstanceHome)
Home (AuditCoordinatorCustomHome)
Home (AuditorCustomHome)
Home (CaseworkerCustomHome)
CGISSEligibilityWorkerHome
CGISSIntakeWorkerHome
CGISSIntakeWorkerSupervisorHome
CombinedWorkerHome
CommonIntake_applicationCaseSearch
New Application Case (CommonIntake_createApplicationCaseForConcernRole)
New Referral (CommonIntake_createReferralApplicationCaseForConcernRole)
Edit Application (CommonIntake_editApplicationCase)
Edit Withdrawal (CommonIntake_editProgramOnlineWithdrawal)
Edit Withdrawal (CommonIntake_editProgramWithdrawal)
Withdrawal Details (CommonIntake_readProgramWithdrawal)
CommonIntake_referralCaseSearch
Withdraw Program (CommonIntake_withdrawProgram)
Home (CommonIntakeApplication_home)
My Home Page (CustomHome)
My Personal Page (CustomPods)
Related Cases (DefaultIC_listCaseRelationship)
Map code table values for mapped attributes (EBMappingConfig_addCodeTableMapping)
Add Attribute Mapping (EBMappingConfig_addNonIdenticalAttributeMapping)
Remove Code Table Mappings (EBMappingConfig_removeCodeTableMappings)
Code Table Mapping Details (EBMappingConfig_viewAttributeCodetTableMapping)
Attribute Mapped Between Evidence Type (EBMappingConfig_viewNonIdenticalAttributeMapping)
EligibilityWorkerHome
New Countable Assistance History Evidence (EVD_addToCaseCountableAssistanceHistoryEvidence_sa)
New Exemption Evidence (EVD_addToCaseExemptionEvidence_sa)
New Extension Evidence (EVD_addToCaseExtensionEvidence_sa)
Edit Countable Assistance History Evidence (EVD_incomingModifyCountableAssistanceHistoryEvidence)
Edit Exemption Evidence (EVD_incomingModifyExemptionEvidence)
Edit Extension Evidence (EVD_incomingModifyExtensionEvidence)
Edit Countable Assistance History Evidence (EVD_modifyCountableAssistanceHistoryEvidence)
Edit Exemption Evidence (EVD_modifyExemptionEvidence)
Edit Extension Evidence (EVD_modifyExtensionEvidence)
View Countable Assistance History Evidence (EVD_viewCountableAssistanceHistoryEvidence)
View Countable Assistance History Evidence (EVD_viewCountableAssistanceHistoryEvidenceHistRec)
Home (EVD_viewCountableAssistanceHistoryEvidenceObject)
View Countable Assistance History Evidence (EVD_viewCountableAssistanceHistoryEvidenceSnapshot)
View Exemption Evidence (EVD_viewExemptionEvidence)
View Exemption Evidence (EVD_viewExemptionEvidenceHistRec)
Home (EVD_viewExemptionEvidenceObject)
View Exemption Evidence (EVD_viewExemptionEvidenceSnapshot)
View Extension Evidence (EVD_viewExtensionEvidence)
View Extension Evidence (EVD_viewExtensionEvidenceHistRec)
Home (EVD_viewExtensionEvidenceObject)
View Extension Evidence (EVD_viewExtensionEvidenceSnapshot)
New Non-Identical Evidence Sharing (EvidenceBroker_createNonIdenticalAttributeConfig)
FacilityManagerCustomHome
Home (FinancialCustomHome)
Home (FundPMCustomHome)
Home (HearingOfficialCustomHome)
Home (HearingReviewerCustomHome)
Home (HearingSchedulerCustomHome)
and (IncomeSupportScreening_cancelISHouseholdRshipEvidence)
and (IncomeSupportScreening_cancelISHouseholdRshipEvidenceFromCreate)
and (IncomeSupportScreening_cancelISHouseholdRshipEvidenceFromList)
and (IncomeSupportScreening_modifyISHouseholdRshipEvidence)
and (IncomeSupportScreening_modifyISHouseholdRshipEvidenceFromCreate)
and (IncomeSupportScreening_modifyISHouseholdRshipEvidenceFromList)
IntakeWorkerHome
IntakeWorkerSupervisorHome
Home (InvestigatorCustomHome)
Home (OutcomePlanApplication_home)
OutcomesApplicationHome
OutcomesSupervisorApplicationHome
New Product (Product_benefitWizardCreate)
New Product (Product_createBenefitWizard)
New Product (Product_createLiabilityWizard)
New Scores (ProviderManagement_addResponseScore)
ReceptionManagementHome
ResourceManagerCustomHome
Home (ResourceManagerSupervisorCustomHome)
Edit Sanction (SanctionAssessment_modifySanction)
Edit Recommendation Disregard (SanctionAssessment_modifySanctionOverride)
SanctionAssessment_viewSanction
View Member Sanction Override Details (SanctionAssessment_viewSanctionOverride)
My Home Page (SupervisorCustomHome)
Home (SysAdminCustomHome)
Add Localizable Text (System_addCodeTableItemFunctionalName)
Delete Code Table (System_cancelCodetable)
Delete Code Table Item (System_cancelCodetableItem)
System_codetableSearch
New Code Table (System_createCodetable)
New Code Table Item (System_createCodetableItem)
Edit Text Translation (System_editCTItemLocalizableDescText)
Alter Code Table Item Visibility (System_hideCodetableItemFromList)
System_listCodetable
Available Child Codes (System_modifyChildrenCodePopup)
Change Code Table Default (System_modifyCodetableDefault)
Edit Item (System_modifyCodetableItemFromList)
Edit Item (System_modifyCodetableItemFromView)
Edit Code Table (System_modifyCodetableNameFromList)
Edit Code Table (System_modifyCodetableNameFromView)
Change Parent Code (System_modifyParentCodePopup)
Delete translation: (System_removeCTItemFunctionalName)
System_viewCodetable
System_viewCodetableHierarchy
System_viewCodetablesInHierarchy
Code Table (System_viewHierarchyCodetableDetails)
View Code Table Item (System_viewHierarchyCodetableItemDetails)
New Product (Wizard_benefitProduct)
New Product (Wizard_liabilityProduct)
Add Zip Codes (WorkspaceServices_addZipToServiceArea)