Submittal Screen - Field Assignments

 Top  Previous  Next

MAR Class Code: 361

 

 LogTypeID = 6 (Submittals LOG Record)

 

•Submittal Tab

 

Screen Field Name                                Database Field Name (ProjMgmt)

 

General Information

Submittal Number                        LogNo

Origination Date                        OriginationDate

Category                                Category

Spec No                                SpecSectionNo

Spec Desc

Title or Section of Work                WorkArea    (*)

Work Area                        

Description                                LogDescription (**)

Submittal Request Date                SubmissionDate

Reply Due Date                        ReplyDueDate

Date Received                                ActualReplyDate

Notes                                        ProposedSolution

Status                                        StatusCode

Status Date                                StatusDate

Approval

Submitted To                                SubmittedToNaNo

Contact                                MiscInt19

Approved Req. Date                        ReplyDistributionDate

Approved                                OwnerApproval

Approved Date                        MiscDate3

Approved By                                ReceivedFromCotactName

User Defined Fields (all logs same)

 

 

* This is a Memo field; bring this into the report as a DbMemo field so that it can be formatted within the report design.

** This is a RichText field and can only be formatted within the log screen itself.

 

 

Internal Fields:

 

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

 

•Open Submittal: Codes A through E

A – Submittal is out for Approval

B – Submittal Reply has been received

C – Submittal Reply has been distributed to others

•Closed Submittal: Codes W through Z

W – Submittal Approved as Noted

Y – Submittal Approved

Z – Submittal Denied (Resubmitted) – causes amended submittal to be created

COLogNo = Set to the CloseOutID Field of the PMCODetail Table when the Submittal is Linked to a Closeout Item

 

•Correspondence Tab – Optional Tab used to create transaction records and update Submittal Status Fields.  Note: Submittal status fields can also be updated manually on the Submittal Tab but no transaction records are created.  The transaction records are written to to the PMSubmittal Table using the following fields:

 

Field Name (PMSubmittal Table)                Field Contents

 

MiscChar3                                        Status Code (See Status Code Settings)

Date                                                Date (when button pushed)

ConfirmedTime                                Time (when button pushed)

ContractorNaNo                                Category Contractor's NA_NO Field

Contact                                        Contact Name

Notes                                                Correspondence notes

 

NOTE: in addition to the above record being created in the PMSubmittal Table, The Submittal 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 Request Date                SubmissionDate (when button pushed)

Date Received                                ActualReplyDate

Reply Due Date                        ReplyDueDate

Approved Req. Date                        ReplyDistributionDate