Custom Report Design - Data Pipe Info

•The Job Cost Capsheet and Committed Cost report data pipes have been updated for new cost phase formatting when using the CSI Cost Code 6+2 Digit Format for job cost phases.  New fields representing variations of the cost phase are now available in order to enhance grouping and subtotaling.  The following fields have been added to the data pipes on these reports based on the CSI Format (“12 34 56.78”):

oMasterDivision – The first 2 digits of the phase code (12).

oMasterLevel1 – The 3rd and 4th digits of the phase code (34).

oMasterLevel2 – The 5th and 6th digits of the phase code (56).

oMasterLevel3 – The decimal place digits of the phase code (78).

oPhaseDivision – The first 2 digits of the phase code with trailing zeros (120000).

oPhaseLevel1 – The first 4 digits of the phase code with trailing zeros (123400).

oPhase Group – The first 6 digits of the phase code (123456).

oMasterPhaseFormatted – This is a string field formatted with spaces between each level in case this layout is needed in a report or form (“12 34 56.78”).

•The two phase master lists produced for MAR Reports: “PhaseMasterList” and “JobCostPhaseList” include the following additional phase fields:

oDivisionDescription – phase description for the PhaseDivision phase code (120000) if it exists in the Phase List.

oLevel1Description - phase description for the PhaseLevel1 phase code (123400) if it exists in the Phase List.

oPhaseParts – all digits of the phase code with leading zeros and two additional trailing zeros: (123456.7800)

oPhaseDigit1 – 1st digit of the phase code (1).

oPhaseDigit2 – 2nd digit of the phase code (2).

oPhaseDigit3 – 3rd digit of the phase code (3).

oPhaseDigit4 – 4th digit of the phase code (4).

oPhaseDigit5 – 5th digit of the phase code (5).

oPhaseDigit6 – 6th digit of the phase code (6).

oPhaseDigit7 – 7th digit of the phase code (7).

oPhaseDigit8 – 8th digit of the phase code (8).

•For the Committed Cost Report Totals, three datapipe tables are available for roll up totals based on the new phase code fields:

oCOMMITTEDCOSTTOTALSBYJOBPHASEDIVISION.ADT – Totals by PhaseDivision

oCOMMITTEDCOSTTOTALSBYJOBPHASELEVEL1.ADT – Totals by PhaseLeve1

oCOMMITTEDCOSTTOTALSBYJOBPHASEGROUP.ADT – Totals by Phase Group