fii_frs_organization: Retrieve frs organization data from fii database

Description Usage Arguments

Description

Retrieve frs organization data from fii database

Usage

1
2
3
4
5
6
7
fii_frs_organization(ORG_UIN = NULL, ORG_NAME = NULL,
  STD_ORG_NAME = NULL, ORG_TYPE = NULL, DUNS_NUMBER = NULL,
  DIVISION_NAME = NULL, PHONE_NUMBER = NULL, ALTERNATE_PHONE = NULL,
  FAX_NUMBER = NULL, EMAIL_ADDRESS = NULL, EIN = NULL,
  STATE_BUSINESS_ID = NULL, SOURCE_OF_DATA = NULL,
  LAST_REPORTED_DATE = NULL, CREATE_DATE = NULL, UPDATE_DATE = NULL,
  SENSITIVE_IND = NULL, USER_ID = NULL, PUBLIC_IND = NULL)

Arguments

ORG_UIN

e.g. '000014958995'. See Details.

ORG_NAME

e.g. 'CALUMET OIL COMPANY'. See Details.

STD_ORG_NAME

e.g. 'CALUMET OIL COMPANY'. See Details.

ORG_TYPE

e.g. 'NA'. See Details.

DUNS_NUMBER

e.g. 'NA'. See Details.

DIVISION_NAME

e.g. 'NA'. See Details.

PHONE_NUMBER

e.g. '9187493606'. See Details.

ALTERNATE_PHONE

e.g. 'NA'. See Details.

FAX_NUMBER

e.g. 'NA'. See Details.

EMAIL_ADDRESS

e.g. 'NA'. See Details.

EIN

e.g. 'NA'. See Details.

STATE_BUSINESS_ID

e.g. 'NA'. See Details.

SOURCE_OF_DATA

e.g. 'ICIS'. See Details.

LAST_REPORTED_DATE

e.g. '11-JAN-05'. See Details.

CREATE_DATE

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

UPDATE_DATE

e.g. '20-JAN-05'. See Details.

SENSITIVE_IND

e.g. 'N'. See Details.

USER_ID

e.g. 'REFRESH_ORG_UPD'. See Details.

PUBLIC_IND

e.g. 'Y'. See Details.


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