Sunday 14 October 2012

Another Presentation

Hi All,
 Our team is back with another presentation. Check it out!
Be Updated:)

Thursday 11 October 2012

Presentation on BI Publisher Classes and Integration Broker

Hi All,

    We updated another two presentations on BI publishers classes and Integration Broker. which cover some to many important point to not down.


Be updated for more updates :)




Wednesday 10 October 2012

Points to remember on PeopleSoft Benefits

With the HRMS Base Benefits business process you can:

·         Define the tables that will be used to build your benefit programs.
·         Manually enroll employees and dependents into a benefit program.
·         Perform nondiscrimination testing to determine whether or not your U.S. organization is in compliance with government regulations.
·         Print HIPPA reports.
·         Track and manage FMLA requests.
·         Calculate accrued leave awards and maintain employee leave balances.
·         Manage 403(b) savings plans.
·         Manage vacation buy and sell programs.
·         Administer COBRA coverage for qualified participants and their dependents.
·         Process retroactive benefits and deduction.
·         Send enrollment data to third-party administrators.
 Difference between BaseBenefits and Ben Adminstration:  
  Base Benefits will give you the ability to perform the following functions:
      Base Benefits provides you with the tools you need to manage your employee benefit programs. It enables you to set up your basic benefits system architecture and manually enroll employees and their dependents into the benefits system. This comprehensive benefits management solution supports a full range of benefit programs and plans, and provides you with everything you need to maintain your benefit records and to respond to inquiries from decision makers, managers, and other employees.

With the Base Benefits business process, you can:
• Define the tables you need to build your benefit programs.
• Manually enroll employees and dependents into benefit programs.
• Print HIPAA (Health Insurance Portability and Accountability Act) reports.
• Track and manage FMLA (Family Medical Leave Act) requests.
• Calculate accrued leave awards and maintain employee leave balances.
• Manage qualified savings plans and pension plans.
• Manage vacation buy and sell programs.
• Administer COBRA (Consolidated Omnibus Budget Reconciliation Act) coverage for qualified participants
and their dependents.
• Process retroactive benefits and deductions.
• Send enrollment data to third-party administrators.
• Send FEHB (federal employee health benefits) data to the OPM (Office of Personnel Management).


BenefitAdminstration: 

Benefits Administration is a separate add-on to Base Benefits. With it, you can perfrom the following additional functions:

When you build on PeopleSoft Enterprise Human Resources Base Benefits by adding PeopleSoft Enterprise
Benefits Administration, you can:
• Automate eligibility checking and respond to Human Resource events that might impact benefits enrollment,
based on your eligibility and event rules.
• Administer multiple, simultaneous plan years, according to enrollment rules that you define.
• Calculate benefit costs and coverage amounts independent of PeopleSoft Enterprise Payroll for North
America.
• Define and process a variety of flexible credits, both general and plan-based.
• For federal users, administer multiple, simultaneous open seasons for different benefit plan types.

• Establish the foundation for implementing self-service enrollment using PeopleSoft Enterprise eBenefits.
• Define flexible spending account (FSA) information for employees.
• Process healthcare and dependent care FSA claims.
• Track and view claim and payment data.
Tables:


PS_VENDOR
PS_BENEF_COMMENT
PS_BN_RATE_TBL*
PS_DEPENDENT_BENEF
PS_BN_RATE_DATA*
PS_DEPENDENT_BENEF
PS_CALC_RULES_TBL
PS_DEP_BEN_EFF
PS_COVRG_CD_TBL
PS_DEP_BENEF_VW 
PS_DEDUCTION_TBL,
PS_DEP_BEN_ADDR
PS_BENEF_PLAN_TBL
PS_BEN_NAME
PS_BEN_DEFN_PGM
PS_DEP_BENEF_NID
PS_BEN_PROG_PARTIC
PS_DEPENDENT_PHONE
PS_BENEFIT_PARTICl
PS_HEALTH_PLAN_TBL
PS_BENEF_COMMENT
PS_HEALTH_PLAN_VW
PS_HEALTH_PLAN_LNG
PS_HEALTH_BENEFIT

* From 8.9 RateTables (age , salary,flatrate,svcrate ..) are consolidated into two tables as above.





Be updated for the updates coming soon....:)


 


Latest Presentations by Second Batch

Hi All!,
   We are back with our next batch of energetic and enthusiastic PeopleSoft Developers. We are here with another set of presentations by our employees and check them in this blog soon....
   The first  presentation is by Mr.Veneel Gunda on Payroll . His presentation covers the payroll tables and payroll processes including their navigations. This presentation has enough stuff for any beginner.
The next presentation is by Mr. Ismail on Global Payroll with  conceptual  explanation on Global Payroll.

Both are pretty good.  check them out!

Thanks to both  from Envytee.


Be updated for more updates :)

Sunday 5 August 2012

Upgrade from PS8.9 to PS9.1




