My Daily Work à System Setup à Change of Status à
Change of Status.
1. To add a new record, click New, to change click Edit.
2. 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 Fields: Specify the required changed fields, which will be displayed upon selecting this transaction with option to select Hide Old Value & Accept new Value.
3.
User can Determines the validation period
from start date to end date, also can attach any file determining its
Description & Entry date.
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