ST_CRHISTORY

This table provides the change request history - one record for every revision.

Column Field Type Length Primary Description

1

ServerID

int

4

Y

Server ID

2

ID

int

4

Y

ObjectID

3

RevisionNumber

int

4

Y

Number of revisions since branching

4

CreatedTime

datetime

8

N

Creation time

5

CreatedUserID

varchar

254

N

Creation user

6

ModifiedTime

datetime

8

N

Time last modified

7

ModifiedUserID

varchar

254

N

User who last modified

8

RevisionFlags

int

4

N

Revision Flags

9

StComment

text

16

N

Comment

10

RootObjectID

int

4

N

ObjectID of the root object

11

ParentObjectID

int

4

N

Object ID of item from which this item is branched from

12

ParentRevision

int

4

N

 

13

PathRevision

int

4

N

Revision of branching (0 means no branching)

14

ViewID

int

4

N

View ID

15

DotNotation

varchar

254

N

Dot notation

16

ChangeNumber

int

4

N

Change Request Number

17

Synopsis

text

16

N

Synopsis

18

Type

varchar

254

N

Type

19

Status

varchar

254

N

Status

20

Severity

varchar

254

N

Severity

21

Platform

varchar

254

N

Platform

22

Category

varchar

192

N

Category

23

Component

varchar

192

N

Component

24

ExternalReference

varchar

192

N

External Reference

25

AddressedIn

varchar

254

N

Addressed In

26

AddressedBy

varchar

254

N

Addressed By

27

LastBuildTested

varchar

254

N

Last Build Tested

28

Responsibility

varchar

254

N

Responsibility

29

Priority

varchar

254

N

Priority

30

Description

text

16

N

Description

31

TestCommand

varchar

762

N

 

32

WorkAround

text

16

N

Work Around

33

Fix

text

16

N

Fix

34

ClosedOn

datetime

8

N

Time closed

35

AttachmentCount

int

4

N

Attachment Count

36

AttachmentNames

text

16

N

Names of all attachments

37

ResolvedOn

datetime

8

N

Time resolved

38

VerifiedOn

datetime

8

N

Time verified

39

AddressedInView

int

4

N

 

40

EnteredOn

datetime

8

N

Time when CR entered

41

EnteredBy

varchar

254

N

User who entered CR

42

Usr_StarFlowStatus

varchar

254

N

 

Table Joins

Column Primary Table Primary Field Foreign Table Foreign Field

1

ST_CRS

ServerID

ST_CRHISTORY

ServerID

2

ST_CRS

ID

ST_CRHISTORY

ID

1

ST_CRHISTORY

ServerID

ST_VIEWMEMBER

ServerID

2

ST_CRHISTORY

ID

ST_VIEWMEMBER

ID

3

STCRHISTORY

RevisionNumber

STVIEWMEMBER

RevisionNumber