COR Screen - Field Assignments

MAR Class Code: 321

 LogTypeID = 2 (COR LOG Record)

Screen Field Name                                Database Field Name (ProjMgmt Table)

General Information

COR Number                                LogNo

Visibility                                MiscInt2 (0=Normal/1=Internal)

Origination Date                        OriginationDate

Category                                Category

Category CO #                        MiscFloat2

Description                                LogDescription

Received From                        ReceivedFromNaNo

Contact                                ReceivedFromContactName

Building #                                BuildingNo

Floor #                                        FloorNo

Room #                                RoomNo

Work Area                                MiscFloat19 (PMAreas table lookup)

Proposed Change Order                ProposedSolution

Status Code                                StatusCode

Status Date                                StatusDate

Impact

WorkDay Extension                        MiscInt3

Proposed Cost                                ApprovedCO

 COR Breakdown Items

         Unit Price                                MiscFloat10

 COR Markup Amounts

         Markup Desc.                                MU_Desc1

         Markup %                                PMPercent1

         COR Subtotal1                        PMAmount1

         Markup Desc.                                MU_Desc2

         Markup %                                PMPercent2

         COR Subtotal2                        PMAmount2

         Markup Desc.                                MU_Desc3

         Markup %                                PMPercent3

         COR Subtotal3                        PMAmount3

 Cost Phase                                Phase

 COR Total                                PMAmount3

CO Markup Amounts

         Markup Desc.                                MU_Desc5

         Markup %                                PMPercent5

         CO Subtotal1                                PMAmount5

         Markup Desc.                                MU_Desc6

         Markup %                                PMPercent6

         CO Subtotal2                                PMAmount6

         Markup Desc.                                MU_Desc7

         Markup %                                PMPercent7

         CO Subtotal3                                PMAmount7

 Bill Phase                                        Bill_Phase

 CO Total                                        PMAmount7

 Total Profit & Overhead Markup                MiscFloat3

 Total Contract Price                                TotalContractCost

Submittal & Response

Submitted To                                SubmittedToNaNo

Contact                                MiscInt19

Submittal Date                        SubmissionDate

Answer Due Date                        ReplyDueDate

Act. Answer Date                        ActualReplyDate

Answer Dist. Date                        ReplyDistributionDate

Response Text                        ResponseDescription

Response From                        ResponseFromNaNo

Contact                                ResponseFromContact

User Defined Fields (all logs same)

Internal Fields:

COLogNo – This field is set to the PMID field of the associated CO Log Entry

sequenceno – This field is set to the Category COR number which is the sequential number of the COR for the associated Category.  For Example, this could be COR Number 33 on the Project, but only the 2nd COR Number for the Category.

StatusCode Settings: Set to indicate the current status of the COR Log Entry

A – RFI is out for Approval

B – RFI Reply has been received

C – RFI Reply has been distributed to others

W or Y – COR is available for attaching to a CO

X – COR was closed and Amended COR Created

Z – COR is NOT available for attaching to CO

Field Name (PMSubmittal Table)                Field Contents

Date                                                Date (when button pushed)

ConfirmedTime                                Time (when button pushed)

ContractorNaNo                                Category Contractor's NA_NO Field

Contact                                        Contact Name

SectionNo                                        Contact ID Number

MiscChar3                                        Status Code (See Status Code Settings)

Notes                                                Correspondence notes

NOTE: in addition to the above record being created in the PMSubmittal Table, The COR Log Entry is updated for the following fields:

Screen Field Name                        Database Field Name (ProjMgmt Table)

Status Code                                StatusCode (See Status Code Settings)

Status Date                                StatusDate (when button pushed)

Submittal Date                        SubmissionDate (when button pushed)

Change Order Links – A pair of fields can now be used to identify PM Log records that are related to the same Change Order Number.  These fields are available for RFI Records, COR Records, and CO Records.

oCONumber – This field contains the Change Order Number of the Change Order Record to which the other records in the log are linked. This makes it very easy to visually group related records together.

oCOPMID – This field contains the PMID of the Change Order Record to which the other records in the log are linked. The PMID is the primary record ID field for all records in the PM Log.

oCategory CO Number – This field contains the Change Order number for selected category.

Change Order Request Links – A pair of fields can now be used to identify PM Log records that are related to the same COR.  These fields are available for both RFIs and CORs.

oCORNumber – This field contains the COR number of the COR Record to which the other records in the log are linked. This makes it very easy to visually group related records together.

oCORPMID – This field contains the PMID of the COR Record to which the other records in the log are linked. The PMID is the primary record ID field for all records in the PM Log.