Fields:

Field Name	Common Type	Database Type	Generic Field ID	Array Size	Default	Flags	Comment	Field Used in Views
attrib_name	CHAR	varchar		64			Attribute name	Search (3)
db_attrib_type	LONG	int				DIRECT	Attribute type from database; Same as N_Attribute.N_Type	Search (3)
depends_on	CHAR	varchar		255		ALLOW_NULL	Dependent field depends on this value	Search (1)
dev	LONG	int	151		1	DIRECT, ALLOW_NULL	Row version number for mobile distribution purposes
field_flags	LONG	int				DIRECT	Field creation flags; 0 = create as needed, 1 = always create, 2 = never create	Search (2)
fld_name	CHAR	varchar		128			FML field name	Search (5)
fml_attrib_type	CHAR	varchar		10			Attribute type of the FML field definition; one of 'long', 'string' (or possibly 'date')	Search (4)
focus	LONG	int				DIRECT	0 = Current focus object, 1 = rqst_inst	Search (5)
focus_alpha	CHAR	varchar		20			String value for focus	Search (3)
is_flexible	LONG	int				DIRECT	0 = Current focus object, 1 = rqst_inst	Search (3)
object_cond	CHAR	varchar		255			Condition list for object path	Search (2)
object_inv_path	CHAR	varchar		255			Inverse object path	Search (1)
object_path	CHAR	varchar		255			Object path	Search (2)
object_sqlfrom	CHAR	varchar		255			SQL FROM clause for object path	Search (3)
object_sqlwhere	CHAR	varchar		255			SQL WHERE clause for object path	Search (3)
object_target_id	LONG	int				DIRECT	Object path target type ID	Search (2)
objid	LONG	int	3			DIRECT	Internal record number	Search (10)
parent_cond	CHAR	varchar		255			Condition list for parent path	Search (1)
parent_inv_path	CHAR	varchar		255			Inverse parent path	Search (1)
parent_path	CHAR	varchar		255			Parent path	Search (1)
parent_rel	CHAR	varchar		64			Name of the relation from parent to the object	Search (1)
parent_sqlfrom	CHAR	varchar		255			SQL FROM clause for parent path	Search (1)
parent_sqlwhere	CHAR	varchar		255			SQL WHERE clause for parent path	Search (1)
parent_target	CHAR	varchar		64			Target of parent path	Search (1)
parent_target_id	LONG	int				DIRECT	Parent path target type ID
path	CHAR	varchar		255			The database path that defines the field value	Search (7)
rel_cond	CHAR	varchar		255			Condition list for relation path	Search (1)
rel_focus	CHAR	varchar		64			Focus type for relation path	Search (1)
rel_inv_path	CHAR	varchar		255			Inverse relation path	Search (1)
rel_path	CHAR	varchar		255			Relation path	Search (1)
rel_sqlfrom	CHAR	varchar		255			SQL FROM clause for relation path	Search (1)
rel_sqlwhere	CHAR	varchar		255			SQL WHERE clause for relation path	Search (1)
rel_target	CHAR	varchar		64			Target of relation path	Search (1)
rel_target_id	LONG	int				DIRECT	Relation path target type ID	Search (1)
target_name	CHAR	varchar		64			Target of object path	Search (4)
type	LONG	int				DIRECT	1 = Activation, 2 = Input, 3 = Dependent, 4 = Output, 5 = Output-Async, 6 = Input Constant, 7 = Output Constant	Search (7)
type_alpha	CHAR	varchar		20			String value for type	Search (3)

Table Name:	svc_fld
Table Number:	9755
Group:	Process Manager
Description:	Contains one instance for each field used by a function. A service request contains one instance for each service field
Flags:
Baseline/Custom:	Baseline

Relation	Type	Target Object	Inverse Relation	Comment	Used in Views
svc_fld2fld_def	MTO	fld_def	fld_def2svc_fld	FML field definition on which this field is based
inst2fld_inst	OTM	fld_inst	fld2svc_fld	Instances of this field. Created when the owning process is executed and the owning request is initiated
fld2svc_rqst	MTO	svc_rqst	rqst2svc_fld	The service request that owns the fields	Search (4)

Index Name	Fields	Additional Information
f2sr9755	fld2svc_rqst	nonclustered located on PRIMARY
objindex	objid	clustered, unique located on PRIMARY
sf2fd9755	svc_fld2fld_def	nonclustered located on PRIMARY

View ID	View Name	Tables
9852	svc_fld_view	function, svc_fld, svc_rqst
9862	fld_status_view	fld_inst, rqst_inst, svc_fld
9873	process_rqst_inst_view	proc_inst, rqst_inst, svc_fld, svc_rqst
9874	process_fld_inst_view	fld_inst, rqst_inst, svc_fld, svc_rqst
9876	dummy_path_view	svc_fld
9877	indexed_svc_fld_view	svc_fld
9890	inst_dependent_field	proc_fc_item, svc_fld, svc_rqst
9895	procdef_action_view	showpage, svc_fld, svc_rqst
9898	procinst_param_view	fld_inst, function, group_inst, proc_inst, rqst_inst, svc_fld
9904	fld_inst_view	fld_inst, rqst_inst, svc_fld

act_entry	case	contact	employee
rol_contct	site	site_view	user

Fields:

Relations:

Indexes: (Defined in Clarify Schema)

Indexes (Defined in Database):

Referenced in Views:

My Recent Objects

Quick Links

alt-s	Execute SQL
alt-t	Execute SQL, getting latest 10 rows
?	Bring up this help dialog