HRMS Terminologies

Salary Admin Plan.
A salary administration plan defines a high-level distinction for a grouping of workers that points to the salary controls that are in place for them, including standard hours, salary increase guidelines, and review rating guidelines A salary plan, grade, or step is not required when saving a job record for a worker.

---

Job Code

---

Job Family

---

Job Function

---

Job Task

---

Job Code

---

Workgroup

---

Task Group

---

Pay Groups

Pay Groups are created based on                   

1.    We define separate Pay groups for payroll & Absence in any organization.

a)    Payroll Elements and absence element are different. Like

Payroll: - Earning, deduction, Taxes, One time Payroll etc.

Absence :- Absence Take, entitlement, Balance accumulator, adjustments formulas etc.

b)    Payroll rules and absence rules are different, Rounding rule, Prorate rule, and Accruals rules. Etc.

c)     Payroll processing different then Absence likes

Payroll :- earnings, deductions, Compensation, Additional Pay, Tax calculations etc.

Absence: - Balance accumulator, Absence entitlement, Calculation Formula triggers etc.

2.    Employee has same Pay groups when they share same payroll or absence characteristics.

d)     Absence & payroll pay period is same (monthly, weekly etc.)

e)     Pay Frequency

f)      Pay rate is same

g)    Pay component like (Basic pay, Special Pay, variable pay etc.)

3.    Hourly employee will have different pay group, as frequency of pay is different and  their pay or absence need to be proceed & paid on daily basis. Salaried employee has rules different the Hourly employee.

4.    Companies will have difference Pay group for different Country, some time for specific business Group they create separate Pay Groups.

5.    Peoples at executive level will have separate Pay group for security requirement.

6.    For contractual employee we can make a separate Paygroup,If the contract is such a way that make absence & payroll characterizer different fro then from local employee.

7.    Generally we have same playgroup for employee's and contractors.

SQL for Project Consolidation/Merge Check

========================================================================================
                  Project Details Quary :
========================================================================================
Step 1 : Identify No. of objects that are not present in the consolidated project
Step 2 : Object Count of all Project & consolidated Project
Step 3 : Project dependancy with each other

==========================================================================
Step 1 : Identify No. of objects that are not present in the consolidated project
==========================================================================
/*No. of objects that are not present in the consolidated project*/
SELECT   Count(objecttype) FROM PSPROJECTITEM
 WHERE  PROJECTNAME IN ('UNBLR_TAM_CR_681_SR', 'UNBLR_TAM_CR681_PRINT')  -- List of Induvisual Project
 and OBJECTVALUE1||'.'||OBJECTVALUE2||'.'||OBJECTVALUE3||'.'||OBJECTVALUE4  Not IN (
select Distinct OBJECTVALUE1||'.'||OBJECTVALUE2||'.'||OBJECTVALUE3||'.'||OBJECTVALUE4  FullObject  FROM PSPROJECTITEM
 WHERE  PROJECTNAME IN ('UNBLR_TAM_BATCHIV_2_23FEB2012'))  -- Consolidated Project
/*No. of objects (Object Typewise) that are not present in the consolidated project*/
SELECT  case objecttype
WHEN 0 THEN 'Record'
WHEN 2  THEN 'Field'
WHEN 5 THEN 'Page'
WHEN 30 THEN  'SQL'
WHEN 25 THEN  'Message Cateloge'
WHEN 44 THEN 'Page Peoplecode'
WHEN 46 THEN  'Component Peoplecode'
WHEN 4 THEN 'Translate Value'
WHEN 8 THEN 'Record Peoplecode'
WHEN 47 THEN 'Component Record peoplecode'
WHEN 48 THEN  'Component Record Field Peoplecode'
WHEN 58 THEN  'Application Package Peoplecode'
else
'Others :'|| objecttype
End objecttype,
 Count(objecttype) FROM PSPROJECTITEM
 WHERE  PROJECTNAME IN ('UNBLR_TAM_CR_623','UNBLR_TAM_CR_631','UNBLR_TAM_CR635', 'UNBKK_CR638','UNBKK_CR639', 'UNBLR_TAM_CR_643','UNBLR_TAM_CR_644','UNBLR_TAM_CR649','UNBLR_TAM_CR650','UNBLR_TAM_CR_661'
 ,'UNBLR_TAM_CR_662','UNBLR_TAM_CR665','UNBLR_TAM_CR668','UNBLR_TAM_CR_669','UNBLR_TAM_CR671','UNBLR_TAM_CR_673','UNBLR_TAM_CR674'
 ,'UNBLR_TAM_CR_675','UNBLR_TAM_CR677','UNBLR_TAM_CR_680','UNBLR_TAM_CR_691','UNBLR_TAM_CR_640','UNBLR_TAM_CR_618','UNBLR_TAM_DEF_641','UNBLR_TAM_DEF_637') -- List of Induvisual Project
 and OBJECTVALUE1||'.'||OBJECTVALUE2||'.'||OBJECTVALUE3||'.'||OBJECTVALUE4  Not IN (
select Distinct OBJECTVALUE1||'.'||OBJECTVALUE2||'.'||OBJECTVALUE3||'.'||OBJECTVALUE4  FullObject  FROM PSPROJECTITEM
 WHERE  PROJECTNAME IN ('UNBLR_TAM_BATCHIV_28NOV2011')) -- Consolidated Project
