EFRASET

Roof Asset Inventory

Field Name

Caption

Mask

Description

Field Type

RA_AACCOUNT

Asset Account #

45x

Asset Account #

Text

RA_ALTID

Alt ID

20x

Alt ID

Text

RA_APNUMACT

Asset Proj No - Acct

40x

Asset Proj No - Acct

Text

RA_ASSETID

Unique Asset ID

30x

Unique Asset ID

Text

RA_AST_CST

Asset Cost

-nnnnnnnn.nn

Asset Cost

Double

RA_AZONE_CD

Alternate Zone

10x

Alternate Zone

String

RA_AZONE_TY

Alternate Zone Text

60x

Alternate Zone Text

String

RA_BR_CD

Default WO Cat

10x

Category

Text

RA_BR_TY

Default WO Cat Text

60x

Category Text

Text

RA_COF

Consequence of Failure

-nnnnnnnn.nn

Consequence of Failure

Double

RA_COMMENT1

Long Note

 

Long Note

Memo

RA_CRT_BY

Created By

25x

Created By

Text

RA_CRT_DTTM

Creation Date Time

mm/dd/yyyy hh:mm am

Creation Date Time

Date/Time

RA_CT_ID

WO Cat Rec #

-nnnnnnnn

Link to WKCAT.CT_ID

Long Integer

RA_DEPT_CD

Department

nnn

Department Code

Integer

RA_DEPT_TY

Department Text

25x

Department Text

Text

RA_DOC_FLG

Document Available

 

Doc Available: Doc Flag

Boolean

RA_ELEV

Elevation

nnnnnnnn.nn

Elevation

Double

RA_FASSET

Fixed Asset ID

nnnnnnnn

Fixed Asset ID

Long Integer

RA_GISNEED_CD

Needs GIS

nnn

Needs GIS

Integer

RA_GISNEED_TY

Needs GIS Text

100x

Needs GIS Text

Text

RA_ID

Roof Asset Rec #

nnnnnnnnn

General Number

Long Integer

RA_IFREQ

Inspection Freq

nnn

Inspection Freq

Small Integer

RA_IFRQ_CD

Inspection Freq Units

nnn

Inspection Freq Units

Small Integer

RA_IFRQ_TY

Inspection Freq Units Text

10x

Inspection Freq Units Text

String

RA_INMAP

In Map

 

In Map

Boolean

RA_INST_DT

Installation Date

mm/dd/yyyy

Installation Date

Date/Time

RA_LASTDT

Last Insp Date

mm/dd/yyyy

Last Condition

Date/Time

RA_LIFE

Asset Life (Years)

-nnnnnnnn.nn

Asset Life (Years)

Double

RA_LOCATION

General Location

75x

Location

Text

RA_LSTC_CD

Last Condition

nnn

Last Condition Code

Integer

RA_LSTC_TY

Last Condition Text

25x

Last Condition Text

Text

RA_LWOT_DT

Last WO Task Date

mm/dd/yyyy

Last WO Task Date

DateTime

RA_MAIN_CD

Maintained

nnn

Maintained Code

Integer

RA_MAIN_TY

Maintained Text

25x

Maintained Text

Text

RA_MAPNO

Map Number

30x

Map Number

Text

RA_MITIGAT

Mitigation

-nnnnnnnn.nn

Mitigation

Double

RA_MOD_BY

Last Modified By

25x

Last Modified By:

Text

RA_MOD_DT

Last Modified Date

mm/dd/yyyy

Last Modified Date:

Date/Time

RA_MOD_TM

Last Modified Time

hh:mm am

Modified Time

Date/Time

RA_MZONE_CD

Maintenance Zone

10x

Maintenance Zone

String

RA_MZONE_TY

Maintenance Zone Text

60x

Maintenance Zone Text

String

RA_NAME

Name

50x

Name

Text

RA_NEXTDT

Next Insp Date

mm/dd/yyyy

Next Inspection Date

Date/Time

RA_NOWORK

No WO/PM/Req

 

No WO/PM/Req

Boolean

RA_OWN_CD

Owner

nnn

Owner Code

Integer

RA_OWN_TY

Owner Text

100x

Owner Text

Text

RA_POF

Probability of Failure

-nnnnnnnn.nn

Probability of Failure

Double

RA_PVALUE

Present Value

-nnnnnnnn.nn

Present Value

Double

RA_REPL_DT

Replacement Date

mm/dd/yyyy

Replacement Date

DateTime

RA_REPLCST

Estimated Replacement Cost

nnnnnnnn

Estimated Replacement Cost

Long Integer

RA_RF_ID

Roof Rec #

nnnnnnnn

Link to EFROOFINV.RF_ID

Long Integer

RA_RISK

Risk

-nnnnnnnn.nn

Risk

Double

RA_RLIFE

Remaining Life

-nnnnnnnn.nn

Remaining Life

Double

RA_ROWVER

 

 

Rowversion for optimistic locking

Date/Time

RA_STAT_CD

Status

nnn

Status

Integer

RA_STAT_TY

Status Text

25x

Status Text

Text

RA_STYPE_CD

GIS Sub-Type

nnn

Sub-Type

Integer

RA_STYPE_TY

GIS Sub-Type Text

25x

Sub-Type Text

Text

RA_SUBTY_CD

Sub Type

