ROBOHEAD REST API

REST API Documentation
Up

Models

Table of Contents

  1. Account
  2. AccountHoliday
  3. AccountSummary
  4. ActivityLog
  5. ActivityUser
  6. ActiveUserGroupList
  7. ActualExpense
  8. AllActiveGroup
  9. AnnotationViewer
  10. Announcement
  11. AnnouncementRole
  12. AnnouncementUser
  13. BudgetedExpense
  14. Campaign
  15. CampaignForm
  16. CampaignProject
  17. CampaignSecurity
  18. CampaignSummary
  19. ChangeTracking
  20. Chart
  21. Client
  22. ClientFee
  23. ClientFeeHistory
  24. ClientOption
  25. ClientSummary
  26. Coordinate
  27. CwClient
  28. CwUser
  29. DashboardMap
  30. DashboardPreference
  31. DashboardUserWeeklyActivityType
  32. EmailTemplate
  33. EstimateBudgetedExpense
  34. EstimateLaborExpense
  35. EstimateRateCard
  36. EstimateTypeTotals
  37. ExpenseFieldOptions
  38. Field
  39. FieldComparator
  40. FieldEvent
  41. FieldJavascript
  42. FieldOption
  43. FieldType
  44. FieldValue
  45. File
  46. FileActivityLog
  47. FileExternalLink
  48. FileVersion
  49. Folder
  50. FolderSecurity
  51. FinanceItem
  52. FinanceSummary
  53. Form
  54. FormHistory
  55. FulltextSearch
  56. GetCampaign
  57. GetFolderDetail
  58. GetProject
  59. GetProjectRequestActivity
  60. GetRequest
  61. GetTimeSheet
  62. GlobalList
  63. GroupUser
  64. IdValuePair
  65. IntervalDateDetail
  66. ItemLastRead
  67. ListColumn
  68. ListProjectTaskAndReview
  69. NameValuePair
  70. NonProjectTask
  71. Note
  72. NoteUser
  73. NotificationEvent
  74. NotificationEventScope
  75. NotificationMethodName
  76. NotificationPreference
  77. PayRate
  78. Permission
  79. Project
  80. ProjectFee
  81. ProjectFeeHistory
  82. ProjectFeeSummary
  83. ProjectForm
  84. ProjectPurchaseOrder
  85. PurchaseOrder
  86. PurchaseOrderChargeHistory
  87. ProjectSecurity
  88. ProjectSummary
  89. ProjectItem
  90. RateCard
  91. RateCardHistory
  92. Report
  93. ReportColumn
  94. ReportCondition
  95. ResourceUtilizationInfoMap
  96. ResourceUtilizationMap
  97. Result
  98. Review
  99. ReviewAnnotationViewer
  100. ReviewComment
  101. ReviewGroupUser
  102. ReviewItem
  103. ReviewMultipage
  104. ReviewOwner
  105. ReviewSummary
  106. ReviewUser
  107. ReviewUsergroup
  108. ReviewVersion
  109. ReviewVersionStatus
  110. ReviewerCommentDetail
  111. Role
  112. Rule
  113. RuleAction
  114. RuleCondition
  115. RunReport
  116. Section
  117. SectionField
  118. Series
  119. Stamp
  120. SummaryField
  121. Tag
  122. TagValue
  123. Task
  124. TaskDetailsList
  125. TaskHoursDetail
  126. TaskPredecessor
  127. TaskPriority
  128. TaskRole
  129. TaskSummary
  130. TaskUser
  131. TimeTaskList
  132. Timesheet
  133. TimesheetApprovers
  134. TimesheetStatusHistory
  135. Timeslip
  136. TimeslipNonprj
  137. Todo
  138. UnreadObjectCount
  139. User
  140. UserClient
  141. UserEmailMap
  142. UserFavority
  143. UserGroup
  144. UserHoliday
  145. UserPermission
  146. UserCapacity
  147. UserResourceUtilizationList
  148. UserSummary
  149. UserTaskRole
  150. UserTaskRoleRate
  151. UserCalendarResponse
  152. UserGanttDetails
  153. RateInfo
  154. MonthlyAccountSummary
  155. QuarterlyAccountSummary
  156. TaskGroup
  157. UserFilter
  158. Survey
  159. SurveyRecipient
  160. SurveyResponse
  161. ScheduleGanttView
  162. NoteThread
  163. NoteThreadUser
  164. ReviewCcUser
  165. PdfLayerDetail

Account Up

id
Long format: int64
globalListByContractTermsId
GlobalList
globalListByInvoiceFrequencyId
GlobalList
globalListByClassificationId
GlobalList
globalListByCurrencyId
GlobalList
globalListByAccountManagerId
GlobalList
globalListByIndustryId
GlobalList
createdBy
Long format: int64
createdOn
date format: date
modifiedBy
Integer
modifiedOn
date format: date
state
Integer
accountName
String
accountUrl
String
timezone
String
defaultEmailDisplayName
String
inboxEmailName
String
accountCloseDate
date format: date
directS3Download
Integer
requestNumberFormat
String
resetRequestNumberYearlyFlag
Integer
startRequestNumber
Integer
fiscalYearStartDate
date format: date
projectNumberFormat
String
resetProjectNumberYearlyFlag
Integer
startProjectNumber
Integer
pwdExpiryDays
Integer
pwdMinimumLength
Integer
requireInitialPwdReset
Integer
pwdContainNumber
Integer
pwdContainSymbol
Integer
pwdUpperLower
Integer
pwdAsUserName
Integer
allowSaveUserName
Integer
allowSavePwd
Integer
allowEditForApproval
Integer
allowExternalRequests
Integer
allowExternalReviews
Integer
storageLimit
Integer
enableReviewModule
Integer
enableRequestModule
Integer
enableProjectModule
Integer
enableLibraryModule
Integer
enableCampaignModule
Integer
enableTimeModule
Integer
enableExpenseModule
Integer
enablePersonalTodos
Integer
enableTaskModule
Integer
enableClientModule
Integer
enableApi
Integer
expenseContribute
Integer
expenseView
Integer
sessionTimeoutMinutes
Integer
numContractedUsers
Integer
numContractedContacts
Integer
dateFormat
String
customLabels
String
requiredTaskDates
Integer
requiredReviewDates
Integer
weekStartDay
Integer
contractSignature
date format: date
firstUseDate
date format: date
poEndDate
date format: date
renewalType
Integer
loginCustomLabels
String
extraStorageRate
Double format: double
nameOnContract
String
contractLastExecutionDate
date format: date
goLiveDate
date format: date
otherTerms
String
legacyAccount
Integer
billingDay
Integer
baseRatePerUser
Double format: double
additionalUserRate
Double format: double
collaboratorModuleRate
Double format: double
requesterModuleRate
Double format: double
bundledModuleRate
Double format: double
enableSaml
Integer
samlEntityId
String
accountSummary
AccountSummary
accountLogoUrl
String
welcomeLogoUrl
String
formatttedProjectNumberFormat
Integer
formatttedRequestNumberFormat
Integer
messagesMap
Object Map of custom messages.
maxNumFailedAttempts
Integer
numLastPwdCannotbeUsed
Integer
allowRequesterEditSubmittedRequest
Integer
requiredProjectDates
Integer
requiredCampaignDates
Integer
enableAdvancedDam
Integer
enableDamForContacts
Integer
enableClientSegmentation
Integer
enableChat
Integer
enableCwSync
Integer
enableEstimatesModule
Integer
enableBillingModule
Integer
enableAdvancedTimesheetApproval
Integer
enablePo
Integer

AccountHoliday Up

id
Integer
account
Account
Client
Client
createdBy
Integer
createdOn
date format: date
modifiedBy
Integer
modifiedOn
date format: date
startDate
date format: date
endDate
date format: date
description
String

