HR_SRCH_PRSDTM1

(SQL View)

SELECT PRS.EMPLID ,MAX(prs.LAST_CHILD_UPDDTM) ,MAX(jbcd.LASTUPDDTTM) ,MAX(P.LASTUPDDTTM) ,MAX(O.LAST_CHILD_UPDDTM) ,MAX(PT.LAST_CHILD_UPDDTM) , MAX(PT1.LASTUPDDTTM) ,MAX(A.LASTUPDDTTM ) ,MAX(N.LASTUPDDTTM) ,MAX(J.LASTUPDDTTM) ,MAX(C.LASTUPDDTTM) ,MAX(L.LASTUPDDTTM) ,MAX(B.LASTUPDDTTM) FROM PS_PERSON PRS LEFT OUTER JOIN PS_JOB J ON (PRS.EMPLID=J.EMPLID) LEFT OUTER JOIN PS_JOBCODE_TBL JBCD ON ( J.JOBcode=JBcD.JOBCODE AND J.SETID_JOBCODE=JBCD.SETID ) LEFT OUTER JOIN PS_POSITION_DATA P ON (J.POSITION_NBR=P.POSITION_NBR ) LEFT OUTER JOIN PS_PER_ORG_ASGN O ON(PRS.EMPLID=O.EMPLID) LEFT OUTER JOIN PS_PER_POI_TYPE PT ON(PRS.EMPLID=PT.EMPLID) LEFT OUTER JOIN PS_PER_POI_TYPE PT1 ON (PRS.EMPLID=PT1.EMPLID) LEFT OUTER JOIN PS_ADDRESSES A ON (PRS.EMPLID=A.EMPLID) LEFT OUTER JOIN PS_COMPANY_TBL C ON (J.COMPANY=C.COMPANY) LEFT OUTER JOIN PS_LOCATION_TBL L ON( J.SETID_LOCATION=L.SETID AND J.LOCATION=L.LOCATION ) LEFT OUTER JOIN PS_BUS_UNIT_TBL_HR B ON( J.BUSINESS_UNIT=B.BUSINESS_UNIT ) LEFT OUTER JOIN PS_NAMES N ON (PRS.EMPLID=N.EMPLID ) GROUP BY PRS.EMPLID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

2 HR_SRCH_LASTUPDTM1 DateTime(26) TIMESTAMP Last Updated Datetime

3 HR_SRCH_LASTUPDTM2 DateTime(26) TIMESTAMP Last Updated Datetime

4 HR_SRCH_LASTUPDTM3 DateTime(26) TIMESTAMP Last Updated Datetime

5 HR_SRCH_LASTUPDTM4 DateTime(26) TIMESTAMP Last Updated Datetime

6 HR_SRCH_LASTUPDTM5 DateTime(26) TIMESTAMP Last Updated Datetime

7 HR_SRCH_LASTUPDTM6 DateTime(26) TIMESTAMP Last Updated Datetime

8 HR_SRCH_LASTUPDTM7 DateTime(26) TIMESTAMP Last Updated Datetime

9 HR_SRCH_LASTUPDTM8 DateTime(26) TIMESTAMP Last Updated Datetime

10 HR_SRCH_LASTUPDTM9 DateTime(26) TIMESTAMP Last Updated Datetime

11 HR_SRCH_LSTUPDTM10 DateTime(26) TIMESTAMP Last Updated Datetime

12 HR_SRCH_LSTUPDTM11 DateTime(26) TIMESTAMP Last Updated Datetime

13 HR_SRCH_LSTUPDTM12 DateTime(26) TIMESTAMP Last Updated Datetime

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	HR_SRCH_LASTUPDTM1	DateTime(26)	TIMESTAMP	Last Updated Datetime
3	HR_SRCH_LASTUPDTM2	DateTime(26)	TIMESTAMP	Last Updated Datetime
4	HR_SRCH_LASTUPDTM3	DateTime(26)	TIMESTAMP	Last Updated Datetime
5	HR_SRCH_LASTUPDTM4	DateTime(26)	TIMESTAMP	Last Updated Datetime
6	HR_SRCH_LASTUPDTM5	DateTime(26)	TIMESTAMP	Last Updated Datetime
7	HR_SRCH_LASTUPDTM6	DateTime(26)	TIMESTAMP	Last Updated Datetime
8	HR_SRCH_LASTUPDTM7	DateTime(26)	TIMESTAMP	Last Updated Datetime
9	HR_SRCH_LASTUPDTM8	DateTime(26)	TIMESTAMP	Last Updated Datetime
10	HR_SRCH_LASTUPDTM9	DateTime(26)	TIMESTAMP	Last Updated Datetime
11	HR_SRCH_LSTUPDTM10	DateTime(26)	TIMESTAMP	Last Updated Datetime
12	HR_SRCH_LSTUPDTM11	DateTime(26)	TIMESTAMP	Last Updated Datetime
13	HR_SRCH_LSTUPDTM12	DateTime(26)	TIMESTAMP	Last Updated Datetime