Playground Equipment Inspection
Field Name |
Caption |
Mask |
Description |
Field Type |
EI_BARS_CD |
Bar Support |
nnn |
Bar Support |
Integer |
EI_BARS_CM |
Bar Support Comm |
80x |
Bar Support Comment |
Text |
EI_BARS_TY |
Bar Support Text |
25x |
Bar Support Text |
Text |
EI_CAPS_CD |
Caps/Plugs |
nnn |
Caps/Plugs |
Integer |
EI_CAPS_CM |
Caps/Plugs Comm |
80x |
Caps/Plugs Comment |
Text |
EI_CAPS_TY |
Caps/Plugs Text |
25x |
Caps/Plugs Text |
Text |
EI_CCOV_CD |
Chain Cover |
nnn |
Chain Covers |
Integer |
EI_CCOV_CM |
Chain Cover Comm |
80x |
Chain Cover Comment |
Text |
EI_CCOV_TY |
Chain Cover Text |
25x |
Chain Covers Text |
Text |
EI_CLER_CD |
Clearance |
nnn |
Clearance |
Integer |
EI_CLER_CM |
Clearance Comm |
80x |
Clearance Comment |
Text |
EI_CLER_TY |
Clearance Text |
25x |
Clearance Text |
Text |
EI_CONC_CD |
Concrete Exposure |
nnn |
Concrete Exposure |
Integer |
EI_CONC_CM |
Concrete Expose Comm |
80x |
Concrete Expose Comment |
Text |
EI_CONC_TY |
Concrete Expose Text |
25x |
Concrete Exposure Text |
Text |
EI_COND_CD |
Overall Cond |
nnn |
Overall Condition Code |
Integer |
EI_COND_CM |
Overall Cond Comm |
80x |
Condition Comment |
Text |
EI_COND_TY |
Overall Cond Text |
25x |
Overall Condition Text |
Text |
EI_CREW |
Inspection Crew |
30x |
Inspection Crew |
Text |
EI_CRT_BY |
Created By |
25x |
Created By |
Text |
EI_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
Date/Time |
EI_DEBR_CD |
Debris/Glass |
nnn |
Debris/Broken Glass |
Integer |
EI_DEBR_CM |
Debris/Glass Comm |
80x |
Debris/Glass Comment |
Text |
EI_DEBR_TY |
Debris/Glass Text |
25x |
Debris/Broken Glass Text |
Text |
EI_DOC_FLG |
Document Available |
|
Document Available |
Boolean |
EI_EDGE_CD |
Edges/Points |
nnn |
Edges/Points |
Integer |
EI_EDGE_CM |
Edges/Points Comm |
80x |
Edges/Points Comment |
Text |
EI_EDGE_TY |
Edges/Points Text |
25x |
Edges/Points Text |
Text |
EI_ENTR_CD |
Entrapments |
nnn |
Entrapments |
Integer |
EI_ENTR_CM |
Entrapments Comm |
80x |
Entrapments Comment |
Text |
EI_ENTR_TY |
Entrapments Text |
25x |
Entrapments Text |
Text |
EI_EQ_ID |
Equipment Rec # |
nnnnnnnn |
Long Integer |
|
EI_FAST_CD |
Fastenings |
nnn |
Fastenings |
Integer |
EI_FAST_CM |
Fastenings Comm |
80x |
Fastenings Comment |
Text |
EI_FAST_TY |
Fastenings Text |
25x |
Fastenings Text |
Text |
EI_FIT_CD |
Fittings |
nnn |
Fittings |
Integer |
EI_FIT_CM |
Fittings Comm |
80x |
Fittings Comment |
Text |
EI_FIT_TY |
Fittings Text |
25x |
Fittings Text |
Text |
EI_HAND_CD |
Handles |
nnn |
Handles |
Integer |
EI_HAND_CM |
Handles Comm |
80x |
Handles Comment |
Text |
EI_HAND_TY |
Handles Text |
25x |
Handles Text |
Text |
EI_HBER_CD |
Hanger Bearings |
nnn |
Hanger Bearings |
Integer |
EI_HBER_CM |
Hanger Bearings Comm |
80x |
Hanger Bearings Comment |
Text |
EI_HBER_TY |
Hanger Bearings Text |
25x |
Hanger Bearings Text |
Text |
EI_HOOK_CD |
S-Hooks/C-Hooks |
nnn |
S-Hooks/C-Hooks |
Integer |
EI_HOOK_CM |
S-Hooks/C-Hooks Comm |
80x |
S-Hooks/C-Hooks Comment |
Text |
EI_HOOK_TY |
S-Hooks/C-Hooks Text |
25x |
S-Hooks/C-Hooks Text |
Text |
EI_ID |
Equip Insp Rec # |
|
AutoID; number for record index |
Long Integer |
EI_IMG_FLG |
|
|
Image Available |
Boolean |
EI_INSP_CD |
Inspected By |
5x |
Inspected By |
Text |
EI_INSP_DT |
Inspection Date |
mm/dd/yyyy |
Inspection Date |
Date/Time |
EI_INSP_TM |
Inspection Time |
mm/dd/yyyy hh:mm am |
Inspection Time |
DateTime |
EI_INSP_TY |
Inspected By Text |
30x |
Inspected By Text |
Text |
EI_LATEST |
Most Recent Inspection |
|
Most Recent Inspection |
Boolean |
EI_LEGS_CD |
Leg Support |
nnn |
Leg Support |
Integer |
EI_LEGS_CM |
Leg Support Comm |
80x |
Leg Support Comment |
Text |
EI_LEGS_TY |
Leg Support Text |
25x |
Leg Support Text |
Text |
EI_MAINTREQ |
Maint Requested |
|
Maintenance Requested |
Boolean |
EI_MOD_BY |
Last Modified By |
25x |
Last Modified By |
Text |
EI_MOD_DT |
Last Modified Date |
mm/dd/yyyy |
Last Modified Date |
Date/Time |
EI_MOD_TM |
Last Modified Time |
hh:mm am |
Modified Time |
Date/Time |
EI_MOV_FLG |
|
|
Movie Available |
Boolean |
EI_NEEDREP |
Needs Repair |
|
Needs Repair |
Boolean |
EI_NEXTDT |
Next Inspection |
mm/dd/yyyy |
Next Inspection Date |
Date/Time |
EI_NUTS_CD |
Nuts/Bolts |
nnn |
Nuts & Bolts |
Integer |
EI_NUTS_CM |
Nuts/Bolts Comm |
80x |
Nuts/Bolts Comment |
Text |
EI_NUTS_TY |
Nuts/Bolts Text |
25x |
Nuts & Bolts Text |
Text |
EI_PIVT_CD |
Pivot Points |
nnn |
Pivot Points |
Integer |
EI_PIVT_CM |
Pivot Points Comm |
80x |
Pivot Points Comment |
Text |
EI_PIVT_TY |
Pivot Points Text |
25x |
Pivot Points Text |
Text |
EI_PLAS_CD |
Plastic Components |
nnn |
Plastic Components |
Integer |
EI_PLAS_CM |
Plastic Comp Comm |
80x |
Plastic Comp Comment |
Text |
EI_PLAS_TY |
Plastic Comp Text |
25x |
Plastic Components Text |
Text |
EI_PP_CD |
Pinch Points |
nnn |
Pinch Points |
Integer |
EI_PP_CM |
Pinch Points Comm |
80x |
Pinch Points Comment |
Text |
EI_PP_TY |
Pinch Points Text |
25x |
Pinch Points Text |
Text |
EI_PROT_CD |
Protrusions |
nnn |
Protrusions |
Integer |
EI_PROT_CM |
Protrusions Comm |
80x |
Protrusions Comment |
Text |
EI_PROT_TY |
Protrusions Text |
25x |
Protrusions Text |
Text |
EI_PSUR_CD |
Protective Surface |
nnn |
Protective Surfaces |
Integer |
EI_PSUR_CM |
Protect Surface Comm |
80x |
Protect Surface Comment |
Text |
EI_PSUR_TY |
Protect Surface Text |
25x |
Protective Surfaces Text |
Text |
EI_RAIL_CD |
Hand Rails |
nnn |
Hand Rails |
Integer |
EI_RAIL_CM |
Hand Rails Comm |
80x |
Hand Rails Comment |
Text |
EI_RAIL_TY |
Hand Rails Text |
25x |
Hand Rails Text |
Text |
EI_ROPE_CD |
Chains/Ropes |
nnn |
Chains/Ropes |
Integer |
EI_ROPE_CM |
Chains/Ropes Comm |
80x |
Chains/Ropes Comment |
Text |
EI_ROPE_TY |
Chains/Ropes Text |
25x |
Chains/Ropes Text |
Text |
EI_ROWVER |
|
|
Rowversion for optimistic locking |
Date/Time |
EI_RQ_ID |
Link to Request |
nnnnnnnn |
Long Integer |
|
EI_SEAT_CD |
Seat/Tires |
nnn |
Seats/Tires |
Integer |
EI_SEAT_CM |
Seat/Tires Comm |
80x |
Seat/Tires Comment |
Text |
EI_SEAT_TY |
Seat/Tires Text |
25x |
Seats/Tires Text |
Text |
EI_STAB_CD |
Stability |
nnn |
Stability |
Integer |
EI_STAB_CM |
Stability Comm |
80x |
Stability Comment |
Text |
EI_STAB_TY |
Stability Text |
25x |
Stability Text |
Text |
EI_STEP_CD |
Stairs/Steps/Rungs |
nnn |
Stairs/Steps/Rungs |
Integer |
EI_STEP_CM |
Stairs/Steps Comm |
80x |
Stairs/Steps Comment |
Text |
EI_STEP_TY |
Stairs/Steps Text |
25x |
Stairs/Steps/Rungs Text |
Text |
EI_USER1CD |
User 1 |
nnn |
User 1 |
Integer |
EI_USER1TY |
User 1 Text |
25x |
User 1 Text |
Text |
EI_USER2CD |
User 2 |
nnn |
User 2 |
Integer |
EI_USER2TY |
User 2 Text |
25x |
User 2 Text |
Text |
EI_USER3CD |
User 3 |
nnn |
User 3 |
Integer |
EI_USER3TY |
User 3 Text |
25x |
User 3 Text |
Text |
EI_USER4 |
User 4 |
30x |
User 4 |
Text |
EI_USER5 |
User 5 |
30x |
User 5 |
Text |
EI_USER6 |
User 6 |
30x |
User 6 |
Text |
EI_USER7 |
User 7 |
-nnnnnnnn.nn |
User 7 |
Double |
EI_USER8 |
User 8 |
-nnnnnnnn.nn |
User 8 |
Double |
EI_USER9 |
User 9 |
-nnnnnnnn.nn |
User 9 |
Double |
EI_USER10 |
User 10 |
mm/dd/yyyy |
User 10 |
Date/Time |
EI_USER11 |
User 11 |
mm/dd/yyyy |
User 11 |
Date/Time |
EI_USER12 |
User 12 |
mm/dd/yyyy |
User 12 |
Date/Time |
EI_USER13 |
User 13 |
|
User 13 |
Boolean |
EI_USER14 |
User 14 |
|
User 14 |
Boolean |
EI_USER15 |
User 15 |
|
User 15 |
Boolean |
EI_USER16CD |
User 16 |
nnn |
User 16 |
Integer |
EI_USER16TY |
User 16 Text |
50x |
User 16 Text |
String |
EI_USER17CD |
User 17 |
nnn |
User 17 |
Integer |
EI_USER17TY |
User 17 Text |
50x |
User 17 Text |
String |
EI_USER18CD |
User 18 |
nnn |
User 18 |
Integer |
EI_USER18TY |
User 18 Text |
50x |
User 18 Text |
String |
EI_USER19CD |
User 19 |
nnn |
User 19 |
Integer |
EI_USER19TY |
User 19 Text |
50x |
User 19 Text |
String |
EI_USER20CD |
User 20 |
nnn |
User 20 |
Integer |
EI_USER20TY |
User 20 Text |
50x |
User 20 Text |
String |
EI_USER21 |
User 21 |
50x |
User 21 |
String |
EI_USER22 |
User 22 |
50x |
User 22 |
String |
EI_USER23 |
User 23 |
50x |
User 23 |
String |
EI_USER24 |
User 24 |
50x |
User 24 |
String |
EI_USER25 |
User 25 |
50x |
User 25 |
String |
EI_USER26 |
User 26 |
nnnnnnnn.nn |
User 26 |
Double |
EI_USER27 |
User 27 |
nnnnnnnn.nn |
User 27 |
Double |
EI_USER28 |
User 28 |
nnnnnnnn.nn |
User 28 |
Double |
EI_USER29 |
User 29 |
nnnnnnnn.nn |
User 29 |
Double |
EI_USER30 |
User 30 |
nnnnnnnn.nn |
User 30 |
Double |
EI_USER31 |
User 31 |
mm/dd/yyyy hh:mm am |
User 31 |
DateTime |
EI_USER32 |
User 32 |
mm/dd/yyyy hh:mm am |
User 32 |
DateTime |
EI_USER33 |
User 33 |
mm/dd/yyyy hh:mm am |
User 33 |
DateTime |
EI_USER34 |
User 34 |
mm/dd/yyyy hh:mm am |
User 34 |
DateTime |
EI_USER35 |
User 35 |
mm/dd/yyyy hh:mm am |
User 35 |
DateTime |
EI_USER36 |
User 36 |
|
User 36 |
Boolean |
EI_USER37 |
User 37 |
|
User 37 |
Boolean |
EI_USER38 |
User 38 |
|
User 38 |
Boolean |
EI_USER39 |
User 39 |
|
User 39 |
Boolean |
EI_USER40 |
User 40 |
|
User 40 |
Boolean |
EI_WALL_CD |
Walls/Bedways |
nnn |
Walls & Bedways |
Integer |
EI_WALL_CM |
Walls/Bedways Comm |
80x |
Walls/Bedways Comment |
Text |
EI_WALL_TY |
Walls/Bedways Text |
25x |
Walls & Bedways Text |
Text |
EI_WO_ID |
Work Order Rec # |
nnnnnnnn |
Long Integer |
|
EI_WOOD_CD |
Wood Components |
nnn |
Wood Components |
Integer |
EI_WOOD_CM |
Wood Components Comm |
80x |
Wood Components Comment |
Text |
EI_WOOD_TY |
Wood Component Text |
25x |
Wood Components Text |
Text |