AccountSummary Up

account
Account
storageUsed
Integer
numUsers
Integer
numContacts
Integer
lastLogin
date format: date

ActivityLog Up

id
Integer
account
Account
notificationEvent
NotificationEvent
performedBy
Integer
performedOn
date format: date
objectId
Integer
objectType
Integer
rootObjectId
Integer
rootObjectType
Integer
activityUserJobStatusId
Integer
activityUsers
ActivityUser
performedByUserImage
String
userEmailAddressList
String
userEmailAddress
String
userTimeZone
String
subject
String
streamMessage
String
emailPlaintextMessage
String
emailHtmlMessage
String

ActivityUser Up

id
Integer
user
User
activityLog
ActivityLog
inDashboardStream
Integer
inImmediateEmail
Integer
inDailyEmail
Integer
inWeeklyEmail
Integer

ActiveUserGroupList Up

id
Integer User Id or Group Id.
displayName
String User Name or Group Name.
isUser
Boolean If user object then it is true otherwise false when it is group object.
emailAddress
String User email address(Applicable for User object)
roleId
Integer User role Id (Applicable for User object).

ActualExpense Up

id
Integer
project
Project
budgetedExpense
BudgetedExpense
expenseFieldOptionsBySupplierId
ExpenseFieldOptions
expenseFieldOptionsByExpenseType
ExpenseFieldOptions
createdBy
Integer
createdOn
date format: date
modifiedBy
Integer
modifiedOn
date format: date
state
Integer
expenseDate
date format: date
actualAmount
Double format: double
invoiceNumber
String
deletedBudgetedExpenseReferenceId
Integer
description
String
user
User
markupPercentage
BigDecimal
billAmount
BigDecimal
globalList
GlobalList
invoiceInfo
String
invoiceId
Integer

AllActiveGroup Up

id
Integer
createdBy
Integer
createdOn
date format: date
modifiedBy
Integer
modifiedOn
date format: date
state
Integer
name
String Returned for user group only
reviewUsergroupName
String returend for review group only
createdByUser
String
modifiedByUser
String

AnnotationViewer Up

refreshComments
Boolean
annotationViewers
String comma seperated annotation viewer

Announcement Up

id
Integer
account
Account
createdBy
Integer
createdOn
date format: date
modifiedBy
Integer
modifiedOn
date format: date
state
Integer
name
String
type
Integer
header
String
body
String
startDate
date format: date
expiryDate
date format: date
announcementRoles
AnnouncementRole
announcementUsers
AnnouncementUser
roles
Role

AnnouncementRole Up

id
Integer
role
Role
announcement
Announcement
createdBy
Integer
createdOn
date format: date
modifiedBy
Integer
modifiedOn
date format: date

AnnouncementUser Up

id
Integer
user
User
announcement
Announcement
createdBy
Integer
createdOn
date format: date
modifiedBy
Integer
modifiedOn
date format: date
readDate
date format: date

BudgetedExpense Up

id
Integer
project
Project
expenseFieldOptions
ExpenseFieldOptions
createdBy
Integer
createdOn
date format: date
modifiedBy
Integer
modifiedOn
date format: date
state
Integer
budgetedAmount
Double format: double
description
String
actualExpenseTotal
Double format: double
actualExpenses
ActualExpense
leaf
Boolean
fieldValues
Double format: double

Campaign Up

id
Integer
client
Client
account
Account
createdBy
Integer
createdOn
date format: date
modifiedBy
Integer
modifiedOn
date format: date
state
Integer
name
String
startDate
date format: date
dueDate
date format: date
description
String
budgetedExpense
Integer
budgetedRevenue
Integer
campaignSummary
CampaignSummary
campaignSecurities
CampaignSecurity
campaignProjects
CampaignProject
fieldValues
FieldValue
leaf
Boolean
createdByUser
String
modifiedByUser
String
tag
Tag
campaignNumber
Integer
formattedCampaignNumber
String

CampaignForm Up

id
Integer
account
Account
createdBy
Integer
createdOn
date format: date
modifiedBy
Integer
modifiedOn
date format: date
formType
Integer
customJs
String
introText
String
confirmationMessage
String
sections
Section
formHistories
FormHistoy
formStatus
Integer
modifiedByUser
String
formName
String

CampaignProject Up

id
Integer
project
Project
campaign
Campaign
createdBy
Integer
createdOn
date format: date
modifiedBy
Integer
modifiedOn
date format: date
sortOrder
Integer

CampaignSecurity Up

id
Integer
user
User
usergroup
UserGroup
campaign
Campaign
createdBy
Integer
createdOn
date format: date
modifiedBy
Integer
modifiedOn
date format: date
security
Integer

CampaignSummary Up

campaignId
Integer
campaign
Campaign
numProjects
Integer
numProjectsOverBudget
Integer
numProjectsBlocked
Integer
numTasksCompleted
Integer
numTasksInProgress
Integer
numTasksNotStarted
Integer
projectBudgetedExpense
Double format: double
projectBudgetedLabor
Double format: double
projectTotalBudgetedCost
Double format: double
projectEstimatedRevenue
Double format: double
projectActualExpense
Double format: double
projectTotalActualCost
Double format: double
budgetRemaining
Double format: double
onBudget
Integer
isBlocked
Integer
numProjectsBehindSchedule
Integer
isOnSchedule
Integer

ChangeTracking Up

id
Integer
user
User
changedOn
date format: date
objectId
Integer
objectType
Integer
trackingType
Integer
oldValue
String
newValue
String
description
String

Chart Up

xLabel
String
yLabel
String
start
Integer
limit
Integer
totalRecords
Integer
page
Integer
series
Series

Client Up

id
Integer
account
Account
createdBy
Integer
createdOn
date format: date
modifiedBy
Integer
modifiedOn
date format: date
state
Integer
name
String
description
String
code
String
clientLogoUrl
String
clientSummary
ClientSummary
modifiedByUser
String
emailDisplayName
String
fiscalYearStartDate
date format: date
requestNumberFormat
String
startRequestNumber
Integer
resetRequestNumberYearlyFlag
Integer
projectNumberFormat
String
startProjectNumber
Integer
resetProjectNumberYearlyFlag
Integer
globalList
GlobalList
userClient
UserClient
cwClient
CwClient
classificationCode
String

ClientFee Up

id
Integer
user
User
globalListByFrequency
GlobalList
account
Account
client
Client
globalListByStatusId
GlobalList
purchaseOrder
PurchaseOrder
globalListByEnds
GlobalList
globalListByFeeTypeId
GlobalList
createdBy
Integer
createdOn
date format: date
modifiedBy
Integer
modifiedOn
date format: date
billDate
date format: date
amount
BigDecimal
description
String
state
Integer
recurring
Integer
repeatInterval
Integer
numOccurences
Integer
lastBillDate
date format: date
nextBillDate
date format: date
startDate
date format: date
endDate
date format: date
isCwSynced
Integer

ClientFeeHistory Up

id
Integer
user
User
account
Account
client
Client
globalListByStatusId
GlobalList
purchaseOrder
PurchaseOrder
globalListByFeeTypeId
GlobalList
createdBy
Integer
createdOn
date format: date
billDate
date format: date
amount
BigDecimal
description
String
isCwSynced
Integer
isClientFeeOpen
Integer
invoiceId
Integer
invoiceNumber
String

ClientSummary Up

