Signal Controller Service Plan
Field Name |
Caption |
Mask |
Description |
Field Type |
TP_CM_ID |
Controller Rec # |
nnnnnnnn |
Long Integer |
|
TP_CMP1_CD |
Call Mode P1 |
nnn |
Call Mode P1 |
Integer |
TP_CMP1_TY |
Call Mode P1 Text |
25x |
Call Mode P1 Text |
Text |
TP_CMP10CD |
Call Mode P10 |
nnn |
Call Mode P10 |
Integer |
TP_CMP10TY |
Call Mode P10 Text |
25x |
Call Mode P10 Text |
Text |
TP_CMP11CD |
Call Mode P11 |
nnn |
Call Mode P11 |
Integer |
TP_CMP11TY |
Call Mode P11 Text |
25x |
Call Mode P11 Text |
Text |
TP_CMP12CD |
Call Mode P12 |
nnn |
Call Mode P12 |
Integer |
TP_CMP12TY |
Call Mode P12 Text |
25x |
Call Mode P12 Text |
Text |
TP_CMP2_CD |
Call Mode P2 |
nnn |
Call Mode P2 |
Integer |
TP_CMP2_TY |
Call Mode P2 Text |
25x |
Call Mode P2 Text |
Text |
TP_CMP3_CD |
Call Mode P3 |
nnn |
Call Mode P3 |
Integer |
TP_CMP3_TY |
Call Mode P3 Text |
25x |
Call Mode P3 Text |
Text |
TP_CMP4_CD |
Call Mode P4 |
nnn |
Call Mode P4 |
Integer |
TP_CMP4_TY |
Call Mode P4 Text |
25x |
Call Mode P4 Text |
Text |
TP_CMP5_CD |
Call Mode P5 |
nnn |
Call Mode P5 |
Integer |
TP_CMP5_TY |
Call Mode P5 Text |
25x |
Call Mode P5 Text |
Text |
TP_CMP6_CD |
Call Mode P6 |
nnn |
Call Mode P6 |
Integer |
TP_CMP6_TY |
Call Mode P6 Text |
25x |
Call Mode P6 Text |
Text |
TP_CMP7_CD |
Call Mode P7 |
nnn |
Call Mode P7 |
Integer |
TP_CMP7_TY |
Call Mode P7 Text |
25x |
Call Mode P7 Text |
Text |
TP_CMP8_CD |
Call Mode P8 |
nnn |
Call Mode P8 |
Integer |
TP_CMP8_TY |
Call Mode P8 Text |
25x |
Call Mode P8 Text |
Text |
TP_CMP9_CD |
Call Mode P9 |
nnn |
Call Mode P9 |
Integer |
TP_CMP9_TY |
Call Mode P9 Text |
25x |
Call Mode P9 Text |
Text |
TP_CRT_BY |
Created By |
25x |
Created By |
Text |
TP_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
Date/Time |
TP_ID |
Rec # |
|
AutoID |
Long Integer |
TP_MG_P1 |
Min Green P1 |
nnn |
Min Green P1 |
Integer |
TP_MG_P10 |
Min Green P10 |
nnn |
Min Green P10 |
Integer |
TP_MG_P11 |
Min Green P11 |
nnn |
Min Green P11 |
Integer |
TP_MG_P12 |
Min Green P12 |
nnn |
Min Green P12 |
Integer |
TP_MG_P2 |
Min Green P2 |
nnn |
Min Green P2 |
Integer |
TP_MG_P3 |
Min Green P3 |
nnn |
Min Green P3 |
Integer |
TP_MG_P4 |
Min Green P4 |
nnn |
Min Green P4 |
Integer |
TP_MG_P5 |
Min Green P5 |
nnn |
Min Green P5 |
Integer |
TP_MG_P6 |
Min Green P6 |
nnn |
Min Green P6 |
Integer |
TP_MG_P7 |
Min Green P7 |
nnn |
Min Green P7 |
Integer |
TP_MG_P8 |
Min Green P8 |
nnn |
Min Green P8 |
Integer |
TP_MG_P9 |
Min Green P9 |
nnn |
Min Green P9 |
Integer |
TP_MOD_BY |
Last Modified By |
25x |
Last Modified By |
Text |
TP_MOD_DT |
Last Modified Date |
mm/dd/yyyy |
Last Modified Date |
Date/Time |
TP_MOD_TM |
Last Modified Time |
hh:mm am |
Modified Time |
Date/Time |
TP_P_P1 |
Passage P1 |
nnn |
Passage P1 |
Integer |
TP_P_P10 |
Passage P10 |
nnn |
Passage P10 |
Integer |
TP_P_P11 |
Passage P11 |
nnn |
Passage P11 |
Integer |
TP_P_P12 |
Passage P12 |
nnn |
Passage P12 |
Integer |
TP_P_P2 |
Passage P2 |
nnn |
Passage P2 |
Integer |
TP_P_P3 |
Passage P3 |
nnn |
Passage P3 |
Integer |
TP_P_P4 |
Passage P4 |
nnn |
Passage P4 |
Integer |
TP_P_P5 |
Passage P5 |
nnn |
Passage P5 |
Integer |
TP_P_P6 |
Passage P6 |
nnn |
Passage P6 |
Integer |
TP_P_P7 |
Passage P7 |
nnn |
Passage P7 |
Integer |
TP_P_P8 |
Passage P8 |
nnn |
Passage P8 |
Integer |
TP_P_P9 |
Passage P9 |
nnn |
Passage P9 |
Integer |
TP_PC_P1 |
Ped Clear P1 |
nnn |
Ped Clear P1 |
Integer |
TP_PC_P10 |
Ped Clear P10 |
nnn |
Ped Clear P10 |
Integer |
TP_PC_P11 |
Ped Clear P11 |
nnn |
Ped Clear P11 |
Integer |
TP_PC_P12 |
Ped Clear P12 |
nnn |
Ped Clear P12 |
Integer |
TP_PC_P2 |
Ped Clear P2 |
nnn |
Ped Clear P2 |
Integer |
TP_PC_P3 |
Ped Clear P3 |
nnn |
Ped Clear P3 |
Integer |
TP_PC_P4 |
Ped Clear P4 |
nnn |
Ped Clear P4 |
Integer |
TP_PC_P5 |
Ped Clear P5 |
nnn |
Ped Clear P5 |
Integer |
TP_PC_P6 |
Ped Clear P6 |
nnn |
Ped Clear P6 |
Integer |
TP_PC_P7 |
Ped Clear P7 |
nnn |
Ped Clear P7 |
Integer |
TP_PC_P8 |
Ped Clear P8 |
nnn |
Ped Clear P8 |
Integer |
TP_PC_P9 |
Ped Clear P9 |
nnn |
Ped Clear P9 |
Integer |
TP_ROWVER |
|
|
Rowversion for optimistic locking |
Date/Time |
TP_SPLAN |
Service Plan |
nn |
Service Plan |
Integer |
TP_W_P1 |
Walk P1 |
nnn |
Walk P1 |
Integer |
TP_W_P10 |
Walk P10 |
nnn |
Walk P10 |
Integer |
TP_W_P11 |
Walk P11 |
nnn |
Walk P11 |
Integer |
TP_W_P12 |
Walk P12 |
nnn |
Walk P12 |
Integer |
TP_W_P2 |
Walk P2 |
nnn |
Walk P2 |
Integer |
TP_W_P3 |
Walk P3 |
nnn |
Walk P3 |
Integer |
TP_W_P4 |
Walk P4 |
nnn |
Walk P4 |
Integer |
TP_W_P5 |
Walk P5 |
nnn |
Walk P5 |
Integer |
TP_W_P6 |
Walk P6 |
nnn |
Walk P6 |
Integer |
TP_W_P7 |
Walk P7 |
nnn |
Walk P7 |
Integer |
TP_W_P8 |
Walk P8 |
nnn |
Walk P8 |
Integer |
TP_W_P9 |
Walk P9 |
nnn |
Walk P9 |
Integer |