STRDRAMP

Road Ramp

Field Name

Caption

Mask

Description

Field Type

RP_ALTID

Alt Ramp ID

20x

Alt Ramp ID

Text

RP_AZONE_CD

Alternate Zone

10x

Alternate Zone

String

RP_AZONE_TY

Alternate Zone Text

60x

Alternate Zone Text

String

RP_BOFFSET1

Beginning Offset 1

nnnnnnnn.nn

Beginning Offset 1

Double

RP_BOFFSET2

Beginning Offset 2

nnnnnnnn.nn

Beginning Offset 2

Double

RP_BRMS

Beginning Ramp Mainline Station

nnnnnnnn.nn

Beginning Ramp Mainline Station

Double

RP_BRSTN

Beginning Ramp Station

nnnnnnnn.nn

Beginning Ramp Station

Double

RP_BR_CD

Default WO Cat

10x

Default Category Code

Text

RP_BR_TY

Default WO Cat Text

60x

Default Category Text

Text

RP_BSW

Begin Station With

 

Begin Station With

Boolean

RP_COF

Consequence of Failure

nnnn.

Consequence of Failure

Double

RP_CRT_BY

Created By

25x

Created By

Text

RP_CRT_DTTM

Creation Date Time

mm/dd/yyyy hh:mm am

Creation Date Time

Date/Time

RP_DIS_CD

District

5x

District

Text

RP_DIS_TY

District Text

50x

District Text

Text

RP_DOC_FLG

Document Available

 

Doc Available: Doc Flag

Boolean

RP_EOFFSET1

Ending Offset 1

nnnnnnnn.nn

Ending Offset 1

Double

RP_EOFFSET2

Ending Offset 2

nnnnnnnn.nn

Ending Offset 2

Double

RP_ERMS

Ending Ramp Mainline Station

nnnnnnnn.nn

Ending Ramp Mainline Station

Double

RP_ERSTN

Ending Ramp Station

nnnnnnnn.nn

Ending Ramp Station

Double

RP_ESW

End Station With

 

End Station With

Boolean

RP_FBRP

From Beg Ref Post

nnnnnnnn.nnn

From Beginning Reference Post

Double

RP_FBXC

From Beg X Coord

-nnnnnnnn.nnnn

From Beginning X Coordinate

Double

RP_FBYC

From Beg Y Coord

-nnnnnnnn.nnnn

From Beginning Y Coordinate

Double

RP_FCBS

From Curr Beg Station

nnnnnnnn.nn

From Current Beginning Stationing

Double

RP_FCES

From Curr End Station

nnnnnnnn.nn

From Current Ending Stationing

Double

RP_FERP

From End Ref Post

nnnnnnnn.nnn

From Ending Reference Post

Double

RP_FEXC

From End X Coord

-nnnnnnnn.nnnn

From Ending X Coordinate

Double

RP_FEYC

From End Y Coord

-nnnnnnnn.nnnn

From Ending Y Coordinate

Double

RP_FOBS

From Org. Beg Station

nnnnnnnn.nnn

From Original Beginning Stationing

Double

RP_FOES

From Org. End Station

nnnnnnnn.nnn

From Original Ending Stationing

Double

RP_FROM

From Road

60x

From Road

Text

RP_ID

Road Ramp Rec ID

nnnnnnnn

Road Seg Rec ID

Long Integer

RP_INMAP

In Map

 

In Map Flag

Boolean

RP_MITIGAT

Mitigation

nnnnnnnn.nn

Mitigation

Double

RP_MOD_BY

Last Modified By

25x

Last Modified By

Text

RP_MOD_DT

Last Modified Date

mm/dd/yyyy

Last Modified Date

Date/Time

RP_MOD_TM

Last Modified Time

hh:mm am

Modified Time

Date/Time

RP_MZONE_CD

Maintenance Zone

10x

Maintenance Zone

String

RP_MZONE_TY

Maintenance Zone Text

60x

Maintenance Zone Text

String

RP_NOWORK

No WO/PM/Req

 

No WO/PM/Req

Boolean

RP_POF

Probability of Failure

nnn.nn

Probability of Failure

Double

RP_PVALUE

Present Value

nnnnnnnnn.nn

Present Value

Double

RP_RCOST

Replacement Cost

nnnnn.nn

Replacement Cost

Double

RP_REPL_DT

Replacement Date

mm/dd/yyyy

Replacement Date

Date/Time

RP_RHFR_ID

From Road Rec ID

nnnnnnnn

From Road - Link to STRDROAD.RH_ID

Long Integer

RP_RHTO_ID

To Road Rec ID

nnnnnnnn

To Road - Link to STRDROAD.RH_ID

Long Integer

RP_RISK

Risk

nnnn.

Risk - COF * POF

Double

RP_RMPLEN

Ramp Length

nnnnnnnn.nn

Ramp Length

Double

RP_RLIFE

Remaining Life

nnnn.nn

Remaining Life

Double

RP_ROWVER

 

 

Rowversion for optimistic locking

Date/Time

RP_RSFR_ID

From Road Seg Rec ID

nnnnnnnn

From Road Seg - Link to STRDSEG.RS_ID

Long Integer

RP_RSTO_ID

To Road Seg Rec ID

nnnnnnnn

To Road - Link to STRDSEG.RS_ID

Long Integer

RP_RVALUE

