STSERVPLAN

Signal Controller Phase and Service Plan

Field Name

Caption

Mask

Description

Field Type

SE_CM_ID

Controller Rec #

nnnnnnnn

Link to STCNTRLINV.CM_ID

Long Integer

SE_CRT_BY

Created By

25x

Created By

Text

SE_CRT_DTTM

Creation Date Time

mm/dd/yyyy hh:mm am

Creation Date Time

Date/Time

SE_CYCLE

Cycle

nn

Cycle

Integer

SE_ID

Rec #

 

AutoID

Long Integer

SE_MOD_BY

Last Modified By

25x

Last Modified By

Text

SE_MOD_DT

Last Modified Date

mm/dd/yyyy

Last Modified Date

Date/Time

SE_MOD_TM

Last Modified Time

hh:mm am

Modified Time

Date/Time

SE_ROWVER

 

 

Rowversion for optimistic locking

Date/Time

SE_S1MP_CD

Max Plan S1

nnn

Max Plan S1

Integer

SE_S1MP_TY

Max Plan S1 Text

25x

Max Plan S1 Text

Text

SE_S1R1_CD

Split 1 Ring 1

nnn

Split 1 Ring 1

Integer

SE_S1R1_TY

Split 1 Ring 1 Text

25x

Split 1 Ring 1 Text

Text

SE_S1R2_CD

Split 1 Ring 2

nnn

Split 1 Ring 2

Integer

SE_S1R2_TY

Split 1 Ring 2 Text

25x

Split 1 Ring 2 Text

Text

SE_S1SP_CD

Service Plan S1

nnn

Service Plan S1

Integer

SE_S1SP_TY

Service Plan S1 Text

25x

Service Plan S1 Text

Text

SE_S2MP_CD

Max Plan S2

nnn

Max Plan S2

Integer

SE_S2MP_TY

Max Plan S2 Text

25x

Max Plan S2 Text

Text

SE_S2R1_CD

Split 2 Ring 1

nnn

Split 2 Ring 1

Integer

SE_S2R1_TY

Split 2 Ring 1 Text

25x

Split 2 Ring 1 Text

Text

SE_S2R2_CD

Split 2 Ring 2

nnn

Split 2 Ring 2

Integer

SE_S2R2_TY

Split 2 Ring 2 Text

25x

Split 2 Ring 2 Text

Text

SE_S2SP_CD

Service Plan S2

nnn

Service Plan S2

Integer

SE_S2SP_TY

Service Plan S2 Text

25x

Service Plan S2 Text

Text

SE_S3MP_CD

Max Plan S3

nnn

Max Plan S3

Integer

SE_S3MP_TY

Max Plan S3 Text

25x

Max Plan S3 Text

Text

SE_S3R1_CD

Split 3 Ring 1

nnn

Split 3 Ring 1

Integer

SE_S3R1_TY

Split 3 Ring 1 Text

25x

Split 3 Ring 1 Text

Text

SE_S3R2_CD

Split 3 Ring 2

nnn

Split 3 Ring 2

Integer

SE_S3R2_TY

Split 3 Ring 2 Text

25x

Split 3 Ring 2 Text

Text

SE_S3SP_CD

Service Plan S3

nnn

Service Plan S3

Integer

SE_S3SP_TY

Service Plan S3 Text

25x

Service Plan S3 Text

Text

SE_S4MP_CD

Max Plan S4

nnn

Max Plan S4

Integer

SE_S4MP_TY

Max Plan S4 Text

25x

Max Plan S4 Text

Text

SE_S4R1_CD

Split 4 Ring 1

nnn

Split 4 Ring 1

Integer

SE_S4R1_TY

Split 4 Ring 1 Text

25x

Split 4 Ring 1 Text

Text

SE_S4R2_CD

Split 4 Ring 2

nnn

Split 4 Ring 2

Integer

SE_S4R2_TY

Split 4 Ring 2 Text

25x

Split 4 Ring 2 Text

Text

SE_S4SP_CD

Service Plan S4

nnn

Service Plan S4

Integer

SE_S4SP_TY

Service Plan S4 Text

25x

Service Plan S4 Text

Text