This table stores objects that represent dependencies between a procedure and another procedure. E.g. if procedure A needs procedure B to be executed before A can execute, a dependency object would be created. Note that in this example procedure B (and its software package) may not exist at the time the dependency is created, that is why there is a reference to the procedure by 4 identifiers (rswName, rswVersion, apName, apVersion) as well as a FK link. In case procedure B exists a proper FK link can be used (depap). More than one dependencies can exists for a procedure, they are then ordered.
| Column Name | Column Datatype | Column Null Option | Column Comment |
| objectid | byte(16) | not null | Primary key, it is a uuid. |
| version | integer | not null | Version number is used to maintain cache and an optimistic transaction policy |
| rswname | nvarchar(129) | not null | This is the software package name that a procedure is depending on. |
| rswversion | nvarchar(129) | not null | This is the software package version that a procedure is depending on. |
| apname | nvarchar(129) | not null | This is the procedure name that a procedure is depending on. |
| apversion | nvarchar(129) | not null | This is the procedure version that a procedure is depending on. |
| filedby | integer | not null | Type of administrator that registered the procedure, typically enterprise or domain or automatically during installation (autoreg) |
| ap | byte(16) | with null | Link to my procedure (usd_actproc) |
| depap | byte(16) | with null | In case the procedure we depend upon exist this is the link, FK to usd_actproc. |
| ordernumber | integer | not null | Stores the order number of a specific dependancy in case a procedure depends on more than one, will affect execution order of dependant procedures. |
Product Name: Unicenter Desktop and Server Management
Table Type: Table