Replacement Value

nnnnnnnnn.nn

Replacement Value

Double

RP_SDIS_CD

SubDistrict

5x

SubDistrict

Text

RP_SDIS_TY

SubDistrict Text

50x

SubDistrict Text

Text

RP_STAT_CD

Status

nnn

Status

Integer

RP_STAT_TY

Status Text

25x

Status Text

Text

RP_STYPE_CD

Sub-Type

nnn

Sub-Type

Integer

RP_STYPE_TY

Sub-Type Text

25x

Sub-Type Text

Text

RP_SUPER

Supervisor

60x

Supervisor

Text

RP_TBRP

To Beg Ref Post

nnnnnnnn.nnn

To Beginning Reference Post

Double

RP_TBXC

To Beg X Coord

-nnnnnnnn.nnnn

To Beginning X Coordinate

Double

RP_TBYC

To Beg Y Coord

-nnnnnnnn.nnnn

To Beginning Y Coordinate

Double

RP_TCBS

To Curr Beg Station

nnnnnnnn.nn

To Current Beginning Stationing

Double

RP_TCES

To Curr End Station

nnnnnnnn.nn

To Current Ending Stationing

Double

RP_TERP

To End Ref Post

nnnnnnnn.nnn

To Ending Reference Post

Double

RP_TEXC

To Ending X Coord

-nnnnnnnn.nnnn

To Ending X Coordinate

Double

RP_TEYC

To Ending Y Coord

-nnnnnnnn.nnnn

To Ending Y Coordinate

Double

RP_TO

To Road

60x

To Road

Text

RP_TOBS

To Org. Beg Station

nnnnnnnn.nn

To Original Beginning Stationing

Double

RP_TOES

To Org. End Station

nnnnnnnn.nn

To Original Ending Stationing

Double

RP_TYPE_CD

Type

10x

Type

Text

RP_TYPE_TY

Type Text

60x

Type Text

Text

RP_USER1CD

User 1

nnn

User 1

Integer

RP_USER1TY

User 1 Text

25x

User 1 Text

Text

RP_USER2CD

User 2

nnn

User 2

Integer

RP_USER2TY

User 2 Text

25x

User 2 Text

Text

RP_USER3CD

User 3

nnn

User 3

Integer

RP_USER3TY

User 3 Text

25x

User 3 Text

Text

RP_USER4

User 4

30x

User 4

Text

RP_USER5

User 5

30x

User 5

Text

RP_USER6

User 6

30x

User 6

Text

RP_USER7

User 7

nnnnnnnn.nn

User 7

Double

RP_USER8

User 8

nnnnnnnn.nn

User 8

Double

RP_USER9

User 9

nnnnnnnn.nn

User 9

Double

RP_USER10

User 10

mm/dd/yyyy

User 10

Date/Time

RP_USER11

User 11

mm/dd/yyyy

User 11

Date/Time

RP_USER12

User 12

mm/dd/yyyy

User 12

Date/Time

RP_USER13

User 13

 

User 13

Boolean

RP_USER14

User 14

 

User 14

Boolean

RP_USER15

User 15

 

User 15

Boolean

RP_USER16CD

User 16

nnn

User 16

Integer

RP_USER16TY

User 16 Text

50x

User 16 Text

String

RP_USER17CD

User 17

nnn

User 17

Integer

RP_USER17TY

User 17 Text

50x

User 17 Text

String

RP_USER18CD

User 18

nnn

User 18

Integer

RP_USER18TY

User 18 Text

50x

User 18 Text

String

RP_USER19CD

User 19

nnn

User 19

Integer

RP_USER19TY

User 19 Text

50x

User 19 Text

String

RP_USER20CD

User 20

nnn

User 20

Integer

RP_USER20TY

User 20 Text

50x

User 20 Text

String

RP_USER21

User 21

50x

User 21

String

RP_USER22

User 22

50x

User 22

String

RP_USER23

User 23

50x

User 23

String

RP_USER24

User 24

50x

User 24

String

RP_USER25

User 25

50x

User 25

String

RP_USER26

User 26

nnnnnnnn.nn

User 26

Double

RP_USER27

User 27

nnnnnnnn.nn

User 27

Double

RP_USER28

User 28

nnnnnnnn.nn

User 28

Double

RP_USER29

User 29

nnnnnnnn.nn

User 29

Double

RP_USER30

User 30

nnnnnnnn.nn

User 30

Double

RP_USER31

User 31

mm/dd/yyyy hh:mm am

User 31

DateTime

RP_USER32

User 32

mm/dd/yyyy hh:mm am

User 32

DateTime

RP_USER33

User 33

mm/dd/yyyy hh:mm am

User 33

DateTime

RP_USER34

User 34

mm/dd/yyyy hh:mm am

User 34

DateTime

RP_USER35

User 35

mm/dd/yyyy hh:mm am

User 35

DateTime

RP_USER36

User 36

 

User 36

Boolean

RP_USER37

User 37

 

User 37

Boolean

RP_USER38

User 38

 

User 38

Boolean

RP_USER39

User 39

 

User 39

Boolean

RP_USER40

User 40

 

User 40

Boolean

RP_WO_COMM

WO Comment

255x

WO Comment

Text

RP_YARD_CD

Yard

5x

Yard

Text

RP_YARD_TY

Yard Text

50x

Yard Text

Text