The db_programinstance table contains metadata about instances of program types in a workflow.
| Column Name | Column Datatype | Column Null Option | Column Comment |
| dbrep_iid | integer | not null | The unique ID of the program instance. |
| dbrep_version | smallint | with null | The version number of the program instance. |
| dbrep_left | integer | with null | The left coordinates of the program instance window. |
| dbrep_top | integer | with null | The top coordinates of the program instance window. |
| dbrep_right | integer | with null | The right coordinates of the program instance window. |
| dbrep_bottom | integer | with null | The bottom coordinates of the program instance window. |
| dbrep_proginsttype | smallint | with null | The program instance type:
Data Transformer 1 Fax 2 Printer 3 File 4 Email 5 Workflow 6 Other 7 |
| dbrep_executablename | varchar(128) | with null | The executable name of the program instance. |
| dbrep_location | varchar(128) | with null | The location/name of the idb or repository associated with this program instance. |
| dbrep_lastexecution | varchar(31) | with null | The Datetime of last execution of program instance. |
| dbrep_userreturncode | integer | with null | The user return code set in the program/script. |
| dbrep_returncode | integer | with null | The last return code of program instance. |
| dbrep_runstatus | integer | with null | Indicates the run status of the program instance which can
be:
NOTRUN = 0, RUN_STARTED = 1, RUN_CONTINUING = 2, RUN_END = 3, RUN_FAILED = 4 |
| dbrep_programiid | integer | with null | The unique ID of the Program object that the program instance is associated with. Currently not used. |
| dbrep_programtypeiid | integer | with null | The program instance type id. Currently not used. |
| dbrep_miscprogramtypeiid | integer | with null | Currently not used. |
Product Name: Data Transformer
Table Type: Table