Fields:

Field Name	Common Type	Database Type	Generic Field ID	Array Size	Default	Flags	Comment
author	CHAR	varchar		30			User login name
category	CHAR	varchar		40			User=defined category - user-defined popup list 'Script Category'
description	CHAR	varchar		255			A brief description of the nature of the process
is_validated	LONG	tinyint				DIRECT	0 = the process definition is not validated, 1 = the definition is validated and may be made active
last_updated	CLK_TIME	datetime					Date and time the process definition was last modified
process_objid	LONG	int	3			DIRECT	Internal record number
script_name	CHAR	varchar		30			Script Name
status	CHAR	varchar		80			Name of the item/element
status_rank	LONG	int				DIRECT	Position of the item in the list; important in tracking scheduled/unscheduled and config time for service interuption report
type	LONG	tinyint				DIRECT	Process type: 0 = Process, 1 = Script
user_objid	LONG	int				DIRECT	Internal record number
visible	LONG	tinyint				DIRECT	Controls if the process/script may be selected and run by an agent choice: 0 = no, 1 = yes

SQL:

(
select p1.objid as process_objid,
p1.id as script_name,
p1.category as category,
p1.last_mod_time as last_updated,
p1.description as description,
p1.is_agent_runnable as visible,
p1.is_validated as is_validated,
p1.type as type,
g1.title as status,
g1.rank as status_rank,
u1.objid as user_objid,
u1.login_name as author
from table_process p1, table_gbst_elm g1, table_user u1
where p1.objid in
(select min(p.objid)
from table_process p, table_gbst_elm g
where p.type=1 AND g.rank=3 AND p.process_status2gbst_elm=g.objid
group by p.id) AND p1.process_status2gbst_elm=g1.objid AND p1.author2user=u1.objid
)