LookupListAddEntryWithDurationAndClientID

Note: This function is available for use in sub-tenancy environments only.

Syntax: LookupListAddEntryWithDurationAndClientID(TableName, Key, Value, Comment, StartDateFromNow, EndDuration, ClientID)

Arguments:

  • TableName is the Lookup List table name.
  • Key is the key column in the table.
  • Value is the value for that Key. The value must be in all capital letters.
    See Also: Refer to the table in Card Integration Rule Example for information on possible values for the Value string.
  • Comment is the string value for comment. The number of available characters for the Comments argument is limited to 66 characters.
  • StartDateFromNow specifies in number of days when addition of the hotlist entry should begin.
    • 0: A value of 0 specifies the start date is today (the current system date).
    • > 0: A value greater than zero specifies how many days in the future the hotlist entry should start being added.
  • EndDuration specifies in number of days when addition of the hotlist entry should end.
    • 0: A value of 0 specifies that there is no expiration date.
    • > 0: A value greater than zero specifies how many days from the start date (StartDateFromNow value) the hotlist entry addition should end.
  • ClientID is the client ID from the transaction data.

Return Type: Integer

1: If it fails.

0: If it is successful.

-1: If there are more than 32 add, update, or remove operations per transaction.

-2: If the record size exceeds the maximum record size (currently 1024 characters).

-3: If either StartDateFromNow or EndDuration parameter is a negative number.

Description: Adds a List lookup entry to the List table based on ClientID for a specified duration at the sub-tenant level instead of at the global level.

Usage Considerations: The context for using this function determines the tables involved and the actions taken in relation to those tables, as follows.

Usage Context
 Table-level Results
Restrict a card
  • Removes all entries for this key and client ID from the SYSTEM_RESTRICT table.
  • Removes all entries from all partial permit tables (SYSTEM_PERMIT_MCC, SYSTEM_PERMIT_MER_COUNTRY, SYSTEM_PERMIT_MER_STATE, and SYSTEM_PERMIT_RULES) for the same key and client ID.
  • Adds a new hotlist entry to the SYSTEM_RESTRICT hotlist table.
Fully permit a card
  • Removes the entry in SYSTEM_RESTRICT table for the same key and client ID.
  • Removes the entry in SYSTEM_PERMIT_FULL table for the same key and client ID.
  • Removes the entry from all partial permit tables (SYSTEM_PERMIT_MCC, SYSTEM_PERMIT_MER_COUNTRY, SYSTEM_PERMIT_MER_STATE, and SYSTEM_PERMIT_RULES) for the same key and client ID.
  • Adds a new entry in SYSTEM_PERMIT_FULL table for the same key and client ID.
Partially permit a card
  • Removes the entry in SYSTEM_RESTRICT table for the same key and client ID.
  • Removes the entry in SYSTEM_PERMIT_FULL table for the same key and client ID.
  • Removes the entry in the specified partial permit table for the same key and client ID.
  • Adds a new hotlist entry in the specified partial permit hotlist table for the same key and client ID.
Examples:
retCode is an integer;
Key is a string initially CRTRAN25.pan;
Value is a string initially “ALL”;
Comment is a string initially "Restrict All";
StartDateFromNow is an integer initially 0;
Duration is an integer initially 30;
ClientID is a string initially CRTRAN25.clientIdFromHeader;

retCode = LookupListAddEntryWithDurationAndClientID(SYSTEM_RESTRICT, Key, Value, Comment, StartDateFromNow, Duration, ClientID);
  • www.fico.com