0 comments

PeopleSoft Tables with Public privilege

SELECT table_schema  GRANTOR, PRIVILEGEFROM all_TAB_PRIVSWHERE GRANTEE = 'PUBLIC'AND GRANTOR  <> 'SYS'AND GRANTOR  <> 'SYSTEM'and table_schema = 'SYSADM'order by 1,2,3,4; ...

0 comments

Employee Death Detail Report SQL PeopleSoft

SELECT (A.EMPLID)"GPID",(SELECT PED.ALTER_EMPLID FROM SYSADM.PS_PERS_DATA_EFFDT PED WHERE PED.EMPLID = A.EMPLID ANDPED.EFFDT = (SELECT MAX(PED1.EFFDT) FROM SYSADM.PS_PERS_DATA_EFFDT PED1 WHERE PED1.EMPLID =PED.EMPLID)) "GID",(A.DT_OF_DEATH)"DATE OF DEATH",B.HR_STATUS,B.EMPL_RCD,B.EFFDT,B.EFFSEQ,B.ACTION,B.ACTION_REASON,B.REG_REGION FROM SYSADM.PS_CURRENT_JOB B, SYSADM.PS_PERSON A WHERE A.EMPLID = B.EMPLID AND ...