Group By  objecttype

/* List of objects that are not present in the consolidated project*/
select Distinct PROJECTNAME,
 case objecttype
WHEN 0 THEN 'Record'
WHEN 2  THEN 'Field'
WHEN 5 THEN 'Page'
WHEN 30 THEN  'SQL'
WHEN 25 THEN  'Message Cateloge'
WHEN 44 THEN 'Page Peoplecode'
WHEN 46 THEN  'Component Peoplecode'
WHEN 4 THEN 'Translate Value'
WHEN 8 THEN 'Record Peoplecode'
WHEN 47 THEN 'Component Record peoplecode'
WHEN 48 THEN  'Component Record Field Peoplecode'
WHEN 58 THEN  'Application Package Peoplecode'
else
'Others'|| objecttype
End objecttype,
OBJECTVALUE1, OBJECTVALUE2, OBJECTVALUE3, OBJECTVALUE4  FROM PSPROJECTITEM
 WHERE  PROJECTNAME IN ('UNBLR_TAM_CR_623','UNBLR_TAM_CR_631','UNBLR_TAM_CR635', 'UNBKK_CR638','UNBKK_CR639', 'UNBLR_TAM_CR_643','UNBLR_TAM_CR_644','UNBLR_TAM_CR649','UNBLR_TAM_CR650','UNBLR_TAM_CR_661'
 ,'UNBLR_TAM_CR_662','UNBLR_TAM_CR665','UNBLR_TAM_CR668','UNBLR_TAM_CR_669','UNBLR_TAM_CR671','UNBLR_TAM_CR_673','UNBLR_TAM_CR674'
 ,'UNBLR_TAM_CR_675','UNBLR_TAM_CR677','UNBLR_TAM_CR_680','UNBLR_TAM_CR_691','UNBLR_TAM_CR_640','UNBLR_TAM_CR_618','UNBLR_TAM_DEF_641','UNBLR_TAM_DEF_637')  -- List of Induvisual Project
 and OBJECTVALUE1||'.'||OBJECTVALUE2||'.'||OBJECTVALUE3||'.'||OBJECTVALUE4  Not IN (
select Distinct OBJECTVALUE1||'.'||OBJECTVALUE2||'.'||OBJECTVALUE3||'.'||OBJECTVALUE4  FullObject  FROM PSPROJECTITEM
 WHERE  PROJECTNAME IN ('UNBLR_TAM_BATCHIV_28NOV2011')) -- Consolidated Project

==========================================================================
Step 2 : Object Count of all Project & consolidated Project
==========================================================================

/* Object Count of all Project & consolidated Project*/
--------------------------------------------------------
SELECT  case A.objecttype
WHEN 0 THEN 'Record'
WHEN 2  THEN 'Field'
WHEN 5 THEN 'Page'
WHEN 30 THEN  'SQL'
WHEN 25 THEN  'Message Cateloge'
WHEN 44 THEN 'Page Peoplecode'
WHEN 46 THEN  'Component Peoplecode'
WHEN 4 THEN 'Translate Value'
WHEN 8 THEN 'Record Peoplecode'
WHEN 47 THEN 'Component Record peoplecode'
WHEN 48 THEN  'Component Record Field Peoplecode'
WHEN 58 THEN  'Application Package Peoplecode'
else
'Others'
End objecttype, ProjectCount, ConsolidateProjectCount FROm
(SELECT   objecttype,
 Count(objecttype) ProjectCount   FROM PSPROJECTITEM
 WHERE  PROJECTNAME IN  ('UNBLR_TAM_CR_629','UNBLR_TAM_CR_664_664B','UNBLR_TAM_DEF_671', 'UNBLR_TAM_DEF_673','UNBLR_TAM_DEF_674','UNBLR_TAM_DEF_675','UNBLR_TAM_DEF_678')  -- List of Induvisual Project
Group By  objecttype) A, (SELECT   objecttype,
 Count(objecttype) ConsolidateProjectCount FROM PSPROJECTITEM
 WHERE  PROJECTNAME IN ('UNBLR_TAM_BATCHIV_5_27MAR2012') -- Consolidated Project
Group By  objecttype) B
WHERE A.objecttype = B.objecttype(+)

