Skip to main content

Releases & Change Management - Key Tables

Full column listings for the 2 key tables in this category.

CHANGESEQ (40 columns)

# Column Type Length Nullable Default
1 id int NO
2 lastseq int YES
3 faults int YES
4 actions int YES
5 requesttype int YES
6 tstatus int YES
7 slahead int YES
8 policy int YES
9 toutcome int YES
10 lookup int YES
11 stocklevel int YES
12 faultitem int YES
13 item int YES
14 area int YES
15 site int YES
16 users int YES
17 appointment int YES
18 uname int YES
19 sectiondetail int YES
20 categorydetail int YES
21 device int YES
22 xtype int YES
23 info int YES
24 typeinfo int YES
25 field int YES
26 holidays int YES
27 company int YES
28 organisation int YES
29 release int YES
30 releaseproduct int YES
31 customfieldvisibility int YES
32 WorkflowHeader int YES
33 Mailbox int YES
34 Fieldinfo int YES ((0))
35 AutoAssign int YES ((0))
36 FieldGroup int YES ((0))
37 FlowHeader int YES ((0))
38 CustomFieldValueRestrictions int YES ((0))
39 RemoteSessionData int YES ((0))
40 categoryRestrictions int YES ((0))

RELEASE (20 columns)

# Column Type Length Nullable Default
1 RLid int NO
2 RLstatus int YES ((0))
3 RLdesc nvarchar 4000 YES
4 RLWhoReleased int YES ((0))
5 RLReleaseDate datetime YES
6 RLNote ntext 1073741823 YES
7 RLrpid int YES ((0))
8 RLchangeseq int YES ((0))
9 RLseq int YES ((0))
10 rlrelease1emaildate datetime YES ((0))
11 rlrelease2emaildate datetime YES ((0))
12 rlrelease3emaildate datetime YES ((0))
13 rlpublicnote nvarchar 4000 YES ('')
14 RLJiraName nvarchar 100 YES ('')
15 RLmajorVersion int YES ((0))
16 RLminorVersion int YES ((0))
17 RLPatchNumber int YES ((0))
18 RLrbId int YES
19 RLbuildDate datetime YES ((0))
20 rltargetdate datetime YES ((0))
Back to top