PwsTimeCardHistory

Owned by Bettina Borces
Last updated: Jun 12, 2018 by Luke Wright

Overview


Time card history records all the significant events that occur to a time card, from the time it is first created, until it has been placed on an invoice and issued. This structure represents a single event in the history of a specific time card.

Format


PwsTimecardHistory

Elements


Element

Data Type

Description

Sample Data

AdjustedRevenueAmount

Double

The adjusted revenue amount is the revenue amount after write ups/downs have been applied.

560

AdjustmentCodeIdentity

PwsAdjustmentCodeRef

If this record represents a time card adjustment that required or allowed the user to enter an adjustment code at the time of the adjustment, this is the adjustment code that was supplied.


AdjustmentType

String

The time card adjustment type:

'CDT' for Change Time Description

'CTT' for Change Task/Task Code

'DBT' for Adjust Time for Daily Billing

'II' for Issue Invoice

'IT' for Include Time

'RT' for Revalue Time

'ST' for Split Time

'TPC' for Transfer Time

'TPT' for Transfer Time to Role

'TRT' for Transfer and Exclude Time

'TXT' for Void Invoice

'WT' for Write Up/Down Time

'XT' for Exclude Time

TPT

ApprovalWorkflowStatus

String

The time card's current approval workflow status:

'D' for draft

'R' for rejected

'S' for submitted

'A' for approved

A

BillingAdjustmentAmount

Double

The total amount associated with the billing adjustment (i.e. write up/down).

0

ClientIdentity

PwsClientRef

The client identity associated with the project that is associated with the time card at the time of the history record.


ClientName

String (50)

The client name.

Projector PSA

ContractRevenueAmount

Double

The contract revenue amount is the revenue amount based on negotiated rates.

560

DayFraction

Double

Fraction of a day to be charged to the client.

Hours on a time card divided by the project's Day Length (measured in hours) is the starting value (Day Fraction can be overridden). Day Fraction is a positive number. It isn't generally larger than 1, but it could be.

Refered to as "Billing Days" in field names, although it is based on Hours rather than Chargeable Hours.

0.7

Description

String (1000)

The time card description.

Initial research

EngagementCurrencyIdentity

PwsCurrencyRef

The currency associated with the engagement associated with the time cards' project, at the time of the history record..


EngagementIdentity

PwsEngagementRef

The identity of the engagement.


EngagementName

String (255)

The engagement name.

Web Services Engagement

EngagementTypeBillableFlag

Boolean

If set to 'true', the engagement type is defined as billable.

true

EngagementTypeIdentity

PwsEngagementTypeRef

The engagement type associated with the time cards' project's engagement at the time of the history record.


Explanation

String

The explanation associated with the adjustment.


InvoiceIdentity

PwsInvoiceRef

The invoice the time card is associated with at the time of the history record.


LocationIdentity

PwsLocationRef

The time card's location.


OldAdjustedRevenueAmount

Double

In the case of an adjustment that affected the adjusted revenue amount, this was the adjusted revenue amount prior to the adjustment.

1232

OldBillingAdjustmentAmount

Double

In the case of an adjustment that affected the billing adjustment amount, this was the billing adjustment amount prior to the adjustment.

112

OldClientIdentity

PwsClientRef

In the case of an adjustment that affected the identity of the client, this was the identity of the client prior to the adjustment.


OldClientName

String (50)

In the case of an adjustment that affected the identity of the client, this was the name of the client prior to the adjustment.

Projector PSA

OldContractRevenueAmount

Double

In the case of an adjustment that affected the contract revenue amount, this was the contract revenue amount prior to the adjustment.

1120

OldDayFraction

Double

In the case of an adjustment that affected the day fraction, this was the day fraction prior to the adjustment.


OldDescription

String (1000)

In the case of an adjustment that affected the description, this was the description prior to the adjustment.


OldEngagementCurrencyIdentity

PwsCurrencyRef

In the case of an adjustment that affected the engagement, this was the currency of the engagement prior to the adjustment.


