ACT_USER_DETAILS
Description
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | SOURCE_SYSTEM_CODE | CHARACTER VARYING(12) | 12 |
| 2 | EXTRACT_TIMESTAMP | TIMESTAMP | 8 |
| 3 | DOM | CHARACTER VARYING(12) | 12 |
| 4 | ROOT | CHARACTER VARYING(64) | 64 |
| 5 | OU_NAME | CHARACTER VARYING(128) | 128 |
| 6 | ACCOUNT_TYPE | CHARACTER VARYING(32) | 32 |
| 7 | SAMACCOUNTNAME | CHARACTER VARYING(64) | 64 |
| 8 | CN | CHARACTER VARYING(64) | 64 |
| 9 | GIVENNAME | CHARACTER VARYING(512) | 512 |
| 10 | INITIALS | CHARACTER VARYING(512) | 512 |
| 11 | SN | CHARACTER VARYING(512) | 512 |
| 12 | COMPANY | CHARACTER VARYING(512) | 512 |
| 13 | DEPARTMENT | CHARACTER VARYING(512) | 512 |
| 14 | PHYSICALDELIVERYOFFICENAME | CHARACTER VARYING(512) | 512 |
| 15 | L | CHARACTER VARYING(512) | 512 |
| 16 | TITLE | CHARACTER VARYING(512) | 512 |
| 17 | DESCRIPTION | CHARACTER VARYING(512) | 512 |
| 18 | BUSINESSCATEGORY | CHARACTER VARYING(512) | 512 |
| 19 | FORWARDINGADDRESS | CHARACTER VARYING(512) | 512 |
| 20 | STREETADDRESS | CHARACTER VARYING(512) | 512 |
| 21 | ST | CHARACTER VARYING(512) | 512 |
| 22 | POSTALCODE | CHARACTER VARYING(512) | 512 |
| 23 | CO | CHARACTER VARYING(512) | 512 |
| 24 | C | CHARACTER VARYING(512) | 512 |
| 25 | TELEPHONENUMBER | CHARACTER VARYING(512) | 512 |
| 26 | HOMEPHONE | CHARACTER VARYING(512) | 512 |
| 27 | MOBILE | CHARACTER VARYING(512) | 512 |
| 28 | CHARACTER VARYING(512) | 512 | |
| 29 | EXTENSIONATTRIBUTE1 | CHARACTER VARYING(512) | 512 |
| 30 | EXTENSIONATTRIBUTE2 | CHARACTER VARYING(512) | 512 |
| 31 | EXTENSIONATTRIBUTE3 | CHARACTER VARYING(512) | 512 |
| 32 | EXTENSIONATTRIBUTE4 | CHARACTER VARYING(512) | 512 |
| 33 | EXTENSIONATTRIBUTE5 | CHARACTER VARYING(512) | 512 |
| 34 | GECOS | CHARACTER VARYING(512) | 512 |