API Specification
| Description | Creates a task for Work Manager to execute export Engine for Agent Vacation Summary exporter. |
| Authentication
Required |
yes |
| URL | https://<domain or IP>/SMARTSync/services/rs/exporters/v1/agent-vacation-summary |
| Method | POST |
| Request Headers |
Cookie: JSESSIONID={jsessionId} Content-Type: application/json |
| Request Params | (See below) |
API Specification: Request Params
|
startDate - String, format: YYYY-MM-YY Required: true. Notes: cannot be after the endDate |
|
endDate - String, format: YYYY-MM-YY Required: true. Notes: cannot be before the startDate |
|
outputFormat - String, supported formats: PIPE ,XML, JSON Required: true. Notes: is not case sensitive |
|
dateFormat - String, possible values: mmddyy, ddmmyy, mmddyyyy, ddmmyyyy, yyyymmdd, yyyyddmm, yyddmm, yymmdd. If dateformat is not provided and outputFormat is set to JSON then all date fields will be converted into ISO date format. Required: Only for PIPE outputFormat. Notes: is not case sensitive. Determines format of output dates. |
|
timeFormat - String, possible values: 12, 24. Determines format of output times. Required: for PIPE, JSON outputFormat. |
|
timeOffGroupList - array of complex Objects. Consists of timeOffGroup (Integer) and timeOffRules (array of Strings) Required: only 1 of the fields is supported (either timeOffGroupList or allTimeOffGroups). Notes: is not case sensitive |
|
allTimeOffGroups - complex object with one optional property includeAllTimeOffRules with type boolean (If not present in this object then it's set to false). includeAllTimeOffRules specifies when running the Agent Vacation Summary exporter with the all child, the export includes Time Off Rules with a date range that overlap the start/end date selected. Required: only 1 of the fields is supported (either timeOffGroupList or allTimeOffGroups). Notes: is not case sensitive. |
|
keepEmptyJsonFields - boolean field. Required: false. Notes: This field can be set only if outputFormat is set to JSON. By default it is false. If set to true then JSON output will contain empty values ({},[],"") for fields. |
|
excludePipeHeader - boolean field. Required: false. Notes: This field can be set only if outputFormat is PIPE. By default it is false. If set to true then PIPE output will contain header and sort in results output. |
|
fields - array of Objects. Only supported for outputFormat as JSON or PIPE. Represents the list of the supported field names, fields with specified value. All field names and values are not case sensitive. Required: false. Possible values: Simple fields when outputFormat is PIPE: {"name": "custID"}, {"name": "muID"}, {"name": "tvID"}, {"name": "acdID"}, {"name": "logonID"}, {"name": "ssn"}, {"name": "agentName"}, {"name": "vacGroup"}, {"name": "vacYear"}, {"name": "vacType"}, {"name": "modify"}, {"name": "from"}, {"name": "to"}, {"name": "earned"}, {"name": "debited"}, {"name": "coFrom"}, {"name": "coTo"}, {"name": "selected"}, {"name": "taken"}, {"name": "credited"}, {"name": "minFullWeeks"}, {"name": "maxPartialHours"}, {"name": "externalID"} Simple fields when outputFormat is JSON: {"name":"custID"}, {"name":"muID"}, {"name":"tvID"}, {"name":"acdID"}, {"name":"logonID"}, {"name":"personalId"}, {"name":"agentName"}, {"name":"timeOffGroup"}, {"name":"timeOffRule"}, {"name":"earningsType"}, {"name":"modify"}, {"name":"from"}, {"name":"to"}, {"name":"earned"}, {"name":"debited"}, {"name":"coFrom"}, {"name":"coTo"}, {"name":"selected"}, {"name":"taken"}, {"name":"credited"}, {"name":"minFullWeeks"}, {"name":"maxPartialHours"}, {"name":"externalID"} Note:
Field with multi value: {"name":"agentData","value":"value1"}, {"name":"agentData","value":"value2"} Note: agentData value should exists in DB. |
|
sortOrder - array of Objects. Only supported for outputFormat as JSON or PIPE. Represents the list of the supported field names, fields with specified value. All field names and values are not case sensitive. Required: false. Possible values: the same values as for fields. |
API Specification (cont)
| Response
Data |
Response has a unique JobId: jobId is a 32 length string Example {
"jobId": "9b2fe7bb8362429fb85a16c9373cf50c"
}
|
| Response
Headers |
Content-Type: application/json |
| Success
Response |
Code: 200 OK Content : [Response Data] |
| Error
Response |
Code: 401 Unauthorized Error message: {
"message": "Unauthorized",
"status": 401
}
Code: 400 Bad Request
All fields are invalid:
{
"message": "One or more request validations failed",
"status": 400,
"details": [
"Invalid outputFormat value: 'pipe'",
"Invalid dateFormat value: 'wrongDateFormat'",
"Invalid timeFormat value: 'wrongTimeFormat'",
"startDate must match the provided yyyy-MM-dd format",
"endDate must match the provided yyyy-MM-dd format",
"Invalid recordType value: 'wrongRecordType'",
"Invalid values within fields element: wrongField",
"Invalid agentData value within fields element: wrongAgentData",
"Invalid id attribute value within fields: 'wrong'",
"Invalid values within sortOrder element: wrongField",
"Invalid entity: 'TimeOffGroup 1001'",
"Insufficient permissions to view entities 'TimeOffGroup 1001'",
"Invalid entity: 'TimeOffRule Test Rule1'",
"For Time Off Group [501], Time Off Rule [501_SB_DAYS_Rule] is configured to use "Days" Calculation Unit, which is not supported. Only "HH:MM" Calculation Unit is supported.",
"Invalid agentData value within sortOrder element: wrongAgentData"
]
}
Start date>end date
{
"message": "One or more request validations failed",
"status": 400,
"details": [
"endDate must be either equal to or after the startDate"
]
}
Code: 500 Internal server error
|
| Sample Call for XML outputFormat |
https://localhost/SMARTSync/services/rs/exporters/v1/agent-vacation-summary request body(request for all fields and 1 TimeOffGroup and TimeOffRule): {
"outputFormat": "XML",
"dateFormat": "DDMMYYYY",
"timeFormat": "12",
"startDate": "2020-01-01",
"endDate": "2023-03-01",
"timeOffGroupList": [
{"timeOffGroup": 505,
"timeOffRules": [
"Y_TOR"
]
}
]
}
|
| Sample Call for JSON outputFormat |
https://localhost/SMARTSync/services/rs/exporters/v1/agent-vacation-summary request body(request for all fields and 1 TimeOffGroup and TimeOffRule with keeping empty json fields): {
"outputFormat": "JSON",
"dateFormat": "DDMMYYYY",
"timeFormat": "12",
"startDate": "2020-01-01",
"endDate": "2023-03-01",
"keepEmptyJsonFields": true,
"timeOffGroupList": [
{"timeOffGroup": 505,
"timeOffRules": [
"Y_TOR"
]
}
]
}
request body(request for all fields and ALL TimeOffGroups with their corresponding TimeOffRules):
{
"outputFormat": "JSON",
"dateFormat": "DDMMYYYY",
"timeFormat": "12",
"startDate": "2020-01-01",
"endDate": "2023-03-01",
"allTimeOffGroups": {
"includeAllTimeOffRules": true
}
}
|
|
request body(request for specific fields and 1 TimeOffGroup and TimeOffRule):
{
"outputFormat": "JSON",
"dateFormat": "DDMMYYYY",
"timeFormat": "12",
"startDate": "2020-01-01",
"endDate": "2023-03-01",
"keepEmptyJsonFields": true,
"timeOffGroupList": [
{"timeOffGroup": 505,
"timeOffRules": [
"Y_TOR"
]
}
],
"fields":[{"name":"custID"}, {"name":"muID"}, {"name":"tvID"}, {"name":"acdID"}, {"name":"logonID"}, {"name":"personalId"}, {"name":"agentName"}, {"name":"timeOffGroup"}, {"name":"timeOffRule"}, {"name":"earningsType"}, {"name":"modify"}, {"name":"from"}, {"name":"to"}, {"name":"earned"}, {"name":"debited"}, {"name":"coFrom"}, {"name":"coTo"}, {"name":"selected"}, {"name":"taken"}, {"name":"credited"}, {"name":"minFullWeeks"}, {"name":"maxPartialHours"}, {"name":"externalID"}, {"name":"agentData","value":"Supervisor"}],
"sortOrder":[{"name":"custID"}, {"name":"muID"}, {"name":"tvID"}, {"name":"acdID"}, {"name":"logonID"}, {"name":"personalId"}, {"name":"agentName"}, {"name":"timeOffGroup"}, {"name":"timeOffRule"}, {"name":"earningsType"}, {"name":"modify"}, {"name":"from"}, {"name":"to"}, {"name":"earned"}, {"name":"debited"}, {"name":"coFrom"}, {"name":"coTo"}, {"name":"selected"}, {"name":"taken"}, {"name":"credited"}, {"name":"minFullWeeks"}, {"name":"maxPartialHours"}, {"name":"externalID"}, {"name":"agentData","value":"Supervisor"}]
}
|
|
| Sample Call for PIPE outputFormat | https://localhost/SMARTSync/services/rs/exporters/v1/agent-vacation-summary request body(request for all fields and 1 TimeOffGroup and TimeOffRule with keeping pipe headers): {
"outputFormat": "PIPE",
"dateFormat": "DDMMYYYY",
"timeFormat": "12",
"startDate": "2020-01-01",
"endDate": "2023-03-01",
"excludePipeHeader": false,
"timeOffGroupList": [
{"timeOffGroup": 505,
"timeOffRules": [
"Y_TOR"
]
}
]
}
request body(request for all fields and ALL TimeOffGroups with their corresponding TimeOffRules):
{
"outputFormat": "PIPE",
"dateFormat": "DDMMYYYY",
"timeFormat": "12",
"startDate": "2020-01-01",
"endDate": "2023-03-01",
"allTimeOffGroups": {
"includeAllTimeOffRules": true
}
}
|
|
request body(request for specific fields and 1 TimeOffGroup and TimeOffRule):
{
"outputFormat": "PIPE",
"dateFormat": "DDMMYYYY",
"timeFormat": "12",
"startDate": "2020-01-01",
"endDate": "2023-03-01",
"timeOffGroupList": [
{"timeOffGroup": 505,
"timeOffRules": [
"Y_TOR"
]
}
],
"fields":[{"name":"custID"}, {"name":"muID"}, {"name":"tvID"}, {"name":"acdID"}, {"name":"logonID"}, {"name":"ssn"}, {"name":"agentName"}, {"name":"vacGroup"}, {"name":"vacYear"}, {"name":"vacType"}, {"name":"modify"}, {"name":"from"}, {"name":"to"}, {"name":"earned"}, {"name":"debited"}, {"name":"coFrom"}, {"name":"coTo"}, {"name":"selected"}, {"name":"taken"}, {"name":"credited"}, {"name":"minFullWeeks"}, {"name":"maxPartialHours"}, {"name":"externalID"}, {"name":"agentData","value":"Supervisor"}],
"sortOrder":[{"name":"custID"}, {"name":"muID"}, {"name":"tvID"}, {"name":"acdID"}, {"name":"logonID"}, {"name":"ssn"}, {"name":"agentName"}, {"name":"vacGroup"}, {"name":"vacYear"}, {"name":"vacType"}, {"name":"modify"}, {"name":"from"}, {"name":"to"}, {"name":"earned"}, {"name":"debited"}, {"name":"coFrom"}, {"name":"coTo"}, {"name":"selected"}, {"name":"taken"}, {"name":"credited"}, {"name":"minFullWeeks"}, {"name":"maxPartialHours"}, {"name":"externalID"}, {"name":"agentData","value":"Supervisor"}
}
|
Output Field Descriptions
-
This export runs for each time off group and time off rule specified in the timeOffGroupList array.
-
If the export runs for multiple time off groups, all the data is saved in the same output file.
-
For each time off group and time off rule the export runs, data is exported for each agent with at least one record in the Time Off Summary table for that time off group and time off rule.
-
Note: Even if an agent belongs to the time off group for the year being exported, the agent is not included for that year if no time off summary records exist.
-
Data is exported for the Wait List earnings type as it is for all other earnings types.
-
Agent data group values assigned to the agent for the date being processed are exported. Agent data group values are stored by date range and are not dependent on the agent’s MU assignment.
-
If more than one time off code is associated with the same earnings type, the code-level details are not visible in this export.
-
Vacation is named Time Off in the application.
The Agent Vacation Summary output can include these fields if the XML outputFormat value is not specified:
|
Field |
Description |
Values |
|---|---|---|
|
custID |
The customer ID. |
|
|
muID |
The ID of the MU to which the agent is assigned in his or her latest AgentMap record. |
|
|
tvID |
The agent’s WFM ID. |
|
|
acdID |
The ID of the agent’s highest-priority ACD according to the agent’s latest Agent ACD definition record. The highest-priority ACD is the one with the lowest priority number. |
|
|
logonID |
The agent’s highest-priority ACD logon ID. The highest-priority ACD is the one with the lowest priority number. |
It is possible for this field to be blank. |
|
ssn |
The agent’s personal ID number. For JSON output, personalId is used instead
|
This field is blank if no personal ID number is assigned to the agent. |
|
agentData |
This multi-value field exports the value(s) assigned to the agent for each agent data group specified in the "value" attribute of the agentData field. You can include as many agentData elements as you want; one agent data group is printed in the output file for each agentData value defined. You can specify the same agent data group more than once. If you do not include an agentData element, this field is omitted. |
This field may be blank if the agent is not assigned a value for the specified agent data group for the date being processed. |
|
agentName |
The agent’s name, formatted as <last>, <first><suffix>. |
|
|
vacGroup |
The ID of the time off group for which the export is being run. |
|
|
vacYear |
The time off rule for which data are being exported. Note: This must be a time off rule with a calculation unit of HH:MM. This export does not support time off rules with a calculation unit of Days. |
|
|
vacType |
The earnings type. The earnings type name is printed in this field. Each earnings type for which the agent has Vacation Summary data for the time off rule is included, each in a separate record. Note: Vacation Summary records whose code is -1 represent the Wait List earnings type. |
|
|
modify |
The record’s modify timestamp. |
|
|
from |
The earliest date for which the agent may select an activity code; this is the earliest From Date for all the codes associated with the same earnings type. |
|
|
to |
The latest date for which the agent may select an activity code; this is the latest To Date for all codes associated with the same earnings type. |
|
|
earned |
The amount of time, in minutes, the agent has earned for the earnings type in the time off rule. |
|
|
debited |
The amount of time, in minutes, debited for the earnings type. |
|
|
coFrom |
The amount of time, in minutes, the agent carried over from the previous year for the earnings type. |
|
|
coTo |
The amount of time, in minutes, the agent carried over into the next year for the earnings type. |
|
|
selected |
The amount of time, in minutes, the agent has selected for the earnings type within the time off rule. Only the vacation selections made for dates on and after the time off rule’s Master From Date are included. If the Master From date is the same as or later than the time off rule's end date, the system considers the rule to be closed out and all days are taken values, including the time off rule’s end date. In this case, the selected time is zero for all days. The export's startDate and endDate parameters are not used for calculating this value. Vacation selections are stored in the Future Activities table. Only records that exist for the time off rule being exported are included in the selected value. This value is the sum of the selected time for all the codes associated with the same earnings type. |
|
|
taken |
The amount of time, in minutes, the agent has taken for the earnings type within the time off rule. This value is not stored in the database. It is the sum of the time on agent schedules for dates that fall before the Master From date for all the codes associated with the same earnings type. If the Master From date is the same as or later than the time off rule's end date, the system considers the rule to be closed out and all days are taken values, including the time off rule’s end date. In this case, the selected time is zero for all days. The export's startDate and endDate parameters are not used for calculating this value. |
|
|
credited |
The amount of time, in minutes, added to the agent’s earned amount. |
|
|
minFullWeeks |
The number of weeks the agent must take in full week increments. |
|
|
maxPartialHours |
The maximum amount of time, in minutes, the agent is allowed to take in partial day increments. |
|
|
externalID |
The ID the agent uses to log in to the Agent WebStation if the WebStation is configured to use external IDs. |
If the agent's externalID field is blank, this field is blank. |
XML Output Option for Agent Vacation Summary
If XML is selected in the outputFormat parameter:
-
the output will follow the DTD below.
-
all of the fields listed in the DTD are included.
-
all of an agent’s time off summary records for a time off group and time off rule are grouped together and included in one agentVacation element.
-
the agentID element is the agent’s WFM agent ID.
-
all other fields contain the same values as specified above.
<?xml version="1.0"?>
<!ELEMENT agentVacationSummary (agentVacation+)>
<!ELEMENT agentVacation (agent, vacation+)>
<!ELEMENT agent (agentID, vacGroup, vacYear)>
<!ELEMENT vacation (from?, to?, earned?, credited?, debited?, selected?, taken?, minFullWeeks?, maxPartialHours?, coFrom?, coTo?)>
<!ELEMENT agentID #PCDATA>
<!ELEMENT vacGroup #PCDATA>
<!ELEMENT vacYear #PCDATA>
<!ELEMENT from (day, month, year)>
<!ELEMENT to (day, month, year)>
<!ELEMENT earned #PCDATA>
<!ELEMENT debited #PCDATA>
<!ELEMENT credited #PCDATA>
<!ELEMENT selected #PCDATA>
<!ELEMENT taken #PCDATA>
<!ELEMENT minFullWeeks #PCDATA>
<!ELEMENT maxPartialHours #PCDATA>
<!ELEMENT coFrom #PCDATA>
<!ELEMENT coTo #PCDATA>
<!ELEMENT day (#PCDATA)>
<!ELEMENT month (#PCDATA)>
<!ELEMENT year (#PCDATA)>
<!ATTLIST vacation type CDATA #REQUIRED>
<!ATTLIST agentID acdID CDATA #IMPLIED>
Supported output formats:
- Pipe delimited
- JSON
- XML
XML with results
View code
<?xml version="1.0"?>
<agentVacationSummary>
<agentVacation>
<agent>
<agentID>506</agentID>
<vacGroup>505</vacGroup>
<vacYear>Y_TOR</vacYear>
</agent>
<vacation type="Earning1">
<from>
<day>1</day>
<month>12</month>
<year>2020</year>
</from>
<to>
<day>4</day>
<month>12</month>
<year>2021</year>
</to>
<earned>6000</earned>
<credited>6000</credited>
<debited>6000</debited>
<selected>240</selected>
<taken>0</taken>
<minFullWeeks>0</minFullWeeks>
<maxPartialHours>6000</maxPartialHours>
<coFrom>6000</coFrom>
<coTo>6000</coTo>
</vacation>
</agentVacation>
<agentVacation>
<agent>
<agentID>507</agentID>
<vacGroup>505</vacGroup>
<vacYear>Y_TOR</vacYear>
</agent>
<vacation type="Earning1">
<from>
<day>1</day>
<month>12</month>
<year>2020</year>
</from>
<to>
<day>4</day>
<month>12</month>
<year>2021</year>
</to>
<earned>6000</earned>
<credited>6000</credited>
<debited>6000</debited>
<selected>0</selected>
<taken>0</taken>
<minFullWeeks>0</minFullWeeks>
<maxPartialHours>6000</maxPartialHours>
<coFrom>6000</coFrom>
<coTo>6000</coTo>
</vacation>
</agentVacation>
<agentVacation>
<agent>
<agentID>508</agentID>
<vacGroup>505</vacGroup>
<vacYear>Y_TOR</vacYear>
</agent>
<vacation type="Earning1">
<from>
<day>1</day>
<month>12</month>
<year>2020</year>
</from>
<to>
<day>4</day>
<month>12</month>
<year>2021</year>
</to>
<earned>6000</earned>
<credited>6000</credited>
<debited>6000</debited>
<selected>2880</selected>
<taken>0</taken>
<minFullWeeks>0</minFullWeeks>
<maxPartialHours>6000</maxPartialHours>
<coFrom>6000</coFrom>
<coTo>6000</coTo>
</vacation>
</agentVacation>
<agentVacation>
<agent>
<agentID>606</agentID>
<vacGroup>505</vacGroup>
<vacYear>Y_TOR</vacYear>
</agent>
<vacation type="Earning1">
<from>
<day>1</day>
<month>12</month>
<year>2020</year>
</from>
<to>
<day>4</day>
<month>12</month>
<year>2021</year>
</to>
<earned>6000</earned>
<credited>6000</credited>
<debited>6000</debited>
<selected>1440</selected>
<taken>0</taken>
<minFullWeeks>0</minFullWeeks>
<maxPartialHours>6000</maxPartialHours>
<coFrom>6000</coFrom>
<coTo>6000</coTo>
</vacation>
</agentVacation>
<agentVacation>
<agent>
<agentID>607</agentID>
<vacGroup>505</vacGroup>
<vacYear>Y_TOR</vacYear>
</agent>
<vacation type="Earning1">
<from>
<day>1</day>
<month>12</month>
<year>2020</year>
</from>
<to>
<day>4</day>
<month>12</month>
<year>2021</year>
</to>
<earned>6000</earned>
<credited>6000</credited>
<debited>6000</debited>
<selected>0</selected>
<taken>0</taken>
<minFullWeeks>0</minFullWeeks>
<maxPartialHours>6000</maxPartialHours>
<coFrom>6000</coFrom>
<coTo>6000</coTo>
</vacation>
</agentVacation>
</agentVacationSummary>XML with empty results
View code
<?xml version="1.0"?>
<agentVacationSummary/>JSON with results for 1 TOG and TOR and empty fields
View code
[
{
"custID": "1",
"muID": "500",
"tvID": "506",
"acdID": "1",
"logonID": "506",
"personalId": "",
"agentName": "506, 506",
"timeOffGroup": "505",
"timeOffRule": "Y_TOR",
"earningsType": "Earning1",
"modify": "1608036909",
"from": "2020-12-01",
"to": "2021-12-04",
"earned": "6000",
"debited": "6000",
"coFrom": "6000",
"coTo": "6000",
"selected": "240",
"taken": "0",
"credited": "6000",
"minFullWeeks": "0",
"maxPartialHours": "6000",
"externalID": "" },
{
"custID": "1",
"muID": "500",
"tvID": "507",
"acdID": "1",
"logonID": "507",
"personalId": "",
"agentName": "507, 507",
"timeOffGroup": "505",
"timeOffRule": "Y_TOR",
"earningsType": "Earning1",
"modify": "1608036909",
"from": "2020-12-01",
"to": "2021-12-04",
"earned": "6000",
"debited": "6000",
"coFrom": "6000",
"coTo": "6000",
"selected": "0",
"taken": "0",
"credited": "6000",
"minFullWeeks": "0",
"maxPartialHours": "6000",
"externalID": "" },
{
"custID": "1",
"muID": "500",
"tvID": "508",
"acdID": "1",
"logonID": "508",
"personalId": "",
"agentName": "508, 508",
"timeOffGroup": "505",
"timeOffRule": "Y_TOR",
"earningsType": "Earning1",
"modify": "1608036909",
"from": "2020-12-01",
"to": "2021-12-04",
"earned": "6000",
"debited": "6000",
"coFrom": "6000",
"coTo": "6000",
"selected": "2880",
"taken": "0",
"credited": "6000",
"minFullWeeks": "0",
"maxPartialHours": "6000",
"externalID": "" },
{
"custID": "1",
"muID": "600",
"tvID": "606",
"acdID": "1",
"logonID": "606",
"personalId": "",
"agentName": "606, 606",
"timeOffGroup": "505",
"timeOffRule": "Y_TOR",
"earningsType": "Earning1",
"modify": "1608036909",
"from": "2020-12-01",
"to": "2021-12-04",
"earned": "6000",
"debited": "6000",
"coFrom": "6000",
"coTo": "6000",
"selected": "1440",
"taken": "0",
"credited": "6000",
"minFullWeeks": "0",
"maxPartialHours": "6000",
"externalID": "" },
{
"custID": "1",
"muID": "600",
"tvID": "607",
"acdID": "1",
"logonID": "607",
"personalId": "",
"agentName": "607, 607",
"timeOffGroup": "505",
"timeOffRule": "Y_TOR",
"earningsType": "Earning1",
"modify": "1608036909",
"from": "2020-12-01",
"to": "2021-12-04",
"earned": "6000",
"debited": "6000",
"coFrom": "6000",
"coTo": "6000",
"selected": "0",
"taken": "0",
"credited": "6000",
"minFullWeeks": "0",
"maxPartialHours": "6000",
"externalID": "" }
]JSON for all TOG and TOR
View code
[
{
"custID": "1",
"muID": "101",
"tvID": "521",
"acdID": "1",
"logonID": "",
"personalId": "",
"agentName": "521, 521",
"timeOffGroup": "8000",
"timeOffRule": "TOR_2020",
"earningsType": "Waitlist",
"modify": "1586958791",
"from": "",
"to": "",
"earned": "0",
"debited": "0",
"coFrom": "0",
"coTo": "0",
"selected": "0",
"taken": "0",
"credited": "0",
"minFullWeeks": "0",
"maxPartialHours": "0",
"externalID": "" },
{
"custID": "1",
"muID": "101",
"tvID": "521",
"acdID": "1",
"logonID": "",
"personalId": "",
"agentName": "521, 521",
"timeOffGroup": "8000",
"timeOffRule": "TOR_2020",
"earningsType": "et1",
"modify": "1567171601",
"from": "2019-12-31",
"to": "2020-12-31",
"earned": "12000",
"debited": "0",
"coFrom": "0",
"coTo": "0",
"selected": "0",
"taken": "0",
"credited": "0",
"minFullWeeks": "0",
"maxPartialHours": "6000",
"externalID": "" },
{
"custID": "1",
"muID": "500",
"tvID": "501",
"acdID": "1",
"logonID": "501",
"personalId": "",
"agentName": "Parker, Robert",
"timeOffGroup": "100",
"timeOffRule": "TOR_2020_copy",
"earningsType": "et1",
"modify": "1608244626",
"from": "2019-12-31",
"to": "2020-12-31",
"earned": "4800",
"debited": "0",
"coFrom": "0",
"coTo": "0",
"selected": "0",
"taken": "0",
"credited": "0",
"minFullWeeks": "0",
"maxPartialHours": "300",
"externalID": "" },
{
"custID": "1",
"muID": "500",
"tvID": "501",
"acdID": "1",
"logonID": "501",
"personalId": "",
"agentName": "Parker, Robert",
"timeOffGroup": "100",
"timeOffRule": "TOR_2020_copy",
"earningsType": "Waitlist",
"modify": "1608232792",
"from": "",
"to": "",
"earned": "0",
"debited": "0",
"coFrom": "0",
"coTo": "0",
"selected": "0",
"taken": "0",
"credited": "0",
"minFullWeeks": "0",
"maxPartialHours": "0",
"externalID": "" },
{
"custID": "1",
"muID": "500",
"tvID": "501",
"acdID": "1",
"logonID": "501",
"personalId": "",
"agentName": "Parker, Robert",
"timeOffGroup": "100",
"timeOffRule": "TOR_2020",
"earningsType": "et1",
"modify": "1608244843",
"from": "2019-12-31",
"to": "2020-12-31",
"earned": "0",
"debited": "0",
"coFrom": "0",
"coTo": "0",
"selected": "0",
"taken": "0",
"credited": "10200",
"minFullWeeks": "2",
"maxPartialHours": "120",
"externalID": "" },
{
"custID": "1",
"muID": "500",
"tvID": "501",
"acdID": "1",
"logonID": "501",
"personalId": "",
"agentName": "Parker, Robert",
"timeOffGroup": "100",
"timeOffRule": "TOR_2020",
"earningsType": "Waitlist",
"modify": "1608242083",
"from": "",
"to": "",
"earned": "0",
"debited": "0",
"coFrom": "0",
"coTo": "0",
"selected": "0",
"taken": "0",
"credited": "0",
"minFullWeeks": "0",
"maxPartialHours": "120",
"externalID": "" },
{
"custID": "1",
"muID": "500",
"tvID": "502",
"acdID": "1",
"logonID": "502",
"personalId": "",
"agentName": "502, 502",
"timeOffGroup": "510",
"timeOffRule": "AWL_Rule",
"earningsType": "Test",
"modify": "1613396031",
"from": "2021-02-01",
"to": "2021-05-29",
"earned": "6000",
"debited": "0",
"coFrom": "0",
"coTo": "0",
"selected": "1440",
"taken": "0",
"credited": "0",
"minFullWeeks": "0",
"maxPartialHours": "0",
"externalID": "" },
{
"custID": "1",
"muID": "500",
"tvID": "503",
"acdID": "1",
"logonID": "503",
"personalId": "",
"agentName": "503, 503",
"timeOffGroup": "510",
"timeOffRule": "AWL_Rule",
"earningsType": "Test",
"modify": "1613573157",
"from": "2021-02-01",
"to": "2021-05-29",
"earned": "3000",
"debited": "0",
"coFrom": "0",
"coTo": "0",
"selected": "480",
"taken": "0",
"credited": "0",
"minFullWeeks": "0",
"maxPartialHours": "0",
"externalID": "" },
{
"custID": "1",
"muID": "500",
"tvID": "504",
"acdID": "1",
"logonID": "504",
"personalId": "",
"agentName": "504, 504",
"timeOffGroup": "510",
"timeOffRule": "AWL_Rule",
"earningsType": "Test",
"modify": "1613399403",
"from": "2021-02-01",
"to": "2021-05-29",
"earned": "480",
"debited": "0",
"coFrom": "0",
"coTo": "0",
"selected": "0",
"taken": "0",
"credited": "0",
"minFullWeeks": "0",
"maxPartialHours": "0",
"externalID": "" },
{
"custID": "1",
"muID": "500",
"tvID": "506",
"acdID": "1",
"logonID": "506",
"personalId": "",
"agentName": "506, 506",
"timeOffGroup": "505",
"timeOffRule": "Y_TOR",
"earningsType": "Earning1",
"modify": "1608036909",
"from": "2020-12-01",
"to": "2021-12-04",
"earned": "6000",
"debited": "6000",
"coFrom": "6000",
"coTo": "6000",
"selected": "240",
"taken": "0",
"credited": "6000",
"minFullWeeks": "0",
"maxPartialHours": "6000",
"externalID": "" },
{
"custID": "1",
"muID": "500",
"tvID": "507",
"acdID": "1",
"logonID": "507",
"personalId": "",
"agentName": "507, 507",
"timeOffGroup": "505",
"timeOffRule": "Y_TOR",
"earningsType": "Earning1",
"modify": "1608036909",
"from": "2020-12-01",
"to": "2021-12-04",
"earned": "6000",
"debited": "6000",
"coFrom": "6000",
"coTo": "6000",
"selected": "0",
"taken": "0",
"credited": "6000",
"minFullWeeks": "0",
"maxPartialHours": "6000",
"externalID": "" },
{
"custID": "1",
"muID": "500",
"tvID": "508",
"acdID": "1",
"logonID": "508",
"personalId": "",
"agentName": "508, 508",
"timeOffGroup": "505",
"timeOffRule": "Y_TOR",
"earningsType": "Earning1",
"modify": "1608036909",
"from": "2020-12-01",
"to": "2021-12-04",
"earned": "6000",
"debited": "6000",
"coFrom": "6000",
"coTo": "6000",
"selected": "2880",
"taken": "0",
"credited": "6000",
"minFullWeeks": "0",
"maxPartialHours": "6000",
"externalID": "" },
{
"custID": "1",
"muID": "500",
"tvID": "509",
"acdID": "1",
"logonID": "509",
"personalId": "",
"agentName": "509, 509",
"timeOffGroup": "503",
"timeOffRule": "503_Out_of_TOR",
"earningsType": "Rule1",
"modify": "1663348984",
"from": "2022-09-04",
"to": "2023-09-30",
"earned": "30000",
"debited": "0",
"coFrom": "0",
"coTo": "0",
"selected": "0",
"taken": "0",
"credited": "0",
"minFullWeeks": "0",
"maxPartialHours": "0",
"externalID": "" },
{
"custID": "1",
"muID": "500",
"tvID": "510",
"acdID": "1",
"logonID": "510",
"personalId": "",
"agentName": "510, 510",
"timeOffGroup": "503",
"timeOffRule": "503_Out_of_TOR",
"earningsType": "Rule1",
"modify": "1663339865",
"from": "2022-09-04",
"to": "2023-09-30",
"earned": "34680",
"debited": "0",
"coFrom": "0",
"coTo": "0",
"selected": "0",
"taken": "0",
"credited": "0",
"minFullWeeks": "0",
"maxPartialHours": "0",
"externalID": "" },
{
"custID": "1",
"muID": "500",
"tvID": "512",
"acdID": "1",
"logonID": "512",
"personalId": "",
"agentName": "Pickering, Sally",
"timeOffGroup": "500",
"timeOffRule": "500_SB_Rule",
"earningsType": "Special",
"modify": "1666636335",
"from": "",
"to": "",
"earned": "0",
"debited": "0",
"coFrom": "0",
"coTo": "0",
"selected": "0",
"taken": "0",
"credited": "0",
"minFullWeeks": "0",
"maxPartialHours": "0",
"externalID": "" },
{
"custID": "1",
"muID": "500",
"tvID": "512",
"acdID": "1",
"logonID": "512",
"personalId": "",
"agentName": "Pickering, Sally",
"timeOffGroup": "500",
"timeOffRule": "500_SB_Rule",
"earningsType": "Sick",
"modify": "1666636335",
"from": "",
"to": "",
"earned": "0",
"debited": "0",
"coFrom": "0",
"coTo": "0",
"selected": "0",
"taken": "0",
"credited": "0",
"minFullWeeks": "0",
"maxPartialHours": "0",
"externalID": "" },
{
"custID": "1",
"muID": "500",
"tvID": "512",
"acdID": "1",
"logonID": "512",
"personalId": "",
"agentName": "Pickering, Sally",
"timeOffGroup": "500",
"timeOffRule": "500_SB_Rule",
"earningsType": "SB_Only",
"modify": "1666347526",
"from": "2022-09-11",
"to": "2023-12-30",
"earned": "33300",
"debited": "0",
"coFrom": "0",
"coTo": "0",
"selected": "0",
"taken": "0",
"credited": "0",
"minFullWeeks": "0",
"maxPartialHours": "0",
"externalID": "" },
{
"custID": "1",
"muID": "500",
"tvID": "512",
"acdID": "1",
"logonID": "512",
"personalId": "",
"agentName": "Pickering, Sally",
"timeOffGroup": "500",
"timeOffRule": "500_SB_Rule",
"earningsType": "Unpaid",
"modify": "1666636335",
"from": "",
"to": "",
"earned": "0",
"debited": "0",
"coFrom": "0",
"coTo": "0",
"selected": "0",
"taken": "0",
"credited": "0",
"minFullWeeks": "0",
"maxPartialHours": "0",
"externalID": "" },
{
"custID": "1",
"muID": "500",
"tvID": "512",
"acdID": "1",
"logonID": "512",
"personalId": "",
"agentName": "Pickering, Sally",
"timeOffGroup": "500",
"timeOffRule": "500_SB_Rule",
"earningsType": "Vacation",
"modify": "1666722984",
"from": "2022-01-01",
"to": "2022-12-31",
"earned": "7200",
"debited": "0",
"coFrom": "0",
"coTo": "0",
"selected": "0",
"taken": "0",
"credited": "0",
"minFullWeeks": "0",
"maxPartialHours": "0",
"externalID": "" },
{
"custID": "1",
"muID": "500",
"tvID": "512",
"acdID": "1",
"logonID": "512",
"personalId": "",
"agentName": "Pickering, Sally",
"timeOffGroup": "500",
"timeOffRule": "500_SB_Rule",
"earningsType": "Wait List",
"modify": "1666636335",
"from": "",
"to": "",
"earned": "0",
"debited": "0",
"coFrom": "0",
"coTo": "0",
"selected": "0",
"taken": "0",
"credited": "0",
"minFullWeeks": "0",
"maxPartialHours": "0",
"externalID": "" },
{
"custID": "1",
"muID": "500",
"tvID": "513",
"acdID": "1",
"logonID": "513",
"personalId": "",
"agentName": "Ryker, Mason",
"timeOffGroup": "500",
"timeOffRule": "500_SB_Rule",
"earningsType": "SB_Only",
"modify": "1666347526",
"from": "2022-09-11",
"to": "2023-12-30",
"earned": "33300",
"debited": "0",
"coFrom": "0",
"coTo": "0",
"selected": "0",
"taken": "0",
"credited": "0",
"minFullWeeks": "0",
"maxPartialHours": "0",
"externalID": "" },
{
"custID": "1",
"muID": "500",
"tvID": "513",
"acdID": "1",
"logonID": "513",
"personalId": "",
"agentName": "Ryker, Mason",
"timeOffGroup": "500",
"timeOffRule": "500_SB_Rule",
"earningsType": "Sick",
"modify": "1666636335",
"from": "",
"to": "",
"earned": "0",
"debited": "0",
"coFrom": "0",
"coTo": "0",
"selected": "0",
"taken": "0",
"credited": "0",
"minFullWeeks": "0",
"maxPartialHours": "0",
"externalID": "" },
{
"custID": "1",
"muID": "500",
"tvID": "513",
"acdID": "1",
"logonID": "513",
"personalId": "",
"agentName": "Ryker, Mason",
"timeOffGroup": "500",
"timeOffRule": "500_SB_Rule",
"earningsType": "Special",
"modify": "1666636335",
"from": "",
"to": "",
"earned": "0",
"debited": "0",
"coFrom": "0",
"coTo": "0",
"selected": "0",
"taken": "0",
"credited": "0",
"minFullWeeks": "0",
"maxPartialHours": "0",
"externalID": "" },
{
"custID": "1",
"muID": "500",
"tvID": "513",
"acdID": "1",
"logonID": "513",
"personalId": "",
"agentName": "Ryker, Mason",
"timeOffGroup": "500",
"timeOffRule": "500_SB_Rule",
"earningsType": "Unpaid",
"modify": "1666636335",
"from": "",
"to": "",
"earned": "0",
"debited": "0",
"coFrom": "0",
"coTo": "0",
"selected": "0",
"taken": "0",
"credited": "0",
"minFullWeeks": "0",
"maxPartialHours": "0",
"externalID": "" },
{
"custID": "1",
"muID": "500",
"tvID": "513",
"acdID": "1",
"logonID": "513",
"personalId": "",
"agentName": "Ryker, Mason",
"timeOffGroup": "500",
"timeOffRule": "500_SB_Rule",
"earningsType": "Vacation",
"modify": "1666722984",
"from": "2022-01-01",
"to": "2022-12-31",
"earned": "7200",
"debited": "0",
"coFrom": "0",
"coTo": "0",
"selected": "0",
"taken": "0",
"credited": "0",
"minFullWeeks": "0",
"maxPartialHours": "0",
"externalID": "" },
{
"custID": "1",
"muID": "500",
"tvID": "513",
"acdID": "1",
"logonID": "513",
"personalId": "",
"agentName": "Ryker, Mason",
"timeOffGroup": "500",
"timeOffRule": "500_SB_Rule",
"earningsType": "Wait List",
"modify": "1666636335",
"from": "",
"to": "",
"earned": "0",
"debited": "0",
"coFrom": "0",
"coTo": "0",
"selected": "0",
"taken": "0",
"credited": "0",
"minFullWeeks": "0",
"maxPartialHours": "0",
"externalID": "" },
{
"custID": "1",
"muID": "600",
"tvID": "606",
"acdID": "1",
"logonID": "606",
"personalId": "",
"agentName": "606, 606",
"timeOffGroup": "505",
"timeOffRule": "Y_TOR",
"earningsType": "Earning1",
"modify": "1608036909",
"from": "2020-12-01",
"to": "2021-12-04",
"earned": "6000",
"debited": "6000",
"coFrom": "6000",
"coTo": "6000",
"selected": "1440",
"taken": "0",
"credited": "6000",
"minFullWeeks": "0",
"maxPartialHours": "6000",
"externalID": "" },
{
"custID": "1",
"muID": "600",
"tvID": "607",
"acdID": "1",
"logonID": "607",
"personalId": "",
"agentName": "607, 607",
"timeOffGroup": "505",
"timeOffRule": "Y_TOR",
"earningsType": "Earning1",
"modify": "1608036909",
"from": "2020-12-01",
"to": "2021-12-04",
"earned": "6000",
"debited": "6000",
"coFrom": "6000",
"coTo": "6000",
"selected": "0",
"taken": "0",
"credited": "6000",
"minFullWeeks": "0",
"maxPartialHours": "6000",
"externalID": "" },
{
"custID": "1",
"muID": "700",
"tvID": "125",
"acdID": "1",
"logonID": "remurphy",
"personalId": "",
"agentName": "Murphy, Reed-SB-Days",
"timeOffGroup": "6000",
"timeOffRule": "2022_DAYS_SB",
"earningsType": "Vacation3",
"modify": "1670425954",
"from": "2023-01-01",
"to": "2023-12-31",
"earned": "54240",
"debited": "0",
"coFrom": "0",
"coTo": "0",
"selected": "0",
"taken": "0",
"credited": "0",
"minFullWeeks": "0",
"maxPartialHours": "0",
"externalID": "" },
{
"custID": "1",
"muID": "700",
"tvID": "125",
"acdID": "1",
"logonID": "remurphy",
"personalId": "",
"agentName": "Murphy, Reed-SB-Days",
"timeOffGroup": "6000",
"timeOffRule": "2022_DAYS_SB",
"earningsType": "Vacation2",
"modify": "1670425954",
"from": "2023-01-01",
"to": "2023-12-31",
"earned": "54240",
"debited": "0",
"coFrom": "0",
"coTo": "0",
"selected": "0",
"taken": "0",
"credited": "0",
"minFullWeeks": "0",
"maxPartialHours": "0",
"externalID": "" },
{
"custID": "1",
"muID": "700",
"tvID": "125",
"acdID": "1",
"logonID": "remurphy",
"personalId": "",
"agentName": "Murphy, Reed-SB-Days",
"timeOffGroup": "6000",
"timeOffRule": "2022_DAYS_SB",
"earningsType": "Vacation1",
"modify": "1666274186",
"from": "2022-10-01",
"to": "2023-12-31",
"earned": "48000",
"debited": "0",
"coFrom": "0",
"coTo": "0",
"selected": "0",
"taken": "0",
"credited": "0",
"minFullWeeks": "0",
"maxPartialHours": "0",
"externalID": "" },
{
"custID": "1",
"muID": "700",
"tvID": "520",
"acdID": "1",
"logonID": "520_login",
"personalId": "",
"agentName": "520, 520",
"timeOffGroup": "701",
"timeOffRule": "701_YB",
"earningsType": "YB_rule1",
"modify": "1663148638",
"from": "2022-09-04",
"to": "2023-12-30",
"earned": "47340",
"debited": "0",
"coFrom": "0",
"coTo": "0",
"selected": "1440",
"taken": "0",
"credited": "0",
"minFullWeeks": "0",
"maxPartialHours": "0",
"externalID": "" },
{
"custID": "1",
"muID": "700",
"tvID": "521",
"acdID": "1",
"logonID": "",
"personalId": "",
"agentName": "521, 521",
"timeOffGroup": "8000",
"timeOffRule": "TOG350_TOR",
"earningsType": "TOG350_AT",
"modify": "1620927369",
"from": "2021-05-01",
"to": "2021-12-31",
"earned": "0",
"debited": "0",
"coFrom": "0",
"coTo": "0",
"selected": "0",
"taken": "0",
"credited": "0",
"minFullWeeks": "0",
"maxPartialHours": "0",
"externalID": "" },
{
"custID": "1",
"muID": "700",
"tvID": "523",
"acdID": "1",
"logonID": "L_523",
"personalId": "",
"agentName": "523, 523",
"timeOffGroup": "701",
"timeOffRule": "701_YB",
"earningsType": "YB_rule1",
"modify": "1663148638",
"from": "2022-09-04",
"to": "2023-12-30",
"earned": "47340",
"debited": "0",
"coFrom": "0",
"coTo": "0",
"selected": "0",
"taken": "0",
"credited": "0",
"minFullWeeks": "0",
"maxPartialHours": "0",
"externalID": "" },
{
"custID": "1",
"muID": "700",
"tvID": "524",
"acdID": "1",
"logonID": "524",
"personalId": "",
"agentName": "Parker, John",
"timeOffGroup": "500",
"timeOffRule": "500_SB_Rule",
"earningsType": "Wait List",
"modify": "1666636335",
"from": "2022-01-01",
"to": "2022-12-31",
"earned": "4800",
"debited": "0",
"coFrom": "0",
"coTo": "0",
"selected": "0",
"taken": "0",
"credited": "0",
"minFullWeeks": "0",
"maxPartialHours": "0",
"externalID": "" },
{
"custID": "1",
"muID": "700",
"tvID": "524",
"acdID": "1",
"logonID": "524",
"personalId": "",
"agentName": "Parker, John",
"timeOffGroup": "500",
"timeOffRule": "500_SB_Rule",
"earningsType": "Vacation",
"modify": "1666722984",
"from": "2022-01-01",
"to": "2022-12-31",
"earned": "12000",
"debited": "0",
"coFrom": "0",
"coTo": "0",
"selected": "0",
"taken": "0",
"credited": "0",
"minFullWeeks": "0",
"maxPartialHours": "0",
"externalID": "" },
{
"custID": "1",
"muID": "700",
"tvID": "524",
"acdID": "1",
"logonID": "524",
"personalId": "",
"agentName": "Parker, John",
"timeOffGroup": "500",
"timeOffRule": "500_SB_Rule",
"earningsType": "SB_Only",
"modify": "1665483113",
"from": "2022-09-11",
"to": "2023-12-30",
"earned": "34020",
"debited": "0",
"coFrom": "0",
"coTo": "0",
"selected": "0",
"taken": "0",
"credited": "0",
"minFullWeeks": "0",
"maxPartialHours": "0",
"externalID": "" },
{
"custID": "1",
"muID": "700",
"tvID": "524",
"acdID": "1",
"logonID": "524",
"personalId": "",
"agentName": "Parker, John",
"timeOffGroup": "500",
"timeOffRule": "500_SB_Rule",
"earningsType": "Sick",
"modify": "1666636335",
"from": "2022-01-01",
"to": "2022-12-31",
"earned": "4800",
"debited": "0",
"coFrom": "0",
"coTo": "0",
"selected": "0",
"taken": "0",
"credited": "0",
"minFullWeeks": "0",
"maxPartialHours": "0",
"externalID": "" },
{
"custID": "1",
"muID": "700",
"tvID": "524",
"acdID": "1",
"logonID": "524",
"personalId": "",
"agentName": "Parker, John",
"timeOffGroup": "500",
"timeOffRule": "500_SB_Rule",
"earningsType": "Special",
"modify": "1666636335",
"from": "2022-01-01",
"to": "2022-12-31",
"earned": "2400",
"debited": "0",
"coFrom": "0",
"coTo": "0",
"selected": "0",
"taken": "0",
"credited": "0",
"minFullWeeks": "0",
"maxPartialHours": "0",
"externalID": "" },
{
"custID": "1",
"muID": "700",
"tvID": "524",
"acdID": "1",
"logonID": "524",
"personalId": "",
"agentName": "Parker, John",
"timeOffGroup": "500",
"timeOffRule": "500_SB_Rule",
"earningsType": "Unpaid",
"modify": "1666722984",
"from": "2022-01-01",
"to": "2022-12-31",
"earned": "2400",
"debited": "0",
"coFrom": "0",
"coTo": "0",
"selected": "0",
"taken": "0",
"credited": "0",
"minFullWeeks": "0",
"maxPartialHours": "0",
"externalID": "" },
{
"custID": "1",
"muID": "700",
"tvID": "526",
"acdID": "1",
"logonID": "",
"personalId": "",
"agentName": "Rogers, Patty",
"timeOffGroup": "500",
"timeOffRule": "500_SB_Rule",
"earningsType": "FullTime",
"modify": "1658938124",
"from": "2023-01-01",
"to": "2023-08-26",
"earned": "7380",
"debited": "0",
"coFrom": "0",
"coTo": "0",
"selected": "0",
"taken": "0",
"credited": "0",
"minFullWeeks": "0",
"maxPartialHours": "0",
"externalID": "" },
{
"custID": "1",
"muID": "700",
"tvID": "526",
"acdID": "1",
"logonID": "",
"personalId": "",
"agentName": "Rogers, Patty",
"timeOffGroup": "500",
"timeOffRule": "500_SB_Rule",
"earningsType": "SB_Only",
"modify": "1663146487",
"from": "2022-09-11",
"to": "2023-12-30",
"earned": "30000",
"debited": "0",
"coFrom": "0",
"coTo": "0",
"selected": "0",
"taken": "0",
"credited": "0",
"minFullWeeks": "0",
"maxPartialHours": "0",
"externalID": "" },
{
"custID": "1",
"muID": "700",
"tvID": "526",
"acdID": "1",
"logonID": "",
"personalId": "",
"agentName": "Rogers, Patty",
"timeOffGroup": "500",
"timeOffRule": "500_SB_Rule",
"earningsType": "Sick",
"modify": "1640111992",
"from": "2022-01-01",
"to": "2022-12-31",
"earned": "4620",
"debited": "0",
"coFrom": "0",
"coTo": "0",
"selected": "0",
"taken": "0",
"credited": "0",
"minFullWeeks": "0",
"maxPartialHours": "0",
"externalID": "" },
{
"custID": "1",
"muID": "700",
"tvID": "526",
"acdID": "1",
"logonID": "",
"personalId": "",
"agentName": "Rogers, Patty",
"timeOffGroup": "500",
"timeOffRule": "500_SB_Rule",
"earningsType": "Special",
"modify": "1666722984",
"from": "2022-01-01",
"to": "2022-12-31",
"earned": "2400",
"debited": "0",
"coFrom": "0",
"coTo": "0",
"selected": "0",
"taken": "0",
"credited": "0",
"minFullWeeks": "0",
"maxPartialHours": "0",
"externalID": "" },
{
"custID": "1",
"muID": "700",
"tvID": "526",
"acdID": "1",
"logonID": "",
"personalId": "",
"agentName": "Rogers, Patty",
"timeOffGroup": "500",
"timeOffRule": "500_SB_Rule",
"earningsType": "Unpaid",
"modify": "1666722984",
"from": "2022-01-01",
"to": "2022-12-31",
"earned": "2400",
"debited": "0",
"coFrom": "0",
"coTo": "0",
"selected": "0",
"taken": "0",
"credited": "0",
"minFullWeeks": "0",
"maxPartialHours": "0",
"externalID": "" },
{
"custID": "1",
"muID": "700",
"tvID": "526",
"acdID": "1",
"logonID": "",
"personalId": "",
"agentName": "Rogers, Patty",
"timeOffGroup": "500",
"timeOffRule": "500_SB_Rule",
"earningsType": "Vacation",
"modify": "1666722984",
"from": "2022-01-01",
"to": "2022-12-31",
"earned": "7200",
"debited": "0",
"coFrom": "0",
"coTo": "0",
"selected": "0",
"taken": "0",
"credited": "0",
"minFullWeeks": "0",
"maxPartialHours": "0",
"externalID": "" },
{
"custID": "1",
"muID": "700",
"tvID": "526",
"acdID": "1",
"logonID": "",
"personalId": "",
"agentName": "Rogers, Patty",
"timeOffGroup": "500",
"timeOffRule": "500_SB_Rule",
"earningsType": "Vacation1",
"modify": "1648034302",
"from": "2022-03-20",
"to": "2022-07-30",
"earned": "1200",
"debited": "0",
"coFrom": "0",
"coTo": "0",
"selected": "0",
"taken": "0",
"credited": "0",
"minFullWeeks": "0",
"maxPartialHours": "0",
"externalID": "" },
{
"custID": "1",
"muID": "700",
"tvID": "526",
"acdID": "1",
"logonID": "",
"personalId": "",
"agentName": "Rogers, Patty",
"timeOffGroup": "500",
"timeOffRule": "500_SB_Rule",
"earningsType": "Vacation2",
"modify": "1648032129",
"from": "",
"to": "",
"earned": "0",
"debited": "0",
"coFrom": "0",
"coTo": "0",
"selected": "0",
"taken": "0",
"credited": "0",
"minFullWeeks": "0",
"maxPartialHours": "0",
"externalID": "" },
{
"custID": "1",
"muID": "700",
"tvID": "526",
"acdID": "1",
"logonID": "",
"personalId": "",
"agentName": "Rogers, Patty",
"timeOffGroup": "500",
"timeOffRule": "500_SB_Rule",
"earningsType": "Vacation3",
"modify": "1648034302",
"from": "",
"to": "",
"earned": "0",
"debited": "0",
"coFrom": "0",
"coTo": "0",
"selected": "0",
"taken": "0",
"credited": "0",
"minFullWeeks": "0",
"maxPartialHours": "0",
"externalID": "" },
{
"custID": "1",
"muID": "700",
"tvID": "526",
"acdID": "1",
"logonID": "",
"personalId": "",
"agentName": "Rogers, Patty",
"timeOffGroup": "500",
"timeOffRule": "500_SB_Rule",
"earningsType": "Wait List",
"modify": "1666722984",
"from": "2022-01-01",
"to": "2022-12-31",
"earned": "4800",
"debited": "0",
"coFrom": "0",
"coTo": "0",
"selected": "0",
"taken": "0",
"credited": "0",
"minFullWeeks": "0",
"maxPartialHours": "0",
"externalID": "" },
{
"custID": "1",
"muID": "700",
"tvID": "800003",
"acdID": "1",
"logonID": "800003",
"personalId": "",
"agentName": "800003, 800003",
"timeOffGroup": "700",
"timeOffRule": "NotActive Request",
"earningsType": "Vacation",
"modify": "1663148565",
"from": "2022-09-04",
"to": "2023-12-30",
"earned": "47340",
"debited": "0",
"coFrom": "0",
"coTo": "0",
"selected": "1800",
"taken": "0",
"credited": "0",
"minFullWeeks": "0",
"maxPartialHours": "0",
"externalID": "" },
{
"custID": "1",
"muID": "700",
"tvID": "800004",
"acdID": "1",
"logonID": "800004",
"personalId": "",
"agentName": "800004, 800004",
"timeOffGroup": "700",
"timeOffRule": "NotActive Request",
"earningsType": "Vacation",
"modify": "1663148565",
"from": "2022-09-04",
"to": "2023-12-30",
"earned": "47340",
"debited": "0",
"coFrom": "0",
"coTo": "0",
"selected": "1440",
"taken": "0",
"credited": "0",
"minFullWeeks": "0",
"maxPartialHours": "0",
"externalID": "" },
{
"custID": "1",
"muID": "700",
"tvID": "800005",
"acdID": "1",
"logonID": "800005",
"personalId": "",
"agentName": "800005, 800005",
"timeOffGroup": "700",
"timeOffRule": "NotActive Request",
"earningsType": "Vacation",
"modify": "1663148565",
"from": "2022-09-04",
"to": "2023-12-30",
"earned": "47340",
"debited": "0",
"coFrom": "0",
"coTo": "0",
"selected": "0",
"taken": "0",
"credited": "0",
"minFullWeeks": "0",
"maxPartialHours": "0",
"externalID": "" },
{
"custID": "1",
"muID": "700",
"tvID": "800007",
"acdID": "1",
"logonID": "800007",
"personalId": "",
"agentName": "800007, 800007",
"timeOffGroup": "6000",
"timeOffRule": "2022_DAYS_SB",
"earningsType": "Vacation3",
"modify": "1665525793",
"from": "2022-01-01",
"to": "2023-12-31",
"earned": "0",
"debited": "0",
"coFrom": "0",
"coTo": "0",
"selected": "0",
"taken": "0",
"credited": "0",
"minFullWeeks": "0",
"maxPartialHours": "0",
"externalID": "" },
{
"custID": "1",
"muID": "700",
"tvID": "800007",
"acdID": "1",
"logonID": "800007",
"personalId": "",
"agentName": "800007, 800007",
"timeOffGroup": "6000",
"timeOffRule": "2022_DAYS_SB",
"earningsType": "Vacation2",
"modify": "1670425954",
"from": "2022-01-01",
"to": "2023-12-31",
"earned": "102240",
"debited": "0",
"coFrom": "0",
"coTo": "0",
"selected": "0",
"taken": "0",
"credited": "0",
"minFullWeeks": "0",
"maxPartialHours": "0",
"externalID": "" },
{
"custID": "1",
"muID": "700",
"tvID": "800007",
"acdID": "1",
"logonID": "800007",
"personalId": "",
"agentName": "800007, 800007",
"timeOffGroup": "6000",
"timeOffRule": "2022_DAYS_SB",
"earningsType": "Vacation1",
"modify": "1665525793",
"from": "2022-01-01",
"to": "2023-12-31",
"earned": "48000",
"debited": "0",
"coFrom": "0",
"coTo": "0",
"selected": "0",
"taken": "0",
"credited": "0",
"minFullWeeks": "0",
"maxPartialHours": "0",
"externalID": "" },
{
"custID": "1",
"muID": "700",
"tvID": "800008",
"acdID": "1",
"logonID": "800008",
"personalId": "",
"agentName": "Pastor, Robert",
"timeOffGroup": "500",
"timeOffRule": "500_SB_Rule",
"earningsType": "Vacation",
"modify": "1665666274",
"from": "",
"to": "",
"earned": "0",
"debited": "0",
"coFrom": "0",
"coTo": "0",
"selected": "0",
"taken": "0",
"credited": "0",
"minFullWeeks": "0",
"maxPartialHours": "0",
"externalID": "" },
{
"custID": "1",
"muID": "700",
"tvID": "800008",
"acdID": "1",
"logonID": "800008",
"personalId": "",
"agentName": "Pastor, Robert",
"timeOffGroup": "500",
"timeOffRule": "500_SB_Rule",
"earningsType": "Unpaid",
"modify": "1665666274",
"from": "",
"to": "",
"earned": "0",
"debited": "0",
"coFrom": "0",
"coTo": "0",
"selected": "0",
"taken": "0",
"credited": "0",
"minFullWeeks": "0",
"maxPartialHours": "0",
"externalID": "" },
{
"custID": "1",
"muID": "700",
"tvID": "800008",
"acdID": "1",
"logonID": "800008",
"personalId": "",
"agentName": "Pastor, Robert",
"timeOffGroup": "500",
"timeOffRule": "500_SB_Rule",
"earningsType": "Special",
"modify": "1665666274",
"from": "",
"to": "",
"earned": "0",
"debited": "0",
"coFrom": "0",
"coTo": "0",
"selected": "0",
"taken": "0",
"credited": "0",
"minFullWeeks": "0",
"maxPartialHours": "0",
"externalID": "" },
{
"custID": "1",
"muID": "700",
"tvID": "800008",
"acdID": "1",
"logonID": "800008",
"personalId": "",
"agentName": "Pastor, Robert",
"timeOffGroup": "500",
"timeOffRule": "500_SB_Rule",
"earningsType": "Sick",
"modify": "1665666274",
"from": "",
"to": "",
"earned": "0",
"debited": "0",
"coFrom": "0",
"coTo": "0",
"selected": "0",
"taken": "0",
"credited": "0",
"minFullWeeks": "0",
"maxPartialHours": "0",
"externalID": "" },
{
"custID": "1",
"muID": "700",
"tvID": "800008",
"acdID": "1",
"logonID": "800008",
"personalId": "",
"agentName": "Pastor, Robert",
"timeOffGroup": "500",
"timeOffRule": "500_SB_Rule",
"earningsType": "SB_Only",
"modify": "1666347541",
"from": "2022-09-11",
"to": "2023-12-30",
"earned": "30000",
"debited": "0",
"coFrom": "0",
"coTo": "0",
"selected": "0",
"taken": "0",
"credited": "0",
"minFullWeeks": "0",
"maxPartialHours": "0",
"externalID": "" },
{
"custID": "1",
"muID": "700",
"tvID": "800008",
"acdID": "1",
"logonID": "800008",
"personalId": "",
"agentName": "Pastor, Robert",
"timeOffGroup": "500",
"timeOffRule": "500_SB_Rule",
"earningsType": "Wait List",
"modify": "1665666274",
"from": "",
"to": "",
"earned": "0",
"debited": "0",
"coFrom": "0",
"coTo": "0",
"selected": "0",
"taken": "0",
"credited": "0",
"minFullWeeks": "0",
"maxPartialHours": "0",
"externalID": "" },
{
"custID": "1",
"muID": "8000",
"tvID": "800001",
"acdID": "1",
"logonID": "800001a",
"personalId": "",
"agentName": "test, test",
"timeOffGroup": "8000",
"timeOffRule": "TOG350_TOR",
"earningsType": "TOG350_AT",
"modify": "1620927369",
"from": "2021-05-01",
"to": "2021-12-31",
"earned": "2400",
"debited": "0",
"coFrom": "0",
"coTo": "0",
"selected": "0",
"taken": "0",
"credited": "0",
"minFullWeeks": "0",
"maxPartialHours": "0",
"externalID": "" },
{
"custID": "1",
"muID": "8000",
"tvID": "800001",
"acdID": "1",
"logonID": "800001a",
"personalId": "",
"agentName": "test, test",
"timeOffGroup": "8000",
"timeOffRule": "TOR_2020",
"earningsType": "Waitlist",
"modify": "1586958791",
"from": "",
"to": "",
"earned": "0",
"debited": "0",
"coFrom": "0",
"coTo": "0",
"selected": "0",
"taken": "0",
"credited": "0",
"minFullWeeks": "0",
"maxPartialHours": "0",
"externalID": "" },
{
"custID": "1",
"muID": "8000",
"tvID": "800001",
"acdID": "1",
"logonID": "800001a",
"personalId": "",
"agentName": "test, test",
"timeOffGroup": "8000",
"timeOffRule": "TOR_2020",
"earningsType": "et1",
"modify": "1567596497",
"from": "2019-12-31",
"to": "2020-12-31",
"earned": "12000",
"debited": "0",
"coFrom": "0",
"coTo": "0",
"selected": "0",
"taken": "0",
"credited": "0",
"minFullWeeks": "0",
"maxPartialHours": "0",
"externalID": "" },
{
"custID": "1",
"muID": "8000",
"tvID": "800002",
"acdID": "1",
"logonID": "800002",
"personalId": "",
"agentName": "800002, 800002",
"timeOffGroup": "8000",
"timeOffRule": "TOG350_TOR",
"earningsType": "TOG350_AT",
"modify": "1620927369",
"from": "2021-05-01",
"to": "2021-12-31",
"earned": "2400",
"debited": "0",
"coFrom": "0",
"coTo": "0",
"selected": "0",
"taken": "0",
"credited": "0",
"minFullWeeks": "0",
"maxPartialHours": "0",
"externalID": "" },
{
"custID": "1",
"muID": "8000",
"tvID": "800002",
"acdID": "1",
"logonID": "800002",
"personalId": "",
"agentName": "800002, 800002",
"timeOffGroup": "8000",
"timeOffRule": "TOR_2020",
"earningsType": "Waitlist",
"modify": "1586958791",
"from": "",
"to": "",
"earned": "0",
"debited": "0",
"coFrom": "0",
"coTo": "0",
"selected": "0",
"taken": "0",
"credited": "0",
"minFullWeeks": "0",
"maxPartialHours": "0",
"externalID": "" },
{
"custID": "1",
"muID": "8000",
"tvID": "800002",
"acdID": "1",
"logonID": "800002",
"personalId": "",
"agentName": "800002, 800002",
"timeOffGroup": "8000",
"timeOffRule": "TOR_2020",
"earningsType": "et1",
"modify": "1567596497",
"from": "2019-12-31",
"to": "2020-12-31",
"earned": "12000",
"debited": "0",
"coFrom": "0",
"coTo": "0",
"selected": "0",
"taken": "0",
"credited": "0",
"minFullWeeks": "0",
"maxPartialHours": "0",
"externalID": "" },
{
"custID": "1",
"muID": "70000",
"tvID": "2345",
"acdID": "1",
"logonID": "2345",
"personalId": "",
"agentName": "Manning, Tawana",
"timeOffGroup": "8000",
"timeOffRule": "TOG350_TOR",
"earningsType": "TOG350_AT",
"modify": "1620927369",
"from": "2021-05-01",
"to": "2021-12-31",
"earned": "0",
"debited": "0",
"coFrom": "0",
"coTo": "0",
"selected": "0",
"taken": "0",
"credited": "0",
"minFullWeeks": "0",
"maxPartialHours": "0",
"externalID": "2345" },
{
"custID": "1",
"muID": "70000",
"tvID": "2345",
"acdID": "1",
"logonID": "2345",
"personalId": "",
"agentName": "Manning, Tawana",
"timeOffGroup": "8000",
"timeOffRule": "TOR_2020",
"earningsType": "Waitlist",
"modify": "1586958791",
"from": "2019-12-31",
"to": "2020-12-31",
"earned": "2400",
"debited": "0",
"coFrom": "0",
"coTo": "0",
"selected": "0",
"taken": "0",
"credited": "0",
"minFullWeeks": "0",
"maxPartialHours": "0",
"externalID": "2345" },
{
"custID": "1",
"muID": "70000",
"tvID": "2345",
"acdID": "1",
"logonID": "2345",
"personalId": "",
"agentName": "Manning, Tawana",
"timeOffGroup": "8000",
"timeOffRule": "TOR_2020",
"earningsType": "et1",
"modify": "1586958791",
"from": "2019-12-31",
"to": "2020-12-31",
"earned": "12000",
"debited": "0",
"coFrom": "0",
"coTo": "0",
"selected": "0",
"taken": "0",
"credited": "0",
"minFullWeeks": "0",
"maxPartialHours": "0",
"externalID": "2345" },
{
"custID": "1",
"muID": "70000",
"tvID": "70001",
"acdID": "1",
"logonID": "",
"personalId": "70001",
"agentName": "Merrick, Clark",
"timeOffGroup": "450",
"timeOffRule": "Test450_Rule",
"earningsType": "TOG450_AT",
"modify": "1613002209",
"from": "2021-01-10",
"to": "2021-12-31",
"earned": "3600",
"debited": "0",
"coFrom": "0",
"coTo": "0",
"selected": "480",
"taken": "0",
"credited": "0",
"minFullWeeks": "0",
"maxPartialHours": "0",
"externalID": "70001" },
{
"custID": "1",
"muID": "70000",
"tvID": "70500",
"acdID": "1",
"logonID": "70500",
"personalId": "rw70500",
"agentName": "Williams, Ryan",
"timeOffGroup": "500",
"timeOffRule": "500_SB_Rule",
"earningsType": "Vacation",
"modify": "1666099288",
"from": "2022-01-01",
"to": "2022-12-31",
"earned": "9600",
"debited": "0",
"coFrom": "0",
"coTo": "0",
"selected": "0",
"taken": "0",
"credited": "0",
"minFullWeeks": "0",
"maxPartialHours": "0",
"externalID": "rw70500" },
{
"custID": "1",
"muID": "70000",
"tvID": "70500",
"acdID": "1",
"logonID": "70500",
"personalId": "rw70500",
"agentName": "Williams, Ryan",
"timeOffGroup": "500",
"timeOffRule": "500_SB_Rule",
"earningsType": "Unpaid",
"modify": "1666099288",
"from": "2022-01-01",
"to": "2022-12-31",
"earned": "2400",
"debited": "0",
"coFrom": "0",
"coTo": "0",
"selected": "0",
"taken": "0",
"credited": "0",
"minFullWeeks": "0",
"maxPartialHours": "0",
"externalID": "rw70500" },
{
"custID": "1",
"muID": "70000",
"tvID": "70500",
"acdID": "1",
"logonID": "70500",
"personalId": "rw70500",
"agentName": "Williams, Ryan",
"timeOffGroup": "500",
"timeOffRule": "500_SB_Rule",
"earningsType": "Special",
"modify": "1666099288",
"from": "2022-01-01",
"to": "2022-12-31",
"earned": "2400",
"debited": "0",
"coFrom": "0",
"coTo": "0",
"selected": "0",
"taken": "0",
"credited": "0",
"minFullWeeks": "0",
"maxPartialHours": "0",
"externalID": "rw70500" },
{
"custID": "1",
"muID": "70000",
"tvID": "70500",
"acdID": "1",
"logonID": "70500",
"personalId": "rw70500",
"agentName": "Williams, Ryan",
"timeOffGroup": "500",
"timeOffRule": "500_SB_Rule",
"earningsType": "Sick",
"modify": "1666099288",
"from": "2022-01-01",
"to": "2022-12-31",
"earned": "4800",
"debited": "0",
"coFrom": "0",
"coTo": "0",
"selected": "0",
"taken": "0",
"credited": "0",
"minFullWeeks": "0",
"maxPartialHours": "0",
"externalID": "rw70500" },
{
"custID": "1",
"muID": "70000",
"tvID": "70500",
"acdID": "1",
"logonID": "70500",
"personalId": "rw70500",
"agentName": "Williams, Ryan",
"timeOffGroup": "500",
"timeOffRule": "500_SB_Rule",
"earningsType": "SB_Only",
"modify": "1666347541",
"from": "2022-09-11",
"to": "2023-12-30",
"earned": "30000",
"debited": "0",
"coFrom": "0",
"coTo": "0",
"selected": "0",
"taken": "0",
"credited": "0",
"minFullWeeks": "0",
"maxPartialHours": "0",
"externalID": "rw70500" },
{
"custID": "1",
"muID": "70000",
"tvID": "70500",
"acdID": "1",
"logonID": "70500",
"personalId": "rw70500",
"agentName": "Williams, Ryan",
"timeOffGroup": "500",
"timeOffRule": "500_SB_Rule",
"earningsType": "Wait List",
"modify": "1666099288",
"from": "2022-01-01",
"to": "2022-12-31",
"earned": "9600",
"debited": "0",
"coFrom": "0",
"coTo": "0",
"selected": "0",
"taken": "0",
"credited": "0",
"minFullWeeks": "0",
"maxPartialHours": "0",
"externalID": "rw70500" },
{
"custID": "1",
"muID": "70000",
"tvID": "70505",
"acdID": "1",
"logonID": "",
"personalId": "",
"agentName": "Wu 70505, Yi 70505",
"timeOffGroup": "450",
"timeOffRule": "Test450_Rule",
"earningsType": "TOG450_AT",
"modify": "1613002209",
"from": "2021-01-10",
"to": "2021-12-31",
"earned": "4800",
"debited": "0",
"coFrom": "0",
"coTo": "0",
"selected": "480",
"taken": "0",
"credited": "0",
"minFullWeeks": "0",
"maxPartialHours": "0",
"externalID": "" },
{
"custID": "1",
"muID": "70000",
"tvID": "70506",
"acdID": "1",
"logonID": "",
"personalId": "",
"agentName": "Wu 70506, Yi 70506",
"timeOffGroup": "450",
"timeOffRule": "Test450_Rule",
"earningsType": "TOG450_AT",
"modify": "1613002209",
"from": "2021-01-10",
"to": "2021-12-31",
"earned": "4800",
"debited": "0",
"coFrom": "0",
"coTo": "0",
"selected": "480",
"taken": "0",
"credited": "0",
"minFullWeeks": "0",
"maxPartialHours": "0",
"externalID": "" }
]JSON with empty results
PIPE results for 1 TOG and TOR with PIPE header
View code
#fields:custID|muID|tvID|acdID|logonID|ssn|agentName|vacGroup|vacYear|vacType|modify|from|to|earned|debited|coFrom|coTo|selected|taken|credited|minFullWeeks|maxPartialHours|externalID
#sort:custID,muID,tvID,acdID,logonID,ssn,agentName,vacGroup,vacYear,vacType,modify,from,to,earned,debited,coFrom,coTo,selected,taken,credited,minFullWeeks,maxPartialHours,externalID
1|500|506|1|506||506, 506|505|Y_TOR|Earning1|1608036909|01122020|04122021|6000|6000|6000|6000|240|0|6000|0|6000|
1|500|507|1|507||507, 507|505|Y_TOR|Earning1|1608036909|01122020|04122021|6000|6000|6000|6000|0|0|6000|0|6000|
1|500|508|1|508||508, 508|505|Y_TOR|Earning1|1608036909|01122020|04122021|6000|6000|6000|6000|2880|0|6000|0|6000|
1|600|606|1|606||606, 606|505|Y_TOR|Earning1|1608036909|01122020|04122021|6000|6000|6000|6000|1440|0|6000|0|6000|
1|600|607|1|607||607, 607|505|Y_TOR|Earning1|1608036909|01122020|04122021|6000|6000|6000|6000|0|0|6000|0|6000|
PIPE results all TOG and TOR
View code
#fields:custID|muID|tvID|acdID|logonID|ssn|agentName|vacGroup|vacYear|vacType|modify|from|to|earned|debited|coFrom|coTo|selected|taken|credited|minFullWeeks|maxPartialHours|externalID
#sort:custID,muID,tvID,acdID,logonID,ssn,agentName,vacGroup,vacYear,vacType,modify,from,to,earned,debited,coFrom,coTo,selected,taken,credited,minFullWeeks,maxPartialHours,externalID
1|101|521|1|||521, 521|8000|TOR_2020|Waitlist|1586958791|||0|0|0|0|0|0|0|0|0|
1|101|521|1|||521, 521|8000|TOR_2020|et1|1567171601|31122019|31122020|12000|0|0|0|0|0|0|0|6000|
1|500|501|1|501||Parker, Robert|100|TOR_2020_copy|et1|1608244626|31122019|31122020|4800|0|0|0|0|0|0|0|300|
1|500|501|1|501||Parker, Robert|100|TOR_2020_copy|Waitlist|1608232792|||0|0|0|0|0|0|0|0|0|
1|500|501|1|501||Parker, Robert|100|TOR_2020|et1|1608244843|31122019|31122020|0|0|0|0|0|0|10200|2|120|
1|500|501|1|501||Parker, Robert|100|TOR_2020|Waitlist|1608242083|||0|0|0|0|0|0|0|0|120|
1|500|502|1|502||502, 502|510|AWL_Rule|Test|1613396031|01022021|29052021|6000|0|0|0|1440|0|0|0|0|
1|500|503|1|503||503, 503|510|AWL_Rule|Test|1613573157|01022021|29052021|3000|0|0|0|480|0|0|0|0|
1|500|504|1|504||504, 504|510|AWL_Rule|Test|1613399403|01022021|29052021|480|0|0|0|0|0|0|0|0|
1|500|506|1|506||506, 506|505|Y_TOR|Earning1|1608036909|01122020|04122021|6000|6000|6000|6000|240|0|6000|0|6000|
1|500|507|1|507||507, 507|505|Y_TOR|Earning1|1608036909|01122020|04122021|6000|6000|6000|6000|0|0|6000|0|6000|
1|500|508|1|508||508, 508|505|Y_TOR|Earning1|1608036909|01122020|04122021|6000|6000|6000|6000|2880|0|6000|0|6000|
1|500|509|1|509||509, 509|503|503_Out_of_TOR|Rule1|1663348984|04092022|30092023|30000|0|0|0|0|0|0|0|0|
1|500|510|1|510||510, 510|503|503_Out_of_TOR|Rule1|1663339865|04092022|30092023|34680|0|0|0|0|0|0|0|0|
1|500|512|1|512||Pickering, Sally|500|500_SB_Rule|Special|1666636335|||0|0|0|0|0|0|0|0|0|
1|500|512|1|512||Pickering, Sally|500|500_SB_Rule|Sick|1666636335|||0|0|0|0|0|0|0|0|0|
1|500|512|1|512||Pickering, Sally|500|500_SB_Rule|SB_Only|1666347526|11092022|30122023|33300|0|0|0|0|0|0|0|0|
1|500|512|1|512||Pickering, Sally|500|500_SB_Rule|Unpaid|1666636335|||0|0|0|0|0|0|0|0|0|
1|500|512|1|512||Pickering, Sally|500|500_SB_Rule|Vacation|1666722984|01012022|31122022|7200|0|0|0|0|0|0|0|0|
1|500|512|1|512||Pickering, Sally|500|500_SB_Rule|Wait List|1666636335|||0|0|0|0|0|0|0|0|0|
1|500|513|1|513||Ryker, Mason|500|500_SB_Rule|SB_Only|1666347526|11092022|30122023|33300|0|0|0|0|0|0|0|0|
1|500|513|1|513||Ryker, Mason|500|500_SB_Rule|Sick|1666636335|||0|0|0|0|0|0|0|0|0|
1|500|513|1|513||Ryker, Mason|500|500_SB_Rule|Special|1666636335|||0|0|0|0|0|0|0|0|0|
1|500|513|1|513||Ryker, Mason|500|500_SB_Rule|Unpaid|1666636335|||0|0|0|0|0|0|0|0|0|
1|500|513|1|513||Ryker, Mason|500|500_SB_Rule|Vacation|1666722984|01012022|31122022|7200|0|0|0|0|0|0|0|0|
1|500|513|1|513||Ryker, Mason|500|500_SB_Rule|Wait List|1666636335|||0|0|0|0|0|0|0|0|0|
1|600|606|1|606||606, 606|505|Y_TOR|Earning1|1608036909|01122020|04122021|6000|6000|6000|6000|1440|0|6000|0|6000|
1|600|607|1|607||607, 607|505|Y_TOR|Earning1|1608036909|01122020|04122021|6000|6000|6000|6000|0|0|6000|0|6000|
1|700|125|1|remurphy||Murphy, Reed-SB-Days|6000|2022_DAYS_SB|Vacation3|1670425954|01012023|31122023|54240|0|0|0|0|0|0|0|0|
1|700|125|1|remurphy||Murphy, Reed-SB-Days|6000|2022_DAYS_SB|Vacation2|1670425954|01012023|31122023|54240|0|0|0|0|0|0|0|0|
1|700|125|1|remurphy||Murphy, Reed-SB-Days|6000|2022_DAYS_SB|Vacation1|1666274186|01102022|31122023|48000|0|0|0|0|0|0|0|0|
1|700|520|1|520_login||520, 520|701|701_YB|YB_rule1|1663148638|04092022|30122023|47340|0|0|0|1440|0|0|0|0|
1|700|521|1|||521, 521|8000|TOG350_TOR|TOG350_AT|1620927369|01052021|31122021|0|0|0|0|0|0|0|0|0|
1|700|523|1|L_523||523, 523|701|701_YB|YB_rule1|1663148638|04092022|30122023|47340|0|0|0|0|0|0|0|0|
1|700|524|1|524||Parker, John|500|500_SB_Rule|Wait List|1666636335|01012022|31122022|4800|0|0|0|0|0|0|0|0|
1|700|524|1|524||Parker, John|500|500_SB_Rule|Vacation|1666722984|01012022|31122022|12000|0|0|0|0|0|0|0|0|
1|700|524|1|524||Parker, John|500|500_SB_Rule|SB_Only|1665483113|11092022|30122023|34020|0|0|0|0|0|0|0|0|
1|700|524|1|524||Parker, John|500|500_SB_Rule|Sick|1666636335|01012022|31122022|4800|0|0|0|0|0|0|0|0|
1|700|524|1|524||Parker, John|500|500_SB_Rule|Special|1666636335|01012022|31122022|2400|0|0|0|0|0|0|0|0|
1|700|524|1|524||Parker, John|500|500_SB_Rule|Unpaid|1666722984|01012022|31122022|2400|0|0|0|0|0|0|0|0|
1|700|526|1|||Rogers, Patty|500|500_SB_Rule|FullTime|1658938124|01012023|26082023|7380|0|0|0|0|0|0|0|0|
1|700|526|1|||Rogers, Patty|500|500_SB_Rule|SB_Only|1663146487|11092022|30122023|30000|0|0|0|0|0|0|0|0|
1|700|526|1|||Rogers, Patty|500|500_SB_Rule|Sick|1640111992|01012022|31122022|4620|0|0|0|0|0|0|0|0|
1|700|526|1|||Rogers, Patty|500|500_SB_Rule|Special|1666722984|01012022|31122022|2400|0|0|0|0|0|0|0|0|
1|700|526|1|||Rogers, Patty|500|500_SB_Rule|Unpaid|1666722984|01012022|31122022|2400|0|0|0|0|0|0|0|0|
1|700|526|1|||Rogers, Patty|500|500_SB_Rule|Vacation|1666722984|01012022|31122022|7200|0|0|0|0|0|0|0|0|
1|700|526|1|||Rogers, Patty|500|500_SB_Rule|Vacation1|1648034302|20032022|30072022|1200|0|0|0|0|0|0|0|0|
1|700|526|1|||Rogers, Patty|500|500_SB_Rule|Vacation2|1648032129|||0|0|0|0|0|0|0|0|0|
1|700|526|1|||Rogers, Patty|500|500_SB_Rule|Vacation3|1648034302|||0|0|0|0|0|0|0|0|0|
1|700|526|1|||Rogers, Patty|500|500_SB_Rule|Wait List|1666722984|01012022|31122022|4800|0|0|0|0|0|0|0|0|
1|700|800003|1|800003||800003, 800003|700|NotActive Request|Vacation|1663148565|04092022|30122023|47340|0|0|0|1800|0|0|0|0|
1|700|800004|1|800004||800004, 800004|700|NotActive Request|Vacation|1663148565|04092022|30122023|47340|0|0|0|1440|0|0|0|0|
1|700|800005|1|800005||800005, 800005|700|NotActive Request|Vacation|1663148565|04092022|30122023|47340|0|0|0|0|0|0|0|0|
1|700|800007|1|800007||800007, 800007|6000|2022_DAYS_SB|Vacation3|1665525793|01012022|31122023|0|0|0|0|0|0|0|0|0|
1|700|800007|1|800007||800007, 800007|6000|2022_DAYS_SB|Vacation2|1670425954|01012022|31122023|102240|0|0|0|0|0|0|0|0|
1|700|800007|1|800007||800007, 800007|6000|2022_DAYS_SB|Vacation1|1665525793|01012022|31122023|48000|0|0|0|0|0|0|0|0|
1|700|800008|1|800008||Pastor, Robert|500|500_SB_Rule|Vacation|1665666274|||0|0|0|0|0|0|0|0|0|
1|700|800008|1|800008||Pastor, Robert|500|500_SB_Rule|Unpaid|1665666274|||0|0|0|0|0|0|0|0|0|
1|700|800008|1|800008||Pastor, Robert|500|500_SB_Rule|Special|1665666274|||0|0|0|0|0|0|0|0|0|
1|700|800008|1|800008||Pastor, Robert|500|500_SB_Rule|Sick|1665666274|||0|0|0|0|0|0|0|0|0|
1|700|800008|1|800008||Pastor, Robert|500|500_SB_Rule|SB_Only|1666347541|11092022|30122023|30000|0|0|0|0|0|0|0|0|
1|700|800008|1|800008||Pastor, Robert|500|500_SB_Rule|Wait List|1665666274|||0|0|0|0|0|0|0|0|0|
1|8000|800001|1|800001a||test, test|8000|TOG350_TOR|TOG350_AT|1620927369|01052021|31122021|2400|0|0|0|0|0|0|0|0|
1|8000|800001|1|800001a||test, test|8000|TOR_2020|Waitlist|1586958791|||0|0|0|0|0|0|0|0|0|
1|8000|800001|1|800001a||test, test|8000|TOR_2020|et1|1567596497|31122019|31122020|12000|0|0|0|0|0|0|0|0|
1|8000|800002|1|800002||800002, 800002|8000|TOG350_TOR|TOG350_AT|1620927369|01052021|31122021|2400|0|0|0|0|0|0|0|0|
1|8000|800002|1|800002||800002, 800002|8000|TOR_2020|Waitlist|1586958791|||0|0|0|0|0|0|0|0|0|
1|8000|800002|1|800002||800002, 800002|8000|TOR_2020|et1|1567596497|31122019|31122020|12000|0|0|0|0|0|0|0|0|
1|70000|2345|1|2345||Manning, Tawana|8000|TOG350_TOR|TOG350_AT|1620927369|01052021|31122021|0|0|0|0|0|0|0|0|0|2345
1|70000|2345|1|2345||Manning, Tawana|8000|TOR_2020|Waitlist|1586958791|31122019|31122020|2400|0|0|0|0|0|0|0|0|2345
1|70000|2345|1|2345||Manning, Tawana|8000|TOR_2020|et1|1586958791|31122019|31122020|12000|0|0|0|0|0|0|0|0|2345
1|70000|70001|1||70001|Merrick, Clark|450|Test450_Rule|TOG450_AT|1613002209|10012021|31122021|3600|0|0|0|480|0|0|0|0|70001
1|70000|70500|1|70500|rw70500|Williams, Ryan|500|500_SB_Rule|Vacation|1666099288|01012022|31122022|9600|0|0|0|0|0|0|0|0|rw70500
1|70000|70500|1|70500|rw70500|Williams, Ryan|500|500_SB_Rule|Unpaid|1666099288|01012022|31122022|2400|0|0|0|0|0|0|0|0|rw70500
1|70000|70500|1|70500|rw70500|Williams, Ryan|500|500_SB_Rule|Special|1666099288|01012022|31122022|2400|0|0|0|0|0|0|0|0|rw70500
1|70000|70500|1|70500|rw70500|Williams, Ryan|500|500_SB_Rule|Sick|1666099288|01012022|31122022|4800|0|0|0|0|0|0|0|0|rw70500
1|70000|70500|1|70500|rw70500|Williams, Ryan|500|500_SB_Rule|SB_Only|1666347541|11092022|30122023|30000|0|0|0|0|0|0|0|0|rw70500
1|70000|70500|1|70500|rw70500|Williams, Ryan|500|500_SB_Rule|Wait List|1666099288|01012022|31122022|9600|0|0|0|0|0|0|0|0|rw70500
1|70000|70505|1|||Wu 70505, Yi 70505|450|Test450_Rule|TOG450_AT|1613002209|10012021|31122021|4800|0|0|0|480|0|0|0|0|
1|70000|70506|1|||Wu 70506, Yi 70506|450|Test450_Rule|TOG450_AT|1613002209|10012021|31122021|4800|0|0|0|480|0|0|0|0|
PIPE empty results
View code
#fields:custID|muID|tvID|acdID|logonID|ssn|agentName|vacGroup|vacYear|vacType|modify|from|to|earned|debited|coFrom|coTo|selected|taken|credited|minFullWeeks|maxPartialHours|externalID
#sort:custID,muID,tvID,acdID,logonID,ssn,agentName,vacGroup,vacYear,vacType,modify,from,to,earned,debited,coFrom,coTo,selected,taken,credited,minFullWeeks,maxPartialHours,externalID
Agent Vacation Summary DTD
View code
<?xml version="1.0"?>
<!ELEMENT agentVacationSummary ((allFields | fieldList), sortOrder?)>
<!ELEMENT fieldList (fields)>
<!ELEMENT sortOrder (fields)>
<!ELEMENT fields (custID | muID | tvID | acdID | logonID | ssn | agentData |
agentName | vacGroup |vacYear | vacType | modify | from | to | earned | debited |
coFrom | coTo | selected | taken | credited | minFullWeeks | maxPartialHours |
externalID)+>
<!ELEMENT allFields EMPTY>
<!ELEMENT custID EMPTY>
<!ELEMENT muID EMPTY>
<!ELEMENT tvID EMPTY>
<!ELEMENT acdID EMPTY>
<!ELEMENT logonID EMPTY>
<!ELEMENT ssn EMPTY>
<!ELEMENT agentData (#PCDATA)>
<!ELEMENT agentName EMPTY>
<!ELEMENT vacGroup EMPTY>
<!ELEMENT vacYear EMPTY>
<!ELEMENT vacType EMPTY>
<!ELEMENT modify EMPTY>
<!ELEMENT from EMPTY>
<!ELEMENT to EMPTY>
<!ELEMENT earned EMPTY>
<!ELEMENT debited EMPTY>
<!ELEMENT coFrom EMPTY>
<!ELEMENT coTo EMPTY>
<!ELEMENT selected EMPTY>
<!ELEMENT taken EMPTY>
<!ELEMENT credited EMPTY>
<!ELEMENT minFullWeeks EMPTY>
<!ELEMENT maxPartialHours EMPTY>
<!ELEMENT externalID EMPTY>
Agent Vacation Summary Advanced Configuration File XML Example
View code
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE exportList SYSTEM "exportList.dtd">
<exportList dateFormat="mmddyy" timeFormat="12" header="on">
<entityList>
<cust>1</cust>
<vacList>
<vac>
<vacGrp>1</vacGrp>
<vacYear>Eastern 2020 PTO</vacYear>
<vacYear>Eastern 2019 PTO</vacYear>
<vacYear>Eastern 2018 PTO</vacYear>
</vac>
</vacList>
</entityList>
<agentVacationSummary>
<inputFile>/totalview/tvsys/support/agtVacation/conf.in.xml</inputFile>
<outputFile>/totalview/tvsys/support/agtVacation/data.txt</outputFile>
</agentVacationSummary>
</exportList>