Project
A Project or PX Scheduled Task in the JX system.
The internal ID of the resource or object.
In general, the id
field is the primary key of the object and cannot
be changed or updated.
64BBA147B9AC41D9978062300826C89F
The URI associated with this resource. This is usually a relative URL that can be used to access the resource. Typically it incorporates the Unique ID of the resource.
/api/v1/objects/64BBA147B9AC41D9978062300826C89F
The name of the internal database table associated with this resource.
users
The user-visible label of the database table associated with this object.
codes_pay_types
group_names object[]
A list of Groups (names and IDs) that the object belongs to.
This is a read-only list. To change the Groups that an object belongs to,
use the groups
field.
See GroupFields for additional information about Groups and this field.
The Group ID.
The Group name.
The URI of the Group.
WARNING: this field is planned in a future release but is not yet available.
A list of Group IDs that the object belongs to. See GroupFields for additional information about Groups and this field.
["5088C427E8B64EBEBE1C5B5961DB1902","3553F715A6F54DAB95D0D25B08468195"]
The internal ID of the parent Project. This can only be set when creating a new Project. The parent of an existing Project cannot be changed, except for "PX Task" type projects.
64BBA147B9AC41D9978062300826C89F
The name of the Project.
XYZ Project
A description of the Project.
This is a description of the XYZ Project.
The estimated number of hours for the Project.
100
The percentage of the Project that is complete.
50
The Project Type code of the Project. Should be 1
for a normal Project.
Types 4-12 are used for PX Scheduled Projects.
1
UNUSED FIELD; normally null
null
The internal ID of the User who is the owner of the Project. Note: changes to owners are automatically propagated to all descendants.
64BBA147B9AC41D9978062300826C89F
The internal ID of the User who is the Backup Owner for the Project. Note: changes to owners are automatically propagated to all descendants.
64BBA147B9AC41D9978062300826C89F
UNUSED FIELD; normally 0
0
UNUSED FIELD; normally 0
0
PX Scheduled Projects only: TODO: explain
0
PX Scheduled Projects only: TODO: explain
0
PX Scheduled Projects only: TODO: explain
0
PX Scheduled Projects only: TODO: explain Integer number of days.
0
PX Scheduled Projects only: TODO: explain Number of hours.
0
PX Scheduled Projects only: The scheduled start date of the Project as an epoch timestamp.
1727724343
PX Scheduled Projects only: The scheduled end date of the Project as an epoch timestamp.
1727724343
PX Scheduled Projects only: The scheduled duration of the Project in days.
10
The projected cost of the Project.
1000
The projected return of the Project.
2000
The projected profit of the Project.
1000
The projected return on investment of the Project.
2
If 1
, the Project is awaiting export in Projectlink.
Does not apply to other integrations.
0
If true
, time can be logged against this Project.
true
If true
, expenses can be logged against this Project.
true
If true
, Custom Entry (a.k.a Mileage) entries can be logged against this Project.
true
If true
, Leave Request entries can be logged against this Project.
true
If true
, Holiday entries can be created using this Project.
true
If true
, the Project will propagate the "Project Activity" rates assigned
to this Project to any new Projects created under this Project.
true
If true
, Assignments can be made in "Multiple Assignment" mode using this Project.
true
If true
, Assignments can be made to a "Team" instead of an individual using this Project.
true
If true
, new child Projects will inherit the dependencies of this Project.
true
If true
, the dependencies of this Project will be copied to all descendants.
Note: this field is spelled as descendents
instead of descendants
.
true
dependencies object
A map of Project dependencies; when this Project is selected, only the listed choices in the dependent Entry Columns are available to the user.
The keys in this object should be the table name of the dependent Entry Code,
e.g. codes_pay_types
. The values should be arrays of Entry Code IDs that belong to that table.
These will be the allowed choices when this Project is selected.
The list of available Entry Column tables is here: (TODO: provide link)
property name* string[]
A list of Entry Code IDs that belong to the table specified by the key, e.g. codes_bill_types
.
A list of Change Requests associated with this Project. These are requests from team members to change the estimated hours left for the Project / Task.
If true
, this Project is automatically added to new Groups as they are created.
false
Indicates whether the object is hidden.
See also status
Indicates whether the user is hidden.
Read-only alias for is_hidden
.
The general visibility status of the object;
either Hidden
, Loggable and Reportable
, or Reportable Only
.
This is a write-enabled field if you have the appropriate permissions.
See also status_code
which can be changed in the same way.
Possible values: [Hidden
, Loggable and Reportable
, Reportable Only
]
Loggable and Reportable
The internal code for the status of the object; either:
lr
forLoggable and Reportable
ro
forReportable Only
h
forHidden
Possible values: [lr
, ro
, h
]
lr
custom_fields object
A map of custom fields. The key is the field ID and the value a description of the field.
Important: this will only be included in the response if $keys=custom_fields
or $keys=$extended
was set as a query parameter.
There is also a more compact representation available in most object types, where
each custom field value is a separate key in the main object (not under custom_fields
).
See the CustomFields schema page for more information on these topics.
property name* CustomFieldValue
A specific instance (value) of a Custom field for a particular object.
The unique internal ID of this Custom Field definition (same as id
field)
2DDD372DC4D3422D9E73F6DE936C4265
Datatype of the custom field. The basic types available are:
- STRING - a variable-length string.
- CHAR - a fixed-length string. (The value may be padded with spaces.)
- NUMBER - a floating-point number.
- INTEGER - an integer (whole number).
- TIMESTAMP - a date and time, stored in Unix epoch format.
- DATE - a YYYYMMDD (F8) date.
In addition, most types can be modified with a prefix to indicate
whether they are "select lists" (ENUM
or enumerated) or "multi-select
lists" (M_ENUM
) which can take on multiple values.
Strings may also have a maximum length specified, such as STRING_100
.
["STRING_100","ENUM_STRING_20","M_ENUM_STRING_252","ENUM_INTEGER","NUMBER"]
Description of custom field
Name of custom field
Pay Group
URI of the custom field to get more information about the custom field definition.
/api/v1/custom_fields/E07526A217164D1B94188279A8A0E4D9
Value of the custom field for this object. To update the value, see the note on the CustomFields schema page.
XYZ Pay Group
The internal User ID of the user who created the object.
64BBA147B9AC41D9978062300826C89F
The full name of the user who created the object.
John Doe
creator_properties object
Extended information about the User who
created the object.
This field is only included if the $keys
parameter requests it.
The ID of the user's assigned Expense entry screen configuration.
The ID of the user's assigned time entry screen configuration.
The ID of the user's assigned Custom Entry (a.k.a. Mileage or Travel) entry screen configuration.
UNUSED FIELD This is a legacy field that is no longer used.
The email address of the user.
Note: This is a read-only field. To change the user's email address, you must modify the
users_attribs:users_email
field.
The first name of the user.
Note: read-only; set via the fullname
field.
The unique internal ID of this user. (Same as id
.)
5CD906A3941C463B9CC98F49DBCC25AA
The last name of the user.
Note: read-only; set via the fullname
field.
memorized_sheet_choices object[]
A list of memorized timesheets associated with the user.
These are the choices available to set in the default_memorized_sheet
field.
The internal ID of the memorized timesheet.
The name of the memorized timesheet.
UNUSED FIELD This is a legacy field that is no longer used.
UNUSED FIELD This is a legacy field that is no longer used.
UNUSED FIELD This is a legacy field that is no longer used.
UNUSED FIELD This is a legacy field that is no longer used.
Details about the user's assigned time entry screen configuration.
Details about the user's assigned Custom Entry (a.k.a. Mileage or Travel) entry screen configuration.
Details about the user's assigned Expense entry screen configuration.
The timestamp when the object was created, in Unix epoch format. This is the number of seconds since 1970-01-01T00:00:00Z.
1696021987.01375
The object creation date in the "long date" format defined in the system settings.
Wednesday, March 22, 2023
The object creation date in the "short date" format defined in the system settings.
03/22/2023
The object creation date and time in the "long date" format defined in the system settings.
Wednesday, March 22, 2023 12:18:46 CDT
The object creation date and time in the "short date" format defined in the system settings.
03/22/2023 12:18:46 CDT
The creation timestamp in ISO 8601 format.
2023-03-22T12:18:46-05:00
The internal User ID of the user who most recently modified the object.
64BBA147B9AC41D9978062300826C89F
The full name of the user who most recently modified the object.
John Doe
modifier_properties object
Extended information about the User who
last modified the object.
This field is only included if the $keys
parameter requests it.
The ID of the user's assigned Expense entry screen configuration.
The ID of the user's assigned time entry screen configuration.
The ID of the user's assigned Custom Entry (a.k.a. Mileage or Travel) entry screen configuration.
UNUSED FIELD This is a legacy field that is no longer used.
The email address of the user.
Note: This is a read-only field. To change the user's email address, you must modify the
users_attribs:users_email
field.
The first name of the user.
Note: read-only; set via the fullname
field.
The unique internal ID of this user. (Same as id
.)
5CD906A3941C463B9CC98F49DBCC25AA
The last name of the user.
Note: read-only; set via the fullname
field.
memorized_sheet_choices object[]
A list of memorized timesheets associated with the user.
These are the choices available to set in the default_memorized_sheet
field.
The internal ID of the memorized timesheet.
The name of the memorized timesheet.
UNUSED FIELD This is a legacy field that is no longer used.
UNUSED FIELD This is a legacy field that is no longer used.
UNUSED FIELD This is a legacy field that is no longer used.
UNUSED FIELD This is a legacy field that is no longer used.
Details about the user's assigned time entry screen configuration.
Details about the user's assigned Custom Entry (a.k.a. Mileage or Travel) entry screen configuration.
Details about the user's assigned Expense entry screen configuration.
The timestamp when the object was most recently modified, in Unix epoch format. This is the number of seconds since 1970-01-01T00:00:00Z.
1696021987.01375
The last modification date in the "long date" format defined in the system settings.
Wednesday, March 22, 2023
The last modification date in the "short date" format defined in the system settings.
03/22/2023
The last modification date and time in the "long date" format defined in the system settings.
Wednesday, March 22, 2023 12:18:46 CDT
The last modification date and time in the "short date" format defined in the system settings.
03/22/2023 12:18:46 CDT
The last modification timestamp in ISO 8601 format.
2023-03-22T12:18:46-05:00
{
"id": "64BBA147B9AC41D9978062300826C89F",
"uri": "/api/v1/objects/64BBA147B9AC41D9978062300826C89F",
"tablename": "users",
"table_label": "codes_pay_types",
"group_names": [
{
"id": "5088C427E8B64EBEBE1C5B5961DB1902",
"pname": "Sales"
},
{
"id": "3553F715A6F54DAB95D0D25B08468195",
"pname": "Accounting"
}
],
"groups": [
"5088C427E8B64EBEBE1C5B5961DB1902",
"3553F715A6F54DAB95D0D25B08468195"
],
"id_parent": "64BBA147B9AC41D9978062300826C89F",
"pname": "XYZ Project",
"description": "This is a description of the XYZ Project.",
"hours_estimate": 100,
"percent_complete": 50,
"project_type": 1,
"wbs": null,
"id_owner": "64BBA147B9AC41D9978062300826C89F",
"id_backup": "64BBA147B9AC41D9978062300826C89F",
"rm_type": 0,
"state": 0,
"work_variance": 0,
"start_variance": 0,
"end_variance": 0,
"duration_variance": 0,
"scheduled_work": 0,
"scheduled_start": 1727724343,
"scheduled_end": 1727724343,
"scheduled_duration": 10,
"projected_cost": 1000,
"projected_return": 2000,
"projected_profit": 1000,
"projected_roi": 2,
"awaiting_export": 0,
"allow_time": true,
"allow_expense": true,
"allow_custom": true,
"allow_leave": true,
"allow_holiday": true,
"propagate_pa_rates": true,
"multiple_assns": true,
"agile_team_assns": true,
"dependencies_new_children_inherit": true,
"dependencies_copy_to_descendents": true,
"dependencies": {
"codes_pay_types": [
"PayTypeID1",
"PayTypeID2"
],
"codes_bill_types": [
"BillTypeID1",
"BillTypeID2"
]
},
"change_requests": [
null
],
"autoadd": false,
"is_hidden": true,
"hidden": true,
"status": "Loggable and Reportable",
"status_code": "lr",
"custom_fields": {
"C41B2DDA662F4EF6B730F9CB6DB04696": {
"attr_type": "ENUM_STRING_252",
"description": "Employee pay group.",
"id_attr_type": "C41B2DDA662F4EF6B730F9CB6DB04696",
"id_attr_type_uri": "/api/v1/custom_fields/C41B2DDA662F4EF6B730F9CB6DB04696",
"pname": "Pay Group",
"value": "XYZ Pay Group"
},
"users_email": {
"attr_type": "STRING_252",
"description": "Email address",
"id_attr_type": "users_email",
"id_attr_type_uri": "/api/v1/custom_fields/users_email",
"pname": "Email Address",
"value": "username@example.com"
}
},
"creator": "64BBA147B9AC41D9978062300826C89F",
"creator_fullname": "John Doe",
"creator_properties": {
"expense_gui": "string",
"time_gui": "string",
"travel_gui": "string",
"daysinlist": 0,
"email": "string",
"first_name": "string",
"id_user": "5CD906A3941C463B9CC98F49DBCC25AA",
"last_name": "string",
"memorized_sheet_choices": [
{
"value": "string",
"text": "string"
}
],
"reserved1": "string",
"reserved2": 0,
"reserved3": 0,
"timerecs_out": 0,
"time_gui_properties": {},
"travel_gui_properties": {},
"expense_gui_properties": {}
},
"create_timestamp": 1696021987.01375,
"create_timestamp_date_long": "Wednesday, March 22, 2023",
"create_timestamp_date_short": "03/22/2023",
"create_timestamp_datetime_long": "Wednesday, March 22, 2023 12:18:46 CDT",
"create_timestamp_datetime_short": "03/22/2023 12:18:46 CDT",
"create_timestamp_iso": "2023-03-22T12:18:46-05:00",
"modifier": "64BBA147B9AC41D9978062300826C89F",
"modifier_fullname": "John Doe",
"modifier_properties": {
"expense_gui": "string",
"time_gui": "string",
"travel_gui": "string",
"daysinlist": 0,
"email": "string",
"first_name": "string",
"id_user": "5CD906A3941C463B9CC98F49DBCC25AA",
"last_name": "string",
"memorized_sheet_choices": [
{
"value": "string",
"text": "string"
}
],
"reserved1": "string",
"reserved2": 0,
"reserved3": 0,
"timerecs_out": 0,
"time_gui_properties": {},
"travel_gui_properties": {},
"expense_gui_properties": {}
},
"modify_timestamp": 1696021987.01375,
"modify_timestamp_date_long": "Wednesday, March 22, 2023",
"modify_timestamp_date_short": "03/22/2023",
"modify_timestamp_datetime_long": "Wednesday, March 22, 2023 12:18:46 CDT",
"modify_timestamp_datetime_short": "03/22/2023 12:18:46 CDT",
"modify_timestamp_iso": "2023-03-22T12:18:46-05:00"
}