==========================================================================
Step 3 : Project dependancy with each other
==========================================================================
/*Project dependancy with each other*/
-------------------------------------
SELECT  A.PROJECTNAME, B.PROJECTNAME ConflictingProject,  Count(A.objecttype) FROM PSPROJECTITEM A, PSPROJECTITEM B
 WHERE  A.PROJECTNAME IN ('UNBLR_TAM_CR_629','UNBLR_TAM_CR_664_664B','UNBLR_TAM_DEF_671', 'UNBLR_TAM_DEF_673','UNBLR_TAM_DEF_674','UNBLR_TAM_DEF_675','UNBLR_TAM_DEF_678')  -- List of Induvisual Project
  AND  B.PROJECTNAME IN  ('UNBLR_TAM_CR_629','UNBLR_TAM_CR_664_664B','UNBLR_TAM_DEF_671', 'UNBLR_TAM_DEF_673','UNBLR_TAM_DEF_674','UNBLR_TAM_DEF_675','UNBLR_TAM_DEF_678')  -- List of Induvisual Project
 and A.OBJECTVALUE1||'.'||A.OBJECTVALUE2||'.'||A.OBJECTVALUE3||'.'||A.OBJECTVALUE4  =  B.OBJECTVALUE1||'.'||B.OBJECTVALUE2||'.'||B.OBJECTVALUE3||'.'||B.OBJECTVALUE4
 and A.PROJECTNAME <> B.PROJECTNAME
 Group BY A.PROJECTNAME, B.PROJECTNAME

How to bypass Peoplesoft Login Page through HTML

Inputs for below HTML script is URL, UserID & Password.

<html>
<head>
</head>
<script LANGUAGE="JavaScript">
    function signin(form)
      {
      var now=new Date();
      form.timezoneOffset.value=now.getTimezoneOffset();
      return ;
      }
     
</script>
<body Onload="signin(login); login.submit();">
<form action="http://oms.in.oracle.com:8000/psp/fsm91dmo/EMPLOYEE/ERP/c/OR_EMP_DATA.OR_MGR_SEARCH_RPT.GBL?FolderPath=PORTAL_ROOT_OBJECT.EMPLOYEE_PORTAL.OMS_REPORTS&IsFolder=false&IgnoreParamTempl=FolderPath%2cIsFolder" method="post" id="login" name="login" autocomplete=off>
    <input type="hidden" name="timezoneOffset" value="0">
    <input type="hidden" id="userid" name="userid" value="sandeep.raghuwanshi">
    <input TYPE="hidden" id="pwd" name="pwd" value="123456">                                        
</form>
</body>
</html>     

Peoplesoft Recruitment module Table

HRS_LOCATION --INTERVIEW LOCATION DETAILS
HRS_CONTACT --COMPANY CONTACT DETAILS
HRS_JO_RCTR_RL ---RECRUITER ROLE
HRS_JO_DSC_TYP --POSTING DESCRIPTIONS
HRS_JO_PST_LIB --POSTING DESCRIPTIONS LIBRARY
HRS_JOB_OPENING ---JOB OPENING
HRS_STS_JO_I --JOB OPENING STATUS CODE
HRS_APPLICANT --APPLICANT DETAILS
HRS_RCMNT --RECRUITMENT SUMMARY
HRS_STS_REC_I --RECRUITMENT STATUS
HRS_APP_RTE --ROUTE
HRS_RCM_INT --]INTERVIEW DETAILS
HRS_STS_INT_I --]INTERVIEW STATUS CODES
HRS_OFFER --OFFER DETAILS
HRS_STS_OFF_I --OFFER STATUS
HRS_TEAM --TEAM DETAILS

Running XML Publisher report in AE using PS Query Data Source

Running XML Publisher report in AE using PS Query Data Source

/*fill prompt record*/

&rcdQryPrompts = &ReportDef.GetPSQueryPromptRecord();

If Not &rcdQryPrompts = Null Then

    If Not Prompt(&ReportDef.GetDataSource().Name, "",&rcdQryPrompts) Then         Exit;
    End-If;

    &ReportDef.ProcessReport(&sTemplateId, %Language_User, %Date, &sOutputFormat);

End-If;

Peoplecode for calling SQR 

Local ProcessRequest &RQST;

&sRunCntlId = "Test";
&aProcessType = "SQR Report"; /*(or "SQR Process")*/
&aProcessName = "MYSQRRPT";

&dttmRunDateTime = %Datetime;
&aTimeZone = "EST";
&aOutDestType = "WEB";
&aOutDestFormat = "PDF";

/* Create the ProcessRequest Object */
&RQST = CreateProcessRequest();

/* Set all the Required Properties */
&RQST.RunControlID = &aRunCntlId;
&RQST.ProcessType = &aProcessType;
&RQST.ProcessName = &aProcessName;

/* Set any Optional Properties for this Process */
&RQST.RunDateTime = &dttmRunDateTime;
&RQST.TimeZone = &aTimeZone;
&RQST.OutDestType = &aOutDestType;
&RQST.OutDestFormat = &aOutDestFormat;

/* Schedule the Process */
&RQST.Schedule();