Are these two tables able to be joined, or is there a table that links them together I am trying to write a SQL query to show Terminate Action Requests and the Reason for them. Thanks.   EDIT: I was able to join the ACTIONREQUESTS table to the S$USRA table and find the data I need in the PARAMETERS column, except its in XML. Does anyone have experience parsing information from XML in SQL SERVER 2008

we have a requirement to change the default Rating level to 0 rather 1  . Is there a way we can do it. The reason we are doing this when we create the PDF file its so confusing because our points starts from 0-3 but the graph shows from 1-4.  I have attached screen shot   Any help would be appreciated

HI, We currently have our HTML5 EMSS running on Citrix for both the internally and externally hosted sites.  We would like to have employees be able to load resumes to positions they are applying for on the external site.  Initial though was to remove Citrix and expose the HTML5 site.  Has anyone set this up  We are V10 and testing todate shows some of the paths to directories are built via javascript on the client side, making redirect at the firewall not possible.   Seems like HTML5 EMSS w...

We're in the planning stages of implementing Compensation Mgmt and Incentive bonuses.  How do we track employees moving in and out of groups in order to prorate the incentive

First post, so Hi and thanks for all the help you don't know you've already provided. v11.0.1.43,  single tenant, cloud, SQL Server.  Early stages of implementation. Per our business model, manager terminations do not go through HR for approval.  With 22k employees, HR relies on managers to handle their own terms with the expectation that they will do it correctly... In GHR, on the Terminate form, the delivered 'Eligible for Rehire' Boolean field is a rendered as a checkbox.  Our HR lead...

How do I locate the version of GHR  I know about searching for 'Platform Components' to locate Landmark and Grid versions but it doesn't show us the GHR/LTM version.   Thanks!

We are transferring from our previous job posting vendor to using Talent Management V10.1.1. When I use a variable in the job description template to post 'Education' or 'Summary'. I'd like to bold the header of 'Summary', but not the actual summary text. Also when posting the 'Education Specialization', the header is 'Education specialization', I'd like to capitalize the S in specialization. Any idea where I find where these variables are defined or if I need to do something special in the HTML...

We created an alias using a load balancer, but the HTML content that was configured is not showing.  We are using HTML5 Iframe, but the alias works fine, the page does not display correctly. What do we need to change to get it to display

We are looking for other client's experience in tracking (non-paid) non-employees in GHR, particularly when they might overlap. We have students and volunteers groups, some of which are also employees. Has anyone implemented a solution that works, or doesn't work and we can learn from it Any information or solutions would be greatly appreciated, thank you!

During one of our action approvals, the final approval is by a budgeting team that does not utilize LTM as they are constantly on-the-go.  We have the action request approval go to their email and they can select approve or reject from their email.  Our dilemma is that if they reject from the email, they do not have the ability to comment as to why it is being rejected.  Does anyone have a similar situation with a workaround that allows for an approver to comment and take action from their email...

We are updating procedures to make creation of new user id's more streamlined and timely.  In our current procedure the user id for system access cannot be created until the hiring of an employee is complete, in particular only after the employee id has been created.  Because of the volume of transactions processed by our central HR department, there may be delays before they have the opportunity to review, or 'audit', the transaction and complete the hire work unit which creates the employee id...

I need to query the export tables and need the CHANGEDFIELDS field as it doesn't exists on the ...EXPORT tables (WorkassignmentExport, EmployeeExport. What tables correlate that I can join to fetch this field Landmark V10.

Our database has one HROrganization and three legal entities.  How do we restrict an actor in Human Resources to be able to see resources assigned to one legal entity only

Hello, for those of you on TM, what is your deployment strategy for the general user population. Is the general user population using browser based java applet or local rich client install Did you encounter obstacles with either solution Was remote access a factor in the decision Thanks.

We are getting an error msg when registering on our Infor Career Self Service website. FIELD ORGANIZATION IS REQUIRED. Steps: Candidate opens Career Self Service website. Clicks Register. Completes Registration page. Clicks Continue. Error message - Field Organization is required. Candidate is not allowed to continue.

Looking for information on how we can lock down IPA process flows set up with a service.  We want only a select few individuals to be able to trigger these services and don't want these individuals to be able to access other services.   Thoughts  Thank You!

Viewing this topic as a DBA, I notice that some LTM tables have many indexes.   EMPLOYEE has 78 for example.  That seems way to many from a performance perspective.  Anyone care to comment on that

We are on LTM/GHR v11.0.0.25 and are wanting to try some mobile accessibility for Emp and Mgr Space.  Has anyone done this yet What is required Many thanks! Chris

if you have Global Human Resources, would that include Talent Acquisition and On-boarding, or are those separate modules.  We are having a discussion and can't get any straights answers from Lawson.

Hi! I am trying to upload a new 'SalaryStructurePayZone' to TM through Infor Spreadsheet Designer and am getting the following error message: 'Salary Structure Pay Zone' does not exist. I went to Salary Structures > Zones.. and I have zones in there. Anyone know what I might be doing wrong

We are in the process of upgrading to GHR Version 11.  We are currently on GHR Version 10.2, Landmark 10.1.1.31.  We are using Windows server with an Oracle Database. For this upgrade to V11, the intention was to move to the latest Landmark Version 11.0.1.8 and implement V11 Benefits and the Infor Onboarding tool.  Remaining on the Windows server and oracle database.   It was brought to our attention that the compatibility matrix was recently updated and Infor is no longer supporting this comb...

Hello, I am trying to add the address fields to the rehire form in Landmark TM - our HR users want to be able to update an employee's address when submitting a rehire. When I try to update the configuration - I am not able to add the address fields. I have tried doing so via LPL and also the configuration console. I was at the TechEd conference last month and learned that this is a common complaint in the Landmark TM. Anyone have any idea how to do this Thanks!

For instance, the S$ table for EMPLOYEE is S$EMPL.  What is the S$ table for EMPLOYEECONTACT

I am working on a project to sync the work emails between my LTM and S3 environments.  However, one problem I'm running into is that in LTM, there's no real way to determine which email is the work email versus any of the other emails unless you set the flag IsWorkEmail.  however I can find this flag in the background SQL database which is the tool I'm using to perform this sync.  Anyone have any methods to help identify work emails from all others and ways to access them directly from the backe...

Has anyone upgraded from landmark ltm version 10 to 11  We would just like to know if it is a smooth or painful transition.  We just found out that we have to be on 11 in order to go to the cloud.  Thank you!