Documentation
    {{docApp.userSession.userId}}
    {{docApp.userSession.userName}}
    {{docApp.userSession.email}}
    Issuer : {{docApp.userSession.issuerInstance}}
    Expires : {{new Date(docApp.userSession.validUntil).toLocaleDateString()}}

{{docApp.title}}

{{docApp.description}}

How can we help?

{{docApp.searchError}}
{{product.name}}

Searching in {{docApp.searchFilterBySpecificBookTitle}}

{{docApp.searchResultFilteredItems.length}} results for: {{docApp.currentResultsSearchText}} in {{docApp.searchFilterBySpecificBookTitle}}
Search results have been limited. There are a total of {{docApp.searchResponse.totalResultsAvailable}} matches.

You have an odd number of " characters in your search terms - each one needs closing with a matching " character!

{{docApp.libraryHomeViewProduct.title || docApp.libraryHomeViewProduct.id}}

{{docApp.libraryHomeViewProduct.description}}

  1. {{book.title}}

{{group.title || group.id}}

{{group.description}}

  1. {{book.title}}

{{group.title}}

{{book.title}}
More...

Change Requests

  • Article
  • 7 minutes to read

Details

Table ID: h_itsm_changerequests

Change specific information for Requests (see h_itsm_requests for more information)

Table Attributes

Name Value
Primary Key h_fk_reference

Columns

Name & ID Description Column Attributes Relationships
Backout Plan
h_backout_plan
 The backout plan of the change
Type LONGTEXT
Nullable true
Change Classification
h_change_category
 The category of the change (Major, Significant, Minor)
Type VARCHAR
Size 100
Nullable true
Change Justification
h_change_justification
 The justification of this change
Type LONGTEXT
Nullable true
Change Type
h_change_type
 Type of Change
Type VARCHAR
Size 128
Nullable true
Communication Plan
h_communication_plan
 The communication plan of the change
Type LONGTEXT
Nullable true
Custom 21
h_custom_21
 Custom Field 21
Type DATETIME
Nullable true
Custom 22
h_custom_22
 Custom Field 22
Type DATETIME
Nullable true
Custom 23
h_custom_23
 Custom Field 23
Type DATETIME
Nullable true
Custom 24
h_custom_24
 Custom Field 24
Type DATETIME
Nullable true
Custom 25
h_custom_25
 Custom Field 25
Type DATETIME
Nullable true
Custom 26
h_custom_26
 Custom Field 26
Type INTEGER
Nullable true
Custom 27
h_custom_27
 Custom Field 27
Type INTEGER
Nullable true
Custom 28
h_custom_28
 Custom Field 28
Type INTEGER
Nullable true
Custom 29
h_custom_29
 Custom Field 29
Type INTEGER
Nullable true
Custom 30
h_custom_30
 Custom Field 30
Type INTEGER
Nullable true
Custom 31
h_custom_31
 Custom Field 31
Type LONGTEXT
Nullable true
Custom 32
h_custom_32
 Custom Field 32
Type LONGTEXT
Nullable true
Custom 33
h_custom_33
 Custom Field 33
Type LONGTEXT
Nullable true
Custom 34
h_custom_34
 Custom Field 34
Type LONGTEXT
Nullable true
Custom 35
h_custom_35
 Custom Field 35
Type LONGTEXT
Nullable true
Custom 36
h_custom_36
 Custom Field 36
Type LONGTEXT
Nullable true
Custom 37
h_custom_37
 Custom Field 37
Type LONGTEXT
Nullable true
Custom 38
h_custom_38
 Custom Field 38
Type LONGTEXT
Nullable true
Custom 39
h_custom_39
 Custom Field 39
Type LONGTEXT
Nullable true
Custom 40
h_custom_40
 Custom Field 40
Type LONGTEXT
Nullable true
Custom 41
h_custom_41
 Custom Field 41
Type VARCHAR
Size 255
Nullable true
Custom 42
h_custom_42
 Custom Field 42
Type VARCHAR
Size 255
Nullable true
Custom 43
h_custom_43
 Custom Field 43
Type VARCHAR
Size 255
Nullable true
Custom 44
h_custom_44
 Custom Field 44
Type VARCHAR
Size 255
Nullable true
Custom 45
h_custom_45
 Custom Field 45
Type VARCHAR
Size 255
Nullable true
Custom 46
h_custom_46
 Custom Field 46
Type VARCHAR
Size 255
Nullable true
Custom 47
h_custom_47
 Custom Field 47
Type VARCHAR
Size 255
Nullable true
Custom 48
h_custom_48
 Custom Field 48
Type VARCHAR
Size 255
Nullable true
Custom 49
h_custom_49
 Custom Field 49
Type VARCHAR
Size 255
Nullable true
Custom 50
h_custom_50
 Custom Field 50
Type VARCHAR
Size 255
Nullable true
Custom 51
h_custom_51
 Custom Field 51
Type VARCHAR
Size 255
Nullable true
Custom 52
h_custom_52
 Custom Field 52
Type VARCHAR
Size 255
Nullable true
Custom 53
h_custom_53
 Custom Field 53
Type VARCHAR
Size 255
Nullable true
Custom 54
h_custom_54
 Custom Field 54
Type VARCHAR
Size 255
Nullable true
Custom 55
h_custom_55
 Custom Field 55
Type VARCHAR
Size 255
Nullable true
Custom 56
h_custom_56
 Custom Field 56
Type VARCHAR
Size 255
Nullable true
Custom 57
h_custom_57
 Custom Field 57
Type VARCHAR
Size 255
Nullable true
Custom 58
h_custom_58
 Custom Field 58
