Request + Approval Table Details


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_namecolumn_labelelementinternal_typereferencemax_lengthReporting Notes
CategoryCategoryu_request_categoryString 255 
Close codeClose codeu_close_codeString 40 
CustomerCustomerrequested_forReferenceUser32 
Delivery addressDelivery addressdelivery_addressString 4,000 
Don't Send Resolved NoticeDon't Send Resolved Noticeu_don_t_send_closure_noticeTrue/False 40 
Don't Send SurveyDon't Send Surveyu_don_t_send_surveyTrue/False 40 
EmailEmailu_emailString 100 
Employee full nameEmployee full nameu_employee_full_nameString 100 
Employee IDEmployee IDu_employee_idString 100 
Financial ApprovalFinancial Approvalu_fin_approvalString 40 
FulfilledFulfilledu_fulfilled_dateDate/Time 40 
Fulfilled byFulfilled byu_fulfilled_byReferenceUser32 
Fulfillment TimeFulfillment Timeu_fulfillment_timeInteger 40 
General RequestGeneral Requestu_general_requestTrue/False 40 
Incoming Email AddressIncoming Email Addressu_incoming_email_addressString 100 
Library Assignment GroupLibrary Assignment Groupu_library_assignment_groupReferenceGroup32 
New / separationNew / separationu_new_separationString 100 
Order GuideOrder Guideu_order_guideReferenceOrder guide32 
Parent interactionParent interactionparent_interactionReferenceInteraction32 
Phone NumberPhone Numberu_phone_numberString 40 
PricePricepriceCurrency 20 
Request StatusRequest Statusrequest_stateString 40Specific place within flow. Fulfillment Complete, Fulfillment Rejected, Closed Complete, Closed Incomplete, Open are common, but can be one of 15 statuses.
Requested for dateRequested for daterequested_dateDate 40 
Resolve TimeResolve Timecalendar_stcInteger 40 
Special instructionsSpecial instructionsspecial_instructionsString 4,000 
StageStagestageWorkflow 80Driven by the flow, high level where is the request right now? Closed Complete, Closed Incomplete, Requested are options.
Start end dateStart end dateu_start_end_dateDate 40 
Student emailStudent emailu_student_emailString 100 
Sub-subcategorySub-subcategoryu_request_sub_subcategoryString 255 
SubcategorySubcategoryu_request_subcategoryString 255 
Transferred FromTransferred Fromu_transferred_fromReferenceTask32 
Transferred from ContactTransferred from Contactu_transferred_from_contactReferenceContact32 
Transferred from IncidentTransferred from Incidentu_transferred_from_incidentReferenceIncident32 
Transferred from ProblemTransferred from Problemu_transferred_from_problemReferenceProblem32 
Transferred to IncidentTransferred to Incidentu_transferred_to_incidentReferenceIncident32 
Transferred to ProblemTransferred to Problemu_transferred_to_problemReferenceProblem32 
Workflow FormWorkflow Formu_workflow_formURL 1,024 

 

Notable sc_task fields

sys_namecolumn_labelelementinternal_typereferencemax_lengthReporting Notes
 Sys IDsys_idSys ID (GUID)32 
CatalogCatalogsc_catalogReferenceCatalog32 
RequestRequestrequestReferenceRequest32 
Request itemRequest itemrequest_itemReferenceRequested Item32 
Resolve TimeResolve Timecalendar_stcInteger 40 

 

Notable sc_req_item fields

sys_namecolumn_labelelementinternal_typereferencemax_lengthReporting Notes
 Sys IDsys_idSys ID (GUID)32 
BackorderedBackorderedbackorderedTrue/False 40 
BillableBillablebillableTrue/False 40 
CatalogCatalogsc_catalogReferenceCatalog32 
Configuration itemConfiguration itemconfiguration_itemReferenceConfiguration Item32 
ContextContextcontextReferenceWorkflow context32 
Estimated DeliveryEstimated Deliveryestimated_deliveryDate/Time 40 
Flow ContextFlow Contextflow_contextReferenceFlow engine context32 
ItemItemcat_itemReferenceCatalog Item32 
Order GuideOrder Guideorder_guideReferenceOrder guide32 
PricePricepriceCurrency 20 
QuantityQuantityquantityInteger 40 
Recurring PriceRecurring Pricerecurring_pricePrice 20 
Recurring Price FrequencyRecurring Price Frequencyrecurring_frequencyChoice 40 
RequestRequestrequestReferenceRequest32 
StageStagestageWorkflow 80 

 

Notable sysapproval_approver fields

sys_namecolumn_labelelementinternal_typereferencemax_lengthReporting Notes
 Createdsys_created_onDate/Time 40 
 Updated bysys_updated_byString 40 
 Sys IDsys_idSys ID (GUID)32 
 Created bysys_created_byString 40 
 Updatedsys_updated_onDate/Time 40 
 Updatessys_mod_countInteger 40 
Approval ColumnApproval Columnapproval_columnField Name 80 
Approval forApproval forsysapprovalReferenceTask32 
Approval Journal ColumnApproval Journal Columnapproval_journal_columnField Name 80 
Approval sourceApproval sourceapproval_sourceString 40 
ApproverApproverapproverReferenceUser32 
ApprovingApprovingdocument_idDocument ID32 
CommentsCommentscommentsJournal Input4,000 
Due dateDue datedue_dateDate/Time 40 
Expected startExpected startexpected_startDate/Time 40 
GroupGroupgroupReferenceGroup approval32 
IterationIterationiterationInteger 40 
OrderOrderorderInteger 40 
Process stepProcess stepprocess_stepReferenceProcess Steps32 
Register accountRegister accountregister_accountString 151 
Register emailRegister emailregister_emailString 151 
Register nameRegister nameregister_nameString 151 
Source tableSource tablesource_tableTable Name 80 
StateStatestateString 40 
State bindingState bindingstate_bindingReferenceState Binding32 
Workflow activityWorkflow activitywf_activityReferenceWorkflow Activity32 

If you still have questions or need additional assistance, please use the 'Contact ServiceNow Team' form.