CMFCABLE

Fiber Optic Cables

Field Name

Caption

Mask

Description

Field Type

FA_AACCOUNT

Asset Account #

45x

Asset Account #

Text

FA_APNUMACT

Asset Proj No - Acct

40x

Asset Proj No - Acct

Text

FA_AZONE_CD

Alternate Zone

10x

Alternate Zone

String

FA_AZONE_TY

Alternate Zone Text

60x

Alternate Zone Text

String

FA_BR_CD

Default WO Cat

10x

Default WO Cat

String

FA_BR_TY

Default WO Cat Text

60x

Default WO Cat Text

String

FA_CLEN

Calculated Length

nnnnnnnn.nn

Calculated Length

Double

FA_COMMENT1

Long Note

 

Long Note

Memo

FA_CORE_CD

Conduit Type

nnn

Conduit Type

integer

FA_CORE_TY

Conduit Type Text

50x

Conduit Type Text

String

FA_COST

Cost

nnnnnnnn.nn

Cost

Double

FA_COUNT

Number of Fibers

nnn

Number of Fibers

integer

FA_CRT_BY

Created By

25x

Created By

String

FA_CRT_DTTM

Creation Date Time

mm/dd/yyyy hh:mm am

Creation Date Time

DateTime

FA_CTYPE_CD

Cable Type

20x

Cable Type

String

FA_CTYPE_TY

Cable Type Text

60x

Cable Type Text

String

FA_DIA

Diameter

nnnnnnnn.nn

Diameter

Double

FA_DOC_FLG

Doc Available: Doc Flag

 

Doc Available: Doc Flag

Boolean

FA_FD_ID

Innerduct Rec #

nnnnnnnn

Link to CMINDUCT.FD_ID

Long Integer

FA_FE_ID

Reel Rec #

nnnnnnnn

Link to CMFREEL.FE_ID

Long Integer

FA_FRM_END

From End

30x

From End

String

FA_GISNEED_CD

Needs GIS

nnn

Needs GIS

Integer

FA_GISNEED_TY

Needs GIS Text

100x

Needs GIS Text

Text

FA_GPS

GPS Flag

 

GPS Flag

Boolean

FA_ID

Cable Rec #

nnnnnnnn

Fiber Cable AutoID

Long Integer

FA_INMAP

In Map Flag

 

In Map Flag

Boolean

FA_INST_DT

Installation Date

mm/dd/yyyy hh:mm am

Installation Date

DateTime

FA_LEN

Measured Length

nnnnnnnn.nn

Measured Length

Double

FA_LOCATION

Location

250x

Location

String

FA_LWOT_DT

Last WO Task Date

mm/dd/yyyy hh:mm am

Last WO Task Date

DateTime

FA_MAINT_CD

Maintenance By

nnn

Maintenance By

integer

FA_MAINT_TY

Maintenance By Text

50x

Maintenance By Text

String

FA_MANU_CD

Manufacturer

nnn

Manufacturer

integer

FA_MANU_TY

Manufacturer Text

60x

Manufacturer Text

String

FA_MOD_BY

Last Modified By:

25x

Last Modified By:

String

FA_MOD_DT

Last Modified Date:

mm/dd/yyyy hh:mm am

Last Modified Date:

DateTime

FA_MOD_TM

Modified Time

mm/dd/yyyy hh:mm am

Modified Time

DateTime

FA_MZONE_CD

Maintenance Zone

10x

Maintenance Zone

String

FA_MZONE_TY

Maintenance Zone Text

60x

Maintenance Zone Text

String

FA_NOWORK

No WO/PM/Req

 

No WO/PM/Req

Boolean

FA_NUMBER

Alt Record #

30x

Fiber Cable CommonID

String

FA_OWN_CD

Owner

nnn

Owner

integer

FA_OWN_TY

Owner Text

100x

Owner Text

String

FA_PART

Part Number

30x

Part Number

String

FA_PLACE_CD

Placement Type

nnn

Placement Type

integer

FA_PLACE_TY

Placement Type Text

50x

Placement Type Text

String

FA_ROWVER

Rowversion for optimistic locking

 

Rowversion for optimistic locking

TimeStamp

FA_STAT_CD

Status

nnn

Status

integer

FA_STAT_TY

Status Text

50x

Status Text

String

FA_TO_END

To End

30x

To End

String

FA_TUBE

Number of Buffer Tubes

nnn

Number of Buffer Tubes

integer

FA_USER10CD

User 10

20x

User 10

String

FA_USER10TY

User 10 Text

60x

User 10 Text

String

FA_USER11

User 11

150x

User 11

String

FA_USER12

User 12

150x

User 12

String

FA_USER13

User 13

150x

User 13

String

FA_USER14

User 14

150x

User 14

String

FA_USER15

User 15

150x

User 15

String

FA_USER16

User 16

nnnnnnnn.nn

User 16

Double

FA_USER17

User 17

nnnnnnnn.nn

User 17

Double

FA_USER18

User 18

nnnnnnnn.nn

User 18

Double

FA_USER19

User 19

nnnnnnnn.nn

User 19

Double

