BO_IDRECIPIENT_TYPEPER=Person
PROV=Provider Group
IDTYPEATTRIBEMAIL_ADDRUSERIDE=External Contact
I=Internal Corporate Contact
B=Both
E=Email
W=Worklist
RD_DIRECTORY_US(SQL Table) |
Index Back |
|---|
| # | 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 | RECIPIENT_TYPE |
Character(4) | VARCHAR2(4) NOT NULL |
Recipient Type
PER=Person PROV=Provider Group |
| 3 | IDTYPEATTRIB |
Character(56) | VARCHAR2(56) NOT NULL | LDAP ID Type Attribute |
| 4 | EMAIL_ADDR |
Character(70) | VARCHAR2(70) NOT NULL | Email address to store the address of email. |
| 5 | USERID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID |
| 6 | NAME_T | Character(70) | VARCHAR2(70) NOT NULL | This field is to show instructional text next to the filter, when filtering a grid. |
| 7 | FIRST_NAME_SRCH | Character(30) | VARCHAR2(30) NOT NULL | First Name |
| 8 | LAST_NAME_SRCH | Character(30) | VARCHAR2(30) NOT NULL | Last Name |
| 9 | WORKLIST_USER_SW | Character(1) | VARCHAR2(1) NOT NULL | Used to determine if the user gets a worklist generated |
| 10 | EMAIL_USER_SW | Character(1) | VARCHAR2(1) NOT NULL | Used to determine if the user gets workflow email generated |
| 11 | 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 |
| 12 | PREF_WF_ROUTE_MTHD | Character(1) | VARCHAR2(1) NOT NULL |
Preferred workflow notification method. E.g., Email, Worklist, or Both.
B=Both E=Email W=Worklist |
| 13 | RB_CREATE_DTTM | DateTime(26) | TIMESTAMP | Created date time |