RFI Screen - Field Assignments |
Top Previous Next |
MAR Class Code: 300
LogTypeID = 1 (RFI LOG Record)
Screen Field Name Database Field Name (ProjMgmt Table)
General Information RFI Number LogNo Origination Date OriginationDate Category Category Description LogDescription Subject Comments Initiated By ReceivedFromNaNo Contact ReceivedFromContactName Building # BuildingNo Floor # FloorNo Room # RoomNo Work Area MiscFloat19 (PMAreas table lookup) Architect's RFI ArchitectNo Contractor's RFI ContractorNo Proposed Solution ProposedSolution Status StatusCode Status Date StatusDate Reference Spec # SpecSectionNo Title or Section of Work WorkArea Detail # DetailNo Drawing # DrawingNo Impact Impact Time TimeImpact Impact Cost CostImpact Submittal & Response Submitted To SubmittedToNaNo Contact MiscInt19 Submittal Date SubmissionDate Response Due Date ReplyDueDate Actual Resp. Date ActualReplyDate Reply Dist. Date ReplyDistributionDate Response Text ResponseDescription Response From ResponseFromNaNo Contact ResponseFromContact User Defined Fields Text1 MiscChar1 Text2 MiscChar10 Text3 MiscChar11 Text4 MiscChar12 Text5 MiscChar13 Text6 MiscChar14 Text7 MiscChar15 Text8 MiscChar16 Text9 MiscChar17 Text10 MiscChar18 Integer1 MiscInt1 Integer2 MiscInt10 Integer3 MiscInt11 Integer4 MiscInt12 Integer5 MiscInt13 Integer6 MiscInt14 Integer7 MiscInt15 Integer8 MiscInt16 Integer9 MiscInt17 Integer10 MiscInt18 Number1 MiscFloat1 Number2 MiscFloat10 Number3 MiscFloat11 Number4 MiscFloat12 Number5 MiscFloat13 Number6 MiscFloat14 Number7 MiscFloat15 Number8 MiscFloat16 Number9 MiscFloat17 Number10 MiscFloat18 Date1 MiscDate1 Date2 MiscDate10 Date3 MiscDate11 Date4 MiscDate12 Date5 MiscDate13 Date6 MiscDate14 Date7 MiscDate15 Date8 MiscDate16 Date9 MiscDate17 Date10 MiscDate18 Logical1 MiscBool1 Logical2 MiscBool10 Logical3 MiscBool11 Logical4 MiscBool12 Logical5 MiscBool13 Logical6 MiscBool14 Logical7 MiscBool15 Logical8 MiscBool16 Logical9 MiscBool17 Logical10 MiscBool18
Internal Fields:
CORLogNo – This field is set to the PMID field of the associated COR Log Entry when the RFI is linked or "related to" a COR. If blank or null when not linked to a COR.
StatusCode Settings: Set to indicate the current status of the RFI Log Entry
A – RFI is out for Answer B – RFI Reply has been received C – RFI Reply has been distributed to others
W or Y – RFI is available for attaching to COR or CO X – RFI was closed and Amended RFI Created Z – RFI is NOT available for attaching to COR or 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)
|