Table Description
ProgramOfficeServiceAreaLink: This entity allows the definition of the local office that covers a service area for a particular program. Citizens who reside in a particular service area can be informed of the local office that they should contact to apply for or find out more information about a particular program.
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::WorkspaceServices::Entity::Intake::ProgramOfficeServiceAreaLink::ProgramOfficeServiceAreaLink
Controlling File: WorkspaceServices\model\Packages\Entity\ProgramOfficeServiceAreaLink\ProgramOfficeServiceAreaLink_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (5)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
programOfficeServiceAreaLinkIDkeynoUnique identifier for this record.INTERNAL_ID SVR_INT64
programTypeIDdetailsnoA reference to the program that is served by the local office for the defined service area.INTERNAL_ID SVR_INT64
locationIDdetailsnoA reference to the local office that covers the program fro the specified service area.INTERNAL_ID SVR_INT64
serviceAreaIDdetailsnoA reference to the service area that is covered by the local office for the specified program.INTERNAL_ID SVR_INT64
recordStatusdetails The status of the record, Active or Cancelled.RECORD_STATUS_CODERecordStatusSVR_STRING<10>
Foreign Keys (3)
ChildParent
ProgramOfficeServiceAreaLink.locationIDLocation.locationID
ProgramOfficeServiceAreaLink.programTypeIDProgramType.programTypeID
ProgramOfficeServiceAreaLink.serviceAreaIDServiceArea.serviceAreaID
Indices (3)
Index NameAttributes
IND__134213610programTypeID
IND__1785194989locationID
IND_1070876698serviceAreaID
Operations (9)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: programOfficeServiceAreaLinkID
AUTO_ID_KEY: INTAKERAKS
Standard Operation 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
searchByRecordStatusreadmultiORDER_BY: programOfficeServiceAreaLinkID
Returns a list of ProgramOfficeServiceAreaLink records for a specified recordStatus. 
searchByProgramTypeIDStatusreadmultiORDER_BY: locationID
Returns a list of ProgramOfficeServiceAreaLink records for a specified program and recordStatus. 
searchByLocationIDStatusreadmulti Returns a list of ProgramOfficeServiceAreaLink records for a specified location and recordStatus. 
searchByServiceAreaIDStatusreadmulti Returns a list of ProgramOfficeServiceAreaLink records for a specified serviceArea and recordStatus. 
searchByProgramTypeIDLocationIDStatusreadmulti Returns a list of ProgramOfficeServiceAreaLink records for a specified program and local office. 
insertProgramOfficeServiceAreaLinknsinsert   
Related Pages (10)