|
| Read | Filterable |
|
|---|---|---|---|---|
AllResourceAccessFlag | boolean |
| X | The flag that determines whether the user has all resource access (TRUE) or restricted resource access (FALSE). Admin Superusers always have all resource access. |
AssignmentStaffingPreference | string |
|
| The value that determines whether the current or the new resource's Units per Time and Overtime factor is used to calculate costs when assigning the resource to an existing activity assignment. If the AssignmentStaffingPreference is set to 'Ask Me', the default value is then current resource. |
CreateDate | dateTime | X | X | The date this user was created. |
CreateUser | string | X | X | The name of the user that created this user. |
CurrencyId | string | X | X | The unique currency abbreviation for the currency associated with this user. |
CurrencyName | string | X | X | The name of the currency associated with this user. |
CurrencyObjectId | int |
| X | The unique ID of the associated currency |
CurrencyShowDecimals | boolean |
|
| The flag which when set to true will show decimal places for the currency, and when set to false will not Display decimal places. Possible values : 'True' or 'False' |
CurrencyShowSymbol | boolean |
|
| The flag which when set to true will show Currency Symbol for the currency, and when set to false will not Display Currency Symbol. Possible values : 'True' or 'False' |
DateFormatType | string |
|
| The date format type for the user: 'Month, Day, Year' , 'Day, Month, Year' or 'Year, Month, Day'. |
DateSeparator | string |
|
| The date Separator for the user: '/' , '-' or '.' |
DateShowFourDigitYear | boolean |
|
| The flag which when set to true will show four digit year for the Date format specified, and when set to false will not show four digit year. Possible values : 'True' or 'False' |
DateShowMinutes | boolean |
|
| The flag which when set to true will show minutes value for the Time format specified, and when set to false will not show minutes value. Possible values : 'True' or 'False' |
DateTimeFormatType | string |
|
| The date format type for the user: '12 hour (1:30 PM)' , '24 hour (13:30)' or 'Do not show time'. |
DateUseLeadingZero | boolean |
|
| The flag which when set to true will show leading zero for the Date format specified, and when set to false will not show leading zero. Possible values : 'True' or 'False' |
DateUseMonthName | boolean |
|
| The flag which when set to true will show month value for the Date format specified, and when set to false will not show month value. Possible values : 'True' or 'False' |
DoNotShowNewFeaturesAgain | boolean |
|
| The flag that, when set to true, will suppress the What's New dialog for the user until the next version change. |
DurationDecimalCount | string |
|
| The Duration Decimal count for the user is the number of decimal places to be displayed for the Duration. : '0','1' or '2'. |
DurationUnitType | string |
|
| The Duration Unit Type for the user is the Display Time units In: 'Hour','Day','Week','Month' or 'Year'. |
DurationUseFraction | boolean |
|
| The flag which when set to true will show units for the Duration, and when set to false will not show units. Possible values : 'True' or 'False' |
EmailAddress | string |
| X | The current user's return email address. This will be used in the "FROM" line for any email sent by this user. Example: "yourname@yourdomain.com". For MAPI users, this may just be the MAPI profile name or mailbox name. |
EmailProtocol | string |
| X | The email type for the user: 'Internet Mail' or 'MAPI Mail'. |
EnableUserToModifyViewSettingsFlag | boolean |
| X | The flag that when set to true allows the user to change his or her personal view settings in P6. When a user changes the user interface view settings, the changes do not affect the settings of other users assigned to the same view. |
FinancialPeriodEndObjectId | int |
|
| The unique ID generated by the system of the last financial period viewable in columns in Project Management. |
FinancialPeriodStartObjectId | int |
|
| The unique ID generated by the system of the first financial period viewable in columns in Project Management. |
GUID | string |
| X | The globally unique ID generated by the system. |
GlobalProfileObjectId | int |
| X | The unique ID of the global security profile assigned to the user. See the GlobalProfile class for constants defining the fixed profiles of Admin Superuser and No Global Privileges. |
LastUpdateDate | dateTime | X | X | The date this user was last updated. |
LastUpdateUser | string | X | X | The name of the user that last updated this user. |
MailServerLoginName | string |
| X | The mail login name (profile name) for the current user to send outgoing email. If the email protocol is MAPI, this field should contain the MAPI profile name (e.g. "Microsoft Mail Settings"). This field is not required for Internet email users. |
Name | string |
| X | The user's login name. |
NewProjectDurationType | string |
|
| the default duration type assigned to new activities. Valid values are 'Fixed Units/Time', 'Fixed Duration and Units/Time', 'Fixed Units', or 'Fixed Duration and Units'. |
ObjectId | int |
| X | The unique ID generated by the system. |
OfficePhone | string |
| X | The work phone number of the user. |
OutgoingMailServer | string |
| X | The outgoing mail server (SMTP) address used to send outgoing email for this user. The address may be a host name or an IP address. This field is used only with the Internet email protocol, and is not required for MAPI. Example: "smtp.yourdomain.com". |
PersonalName | string |
| X | The user's personal or actual name. |
RateSourcePreference | string |
|
| The value that determines which price/unit will be used by default to calculate costs for the assignment when both a resource and role are assigned. If the value is 'Resource', the resource's price/unit will be used. If the value is 'Role', the role's price/unit will be used. If the value is 'Ask me', the default is set to 'Resource'. |
ReportingFlag | boolean |
| X | The flag that determines whether the user can access ODS database as a database user. |
ResourceRequests | See the ResourceRequest table below |
|
| The resource requests used as search templates to search for qualified resources. |
RespectActivityDurationType | boolean |
|
| the setting that indicates whether to recalculate the Duration, Units, or Units/Time for existing assignments based on the activity Duration Type (true) or to preserve the Duration, Units, or Units/Time for existing assignments (false) when adding or removing assignments on activities. |
RoleLimitDisplayOption | string |
|
| The option for how RoleLimit is displayed. This setting corresponds to the setting "Display the role limit based on" on the Resources section of the Global tab of the My Preferences Page. |
ShowDurationTimeUnit | boolean |
|
| The flag which when set to true will show units for the Duration, and when set to false will not show units. Possible values : 'True' or 'False' |
ShowTimeUnit | boolean |
|
| The flag which when set to true will show units for the Time, and when set to false will not show units. Possible values : 'True' or 'False' |
SmallScaleDecimalCount | string |
|
| The Small Scale Decimal count for the user is the number of decimal places to be displayed for the Time. : '0','1' or '2'. |
SmallScaleUnitType | string |
|
| The Small Scale Unit Type for the user is the Display Time units In: 'Hour','Day','Week','Month' or 'Year'. |
SmallScaleUseFraction | boolean |
|
| The flag which when set to true will show sub units for the Time units format specified, and when set to false will not show sub units. Possible values : 'True' or 'False' |
TeamMemberActivityFilters | string |
|
| The Statuser activity filters for the Team Member application. |
TeamMemberActivitySortField | string | x |
| Select whether column name entries are sorted in ascending or descending order. |
TeamMemberActivitySortOrder | string | x |
| From the Sort Order list, you can select to list projects in the scorecard in either ascending (e.g., A to Z) or descending (e.g., Z to A) order. |
TeamMemberApplicationTheme | string |
|
| The user interface theme setting for P6 Team Member Web. |
TeamMemberDateFormat | string |
|
| The date format setting for the P6 Team Member Web. |
TeamMemberDisplayTimeFlag | boolean |
|
| The display hours setting for P6 Team Member Web. |
TeamMemberDisplayTimeFormat | string |
|
| The display hours format setting for P6 Team Member Web. |
TeamMemberLocale | string |
|
| The user-specific locale set for P6 Team Member Web. |
TeamMemberProjectFilter | string |
|
| The project filter for P6 Team Member Web. |
TeamMemberResourceFilter | string | X |
| The user-specific resource filter for P6 Team Member Web. |
TeamMemberDisplayQRQuickAccess | string | X |
| The flag that is used to to determine if a user has seen the QR quick access link in P6 Team Member Web. |
TeamMemberTaskStatusFilter | string |
|
| The task status filter for P6 Team Member Web. |
TeamMemberTimeframeFilter | string |
|
| The time frame filter for P6 Team Member Web. |
TeamMemberWBSFilter | string | X |
| The user-specific wbs filter for P6 Team Member Web. |
TeamMemberWorkUnitType | string |
|
| The work unit type user preference for P6 Team Member Web. |
UnitsPerTimeShowAsPercentage | boolean |
|
| The flag which when set to true will show Units/Time as Percentage, and when set to false will display as Units/Duration. Possible values : 'True' or 'False' |
UserInterfaceViewObjectId | int |
| X | The unique ID of the associated user interface view. |
ResourceRequest Table
FinishDate | dateTime |
|---|---|
MatchAllCriteria | boolean |
Name | string |
RequestedUnits | double |
SequenceNumber | int |
ShowOnlyLaborResources | boolean |
ShowOverallocatedResources | boolean |
SortResultsByAvailability | boolean |
StartDate | dateTime |
UseActivityDates | boolean |
ResourceRequestCriterion |
|