![[logo] US EPA](http://www.epa.gov/epafiles/images/logo_epaseal.gif){kind=logo}
Table Name: FRS_AFFILIATION
Description: The relationship between a facility site and an organization and/or an individual person.
Relationships:
- May involve one and only one FRS_ORGANIZATION related by column ORG_UIN
- May involve one and only one FRS_CONTACT related by column CONTACT_UIN
- May receive mail at one and only one FRS_MAILING_ADDRESS related by column MAIL_UIN
- May be associated with one and only one FRS_INTEREST related by columns PGM_SYS_ACRNM, PGM_SYS_ID, INTEREST_TYPE
- May be associated with one and only one FRS_SUPPLEMENTAL_INTEREST related by column FRS_SUB_INTEREST_ID
- AFFILIATION_TYPE
- CONTACT_UIN
- CREATE_DATE
- END_DATE
- INTEREST_TYPE
- LAST_REPORTED_DATE
- MAIL_UIN
- ORG_UIN
- PGM_SYS_ACRNM
- PGM_SYS_ID
- PUBLIC_IND
- SENSITIVE_IND
- SOURCE_OF_DATA
- START_DATE
- SUP_INTEREST_ID
- UPDATE_DATE
- USER_ID
Return To: