TRANSACTION_NBRHR_REP_SUMM_VW2(SQL View) |
Index Back |
|---|---|
Reporting Chg Summary View 2Reporting change summary information 2 |
| SELECT DISTINCT A.TRANSACTION_NBR , D.ACTION_DT_SS , A.ORIGINATORID , B.EMPLID , B.NAME_DISPLAY , C.EMPLID , C.NAME_DISPLAY , ' ' , ' ' FROM PS_HR_REPORT_TRANS A , PS_PERSON_NAME B , PS_PERSON_NAME C , PS_HR_MGR_REP_DAT D WHERE A.TRANSACTION_NBR = D.TRANSACTION_NBR AND B.EMPLID = ( SELECT EMPLID FROM PSOPRDEFN WHERE OPRID = A.ORIGINATORID) AND C.EMPLID = D.SUPERVISOR_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | TRANSACTION_NBR |
Number(15,0) | DECIMAL(15) NOT NULL | 08/02/99 NAS: Changed the size of this field from 10 to 15. Based on Jim Hillman's decision to make the field at a standard size. |
| 2 | ACTION_DT_SS | Date(10) | DATE | Termination Date |
| 3 | ORIGINATORID | Character(30) | VARCHAR2(30) NOT NULL | Originator Identifier |
| 4 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 5 | NAME_TRANS | Character(50) | VARCHAR2(50) NOT NULL | Name of Person Transmitting |
| 6 | EMPLID2 | Character(11) | VARCHAR2(11) NOT NULL | Field is referenced in state record used by Cobra Upgrade. |
| 7 | NAME_DISPLAY | Character(50) | VARCHAR2(50) NOT NULL | Display Name - name formatted for Display based on the Country |
| 8 | DESCR15 | Character(15) | VARCHAR2(15) NOT NULL | Short Description |
| 9 | DUMMY_FIELD | Character(1) | VARCHAR2(1) NOT NULL | Dummy Field |