numActiveProjects
Integer
numArchivedProjects
Integer
numActiveCampaigns
Integer
numArchivedCampaigns
Integer
budgetActiveProjects
Double format: double
budgetActiveCampaigns
Double format: double
budgetArchivedProjects
Double format: double
budgetArchivedCampaigns
Double format: double
revenueActiveProjects
Double format: double
revenueArchivedProjects
Double format: double
revenueArchivedCampaigns
Double format: double
actualExpenseActiveProjects
Double format: double
actualExpenseActiveCampaigns
Double format: double
actualExpenseArchivedProjects
Double format: double
actualExpenseArchivedCampaigns
Double format: double

Coordinate Up

xValue
Object
yValue
Object

CwClient Up

id
Integer
cwClientId
String
cwClientName
String
modifiedOn
date
createdOn
date
state
Integer
previousCwClientId
String

CwUser Up

id
Integer
cwUserId
String
cwEmailAddress
String
cwFirstName
String
cwLastName
String
modifiedOn
date
createdOn
date
state
Integer
previousCwUserId
String
globalList
GlobalList

RateCardHistory Up

id
Integer
rateCard
RateCard
createdBy
Integer
createdOn
date
modifiedBy
Integer
modifiedOn
date
effectiveDate
date
unitCost
BigDecimal

DashboardMap Up

id
Long format: int64
createdBy
Long format: int64
createdOn
date format: date
modifiedBy
Integer
modifiedOn
date format: date
state
Integer
listType
Integer
value
Integer
displayValue
String
sortOrder
Integer

DashboardPreference Up

id
Integer
user
User
globalList
GlobalList
createdBy
Integer
createdOn
date format: date
modifiedBy
Integer
modifiedOn
date format: date
tabId
Integer
avatarFlag
Integer
numRecentActivity
Integer
sectionSortOrder
Integer
tabSortOrder
Integer
dashboardViewType
Integer
reportName
String
reportType
Integer
screenSize
Integer

DashboardUserWeeklyActivityType Up

requestSubmittedCount
Integer
projectStartedCount
Integer
projectCreatedCount
Integer
endWeek
date format: date
hoursEstimated
Double format: double
hoursWorked
Double format: double

EmailTemplate Up

id
Integer
globalList
GlobalList
account
Account
createdBy
Integer
createdOn
date format: date
modifiedBy
Integer
modifiedOn
date format: date
templateType
Integer
subject
String
plaintextMessage
String
htmlMessage
String

EstimateBudgetedExpense Up

id
Integer
estimateTypeTotals
EstimateTypeTotals
estimate
Estimate
expenseFieldOptions
ExpenseFieldOptions
createdBy
Integer
createdOn
date
description
String
budgetedAmount
BigDecimal
taxRate
BigDecimal
taxAmount
BigDecimal
total
BigDecimal

EstimateLaborExpense Up

id
Integer
estimateTypeTotals
EstimateTypeTotals
taskRole
TaskRole
estimate
Estimate
createdBy
Integer
createdOn
date
description
String
hours
BigDecimal
taxRate
BigDecimal
taxAmount
BigDecimal
total
BigDecimal
rate
BigDecimal

EstimateRateCard Up

id
Integer
estimateTypeTotals
EstimateTypeTotals
rateCard
RateCard
estimate
Estimate
createdBy
Integer
createdOn
date
description
String
quantity
BigDecimal
taxRate
BigDecimal
taxAmount
BigDecimal
total
BigDecimal
unitCost
BigDecimal

EstimateTypeTotals Up

id
Integer
estimate
Estimate
createdBy
Integer
createdOn
date
estimateType
Integer
totalTax
BigDecimal
total
BigDecimal

ExpenseFieldOptions Up

id
Integer
account
Account
client
Client
createdBy
Integer
createdOn
date format: date
modifiedBy
Integer
modifiedOn
date format: date
state
Integer
listType
Integer
displayValue
String
sortOrder
Integer

Field Up

id
Integer
fieldType
FieldType
globalList
GlobalList
account
Account
createdBy
Integer
createdOn
date format: date
modifiedBy
Integer
modifiedOn
date format: date
state
Integer
objectType
Integer
displayName
String
noOfDecimal
Integer
fieldOptions
FieldOption
reportColumns
ReportColumn
sectionFields
SectionField
summaryFields
SummaryField
ruleConditions
RuleCondition
fieldValues
FieldValue
listColumns
ListColumn
reportConditions
ReportCondition
reportsForGroupByFieldId
Report
ruleActions
RuleAction
reportsForSortByFieldId
Report
fieldOptionJson
String

FieldComparator Up

id
Integer
fieldType
FieldType
globalList
GlobalList

FieldEvent Up

id
Integer
fieldType
FieldType
name
String
description
String

FieldJavascript Up

id
Integer
fieldEvent
FieldEvent
sectionField
SectionField
createdBy
Integer
createdOn
date format: date
modifiedBy
Integer
modifiedOn
date format: date
state
Integer
functionName
String

FieldOption Up

id
Integer
field
Field
createdBy
Integer
createdOn
date format: date
modifiedBy
Integer
modifiedOn
date format: date
state
Integer
displayValue
String
sortOrder
Integer
projectsForProjectCode
Project
projectsForProjectStatusId
Project
fieldValues
FieldValue

FieldType Up

id
Integer
createdBy
Integer
createdOn
date format: date
modifiedBy
Integer
modifiedOn
date format: date
name
String
description
String

FieldValue Up

id
Integer
field
Field
fieldOption
FieldOption
createdBy
Integer
createdOn
date format: date
modifiedBy
Integer
modifiedOn
date format: date
objectId
Integer
objectType
Integer
textValue
String
numValue
Double format: double
dateValue
date format: date
value
String
optionIds
Integer

File Up

id
Integer
account
Account
createdBy
Integer
createdOn
date format: date
modifiedBy
Integer
modifiedOn
date format: date
state
Integer
objectId
Integer
objectType
Integer
fileName
String
fileVersionById
FileVersion
parentFileId
Integer
versionDescription
String
fileVersion
Integer
title
String
mimeType
String
size
Long format: int64
numPages
Integer
height
Integer
width
Integer
rhS3Path
String
reviewVersions
ReviewVersion
fileActivityLogs
FileActivityLog
fileExternalLink
FileExternalLink
usersForStandardAvatarFileId
User
usersForCustomAvatarFileId
User
createdByUserName
String
originalFileUrl
String
thumbnailUrl
String
previewImageUrl
String
fileSecurity
Integer
objectName
String
rhcInfo
String
modifiedByUser
String

FileActivityLog Up

id
Integer
file
File
user
User
activityOn
date format: date
description
String
objectId
Integer
objectType
Integer

FileExternalLink Up

id
Integer
account
Account
user
User
createdBy
Integer
createdOn
Date format: date
modifiedBy
Integer
modifiedOn
Date format: date
expiryDate
Date format: date
externalUrl
String
file
File
groupId
String
linkedFileList
File

FileVersion Up

fileId
File
parentFileId
File
fileVersion
Integer
description
String

Folder Up

id
Integer
folderByDeletedParentReferenceId
Folder
account
Account
folderByParentFolderId
Folder
createdBy
Integer
createdOn
date format: date
modifiedBy
Integer
modifiedOn
date format: date
state
Integer
folderName
String
folderPath
String
folderNamePath
String
folderSecurities
FolderSecurity
foldersForParentFolderId
Folder
foldersForDeletedParentReferenceId
Folder
isLeaf
Boolean
createdByUserName
String

FolderSecurity Up

id
Integer
user
User
folder
Folder
usergroup
UserGroup
createdBy
Integer
createdOn
date format: date
modifiedBy
Integer
modifiedOn
date format: date
security
Integer

FinanceItem Up

objectType
Integer
itemName
String
estimateTotal
BigDecimal
actualTotal
BigDecimal
invoicedTotal
BigDecimal

FinanceSummary Up

