Rooms Inventory
Field Name |
Caption |
Mask |
Description |
Field Type |
BR_AACCOUNT |
Asset Account # |
45x |
Asset Account # |
Text |
BR_ACCESS_CD |
Access Type |
nnn |
Access Type |
Integer |
BR_ACCESS_TY |
Access Type Text |
50x |
Access Type Text |
Text |
BR_APNUMACT |
Asset Proj No - Acct |
40x |
Asset Proj No - Acct |
Text |
BR_AREA |
Area |
nnnnnn.nn |
Area |
Double |
BR_AZONE_CD |
Alternate Zone |
10x |
Alternate Zone |
String |
BR_AZONE_TY |
Alternate Zone Text |
60x |
Alternate Zone Text |
String |
BR_BELEV |
Base Elevation |
-nnnnnnnn.nn |
Base Elevation |
Double |
BR_BF_ID |
Floor Rec # |
nnnnnnnn |
Long Integer |
|
BR_BL_ID |
Bldg Rec # |
nnnnnnnn |
Long Integer |
|
BR_BR_CD |
Default WO Cat |
10x |
Category |
Text |
BR_BR_TY |
Default WO Cat Text |
60x |
Category Text |
Text |
BR_CEIL_CD |
Ceiling |
nnn |
Ceiling |
Integer |
BR_CEIL_HT |
Ceiling Height |
nnn.nn |
Ceiling Height |
Double |
BR_CEIL_TY |
Ceiling Text |
25x |
Ceiling Text |
Text |
BR_CLCONCD |
Ceiling Condition |
nnn |
Ceiling Condition |
Integer |
BR_CLCONTTY |
Ceiling Cond Text |
25x |
Ceiling Condition Text |
Text |
BR_CLINPDT |
Ceiling Insp Date |
mm/dd/yyyy |
Ceiling Inspection Date |
Date/Time |
BR_CLINSDT |
Ceiling Install Date |
mm/dd/yyyy |
Ceiling Installation Date |
Date/Time |
BR_CLNINDT |
Nxt Ceiling Insp Dt |
mm/dd/yyyy |
Next Ceiling Inspection Date |
Date/Time |
BR_CLREPCT |
Est Ceiling Repl Cst |
nnnnnnnn |
Estimated Ceiling Replacement Cost |
Long Integer |
BR_CLREPDT |
Est Ceiling Repl Dt |
mm/dd/yyyy |
Estimated Ceiling Replacement Date |
Date/Time |
BR_COMMENT1 |
Long Note |
|
Long Note |
Memo |
BR_COND_CD |
Last Condition Code |
nnn |
Last Condition Code |
Integer |
BR_COND_TY |
Last Condition Text |
100x |
Last Condition Text |
Text |
BR_COVERCD |
Window Covering |
nnn |
Window Covering |
Integer |
BR_COVERTY |
Window Covering Text |
25x |
Window Covering Text |
Text |
BR_CRT_BY |
Created By |
25x |
Created By |
Text |
BR_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
Date/Time |
BR_DEPT_CD |
Department |
nnn |
Department: |
Integer |
BR_DEPT_TY |
Department Text |
25X |
Department Text: |
Text |
BR_DESCR |
Room Description |
40x |
Description |
Text |
BR_DOC_FLG |
Document Available |
|
Document Flag |
Boolean |
BR_DOOR_CD |
Door |
nnn |
Door |
Integer |
BR_DOOR_TY |
Door Text |
25x |
Door Text |
Text |
BR_DRCONCD |
Door Condition |
nnn |
Door Condition |
Integer |
BR_DRCONTTY |
Door Cond Text |
25x |
Door Condition Text |
Text |
BR_DRINPDT |
Door Insp Date |
mm/dd/yyyy |
Door Inspection Date |
Date/Time |
BR_DRINSDT |
Door Install Dt |
mm/dd/yyyy |
Door Installation Date |
Date/Time |
BR_DRNINDT |
Nxt Door Insp Dt |
mm/dd/yyyy |
Next Door Inspection Date |
Date/Time |
BR_DRREPCT |
Est Door Repl Cost |
nnnnnnnn |
Estimated Door Replacement Cost |
Long Integer |
BR_DRREPDT |
Est Door Repl Date |
mm/dd/yyyy |
Estimated Door Replacement Date |
Date/Time |
BR_FASSET |
Fixed Asset ID |
nnnnnnnn |
Fixed Asset ID |
Long Integer |
BR_FDESCR |
Description |
255x |
Description |
Text |
BR_FLCONCD |
Flooring Condition |
nnn |
Flooring Condition |
Integer |
BR_FLCONTTY |
Flooring Cond Text |
25x |
Flooring Condition Text |
Text |
BR_FLINPDT |
Flooring Insp Date |
mm/dd/yyyy |
Flooring Inspection Date |
Date/Time |
BR_FLINSDT |
Flooring Install Dt |
mm/dd/yyyy |
Flooring Installation Date |
Date/Time |
BR_FLNINDT |
Nxt Floor Insp Dt |
mm/dd/yyyy |
Next Flooring Inspection Date |
Date/Time |
BR_FLOORCD |
Flooring |
nnn |
Flooring |
Integer |
BR_FLOORTY |
Flooring Type |
25x |
Flooring Type |
Text |
BR_FLREPCT |
Est Floor Repl Cost |
nnnnnnnn |
Estimated Flooring Replacement Cost |
Long Integer |
BR_FLREPDT |
Est Floor Repl Date |
mm/dd/yyyy |
Estimated Flooring Replacement Date |
Date/Time |
BR_FNAME |
Full Name |
100x |
Full Name |
Text |
BR_FNUM |
Floor Number |
5x |
Floor Number |
Text |
BR_FORM_CD |
Space Form |
nnn |
Space Form |
Integer |
BR_FORM_TY |
Space Form Text |
50x |
Space Form Text |
Text |
BR_FUNC_CD |
Space Function |
nnn |
Space Function |
Integer |
BR_FUNC_TY |
Space Function Text |
50x |
Space Function Text |
Text |
BR_GISNEED_CD |
Needs GIS |
nnn |
Needs GIS |
Integer |
BR_GISNEED_TY |
Needs GIS Text |
100x |
Needs GIS Text |
Text |
BR_ID |
Room Rec # |
nnnnnnnn |
AutoNumber |
Long Integer |
BR_IFREQ |
Inspection Freq |
nnn |
Inspection Freq |
Integer |
BR_IFRQ_CD |
Inspection Freq Units |
nnn |
Inspection Freq Units |
Integer |
BR_IFRQ_TY |
Inspection Freq Units Text |
10x |
Inspection Freq Units Text |
Text |
BR_IMG_FLG |
|
|
Image Flag |
Boolean |
BR_INMAP |
In Map Flag |
|
|
Boolean |
BR_LAST_DT |
Last Condition Date |
mm/dd/yyyy hh:mm am |
Last Condition Date |
DateTime |
BR_LIGHTCD |
Lighting |
nnn |
Lighting |
Integer |
BR_LIGHTTY |
Lighting Text |
25x |
Lighting Text |
Text |
BR_LOCK_CD |
Door Lock |
nnn |
Door Lock |
Integer |
BR_LOCK_TY |
Door Lock Text |
25x |
Door Lock Text |
Text |
BR_LWOT_DT |
Last WO Task Date |
mm/dd/yyyy |
Last WO Task Date |
DateTime |
BR_MAXOCC1 |
Max Occupancy 1 |
nnnnnn |
Max Occupancy 1 |
Long Integer |
BR_MAXOCC2 |
Max Occupancy 2 |
nnnnnn |
Max Occupancy 2 |
Long Integer |
BR_MOD_BY |
Last Modified By |
25x |
Modified By |
Text |
BR_MOD_DT |
Last Modified Date |
mm/dd/yyyy |
Modified Date |
Date/Time |
BR_MOD_TM |
Last Modified Time |
hh:mm am |
Modified Time |
Date/Time |
BR_MOV_FLG |
|
|
Movie Flag |
Boolean |
BR_MZONE_CD |
Maintenance Zone |
10x |
Maintenance Zone |
String |
BR_MZONE_TY |
Maintenance Zone Text |
60x |
Maintenance Zone Text |
String |
BR_NEXT_DT |
Next Inspection Date |
mm/dd/yyyy hh:mm am |
Next Inspection Date |
DateTime |
BR_NOWORK |
No WO/PM/Req |
|
No WO/PM/Req |
Boolean |
BR_OCC1_CD |
Occupancy 1 |
nnn |
Occupancy 1 |
Integer |
BR_OCC1_TY |
Occupancy 1 Text |
25x |
Occupancy 1 Text |
Text |
BR_OCC2_CD |
Occupancy 2 |
nnn |
Occupancy 2 |
Integer |
BR_OCC2_TY |
Occupancy 2 Text |
25x |
Occupancy 2 Text |
Text |
BR_OCCUP |
Occupant |
30x |
Occupant |
Text |
BR_PHONE |
Phone # |
30x |
Phone # |
Text |
BR_PP_CD |
Primary Paint |
nnn |
Primary Paint |
Integer |
BR_PP_TY |
Primary Paint Text |
25x |
Primary Paint Text |
Text |
BR_ROWVER |
|
|
Rowversion for optimistic locking |
Date/Time |
BR_SC_ID |
Floor Sec Rec # |
nnnnnnnn |
Link to EFFLSEC - Floor Section |
Long Integer |
BR_SP_CD |
Secondary Paint |
nnn |
Secondary Paint |
Integer |
BR_SP_TY |
Secondary Paint Text |
25x |
Secondary Paint Text |
Text |
BR_SPEC1 |
Spec 1 |
30x |
Spec 1 |
Text |
BR_SPEC10 |
Spec 10 |
30x |
Spec 10 |
Text |
BR_SPEC11 |
Spec 11 |
30x |
Spec 11 |
Text |
BR_SPEC12 |
Spec 12 |
30x |
Spec 12 |
Text |
BR_SPEC13 |
Spec 13 |
30x |
Spec 13 |
Text |
BR_SPEC14 |
Spec 14 |
30x |
Spec 14 |
Text |
BR_SPEC15 |
Spec 15 |
30x |
Spec 15 |
Text |
BR_SPEC16 |
Spec 16 |
30x |
Spec 16 |
Text |
BR_SPEC17 |
Spec 17 |
30x |
Spec 17 |
Text |
BR_SPEC18 |
Spec 18 |
30x |
Spec 18 |
Text |
BR_SPEC19 |
Spec 19 |
30x |
Spec 19 |
Text |
BR_SPEC2 |
Spec 2 |
30x |
Spec 2 |
Text |
BR_SPEC20 |
Spec 20 |
30x |
Spec 20 |
Text |
BR_SPEC3 |
Spec 3 |
30x |
Spec 3 |
Text |
BR_SPEC4 |
Spec 4 |
30x |
Spec 4 |
Text |
BR_SPEC5 |
Spec 5 |
30x |
Spec 5 |
Text |
BR_SPEC6 |
Spec 6 |
30x |
Spec 6 |
Text |
BR_SPEC7 |
Spec 7 |
30x |
Spec 7 |
Text |
BR_SPEC8 |
Spec 8 |
30x |
Spec 8 |
Text |
BR_SPEC9 |
Spec 9 |
30x |
Spec 9 |
Text |
BR_STAT_CD |
Status |
nnn |
Status |
Integer |
BR_STAT_TY |
Status Text |
25x |
Status Text |
Text |
BR_SUSE_CD |
Space Use |
nnn |
Space Use |
Integer |
BR_SUSE_TY |
Space Use Text |
50x |
Space Use Text |
Text |
BR_SWTCHCD |
Light Switch |
nnn |
Light Switch |
Integer |
BR_SWTCHTY |
Light Switch Text |
25x |
Light Switch Text |
Text |
BR_TYPECD |
Type |
nnn |
Type Code |
Integer |
BR_TYPETY |
Type Text |
25x |
Type Text |
Text |
BR_UNIQUE |
Room ID |
20x |
Unique ID |
Text |
BR_USER10 |
User 10 |
mm/dd/yyyy |
User 10 |
Date/Time |
BR_USER11 |
User 11 |
mm/dd/yyyy |
User 11 |
Date/Time |
BR_USER12 |
User 12 |
mm/dd/yyyy |
User 12 |
Date/Time |
BR_USER13 |
User 13 |
|
User 13 |
Boolean |
BR_USER14 |
User 14 |
|
User 14 |
Boolean |
BR_USER15 |
User 15 |
|
User 15 |
Boolean |
BR_USER16CD |
User 16 |
nnn |
User 16 |
Small Integer |
BR_USER16TY |
User 16 Text |
50x |
User 16 Text |
String |
BR_USER17CD |
User 17 |
nnn |
User 17 |
Small Integer |
BR_USER17TY |
User 17 Text |
50x |
User 17 Text |
String |
BR_USER18CD |
User 18 |
nnn |
User 18 |
Small Integer |
BR_USER18TY |
User 18 Text |
50x |
User 18 Text |
String |
BR_USER19CD |
User 19 |
nnn |
User 19 |
Small Integer |
BR_USER19TY |
User 19 Text |
50x |
User 19 Text |
String |
BR_USER1CD |
User 1 |
nnn |
User 1 Code |
Integer |
BR_USER1TY |
User 1 Text |
25x |
User 1 Text |
Text |
BR_USER20CD |
User 20 |
nnn |
User 20 |
Small Integer |
BR_USER20TY |
User 20 Text |
50x |
User 20 Text |
String |
BR_USER21 |
User 21 |
50x |
User 21 |
String |
BR_USER22 |
User 22 |
50x |
User 22 |
String |
BR_USER23 |
User 23 |
50x |
User 23 |
String |
BR_USER24 |
User 24 |
50x |
User 24 |
String |
BR_USER25 |
User 25 |
50x |
User 25 |
String |
BR_USER26 |
User 26 |
-nnnnnnnn.nn |
User 26 |
Double |
BR_USER27 |
User 27 |
-nnnnnnnn.nn |
User 27 |
Double |
BR_USER28 |
User 28 |
-nnnnnnnn.nn |
User 28 |
Double |
BR_USER29 |
User 29 |
-nnnnnnnn.nn |
User 29 |
Double |
BR_USER2CD |
User 2 |
nnn |
User 2 Code |
Integer |
BR_USER2TY |
User 2 Text |
25x |
User 2 Text |
Text |
BR_USER30 |
User 30 |
-nnnnnnnn.nn |
User 30 |
Double |
BR_USER31 |
User 31 |
mm/dd/yyyy |
User 31 |
DateTime |
BR_USER32 |
User 32 |
mm/dd/yyyy |
User 32 |
DateTime |
BR_USER33 |
User 33 |
mm/dd/yyyy |
User 33 |
DateTime |
BR_USER34 |
User 34 |
mm/dd/yyyy |
User 34 |
DateTime |
BR_USER35 |
User 35 |
mm/dd/yyyy |
User 35 |
DateTime |
BR_USER36 |
User 36 |
|
User 36 |
Boolean |
BR_USER37 |
User 37 |
|
User 37 |
Boolean |
BR_USER38 |
User 38 |
|
User 38 |
Boolean |
BR_USER39 |
User 39 |
|
User 39 |
Boolean |
BR_USER3CD |
User 3 |
nnn |
User 3 Code |
Integer |
BR_USER3TY |
User 3 Text |
25x |
User 3 Text |
Text |
BR_USER40 |
User 40 |
|
User 40 |
Boolean |
BR_USER4 |
User 4 |
30x |
User 4 |
Text |
BR_USER5 |
User 5 |
30x |
User 5 |
Text |
BR_USER6 |
User 6 |
30x |
User 6 |
Text |
BR_USER7 |
User 7 |
-nnnnnnnn.nn |
User 7 |
Double |
BR_USER8 |
User 8 |
-nnnnnnnn.nn |
User 8 |
Double |
BR_USER9 |
User 9 |
-nnnnnnnn.nn |
User 9 |
Double |
BR_WACONCD |
Wall Cov Condition |
nnn |
Wall Covering Condition |
Integer |
BR_WACONTTY |
Wall Cov Cond Text |
25x |
Wall Covering Condition Text |
Text |
BR_WAINPDT |
Wall Cov Insp Date |
mm/dd/yyyy |
Wall Covering Inspection Date |
Date/Time |
BR_WAINSDT |
Wall Cov Install Dt |
mm/dd/yyyy |
Wall Covering Installation Date |
Date/Time |
BR_WALL_CD |
Wall Type |
nnn |
Wall Type |
Integer |
BR_WALL_TY |
Wall Type Text |
25x |
Wall Type Text |
Text |
BR_WANINDT |
Nxt Wall Cov Insp Dt |
mm/dd/yyyy |
Next Wall Covering Inspection Date |
Date/Time |
BR_WAREPCT |
Est Wall Cov Repl Ct |
nnnnnnnn |
Estimated Wall Covering Replacement Cost |
Long Integer |
BR_WAREPDT |
Est Wall Cov Repl Dt |
mm/dd/yyyy |
Estimated Wall Covering Replacement Date |
Date/Time |
BR_WCCONCD |
WinCover Condition |
nnn |
Window Covering Condition |
Integer |
BR_WCCONTTY |
WinCover Cond Text |
25x |
Window Covering Condition Text |
Text |
BR_WCINPDT |
WinCover Insp Date |
mm/dd/yyyy |
Window Covering Inspection Date |
Date/Time |
BR_WCINSDT |
WinCover Install Dt |
mm/dd/yyyy |
Window Covering Installation Date |
Date/Time |
BR_WCNINDT |
Nxt WinCover Insp Dt |
mm/dd/yyyy |
Next Window Covering Inspection Date |
Date/Time |
BR_WCREPCT |
Est WinCover Repl Ct |
nnnnnnnn |
Estimated Window Covering Replacement Cost |
Long Integer |
BR_WCREPDT |
Est WinCover Repl Dt |
mm/dd/yyyy |
Estimated Window Covering Replacement Date |
Date/Time |
BR_WDCONCD |
Window Condition |
nnn |
Window Condition |
Integer |
BR_WDCONTTY |
Window Cond Text |
25x |
Window Condition Text |
Text |
BR_WDINPDT |
Window Insp Date |
mm/dd/yyyy |
Window Inspection Date |
Date/Time |
BR_WDINSDT |
Window Install Dt |
mm/dd/yyyy |
Window Installation Date |
Date/Time |
BR_WDNINDT |
Nxt Window Insp Dt |
mm/dd/yyyy |
Next Window Inspection Date |
Date/Time |
BR_WDREPCT |
Est Window Repl Cost |
nnnnnnnn |
Estimated Window Replacement Cost |
Long Integer |
BR_WDREPDT |
Est Window Repl Date |
mm/dd/yyyy |
Estimated Window Replacement Date |
Date/Time |
BR_WIND_CD |
Window |
nnn |
Window |
Integer |
BR_WIND_TY |
Window Text |
25x |
Window Text |
Text |
BR_WO_COMM |
WO Comment |
255x |
Short Work Order Comment |
Text |
BR_X |
X Coordinate |
-nnnnnnnn.nn |
X Coordinate |
Double |
BR_Y |
Y Coordinate |
-nnnnnnnn.nn |
Y Coordinate |
Double |