HRS_DIAG_J_VW(SQL View) |
Index Back |
|---|---|
RS Diagnotstic view |
| SELECT DISTINCT C.HRS_SITE_ID , A.HRS_JOB_OPENING_ID FROM PS_HRS_JO_PST_DST A , PS_HRS_SOURCE B , PS_HRS_SOURCE_SITE C WHERE A.HRS_SOURCE_ID = B.HRS_SOURCE_ID AND B.HRS_SOURCE_ID = C.HRS_SOURCE_ID AND B.EFFDT= C.EFFDT AND C.EFFDT= ( SELECT MAX(X.EFFDT) FROM PS_HRS_SOURCE X WHERE X.HRS_SOURCE_ID = B.HRS_SOURCE_ID AND X.EFFDT <= %CurrentDateIn AND X.HRS_SOURCE_STATUS = '10') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | HRS_SITE_ID | Number(15,0) | DECIMAL(15) NOT NULL | Site ID |
| 2 | HRS_JOB_OPENING_ID | Number(15,0) | DECIMAL(15) NOT NULL | Job Opening Clone |