PM
PMChangeRequestAudit
Represents an audit record that tracks the relationship between a change request and its associated change orders. The records of this type are created to maintain an audit trail of change request processing and change order generation.
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
ChangeOrderNbr | nvarchar(15) | Change Order Nbr. | - | |
Description:The reference number of the change order that was created from or associated with the change request. This field establishes the link between the change request and the resulting change order, providing an audit trail for change request processing and change order generation. | ||||
ChangeRequestNbr | nvarchar(15) | Reference Nbr. | - | |
Description:The reference number of the change request being audited. The value of this field corresponds to the value of the PMChangeRequest.RefNbr field. | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | char(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | Created Date Time | - | |
Description:No description available | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | Users | |
Description:No description available | ||||
LastModifiedByScreenID | char(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime | datetime | Last Modified Date Time | - | |
Description:No description available | ||||
OldChangeOrderNbr | nvarchar(15) | Old Change Order Nbr. | - | |
Description:The reference number of the change order that was created from or associated with the change request. This field establishes the link between the change request and the resulting change order, providing an audit trail for change request processing and change order generation. | ||||
RecordID | int | Record ID | - | |
Description:The unique identifier of the change request audit record. This is an auto-numbered field that serves as the primary key for the record. | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||