Type VARCHAR
Size 255
Nullable true
Custom 59
h_custom_59
 Custom Field 59
Type VARCHAR
Size 255
Nullable true
Custom 60
h_custom_60
 Custom Field 60
Type VARCHAR
Size 255
Nullable true
Custom 61
h_custom_61
 Custom Field 61
Type LONGTEXT
Nullable true
Custom 62
h_custom_62
 Custom Field 62
Type LONGTEXT
Nullable true
Custom 63
h_custom_63
 Custom Field 63
Type LONGTEXT
Nullable true
Custom 64
h_custom_64
 Custom Field 64
Type LONGTEXT
Nullable true
Custom 65
h_custom_65
 Custom Field 65
Type LONGTEXT
Nullable true
Custom 66
h_custom_66
 Custom Field 66
Type LONGTEXT
Nullable true
Custom 67
h_custom_67
 Custom Field 67
Type LONGTEXT
Nullable true
Custom 68
h_custom_68
 Custom Field 68
Type LONGTEXT
Nullable true
Custom 69
h_custom_69
 Custom Field 69
Type LONGTEXT
Nullable true
Custom 70
h_custom_70
 Custom Field 70
Type LONGTEXT
Nullable true
Custom 71
h_custom_71
 Custom Field 71
Type INTEGER
Nullable true
Custom 72
h_custom_72
 Custom Field 72
Type INTEGER
Nullable true
Custom 73
h_custom_73
 Custom Field 73
Type INTEGER
Nullable true
Custom 74
h_custom_74
 Custom Field 74
Type INTEGER
Nullable true
Custom 75
h_custom_75
 Custom Field 75
Type INTEGER
Nullable true
Custom 76
h_custom_76
 Custom Field 76
Type DATETIME
Nullable true
Custom 77
h_custom_77
 Custom Field 77
Type DATETIME
Nullable true
Custom 78
h_custom_78
 Custom Field 78
Type DATETIME
Nullable true
Custom 79
h_custom_79
 Custom Field 79
Type DATETIME
Nullable true
Custom 80
h_custom_80
 Custom Field 80
Type DATETIME
Nullable true
Custom A
h_custom_a
 Custom Field A
Type VARCHAR
Size 255
Nullable true
Custom B
h_custom_b
 Custom Field B
Type VARCHAR
Size 255
Nullable true
Custom C
h_custom_c
 Custom Field C
Type VARCHAR
Size 255
Nullable true
Custom D
h_custom_d
 Custom Field D
Type VARCHAR
Size 255
Nullable true
Custom E
h_custom_e
 Custom Field E
Type VARCHAR
Size 255
Nullable true
Custom F
h_custom_f
 Custom Field F
Type VARCHAR
Size 255
Nullable true
Custom G
h_custom_g
 Custom Field G
Type VARCHAR
Size 255
Nullable true
Custom H
h_custom_h
 Custom Field H
Type VARCHAR
Size 255
Nullable true
Custom I
h_custom_i
 Custom Field I
Type VARCHAR
Size 255
Nullable true
Custom J
h_custom_j
 Custom Field J
Type VARCHAR
Size 255
Nullable true
Custom K
h_custom_k
 Custom Field K
Type VARCHAR
Size 255
Nullable true
Custom L
h_custom_l
 Custom Field L
Type VARCHAR
Size 255
Nullable true
Custom M
h_custom_m
 Custom Field M
Type VARCHAR
Size 255
Nullable true
Custom N
h_custom_n
 Custom Field N
Type VARCHAR
Size 255
Nullable true
Custom O
h_custom_o
 Custom Field O
Type VARCHAR
Size 255
Nullable true
Custom P
h_custom_p
 Custom Field P
Type LONGTEXT
Nullable true
Custom Q
h_custom_q
 Custom Field Q
Type LONGTEXT
Nullable true
Custom R
h_custom_r
 Custom Field R
Type LONGTEXT
Nullable true
Custom S
h_custom_s
 Custom Field S
Type LONGTEXT
Nullable true
Custom T
h_custom_t
 Custom Field T
Type LONGTEXT
Nullable true
Disruption Level
h_disruption_level
 The disruption level of the change
Type VARCHAR
Size 255
Nullable true
End Time
h_end_time
 The start datetime that the change is scheduled to take place on
Type DATETIME
Nullable true
Implementation Plan
h_implementation_plan
 The implementation plan of the change
Type LONGTEXT
Nullable true
Is the Change scheduled
h_scheduled
 Flag whether this request has been scheduled in change calendar
Type INTEGER
Nullable true
Last Updated
h_last_updated
 This stores the date time that this was last updated
Type DATETIME
Nullable true
Proposed End Time
h_proposed_end_time
 The proposed end time of the change
Type DATETIME
Nullable true
Proposed Start Time
h_proposed_start_time
 The proposed start time of the change
Type DATETIME
Nullable true
Request ID
h_fk_reference
 Foreign key to relating this Change to the Request table
Type VARCHAR
Size 100
Nullable false
Primary Key true
One to One
Requests
h_itsm_requests.h_pk_reference
RequestsExtended
h_sm_requests_extended.h_request_id
Security Implication
h_security_implication
 The security implication of the change
Type LONGTEXT
Nullable true
Start Time
h_start_time
 The start datetime that the change is scheduled to take place on
Type DATETIME
Nullable true
Support Plan
h_support_plan
 The support plan of the change
Type LONGTEXT
Nullable true
Test Plan
h_test_plan
 The test plan of the change
Type LONGTEXT
Nullable true
  • Version {{docApp.book.version}}
  • Node {{docApp.node}} / {{docApp.build}}
In This Document