fii_frs_interest: Retrieve frs interest data from fii database

Description Usage Arguments

Description

Retrieve frs interest data from fii database

Usage

1
2
3
4
5
6
7
fii_frs_interest(PGM_SYS_ACRNM = NULL, PGM_SYS_ID = NULL,
  INTEREST_TYPE = NULL, FED_STATE_CODE = NULL, START_DATE = NULL,
  START_DATE_QUALIFIER = NULL, END_DATE = NULL,
  END_DATE_QUALIFIER = NULL, SOURCE_OF_DATA = NULL,
  LAST_REPORTED_DATE = NULL, CREATE_DATE = NULL, UPDATE_DATE = NULL,
  USER_ID = NULL, SENSITIVE_IND = NULL, PUBLIC_IND = NULL,
  ACTIVE_STATUS = NULL)

Arguments

PGM_SYS_ACRNM

e.g. 'ACES'. See Details.

PGM_SYS_ID

e.g. '170001791693'. See Details.

INTEREST_TYPE

e.g. 'STATE MASTER'. See Details.

FED_STATE_CODE

e.g. 'S'. 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. 'ACES'. See Details.

LAST_REPORTED_DATE

e.g. 'NA'. See Details.

CREATE_DATE

e.g. '21-DEC-08'. See Details.

UPDATE_DATE

e.g. '24-FEB-15'. See Details.

USER_ID

e.g. 'REFRESH'. See Details.

SENSITIVE_IND

e.g. 'N'. See Details.

PUBLIC_IND

e.g. 'Y'. See Details.

ACTIVE_STATUS

e.g. 'NA'. See Details.


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