MDR planning create mappings - HxGN SDx - Update 64

MDR planning create mappings - HxGN SDx - Update 64 - Administration & Configuration

Administration and Configuration of HxGN SDx

Language

English

Product

HxGN SDx

Search by Category

Administration & Configuration

SmartPlant Foundation / SDx Version

The planning submittal must have the document names, title, planned issue purpose, and date. For each submittal, a new revision of the MDR document must be supplied in the first row with a new revision and issue date. For more information on what can be done with a submittal, see Planning submittal.

The below table gives you a better understanding of the mappings delivered in the system.

Name	VTLImportDefHeaderOrder	Column header text	Column type	Constant value	Maps to	Notes
Document Number	1	Document Number	Physical			UID=FDWM, ConfigLevel, Document Number
PlannedDocRevision	2		Computed		FDWDocumentRevision/Name	Used to drive the creation of a RESERVED revision. UID=FDWM, COMP_CurrentConfigLevel, Document Number, MAJORREVISION
DocRevision	3		Computed		FDWDocumentRevision/Name	Used for the MDR and existing revision updates. UID=FDWM, COMP_CurrentConfigLevel, Document Number, MAJORREVISION, MINORREVISION
Revision	4	Revision	Physical			Not mapped to the revision property.
COMP_ExtRevision	5		Computed		SPFExternalRevision	Replaces a blank with a -- (planned revision).
COMP_ExtRevisionDoc	6		Computed		SPFExternalRevision	Replaces a blank with a -- (document revision).
Issue Date	7	Issue Date	Physical			A collaboration rule checks that this is populated.
COMP_CURRENTTIME	8		Computed			Gets the current time.
COMP_IssueDateAppendTime	9		Computed			Appends the current time to the issue date.
COMP_CurrentConfigLevelName	10		Computed			Gets the current configuration level.
COMP_CurrentConfigLevel	11		Computed			Gets the current configuration level and replaces any space with an underscore character.
REVISION_SCHEME	12		Computed		SPFRevisionScheme	Uses the fixed revision scheme. UID=RS, REVISION_SCHEME
MAJORREVISION	13		Computed		SPFMajorRevision	Gets the planned major revision from the Revision column.
COMP_MajorRevisionDoc	14		Computed		SPFMajorRevision	Gets the document major revision from the Revision column.
MINORREVISION	15		Computed		SPFMinorRevision	Gets the document minor revision from the Revision column when the parent object is PlannedDocRevision.
COMP_MinorRevisionDoc	16		Computed		SPFMinorRevision	Gets the document minor revision from the Revision column when the parent object is DocRevision.
COMP_DocRevisionUID	17		Computed			Builds UID for the revision.
COMP_ExistingRevisionIssueDate	18		Computed			Gets SPFRevIssueDate from the revision UID above in the system if it already exists.
IssueDate_Conv_Computed	19		Computed		SPFRevIssueDate	Uses existing issue date if already exists; otherwise, uses COMP_IssueDateAppendTime value.
Issue_Date_RevisionDoc	20		Computed		SPFRevIssueDate	Uses existing issue date if already exists; otherwise, uses COMP_IssueDateAppendTime value.
Document Title	21	Document Title	Physical			A collaboration rule checks that this is populated.
Classification	22	Classification	Physical			Must be populated with the short code of the CFIHOS classification, otherwise use the name.
WBSCode	23	WBSCode	Physical			The SDAWorkPackage object must exist.
FEEDCode	24	FEEDCode	Physical			The SDAWorkPackage object must exist.
Discipline	25	Discipline	Physical			The SDADiscipline object must exist and be available in the project - see processing below to validate this.
Area	26	Area	Physical			The SDAArea object must exist. UID= FBA, ConfigLevel, Area
Unit	27	Unit	Physical			The SDAUnit object must exist. UID=FBU, ConfigLevel, COMP_PlantCodeValue, Unit
SubmissionsShareDIrectory	28		Computed			Gets the upload file location from the server manager - for internal use.
SDASubFolder_GUID	29		Computed			gets the subfolder GUID - for internal use
File Name	30	File Name	Physical			creates the SPFDesignFile object if the file is found in the file folder
File	31		Computed			Computes the local filename for the file.
COMP_Config1	32		Computed			Gets the configuration string.
ConfigLevel	33		Computed			Replaces any space with an underscore character in the configuration string.
OWNING_GROUP	34		Constant	ENGINEER		The SPFDataAccessGroup ENGINEER object must exist.
SECURITYCODE	35		Constant	Unclassified		The SDASecurityCode Unclassified object must exist.
Submittal	36		Computed		SCLBSubmittal	Builds relationships to the submittal object. UID=Subm, ConfigLevel, Submittal
ContractNo	37		Computed		SPFContract	The SPFContract is read off the submittal object and a collaboration rule checks an existing document is not related to a different contract. UID=CNTRT, ContractNo
FromOrg	38		Computed		SDAOrganization	The SDAOrganization is read off the submittal object. UID=CO, FromOrg
PlannedIP	39	Planned IP	Physical		SDAPrgDeliverableMilestoneIssuePurpose relationship	Relates the milestone object to the issue purpose.
PlannedDate	40	Planned Date	Physical			Gets the planned date from the csv.
COMP_PlannedIP_Milestone	41		Computed		SDAPrgDeliverableMilestone object and SDAPrgDeliverableMilestoneIssuePurpose relationship	Creates a deliverable milestone object.
PlannedIPDate	42		Computed		SDAPrgDeliverablePlannedDate property on SDAPrgDeliverableMilestone object	Sets the planned date on milestone object.
IssuePurpose_Pattern	43		Computed			Creates a regex expression from the csv input issue purpose.
Resolve_IssuePurposes	44		Computed			Gets the names of all the project issue purposes from the environment variable.
Validate_IssuePurposes	45		Computed		SPFFTRFailureMsg	If the Issue purpose entered in the csv is available in the project it sets SDVIssuePurpose = True. (compares the regex expression with Resolve_IssuePurposes). This property is tested by the Validate IssuePurposes For Config collaboration rule.
COMP_Validate_Docrev_IssuePurposes	46		Computed		SPFFTRFailureMsg	Error code processed by a collaboration rule that checks if the issue purposes specified in the csv file are valid for the current configuration.
SubmittalMDRDoc	47		Computed			Gets the classification of the document from the system, for the document specified as MDR in the csv. This column is used in IsMDRValid computed column.
SubmittalMDRDocName	48		Computed			Gets the name of the document related to the contract from the system, for the document specified as MDR in the csv. This column is used in IsMDRValid computed column.
IsMDRValid	49		Computed		SPFDocReasonForCancel	Error code processed by a collaboration rule that prevents the creation of two MDR documents for the same contract.
IsDocHasContract	50		Computed		SPFDocCancelledBy	Error code processed by a collaboration rule that checks if the document in the csv has a contract other than that specified in the submittal.
COMP_ALLDISCIPLINESFORCREATECONFIG	51		Computed			Gets the UIDs of all the project disciplines from the environment variable.
Comp_Config_Discipline	52		Computed			Gets the UIDs of all the project disciplines from the environment variable and removes the DC_ prefix.
Comp_Discipline_Regex_Pattern	53		Computed			Creates a regex expression from the csv input discipline.
Comp_Discipline_Valid	54		Computed		SPFSharePointRefinerPath	If the discipline entered in the csv is avaialable in the project it sets SDAConfigDiscipline = True. (compares the regex expression with Comp_Config_Discipline). This property is tested by the ValidateDiscipline collaboration rule.
COMP_PlantCode	55		Computed			Builds plant code from config level and Area.
COMP_PlantCodeValue	56		Computed			Gets plant code object from system - used in the UID of the Unit.
COMP_MasterDocTitle	57		Computed		Description	Sets the description property on the master document.
COMP_DocRevDocTitle	58		Computed		Description	Sets the description property on the revision.
COMP_IsMDRPlanRevisionValid	59		Computed		SPFActiveWorkflowStatus	Error code processed by a collaboration rule that checks if the MDR has an actual revision. Only an MDR with actual revision will be considered for loading.
COMP_IsMDRDocRevisionValid	60		Computed		SPFActiveWorkflowStatus	Error code processed by a collaboration rule that checks if the MDR has an actual revision. Only an MDR with actual revision will be considered for loading.
Resolve_Classifications	61		Computed			Gets the names of the document or tag classifications related to the current create configuration.
Comp_Classification	62		Computed			Replaces the empty spaces in names with an underscore (_) and appends a hyphen (-) at the beginning and the end of the string.
Classification_Pattern	63		Computed			Creates a regular expression pattern for the classification column.
Classification_AppendWildcards	64		Computed			Constructs a classification pattern for the resolve classification column. For example, if the Resolve_classifications returns AB,A C,and AD, then it constructs a pattern, such as -AB-,-A_C-, and -AD-.
Validate_Classification	65		Computed		HEXSDxSource	Sets the SDXSource property to true if the classification entered in csv is available in the current create configuration. Otherwise, sets the property to null. This property is validated using the "HEX Check property HEXFDWDocumentMaster-masterref-HEXSDxSource Is Not blank" rule.
COMP_MDRPlan_VersionNumber	66		Computed		HEXSPFDocVersion	Returns the latest version number of the document revision, using the computed API function: NumberForRevision("#FDWDocumentRevision,.Name=[Document Number],.SPFExternalRevision=[Comp_ExtRevision]", "true")
COMP_MDRDoc_VersionNumber	67		Computed		HEXSPFDocVersion	Returns the latest version number of the document revision, using the computed API function: func.GetVersionNumberForRevision("#FDWDocumentRevision,.Name=[Document Number],.SPFExternalRevision=[Comp_ExtRevisionDoc]", "true")