Field descriptions for some fields in: sys_user_has_role, sys_user_role & sysapproval_approver

[SB87]

Hello,

I'm having difficulty trying to gather descriptions for the following fields. Is anyone able to provide meaningful descriptions of what these store and how they are used?

Thanks in advance,

SB

Field Name	Description	Label Name	Data Type	Length	Table Reference	Source Table
inh_count	TBC	Inheritance Count	integer	40		sys_user_has_role
inh_map	TBC	Inheritance Map	glide_action_list	255		sys_user_has_role
description	TBC	Description	string	1000		sys_user_role
includes_roles	TBC	Includes roles	string	40		sys_user_role
suffix	TBC	Suffix	string	100		sys_user_role
document_id	TBC	Approving	document_id	32		sysapproval_approver
due_date	TBC	Due date	glide_date_time	40		sysapproval_approver
expected_start	TBC	Expected start	glide_date_time	40		sysapproval_approver
iteration	TBC	Iteration	integer	40		sysapproval_approver
order	TBC	Order	integer	40		sysapproval_approver
register_account	TBC	Register account	string	151		sysapproval_approver
register_email	TBC	Register email	string	151		sysapproval_approver

[Ravi Chandra_K · Accepted solution]

Hello @SB87 

Greetings!

Inheritence count and Inheritence map are to used to find if Same role is added to user profile in sys_user_has_role table multiple times

refer https://www.servicenow.com/community/developer-forum/group-assigns-multiple-same-roles-to-same-user/...

description - description of the role

includes_roles - what other roles the parent role contains

suffix -  Unique part of the Name field. Appended to the scope in the Name field.

document_id - record that is being approved.

due date - due date for approval (used in flows)

expected start date  - expected start date for approval

(both dates are part of Approval - User Schedule

Specify how workflow calculates the approval record's expected start date and due date. Once you've made a selection for 'Due date based on', and 'Schedule based on', the appropriate fields will display.)

iteration - interger value defines how many times approvals are sent back

order - can be any integer value which differentiates each level of approval.

I don't see register_account, register_email fields in sysapproval_approver table. they are self explanatory.

Please hit the thumb and Mark as correct based on Impact!!

Kind Regards,

Ravi Chandra.