financeItemList
FinanceItem
estimateTotal
BigDecimal
actualTotal
BigDecimal
invoicedTotal
BigDecimal
estimateId
Integer

Form Up

id
Integer
account
Account
createdBy
Integer
createdOn
date format: date
modifiedBy
Integer
modifiedOn
date format: date
formType
Integer
introText
String
confirmationMessage
String
sections
Section
formHistories
FormHistory
formStatus
Integer
modifiedByUser
String
formName
String
client
Client
state
Integer

FormHistory Up

id
Integer
form
Form
account
Account
createdBy
Integer
createdOn
date format: date
modifiedBy
Integer
modifiedOn
date format: date
formStatus
Integer
jsonText
String
formJavaScript
String
viewFormJavaScript
String
ruleJavaScript
String
rules
Object Set of rules
client
Client
state
Integer

FulltextSearch Up

ActiveCampaignCount
Integer
ActiveProjectCount
Integer
ActiveRequestCount
Integer
ArchivedCampaignCount
Integer
ArchivedProjectCount
Integer
ArchivedRequestCount
Integer
CampaignIds
Integer comma seperated Id's
ProjectIds
Integer comma seperated Id's
RequestIds
Integer comma seperated Id's
FileIds
Integer comma seperated Id's
TaskIds
Integer comma seperated Id's
ReviewIds
Integer comma seperated Id's
NoteIds
Integer comma seperated Id's
FileCount
Integer
TaskCount
Integer
ReviewCount
Integer
NoteCount
Integer
activeCount
Integer
archivedCount
Integer
totalCount
Integer

GetCampaign Up

campaign
Campaign
campaignForm
CampaignForm

GetFolderDetail Up

folder
Folder
file
File

GetProject Up

project
Project
projectForm
ProjectForm

GetProjectRequestActivity Up

projectCount
Integer
endWeek
date format: date
requestCount
Integer

GetRequest Up

request
Project
requestForm
ProjectForm

GetTimeSheet Up

isTimeSheetOpen
Integer
timeSheet
TimeTaskList

GlobalList Up

id
Long format: int64
createdBy
Long format: int64
createdOn
date format: date
modifiedBy
Integer
modifiedOn
date format: date
state
Integer
listType
Integer
value
String
displayValue
String
sortOrder
Integer

GroupUser Up

id
Integer
user
User
usergroup
UserGroup
createdBy
Integer
createdOn
date format: date
modifiedBy
Integer
modifiedOn
date format: date

IdValuePair Up

id
Integer
value
String

IntervalDateDetail Up

date
date format: date
isHoliday
Boolean
isWeekend
Boolean

ItemLastRead Up

id
Integer
user
User
createdBy
Integer
createdOn
date format: date
modifiedBy
Integer
modifiedOn
date format: date
itemType
Integer
objectId
Integer
lastReadTimestamp
date format: date

ListColumn Up

id
Integer
field
Field
account
Account
formType
Integer
selectedFlag
Integer
sortOrder
Integer

ListProjectTaskAndReview Up

review
Review
task
Task

NameValuePair Up

name
String
value
String

NonProjectTask Up

id
Integer
taskRole
TaskRole
account
Account
createdBy
Integer
createdOn
date
client
Client
modifiedBy
Integer
modifiedOn
date
state
Integer
displayValue
String
sortOrder
Integer

Note Up

id
Integer
noteByParentNoteId
Note
account
Account
noteByRootNoteId
Note
createdBy
Integer
createdOn
date format: date
modifiedBy
Integer
modifiedOn
date format: date
state
Integer
objectId
Integer
objectType
Integer
description
String
noteType
Integer
lastReplyDate
date format: date
sendEmail
Integer
createdByUser
String
modifiedByUser
String
noteCreatorImageUrl
String
objectName
String
noOfReplies
Integer
createdByUserRoleId
Integer
noteUserNames
String comma seperated name's
noteUserIds
String comma seperated id's
noteUserGroups
String
noteUserGroupIds
String comma seperated id's
attachmentExists
Boolean

NoteUser Up

id
Integer
user
User
note
Note
usergroup
Usergroup
createdBy
Integer
createdOn
date format: date
modifiedBy
Integer
modifiedOn
date format: date

NotificationEvent Up

id
Integer
createdBy
Integer
createdOn
date format: date
modifiedBy
Integer
modifiedOn
date format: date
name
String
moduleType
Integer
description
String
subjectFormat
String
streamMessageFormat
String
emailPlaintextMessageFormat
String
emailHtmlMessageFormat
String
activityLogs
ActivityLog
notificationEventScopes
NotificationEventScope

NotificationEventScope Up

id
Integer
notificationEvent
NotificationEvent
createdBy
Integer
createdOn
date format: date
modifiedBy
Integer
modifiedOn
date format: date
scope
Integer
displayName
String
notificationPreferences
NotificationPreference

NotificationMethodName Up

index
String List of notificationMethodNames, index=>count:value:notificationMethodName

NotificationPreference Up

id
Integer
user
User
notificationEventScope
NotificationEventScope
createdBy
Integer
createdOn
date format: date
modifiedBy
Integer
modifiedOn
date format: date
notificationMethod
Integer
notificationMethodNames
NotificationMethodName

PayRate Up

id
Integer
user
User
createdBy
Integer
createdOn
date
modifiedBy
Integer
modifiedOn
date
effectiveDate
date
payRate
BigDecimal
burden
BigDecimal
isSalaried
Integer

Permission Up

id
Integer
role
Role
createdBy
Integer
createdOn
date format: date
modifiedBy
Integer
modifiedOn
date format: date
name
String
description
String

Project Up

id
Integer
client
Client
project
Project
fieldOptionByProjectStatusId
FieldOption
fieldOptionByProjectCode
FieldOption
account
Account
createdBy
Integer
createdOn
date format: date
modifiedBy
Integer
modifiedOn
date format: date
state
Integer
name
String
description
String
startDate
date format: date
dueDate
date format: date
originalStartDate
date format: date
originalDueDate
date format: date
projectNumber
Integer
requestNumber
Integer
formattedProjectNumber
String
formattedRequestNumber
String
requestStatusId
Integer
projectCreateDate
date format: date
requestCreateDate
date format: date
budgetedExpense
Double format: double
budgetedLabor
Double format: double
budgetedRevenue
Double format: double
actualExpense
Double format: double
actualLabor
Double format: double
actualRevenue
Double format: double
projectSecurities
ProjectSecurity
budgetedExpenses
BudgetedExpense
actualExpenses
ActualExpense
campaignProjects
CampaignProject
projects
Project
projectSummary
ProjectSummary
reviews
Review
tasks
Task
createdByUser
String
modifiedByUser
String
requestStatus
String
fieldValues
FieldValue
leaf
Boolean
requesterEmail
String
requesterClient
String
requesterTitle
String
campaignId
Integer
campaignName
String
minStartDateInProject
date format: date
maxDueDateInProject
date format: date
campaignSecurity
Integer
tag
Tag
user
User
globalListByBillingStatusId
GlobalList
globalListByBillingTypeId
GlobalList

ProjectFee Up

id
Integer
userTaskRoleRate
UserTaskRoleRate
globalListByStatusId
GlobalList
globalListByEnds
GlobalList
globalListByFeeTypeId
GlobalList
purchaseOrder
PurchaseOrder
project
Project
createdBy
Integer
createdOn
date format: date
billDate
date format: date
amount
BigDecimal
description
String
state
Integer
recurring
Integer
repeatInterval
Integer
numOccurences
Integer
lastBillDate
date format: date
nextBillDate
date format: date
startDate
date format: date
endDate
date format: date
isCwSynced
Integer
purchaseOrder
PurchaseOrder

ProjectFeeHistory Up

