This page (revision-11) was last changed on 26-Nov-2021 10:22 by kparrott

This page was created on 26-Nov-2021 10:22 by mmcfarland

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
11 26-Nov-2021 10:22 25 KB kparrott to previous
10 26-Nov-2021 10:22 25 KB mmcfarland to previous | to last
9 26-Nov-2021 10:22 25 KB mmcfarland to previous | to last
8 26-Nov-2021 10:22 25 KB mmcfarland to previous | to last
7 26-Nov-2021 10:22 25 KB mmcfarland to previous | to last
6 26-Nov-2021 10:22 25 KB mmcfarland to previous | to last
5 26-Nov-2021 10:22 24 KB mmcfarland to previous | to last
4 26-Nov-2021 10:22 24 KB mmcfarland to previous | to last
3 26-Nov-2021 10:22 24 KB mmcfarland to previous | to last
2 26-Nov-2021 10:22 646 bytes mmcfarland to previous | to last
1 26-Nov-2021 10:22 647 bytes mmcfarland to last

Page References

Incoming links Outgoing links
WEB SERVICES...nobody
WEB SERVICES

Version management

Difference between version and

At line 8 changed one line
__Purpose__\\
!Purpose
At line 49 changed one line
|DEPOSIT1_BANK_ACCOUNT|Character 30|No|The bank account for direct deposit. When the DEPOSIT1_BANK_LOCATION is defined, then this field is mandatory.
|DEPOSIT1_BANK_ACCOUNT|Character 30|No|The bank account number for direct deposit. When the DEPOSIT1_BANK_LOCATION is defined, then this field is mandatory.
At line 52 changed one line
|DEPOSIT1_PAY_REMAINING|Character 1|No|If any amount is left to be paid into this account, indicate this with a “1” in this field. One of DEPOSIT1_AMOUNT, NET_PAY_PERCENT or PAY_REMAINING must be defined if DEPOSIT1_BANK_LOCATION is defined.
|DEPOSIT1_PAY_REMAINING|Character 1|No|If any amount is left to be paid into this account, enter “1” in this field. One of DEPOSIT1_AMOUNT, NET_PAY_PERCENT or PAY_REMAINING must be defined if DEPOSIT1_BANK_LOCATION is defined.
At line 54 changed 4 lines
|DEPOSIT2_BANK_ACCOUNT|Character 30|No|The bank account for direct deposit. When the DEPOSIT1_BANK_LOCATION is defined, then this field is mandatory.
|DEPOSIT2_AMOUNT|Number|No|The dollar amount to be deposited into this account each pay. One of DEPOSIT1_AMOUNT, NET_PAY_PERCENT or PAY_REMAINING must be defined if DEPOSIT1_BANK_LOCATION is defined.
|DEPOSIT2_NET_PAY_PERCENT|Number|No|The percentage of net pay to be deposited into this account each pay. One of DEPOSIT1_AMOUNT, NET_PAY_PERCENT or PAY_REMAINING must be defined if DEPOSIT1_BANK_LOCATION is defined.
|DEPOSIT2_PAY_REMAINING|Character 1|No|If any amount is left to be paid into this account, indicate this with a “1” in this field. One of DEPOSIT1_AMOUNT, NET_PAY_PERCENT or PAY_REMAINING must be defined if DEPOSIT1_BANK_LOCATION is defined.
|DEPOSIT2_BANK_ACCOUNT|Character 30|No|The bank account number for direct deposit. When the DEPOSIT2_BANK_LOCATION is defined, then this field is mandatory.
|DEPOSIT2_AMOUNT|Number|No|The dollar amount to be deposited into this account each pay. One of DEPOSIT2_AMOUNT, NET_PAY_PERCENT or PAY_REMAINING must be defined if DEPOSIT2_BANK_LOCATION is defined.
|DEPOSIT2_NET_PAY_PERCENT|Number|No|The percentage of net pay to be deposited into this account each pay. One of DEPOSIT2_AMOUNT, NET_PAY_PERCENT or PAY_REMAINING must be defined if DEPOSIT2_BANK_LOCATION is defined.
|DEPOSIT2_PAY_REMAINING|Character 1|No|If any amount is left to be paid into this account, enter “1” in this field. One of DEPOSIT2_AMOUNT, NET_PAY_PERCENT or PAY_REMAINING must be defined if DEPOSIT2_BANK_LOCATION is defined.
At line 83 changed one line
!!Processing
!Processing
At line 89 changed 3 lines
* For a re-hire, IDENTITIES and PERSONALS information are updated, if provided. If the data on the PERSONALS is being updated, the effective date is the HIRE_DATE.
* An EMPLOYMENTS record is created, along with an ASSIGNMENT and an ASSIGNMENT DETAILS record.
* The ASSIGNMENTS start date is the HIRE_DATE.
* For a re-hire, IDENTITIES and PERSONALS information are updated, if provided. If the PERSONALS data is being updated, the effective date is the HIRE_DATE.
* An EMPLOYMENT record is created, along with an ASSIGNMENT and an ASSIGNMENT DETAILS record.
* The ASSIGNMENT start date is the HIRE_DATE.
At line 119 changed 2 lines
|-22|Wage Rate defined but rate basis not defined
|-23|Employee State/Prov Code not defined or does not exist within Personality
|-22|Wage Rate defined but Rate Basis not defined
|-23|Employee State/Prov. Code not defined or does not exist within Personality
At line 128 changed one line
|-31|Phone number is not defined for Emergency Contact 1
|-31|Phone number is not defined for Emergency Contact 2
At line 148 changed 3 lines
|Accept|Character 50|Yes|Indicates what format the web service response is. Must be set to 'application/json'|application/json
|Content-Type|Character 50|Yes|Indicates what the format of the payload is. Must be set to 'application/json'|application/json
|Authorization|Character 50|Yes|OAuth Authorization Token __(see OAuth Security)__|Bearer nnnnnnnnnnnnnnn…
|Accept|Character 50|Yes|Defines what format the web service response is. Must be set to 'application/json'|application/json
|Content-Type|Character 50|Yes|Defines what the format of the payload is. Must be set to 'application/json'|application/json
|Authorization|Character 50|Yes|OAuth Authorization Token (see OAuth Security)|Bearer nnnnnnnnnnnnnnn…
At line 155 changed one line
__Purpose__\\
!Purpose
At line 174 changed one line
|TRANSACTION_TYPE|Character 16|Yes|An indicator of the type of transaction that is being transmitted. Data in each group is mandatory, based upon the transaction code here. Options are:\\* POSITION = Position code change \\* GROUP = Group code change \\* STATUS = New employment status, including TERMINATION \\* WAGE = New wage rate
|TRANSACTION_TYPE|Character 16|Yes|An indicator of the type of transaction that is being transmitted. Data in each group is mandatory, based upon the transaction code defined here. Options are:\\* POSITION = Position code change \\* GROUP = Group code change \\* STATUS = New employment status, including TERMINATION \\* WAGE = New wage rate
At line 188 changed 2 lines
!!Processing
The Work Flow module is utilized to trigger the calls to this web service. When an update is made on the ASSIGNMENT DETAILS table of POSITION_CODE, GROUP_CODE, EMPLOYMENT_STATUS or WAGE_RATE, the workflow fires and invokes this web service, passing the information as needed. \\ \\
!Processing
The Workflow module is utilized to trigger the calls to this web service. When an update is made on the ASSIGNMENT DETAILS table of POSITION_CODE, GROUP_CODE, EMPLOYMENT_STATUS or WAGE_RATE, the workflow fires and invokes this web service, passing the information as needed. \\ \\
At line 191 changed one line
Work Flows fire upon the commit of the updated/inserted/deleted data at the database level. If the EMPLOYMENT_STATUS change is one of a defined LEAVE or TERMINATION status, and the date of the transaction is a future date, then no action is taken. \\ \\
Workflows fire upon the commit of the updated/inserted/deleted data at the database level. If the EMPLOYMENT_STATUS change is one of a defined LEAVE or TERMINATION status, and the date of the transaction is a future date, then no action is taken. \\ \\
At line 193 changed one line
A pro-active workflow is executed on a scheduled basis to examine any employees who were put on leave in one of the defined LEAVE statuses or TERMINATED, which takes effect on the date the workflow is executing. All changes are then sent to the receiving system. \\ \\
A pro-active workflow is executed on a scheduled basis to examine any employees who were put on leave in one of the defined LEAVE statuses, or TERMINATED, which takes effect on the date the workflow is executing. All changes are then sent to the receiving system. \\ \\
At line 195 changed one line
!Work Flow UserCalcs
!Workflow UserCalcs
At line 202 changed 2 lines
\\ \\
The workflow is executed after each CRUD (create, retrieve, update, delete) operation on Assignment Details, Personals and Contacts calling the appropriate inbound web service into the receiving/3rd party system. Connection details to the inbound web service must be defined on the Define Custom Tables (IMCT) admin form.\\ \\
\\
The workflow is executed after each CRUD (create, retrieve, update, delete) operation on Assignment Details, Personals and Contacts, calling the appropriate inbound web service into the receiving/3rd party system. Connection details to the inbound web service must be defined on the Define Custom Tables (IMCT) admin form.\\ \\
At line 205 changed one line
The URL of the inbound service must be defined on the IMCT form in the Custom Data field. The Custom Key and Custom Subkey columns must be defined as follows:
The URL of the inbound service must be defined on IMCT, in the Custom Data field. The Custom Key and Custom Subkey columns must be defined as follows:
At line 221 changed 2 lines
!Pro-Active Work Flow
For Employee status changes dated in the future, which are not handled by the standard work flow, a pro-active work flow must be defined and scheduled to run each day. The UMPWF update process must have the following fields defined.
!Pro-Active Workflow
For employee status changes dated in the future, which are not handled by the standard workflow, a pro-active workflow must be defined and scheduled to run each day. The UMPWF update process must have the following fields defined:
At line 225 changed one line
* User Calc Code: the one that was created in the client's Personality data base
* User Calc Code: the one that was created in the client's Personality database
At line 235 changed one line
|User Defined Code|Employee is not a valid employee number
|User Defined Code|Employee number is not a valid employee number
At line 242 changed one line
__Purpose__\\
!Purpose
At line 253 changed one line
Time systems can send hours as well as an in/out times to Personality. The in/out times are not used, but must be stored for auditing purposes. There is an assumption that the Service does not provide rate overrides or position changes during this interaction.
Time systems can send hours as well as an In/Out times to Personality. The In/Out times are not used, but must be stored for auditing purposes. There is an assumption that the Service does not provide rate overrides or position changes during this interaction.
At line 266 changed 2 lines
!!Processing
As records are received by this web service, they are inserted into the LOADED PAY LINES table with a destination of the IPTR screen, with a status of “To Be Loaded”. Other than the validation that data is in the correct format, no further validation of data is done through this process. Additional validation is done through the Personality UPTR process.
!Processing
As records are received by this web service, they are inserted into the LOADED PAY LINES table with a destination of the IPTR form, with a status of “To Be Loaded”. Other than the validation that data is in the correct format, no further validation of data is done through this process. Additional validation is done through the Personality UPTR process.
At line 273 changed one line
|-1002|Field XXXXXX is a numeric field, but does not contain only numbers
|-1002|Field XXXXXX is a numeric field, but does not only contain numbers
At line 289 changed 3 lines
|Accept|Character 50|Yes|Indicates what format the web service response is. Must be set to 'application/json'|application/json
|Content-Type|Character 50|Yes|Indicates what the format of the payload is. Must be set to 'application/json'|application/json
|Authorization|Character 50|Yes|OAuth Authorization Token __(see OAuth Security)__|Bearer nnnnnnnnnnnnnnn…
|Accept|Character 50|Yes|Defines what format the web service response is. Must be set to 'application/json'|application/json
|Content-Type|Character 50|Yes|Defines what the format of the payload is. Must be set to 'application/json'|application/json
|Authorization|Character 50|Yes|OAuth Authorization Token (see OAuth Security)|Bearer nnnnnnnnnnnnnnn…
At line 295 changed one line
__Purpose__\\
!Purpose
At line 309 changed one line
|AS_OF_DATE|Date|Yes|The date, in YYYYMMDD format, that reflects the time this data was valid
|AS_OF_DATE|Date|Yes|The date the data is valid from, formatted in YYYYMMDD.
At line 312 changed one line
!!Processing
!Processing
At line 315 changed one line
As mentioned above in the work flow UserCalc section, the IMCT form holds the inbound URL, user name and password under the custom key LEAVE BALANCE. The fourth sub-key AUTHORIZATION is used to identify the type of security the outbound service uses. USERNAME indicates the user name and password sent in the header of the request.
As mentioned above in the Workflow UserCalc section, the IMCT form holds the inbound URL, user name and password under the custom key LEAVE BALANCE. \\ \\The fourth sub-key AUTHORIZATION is used to identify the type of security the outbound service uses. \\ \\USERNAME defines the user name and password sent in the header of the request.
At line 332 changed one line
|Description|In order to call High Line web services, users must first be on-boarded as a Client Application. Once this process is complete, users are provided a Client Identifier and a Client Secret. Users utilize these values to obtain a token to gain access to the web services the user has access to. \\ __NOTE:__ The token is only available for 1 hour, after that users must make another call to this service to obtain another token.
|Description|In order to call High Line web services, users must first be on-boarded as a Client Application. Once this process is complete, users are provided a Client Identifier and a Client Secret. Users utilize these values to obtain a token to gain access to the web services the user has access to. \\ __NOTE:__ Tokens have a life span of 1 hour, after which a new token must be retrieved.
At line 337 changed one line
This access token is included in the header of each inbound call to Personality’s web services as shown below under the Authorization key. \\ \\
This access token is included in the header of each inbound call to Personality’s web services, under the Authorization key. \\ \\
At line 364 changed one line
__Outbound logging__ from Personality is captured through Workflow logging and stored on the Executions table.
__Outbound logging__ from Personality is captured through Workflow logging and is stored on the Executions table.
At line 390 added one line
This page (revision-11) was last changed on 26-Nov-2021 10:22 by kparrottTop