fii_frs_affiliation: Retrieve frs affiliation data from fii database

Description Usage Arguments

Description

Retrieve frs affiliation data from fii database

Usage

1
2
3
4
5
6
7
fii_frs_affiliation(AFFILIATION_UIN = NULL, PGM_SYS_ACRNM = NULL,
  PGM_SYS_ID = NULL, AFFILIATION_TYPE = NULL, START_DATE = NULL,
  END_DATE = NULL, ORG_UIN = NULL, CONTACT_UIN = NULL,
  MAIL_UIN = NULL, SOURCE_OF_DATA = NULL, LAST_REPORTED_DATE = NULL,
  CREATE_DATE = NULL, UPDATE_DATE = NULL, USER_ID = NULL,
  SENSITIVE_IND = NULL, PUBLIC_IND = NULL, SUP_INTEREST_ID = NULL,
  REGISTRY_ID = NULL)

Arguments

AFFILIATION_UIN

e.g. '2578011'. See Details.

PGM_SYS_ACRNM

e.g. 'GEIMS'. See Details.

PGM_SYS_ID

e.g. '930052'. See Details.

AFFILIATION_TYPE

e.g. 'OWNER'. See Details.

START_DATE

e.g. 'NA'. See Details.

END_DATE

e.g. 'NA'. See Details.

ORG_UIN

e.g. 'NA'. See Details.

CONTACT_UIN

e.g. '110015862342'. See Details.

MAIL_UIN

e.g. '110015862351'. See Details.

SOURCE_OF_DATA

e.g. 'GEIMS'. See Details.

LAST_REPORTED_DATE

e.g. 'NA'. See Details.

CREATE_DATE

e.g. '24-APR-03'. See Details.

UPDATE_DATE

e.g. 'NA'. See Details.

USER_ID

e.g. 'REFRESH_CON_INS'. See Details.

SENSITIVE_IND

e.g. 'NA'. See Details.

PUBLIC_IND

e.g. 'Y'. See Details.

SUP_INTEREST_ID

e.g. 'NA'. See Details.

REGISTRY_ID

e.g. 'NA'. See Details.


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