id
Integer
userTaskRoleRate
UserTaskRoleRate
account
Account
globalList
GlobalList
project
Project
createdBy
Integer
createdOn
date format: date
billDate
date format: date
amount
BigDecimal
description
String
isCwSynced
Integer
purchaseOrder
PurchaseOrder
projectFee
ProjectFee
invoiceId
Integer
invoiceNumber
String

ProjectFeeSummary Up

fixedResourceAmount
Integer
amountRemaining
Integer
projectEstimateTotal
Integer
previouslyEntered
Integer

ProjectForm Up

id
Integer
account
Account
createdBy
Integer
createdOn
date format: date
modifiedBy
Integer
modifiedOn
date format: date
formType
Integer
customJs
String
introText
String
confirmationMessage
String
sections
Section
formHistories
FormHistoy
formStatus
Integer
modifiedByUser
String
formName
String

ProjectPurchaseOrder Up

id
Integer
account
Account
globalList
GlobalList
purchaseOrder
PurchaseOrder
project
Project
createdBy
Integer
createdOn
date format: date
sortOrder
Integer
endDate
date format: date

PurchaseOrder Up

id
Integer
account
Account
client
Client
user
User
createdBy
Integer
createdOn
date format: date
modifiedBy
Integer
modifiedOn
date format: date
poNumber
String
state
String
validFromDate
date format: date
validToDate
date format: date
amount
BigDecimal
billingContact
String
clientSponsor
String
description
String
amountIncurred
BigDecimal
projectPurchaseOrder
ProjectPurchaseOrder

PurchaseOrderChargeHistory Up

objectId
Integer
date
Date format: date
chargeType
GlobalList
description
String
expenseType
ExpenseFieldOptions
resource
User
project
Project
amount
BigDecimal
status
GlobalList

ProjectSecurity Up

id
Integer
user
User
project
Project
usergroup
UserGroup
createdBy
Integer
createdOn
date format: date
modifiedBy
Integer
modifiedOn
date format: date
security
Integer

ProjectSummary Up

projectId
Integer
project
Project
createdBy
Integer
createdOn
date format: date
modifiedBy
Integer
modifiedOn
date format: date
numTasks
Integer
numTasksOverdue
Integer
numTasksBlocking
Integer
numTasksBlocked
Integer
numApprovalsOverdue
Integer
onBudget
Integer
isBlocked
Integer
numReviews
Integer
budgetTotal
Double format: double
actualTotal
Double format: double
isOnSchedule
Integer
numTasksCompleted
Integer
numTasksInProgress
Integer
numTasksNotStarted
Integer
totalActualHours
Integer
totalEstimatedHours
Integer
minStartDateInProject
date format: date
maxDueDateInProject
date format: date
totalActualTime
Integer
totalEstimatedTime
Integer

RateCard Up

id
Integer
account
Account
client
Client
createdBy
Integer
createdOn
date
modifiedBy
Integer
modifiedOn
date
state
Integer
title
String
description
String
sortOrder
Integer

Report Up

id
Integer
user
User
fieldByGroupByFieldId
Field
globalList
GlobalList
fieldBySortByFieldId
Field
createdBy
Integer
createdOn
date format: date
modifiedBy
Integer
modifiedOn
date format: date
reportName
String
description
String
state
Integer
criteria
String
scheduledFlag
Integer
frequency
Integer
days
String
startTime
Double format: double
recipient
String
emailSubject
String
emailMessage
String
objectState
Integer
reportFormat
Integer
reportColumns
ReportColumn
reportConditions
ReportCondition
totalFieldIds
String comma seperated Id's
standardFieldIds
String comma seperated Id's
customFieldExists
String
parentFieldExists
String
customFieldCount
Integer
dashboardMetricReport
String
dashboardMetricReportType
String
sortByField
String
sortDirection
String
moneyFieldIds
String comma seperated Id's
childObjectState
Integer Applicable for Review and Approval Report(Active:1,Archive:2,Both:3)

ReportColumn Up

id
Integer
field
Field
report
Report
createdBy
Integer
createdOn
date format: date
modifiedBy
Integer
modifiedOn
date format: date
totalFlag
Integer
sortOrder
Integer

ReportCondition Up

id
Integer
field
Field
globalList
GlobalList
report
Report
createdBy
Integer
createdOn
date format: date
modifiedBy
Integer
modifiedOn
date format: date
value
String

ResourceUtilizationInfoMap Up

allocatedPercentage
Double format: double
weekdate
date format: date

ResourceUtilizationMap Up

accountHolidays
AccountHoliday
intervalDateDetails
IntervalDateDetail
userResourceUtilizationList
UserResourceUtilizationList

Result Up

returnCode
Integer Return Code will be 0 in case of request success, or 1 in case of request failure
messageKey
String Sepecific message key.
detailedMessage
String Detail message.
exception
String Will give exception details in case of request failure
customParams
Object Will return map of custom parameters in case of request success. The parameters will vary with the call. Igrnore if not applicable.
browser
String Browser deatils.
sessionId
String Session Id.
errorMessages
Object Provides map of error messages in case of failure.
success
Boolean Value will be true in case of request success or will be false in case of request failure.

Review Up

id
Integer
project
Project
createdBy
Integer
createdOn
date format: date
modifiedBy
Integer
modifiedOn
date format: date
state
Integer
reviewName
String
reviewTypeId
Integer
statusId
Integer
downloadFlag
Integer
startDate
date format: date
endDate
date format: date
emailSubject
String
emailMessage
String
showResponsesToAllReviewers
Integer
progress
Integer
notifyCommentAuthorOnReply
Integer
notifyMeOnResponseSubmission
Integer
reviewItems
ReviewItem
reviewSummary
ReviewSummary
reviewComments
ReviewComment
reviewOwners
ReviewOwner
reviewAnnotationViewers
ReviewAnnotationViewer
reviewUsers
ReviewUser
leaf
Boolean
objectType
Integer
reviewSecurity
Integer
campaignSecurity
Integer
statusString
String
reviewTypeString
String
progressString
String
creatorDisplayName
String
modifierDisplayName
String
approvalsString
String
approvalsWithChangesString
String
rejectionsString
String
pendingsString
String
tag
Tag

ReviewAnnotationViewer Up

id
Integer
user
User
reviewMultipage
ReviewMultipage
review
Review
reviewVersion
ReviewVersion
lastReadTimestamp
date format: date

ReviewComment Up

id
Integer
reviewVersion
ReviewVersion
user
User
stamp
Stamp
reviewMultipage
ReviewMultipage
reviewComment
ReviewComment
review
Review
createdBy
Integer
createdOn
date format: date
modifiedBy
Integer
modifiedOn
date format: date
commentPath
String
markupTypeId
Integer
markupPosition
String
videoTimestamp
date format: date
commentNumber
Integer
comments
String
approvalType
Integer
statusId
Integer
lastReplyDate
date format: date
reviewVersionStatuses
ReviewVersionStatus
reviewComments
ReviewComment
additionalAttributes
String

ReviewGroupUser Up

id
Integer
user
User
reviewUsergroup
ReviewUsergroup
createdBy
Integer
createdOn
date format: date
modifiedBy
Integer
modifiedOn
date format: date

ReviewItem Up

id
Integer
review
Review
createdBy
Integer
createdOn
date format: date
modifiedBy
Integer
modifiedOn
date format: date
defaultThumbnailFlag
Integer
optionalTitle
String
sortOrder
Integer
reviewVersions
ReviewVersion
numOfMultipages
Integer

ReviewMultipage Up

