STPERMTIM

Signal Controller Coordination Permissions

Field Name

Caption

Mask

Description

Field Type

CP_CM_ID

Controller Rec #

nnnnnnnn

Link to STCNTRLINV.CM_ID

Long Integer

CP_CRT_BY

Created By

25x

Created By

Text

CP_CRT_DTTM

Creation Date Time

mm/dd/yyyy hh:mm am

Creation Date Time

Date/Time

CP_CYCLE

Cycle

nn

Cycle

Integer

CP_ID

Rec #

 

AutoID

Long Integer

CP_MOD_BY

Last Modified By

25x

Last Modified By

Text

CP_MOD_DT

Last Modified Date

mm/dd/yyyy

Last Modified Date

Date/Time

CP_MOD_TM

Last Modified Time

hh:mm am

Modified Time

Date/Time

CP_P1S1E

Perm1 Split 1 End

nnn

Perm1 Split 1 End

Integer

CP_P1S1S

Perm1 Split 1 Start

nnn

Perm1 Split 1 Start

Integer

CP_P1S2E

Perm1 Split 2 End

nnn

Perm1 Split 2 End

Integer

CP_P1S2S

Perm1 Split 2 Start

nnn

Perm1 Split 2 Start

Integer

CP_P1S3E

Perm1 Split 3 End

nnn

Perm1 Split 3 End

Integer

CP_P1S3S

Perm1 Split 3 Start

nnn

Perm1 Split 3 Start

Integer

CP_P1S4E

Perm1 Split 4 End

nnn

Perm1 Split 4 End

Integer

CP_P1S4S

Perm1 Split 4 Start

nnn

Perm1 Split 4 Start

Integer

CP_P2S1E

Perm2 Split 1 End

nnn

Perm2 Split 1 End

Integer

CP_P2S1S

Perm2 Split 1 Start

nnn

Perm2 Split 1 Start

Integer

CP_P2S2E

Perm2 Split 2 End

nnn

Perm2 Split 2 End

Integer

CP_P2S2S

Perm2 Split 2 Start

nnn

Perm2 Split 2 Start

Integer

CP_P2S3E

Perm2 Split 3 End

nnn

Perm2 Split 3 End

Integer

CP_P2S3S

Perm2 Split 3 Start

nnn

Perm2 Split 3 Start

Integer

CP_P2S4E

Perm2 Split 4 End

nnn

Perm2 Split 4 End

Integer

CP_P2S4S

Perm2 Split 4 Start

nnn

Perm2 Split 4 Start

Integer

CP_P3S1E

Perm3 Split 1 End

nnn

Perm3 Split 1 End

Integer

CP_P3S1S

Perm3 Split 1 Start

nnn

Perm3 Split 1 Start

Integer

CP_P3S2E

Perm3 Split 2 End

nnn

Perm3 Split 2 End

Integer

CP_P3S2S

Perm3 Split 2 Start

nnn

Perm3 Split 2 Start

Integer

CP_P3S3E

Perm3 Split 3 End

nnn

Perm3 Split 3 End

Integer

CP_P3S3S

Perm3 Split 3 Start

nnn

Perm3 Split 3 Start

Integer

CP_P3S4E

Perm3 Split 4 End

nnn

Perm3 Split 4 End

Integer

CP_P3S4S

Perm3 Split 4 Start

nnn

Perm3 Split 4 Start

Integer

CP_P4S1E

Perm4 Split 1 End

nnn

Perm4 Split 1 End

Integer

CP_P4S1S

Perm4 Split 1 Start

nnn

Perm4 Split 1 Start

Integer

CP_P4S2E

Perm4 Split 2 End

nnn

Perm4 Split 2 End

Integer

CP_P4S2S

Perm4 Split 2 Start

nnn

Perm4 Split 2 Start

Integer

CP_P4S3E

Perm4 Split 3 End

nnn

Perm4 Split 3 End

Integer

CP_P4S3S

Perm4 Split 3 Start

nnn

Perm4 Split 3 Start

Integer

CP_P4S4E

Perm4 Split 4 End

nnn

Perm4 Split 4 End

Integer

CP_P4S4S

Perm4 Split 4 Start

nnn

Perm4 Split 4 Start

Integer

CP_P5S1E

Perm5 Split 1 End

nnn

Perm5 Split 1 End

Integer

CP_P5S1S

Perm5 Split 1 Start

nnn

Perm5 Split 1 Start

Integer

CP_P5S2E

Perm5 Split 2 End

nnn

Perm5 Split 2 End

Integer

CP_P5S2S

Perm5 Split 2 Start

nnn

Perm5 Split 2 Start

Integer

CP_P5S3E

Perm5 Split 3 End

nnn

Perm5 Split 3 End

Integer

CP_P5S3S

Perm5 Split 3 Start

nnn

Perm5 Split 3 Start

Integer

CP_P5S4E

Perm5 Split 4 End

nnn

Perm5 Split 4 End

Integer

CP_P5S4S

Perm5 Split 4 Start

nnn

Perm5 Split 4 Start

Integer

CP_P6S1E

Perm6 Split 1 End

nnn

Perm6 Split 1 End

Integer

CP_P6S1S

Perm6 Split 1 Start

nnn

Perm6 Split 1 Start

Integer

CP_P6S2E

Perm6 Split 2 End

nnn

Perm6 Split 2 End

Integer

CP_P6S2S

Perm6 Split 2 Start

nnn

Perm6 Split 2 Start

Integer

CP_P6S3E

Perm6 Split 3 End

nnn

Perm6 Split 3 End

Integer

CP_P6S3S

Perm6 Split 3 Start

nnn

Perm6 Split 3 Start

Integer

CP_P6S4E

Perm6 Split 4 End

nnn

Perm6 Split 4 End

Integer

CP_P6S4S

Perm6 Split 4 Start

nnn

Perm6 Split 4 Start

Integer

CP_P7S1E

Perm7 Split 1 End

nnn

Perm7 Split 1 End

Integer

CP_P7S1S

Perm7 Split 1 Start

nnn

Perm7 Split 1 Start

Integer

CP_P7S2E

Perm7 Split 2 End

nnn

Perm7 Split 2 End

Integer

CP_P7S2S

Perm7 Split 2 Start

nnn

Perm7 Split 2 Start

Integer

CP_P7S3E

Perm7 Split 3 End

nnn

Perm7 Split 3 End

Integer

CP_P7S3S

Perm7 Split 3 Start

nnn

Perm7 Split 3 Start

Integer

CP_P7S4E

Perm7 Split 4 End

nnn

Perm7 Split 4 End

Integer

CP_P7S4S

Perm7 Split 4 Start

nnn

Perm7 Split 4 Start

Integer

CP_P8S1E

Perm8 Split 1 End

nnn

Perm8 Split 1 End

Integer

CP_P8S1S

Perm8 Split 1 Start

nnn

Perm8 Split 1 Start

Integer

CP_P8S2E

Perm8 Split 2 End

nnn

Perm8 Split 2 End

Integer

CP_P8S2S

Perm8 Split 2 Start

nnn

Perm8 Split 2 Start

Integer

CP_P8S3E

Perm8 Split 3 End

nnn

Perm8 Split 3 End

Integer

CP_P8S3S

Perm8 Split 3 Start

nnn

Perm8 Split 3 Start

Integer

CP_P8S4E

Perm8 Split 4 End

nnn

Perm8 Split 4 End

Integer

CP_P8S4S

Perm8 Split 4 Start

nnn

Perm8 Split 4 Start

Integer

CP_ROWVER

 

 

Rowversion for optimistic locking

Date/Time