Some of the  tables  that underwent changes from PS8.9 to PS9.1 version (fields added,fields deleted,renamed..) are listed below:
  1. PS_CDM_LIST :PRCSBURSTRPT  is added in 9.1 version
  2. PS_CO_STATETAX_TBL : SUI_MAX_GROSS, SUI_OVERRIDE are removed in 9.1 version
  3. PS_DEDUCTION_CLASS : SUPPRESS_GL Is replaced by EMPLR_MATCH_OPT
  4. PS_DEPT_TBL: no changes in PS9.1 Version
  5. PS_EARNINGS_TBL: PNA_USE_SGL_EMPL  is added in PS9.1 version
  6. PS_EMPLOYEES: SECURITY_CLEARANCE is renamed as SEC_CLEARANCE_TYPE in PS9.1 Version.
  7. PS_FLAT_RATE_TBL   is not available in PS9.1 version. It has been removed. Instead PS_BN_RATE_DATA, PS_BN_RATE_TBL  are added in PS9.1.
  8. PS_GARN_SPEC:  VNDOR_LOC is added in PS9.1 version
  9. PS_INSTALLATION Table also undergone changes from PS8.9 TO ps9.1 version
  10. PS_JOB: SETID_EMPL_CLASS is added in PS9.1 Version
  11. PS_JOB_JR:SUSBTIT_REASON_ESP,SUSBTIT_EMPLID_ESP, PART_SUBROGTN_ESP,LABOR_RLTNSHIP_ESP,LABOR_RLTNSHIP_ESP, INACTIVITY_TYP_ESP, PART_STRK_ACT_ESP
  12. PS_JOBCODE_TBL:AVAIL_TELEWORK,GVT_NFC_FUNCTN_CD,GVT_NFC_PI_IND_OVR, GVT_OFF_TITLEPREFX, LASTUPDDTTM,LASTUPDOPRID,MIL_RANK, MILITARY_SERVICE are added in PS9.1. 
  13. JOB_PROFILE_ID in PS8.9 is renamed as KEY_JOBCODE in PS9.1 version
  14. PS_PAY_TAX : WORK_PSD_CD, RES_PSD_CD are removed in PS9.1 version.

Important  SQLS:
To find the structure of a table :
Exec   sp_columns   <Table_Name>
Eg: exec  sp_columns  PS_JOB 
To find the navigation of a Component Online:
SQL:
SELECT a.portal_name,                         
e.portal_label AS parent4_folder,
d.portal_label AS parent3_folder,
c.portal_label AS parent2_folder,    
b.portal_label AS parent_folder,
a.portal_label AS component            
FROM psprsmdefn a
LEFT JOIN psprsmdefn b ON b.portal_name = a.portal_name
AND b.portal_objname = a.portal_prntobjname
LEFT JOIN psprsmdefn c ON c.portal_name = b.portal_name
AND c.portal_objname = b.portal_prntobjname
LEFT JOIN psprsmdefn d ON d.portal_name = c.portal_name
AND d.portal_objname = c.portal_prntobjname
LEFT JOIN psprsmdefn e ON e.portal_name = d.portal_name
AND e.portal_objname = d.portal_prntobjname
WHERE a.portal_reftype = 'C'
AND a.portal_uri_seg2 = 'ADM_APPL_MAINTNCE'(Use your component name here to find its navigation) 
Alternative  Query(Oracle):
SELECTdistinctA.ROLENAME, A.CLASSID,IN2.navigation,'/EMPLOYEE/ERP/c/'||MI.MENUNAME ||'.'||PNLGRPNAME ||'.GBL' AS NAVIGATION1,
C.MENUNAME, C.BARNAME, C.BARITEMNAME, C.PNLITEMNAME, C.DISPLAYONLY, C.AUTHORIZEDACTIONS, D.PAGEACCESSDESCR,B.ROLENAME
FROM PSROLECLASS A, PSROLEDEFN B, PSAUTHITEM C, PSPGEACCESSDESC D ,PSMENUITEM MI,
(select SYS_CONNECT_BY_PATH(A.PORTAL_LABEL,'->') navigation, '/EMPLOYEE/ERP/c/' || PORTAL_URI_SEG1 || '.' || PORTAL_URI_SEG2 || '.' || PORTAL_URI_SEG3 url
from (SELECT distinct A.PORTAL_NAME, A.PORTAL_LABEL, A.PORTAL_OBJNAME, a.PORTAL_PRNTOBJNAME,
A.PORTAL_URI_SEG1, A.PORTAL_URI_SEG2, A.PORTAL_URI_SEG3, A.PORTAL_REFTYPE
FROM PSPRSMDEFN A
WHERE
portal_name = 'EMPLOYEE' and
portal_objname <> portal_prntobjname and
not exists (
select 'x'
from PSPRSMSYSATTRVL
where portal_name = A.PORTAL_NAME AND
portal_Reftype = A.PORTAL_REFTYPE and
portal_objname = A.PORTAL_OBJNAME and
PORTAL_ATTR_NAM = 'PORTAL_HIDE_FROM_NAV' and
A.PORTAL_OBJNAME not in ('CO_NAVIGATION_COLLECTIONS', 'PORTAL_BASE_DATA')
)
) A
start with A.portal_prntobjname = 'PORTAL_ROOT_OBJECT'
connect by prior A.portal_objname = A.portal_prntobjname
) IN2
WHERE A.ROLENAME = B.ROLENAME
AND A.CLASSID = C.CLASSID
AND C.MENUNAME NOT IN ('WEBLIB_MENU')
AND C.BARNAME NOT IN ('FieldFormula')
—AND A.ROLENAME = 'GL_GENERIC_ROLE'
AND D.AUTHORIZEDACTIONS = C.AUTHORIZEDACTIONS
AND C.MENUNAME = MI.MENUNAME
AND C.BARNAME = MI.BARNAME
AND C.BARITEMNAME = MI.ITEMNAME
and url='/EMPLOYEE/ERP/c/'||MI.MENUNAME ||'.'||PNLGRPNAME ||'.GBL' and URL like '%CSG_PROMOTION_DEF1%' (from wiki )