The X_TABLES_NO_SITE is a lexicon that lists tables with records that can never be updated or customized by a client. These are generic values, which are the same for every tenant, and tenant-specific records will never exist for these tables.
For example: States and Provinces do not change by tenant. These records will never contain a reference to the tenant-specific site code but will instead have 'No Site'.
X_TABLES_NO_SITE is a FIXED LEXICON with the following values:
| Saved Value | Displayed Value | ||
|---|---|---|---|
| AAC | P2K_AT_ATTENDANCE_COMPONENTS | ||
| AAR | P2K_AT_AC_RULES | ||
| BBC | P2K_BE_BENEFIT_COMPONENTS | ||
| BBCR | P2K_BE_BC_RULES | ||
| CPT | P2K_CP_PARSING_TAXONOMIES | ||
| DCI | P2K_CM_CITIES | ||
| DCN | P2K_CM_COUNTIES | ||
| DCO | P2K_CM_COUNTRIES | ||
| DIN | P2K_CM_INDUSTRIES | ||
| DLG | P2K_CM_LOADED_GEOCODES | ||
| DMN | P2K_CM_MUNICIPALITIES | ||
| DOC | P2K_CM_OCCUPATIONS | ||
| DSD | P2K_CM_SCHOOL_DISTRICTS | ||
| DSP | P2K_CM_STATE_PROVINCES | ||
| DZR | P2K_CM_ZIP_RANGE | ||
| MCC | P2K_AM_USER_CALC_COMMANDS | ||
| MCD | P2K_AM_COLUMN_DETAILS | ||
| MDAO | P2K_AM_DATA_ACCESS_OBJECTS | ||
| MDC | P2K_AM_DATABASE_CHANGE_LOGS | ||
| MOB | P2K_AM_OBJECTS | ||
| MOPV | P2K_AM_OPERATOR_VALIDATIONS | ||
| MOR | P2K_AM_OPERATORS | ||
| MPD | P2K_AM_PRODUCTS | ||
| MPF | P2K_AM_PREFERENCES | ||
| MPT | P2K_AM_PRODUCT_REF_TABLES | ||
| MSR | P2K_AM_SECURITY_RIGHTS | ||
| MST | P2K_AM_SITES | not used | |
| MTD | P2K_AM_TABLE_DETAILS | ||
| MTML | P2K_AM_TABLE_MODIFIED_LOGS | ||
| MTT | P2K_AM_TRIGGER_TEXT | ||
| MUL | P2K_AM_UNSUCCESSFUL_LOGINS | ||
| PBL | P2K_PR_BANK_LOCATIONS | ||
| PCU | P2K_PR_PC_USAGES | ||
| PTM | P2K_PR_TAX_MISCS | ||
| PUR | P2K_PR_US_TAX_RATES | ||
| PURD | P2K_PR_US_TAX_RATE_DETAILS |
