Restricted Party Data Mapping
The restricted party data is saved in GTM_DENIED_PARTY table. The following table gives the data saved to the GTM_DENIED_PARTY table.
| Content Provider Element | GTM Element | Description |
|---|---|---|
| IDNUM |
GTM_DENIED_PARTY_GID GTM_DENIED_PARTY_XID |
Denied Party ID is a concatenation of Data_Version_ ID+’_’+IDNum. This is the only mandatory element to create denied party data in GTM. Eg: If the new data version ID is 12332 and IDnum is 3242, the denied party ID would be 12332_3242 |
| FirstName | FIRST_NAME | First Name of the denied party |
| LastName | LAST_NAME | Last Name of the denied party |
| CompanyName | COMPANY_NAME | Company Name of the denied party |
| Address | ADDRESS_LINE_1 | Address of the denied party |
| City | CITY | City |
| State | PROVINCE | State/Province |
| CountryName | COUNTRY | Country Name |
| CountryCode | COUNTRY_CODE |
Country Code Eg: USA, IND |
| ZipCode | POSTAL_CODE | Postal Code |
| StartDate | EFFECTIVE_DATE | Effective Date of denied party |
| EndDate | EXPIRATION_DATE | Expiration Date of denied party |
| Code | AGENCY_CODE | Agency Code |
| LastUpdated | ENTRY_DATE | Last updated date of denied party |
| IDNUM | ENTRY_ID | Unique ID of the denied party from the content provider |
| Vol1 | RULING_VOLUME | Volume in which the denied party appears in federal regulations |
| Page1 | RULING_PAGE_NUMBER | Page Number on which the denied party appears in federal regulations |
| FedDate1 | FEDERAL_REGULATION_DATE | Date on which the denied party was added to federal regulations |
| Notes | NOTES | Additional Information regarding denied party |
| url | FEDERAL_REGULATION_URL | URL link to the federal regulations |
CountryCode is preferred to CountryName as it speeds up the restricted party screening process. Using the 2-digit country code is recommended.
The Content Provider must send in each alias as an individual record so that they are also screened against the party records.