RECIPIENT_TYPEPER=Person
PROV=Provider Group
IDTYPEATTRIBE=External Contact
I=Internal Corporate Contact
RB_DIRECTORY(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RECIPIENT_TYPE |
Character(4) | VARCHAR2(4) NOT NULL |
Recipient Type
PER=Person PROV=Provider Group |
| 2 | IDTYPEATTRIB |
Character(56) | VARCHAR2(56) NOT NULL | LDAP ID Type Attribute |
| 3 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 4 | FIRST_NAME_SRCH | Character(30) | VARCHAR2(30) NOT NULL | First Name |
| 5 | LAST_NAME_SRCH | Character(30) | VARCHAR2(30) NOT NULL | Last Name |
| 6 | EMAIL_ADDR | Character(70) | VARCHAR2(70) NOT NULL | Email address to store the address of email. |
| 7 | USERID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID |
| 8 | WORKLIST_USER_SW | Character(1) | VARCHAR2(1) NOT NULL | Used to determine if the user gets a worklist generated |
| 9 | EMAIL_USER_SW | Character(1) | VARCHAR2(1) NOT NULL | Used to determine if the user gets workflow email generated |
| 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 | RB_CREATE_DTTM | DateTime(26) | TIMESTAMP | Created date time |