fii_frs_supplemental_interest: Retrieve frs supplemental interest data from fii database

Description Usage Arguments

Description

Retrieve frs supplemental interest data from fii database

Usage

1
2
3
4
5
6
7
8
fii_frs_supplemental_interest(SUP_INTEREST_ID = NULL,
  PGM_SYS_ACRNM = NULL, PGM_SYS_ID = NULL, SUP_PGM_SYS_ACRNM = NULL,
  SUP_PGM_SYS_ID = NULL, SUP_INTEREST_TYPE = NULL, START_DATE = NULL,
  START_DATE_QUALIFIER = NULL, END_DATE = NULL,
  END_DATE_QUALIFIER = NULL, SOURCE_OF_DATA = NULL,
  LAST_REPORTED_DATE = NULL, REPORTED_SUP_INTEREST_TYPE = NULL,
  CREATE_DATE = NULL, UPDATE_DATE = NULL, USER_ID = NULL,
  SENSITIVE_IND = NULL, PUBLIC_IND = NULL)

Arguments

SUP_INTEREST_ID

e.g. '301676'. See Details.

PGM_SYS_ACRNM

e.g. 'OH-CORE'. See Details.

PGM_SYS_ID

e.g. '47847'. See Details.

SUP_PGM_SYS_ACRNM

e.g. 'NA'. See Details.

SUP_PGM_SYS_ID

e.g. '18-5541-166-2'. See Details.

SUP_INTEREST_TYPE

e.g. 'EPCRA'. See Details.

START_DATE

e.g. 'NA'. See Details.

START_DATE_QUALIFIER

e.g. 'NA'. See Details.

END_DATE

e.g. 'NA'. See Details.

END_DATE_QUALIFIER

e.g. 'NA'. See Details.

SOURCE_OF_DATA

e.g. 'OH-CORE'. See Details.

LAST_REPORTED_DATE

e.g. 'NA'. See Details.

REPORTED_SUP_INTEREST_TYPE

e.g. 'STATE RTK REPORTER'. See Details.

CREATE_DATE

e.g. '17-AUG-01'. See Details.

UPDATE_DATE

e.g. '17-OCT-12'. See Details.

USER_ID

e.g. 'FRS'. 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.