OldEngagementIdentity

PwsEngagementRef

In the case of an adjustment that affected the engagement, this was the identity of the engagement prior to the adjustment.


OldEngagementName

String (255)

In the case of an adjustment that affected the engagement, this was the name of the engagement prior to the adjustment.

Web Services Engagement

OldEngagementTypeIdentity

PwsEngagementTypeRef

In the case of an adjustment that affected the engagement, this was the engagement type of the engagement prior to the adjustment.


OldLocationIdentity

PwsLocationRef

In the case of an adjustment that affected the location, this was the location prior to the adjustment.


OldParentProjectTaskIdentity

PwsProjectTaskRef

In the case of an adjustment that affected the task, this was the parent task of the task prior to the adjustment.


OldParentProjectTaskName

String (512)

In the case of an adjustment that affected the task, this was the parent task name of the task prior to the adjustment.

Task A

OldParentProjectTaskWbsCode

String

In the case of an adjustment that affected the task, this was the work breakdown structure code of the parent task prior to the adjustment.

1

OldProjectIdentity

PwsProjectRef

In the case of an adjustment that affected the project, this was the identity of the project prior to the adjustment.


OldProjectName

String (255)

In the case of an adjustment that affected the project, this was the name of the project prior to the adjustment.

New Web Services Project (A)

OldProjectRateTypeIdentity

PwsProjectRateTypeRef

In the case of an adjustment that affected the project rate type, this was the identity of the rate type prior to the adjustment.


OldProjectRateTypeName

String (50)

In the case of an adjustment that affected the project rate type, this was the name of the rate type prior to the adjustment.

Regular

OldProjectRoleIdentity

PwsProjectRoleRef

In the case of an adjustment that affected the project role, this was the identity of the role prior to the adjustment.


OldProjectRoleName

String (50)

In the case of an adjustment that affected the project role, this was the name of the role prior to the adjustment.

JS

OldProjectTaskIdentity

PwsProjectTaskRef

In the case of an adjustment that affected the project task, this was the identity of the project task prior to the adjustment.


OldProjectTaskName

String (512)

In the case of an adjustment that affected the project task, this was the name of the project task prior to the adjustment.

Task A1

OldProjectTaskTypeIdentity

PwsProjectTaskTypeRef

In the case of an adjustment that affected the project task type, this was the identity of the task type of the project task prior to the adjustment.


OldProjectTaskTypeName

String (50)

In the case of an adjustment that affected the project task type, this was the name of the task type of the project task prior to the adjustment.

Task Type 01

OldProjectTaskWbsCode

String

In the case of an adjustment that affected the project task, this was the work breakdown structure code of the project task prior to the adjustment.

1.1

OldUdf1Value

PwsCardUdfValue

The value of the first user defined field prior to the adjustment.


OldUdf2Value

PwsCardUdfValue

The value of the second user defined field prior to the adjustment.


OldWorkMinutes

Int32

The value of the work minutes prior to the adjustment.


ParentProjectTaskIdentity

PwsProjectTaskRef

The parent task identity of the task associated with the time card.


ParentProjectTaskName

String (512)

The name of the parent task identity of the task associated with the time card.


ParentProjectTaskWbsCode

String

The work breakdown structure of the parent task of the task associated with the time card.


ProjectIdentity

PwsProjectRef

The identity of the project associated with the time card at the time of the history record.


ProjectName

String (255)

The name of the project associated with the time card.

Web Services Project

ProjectRateTypeIdentity

PwsProjectRateTypeRef

The identity of the rate type associated with the time card.


ProjectRateTypeName

String (50)

The name of the rate type associated with the time card.

Regular

ProjectRoleIdentity

PwsProjectRoleRef

The identity of the role associated with the time card.


ProjectRoleName

String (50)

The name of the role associated with the time card.

JS

ProjectTaskIdentity

PwsProjectTaskRef

The identity of the task associated with the time card.


ProjectTaskName

