HRS_OFF_APPR_LN

(SQL View)
 Index Back

Related Language Record

Related Language Record for HRS_OFF_APPR_VW

SELECT X.HRS_PERSON_ID , X.HRS_RCMNT_ID , X.HRS_OFF_ID , Z.LANGUAGE_CD , Z.NAME_DISPLAY FROM PS_HRS_OFFAPR_XREF X , PS_EOAW_STEPINST S , PS_EOAW_USERINST U , PS_HRS_OFF_PEND_VW R , PS_HRS_PERSON_NM_L Z , PSOPRDEFN ZZ WHERE X.EOAWTHREAD_ID = S.EOAWTHREAD_ID AND X.EOAWPRCS_ID = S.EOAWPRCS_ID AND S.EOAWSTEP_INSTANCE = U.EOAWSTEP_INSTANCE AND R.HRS_PERSON_ID = X.HRS_PERSON_ID AND R.HRS_RCMNT_ID = X.HRS_RCMNT_ID AND R.HRS_OFF_ID = X.HRS_OFF_ID AND ZZ.OPRID = X.ORIGINATORID AND ZZ.EMPLID = Z.EMPLID AND X.EOAWPARENT_THREAD = ( SELECT MAX(Y.EOAWPARENT_THREAD) FROM PS_HRS_OFFAPR_XREF Y WHERE X.HRS_PERSON_ID = Y.HRS_PERSON_ID AND X.HRS_RCMNT_ID = Y.HRS_RCMNT_ID AND X.HRS_OFF_ID = Y.HRS_OFF_ID)

  • Related Language Record for HRS_OFF_APPR_VW

    • # 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_RCMNT_ID Number(15,0) DECIMAL(15) NOT NULL App Tracking Recruitment ID
    3 HRS_OFF_ID Number(15,0) DECIMAL(15) NOT NULL Offer ID
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Display Name - name formatted for Display based on the Country