HRS_OFF_APP_MRG

(SQL View)
 Index Back

Offer approval record


SELECT A.HRS_PERSON_ID , CASE WHEN EXISTS ( SELECT 1 FROM PS_HRS_OFFAPR_XREF C WHERE C.HRS_PERSON_ID = A.HRS_PERSON_ID) THEN 'Y' ELSE 'N' END AS HRS_OFF_APPR FROM PS_HRS_OFFER A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 HRS_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL Person Id
2 HRS_OFF_APPR Character(1) VARCHAR2(1) NOT NULL Offer approval
N=No
Y=Yes