Roof Inventory
Field Name |
Caption |
Mask |
Description |
Field Type |
RF_AACCOUNT |
Asset Account # |
45x |
Asset Account # |
Text |
RF_ADINSCD |
Above Deck Insul |
nnn |
Above Deck Insulation |
Integer |
RF_ADINSTY |
Above Deck Insul Text |
25x |
Above Deck Insulation Text |
Text |
RF_AGE |
Age |
nnn |
Age |
Integer |
RF_APNUMACT |
Asset Proj No - Acct |
40x |
Asset Proj No - Acct |
Text |
RF_AREA |
Roof Area (S.F.) |
nnnnnn.n |
Roof Area (S.F.) |
Double |
RF_AST_CST |
Asset Cost |
-nnnnnnnn.nn |
Asset Cost |
Double |
RF_AZONE_CD |
Alternate Zone |
10x |
Alternate Zone |
String |
RF_AZONE_TY |
Alternate Zone Text |
60x |
Alternate Zone Text |
String |
RF_BDINSCD |
Below Deck Insul |
nnn |
Below Deck Insulation |
Integer |
RF_BDINSTY |
Below Deck Insul Text |
25x |
Below Deck Insulation Text |
Text |
RF_BL_ID |
Bldg Rec # |
nnnnnnnn |
Long Integer |
|
RF_BR_CD |
Default WO Cat |
10x |
Category |
Text |
RF_BR_TY |
Default WO Cat Text |
60x |
Category Text |
Text |
RF_BUILTUP |
Built-up |
|
Built-up |
Boolean |
RF_COF |
Consequence of Failure |
-nnnnnnnn.nn |
Consequence of Failure |
Double |
RF_COMMENT1 |
Long Note |
|
Long Note |
Memo |
RF_COND_CD |
Overall Condition |
nnn |
Overall Condition |
Integer |
RF_COND_TY |
Overall Condition Text |
25x |
Overall Condition Text |
Text |
RF_CRT_BY |
Created By |
25x |
Created By |
Text |
RF_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
Date/Time |
RF_DECK_CD |
Decking |
nnn |
Decking |
Integer |
RF_DECK_TY |
Decking Text |
25x |
Decking Text |
Text |
RF_DESC |
Area Description |
40x |
Area Description |
Text |
RF_DOC_FLG |
Document Available |
|
Document Flag |
Boolean |
RF_FASSET |
Fixed Asset ID |
nnnnnnnn |
Fixed Asset ID |
Long Integer |
RF_FM_OTH |
Other |
30x |
Other |
Text |
RF_FOAM |
Foam |
|
Foam |
Boolean |
RF_GISNEED_CD |
Needs GIS |
nnn |
Needs GIS |
Integer |
RF_GISNEED_TY |
Needs GIS Text |
100x |
Needs GIS Text |
Text |
RF_HEIGHT |
Dist above Ground |
nnnn |
Height above Ground |
Integer |
RF_ID |
Roof Rec # |
nnnnnnnn |
Roof Record No |
Long Integer |
RF_IFREQ |
Inspection Freq |
nnn |
Inspection Freq |
Small Integer |
RF_IFRQ_CD |
Inspection Freq Units |
nnn |
Inspection Freq Units |
Small Integer |
RF_IFRQ_TY |
Inspection Freq Units Text |
10x |
Inspection Freq Units Text |
String |
RF_IMG_FLG |
|
|
Image Flag |
Boolean |
RF_INMAP |
In Map? |
|
In Map Flag |
Boolean |
RF_INSP_DT |
Date Inspected |
mm/dd/yyyy |
Date Inspected |
Date/Time |
RF_INST_DT |
Installation Date |
mm/dd/yyyy |
Installation Date |
DateTime |
RF_LIFE |
Asset Life (Years) |
-nnnnnnnn.nn |
Asset Life (Years) |
Double |
RF_LWOT_DT |
Last WO Task Date |
mm/dd/yyyy |
Last WO Task Date |
DateTime |
RF_MAN_CD |
Manufacturer |
nnn |
Manufacturer |
Integer |
RF_MAN_TY |
Manufacturer Text |
25x |
Manufacturer Text |
Text |
RF_MCONTR |
Maint Contractor |
30x |
Maint Contractor |
Text |
RF_MD_BIT |
Modified Bitumen |
|
Modified Bitumen |
Boolean |
RF_METAL |
Metal |
|
Metal |
Boolean |
RF_MITIGAT |
Mitigation |
-nnnnnnnn.nn |
Mitigation |
Double |
RF_MOD_BY |
Last Modified By |
25x |
Modified By |
Text |
RF_MOD_DT |
Last Modified Date |
mm/dd/yyyy |
Modified Date |
Date/Time |
RF_MOD_TM |
Last Modified Time |
hh:mm am |
Modified Time |
Date/Time |
RF_MOV_FLG |
|
|
Movie Flag |
Boolean |
RF_MZONE_CD |
Maintenance Zone |
10x |
Maintenance Zone |
String |
RF_MZONE_TY |
Maintenance Zone Text |
60x |
Maintenance Zone Text |
String |
RF_NOWORK |
No WO/PM/Req |
|
No WO/PM/Req |
Boolean |
RF_NUMLAY |
Number of Layers |
nnn |
Number of Layers |
Integer |
RF_NXT_DT |
Next Inspection |
mm/dd/yyyy |
Next Inspection |
Date/Time |
RF_PITCHCD |
Pitch |
nnn |
Pitch |
Integer |
RF_PITCHTY |
Pitch Text |
25x |
Pitch Text |
Text |
RF_POF |
Probability of Failure |
-nnnnnnnn.nn |
Probability of Failure |
Double |
RF_PVALUE |
Present Value |
-nnnnnnnn.nn |
Present Value |
Double |
RF_REPLCST |
Estimated Replacement Cost |
nnnnnnnn |
Estimated Replacement Cost |
Long Integer |
RF_REPL_DT |
Replacement Date |
mm/dd/yyyy |
Replacement Date |
Date/Time |
RF_REPR_DT |
Repair Date |
mm/dd/yyyy |
Repair Date |
Date/Time |
RF_RFRAMCD |
Framing |
nnn |
Framing |
Integer |
RF_RFRAMTY |
Framing Text |
25x |
Framing Text |
Text |
RF_RISK |
Risk |
-nnnnnnnn.nn |
Risk |
Double |
RF_RLIFE |
Remaining Life |
-nnnnnnnn.nn |
Remaining Life |
Double |
RF_ROWVER |
|
|
Rowversion for optimistic locking |
Date/Time |
RF_SP_BAL |
Single ply,Ballasted |
|
Single ply,Ballasted |
Boolean |
RF_SP_FAS |
Single ply,Fastened |
|
Single ply,Fastened |
Boolean |
RF_SSHING |
Sloped Shingle |
|
Sloped Shingle |
Boolean |
RF_STAT_CD |
Status |
nnn |
Status |
Integer |
RF_STAT_TY |
Status Text |
25x |
Status Text |
Text |
RF_SVALUE |
Salvage Value |
-nnnnnnnn.nn |
Salvage Value |
Double |
RF_TILE |
Tile |
|
Tile |
Boolean |
RF_UNIF_CD |
Uniformat II |
10x |
Uniformat II |
String |
RF_UNIF_TY |
Uniformat II Text |
60x |
Uniformat II Text |
String |
RF_UNIQUE |
Roof ID |
20x |
Roof ID |
Text |
RF_USER10 |
User 10 |
mm/dd/yyyy |
User 10 |
Date/Time |
RF_USER11 |
User 11 |
mm/dd/yyyy |
User 11 |
Date/Time |
RF_USER12 |
User 12 |
mm/dd/yyyy |
User 12 |
Date/Time |
RF_USER13 |
User 13 |
|
User 13 |
Boolean |
RF_USER14 |
User 14 |
|
User 14 |
Boolean |
RF_USER15 |
User 15 |
|
User 15 |
Boolean |
RF_USER16CD |
User 16 |
nnn |
User 16 |
Small Integer |
RF_USER16TY |
User 16 Text |
50x |
User 16 Text |
String |
RF_USER17CD |
User 17 |
nnn |
User 17 |
Small Integer |
RF_USER17TY |
User 17 Text |
50x |
User 17 Text |
String |
RF_USER18CD |
User 18 |
nnn |
User 18 |
Small Integer |
RF_USER18TY |
User 18 Text |
50x |
User 18 Text |
String |
RF_USER19CD |
User 19 |
nnn |
User 19 |
Small Integer |
RF_USER19TY |
User 19 Text |
50x |
User 19 Text |
String |
RF_USER1CD |
User 1 |
nnn |
User 1 Code |
Integer |
RF_USER1TY |
User 1 Text |
25x |
User 1 Text |
Text |
RF_USER20CD |
User 20 |
nnn |
User 20 |
Small Integer |
RF_USER20TY |
User 20 Text |
50x |
User 20 Text |
String |
RF_USER21 |
User 21 |
50x |
User 21 |
String |
RF_USER22 |
User 22 |
50x |
User 22 |
String |
RF_USER23 |
User 23 |
50x |
User 23 |
String |
RF_USER24 |
User 24 |
50x |
User 24 |
String |
RF_USER25 |
User 25 |
50x |
User 25 |
String |
RF_USER26 |
User 26 |
-nnnnnnnn.nn |
User 26 |
Double |
RF_USER27 |
User 27 |
-nnnnnnnn.nn |
User 27 |
Double |
RF_USER28 |
User 28 |
-nnnnnnnn.nn |
User 28 |
Double |
RF_USER29 |
User 29 |
-nnnnnnnn.nn |
User 29 |
Double |
RF_USER2CD |
User 2 |
nnn |
User 2 Code |
Integer |
RF_USER2TY |
User 2 Text |
25x |
User 2 Text |
Text |
RF_USER30 |
User 30 |
-nnnnnnnn.nn |
User 30 |
Double |
RF_USER31 |
User 31 |
mm/dd/yyyy |
User 31 |
DateTime |
RF_USER32 |
User 32 |
mm/dd/yyyy |
User 32 |
DateTime |
RF_USER33 |
User 33 |
mm/dd/yyyy |
User 33 |
DateTime |
RF_USER34 |
User 34 |
mm/dd/yyyy |
User 34 |
DateTime |
RF_USER35 |
User 35 |
mm/dd/yyyy |
User 35 |
DateTime |
RF_USER36 |
User 36 |
|
User 36 |
Boolean |
RF_USER37 |
User 37 |
|
User 37 |
Boolean |
RF_USER38 |
User 38 |
|
User 38 |
Boolean |
RF_USER39 |
User 39 |
|
User 39 |
Boolean |
RF_USER3CD |
User 3 |
nnn |
User 3 Code |
Integer |
RF_USER3TY |
User 3 Text |
25x |
User 3 Text |
Text |
RF_USER40 |
User 40 |
|
User 40 |
Boolean |
RF_USER4 |
User 4 |
30x |
User 4 |
Text |
RF_USER5 |
User 5 |
30x |
User 5 |
Text |
RF_USER6 |
User 6 |
30x |
User 6 |
Text |
RF_USER7 |
User 7 |
nnnnnnnnn.nn |
User 7 |
Double |
RF_USER8 |
User 8 |
nnnnnnnnn.nn |
User 8 |
Double |
RF_USER9 |
User 9 |
nnnnnnnnn.nn |
User 9 |
Double |
RF_VENTCD |
Ventilation |
nnn |
Ventilation |
Integer |
RF_VENTTY |
Ventilation Text |
25x |
Ventilation Text |
Text |
RF_WO_COMM |
WO Comment |
255x |
Short Work Order Comment |
Text |
RF_X |
X Coordinate |
-nnnnnnnn.nn |
X Coordinate |
Double |
RF_Y |
Y Coordinate |
-nnnnnnnn.nn |
Y Coordinate |
Double |