OLM_WORKER1_VW(SQL View) |
Index Back |
|---|---|
Profile WorkerSelected Worker (tied to BO_ID) for Profile use |
| SELECT BO_ID , PERSON_ID , EMPLID , CONTACT_FLAG , RB_LANGUAGE_CD FROM PS_RD_PERSON |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BO_ID |
Signed Number(32,0) | DECIMAL(31) NOT NULL | Business Object ID |
| 2 | PERSON_ID | Character(15) | VARCHAR2(15) NOT NULL | Person ID |
| 3 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 4 | CONTACT_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
An attribute that describes the specific purpose of a given bank/counterparty contact person.
It is also used to indicate whether a person has a Contact role.
E=External Contact I=Internal Corporate Contact |
| 5 | RB_LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL |
Language Code
ARA=Arabic CFR=Canadian French CZE=Czech DAN=Danish DUT=Dutch ENG=English ESP=Spanish FIN=Finnish FRA=French GER=German GRK=Greek HEB=Hebrew HUN=Hungarian ITA=Italian JPN=Japanese KOR=Korean MAY=Bahasa Malay NOR=Norwegian POL=Polish POR=Portuguese RUS=Russian SVE=Swedish THA=Thai TUR=Turkish ZHS=Simplified Chinese ZHT=Traditional Chinese |