DFW_HCM_APPL_NM

(SQL View)

SELECT RCMNT.HRS_PERSON_ID , ANAME.NAME , RCMNT.STATUS_CODE , RCMNT.HRS_ROW_UPD_DTTM FROM PS_HRS_RCMNT RCMNT , PS_HRS_APP_NAMES ANAME WHERE RCMNT.HRS_PERSON_ID = ANAME.HRS_PERSON_ID AND EXISTS ( SELECT 'X' FROM PS_HRS_RCMNT RCMNT2 WHERE RCMNT2.HRS_PERSON_ID = RCMNT.HRS_PERSON_ID AND RCMNT2.HRS_PROFILE_SEQ = RCMNT.HRS_PROFILE_SEQ) AND EXISTS ( SELECT 'X' FROM PS_HRS_APP_PROFILE PROF WHERE PROF.HRS_PERSON_ID = RCMNT.HRS_PERSON_ID AND PROF.HRS_PROFILE_SEQ = RCMNT.HRS_PROFILE_SEQ) AND RCMNT.status_code NOT IN ('110','005')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 HRS_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL Person Id

2 NAME Character(50) VARCHAR2(50) NOT NULL Name

3 STATUS_CODE Character(3) VARCHAR2(3) NOT NULL Identifies a status.

4 HRS_ROW_UPD_DTTM DateTime(26) TIMESTAMP Row Updated DateTime

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	HRS_PERSON_ID	Number(15,0)	DECIMAL(15) NOT NULL	Person Id
2	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
3	STATUS_CODE	Character(3)	VARCHAR2(3) NOT NULL	Identifies a status.
4	HRS_ROW_UPD_DTTM	DateTime(26)	TIMESTAMP	Row Updated DateTime