HRS_XP_OFF_VW(SQL View) |
Index Back |
|---|---|
Batch Letter ViewOffer Letter template view |
| SELECT DISTINCT A.HRS_REPORT_DEFN_ID , A.HRS_REPORT_TMPL_ID FROM PS_HRS_OFFER A WHERE A.LETTER_PRINTED_DT IS NULL AND A.HRS_REPORT_DEFN_ID <> ' ' AND A.HRS_REPORT_TMPL_ID <> ' ' AND EXISTS ( SELECT 'X' FROM PS_HRS_STS_OFF_I C WHERE C.STATUS_AREA = '6' AND C.STATUS_CODE = A.STATUS_CODE AND C.OPEN_STS_IND = 'Y') AND EXISTS ( SELECT 'X' FROM PSXPRPTTMPL_VW B WHERE B.REPORT_DEFN_ID = A.HRS_REPORT_DEFN_ID AND B.TMPLDEFN_ID = A.HRS_REPORT_TMPL_ID) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | HRS_REPORT_DEFN_ID | Character(12) | VARCHAR2(12) NOT NULL | The Fusion Publisher Report Definition ID used by Recruiting |
| 2 | HRS_REPORT_TMPL_ID | Character(30) | VARCHAR2(30) NOT NULL | The Fusion publisher Report template ID used by RS. |