HRS_AL_LOG_VW(SQL View) |
Index Back |
|---|
| SELECT A.HRS_AL_LOG_ID , ' ' , ' ' , ' ' , A.HRS_SOURCE_ID , B.HRS_CHANNEL , C.HRS_RESOLUTION FROM PS_HRS_AL_LOG A , PS_HRS_AL_LOG_RES B , PS_HRS_AL_LOG_RES C WHERE A.HRS_AL_LOG_ID=B.HRS_AL_LOG_ID AND B.HRS_AL_LOG_ID=C.HRS_AL_LOG_ID AND C.HRS_ROW_UPD_DTTM IN ( SELECT MAX(D.HRS_ROW_UPD_DTTM) FROM PS_HRS_AL_LOG_RES D WHERE A.HRS_AL_LOG_ID=D.HRS_AL_LOG_ID) AND B.HRS_ROW_UPD_DTTM IN ( SELECT MIN(E.HRS_ROW_UPD_DTTM) FROM PS_HRS_AL_LOG_RES E WHERE A.HRS_AL_LOG_ID=E.HRS_AL_LOG_ID) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  HRS_AL_LOG_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Resume Extraction Queue ID |
| 2 | FIRST_NAME | Character(30) | VARCHAR2(30) NOT NULL | First Name |
| 3 | LAST_NAME | Character(30) | VARCHAR2(30) NOT NULL | Last Name |
| 4 | EMAIL_ADDR | Character(70) | VARCHAR2(70) NOT NULL | Email Address |
| 5 | HRS_SOURCE_ID | Number(15,0) | DECIMAL(15) NOT NULL |
Source ID
Prompt Table: HRS_SOURCEV_PT |
| 6 | HRS_CHANNEL | Character(3) | VARCHAR2(3) NOT NULL |
Communication Channel
10=Integration Framework 20=Email 30=Apply Online 40=Load Resume 50=Refer a Friend 60=Manager Entry 70=Log Update 80=Manage Applicant |
| 7 | HRS_RESOLUTION | Character(3) | VARCHAR2(3) NOT NULL |
Resolution State
10=Success 20=Rejected 30=Unresolved with Errors 40=Draft 50=Awaiting Resolution |