Table Hrm_Governance_Policies
Entity
Entity: HumanResources.Governance.GovernancePolicies
Policies represent the identity of an internal rule, policy, procedure, guideline, or job description. A policy defines what the rule is about, how it is named and classified, and how it is organized (e.g. in folders). The actual text of the policy and its changes over time are stored as separate policy revisions. Entity: Hrm_Governance_Policies (Introduced in version 26.2.0.88)
Summary
Name
Type
Description
Code
nvarchar(32)
Human-friendly unique identifier (e.g. HR-REMOTE-WORK).
Governance_Policy_Id
uniqueidentifier PK
Governance Policy Identifier
Is_Active
bit
Indicates whether the policy is active as a concept.
Name
nvarchar(256) ML
Policy name as spoken by users (e.g. "Remote Work Policy").
Policy_Kind
char(3) Allowed: JOB, GDL, RUL, PRC, POL, OTH
Classification of the policy.
Row_Version
timestamp
Columns
Code
Human-friendly unique identifier (e.g. HR-REMOTE-WORK).
Property
Value
Auto Complete
no
Data Filter
no
Default Value
None
Enter Stop
yes
Ignore for Insert Order
no
Is Entity Name
no
Max Length
32
Order
1
Ownership Reference
no
Pasword
no
Picture
no
Primary Key
no
Readonly
no
RTF
no
Sortable
yes
Summary Type
None
Supports EQUALS_IN
no
Type
nvarchar(32)
UI Memo Editor
no
UI Width
Medium
User Login
no
Visible
yes
Code - Supported Filters
Filter Type
Default
Include Nulls
Hidden by Default
Equals
NULL
no
no
Like
None
no
no
Governance_Policy_Id
Governance Policy Identifier
Property
Value
Auto Complete
no
Data Filter
no
Default Value
NewGuid
Enter Stop
yes
Ignore for Insert Order
no
Is Entity Name
no
Max Length
-1
Order
0
Ownership Reference
no
Pasword
no
Picture
no
Primary Key
yes (order: 1)
Readonly
no
RTF
no
Sortable
no
Summary Type
None
Supports EQUALS_IN
yes
Type
uniqueidentifier
UI Memo Editor
no
UI Width
Medium
User Login
no
Visible
no
Governance_Policy_Id - Supported Filters
Filter Type
Default
Include Nulls
Hidden by Default
Equals
NULL
no
no
Is_Active
Indicates whether the policy is active as a concept.
Property
Value
Auto Complete
no
Data Filter
no
Default Value
True
Enter Stop
yes
Ignore for Insert Order
no
Is Entity Name
no
Max Length
-1
Order
4
Ownership Reference
no
Pasword
no
Picture
no
Primary Key
no
Readonly
no
RTF
no
Sortable
no
Summary Type
None
Supports EQUALS_IN
no
Type
bit
UI Memo Editor
no
UI Width
Medium
User Login
no
Visible
yes
Is_Active - Supported Filters
Filter Type
Default
Include Nulls
Hidden by Default
Equals
NULL
no
no
Name
Policy name as spoken by users (e.g. "Remote Work Policy").
Property
Value
Auto Complete
no
Data Filter
no
Default Value
None
Enter Stop
yes
Ignore for Insert Order
no
Is Entity Name
no
Max Length
256
Order
2
Ownership Reference
no
Pasword
no
Picture
no
Primary Key
no
Readonly
no
RTF
no
Sortable
no
Summary Type
None
Supports EQUALS_IN
no
Type
nvarchar(256) (MultiLanguage)
UI Memo Editor
no
UI Width
Medium
User Login
no
Visible
yes
Name - Supported Filters
Filter Type
Default
Include Nulls
Hidden by Default
Like
None
no
no
Policy_Kind
Classification of the policy.
Property
Value
Allowed Values
JOB, GDL, RUL, PRC, POL, OTH
Auto Complete
no
Data Filter
no
Default Value
None
Enter Stop
yes
Ignore for Insert Order
no
Is Entity Name
no
Max Length
3
Order
3
Ownership Reference
no
Pasword
no
Picture
no
Primary Key
no
Readonly
no
RTF
no
Sortable
no
Summary Type
None
Supports EQUALS_IN
no
Type
char(3)
UI Memo Editor
no
UI Width
Medium
User Login
no
Visible
yes
Policy_Kind - Supported Filters
Filter Type
Default
Include Nulls
Hidden by Default
Equals
NULL
no
no
Row_Version
Property
Value
Auto Complete
no
Data Filter
no
Default Value
None
Enter Stop
yes
Ignore for Insert Order
no
Is Entity Name
no
Max Length
-1
Order
5
Ownership Reference
no
Pasword
no
Picture
no
Primary Key
no
Readonly
no
RTF
no
Sortable
no
Summary Type
None
Supports EQUALS_IN
no
Type
timestamp
UI Memo Editor
no
UI Width
Medium
User Login
no
Visible
no