Table Description
ProgramProductType: A relationship between a requested application program type and a CGISS product type.

Required to map the program types to the CGISS product type code table value.

Example

Cash Assistance program type is 100, Cash Assistance product type code table value is PT22.
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::Income Support Product::Service Layer::entity::IntakeApplication::ProductProgramType::ProductProgramType
Controlling File: ISProduct\model\Service Layer\entity\IntakeApplication\ProductProgramType\ProductProgramType_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (3)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
productProgramTypeIDkeynoSystem generated unique identifier for a CGISS Product Program Type record.INTERNAL_ID SVR_INT64
productTypeCodedetailsnoThe type code value for a specific product which is specified in the ProductType codetable.PRODUCT_TYPE_CODEProductTypeSVR_STRING<10>
programTypeIDdetailsnoThe unique identifier for an Intake Program Type record.PROGRAM_TYPE_ID SVR_INT64
Foreign Keys (1)
ChildParent
ProductProgramType.programTypeIDProgramType.programTypeID
Indices (1)
Index NameAttributes
productProgramTypeIdxprogramTypeID
Operations (4)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: productProgramTypeID
Standard Operation 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
readByProgramTypeIDnsread This method returns the details for a specific program type ID 
Related Pages (16)