id
Integer
reviewVersion
ReviewVersion
createdBy
Integer
createdOn
date format: date
modifiedBy
Integer
modifiedOn
date format: date
pageNumber
Integer
fileName
String
height
Integer
width
Integer
size
Long format: int64
pageUrl
String
reviewComments
ReviewComment
reviewAnnotationViewers
ReviewAnnotationViewer

ReviewOwner Up

id
Integer
user
User
review
Review
createdBy
Integer
createdOn
date format: date
modifiedBy
Integer
modifiedOn
date format: date

ReviewSummary Up

reviewId
Integer
review
Review
createdBy
Integer
createdOn
date format: date
modifiedBy
Integer
modifiedOn
date format: date
numVersions
Integer
isOverdue
Integer
isOpen
Integer
numApprovals
Integer
numApprovalsWithChanges
Integer
numRejections
Integer
numPending
Integer
numReviewers
Integer
numComments
Integer
numFiles
Integer
numCommentsNotStarted
Integer
numCommentsInProgress
Integer
numCommentsCompleted
Integer

ReviewUser Up

id
Integer
user
User
review
Review
createdBy
Integer
createdOn
date format: date
modifiedBy
Integer
modifiedOn
date format: date
statusId
Integer
state
Integer
reviewVersionStatuses
ReviewVersionStatus
statusString
String
versionFileName
String
recentActivity
String
numOfComments
Integer
lastCommentDate
date format: date

ReviewUsergroup Up

id
Integer
account
Account
client
Client
createdBy
Integer
createdOn
date format: date
modifiedBy
Integer
modifiedOn
date format: date
state
Integer
reviewUsergroupName
String
description
String
reviewGroupUsers
ReviewGroupUser
users
User
createdByUser
String
modifiedByUser
String

ReviewVersion Up

id
Integer
version
Integer
reviewItem
ReviewItem
file
File
createdBy
Integer
createdOn
date format: date
modifiedBy
Integer
modifiedOn
date format: date
enableAnnotation
Integer
annotateEntireWebsiteFlag
Integer
multipageStatus
Integer
uploadType
Integer
description
String
reviewMultipages
ReviewMultipage
reviewComments
ReviewComment
reviewAnnotationViewers
ReviewAnnotationViewer
reviewVersionStatuses
ReviewVersionStatus
approvalsString
String
approvalsWithChangesString
String
rejectionsString
String
pendingsString
String
numOfComments
Integer
numOfUnreadComments
Integer
isUnreadForUser
Boolean
creatorDisplayName
String
hasResponseAssociated
Boolean

ReviewVersionStatus Up

id
Integer
reviewUser
ReviewUser
reviewVersion
ReviewVersion
reviewComment
ReviewComment
createdBy
Integer
createdOn
date format: date
modifiedBy
Integer
modifiedOn
date format: date
statusId
Integer

ReviewerCommentDetail Up

userImageUrl
String
userDisplayName
String
numOfComments
Integer
lastCommentDate
date format: date

Role Up

id
Integer
createdBy
Integer
createdOn
date format: date
modifiedBy
Integer
modifiedOn
date format: date
name
String
description
String
announcementRoles
AnnouncementRole
users
User
permissions
Permission
sortOrder
Integer

Rule Up

id
Integer
formHistory
FormHistory
createdBy
Integer
createdOn
date format: date
modifiedBy
Integer
modifiedOn
date format: date
name
String
state
Integer
sortOrder
Integer
jsonText
String
ruleConditions
RuleCondition
ruleActions
RuleAction

RuleAction Up

id
Integer
field
Field
rule
Rule
section
Section
createdBy
Integer
createdOn
date format: date
modifiedBy
Integer
modifiedOn
date format: date
actionType
Integer
hiddenFlag
Integer
emailAddressList
String
emailSubject
String
message
String
sendTeamEmail
String
valueToSet
String

RuleCondition Up

id
Integer
field
Field
globalList
GlobalList
rule
Rule
createdBy
Integer
createdOn
date format: date
modifiedBy
Integer
modifiedOn
date format: date
value
String

RunReport Up

fieldId
String fieldValue
id
Integer
objectState
Integer
objectSecurity
Integer

Section Up

id
Integer
form
Form
createdBy
Integer
createdOn
date format: date
modifiedBy
Integer
modifiedOn
date format: date
state
Integer
name
String
description
String
helpText
String
templateFlag
Integer
hiddenFlag
Integer
displayOrder
Integer
ruleActions
RuleAction
sectionFields
SectionField

SectionField Up

id
Integer
field
Field
section
Section
createdBy
Integer
createdOn
date format: date
modifiedBy
Integer
modifiedOn
date format: date
state
Integer
displayOrder
Integer
requiredFlag
Integer
hiddenFlag
Integer
helpText
String
fieldLabel
String
state
Integer
maxLength
Integer
fieldSize
Integer
defaultValue
String

Series Up

seriesId
Integer
name
String
coordinates
Coordinate

Stamp Up

id
Integer
account
Account
createdBy
Integer
createdOn
date format: date
modifiedBy
Integer
modifiedOn
date format: date
state
Integer
labelText
String
labelColor
String
labelBackgroundColor
String
sortOrder
Integer

SummaryField Up

id
Integer
field
Field
account
Account
formType
Integer
selectedFlag
Integer
sortOrder
Integer

Tag Up

account
Account
id
Integer
user
User
createdBy
Integer
createdOn
date format: date
modifiedBy
Integer
modifiedOn
date format: date
state
Integer
name
String
tagValues
TagValue

TagValue Up

id
Integer
tag
Tag
createdBy
Integer
createdOn
date format: date
modifiedBy
Integer
modifiedOn
date format: date
objectId
Integer
objectType
Integer

Task Up

id
Integer
globalList
GlobalList
project
Project
createdBy
Integer
createdOn
date format: date
modifiedBy
Integer
modifiedOn
date format: date
state
Integer
name
String
description
String
estimatedHours
Integer
actualHours
Integer
startDate
date format: date
startTime
Double format: double
dueDate
date format: date
dueTime
Double format: double
actualStartDate
date format: date
actualEndDate
date format: date
originalStartDate
date format: date
originalDueDate
date format: date
skipWeekendsFlag
Integer
skipHolidaysFlag
Integer
taskOrderId
String
taskSummary
TaskSummary
timeslips
Timeslip
taskPriorities
TaskPriority
taskPredecessorsForTaskId
TaskPredecessor
taskPredecessorsForTaskPredecessorId
TaskPredecessor
users
User
taskUsers
TaskUser
leaf
Boolean
objectType
Integer
taskSecurity
Integer
actualTime
Double format: double
estimatedTime
Double format: double
taskPredecessorNames
String
modifiedByUser
String
taskRole
TaskRole
tag
Tag
useTaskRate
Integer
taskRate
BigDecimal

TaskDetailsList Up

projectNumber
Integer
taskDescription
String
taskDueDate
date format: date
taskActualHours
Integer
taskStartDate
date format: date
projectStartDate
date format: date
taskName
String
taskEstimatedHours
Integer
projectName
String
projectId
Integer
taskId
Integer
taskStatus
String
taskHoursDetails
TaskHoursDetail

TaskHoursDetail Up

userRoleId
Integer
userName
String
userId
Integer

TaskPredecessor Up

id
Integer
taskByTaskId
Task
taskByTaskPredecessorId
Task
createdBy
Integer
createdOn
date format: date
modifiedBy
Integer
modifiedOn
date format: date

TaskPriority Up

id
Integer
user
User
todo
Todo
task
Task
workType
Integer
sortOrder
Integer

TaskRole Up

id
Integer
account
Account
client
Client
createdBy
Integer
createdOn
date
modifiedBy
Integer
modifiedOn
date
state
Integer
displayValue
String
sortOrder
Integer

TaskSummary Up

