PERSON_IDLANGUAGE_CDRD_WORK_G_LVW(SQL View) |
Index Back |
|---|---|
RD_WORK_G_VWSELECT DISTINCT A.PERSON_ID , A.TITLE , A.EMPLID , D.EMPL_STATUS , A.BO_ID , B.FIRST_NAME , B.LAST_NAME , B.NAME_AC FROM PS_RD_PERSON A , PS_BO_NAME B , PS_BO_ROLE C , PS_RB_WORKER D WHERE A.BO_ID = B.BO_ID AND A.BO_ID = C.BO_ID AND A.PERSON_ID = D.PERSON_ID AND C.ROLE_TYPE_ID = 4 AND (MARKET = 'GBL' OR MARKET = ' ') |
| SELECT PERSON_ID , LANGUAGE_CD , TITLE FROM PS_RD_PERSON_LNG |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PERSON_ID |
Character(15) | VARCHAR2(15) NOT NULL | Person ID |
| 2 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 3 | TITLE | Character(35) | VARCHAR2(35) NOT NULL | Title |