HRS_PREMPLH_VW

(SQL View)
 Index Back

Applicant Pre-Empl Status View

Contains summary status information for pre-employment requests for applicants. Joins in vendor information for page display purposes.

SELECT A.HRS_PERSON_ID ,A.HRS_VENDOR_ID ,A.HRS_PREMPL_PERS_ID ,A.PREEMPLOY_REF_NBR ,A.REQUEST_DT ,A.ORIGINATOR_ID ,A.HRS_PREEMPL_STATUS ,A.HRS_ADJUDICATION ,A.STATUS_DT ,A.COMPLETED ,A.COMPLETE_DATE ,B.HRS_SHOW_ADUJ ,B.HRS_VIEW_DETAILS FROM PS_HRS_APP_PREMPLH A , PS_HRS_PREMPL_VNDR B WHERE A.HRS_VENDOR_ID = B.HRS_VENDOR_ID AND B.HRS_VERSION = ( SELECT MAX(C.HRS_VERSION) FROM PS_HRS_PREMPL_VNDR C WHERE B.HRS_VENDOR_ID = C.HRS_VENDOR_ID)

# 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_VENDOR_ID Number(15,0) DECIMAL(15) NOT NULL Integration Vendor ID

Prompt Table: HRS_VENDOR_I

3 HRS_PREMPL_PERS_ID Number(15,0) DECIMAL(15) NOT NULL Pre-Employment Person Id
4 PREEMPLOY_REF_NBR Character(12) VARCHAR2(12) NOT NULL Pre-employment reference number.
5 REQUEST_DT Date(10) DATE Request Date
6 ORIGINATOR_ID Character(11) VARCHAR2(11) NOT NULL Originator's ID

Prompt Table: HRS_ORGN_NM_VW

7 HRS_PREEMPL_STATUS Character(50) VARCHAR2(50) NOT NULL Status of a pre-employment request.
8 HRS_ADJUDICATION Character(50) VARCHAR2(50) NOT NULL Status of abjudication.
9 STATUS_DT Date(10) DATE NOT NULL Status Date

Default Value: %date

10 COMPLETED Character(1) VARCHAR2(1) NOT NULL Completed

Y/N Table Edit

Default Value: N

11 COMPLETE_DATE Date(10) DATE Date Completed
12 HRS_SHOW_ADUJ Character(1) VARCHAR2(1) NOT NULL Display Adjudication

Y/N Table Edit

13 HRS_VIEW_DETAILS Character(1) VARCHAR2(1) NOT NULL View Results on External Site

Y/N Table Edit