RECIPIENT_TYPEPER=Person
PROV=Provider Group
IDTYPEATTRIBUSERIDE=External Contact
I=Internal Corporate Contact
B=Both
E=Email
W=Worklist
RD_DIRECT_US(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 | USERID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID |
| 4 | NAME_T | Character(70) | VARCHAR2(70) NOT NULL | This field is to show instructional text next to the filter, when filtering a grid. |
| 5 | FIRST_NAME_SRCH | Character(30) | VARCHAR2(30) NOT NULL | First Name |
| 6 | LAST_NAME_SRCH | Character(30) | VARCHAR2(30) NOT NULL | Last Name |
| 7 | WORKLIST_USER_SW | Character(1) | VARCHAR2(1) NOT NULL | Used to determine if the user gets a worklist generated |
| 8 | 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 |
| 9 | 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 |
| 10 | RB_CREATE_DTTM | DateTime(26) | TIMESTAMP | Created date time |