Relational Tables and Stars2 Objects: Applications Suggested reading: Design Document Section 19 178-188 Type Hierarchy Database Schema Note: These classes may be found in the us.oh.state.epa.stars2.database.dbObjects.application package. Applications Stars2 Object Class Database Table Important attributes Application PA_APPLICATION application_id, application_nbr, fp_id, contact_id, application_type_cd, received_date, submitted_date ApplicationEU PA_EU Application_eu_id, application_id, emu_id, corr_epa_emu_id ApplicationDocumentRef PA_APPLICATION_DOCUMENT Application_Doc_id, document_id, application_doc_type_cd, application_id, application_eu_id ApplicationNote PA_APPLICATION_NOTE_XREF, Application_id, note_id CM_NOTE DelegationRequest PA_DELEGATION, Application_id, PA_DOR_ATTACHMENTS request_type_cd PBRNotification PA_PBR_NOTIFICATION Application_id, pbr_type_cd, pbr_reason_cd PBRNotificationDocument PA_PBR_NOTIFICATION_DOCUMENT Application_id, document_id, pbr_notif_doc_type_cd PTIOApplication PA_PTIO_APPLICATION, Application_id, PA_PTIO_APP_PURPOSE_XREF, pa_ptio_app_purpose_cd, PA_PTIO_MACT_SUBPART_XREF, general_permit_type_cd PA_PTIO_NESHAPS_SUBPART_XREF, PA_PTIO_NSPS_SUBPART_XREF, PTIOApplicationEU PA_PTIO _EU, Application_eu_id, PA_PTIO_EU_PURPOSE_XREF, general_permit_type_cd, PA_PTIO_EU_FED_LIM_REASON_XREF model_general_permit_cd
Relational Tables and Stars2 Objects: Applications Suggested reading: Design Document Section 19 178-188 Type Hierarchy Database Schema Note: These classes may be found in the us.oh.state.epa.stars2.database.dbObjects.application package. Applications Stars2 Object Class Database Table Important attributes Application PA_APPLICATION application_id, application_nbr, fp_id, contact_id, application_type_cd, received_date, submitted_date ApplicationEU PA_EU Application_eu_id, application_id, emu_id, corr_epa_emu_id ApplicationDocumentRef PA_APPLICATION_DOCUMENT Application_Doc_id, document_id, application_doc_type_cd, application_id, application_eu_id ApplicationNote PA_APPLICATION_NOTE_XREF, CM_NOTE Application_id, note_id DelegationRequest PA_DELEGATION, PA_DOR_ATTACHMENTS Application_id, request_type_cd PBRNotification PA_PBR_NOTIFICATION Application_id, pbr_type_cd, pbr_reason_cd PBRNotificationDocument PA_PBR_NOTIFICATION_DOCUMENT Application_id, document_id, pbr_notif_doc_type_cd PTIOApplication PA_PTIO_APPLICATION, PA_PTIO_APP_PURPOSE_XREF, PA_PTIO_MACT_SUBPART_XREF, PA_PTIO_NESHAPS_SUBPART_XREF, PA_PTIO_NSPS_SUBPART_XREF, Application_id, pa_ptio_app_purpose_cd, general_permit_type_cd PTIOApplicationEU PA_PTIO _EU, PA_PTIO_EU_PURPOSE_XREF, PA_PTIO_EU_FED_LIM_REASON_XREF Application_eu_id, general_permit_type_cd, model_general_permit_cd
sec2_applications.docx