Overview
When Jobs is selected in Requested Data, the report will return the following details:
|
Field Name |
Data Type |
Information |
|
Job_UID |
Integer (Unsigned) |
The Job ID |
|
Employee_MID |
Integer (Unsigned) |
The Employee ID for the employee assigned the job |
|
NameLast |
String |
The last name of the employee to whom this job belongs |
|
NameFirst |
String |
The first name of the employee to whom this job belongs |
|
NameMiddle |
String |
The middle name of the employee to whom this job belongs |
|
BillingEntity-Company ManagementCompany_CM_CID |
Integer (Unsigned) |
The ID of the billing entity (a CompanyManagementCompany entity) to whom this job belongs |
|
BillingContact_BCID |
Integer (Unsigned) |
The Billing Contact ID for the job |
|
Customer_BID |
Integer (Unsigned) |
The Customer ID linked to the job |
|
Workplace_WID |
Integer |
The Workplace ID linked to the job |
|
WorkplaceName |
String |
The name of the workplace to which the job is assigned If Workplace_WID > 0 then this will match the name of the workplace entity, otherwise it will be a free-text entry |
|
JobStartDate |
Date |
The first date this job is active |
|
JobFinishDate |
Date |
The final date this job is active If blank, there is no end date |
|
TimesheetType |
String |
The timesheet type assigned to this job H = Hourly, D = Daily |
|
PayRate |
Decimal |
The rate at which the employee is paid, as of date of extraction |
|
PayCurrency |
String |
The currency in which the employee is paid |
|
Oncosts |
Decimal |
The prescribed oncosts, as of the date of extraction |
|
ChargeRate |
Decimal |
The rate of which the customer is charged, as of date of extraction |
|
ChargeCurrency |
String |
The currency at which the customer is charged |
|
TimesheetStartingWeekday |
Integer (Unsigned) |
The day of the week on which a timesheet for this job begins 0 = Monday → 6 = Sunday |
|
MasterTimesheet_MTS_id |
Integer (Unsigned) |
The Master Timesheet ID linked to the job If less than or equal to 0 then no master/fixed timesheet is assigned |
|
PrimaryApprover-User_id |
String |
The ID of the user assigned as the primary approver for this job |
|
SecondaryApprover-User_id |
String |
The ID of the user assigned as the secondary approver for this job |
|
Recruiter1-User_id |
String |
The ID of the user assigned as the first recruiter for this job The percentage of the margin that this first recruiter receives is the remainder after all other recruiter margin split percentages are taken into consideration |
|
Recruiter2-User_id |
String |
The ID of the user assigned as the second recruiter for the job |
|
Recruiter2-MarginSplit |
String |
The percentage of the margin split the second recruiter receives |
|
Recruiter3-User_id |
String |
The ID of the user assigned as the third recruiter for the job |
|
Recruiter3-MarginSplit |
String |
The percentage of the margin split the third recruiter receives |
|
Recruiter4-User_id |
String |
The ID of the user assigned as the fourth recruiter for the job |
|
Recruiter4-MarginSplit |
String |
The percentage of the margin split the fourth recruiter receives |
|
Recruiter5-User_id |
String |
The ID of the user assigned as the fifth recruiter for the job |
|
Recruiter5-MarginSplit |
String |
The percentage of the margin split the fifth recruiter receives |
|
DivisionManager-User_UID |
Integer (Unsigned) |
The User ID for the division manager assigned to the job |
|
JobCode |
String |
The remote ID used to access this job through the API |
|
CreationDateTimeUTC |
Date/Time (UTC) |
The date and time the employee was created, in universal time |
Comments
0 comments
Please sign in to leave a comment.