PDXpert PLM Software
On-line Help Guide
This help topic describes the current PDXpert PLM release. Earlier releases may be different. To view your release's version of this topic, open PDXpert and press the F1 key or select the Help menu.
ChangeView & ChangeMasterView reference
The ChangeView contains all change forms with standard item attributes. TheChangeMasterViewcontains all columns of the ChangeView plus all custom attributes. These views are available in both the viewer and the released schemas.
The Lifecycle column is coded
| Value | Lifecycle | Abbreviation |
|---|---|---|
| 0 | Originated | ORG |
| 1 | Submitted | SUB |
| 2 | Routed | RTD |
| 3 | Held | HLD |
| 4 | Approved | APP |
| 5 | Disapproved | DIS |
| 6 | Canceled | CAN |
| 7 | Stopped | STP |
| 8 | Rejected | REJ |
| 9 | Accepted | ACC |
| 10 | Released | REL |
| 11 | Completed | CMP |
For example:
SELECT
Type
,Number
,Priority
,CASE [Lifecycle]
WHEN 0 THEN 'Originated'
WHEN 1 THEN 'Submitted'
WHEN 2 THEN 'Routed'
WHEN 3 THEN 'Held'
WHEN 4 THEN 'Approved'
WHEN 5 THEN 'Disapproved'
WHEN 6 THEN 'Canceled'
WHEN 7 THEN 'Stopped'
WHEN 8 THEN 'Rejected'
WHEN 9 THEN 'Accepted'
WHEN 10 THEN 'Released'
WHEN 11 THEN 'Completed'
ELSE ''
END AS [Lifecycle]
FROM [viewer].[ChangeView]
There may exist in the view one or more "housekeeping" columns that have been reserved for PDXpert's private use. These columns' names begin with the prefix HK (for instance, HK1). Housekeeping columns may be redefined or eliminated in a future PDXpert release. These columns are not documented, and you should ignore them in your SQL queries. Do not create any custom attributes that use the HK prefix. You may want to create a user-defined view that excludes the housekeeping columns.
The column ordering may not be exactly as shown in this table, and may change in a future PDXpert release. Use the column name, not ordinal position, in your SQL queries.
| Column name | Data type | Attribute name |
|---|---|---|
| ItemId | GUID (item primary key) | unique record identifier; not visible within PDXpert client |
| Type | Change FormsName | Type |
| TypeShort | Change FormsAbbreviation | Type as displayed in the Item Explorer |
| Number | string | Number |
| Summary | string | Name as displayed in the Item Explorer |
| Lifecycle | integer 0 (ORG) to 11 (CMP) - see table | Lifecycle |
| WillReleaseCancelItems | Boolean | on Change Forms member asReleases/cancels items on Affected tab |
| Analyst | PersonsName | Analyst |
| Trustee | PersonsName | Trustee |
| OriginatedDate | date | Origination date |
| ReleasedDate (note 1) | date | Release date |
| ProblemSource | Problem SourcesName | Problem source |
| ChangeReason | Change ReasonsName | Change reason |
| ChangeClassification | Change ClassificationsName | Change classification |
| ChangePriority | Change PrioritiesName | Change priority |
| BeginSerialNo | string | [administrator defined] |
| BeginEffectiveDate | date | (none) |
| EndSerialNo | string | [administrator defined] |
| EndEffectiveDate | date | (none) |
| MaximumQuantity | integer | Maximum quantityvalue |
| MaximumQuantityUOM | Units of MeasureName | Maximum quantitycount units |
| MaximumDuration | integer | Maximum durationvalue |
| MaximumDurationUOM | Unit of MeasuresName | Maximum durationtime units |
| FirstAuxiliaryPerson | PersonsName | [administrator defined] |
| SecondAuxiliaryPerson | PersonsName | [administrator defined] |
| PrimaryDiscussion | string | [administrator defined], typically the change description |
| SecondaryDiscussion | string | [administrator defined], typically an optional supporting problem statement |
| Notes | string | Notes tab |
| custom (note 2) | string | custom attribute text or numeric value |
| custom_Member (note 2) | collection memberName | custom attribute value's units, or other collection member |
Notes:
- If the change has not yet been released, then this value is empty and affected items have not yet been updated to their planned release/cancel states.
- These columns are included in the ChangeMasterView, and are not in the ChangeView. All administrator-assigned custom attribute ("CA") names are displayed in value/unit columns; the name is used in the column header. All identically-named CAs are displayed in the same column, regardless of change type. Where a custom attribute name conflicts with an existing system-assigned attribute name (such as Number orType) then the custom attribute name is displayed with a leading underscore (_Number or_Type). See the help topicCollections reference >Custom attributesfor naming guidelines. If a custom attribute name is longer than 120 characters, it is truncated.
1177