taskId
Integer
task
Task
createdBy
Integer
createdOn
date format: date
modifiedBy
Integer
modifiedOn
date format: date
isBlocking
Integer
isBlocked
Integer
isOverdue
Integer
actualLabourExpense
Double format: double
progress
Integer

TaskUser Up

id
Integer
user
User
task
Task
createdBy
Integer
createdOn
date format: date
modifiedBy
Integer
modifiedOn
date format: date

TimeTaskList Up

taskId
Integer
taskName
String
projectName
String
projectNumber
String
isNonProjectTask
Boolean

Timesheet Up

id
Integer
user
User
createdBy
Integer
createdOn
date format: date
modifiedBy
Integer
modifiedOn
date format: date
weekEndDate
date format: date
isTimesheetOpen
Integer
globalList
GlobalList
weekStartDate
date format: date
totalHours
String
overdueAnnouncement
Integer

TimesheetApprovers Up

id
Integer
globalList
GlobalList
userByAlternateApproverId
User
userByApproverId
User
timesheet
Timesheet

TimesheetStatusHistory Up

id
Integer
globalList
GlobalList
user
User
timesheet
Timesheet
performedOn
date format: date
comments
String

Timeslip Up

id
Integer
user
User
task
Task
createdBy
Integer
createdOn
date format: date
modifiedBy
Integer
modifiedOn
date format: date
timeslipDate
date format: date
hours
Integer
isCwSynced
Integer
state
Integer
billRate
BigDecimal
payRate
BigDecimal
billAmount
BigDecimal
payAmount
BigDecimal
burdendPayAmount
BigDecimal
globalList
GlobalList
timesheets
Timesheet
sourceBillRate
Integer
invoiceId
Integer
invoiceNumber
String

TimeslipNonprj Up

id
Integer
user
User
createdBy
Integer
createdOn
date format: date
modifiedBy
Integer
modifiedOn
date format: date
timeslipDate
date format: date
hours
Integer
nonProjectTask
NonProjectTask
globalList
GlobalList
timesheet
Timesheet
billRate
BigDecimal
payRate
BigDecimal
state
Integer
isCwSynced
Integer
billAmount
BigDecimal
payAmount
BigDecimal
burdendPayAmount
BigDecimal
sourceBillRate
Integer
invoiceId
Integer
invoiceNumber
String

Todo Up

id
Integer
user
User
createdBy
Integer
createdOn
date format: date
modifiedBy
Integer
modifiedOn
date format: date
title
String
description
String
markAsComplete
Integer
dueDate
date format: date
taskPriorities
TaskPriority
tag
Tag

UnreadObjectCount Up

2
Integer 2=>objectTypeRequest:value=>unreadRequest
3
Integer 3=>objectTypeProject:value=>unreadProject
6
Integer 6=>objectTypeCampaign:value=>unreadCampaign
9
Integer 9=>objectTypeTask:value=>unreadTask
10
Integer 10=>objectTypeReview:value=>unreadReview

User Up

id
Integer
fileByStandardAvatarFileId
File
account
Account
fileByCustomAvatarFileId
File
role
Role
task
Task
createdBy
Integer
createdOn
date format: date
modifiedBy
Integer
modifiedOn
date format: date
state
Integer
firstName
String
lastName
String
emailAddress
String
password
String
title
String
timezone
String
dateFormat
String
workPhone
String
mobilePhone
String
homePhone
String
defaultReviewEmailMessage
String
pwdModifiedOn
date format: date
lastLogin
date format: date
avatarPosition
String
taskTimerStartTime
date format: date
taskCurrentlyWorkingMinutes
Integer
taskUsers
TaskUser
timeslipNonprjs
TimeslipNonprj
campaignSecurities
CampaignSecurity
timesheets
Timesheet
reviewGroupUsers
ReviewGroupUser
tags
Tag
reports
Report
noteUsers
NoteUser
taskPriorities
TaskPriority
userFavorites
UserFavority
reviewUsers
ReviewUser
changeTrackings
ChangeTracking
dashboardPreferences
DashboardPreference
notificationPreferences
NotificationPreference
reviewComments
ReviewComment
userPermissions
UserPermission
reviewOwners
ReviewOwner
timeslips
Timeslip
fileActivityLogs
FileActivityLog
fileExternalLink
FileExternalLink
groupUsers
GroupUser
reviewAnnotationViewers
ReviewAnnotationViewer
folderSecurities
FolderSecurity
todos
Todo
activityUsers
ActivityUser
projectSecurities
ProjectSecurity
itemLastReads
ItemLastRead
userHolidaies
UserHoliday
announcementUsers
AnnouncementUser
userImageUrl
String
userDisplayName
String
userSummary
UserSummary
userTypeAheadDisplayName
String
displayTimeZone
String
modifiedByUser
String
projectSummaryMetricConfig
Integer
campaignSummaryMetricConfig
Integer
projectSummaryMetricConfigList
String
campaignSummaryMetricConfigList
String
apiKey
String
userClient
UserClient
resourceManager
Integer
cwUser
CwUser
user
User
timesheetApprover
Integer
userByAlternateTimesheetApprover
User
userByAlternateResourceApprover
User
userByResourceManagerId
User

UserClient Up

id
Integer
user
User
client
Client
createdOn
date
createdBy
Integer

UserEmailMap Up

EmailDate
date format: date
From
String
Timestamp
Double format: double
Subject
String
PlainTextMessage
String
To
String
MessageId
Integer

UserFavority Up

id
Integer
user
User
createdBy
Integer
createdOn
date format: date
modifiedBy
Integer
modifiedOn
date format: date
objectId
Integer
objectType
Integer
parentObjectId
Integer
parentObjectType
Integer
sortOrder
Integer
objectName
String
parentObjectName
String

UserGroup Up

id
Integer
account
Account
client
Client
createdBy
Integer
createdOn
date format: date
modifiedBy
Integer
modifiedOn
date format: date
state
Integer
name
String
description
String
users
User
createdByUser
String
modifiedByUser
String

UserHoliday Up

id
Integer
user
User
createdBy
Integer
createdOn
date format: date
modifiedBy
Integer
modifiedOn
date format: date
startDate
date format: date
endDate
date format: date
description
String

UserPermission Up

id
Integer
user
User
permission
Permission
createdBy
Integer
createdOn
date format: date
modifiedBy
Integer
modifiedOn
date format: date

UserResourceUtilizationList Up

userImageUrl
String
userTimeOffDateSet
String
percentUtilization
Double format: double
taskDetailsList
TaskDetailsList

UserSummary Up

numActiveProjects
Integer
numArchivedProjects
Integer
numBlockedProjects
Integer
numOverBudgetProjects
Integer
numBehindScheduleProjects
Integer
numActiveCampaigns
Integer
numArchivedCampaigns
Integer
numBlockedCampaigns
Integer
numOverBudgetCampaigns
Integer
numOpenTasks
Integer
numOverdueTasks
Integer
numBlockingTasks
Integer
numBlockedTasks
Integer
numUpcomingTasks
Integer
numOpenApprovals
Integer
numOverdueApprovals
Integer
numRequestSubmitted
Integer
numRequestApproved
Integer
numRequestDenied
Integer
numRequestUpdateRequired
Integer
numProjectByStatus
Object Map of number of projects for perticular status. The map contains status name as key and number of projects for that status as number.
numOpenFeedbacks
Integer
numOverdueFeedbacks
Integer

UserTaskRole Up

id
Integer
user
User
taskRole
TaskRole
createdBy
Integer
createdOn
date

UserTaskRoleRate Up

id
Integer
user
User
taskRole
TaskRole
createdBy
Integer
createdOn
date
modifiedBy
Integer
modifiedOn
date
rate
BigDecimal
effectiveDate
date

