HRS_BIP_JNOT_VW(SQL View) |
Index Back |
|---|---|
Used in XMLP report for Job OUsed in XMLP report for Job Opening |
| SELECT A.HRS_JOB_OPENING_ID , A.HRS_NOTE_SEQ , A.HRS_NOTE_DT , ' ' ,C.NAME_DISPLAY , A.HRS_JO_NOTE_AUD , ' ' , A.HRS_NOTES_SUBJ , HRS_NOTE ,A.HRS_ROW_ADD_OPRID FROM PS_HRS_JO_NOTE A , PSOPRDEFN B , PS_HRS_PERSON_NM_I C WHERE A.HRS_ROW_ADD_OPRID = B.OPRID AND B.EMPLID = C.EMPLID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | HRS_JOB_OPENING_ID | Number(15,0) | DECIMAL(15) NOT NULL | Job Opening Clone |
| 2 | HRS_NOTE_SEQ | Number(15,0) | DECIMAL(15) NOT NULL | Note Sequence |
| 3 | HRS_NOTE_DT | Date(10) | DATE | Note Date |
| 4 | HRS_NOTDT_STR | Character(15) | VARCHAR2(15) NOT NULL | Used in XMLP report for Job Opening |
| 5 | NAME_DISPLAY | Character(50) | VARCHAR2(50) NOT NULL | Display Name - name formatted for Display based on the Country |
| 6 | HRS_JO_NOTE_AUD | Character(1) | VARCHAR2(1) NOT NULL |
Indicates to whom the note should be visible.
1=Private 2=Public 3=Interview |
| 7 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 8 | HRS_NOTES_SUBJ | Character(254) | VARCHAR2(254) NOT NULL | Subject |
| 9 | HRS_NOTE | Long Character | CLOB | Note |
| 10 | HRS_ROW_ADD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Row Added Operator Id |