TRANSACTION_NBREMPLIDEMPL_RCDN=No
Y=Yes
Y/N Table Edit
Default Value: Y
HR_REP_TRANSVW2(SQL View) |
Index Back |
|---|---|
Reporting Chg Transaction DataReporting change information for Selected Employee used in HTML Email. |
| SELECT A.TRANSACTION_NBR , A.EMPLID , A.EMPL_RCD , A.JOB_DESCR_SS , A.POSITION_FLAG , A.ORIGINATORID , B.NAME , B.NAME_DISPLAY , C.NAME_DISPLAY FROM PS_HR_REPORT_TRANS A , PS_PERSON_NAME B , PS_PERSON_NAME C WHERE B.EMPLID = A.EMPLID AND C.EMPLID = ( SELECT EMPLID FROM PSOPRDEFN WHERE OPRID = A.ORIGINATORID) |
| # | 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 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 3 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 4 | JOB_DESCR_SS | Character(30) | VARCHAR2(30) NOT NULL | Job Title |
| 5 | POSITION_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Position Flag
N=No Y=Yes Y/N Table Edit Default Value: Y |
| 6 | ORIGINATORID | Character(30) | VARCHAR2(30) NOT NULL | Originator Identifier |
| 7 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 8 | NAME_TRANS | Character(50) | VARCHAR2(50) NOT NULL | Name of Person Transmitting |
| 9 | NAME_DISPLAY | Character(50) | VARCHAR2(50) NOT NULL | Display Name - name formatted for Display based on the Country |