ClientOption Up

id
Integer
fieldOption
FieldOption
client
Client
createdBy
Integer
createdOn
date
sortOrder
Integer

Estimate Up

id
Integer
account
Account
client
Client
project
Project
createdBy
Integer
createdOn
date
modifiedBy
Integer
modifiedOn
date
state
Integer
description
String
assumptions
String
goals
String
approach
String
internalNotes
String
totalTax
BigDecimal
total
BigDecimal
estimateDate
Date
approvalTimestamp
Date
approvedBy
Integer
globalList
GlobalList
approvedOn
Date
approvalCcList
String
approvalComment
String

RateInfo Up

currentUserRate
UserTaskRoleRate
oldUserRateList
UserTaskRoleRate
futureUserRateList
UserTaskRoleRate

MonthlyAccountSummary Up

id
Integer
account
Account
monthOf
date
projectsCreated
Integer
requestsCreated
Integer
tasksCreated
Integer
avgProjectDuration
BigDecimal
avgTaskDuration
BigDecimal
avgProjectDuration
BigDecimal
avgTaskDuration
BigDecimal
avgReqApprovalDuration
BigDecimal
avgProjectStartShift
BigDecimal
avgProjectDueShift
BigDecimal
avgBudgetVariance
BigDecimal
avgActiveDuration
BigDecimal
avgTaskStartShift
BigDecimal
avgTaskDueShift
BigDecimal
avgTaskStartSlip
BigDecimal
avgTaskDueSlip
BigDecimal
avgTaskHoursVariance
BigDecimal

QuarterlyAccountSummary Up

id
Integer
account
Account
quarterOf
date
projectsCreated
Integer
requestsCreated
Integer
tasksCreated
Integer
avgProjectDuration
BigDecimal
avgTaskDuration
BigDecimal
avgProjectDuration
BigDecimal
avgTaskDuration
BigDecimal
avgReqApprovalDuration
BigDecimal
avgProjectStartShift
BigDecimal
avgProjectDueShift
BigDecimal
avgBudgetVariance
BigDecimal
avgActiveDuration
BigDecimal
avgTaskStartShift
BigDecimal
avgTaskDueShift
BigDecimal
avgTaskStartSlip
BigDecimal
avgTaskDueSlip
BigDecimal
avgTaskHoursVariance
BigDecimal

UserCapacity Up

id
Integer
user
User
createdBy
Integer
createdOn
date
modifiedBy
Integer
modifiedOn
date
state
Integer
monday
Integer
tuesday
Integer
wednesday
Integer
thursday
Integer
friday
Integer
saturday
Integer
sunday
Integer

UserTaskRoleAllocation Up

id
Integer
user
User
userTaskRole
UserTaskRole
createdBy
Integer
createdOn
date
modifiedBy
Integer
modifiedOn
date
state
Integer
effectiveDate
date
percentAllocation
Double

UserTaskRoleAllocationHistory Up

weekDate
date
userTaskRoleAllocation
UserTaskRoleAllocation

TaskGroup Up

id
Integer
account
Account
client
Client
createdBy
Integer
createdOn
date
modifiedBy
Integer
modifiedOn
date
state
Integer
value
String
sortOrder
Integer

UserFilter Up

id
Integer
account
Account
createdBy
Integer
createdOn
date
userId
Integer
listType
Integer
objectType
Integer
parentObjectType
Integer
isFavorite
Integer
filterName
String
filterColor
String

Survey Up

id
Integer
account
Account
createdBy
Integer
createdOn
date
modifiedBy
Integer
modifiedOn
date
projectId
Integer
comment
String
urlExpiryTime
Integer
surveyRecipients
SurveyRecipient
surveyResponses
SurveyResponse
surveyFiles
File

SurveyRecipient Up

id
Integer
account
Account
Survey
Survey
surveyResponses
SurveyResponse
userByUserId
User
userByLastSentBy
User
recipientEmail
String
surveyUrl
String
sentStatus
Integer
lastSentOn
date
recipientUserEmail
String

SurveyResponse Up

id
Integer
surveyRecipient
SurveyRecipient
Survey
Survey
createdOn
date
modifiedOn
date
rating
Integer
firstName
String
lastName
String
comment
String

Portfolio Up

id
Integer
account
Account
file
File
title
String
logoFileId
Integer
portfolioSummary
String
displayTeamFlag
Integer
styleAttribute
String
createdBy
Integer
createdOn
date
modifiedBy
Integer
modifiedOn
date
state
Integer
useReviewFileFlag
Integer
readyFlag
Integer
portfolioProjectMetrics
PortfolioProjectMetric
portfolioProjects
PortfolioProject
portfolioSummaryMetrics
PortfolioSummaryMetric
portfolioRecipients
PortfolioRecipient
portfolioProjectFields
PortfolioProjectField

PortfolioProjectMetric Up

id
Integer
portfolio
Portfolio
account
Account
field
Field

PortfolioProject Up

id
Integer
portfolio
Portfolio
account
Account
project
Project
slideFlag
Integer
sortOrder
Integer

PortfolioSummaryMetric Up

id
Integer
portfolio
Portfolio
account
Account
portfolioMetricGlobal
PortfolioMetricGlobal
summaryMetricValue
String

PortfolioMetricGlobal Up

id
Integer
globalList
GlobalList
portfolioSummaryMetrics
PortfolioSummaryMetric

PortfolioRecipient Up

id
Integer
portfolio
Portfolio
account
Account
user
User
recipientEmail
String
state
Integer
status
Integer
expiryType
Integer
scheduledDate
date
expiryDate
date
scheduledTime
BigDecimal
scheduledFlag
Integer
portfolioUrl
String
emailSubject
String
emailMessage
String
sentOn
date
createdOn
date

PortfolioProjectField Up

id
Integer
portfolio
Portfolio
account
Account
field
Field

FinalDeliverableProjectFile Up

id
Integer
project
Project
file
File
finalDeliverableFile
FinalDeliverableFile

FinalDeliverableFile Up

id
Integer
account
Project
project
file
File
processType
Integer
width
Integer
height
Integer

ProjectItem Up

projectId
Integer
projectName
String
formattedProjectNumber
String
objectId
Integer
objectType
Integer
objectName
String
objectStartDate
Date
objectDueDate
Date
campaignId
Integer

ScheduleGanttVO Up

result
Result
mask
Object Column mask map.
columnList
List Output column list
ganttDetails
Object Project Details

UserCalendarResponse Up

review
Review
task
Task
userHoliday
UserHoliday
accountHoliday
AccountHoliday
calendarBarText
String
objectType
Integer

UserGanttDetails Up

id
Integer
user
User
children
Object
startDate
Date
endDate
Date
leaf
Boolean

NoteThread Up

id
Integer
noteByLastThreadNoteId
Note
account
Account
noteByRootNoteId
Note
createdBy
Integer
createdOn
Date
modifiedBy
Integer
modifiedOn
Date
state
Integer
subject
String
objectId
Integer
objectType
Integer
rootObjectId
Integer
rootObjectType
Integer
threadType
Integer
threadNoteCount
Integer
lastNoteUserId
Integer
lastNoteText
String
lastThreadActivityOn
Date

NoteThreadUser Up

id
Integer
user
User
noteThread
NoteThread
account
Account
usergroup
UserGroup
createdBy
Integer
createdOn
Date

ReviewUser Up

id
Integer
user
User
review
Review
reviewStage
ReviewStage
createdBy
Integer
createdOn
date format: date
modifiedBy
Integer
modifiedOn
date format: date
statusId
Integer
state
Integer
reviewVersionStatuses
ReviewVersionStatus

PdfLayerDetail Up

id
Integer
versionId
Integer
fileName
String
url
String
value
String