String (512)

The name of the task associated with the time card.

Task 1

ProjectTaskTypeIdentity

PwsProjectTaskTypeRef

The identity of the task type associated with the time card.


ProjectTaskTypeName

String (50)

The name of the task type associated with the time card.

Task Type 01

ProjectTaskWbsCode

String

The work breakdown structure fo the task associated with the time card.

2

RejectedReason

String (255)

The time card's reject reason.

Applicable only when the ApprovalWorkflowStatus = 'R'.


RelatedTimecardIdentity

PwsTimeCardRef

In the case of a split, this is the identity of the related time card.


SplitRatio

Double

In the case of a split, this is the split ratio.


TransactionTimestamp

DateTime

The transaction date and time associated with the time card adjustment (in UTC format).

2018-03-08T18:12:54.203Z

TransactionUser

PwsUserSummary

The identity of the user who issued the adjustment.


Udf1Value

PwsCardUdfValue

The value of the first user defined field.


Udf2Value

PwsCardUdfValue

The value of the second user defined field.


WorkDate

DateTime

The work date associated with the time card.

2018-03-05T00:00:00Z

WorkMinutes

Int32

The work minutes associated with the time card.

336

WriteUpRatio

Double

In the case of a write up, this is the write up ratio.


Example 01 
               <a:PwsTimecardHistory>
                  <a:AdjustedRevenueAmount>560</a:AdjustedRevenueAmount>
                  <a:AdjustmentCodeIdentity i:nil="true" xmlns:b="http://projectorpsa.com/DataContracts/Shared/Common/"/>
                  <a:AdjustmentType>TPT</a:AdjustmentType>
                  <a:ApprovalWorkflowStatus>A</a:ApprovalWorkflowStatus>
                  <a:BillingAdjustmentAmount>0</a:BillingAdjustmentAmount>
                  <a:ClientIdentity xmlns:b="http://projectorpsa.com/DataContracts/Shared/Common/">
                     <b:ClientId i:nil="true"/>
                     <b:ClientNumber>PR-PSA</b:ClientNumber>
                     <b:ClientUid>1152921504606961482</b:ClientUid>
                  </a:ClientIdentity>
                  <a:ClientName>Projector PSA</a:ClientName>
                  <a:ContractRevenueAmount>560</a:ContractRevenueAmount>
                  <a:DayFraction>0.7</a:DayFraction>
                  <a:Description>Initial research</a:Description>
                  <a:EngagementCurrencyIdentity xmlns:b="http://projectorpsa.com/DataContracts/Shared/Common/">
                     <b:CurrencyCode>USD</b:CurrencyCode>
                     <b:CurrencyId i:nil="true"/>
                     <b:CurrencyUid>1152921504606851838</b:CurrencyUid>
                  </a:EngagementCurrencyIdentity>
                  <a:EngagementIdentity xmlns:b="http://projectorpsa.com/DataContracts/Shared/Common/">
                     <b:EngagementCode>E001396</b:EngagementCode>
                     <b:EngagementId i:nil="true"/>
                     <b:EngagementUid>1152921504607324699</b:EngagementUid>
                  </a:EngagementIdentity>
                  <a:EngagementName>Web Services Engagement</a:EngagementName>
                  <a:EngagementTypeBillableFlag>true</a:EngagementTypeBillableFlag>
                  <a:EngagementTypeIdentity xmlns:b="http://projectorpsa.com/DataContracts/Shared/Common/">
                     <b:EngagementTypeId i:nil="true"/>
                     <b:EngagementTypeName>Billable - Time and Materials</b:EngagementTypeName>
                     <b:EngagementTypeShortName>TandM</b:EngagementTypeShortName>
                     <b:EngagementTypeUid>1152921504606863884</b:EngagementTypeUid>
                  </a:EngagementTypeIdentity>
                  <a:Explanation i:nil="true"/>
                  <a:InvoiceIdentity i:nil="true" xmlns:b="http://projectorpsa.com/DataContracts/Shared/Common/"/>
                  <a:LocationIdentity xmlns:b="http://projectorpsa.com/DataContracts/Shared/Common/">
                     <b:LocationId i:nil="true"/>
                     <b:LocationName>USA</b:LocationName>
                     <b:LocationUid>1152921504606855985</b:LocationUid>
                  </a:LocationIdentity>
                  <a:OldAdjustedRevenueAmount>1232</a:OldAdjustedRevenueAmount>
                  <a:OldBillingAdjustmentAmount>112</a:OldBillingAdjustmentAmount>
                  <a:OldClientIdentity xmlns:b="http://projectorpsa.com/DataContracts/Shared/Common/">
                     <b:ClientId i:nil="true"/>
                     <b:ClientNumber>PR-PSA</b:ClientNumber>
                     <b:ClientUid>1152921504606961482</b:ClientUid>
                  </a:OldClientIdentity>
                  <a:OldClientName>Projector PSA</a:OldClientName>
                  <a:OldContractRevenueAmount>1120</a:OldContractRevenueAmount>
                  <a:OldDayFraction i:nil="true"/>
                  <a:OldDescription i:nil="true"/>
                  <a:OldEngagementCurrencyIdentity xmlns:b="http://projectorpsa.com/DataContracts/Shared/Common/">
                     <b:CurrencyCode>USD</b:CurrencyCode>
                     <b:CurrencyId i:nil="true"/>
                     <b:CurrencyUid>1152921504606851838</b:CurrencyUid>
                  </a:OldEngagementCurrencyIdentity>
                  <a:OldEngagementIdentity xmlns:b="http://projectorpsa.com/DataContracts/Shared/Common/">
                     <b:EngagementCode>E001395</b:EngagementCode>
                     <b:EngagementId i:nil="true"/>
                     <b:EngagementUid>1152921504607324698</b:EngagementUid>
                  </a:OldEngagementIdentity>
                  <a:OldEngagementName>Web Services Engagement</a:OldEngagementName>
                  <a:OldEngagementTypeIdentity xmlns:b="http://projectorpsa.com/DataContracts/Shared/Common/">
                     <b:EngagementTypeId i:nil="true"/>
                     <b:EngagementTypeName>Billable - Time and Materials</b:EngagementTypeName>
                     <b:EngagementTypeShortName>TandM</b:EngagementTypeShortName>
                     <b:EngagementTypeUid>1152921504606863884</b:EngagementTypeUid>
                  </a:OldEngagementTypeIdentity>
                  <a:OldLocationIdentity i:nil="true" xmlns:b="http://projectorpsa.com/DataContracts/Shared/Common/"/>
                  <a:OldParentProjectTaskIdentity xmlns:b="http://projectorpsa.com/DataContracts/Shared/Common/">
                     <b:ExternalSystemIdentifier i:nil="true"/>
                     <b:ProjectTaskId i:nil="true"/>
                     <b:ProjectTaskUid>1152921504608637335</b:ProjectTaskUid>
                  </a:OldParentProjectTaskIdentity>
                  <a:OldParentProjectTaskName>Task A</a:OldParentProjectTaskName>
                  <a:OldParentProjectTaskWbsCode>1</a:OldParentProjectTaskWbsCode>
                  <a:OldProjectIdentity xmlns:b="http://projectorpsa.com/DataContracts/Shared/Common/">
                     <b:ProjectCode>P001395-001</b:ProjectCode>
                     <b:ProjectId i:nil="true"/>
                     <b:ProjectUid>1152921504607412209</b:ProjectUid>
                  </a:OldProjectIdentity>
                  <a:OldProjectName>New Web Services Project (A)</a:OldProjectName>
                  <a:OldProjectRateTypeIdentity xmlns:b="http://projectorpsa.com/DataContracts/Shared/Common/">
                     <b:ExternalSystemIdentifier i:nil="true"/>
                     <b:ProjectRateTypeId i:nil="true"/>
                     <b:ProjectRateTypeUid>1152921504607370460</b:ProjectRateTypeUid>
                  </a:OldProjectRateTypeIdentity>
                  <a:OldProjectRateTypeName>Regular</a:OldProjectRateTypeName>
                  <a:OldProjectRoleIdentity xmlns:b="http://projectorpsa.com/DataContracts/Shared/Common/">
                     <b:ExternalSystemIdentifier i:nil="true"/>
                     <b:ProjectRoleId i:nil="true"/>
                     <b:ProjectRoleUid>1152921504609522500</b:ProjectRoleUid>
                  </a:OldProjectRoleIdentity>
                  <a:OldProjectRoleName>JS</a:OldProjectRoleName>
                  <a:OldProjectTaskIdentity xmlns:b="http://projectorpsa.com/DataContracts/Shared/Common/">
                     <b:ExternalSystemIdentifier i:nil="true"/>
                     <b:ProjectTaskId i:nil="true"/>
                     <b:ProjectTaskUid>1152921504608644258</b:ProjectTaskUid>
                  </a:OldProjectTaskIdentity>
                  <a:OldProjectTaskName>Task A1</a:OldProjectTaskName>
                  <a:OldProjectTaskTypeIdentity xmlns:b="http://projectorpsa.com/DataContracts/Shared/Common/">
                     <b:ExternalSystemIdentifier i:nil="true"/>
                     <b:ProjectTaskTypeId i:nil="true"/>
                     <b:ProjectTaskTypeUid>1152921504608115974</b:ProjectTaskTypeUid>
                  </a:OldProjectTaskTypeIdentity>
                  <a:OldProjectTaskTypeName>Task Type 01</a:OldProjectTaskTypeName>
                  <a:OldProjectTaskWbsCode>1.1</a:OldProjectTaskWbsCode>
                  <a:OldUdf1Value xmlns:b="http://projectorpsa.com/DataContracts/Shared/Common/">
                     <b:BooleanValue i:nil="true"/>
                     <b:DateValue i:nil="true"/>
                     <b:IntegerValue i:nil="true"/>
                     <b:TextValue i:nil="true"/>
                     <b:RelationValue i:nil="true"/>
                     <b:NumericValue i:nil="true"/>
                  </a:OldUdf1Value>
                  <a:OldUdf2Value xmlns:b="http://projectorpsa.com/DataContracts/Shared/Common/">
                     <b:BooleanValue i:nil="true"/>
                     <b:DateValue i:nil="true"/>
                     <b:IntegerValue i:nil="true"/>
                     <b:TextValue i:nil="true"/>
                     <b:RelationValue i:nil="true"/>
                     <b:NumericValue i:nil="true"/>
                  </a:OldUdf2Value>
                  <a:OldWorkMinutes i:nil="true"/>
                  <a:ParentProjectTaskIdentity i:nil="true" xmlns:b="http://projectorpsa.com/DataContracts/Shared/Common/"/>
                  <a:ParentProjectTaskName i:nil="true"/>
                  <a:ParentProjectTaskWbsCode i:nil="true"/>
                  <a:ProjectIdentity xmlns:b="http://projectorpsa.com/DataContracts/Shared/Common/">
                     <b:ProjectCode>P001396-001</b:ProjectCode>
                     <b:ProjectId i:nil="true"/>
                     <b:ProjectUid>1152921504607412210</b:ProjectUid>
                  </a:ProjectIdentity>
                  <a:ProjectName>Web Services Project</a:ProjectName>
                  <a:ProjectRateTypeIdentity xmlns:b="http://projectorpsa.com/DataContracts/Shared/Common/">
                     <b:ExternalSystemIdentifier i:nil="true"/>
                     <b:ProjectRateTypeId i:nil="true"/>
                     <b:ProjectRateTypeUid>1152921504607370468</b:ProjectRateTypeUid>
                  </a:ProjectRateTypeIdentity>
                  <a:ProjectRateTypeName>Regular</a:ProjectRateTypeName>
                  <a:ProjectRoleIdentity xmlns:b="http://projectorpsa.com/DataContracts/Shared/Common/">
                     <b:ExternalSystemIdentifier i:nil="true"/>
                     <b:ProjectRoleId i:nil="true"/>
                     <b:ProjectRoleUid>1152921504609525049</b:ProjectRoleUid>
                  </a:ProjectRoleIdentity>
                  <a:ProjectRoleName>JS</a:ProjectRoleName>
                  <a:ProjectTaskIdentity xmlns:b="http://projectorpsa.com/DataContracts/Shared/Common/">
                     <b:ExternalSystemIdentifier i:nil="true"/>
                     <b:ProjectTaskId i:nil="true"/>
                     <b:ProjectTaskUid>1152921504608637344</b:ProjectTaskUid>
                  </a:ProjectTaskIdentity>
                  <a:ProjectTaskName>Task 1</a:ProjectTaskName>
                  <a:ProjectTaskTypeIdentity xmlns:b="http://projectorpsa.com/DataContracts/Shared/Common/">
                     <b:ExternalSystemIdentifier i:nil="true"/>
                     <b:ProjectTaskTypeId i:nil="true"/>
                     <b:ProjectTaskTypeUid>1152921504608115979</b:ProjectTaskTypeUid>
                  </a:ProjectTaskTypeIdentity>
                  <a:ProjectTaskTypeName>Task Type 01</a:ProjectTaskTypeName>
                  <a:ProjectTaskWbsCode>2</a:ProjectTaskWbsCode>
                  <a:RejectedReason i:nil="true"/>
                  <a:RelatedTimecardIdentity i:nil="true" xmlns:b="http://projectorpsa.com/DataContracts/Shared/Common/"/>
                  <a:SplitRatio i:nil="true"/>
                  <a:TransactionTimestamp>2018-03-08T18:12:54.203Z</a:TransactionTimestamp>
                  <a:TransactionUser xmlns:b="http://projectorpsa.com/DataContracts/Shared/Common/">
                     <b:UserDisplayName>Jack Spratt</b:UserDisplayName>
                     <b:UserId i:nil="true"/>
                     <b:UserReferenceSystemId>E123</b:UserReferenceSystemId>
                     <b:UserUid>1152921504607112369</b:UserUid>
                     <b:EmailAddress>jack@revcorp.bb</b:EmailAddress>
                     <b:FirstName>Jack</b:FirstName>
                     <b:LastName>Spratt</b:LastName>
                     <b:MiddleName i:nil="true"/>
                  </a:TransactionUser>
                  <a:Udf1Value xmlns:b="http://projectorpsa.com/DataContracts/Shared/Common/">
                     <b:BooleanValue i:nil="true"/>
                     <b:DateValue i:nil="true"/>
                     <b:IntegerValue i:nil="true"/>
                     <b:TextValue i:nil="true"/>
                     <b:RelationValue>
                        <b:CodeValue>SD-23</b:CodeValue>
                        <b:TextValue>2 laptops for demo</b:TextValue>
                        <b:UidValue>10022</b:UidValue>
                     </b:RelationValue>
                     <b:NumericValue i:nil="true"/>
                  </a:Udf1Value>
                  <a:Udf2Value xmlns:b="http://projectorpsa.com/DataContracts/Shared/Common/">
                     <b:BooleanValue i:nil="true"/>
                     <b:DateValue i:nil="true"/>
                     <b:IntegerValue i:nil="true"/>
                     <b:TextValue i:nil="true"/>
                     <b:RelationValue i:nil="true"/>
                     <b:NumericValue i:nil="true"/>
                  </a:Udf2Value>
                  <a:WorkDate>2018-03-05T00:00:00Z</a:WorkDate>
                  <a:WorkMinutes>336</a:WorkMinutes>
                  <a:WriteUpRatio i:nil="true"/>
               </a:PwsTimecardHistory>