nnn

Sub Type Code

Integer

RA_SUBTY_TY

Sub Type Text

25x

Sub Type Text

Text

RA_SVALUE

Salvage Value

-nnnnnnnn.nn

Salvage Value

Double

RA_TYPE_CD

Type

nnn

Type Code

Integer

RA_TYPE_TY

Type Text

25x

Type Text

Text

RA_UNIF_CD

Uniformat II

10x

Uniformat II

String

RA_UNIF_TY

Uniformat II Text

60x

Uniformat II Text

String

RA_USER10

User 10

30x

User 10

Text

RA_USER11

User 11

30x

User 11

Text

RA_USER12

User 12

30x

User 12

Text

RA_USER13

User 13

nnnnnnnn.nn

User 13

Double

RA_USER14

User 14

nnnnnnnn.nn

User 14

Double

RA_USER15

User 15

nnnnnnnn.nn

User 15

Double

RA_USER16

User 16

nnnnnnnn.nn

User 16

Double

RA_USER17

User 17

nnnnnnnn.nn

User 17

Double

RA_USER18

User 18

nnnnnnnn.nn

User 18

Double

RA_USER19

User 19

nnnnnnnn.nn

User 19

Double

RA_USER1CD

User 1

nnn

User 1 Code

Integer

RA_USER1TY

User 1 Text

25x

User 1 Text

Text

RA_USER20

User 20

nnnnnnnn.nn

User 20

Double

RA_USER21

User 21

nnnnnnnn.nn

User 21

Double

RA_USER22

User 22

mm/dd/yyyy

User 22

Date/Time

RA_USER23

User 23

mm/dd/yyyy

User 23

Date/Time

RA_USER24

User 24

mm/dd/yyyy

User 24

Date/Time

RA_USER25

User 25

 

User 25

Boolean

RA_USER26

User 26

 

User 26

Boolean

RA_USER27

User 27

 

User 28

Boolean

RA_USER28C

User 28

nnn

User28 Code

Integer

RA_USER28T

User 28 Text

25x

User 28 Text

Text

RA_USER29C

User 29

nnn

User 29 Code

Integer

RA_USER29T

User 29 Text

25x

User 29 Text

Text

RA_USER2CD

User 2

nnn

User 2 Code

Integer

RA_USER2TY

User 2 Text

25x

User 2 Text

Text

RA_USER30C

User 30

nnn

User 30 Code

Integer

RA_USER30T

User 30 Text

25x

User 30 Text

Text

RA_USER31C

User 31

nnn

User 31 Code

Integer

RA_USER31T

User 31 Text

25x

User 31 Text

Text

RA_USER32C

User 32

nnn

User 32 Code

Integer

RA_USER32T

User 32 Text

25x

User 32 Text

Text

RA_USER33C

User 33

nnn

User 33 Code

Integer

RA_USER33T

User 33 Text

25x

User 33 Text

Text

RA_USER34

User 34

30x

User 34

Text

RA_USER35

User 35

30x

User 35

Text

RA_USER36

User 36

30x

User 36

Text

RA_USER37

User 37

30x

User 37

Text

RA_USER38

User 38

30x

User 38

Text

RA_USER39

User 39

30x

User 39

Text

RA_USER3CD

User 3

nnn

User 3 Code

Integer

RA_USER3TY

User 3 Text

25x

User 3 Text

Text

RA_USER40

User 40

nnnnnnnn.nn

User 40

Double

RA_USER41

User 41

nnnnnnnn.nn

User 41

Double

RA_USER42

User 42

nnnnnnnn.nn

User 42

Double

RA_USER43

User 43

nnnnnnnn.nn

User 43

Double

RA_USER44

User 44

nnnnnnnn.nn

User 44

Double

RA_USER45

User 45

nnnnnnnn.nn

User 45

Double

RA_USER46

User 46

nnnnnnnn.nn

User 46

Double

RA_USER47

User 47

nnnnnnnn.nn

User 47

Double

RA_USER48

User 48

nnnnnnnn.nn

User 48

Double

RA_USER49

User 49

mm/dd/yyyy

User 49

Date/Time

RA_USER4CD

User 4

nnn

User 4 Code

Integer

RA_USER4TY

User 4 Text

25x

User 4 Text

Text

RA_USER50

User 50

mm/dd/yyyy

User 50

Date/Time

RA_USER51

User 51

mm/dd/yyyy

User 51

Date/Time

RA_USER52

User 52

 

User 52

Boolean

RA_USER53

User 53

 

User 53

Boolean

RA_USER54

User 54

 

User 54

Boolean

RA_USER5CD

User 5

nnn

User 5 Code

Integer

RA_USER5TY

User 5 Text

25x

User 5 Text

Text

RA_USER6CD

User 6

nnn

User 6 Code

Integer

RA_USER6TY

User 6 Text

25x

User 6 Text

Text

RA_USER7

User 7

30x

User 7

Text

RA_USER8

User 8

30x

User 8

Text

RA_USER9

User 9

30x

User 9

Text

RA_WO_COMM

WO Comment

255x

Short Work Order Comment

Text

RA_X

X Coordinate

-nnnnnnnnn.nnnnnnnn

X Coordinate

Double

RA_Y

Y Coordinate

-nnnnnnnnn.nnnnnnnn

Y Coordinate

Double