EMPLIDDefault Value: PER_ORG_ASGN.EMPLID
Prompt Table: PERS_SRCH_GBL
Default Value: %date
TRW_DISP_VW(SQL View) |
Index Back |
|---|---|
Total Reward Display ViewTotal Reward Display View for RTE Data |
| SELECT A.EMPLID ,A.EMPL_RCD ,A.EFFDT ,A.EFFSEQ ,B.FIRST_NAME ,B.LAST_NAME ,B.NAME_DISPLAY ,C.DESCR , B.ADDRESS1 , B.ADDRESS2 ,B.CITY , B.POSTAL ,B.COUNTRY FROM PS_JOB A , PS_PERSONAL_DATA B , PS_JOBCODE_TBL C WHERE A.EMPLID = B.EMPLID AND A.SETID_JOBCODE = C.SETID AND A.JOBCODE = C.JOBCODE AND A.EFFDT = ( SELECT MAX(R1.EFFDT) FROM PS_JOB R1 WHERE A.EMPLID = R1.EMPLID AND R1.EFFDT <=%CurrentDateIn) AND A.EFFSEQ = ( SELECT MAX(R3.EFFSEQ) FROM PS_JOB R3 WHERE A.EMPLID = R3.EMPLID AND A.EFFDT = R3.EFFDT) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Default Value: PER_ORG_ASGN.EMPLID Prompt Table: PERS_SRCH_GBL |
| 2 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 3 | EFFDT | Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 4 | EFFSEQ | Number(3,0) | SMALLINT NOT NULL | Effective Sequence |
| 5 | FIRST_NAME | Character(30) | VARCHAR2(30) NOT NULL | First Name |
| 6 | LAST_NAME | Character(30) | VARCHAR2(30) NOT NULL | Last Name |
| 7 | NAME_DISPLAY | Character(50) | VARCHAR2(50) NOT NULL | Display Name - name formatted for Display based on the Country |
| 8 | JOBTITLE | Character(30) | VARCHAR2(30) NOT NULL | Job Title |
| 9 | ADDRESS1 | Character(55) | VARCHAR2(55) NOT NULL | Address 1 |
| 10 | ADDRESS2 | Character(55) | VARCHAR2(55) NOT NULL | Address 2 |
| 11 | CITY | Character(30) | VARCHAR2(30) NOT NULL | City |
| 12 | POSTAL | Character(12) | VARCHAR2(12) NOT NULL | Postal |
| 13 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Country |