Authorization User Tables are not supported by the Authorization Flexible CSV Import.
The tables that can be inserted using this import are:
AUTHORIZATION
AUTH_STAGE_ASSIGNMENT
AUTH_STAGE_ASSIGNMENT_CF
AUTH_STAGE_ASSIGNMENT_SPECIAL_SECURITY_GROUP (Up to 10 supported)
AUTH_STAGE_EMPLOYEE
AUTH_STAGE_EMPLOYEE_CF
AUTH_STAGE_ASSIGNMENT_MAILING_ADDRESS
AUTH_STAGE_ASSIGNMENT_MAILING_ADDRESS_CF
AUTH_STAGE_ASSIGNMENT_DEPENDENT (Up to 10 supported)
AUTH_STAGE_ASSIGNMENT_DEPENDENT_CF
AUTH_STAGE_COST_ESTIMATE (Up to 10 supported)
AUTH_STAGE_RELOCATION_SCREEN_CONTACT (Up to 10 supported)
AUTH_STAGE_RELOCATION_SCREEN_CONTACT_CF
AUTH_STAGE_SPOUSE_DOMESTIC_PARTNER
AUTH_STAGE_SPOUSE_DOMESTIC_PARTNER_CF
AUTH_STAGE_ASSIGNMENT_EMPLOYEE_CONTACT (Up to 20 supported)
AUTH_STAGE_ASSIGNMENT_SERVICE (Up to 20 supported)
The tables and some of the fields that can be updated using this import are:
AUTHORIZATION
AUTHORIZATION!AUTHORIZATION_COORDINATOR
AUTHORIZATION!CHILDREN_ON_ASSIGNMENT
AUTHORIZATION!DELETE_AFTER_DATE
AUTHORIZATION!TOTAL_CHILDREN
AUTH_STAGE_ASSIGNMENT
AUTH_STAGE_ASSIGNMENT!ASSIGNMENT_LENGTH
AUTH_STAGE_ASSIGNMENT!EFFECTIVE_DATE
AUTH_STAGE_ASSIGNMENT!FROM_CITY
AUTH_STAGE_ASSIGNMENT!FROM_COUNTRY
AUTH_STAGE_ASSIGNMENT!FROM_STATE_PROVINCE
AUTH_STAGE_ASSIGNMENT!FROM_TITLE
AUTH_STAGE_ASSIGNMENT!SCHEDULED_END_DATE
AUTH_STAGE_ASSIGNMENT!TO_COUNTRY
AUTH_STAGE_ASSIGNMENT!TO_CURRENCY
AUTH_STAGE_ASSIGNMENT!TO_STATE_PROVINCE
AUTH_STAGE_ASSIGNMENT!TYPE
AUTH_STAGE_EMPLOYEE
AUTH_STAGE_EMPLOYEE!FIRST_NAME
AUTH_STAGE_EMPLOYEE!LAST_NAME
AUTH_STAGE_EMPLOYEE!GENDER
AUTH_STAGE_EMPLOYEE!PREFIX
AUTH_STAGE_EMPLOYEE!HR_CONTACT_RESOURCE_ID
AUTH_STAGE_EMPLOYEE!PRIMARY_CITIZENSHIP
AUTH_STAGE_EMPLOYEE!BIRTH_COUNTRY
AUTH_STAGE_EMPLOYEE!BIRTH_CITY
AUTH_STAGE_ASSIGNMENT_DEPENDENT
AUTH_STAGE_ASSIGNMENT_EMPLOYEE_CONTACT
AUTH_STAGE_ASSIGNMENT_EMPLOYEE_CONTACT!CONTACT_PREFERRED_EMAIL
AUTH_STAGE_ASSIGNMENT_EMPLOYEE_CONTACT!CONTACT_PREFERRED_EMAIL_LOCATION_TYPE
AUTH_STAGE_ASSIGNMENT_EMPLOYEE_CONTACT!CONTACT_PRIMARY_PHONE
AUTH_STAGE_ASSIGNMENT_EMPLOYEE_CONTACT!CONTACT_PRIMARY_PHONE_LOCATION_TYPE
AUTH_STAGE_SPOUSE_DOMESTIC_PARTNER
AUTH_STAGE_SPOUSE_DOMESTIC_PARTNER!BIRTH_DATE
AUTH_STAGE_SPOUSE_DOMESTIC_PARTNER!CONTACT_EMAIL
AUTH_STAGE_SPOUSE_DOMESTIC_PARTNER!CONTACT_PHONE
AUTH_STAGE_SPOUSE_DOMESTIC_PARTNER!FIRST_NAME
AUTH_STAGE_SPOUSE_DOMESTIC_PARTNER!LAST_NAME
AUTH_STAGE_SPOUSE_DOMESTIC_PARTNER!GENDER
AUTH_STAGE_SPOUSE_DOMESTIC_PARTNER!STATUS
AUTH_STAGE_SPOUSE_DOMESTIC_PARTNER!RELATIONSHIP
TableInstance={somenumber} - This header attribute allows multiple records from child tables to be imported. For example, dependents can be inserted or updated through the Authorization FCSV import like this:
AUTH_STAGE_ASSIGNMENT_DEPENDENT!LAST_NAME|TableInstance=1 Pesoli
AUTH_STAGE_ASSIGNMENT_DEPENDENT!FIRST_NAME|TableInstance=1 Carlo
AUTH_STAGE_ASSIGNMENT_DEPENDENT!LAST_NAME|TableInstance=2 Pesoli
AUTH_STAGE_ASSIGNMENT_DEPENDENT!FIRST_NAME|TableInstance=2 Lucia
Generally speaking, the import can insert any field in any of these tables other than the ID field and any foreign key fields that link these tables to each other (See Employee Assignment Flexible Header Import Field Column Definition.xls for more detail on exact fields).
For lookup-type fields (any field that appears as a drop-down list on the screen) the value given to the import is the full text of the value the user sees on the screen (NOT the ID or code that is looked up and stored in the database).
A country or a currency field should be imported using the appropriate three-letter symbol (not the full name).
A field that appears as a checkbox on the screen should be imported with a value of “Yes” if the box should be checked and “No” otherwise. Also, very few fields are required apart from the fields used to identify a record.
There are, of course, special cases. For example, if a state/province field is given, there will be an associated country field that is required (and the given state province must be a part of the given country).
This sample can be used as a guide for the available fields for the Authorization Flexible CSV Import. The sample template can be used as-is or unneeded fields can be removed.