RB_EMPLID_VW(SQL View) |
Index Back |
|---|---|
Employee by EMPLID ViewPerson rows that contain non-blank EMPLID keyed by EMPLID. |
| SELECT A.PERSON_ID , A.CONTACT_FLAG , %subrec(NAMEGBL_NPC_SBR,B) , A.TITLE , A.RB_LANGUAGE_CD , A.EMPLID , A.SEX , A.BIRTHDATE , A.COMM_METHOD , A.SALUTATION_CD , A.SETID , A.AUTHORIZATION_ID , %subrec(RB_AUDIT_SBR,A) FROM PS_RD_PERSON A , PS_RD_PERSON_NAME B WHERE A.PERSON_ID = B.PERSON_ID AND B.PRIMARY_IND = 'Y' AND EMPLID <> ' ' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PERSON_ID | Character(15) | VARCHAR2(15) NOT NULL | Person ID |
| 2 | 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 |
| 3 | COUNTRY_NM_FORMAT | Character(3) | VARCHAR2(3) NOT NULL |
This is the country name format field.
Default Value: OPR_DEF_TBL_RB.LC_CNTRY Prompt Table: COUNTRY_TBL |
| 4 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 5 | NAME_INITIALS | Character(6) | VARCHAR2(6) NOT NULL | Name Initials |
| 6 | NAME_PREFIX | Character(4) | VARCHAR2(4) NOT NULL | Name Prefix |
| 7 | NAME_SUFFIX | Character(15) | VARCHAR2(15) NOT NULL | Name Suffix |
| 8 | NAME_ROYAL_PREFIX | Character(15) | VARCHAR2(15) NOT NULL | Name Royal Prefix |
| 9 | NAME_ROYAL_SUFFIX | Character(15) | VARCHAR2(15) NOT NULL | Name Royal Suffix |
| 10 | NAME_TITLE | Character(30) | VARCHAR2(30) NOT NULL | Title |
| 11 | LAST_NAME_SRCH | Character(30) | VARCHAR2(30) NOT NULL | Last Name |
| 12 | FIRST_NAME_SRCH | Character(30) | VARCHAR2(30) NOT NULL | First Name |
| 13 | LAST_NAME | Character(30) | VARCHAR2(30) NOT NULL | Last Name |
| 14 | FIRST_NAME | Character(30) | VARCHAR2(30) NOT NULL | First Name |
| 15 | MIDDLE_NAME | Character(30) | VARCHAR2(30) NOT NULL | Middle Name |
| 16 | SECOND_LAST_NAME | Character(30) | VARCHAR2(30) NOT NULL | Second Last Name |
| 17 | SECOND_LAST_SRCH | Character(30) | VARCHAR2(30) NOT NULL | Second Name |
| 18 | NAME_AC | Character(50) | VARCHAR2(50) NOT NULL | Name (Alternate Character) |
| 19 | PREF_FIRST_NAME | Character(30) | VARCHAR2(30) NOT NULL | PREF_FIRST_NAME field is used to identify the employees preferred first name |
| 20 | TITLE | Character(35) | VARCHAR2(35) NOT NULL | Title |
| 21 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 22 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 23 | SEX | Character(1) | VARCHAR2(1) NOT NULL |
Gender of the person.
F=Female M=Male U=Unknown |
| 24 | BIRTHDATE | Date(10) | DATE | Birthdate of the person. |
| 25 | COMM_METHOD | Character(1) | VARCHAR2(1) NOT NULL |
The person's preferred method of communication.
C=Call E=Email Only F=Fax I=XML only M=Standard Mail P=Email & Print R=XML & Print S=SMS |
| 26 | SALUTATION_CD | Character(6) | VARCHAR2(6) NOT NULL |
Salutation Code.
Prompt Table: SALUTATION_TBL |
| 27 | SETID | Character(5) | VARCHAR2(5) NOT NULL | This field is used to store the value of SetID on various setup tables. |
| 28 | AUTHORIZATION_ID | Character(10) | VARCHAR2(10) NOT NULL | Identification used for authorization purposes. |
| 29 | ROW_ADDED_DTTM | DateTime(26) | TIMESTAMP | This is a datetime field for record creation. |
| 30 | ROW_ADDED_OPRID | Character(30) | VARCHAR2(30) NOT NULL | ID of user who added the row. |
| 31 | ROW_LASTMANT_DTTM | DateTime(26) | TIMESTAMP | The date and time that the row was last updated. |
| 32 | ROW_LASTMANT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | ID of user who last modified the row. |
| 33 | SYNCID | Number(10,0) | DECIMAL(10) NOT NULL | The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle. |
| 34 | SYNCDTTM | DateTime(26) | TIMESTAMP | Synchronization Last Update Date Time |