RD_DIRECTORY

(SQL Table)

# 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 EMAIL_ADDR Character(70) VARCHAR2(70) NOT NULL Email address to store the address of email.

4 USERID Character(30) VARCHAR2(30) NOT NULL A user's ID

5 NAME_T Character(70) VARCHAR2(70) NOT NULL This field is to show instructional text next to the filter, when filtering a grid.

6 FIRST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL First Name

7 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name

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 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

12 RB_CREATE_DTTM DateTime(26) TIMESTAMP Created date time

#	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	EMAIL_ADDR	Character(70)	VARCHAR2(70) NOT NULL	Email address to store the address of email.
4	USERID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID
5	NAME_T	Character(70)	VARCHAR2(70) NOT NULL	This field is to show instructional text next to the filter, when filtering a grid.
6	FIRST_NAME_SRCH	Character(30)	VARCHAR2(30) NOT NULL	First Name
7	LAST_NAME_SRCH	Character(30)	VARCHAR2(30) NOT NULL	Last Name
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	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
12	RB_CREATE_DTTM	DateTime(26)	TIMESTAMP	Created date time