STSIGNLI

Signal Inspections

Field Name

Caption

Mask

Description

Field Type

GB_ACT_CD

Action

nnn

Action

Integer

GB_ACT_DT

Action Date

mm/dd/yyyy

Action Date

Date/Time

GB_ACT_TM

Action Time

hh:mm am

Action Time

Date/Time

GB_ACT_TY

Action Text

25x

Action Text

Text

GB_COND_CD

Condition

nnn

Condition

Integer

GB_COND_TY

Condition Text

50x

Condition Text

Text

GB_COND1_CD

Condition 1

nnn

Conditon 1

Integer

GB_COND1_TY

Condition 1 Text

25x

Condition 1 Text

Text

GB_COND2_CD

Condition 2

nnn

Condition 2

Integer

GB_COND2_TY

Condition 2 Text

25x

Condition 2 Text

Text

GB_CREW

Crew

30x

Gathered By

Text

GB_CRT_BY

Created By

25x

Created By

Text

GB_CRT_DTTM

Creation Date Time

mm/dd/yyyy hh:mm am

Creation Date Time

Date/Time

GB_DESC

Description

80x

Description

Text

GB_DOC_FLG

Document Available

 

Doc Available: Doc Flag

Boolean

GB_GA_ID

Signal Rec #

nnnnnnnn

Link to STSIGNL.GA_ID

Long Integer

GB_ID

Signal Inspection Rec #

nnnnnnnn

Auto Number

Long Integer

GB_LATEST

Most Recent Inspection

 

Most Recent Inspection

Boolean

GB_MOD_BY

Last Modified By

25x

Last Modified By

Text

GB_MOD_DT

Last Modified Date

mm/dd/yyyy

Last Modified Date

Date/Time

GB_MOD_TM

Last Modified Time

hh:mm am

Modified Time

Date/Time

GB_NEEDREP

Needs Repair

 

Needs Repair

Boolean

GB_NXT_DT

Next Action

mm/dd/yyyy

Next Action Date

Date/Time

GB_ROWVER

 

 

Rowversion for optimistic locking

Date/Time

GB_USER10

User 10

mm/dd/yyyy

User 10

Date/Time

GB_USER11

User 11

mm/dd/yyyy

User 11

Date/Time

GB_USER12

User 12

mm/dd/yyyy

User 12

Date/Time

GB_USER13

User 13

 

User 13

Boolean

GB_USER14

User 14

 

User 14

Boolean

GB_USER15

User 15

 

User 15

Boolean

GB_USER16CD

User 16

nnn

User 16

Integer

GB_USER16TY

User 16 Text

25x

User 16 Text

Text

GB_USER17CD

User 17

nnn

User 17

Integer

GB_USER17TY

User 17 Text

25x

User 17 Text

Text

GB_USER18CD

User 18

nnn

User 18

Integer

GB_USER18TY

User 18 Text

25x

User 18 Text

Text

GB_USER19CD

User 19

nnn

User 19

Integer

GB_USER19TY

User 19 Text

25x

User 19 Text

Text

GB_USER1CD

User 1

nnn

User 1

Integer

GB_USER1TY

User 1 Text

25x

User 1 Text

Text

GB_USER20CD

User 20

nnn

User 20

Integer

GB_USER20TY

User 20 Text

25x

User 20 Text

Text

GB_USER21

User 21

30x

User 21

Text

GB_USER22

User 22

30x

User 22

Text

GB_USER23

User 23

30x

User 23

Text

GB_USER24

User 24

30x

User 24

Text

GB_USER25

User 25

30x

User 25

Text

GB_USER26

User 26

nnnnnnnn.nn

User 26

Double

GB_USER27

User 27

nnnnnnnn.nn

User 27

Double

GB_USER28

User 28

nnnnnnnn.nn

User 28

Double

GB_USER29

User 29

nnnnnnnn.nn

User 29

Double

GB_USER2CD

User 2

nnn

User 2

Integer

GB_USER2TY

User 2 Text

25x

User 2 Text

Text

GB_USER30

User 30

nnnnnnnn.nn

User 30

Double

GB_USER31

User 31

mm/dd/yyyy

User 31

Date/Time

GB_USER32

User 32

mm/dd/yyyy

User 32

Date/Time

GB_USER33

User 33

mm/dd/yyyy

User 33

Date/Time

GB_USER34

User 34

mm/dd/yyyy

User 34

Date/Time

GB_USER35

User 35

mm/dd/yyyy

User 35

Date/Time

GB_USER36

User 36

 

User 36

Boolean

GB_USER37

User 37

 

User 37

Boolean

GB_USER38

User 38

 

User 38

Boolean

GB_USER39

User 39

 

User 39

Boolean

GB_USER3CD

User 3

nnn

User 3

Integer

GB_USER3TY

User 3 Text

25x

User 3 Text

Text

GB_USER4

User 4

30x

User 4

Text

GB_USER40

User 40

 

User 40

Boolean

GB_USER5

User 5

30x

User 5

Text

GB_USER6

User 6

30x

User 6

Text

GB_USER7

User 7

-nnnnnnnnn.nn

User 7

Double

GB_USER8

User 8

-nnnnnnnnn.nn

User 8

Double

GB_USER9

User 9

-nnnnnnnnn.nn

User 9

Double

GB_WO_ID

Work Order Rec #

nnnnnnnn

Link to WKORDER.WO_ID

Long Integer