FA_USER1CD

User 1

nnn

User 1

integer

FA_USER1TY

User 1 Text

50x

User 1 Text

String

FA_USER20

User 20

nnnnnnnn.nn

User 20

Double

FA_USER21

User 21

mm/dd/yyyy hh:mm am

User 21

DateTime

FA_USER22

User 22

mm/dd/yyyy hh:mm am

User 22

DateTime

FA_USER23

User 23

mm/dd/yyyy hh:mm am

User 23

DateTime

FA_USER24

User 24

mm/dd/yyyy hh:mm am

User 24

DateTime

FA_USER25

User 25

mm/dd/yyyy hh:mm am

User 25

DateTime

FA_USER26

User 26

 

User 26

Boolean

FA_USER27

User 27

 

User 27

Boolean

FA_USER28

User 28

 

User 28

Boolean

FA_USER29

User 29

 

User 29

Boolean

FA_USER2CD

User 2

nnn

User 2

integer

FA_USER2TY

User 2 Text

50x

User 2 Text

String

FA_USER30

User 30

 

User 30

Boolean

FA_USER31CD

User 31

nnn

User 31

integer

FA_USER31TY

User 31 Text

50x

User 31 Text

String

FA_USER32CD

User 32

nnn

User 32

integer

FA_USER32TY

User 32 Text

50x

User 32 Text

String

FA_USER33CD

User 33

nnn

User 33

integer

FA_USER33TY

User 33 Text

50x

User 33 Text

String

FA_USER34CD

User 34

nnn

User 34

integer

FA_USER34TY

User 34 Text

50x

User 34 Text

String

FA_USER35CD

User 35

nnn

User 35

integer

FA_USER35TY

User 35 Text

50x

User 35 Text

String

FA_USER36CD

User 36

20x

User 36

String

FA_USER36TY

User 36 Text

60x

User 36 Text

String

FA_USER37CD

User 37

20x

User 37

String

FA_USER37TY

User 37 Text

60x

User 37 Text

String

FA_USER38CD

User 38

20x

User 38

String

FA_USER38TY

User 38 Text

60x

User 38 Text

String

FA_USER39CD

User 39

20x

User 39

String

FA_USER39TY

User 39 Text

60x

User 39 Text

String

FA_USER3CD

User 3

nnn

User 3

integer

FA_USER3TY

User 3 Text

50x

User 3 Text

String

FA_USER40CD

User 40

20x

User 40

String

FA_USER40TY

User 40 Text

60x

User 40 Text

String

FA_USER41

User 41

150x

User 41

String

FA_USER42

User 42

150x

User 42

String

FA_USER43

User 43

150x

User 43

String

FA_USER44

User 44

150x

User 44

String

FA_USER45

User 45

150x

User 45

String

FA_USER46

User 46

nnnnnnnn.nn

User 46

Double

FA_USER47

User 47

nnnnnnnn.nn

User 47

Double

FA_USER48

User 48

nnnnnnnn.nn

User 48

Double

FA_USER49

User 49

nnnnnnnn.nn

User 49

Double

FA_USER4CD

User 4

nnn

User 4

integer

FA_USER4TY

User 4 Text

50x

User 4 Text

String

FA_USER50

User 50

nnnnnnnn.nn

User 50

Double

FA_USER51

User 51

mm/dd/yyyy hh:mm am

User 51

DateTime

FA_USER52

User 52

mm/dd/yyyy hh:mm am

User 52

DateTime

FA_USER53

User 53

mm/dd/yyyy hh:mm am

User 53

DateTime

FA_USER54

User 54

mm/dd/yyyy hh:mm am

User 54

DateTime

FA_USER55

User 55

mm/dd/yyyy hh:mm am

User 55

DateTime

FA_USER56

User 56

 

User 56

Boolean

FA_USER57

User 57

 

User 57

Boolean

FA_USER58

User 58

 

User 58

Boolean

FA_USER59

User 59

 

User 59

Boolean

FA_USER5CD

User 5

nnn

User 5

integer

FA_USER5TY

User 5 Text

50x

User 5 Text

String

FA_USER60

User 60

 

User 60

Boolean

FA_USER6CD

User 6

20x

User 6

String

FA_USER6TY

User 6 Text

60x

User 6 Text

String

FA_USER7CD

User 7

20x

User 7

String

FA_USER7TY

User 7 Text

60x

User 7 Text

String

FA_USER8CD

User 8

20x

User 8

String

FA_USER8TY

User 8 Text

60x

User 8 Text

String

FA_USER9CD

User 9

20x

User 9

String

FA_USER9TY

User 9 Text

60x

User 9 Text

String

FA_WO_COMM

Short Work Order Comment

255x

Short Work Order Comment

String

FA_X

Start X Coordinate

nnnnnnnn.nn

Start X Coordinate

Double

FA_X2

End X Coordinate

nnnnnnnn.nn

End X Coordinate

Double

FA_Y

Start Y Coordinate

nnnnnnnn.nn

Start Y Coordinate

Double

FA_Y2

End Y Coordinate

nnnnnnnn.nn

End Y Coordinate

Double