Table Description
PDFFormOfficeServiceAreaLink: The Citizen Portal allows a citizen to open and print a PDF form (typically an application form for one or more programs). This PDF form can either be mailed or delivered in person by the citizen to an agency office. This entity allows the definition of the local office that covers a service area for a particular type of PDF form. Citizens who reside in a particular service area can be informed of the local office to which a form should be delivered.
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::Configuration::PDFFormOfficeServiceAreaLink::PDFFormOfficeServiceAreaLink
Controlling File: WorkspaceServices\model\Packages\Entity\PDFFormOfficeServiceAreaLink\PDFFormOfficeServiceAreaLink_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (5)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
pdfFormOfficeServiceAreaLinkIDkeynoUnique identifier for this record.INTERNAL_ID SVR_INT64
pdfFormIDdetailsnoA reference to the PDF form.INTERNAL_ID SVR_INT64
locationIDdetailsnoA reference to the local office to which the PDF form should be mailed or delivered by citizens residing in the service area specified.INTERNAL_ID SVR_INT64
serviceAreaIDdetailsnoThe service area covered by the local office for the PDF form specified.INTERNAL_ID SVR_INT64
recordStatusdetails The status of the record, Active or Cancelled.RECORD_STATUSRecordStatusSVR_STRING<10>
Foreign Keys (3)
ChildParent
PDFFormOfficeServiceAreaLink.locationIDLocation.locationID
PDFFormOfficeServiceAreaLink.pdfFormIDPDFForm.pdfFormID
PDFFormOfficeServiceAreaLink.serviceAreaIDServiceArea.serviceAreaID
Indices (3)
Index NameAttributes
IND_397680892pdfFormID
IND__783641499locationID
IND_1213091976serviceAreaID
Operations (10)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: pdfFormOfficeServiceAreaLinkID
AUTO_ID_KEY: INTAKERAKS
Standard Operation 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
searchByRecordStatusreadmulti Search for links for record status. 
searchByPDFFormAndStatusreadmultiORDER_BY: locationID
Search links by pdf form and record status. The results are ordered by locationID. 
searchByLocationAndStatusreadmulti Search links by location and record status. 
searchByServiceAreaAndStatusreadmulti Search links by location and record status. 
searchByPDFFormServiceAreaStatusreadmulti Search the link table by PDF Form, Service Area and Status. 
searchByPDFFormLocationAndStatusreadmulti   
insertProgramOfficeServiceAreaLinknsinsert   
Related Pages (4)