fii_frs_mailing_address: Retrieve frs mailing address data from fii database

Description Usage Arguments

Description

Retrieve frs mailing address data from fii database

Usage

1
2
3
4
5
6
7
fii_frs_mailing_address(MAIL_UIN = NULL, MAILING_ADDRESS = NULL,
  SUPPLEMENTAL_ADDRESS = NULL, CITY_NAME = NULL, STATE_CODE = NULL,
  STATE_NAME = NULL, POSTAL_CODE = NULL, COUNTRY_NAME = NULL,
  SOURCE_OF_DATA = NULL, LAST_REPORTED_DATE = NULL,
  STD_MAIL_ADDRESS = NULL, STD_SUPPLEMENTAL_ADDRESS = NULL,
  STD_CITY_NAME = NULL, CREATE_DATE = NULL, UPDATE_DATE = NULL,
  USER_ID = NULL, SENSITIVE_IND = NULL, PUBLIC_IND = NULL)

Arguments

MAIL_UIN

e.g. '000015308560'. See Details.

MAILING_ADDRESS

e.g. '141 ROLLINS ROAD'. See Details.

SUPPLEMENTAL_ADDRESS

e.g. 'NA'. See Details.

CITY_NAME

e.g. 'ROLLINSFORD'. See Details.

STATE_CODE

e.g. 'NH'. See Details.

STATE_NAME

e.g. 'NEW HAMPSHIRE'. See Details.

POSTAL_CODE

e.g. '03869'. See Details.

COUNTRY_NAME

e.g. 'NA'. See Details.

SOURCE_OF_DATA

e.g. 'AIRS/AFS'. See Details.

LAST_REPORTED_DATE

e.g. 'NA'. See Details.

STD_MAIL_ADDRESS

e.g. '141 ROLLINS ROAD'. See Details.

STD_SUPPLEMENTAL_ADDRESS

e.g. 'NA'. See Details.

STD_CITY_NAME

e.g. 'ROLLINSFORD'. See Details.

CREATE_DATE

e.g. '03-JUN-02'. See Details.

UPDATE_DATE

e.g. '11-MAR-10'. See Details.

USER_ID

e.g. 'REFRESH_MAI_UPD'. See Details.

SENSITIVE_IND

e.g. 'N'. See Details.

PUBLIC_IND

e.g. 'Y'. See Details.


markwh/envirofacts documentation built on May 21, 2019, 12:26 p.m.