Table Name: SDW_LEGAL_ENTITY
Description: Describes a person, corporation, government agency, private commission, etc.
Relationships:
- Sometimes is a one and only one SDW_GOVERNMENT_AGENCY related from col umn(s) TINLGENT_IS_NUMBER, TINLGENT_ST_CODE to columns(s) TINLGENT_IS_NU MBER, TINLGENT_ST_CODE
- Sometimes is specified for one or many SDW_WATER_SYS_LEGAL_ENT_CO NT related from column(s) TINLGENT_IS_NUMBER, TINLGENT_ST_CODE to columns(s) TINLGENT_IS_NU MBER, TINLGENT_ST_CODE
- Sometimes takes one or many SDW_SAMPLE related from column(s) TIN LGENT_IS_NUMBER, TINLGENT_ST_CODE to columns(s) TINLGENT_IS_NUMBER, TINLGENT_ST_CODE
- ADDRESS_CITY_NAME
- ADDRESS_STATE_CODE
- ADDRESS_ZIP_CODE
- ADDR_LINE_ONE_TXT
- ADDR_LINE_TWO_TXT
- ALIAS_NAME
- COUNTY_FIPS_CODE
- D_LAST_UPDT_TS
- D_USERID_CODE
- EMPLOYER_IDENT_NUM
- NAME
- PHONE_NUMBER
- STATE_FIPS_CODE
- ST_ASGN_IDENT_NUM
- TINLGENT_IS_NUMBER
- TINLGENT_ST_CODE
- TYPE_CODE
Return To:
![[logo] US EPA](http://www.epa.gov/epafiles/images/logo_epaseal.gif)