The IpObject table contains one entry for every object (Folders, Tokens, Profiles, Requests).
| Column Name | Column Datatype | Column Null Option | Column Comment |
| objectid | integer | not null | Unique over all objects. NOTE: Next ID kept in
LookOutIdControl.
|
| userid | integer | not null | The ID from IPUser table of the Script Manager User who
created and owns this object.
|
| objectname | varchar(32) | not null | The Name of the object. |
| objecttype | integer1 | not null | The type of object. NOTE: folder=1, token=2, profile=3, request=4 |
| objectnote | varchar(255) | with null | The optional user-defined note. |
| objectfolderid | integer | not null | The ID of the folder-type object which this object is contained in. |
| objectcreatedtime | date | not null | The Datetime when this object was created. |
| objectlastmodifytime | date | not null | The Datetime when this object was last modified. NOTE: this field is not set if one of the other tables defining the object (e.g.: Request) changes. |
| objectmodifierid | integer | not null | The user_id of the Script Manager user currently modifying this object. |
| objectmodifierinstance | integer | not null | The DBPROC of the Script Manager user currently modifying this object. |
Product Name: Data Transformer
Table Type: Table
Relationships:
| Primary Key | Related Table | Related Column |
| objectid | iprequest | requestid |
| objectid | ipprovider | providerid |
| objectid | permissions | objectid |
| objectid | rdbms_provider | providerid |