Skip to main content

Supported Fields and Example files

This article documents the supported database tables and field formats for batch authorization imports, including proper input values for country, currency, boolean, and lookup fields

These are the supported tables

  1. AUTHORIZATION

  2. AUTH_STAGE_ASSIGNMENT

  3. AUTH_STAGE_ASSIGNMENT_CF

  4. AUTH_STAGE_ASSIGNMENT_SPECIAL_SECURITY_GROUP

  5. AUTH_STAGE_EMPLOYEE

  6. AUTH_STAGE_EMPLOYEE_CF

  7. AUTH_STAGE_RELOCATION_SCREEN_CONTACT

  8. AUTH_STAGE_RELOCATION_SCREEN_CONTACT_CF

  9. AUTH_STAGE_ASSIGNMENT_EMPLOYEE_CONTACT

Input Values for types of fields

  • Any Country field, including Citizenship should use 3 digit code like USA or the Display Name like United States

  • Any Currency field should always use 3 digit currency like USD or GBP

  • Boolean fields can use EQTRUE or EQFALS, or Yes and No

    • All other lookup fields should use Display Name

Example

Here are are basic versions if you want to create your own:

Did this answer your question?