Overview

---

Catalog items (aka forms) involve numerous tables. The specifics of the tables changes depending on the workflow of the form. Not all forms have approvals. Not all forms have tasks. Some forms create cases directly. Requests are not directly acted upon, so they will often have sparse data - usually only submitter and variables.

 

Fields on the Task Table

---

Operational data on forms is available on the Forms and Catalog Items Dashboard.

• sc_request is for the umbrella of the request itself. pre-december 2019, ITS ServiceNow used this table for what we currently use cases for. Any reports you run off of this table should start from January 2020 in order to show relevant and correct data. Saul recommends running task and ritm reports separately
• sc_task is for tasks related to that request.
• sc_req_item is for RITMs related to that request.
• sysapproval_approver is for approvals related to that request. Approval requests can be sent to an individual (like a supervisor) or a group (like a committee or HR team), both end up on this table.

Notable sc_request fields

Notable sc_task fields

Notable sc_req_item fields

Notable sysapproval_approver fields

Notable sc_request fields

sys_name	column_label	element	internal_type	reference	max_length	Reporting Notes
Category	Category	u_request_category	String		255
Close code	Close code	u_close_code	String		40
Customer	Customer	requested_for	Reference	User	32
Delivery address	Delivery address	delivery_address	String		4,000
Don't Send Resolved Notice	Don't Send Resolved Notice	u_don_t_send_closure_notice	True/False		40
Don't Send Survey	Don't Send Survey	u_don_t_send_survey	True/False		40
Email	Email	u_email	String		100
Employee full name	Employee full name	u_employee_full_name	String		100
Employee ID	Employee ID	u_employee_id	String		100
Financial Approval	Financial Approval	u_fin_approval	String		40
Fulfilled	Fulfilled	u_fulfilled_date	Date/Time		40
Fulfilled by	Fulfilled by	u_fulfilled_by	Reference	User	32
Fulfillment Time	Fulfillment Time	u_fulfillment_time	Integer		40
General Request	General Request	u_general_request	True/False		40
Incoming Email Address	Incoming Email Address	u_incoming_email_address	String		100
Library Assignment Group	Library Assignment Group	u_library_assignment_group	Reference	Group	32
New / separation	New / separation	u_new_separation	String		100
Order Guide	Order Guide	u_order_guide	Reference	Order guide	32
Parent interaction	Parent interaction	parent_interaction	Reference	Interaction	32
Phone Number	Phone Number	u_phone_number	String		40
Price	Price	price	Currency		20
Request Status	Request Status	request_state	String		40	Specific place within flow. Fulfillment Complete, Fulfillment Rejected, Closed Complete, Closed Incomplete, Open are common, but can be one of 15 statuses.
Requested for date	Requested for date	requested_date	Date		40
Resolve Time	Resolve Time	calendar_stc	Integer		40
Special instructions	Special instructions	special_instructions	String		4,000
Stage	Stage	stage	Workflow		80	Driven by the flow, high level where is the request right now? Closed Complete, Closed Incomplete, Requested are options.
Start end date	Start end date	u_start_end_date	Date		40
Student email	Student email	u_student_email	String		100
Sub-subcategory	Sub-subcategory	u_request_sub_subcategory	String		255
Subcategory	Subcategory	u_request_subcategory	String		255
Transferred From	Transferred From	u_transferred_from	Reference	Task	32
Transferred from Contact	Transferred from Contact	u_transferred_from_contact	Reference	Contact	32
Transferred from Incident	Transferred from Incident	u_transferred_from_incident	Reference	Incident	32
Transferred from Problem	Transferred from Problem	u_transferred_from_problem	Reference	Problem	32
Transferred to Incident	Transferred to Incident	u_transferred_to_incident	Reference	Incident	32
Transferred to Problem	Transferred to Problem	u_transferred_to_problem	Reference	Problem	32
Workflow Form	Workflow Form	u_workflow_form	URL		1,024

 

Notable sc_task fields

sys_name	column_label	element	internal_type	reference	max_length	Reporting Notes
	Sys ID	sys_id	Sys ID (GUID)		32
Catalog	Catalog	sc_catalog	Reference	Catalog	32
Request	Request	request	Reference	Request	32
Request item	Request item	request_item	Reference	Requested Item	32
Resolve Time	Resolve Time	calendar_stc	Integer		40

 

Notable sc_req_item fields

sys_name	column_label	element	internal_type	reference	max_length	Reporting Notes
	Sys ID	sys_id	Sys ID (GUID)		32
Backordered	Backordered	backordered	True/False		40
Billable	Billable	billable	True/False		40
Catalog	Catalog	sc_catalog	Reference	Catalog	32
Configuration item	Configuration item	configuration_item	Reference	Configuration Item	32
Context	Context	context	Reference	Workflow context	32
Estimated Delivery	Estimated Delivery	estimated_delivery	Date/Time		40
Flow Context	Flow Context	flow_context	Reference	Flow engine context	32
Item	Item	cat_item	Reference	Catalog Item	32
Order Guide	Order Guide	order_guide	Reference	Order guide	32
Price	Price	price	Currency		20
Quantity	Quantity	quantity	Integer		40
Recurring Price	Recurring Price	recurring_price	Price		20
Recurring Price Frequency	Recurring Price Frequency	recurring_frequency	Choice		40
Request	Request	request	Reference	Request	32
Stage	Stage	stage	Workflow		80

 

Notable sysapproval_approver fields

sys_name	column_label	element	internal_type	reference	max_length	Reporting Notes
	Created	sys_created_on	Date/Time		40
	Updated by	sys_updated_by	String		40
	Sys ID	sys_id	Sys ID (GUID)		32
	Created by	sys_created_by	String		40
	Updated	sys_updated_on	Date/Time		40
	Updates	sys_mod_count	Integer		40
Approval Column	Approval Column	approval_column	Field Name		80
Approval for	Approval for	sysapproval	Reference	Task	32
Approval Journal Column	Approval Journal Column	approval_journal_column	Field Name		80
Approval source	Approval source	approval_source	String		40
Approver	Approver	approver	Reference	User	32
Approving	Approving	document_id	Document ID		32
Comments	Comments	comments	Journal Input		4,000
Due date	Due date	due_date	Date/Time		40
Expected start	Expected start	expected_start	Date/Time		40
Group	Group	group	Reference	Group approval	32
Iteration	Iteration	iteration	Integer		40
Order	Order	order	Integer		40
Process step	Process step	process_step	Reference	Process Steps	32
Register account	Register account	register_account	String		151
Register email	Register email	register_email	String		151
Register name	Register name	register_name	String		151
Source table	Source table	source_table	Table Name		80
State	State	state	String		40
State binding	State binding	state_binding	Reference	State Binding	32
Workflow activity	Workflow activity	wf_activity	Reference	Workflow Activity	32