FRS Metadata
Table Name: FRS_PGM_FACILITY_HISTORY
Description: Tracks changes across times to basic identification information for a facility site, as reported by an information management system for an environmental program.
Columns:
- ADDR_TYPE
- CITY_NAME
- COUNTRY_NAME
- COUNTY_NAME
- CREATE_DATE
- DATA_QUALITY_CODE
- ENV_JUSTICE_CODE
- EPA_REGION_CODE
- FEDERAL_AGENCY_CODE
- FEDERAL_FACILITY_CODE
- FIPS_CODE
- HUC_CODE_12
- HUC_CODE_8
- LAST_REPORTED_DATE
- LEGISLATIVE_DIST_NUM
- LINK_MTHD
- LOCATION_ADDRESS
- LOCATION_DESCRIPTION
- NEW_REGISTRY_ID
- OPERATION
- PARENT_PGM_SYS_ID
- PGM_SYS_ACRNM
- PGM_SYS_ID
- POSTAL_CODE
- PRIMARY_NAME
- PUBLIC_IND
- REFRESH_DATE
- REGISTRY_ID
- SENSITIVE_IND
- SITE_TYPE_NAME
- SMALL_BUS_IND
- STATE_CODE
- STATE_NAME
- STD_BASE_NAME
- STD_CITY_NAME
- STD_COUNTRY
- STD_COUNTY_FIPS
- STD_COUNTY_NAME
- STD_FULL_ADDRESS
- STD_HOUSE_NUMBER
- STD_LOC_ADDRESS
- STD_NAME
- STD_POSTAL_CODE
- STD_PREFIX
- STD_STATE_CODE
- STD_STREET_NAME
- STD_STYPE_AFTER
- STD_STYPE_BEFORE
- STD_SUFFIX
- SUPPLEMENTAL_LOCATION
- TRANSACTION_DATE
- TRANSACTION_USER_ID
- TRIBAL_LAND_CODE
- TRIBAL_LAND_NAME
- UPDATE_DATE
- USER_COMMENT
- USER_ID