1. Navigate to Change of Status records; My Daily Work à System Setup à Personnel Codes à Change of Status.
2. To add a new record, click New, to change click Edit.
3. To configure a Change of Status record, enter the following data:
o Define Change of Status transaction basic data and whether this transaction is affected by Salary Scale starting values, according to grade change.
o Select the built-in Increase Type, if relevant.
o Web Form’s Feilds: Specify the required changed fields which will be displayed upon selecting this transaction.
Tip
§ The following table lists the default queries specified for
all fields that can be used in Change of Status setup details at the
‘Web Form’s Fields’ link:
|
ID |
Field
Name |
Default
SQL Query |
|
1.
|
Grade |
SELECT Grade AS Code, GradeName AS NAME, GradeAName as ANAME FROM Grades |
|
2.
|
HR-Status |
SELECT HrStatus AS Code, HrStatusName AS NAME, HrstatusAName AS ANAME From HrStatus |
|
3.
|
Tax
Status |
Select itemno AS Code, edesc AS NAME, adesc AS ANAME from NasArrays where arrayname = 'taxstatus' |
|
4.
|
Military
Status |
Select itemno AS Code, edesc AS NAME, adesc AS ANAME from NasArrays where arrayname = 'milstatus' |
|
5.
|
Social
Status |
Select itemno AS Code, edesc AS NAME, adesc AS ANAME from NasArrays where arrayname = 'socstatus' |
|
6.
|
Job |
Select Job AS Code, JobName AS NAME, JobAName AS ANAME from Jobs |
|
7.
|
Organization |
SELECT OrganizationStructure.Organization as code, ISNULL(OrganizationStructure.OrganizationParent, 0) AS OrganizationParent, Organization.OrganizationName AS NAME, Organization.OrganizationAName
AS ANAME,Organization.OrganizationType, OrganizationStructure.VersionNo FROM OrganizationStructure INNER JOIN Organization ON
OrganizationStructure.Organization = Organization.Organization order by 4,3 |
|
8.
|
Position |
Select PositionNo AS Code, PositionName AS NAME, PositionAName AS ANAME FROM Positions |
|
9.
|
Location
|
Select LocationNo AS Code, LocationName
AS NAME, LocationAName AS ANAME FROM Location |
|
10.
|
Employer |
Select Employerid AS Code, EmployerName AS NAME,
EmployerAName AS ANAME FROM Employer |
|
11.
|
S.C
Status |
Select itemno as code, edesc as name, adesc AS ANAME FROM NasArrays where arrayName='scstatus' |
|
12.
|
SS Applicable |
Select itemno AS Code, edesc AS NAME, Adesc AS ANAME from
nasarrays where Arrayname = 'ssappl' |
|
13.
|
Self
Service Group |
SELECT SSGroup AS code, SSGroupName AS NAME, SSGroupAName
AS ANAME FROM SSGroup |
|
14.
|
Salary Scale |
SELECT SalaryScaleid AS Code,
SalaryScaleName AS NAME, SalaryScaleAName AS ANAME FROM SalaryScales |
|
15.
|
Contract
Type |
SELECT Contracttype AS Code, Contractname
AS NAME, ContractAName AS ANAME FROM ContractType |
Related Topics