PAY_ENTITYEMPLIDDefault Value: PER_ORG_ASGN.EMPLID
GPDE_DX_EMSL_VW(SQL View) |
Index Back |
|---|---|
View for select empl name.View to select Employee, Name and Pay Entity. |
| SELECT DISTINCT A.PAY_ENTITY ,A.EMPLID ,A.EMPL_RCD , B.NAME FROM PS_GPDE_RP_0003_VW A , PS_NAMES_VW B WHERE B.EMPLID = A.EMPLID AND B.EFFDT =( SELECT MAX(C.EFFDT) FROM PS_NAMES C WHERE C.EFFDT = B.EFFDT AND B.NAME_TYPE ='PRI') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PAY_ENTITY |
Character(10) | VARCHAR2(10) NOT NULL | Pay Entity |
| 2 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Default Value: PER_ORG_ASGN.EMPLID |
| 3 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 4 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |