Table Name: FRS_INTEREST
Description: The environmental permits and regulatory programs that apply to the facility site.
Relationships:
- May be classified by one or more FRS_NAICSs related by columns PGM_SYS_ACRNM, PGM_SYS_ID, INTEREST_TYPE
- May be classified by one or more FRS_SICs related by columns PGM_SYS_ACRNM, PGM_SYS_ID, INTEREST_TYPE
- May be involved with one or more FRS_AFFILIATIONs related by columns PGM_SYS_ACRNM, PGM_SYS_ID, INTEREST_TYPE
- May include one or more FRS_SUPPLEMENTAL_INTERESTs related by columns PGM_SYS_ACRNM, PGM_SYS_ID, INTEREST_TYPE
- May serve one or more FRS_SERVICE_AREAs related by columns PGM_SYS_ACRNM, PGM_SYS_ID, INTEREST_TYPE
- Must apply to one and only one FRS_FACILITY_SITE related by column REGISTRY_ID
- Must be described by one and only one FRS_INTEREST_REF related by column INTEREST_TYPE
- Must be tracked by one and only one FRS_SYSTEM_REF related by column PGM_SYS_ACRNM
- May reference one or more FRS_ALTERNATIVE_IDs related by columns PGM_SYS_ACRNM, PGM_SYS_ID
- May reference one or more FRS_ALT_NAMEs related by columns PGM_SYS_ACRNM, PGM_SYS_ID
- ACTIVE_CODE
- COMPLIANCE_IND
- CREATE_DATE
- END_DATE
- END_DATE_QUALIFIER
- FED_STATE_CODE
- INTEREST_TYPE
- LAST_REPORTED_DATE
- LINK_METHOD
- PGM_SYS_ACRNM
- PGM_SYS_ID
- PUBLIC_IND
- REFRESH_DATE
- REGISTRY_ID
- SENSITIVE_IND
- SOURCE_OF_DATA
- START_DATE
- START_DATE_QUALIFIER
- UPDATE_DATE
- USER_ID
Return To: