Appendix A: DCIS Screens
Anchor: #i1097191Overview
Appendix A includes the DCIS screens organized into subsections. Each subsection lists the field names found on the screens, their corresponding names in the Data Dictionary, database code and its metric field name, if relevant. Entries are according to the DCIS field names. The subsections are:
- Project Identification Screen (P1)
- Project Finance Screen (P2)
- Project Finance-Percent Screen (P2C)
- Project Evaluation Screen (P3)
- Project Evaluation-Bridge Screen (P3B)
- UTP Update Screen (P6)
- STIP Update Screen-District TIP (P7)
- STIP View Only Screen
- Cost Estimate History Screen (P8)
- Project Estimate Screen (P4)
- Contract Summary Screen (C1)
- Prebid Conference Screen.
Project Identification Screen (P1)
General – The field names on this screen are found in the Data Dictionary for file 121.
|
Field Name on Screen |
Corresponding Name in Data Dictionary |
Data Base Code |
Metric Field Name |
|---|---|---|---|
|
CTL-SEC-JOB |
Control-Sect-Job |
AB |
|
|
Hwy No |
Highway Number |
BC |
|
|
Dist |
District Number |
AC |
|
|
Cnty |
County Number |
BB |
|
|
Beg Mile Point |
Beg-Mile-Point |
BQ |
|
|
End Mile Point |
end-mile-point |
BR |
|
|
Project Length Km |
proj-length |
BD |
proj-length-metric-meas |
|
Beginning Reference Marker No: Suffix |
beg-ref-marker-nbr |
MS |
|
|
Beginning Reference Marker No: Displacement |
beg-ref-marker-disp |
MT |
|
|
Ending Reference Marker No: Suffix |
end-ref-marker-dnbr |
MV |
|
|
Ending Reference Marker No: Displacement |
end-ref-marker-disp |
MW |
|
|
Limits From |
limits-from |
BM |
|
|
Limits To |
limits-to |
BN |
|
|
Project Class |
proj-class |
BG |
|
|
Type Of Work |
type-of-work |
BL |
|
|
Spec Book Year |
spec-book-yr |
DM |
|
|
Layman’s Desc |
layman-description1 layman-description2 |
BO BP |
|
|
Oversight |
elig-fed-fund |
BF |
|
|
PE Manager Number |
manager-number |
BH |
|
|
LET SCH FY |
Let-sch-1 |
CT |
|
|
Let-sch-3 |
CV |
|
|
|
Resp. Section |
resp/sect |
PV |
|
|
Consultant |
consultant/flag |
PX |
|
|
Donated |
donated/flag |
PY |
|
|
Let Sch |
|
|
|
|
Fed Letter of Auth |
let-sch-2 |
|
|
|
utp-let-date |
|
|
|
|
State Letter of Auth |
State LOA |
RA |
|
|
Latest Est Of Cost - Const |
est-const-cost |
BI |
|
|
Latest Est Of Cost - ROW |
est-row-cost |
CJ |
|
|
UTP Authority |
Priority-code |
CD |
|
|
Date Of Latest Est Cost - Const |
date-est-cost |
BJ |
|
|
Date Of Latest Est Cost - ROW |
date-est-row |
CK |
|
|
Pres Dist Est Let Date |
dist-let-date |
CF |
|
|
Field Name on Screen |
Corresponding Name in Data Dictionary |
Data Base Code |
|---|---|---|
|
Authorized Amount |
There is no corresponding name in Data Dictionary nor Database Code for this field name. This field is a display-only field. |
|
|
Trunk Sys |
trunk-sys-flag |
MQ |
|
Approved Let Date |
apprvd-let-date |
CG |
|
Contract CSJ |
contract-csj |
CB |
|
Functional Class |
rdwy-funct-cls |
HB |
|
NHS |
nhs-flag |
PW |
|
Actual Let Date |
actual-let-date |
CH |
|
Other Participation |
other-part |
CM |
|
Hurr Evac RTE |
evac-rte |
HQ |
|
Project Number |
project-number |
CN |
|
Project Ancestors |
ancestor-csj5 |
EA |
|
Project Descendents |
descendent-csj5 |
FA |
|
Remarks |
Remarks |
CS |
|
PE DIST |
PE – DIST |
RH |
|
DFO |
From-Distanc-From-Origin |
RK |
|
DFO |
To-Distance-From-Origin |
RJ |
|
TRM Update Flag |
TRM-Update-Flag |
UA |
Project Finance Screen (P2)
The field names on the project finance screen (P2) include:
General – The field names on this screen are found in the Data Dictionary for file 121.
|
Field Name on Screen |
Corresponding Name in Data Dictionary |
Data Base Code |
|---|---|---|
|
Control-Sect-Job |
AB |
|
|
District Estimated Amount |
dist-eng-est |
DB |
|
Low Bid Amount |
tot-obg-amount |
DF |
|
Date Of Last Estimate |
date-est-cost |
BJ |
|
Local Contribution |
local-contributions-amt |
PU |
|
Tapered Match |
tapered-match |
QA |
|
Toll Credits |
toll-credits |
QB |
|
Other Participation |
other-part |
CM |
|
Work Program |
work-program |
GB |
|
PIP |
pid |
GS |
|
Authorized Amount |
proj-cost |
GC |
|
Appl Pct |
applied-percent |
GM |
|
APPN Code |
apportionment-code |
GL |
|
Category |
category-p2 |
GO |
|
Fixed Flag |
fixed-flag |
GN |
|
ROW Cost |
row-amount |
GF |
|
Funct FM To |
func-code-from func-code-to |
GH GI |
|
Date |
minute-order-date |
GK |
|
Min Ord Number |
minute-order-number |
GJ |
|
Total Program Cost |
There is no corresponding name in Data Dictionary nor Database Code for this field name. This field is a calculated field. |
|
|
Preservation Percent |
preservation-percent |
UB |
|
Mobility Percent |
mobility-percent |
UC |
Anchor: #i1017507
Project Finance Percent Screen (P2C)
The project finance-percent screen (P2C) contains the following fields:
General – The field names on this screen are found in the Data Dictionary for file 121.
|
Field Name on Screen |
Corresponding Name in Data Dictionary |
Data Base Code |
|---|---|---|
|
Control-Sect-Job |
AB |
|
|
Local-Contributions-Amt |
PU |
|
|
Apportionment-Code |
GL |
|
|
Estimated Const Cost |
est-const-cost |
BI |
|
Applied % |
applied-percent |
GM |
|
Auth Amt |
proj-cost |
GC |
|
Federal % |
federal-cost-pct |
GP |
|
Federal Cost |
There is no corresponding name in Data Dictionary nor Database Code for this field name. This field is a calculated field. This is calculated from the percent (federal %). |
|
|
State % |
state-cost-pct |
GQ |
|
State Cost |
There is no corresponding name in Data Dictionary nor Database Code for this field name. This field is a calculated field. This is calculated from the percent (state %). |
|
|
Local % |
local-cost-pct |
GR |
|
Local Cost |
There is no corresponding name in Data Dictionary nor Database Code for this field name. This field is a calculated field. This is calculated from the percent (local %). |
|
|
Totals Federal/State/Local |
There is no corresponding name in Data Dictionary nor Database Code for these field names. The TOTALS for FEDERAL, STATE, and LOCAL are calculated fields. |
|
|
Max Federal Funds |
This field is for Transportation Enhancement Program Projects only. Dollar amount for federal funds are authorized by the Commission. These funds cannot be increased without Commission action. The authorized amount will reflect the total amount for construction, federal dollars and local match. |
|
Anchor: #i1017521
Project Evaluation Screen (P3)
The project evaluation screen (P3) contains these fields:
General – The field names on this screen are found in the Data Dictionary for file 121.
|
Field Name on Screen |
Corresponding Name in Data Dictionary |
Data Base Code |
Metric Field Name |
|---|---|---|---|
|
Control-Sect-Job |
AB |
|
|
|
District |
Dictrict-number |
AC |
|
|
Project Classification |
proj-class |
BG |
|
|
Urban Rural Operation |
urban-rural |
HD |
|
|
Proposed DES Speed MPH |
prop-dsgn-spd |
IC |
prop-desgn-spd-metric-meas |
|
Terrain |
Terrain |
IO |
|
|
PSE % Complete |
Pse-comp |
CP |
|
|
ROW % Complete |
Row-comp |
CQ |
|
|
Env % Complete |
Pes2-lanes |
IJ |
|
|
Ext Fac: Main Lanes |
exst-mnln-num |
HG |
|
|
Ext Fac: Main Lanes Type |
exst-mnln-type |
HH |
|
|
ExtFac: Frontage Lane |
exst-ftg-num |
HI |
|
|
Ext Fac: Frontage Lane Type |
exst-ftg-type |
HJ |
|
|
Ext Fac: Length Mi |
exst-length |
HK |
exist-length-metric-meas |
|
Pro Fac: Main Lane |
prop-mnln-num |
HL |
|
|
Pro Fac: Main Lane Type |
prop-mnln-type |
HM |
|
|
Pro Fac: Frontage Lane |
prop-ftg-num |
HN |
|
|
Pro Fac: Frontage Lane Type |
prop-ftg-type |
HO |
|
|
Pro Fac: Length Mi |
prop-length |
HP |
prop-length-metric-meas |
|
Lane Miles |
lane-miles |
HS |
lane-length-metric-meas |
|
Shoulder Miles |
shldr-miles |
HT |
shldr-length-metric-meas |
|
Adt: Present |
pres-adt |
HW |
|
|
Projected Year |
proj-adt-year |
HX |
|
|
Projected Adt |
proj-adt |
HY |
|
|
Percent Trucks |
Percent-trucks |
HZ |
|
|
Dist Priority |
Dist-priority |
IQ |
|
|
Field Name on Screen |
Corresponding Name in Data Dictionary |
Data Base Code |
Metric Field Name |
|
Population |
Population-area |
RB |
|
|
<5,000 |
|
|
|
|
>=5,000 and <200,000 |
|
|
|
|
>=200,000 |
|
|
|
|
Roadway Functional Class |
Rdwy-funct-cls |
HB |
|
|
Design Standard |
Design-standard |
RC |
|
|
P.E. INFO FED LOA Date |
Pe-federal-loa |
RD |
|
|
APPN Code |
Pe-appn-code |
RE |
|
|
FED $ |
Pe-federal-dollars |
RF |
|
|
Consultant |
Consultant-flag |
PX |
|
|
Donated |
Donated-flag |
PY |
|
|
|
pes1-score |
II |
|
|
|
pes2-score |
IK |
|
|
Comments - Division |
Comments1 |
JA |
|
|
|
Comments3 |
JC |
|
|
Comments - District |
Comments4 |
JF |
|
|
|
Comments5 |
JG |
|
|
PRO FAC: LENGTH MILE |
PROP - LENGTH |
HP |
|
Anchor: #i1017535
Project Evaluation Screen (P3B)
The project evaluation-bridge screen (P3B) contains these fields:
General – The field names on this screen are found in the Data Dictionary for file 121.
|
Field Names Found in Data Dictionary for File 121 |
||
|---|---|---|
|
Field Name on Screen |
Corresponding Name in Data Dictionary |
Data Base Code |
|
Control-Sect-Job |
AB |
|
|
District-Number |
AC |
|
|
Off System Route Number |
off-state-id |
NG |
|
Bridge Sufficiency Rating |
bridge-sufficiency-rating |
NK |
|
Bridge Deficiency Class |
bridge-deficiency-class |
NJ |
|
Program Qual. Code |
program-qualification-code |
NI |
|
Tebss Score Pct |
tebss-score-pct |
NH |
|
NBI Number |
|
|
|
Historic Significance |
Hist Sig |
|
|
Structure Type |
Str Type |
|
|
Critical Deficiency Indicator |
Critical Def Ind |
|
Anchor: #i1017549
UTP Update Screen (P6)
The UTP update screen (P6) contains these fields:
General – The field names on this screen are found in the Data Dictionary for file 121.
|
Field Name on Screen |
Corresponding Name in Data Dictionary |
Data Base Code |
|---|---|---|
|
Control-Sect-Job |
AB |
|
|
HIGHWAY-NUMBER |
BC |
|
|
Corridor Number |
|
|
|
Ad Hoc Report Codes |
adhoc-report-id |
MU |
Anchor: #i1017563
STIP Update Screen-District TIP (P7)
The STIP update screen-district TIP (P7) contains these fields:
General – The field names on this screen are found in the Data Dictionary for file 121.
|
Field Name on Screen |
Corresponding Name in Data Dictionary |
Data Base Code |
|---|---|---|
|
Control-Sect-Job |
AB |
|
|
Highway-Number |
BC |
|
|
District-Number |
AC |
|
|
Limits-From |
BM |
|
|
Limits-To |
BN |
|
|
County-Number |
BB |
|
|
Layman-Description1 |
BO |
|
|
|
Layman-Description2 |
BP |
|
Project Id |
stip-project-id |
AH |
|
Implementing Agency |
stip-implementing-agency-cmnt |
AK |
|
Phase |
stip-phase-code |
AI |
|
MPO Code |
mpo-code |
JD |
|
City Code |
city-code |
IP |
|
TIP Year |
tip-fy |
JE |
|
STIP Revision Date |
stip-revision-date |
AJ |
|
STIP Remarks |
comments2 |
JB |
Anchor: #i1017577
STIP View Only Screen
The STIP View Only Screen contains these fields:
General – The field names on this screen are found in the Data Dictionary for file 122. Any field name from the different file will have the corresponding file number in parenthesis.
|
Field Name on Screen |
Corresponding Name in Data Dictionary |
Data Base Code |
Metric Field Name |
|---|---|---|---|
|
Control-Sect-Job |
AF |
|
|
|
Highway No (on File 121) |
Highway-Number (from file 121) |
BC |
|
|
Cnty (on File 121) |
County-Number (from file 121) |
BB |
|
|
Act Let (on File 121) |
Actual-Let-Date (from file 121) |
CH |
|
|
District |
district-number |
AG |
|
|
Location From |
stip-location-from-desc |
DR |
|
|
Location To |
stip-location-to-desc |
DS |
|
|
Laymans Desc |
stip-laymans-desc |
DT |
|
|
Project Id |
stip-project-id |
DD |
|
|
Fed Proj No |
stip-project-nbr |
DE |
|
|
Functional Class |
stip-functional-class-code |
DL |
|
|
State Category |
stip-state-category-code |
DM |
|
|
Exist # Of Lanes |
stip-existing-lane-amt |
DO |
|
|
Phase |
stip-phase-code |
DF |
|
|
Prop # Of Lanes |
stip-proposed-lane-amt |
DP |
|
|
MPO Code |
stip-mpo-code |
DB |
|
|
Project Length |
stip-project-length-meas |
DQ |
stip-proj-length-metric |
|
TIP Year |
STIP-FY |
DC |
|
|
Implementing Agency |
STIP-implementing-agency-cmnt |
DX |
|
|
STIP Revision Date |
STIP-revision-date |
DV |
|
|
FHWA Approval Date |
STIP-FHWA-approval-date |
FG |
|
|
District Est Let Date |
STIP-district-est-let-date |
DN |
|
|
Est Const Cost |
STIP-est-construction-amt |
DK |
|
|
Appn Code |
STIP-apportionment-code |
FB |
|
|
Appn Cost |
STIP-program-cost |
FA |
|
|
Local Contribution |
STIP-local contribution-amt |
DI |
|
|
Total State |
STIP-state-cost-total |
FD |
|
|
Total Local |
STIP-local-cost-total |
FE |
|
|
Total Federal |
STIP-federal-cost-total |
FC |
|
|
STIP Remarks |
STIP-project-cmnt |
DU |
|
Anchor: #i1017591
Cost Estimate History Screen (P8)
The Cost Estimate History Screen (P8) contains these fields:
General – The field names on this screen are found in the Data Dictionary for file 121.
|
Field Name on Screen |
Corresponding Name in Data Dictionary |
Data Base Code |
|---|---|---|
|
CTL-SEC-JOB |
Control-Sect-Job |
AB |
|
Highway Number |
Highway-Number |
BC |
|
District |
District Number |
AC |
|
CNTY |
County Number |
BB |
|
UTP Year |
Annual-Utp-Year |
RM |
|
Estimated Construction Cost Amount |
Annual-Const-Est |
RN |
|
Estimated Row Cost Amount |
Annual-Row-Est |
RO |
|
Run Date |
Annual-Cost-Date-Run |
RP |
Anchor: #i1017605
Project Estimate Screen (P4)
The project estimate screen (P4) contains these screens:
General – Most of the field names on this screen are found in the Data Dictionary for file 123. Any field name from the different file will have the corresponding file number in parenthesis.
|
Field Name on Screen |
Corresponding Name in Data Dictionary |
Data Base Code |
|---|---|---|
|
Control-Sect-Job |
AB |
|
|
Line |
None |
None |
|
EST CODE (on File 124) |
EST-CODE (on file 124) |
|
|
% E & C (on File 121) |
EC-percent |
DG |
|
Chg Ind |
None |
None |
|
Line No |
line-number |
BB |
|
Card Type |
card-type |
BC |
|
Item No |
biditem-no |
BF |
|
Desc Code |
biditem-desc-code |
BG |
|
Sp No |
special-prov-no |
BH |
|
Spl Act |
special-acct-no |
BI |
|
Alt Gp |
alternate-group-no |
BD |
|
Alt |
(Part of alternate-group-no) |
(Part of alternate-group-no) |
|
Quantity |
eng-quantity |
BJ |
|
Unit Price (Before Letting) |
eng-estimate-price |
BK |
|
Unit Price (After Letting) |
unit-price |
BL |
|
Bid Item |
biditem-flag |
BM |
|
Category Of Work |
catgwork-desc |
BQ |
|
Unique Desc |
biditem-description |
BN |
|
Comment |
Comment |
BP |
|
Unit |
unit-work |
BO |
|
(No field name on screen) |
catgwork-miles or catgwork-km |
BR |
Anchor: #i1017619
Contract Summary Screen (C1)
The contract summary screen (C1) contains the following fields:
General – The field names on this screen are found in the Data Dictionary for file 124.
|
Field Name on Screen |
Corresponding Name in Data Dictionary |
Data Base Code |
|---|---|---|
|
Contract CSJ |
contract-csj |
AB |
|
Contract Seq No |
There is no corresponding name in Data Dictionary nor Database Code for this field name. This field is a display-only field. |
|
|
No Work Days |
working-days |
BC |
|
No Work Days And Flag |
work-cal-flag |
HR |
|
Prop Guarantee |
proposal-guaranty-amt |
BU |
|
Bids Recd Until |
received-until-date |
BH |
|
Prebid Conference |
pre-bidders-meeting-date |
NB |
|
Contract Locked |
contract-lock-data |
TA |
|
Est Code |
est-code |
FB |
|
Let Code |
letting-status-code |
BD |
|
Div Resp |
division-responsible |
BW |
|
Waiver Flag |
waiver-flag |
BV |
|
Dist-Resp (only LMO can revise this field on locked contracts) |
resp-dist |
FC |
|
DBE Goals Flag |
mbe-wbe-flag |
BQ |
|
Local Let |
local-let |
FD |
|
CST Manager Number |
eng-no |
BK |
|
Name |
eng-name |
BL |
|
Addr |
eng-address |
BM |
|
City |
eng-city |
BN |
|
Zip |
eng-zipcode |
BO |
|
Tel |
eng-phone |
BP |
|
User Cost Amt |
user-cost-amt |
HB |
|
Contract Type Of Work |
type-of-work |
GA |
|
Contract Limits |
Limits |
GB |
|
Included Projects |
included-projects191 |
BY |
|
(combined flag) |
combined-flag191 |
IA |
|
Total Cont Cost |
Total-Contract-Cost |
WC |
Anchor: #i1017633
Prebid Conference Screen
The prebid conference screen contains these fields:
General – The field names on this screen are found in the Data Dictionary for file 124
|
Field Name on Screen |
Corresponding Name in Data Dictionary |
Data Base Code |
|---|---|---|
|
Mandatory Attendance |
pre-bidders-mandatory-flag |
NC |
|
Special Notice Text Requested |
pre-bidders-special-text-flag |
NG |
|
Meeting # 1/ Meeting #2 Date |
pre-bidders-meeting-date |
NB |
|
Meeting # 1/ Meeting #2 Time |
pre-bidders-meeting-time |
NC |
|
Meeting # 1/ Meeting #2 Location |
pre-bidders-meeting-locn |
NF |