Page Comparison

ReferenceId

String

No

Reference id (used to affiliate PwsSaveTimecardResult records with associated PwsTimeCardDetail records).

TimecardId

Int32

No 

The time card Id is a unique identifier for a time card. For internal use only. 

TimecardType

String

No

The time card type:

'T' for time card associated with a project

'R' for reported time off

T

TimecardUid

Int64

On Insert: No

On Update: Yes

A unique and immutable identifier for a time card

1152921504646141261

Description

String (1000)

No (unless the time card task type requires a description)

The time card description

Initial research

DescriptionClearFlag

Boolean

No

false 

If set to 'true', the time card description will be cleared 

false

RejectedByUser

PwsUserRef

Yes (if the status = 'R')

The user who rejected the time card 

Note: This is only applicable if the status = 'R' for rejected 

RejectedReason

String (255)

Yes (if the status = 'R')

The reject reason associated with the time card

Note: This is only applicable if the status = 'R' for rejected 

RejectedTimestamp

DateTime

Yes (if the status = 'R')

The date and time when the time card was rejected

Note: This is only applicable if the status = 'R' for rejected 

Status

TimeCardStatus

On Insert: Yes

On Update: No

The status is similar to the CardStatus, but holds more information to enable proper UI treatment. The possible UI workflow statuses are:

• Draft
• Rejected
• Submitted
• Approved
• Draft-okay
• Draft-error
• remove-on-save
• Draft-save-UI-defective
• Draft-submit-UI-defective

Submitted

WorkDate

DateTime

On Insert: Yes

On Update: No

The work date associated with the time card

2018-03-05T00:00:00Z

WorkMinutes

Int32

On Insert: Yes

On Update: No

The work minutes associated with the time card 

480

Timestamp

String

No

This is a Base64 encoded timestamp optionally utilized for time card locking  

AAAAAA64Niw=

CardStatus

String

On Insert: Yes

On Update: No

The time card status

'D' for draft

'R' for rejected

'S' for submitted

'A' for approved

'B' for billed

'T' for created by split (Transient)

S

LocationClearFlag

Boolean

No

false

If set to 'true', the time card location is cleared

false

LocationIdentity

PwsLocationRef

On Insert: No (unless locations are required for time cards in the installation)

On Update: No

The location associated with the time card

ProjectIdentity

PwsProjectRef

On Insert: Yes

On Update: No

The project associated with the time card

ProjectRateTypeIdentity

PwsProjectRateTypeRef

On Insert: Yes

On Update: No

The project rate type associated with the time card 

ProjectTaskIdentity

PwsProjectTaskRef

On Insert: Yes

On Update: No

The project task associated with the time card 

RoleClearFlag

Boolean

No

false 

If set to 'true', the time card project role is cleared

false

RoleIdentity

PwsProjectRoleRef

On Insert: Yes

On Update: No

The project role associated with time card

Udf1

PwsUserDefinedFieldDetail

On Insert: No (unless the first UDF is required for the time card task type requires Udf1)

On Update: NoNo  

The first user defined field associated with the time card 

Udf1ClearFlag

Boolean

No

false 

If set to 'true', the first user defined field is cleared 

false

Udf2

PwsUserDefinedFieldDetail

On Insert: No (unless the first second UDF is required for the time card task type requires Udf2)

On Update: NoNo  

The second user defined field associated with the time card

Udf2ClearFlag

Boolean

No

If set to 'true', the second user defined field is cleared 

false

ExternalGroupingIdentifier

Int32

No

false 

This unique identifier allows users to group multiple time cards together, most commonly user for reporting purposes

ExternalGroupingIdentifierClearFlag

Boolean

No

false 

If set to 'true', the external grouping identifier is cleared