BO_WORKER_VW(SQL View) |
Index Back |
---|---|
BO ID and Worker ViewView to Fetch BO_ID_CONTACT and Wroker |
SELECT A.BO_ID , %Substring(A.BO_NAME_DISPLAY, 1, 50) , A.EMPLID , A.PERSON_ID , A.TITLE , A.FIRST_NAME ,A.LAST_NAME , A.MIDDLE_NAME , A.SEX , A.CONTACT_FLAG , B.SETID_DEPT , B.DEPTID , B.SETID_LOCATION , B.LOCATION , B.SETID_JOBCODE , JOBCODE FROM PS_RB_PRSN_P_NM_VW A , PS_RB_WORKER B WHERE A.PERSON_ID = B.PERSON_ID |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | BO_ID_CONTACT | Number(31,0) | DECIMAL(31) NOT NULL | This field indicates the Business Object ID for the contact. |
2 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
3 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
4 | PERSON_ID | Character(15) | VARCHAR2(15) NOT NULL | Person ID |
5 | TITLE | Character(35) | VARCHAR2(35) NOT NULL | Title |
6 | FIRST_NAME | Character(30) | VARCHAR2(30) NOT NULL | First Name |
7 | LAST_NAME | Character(30) | VARCHAR2(30) NOT NULL | Last Name |
8 | MIDDLE_NAME | Character(30) | VARCHAR2(30) NOT NULL | Middle Name |
9 | SEX | Character(1) | VARCHAR2(1) NOT NULL |
Gender of the person.
F=Female M=Male U=Unknown |
10 | 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 |
11 | SETID_DEPT | Character(5) | VARCHAR2(5) NOT NULL | Department SetID |
12 | DEPTID | Character(15) | VARCHAR2(15) NOT NULL | Department |
13 | SETID_LOCATION | Character(5) | VARCHAR2(5) NOT NULL | Location SetID |
14 | LOCATION | Character(15) | VARCHAR2(15) NOT NULL | This field stores the Location Code. |
15 | SETID_JOBCODE | Character(5) | VARCHAR2(5) NOT NULL | SETID_JOBCODE field used in the HCM/ CRM sync Application Messages. |
16 | JOBCODE | Character(15) | VARCHAR2(15) NOT NULL | Job Code or Job Title. |