PSDSDIR(SQL Table) | 
Index Back | 
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description | 
|---|---|---|---|---|
| 1 | Character(50) | VARCHAR2(50) NOT NULL | Directory ID | |
| 2 | DESCR100 | Character(100) | VARCHAR2(100) NOT NULL | Length 100 Description | 
| 3 | XLATDSPROD | Character(4) | VARCHAR2(4) NOT NULL | 
Directory Product
 EDIR=Novell NDS eDirectory MSAD=Microsoft Active Directory NSDS=Sun One Directory Server ORCL=Oracle Internet Directory OTHR=Other LDAP Directory  | 
| 4 | DSPROTO | Character(4) | VARCHAR2(4) NOT NULL | DS Communications Protocol | 
| 5 | DSCNCTDN | Character(254) | VARCHAR2(254) NOT NULL | Distinguished Name | 
| 6 | DSCNCTPWD | Character(254) | VARCHAR2(254) NOT NULL | LDAP Connect Password | 
| 7 | PTDSCNCTPWDKY | Character(254) | VARCHAR2(254) NOT NULL | LDAP Connect Password Key | 
| 8 | DSCACHESCHEMA_PB | Character(1) | VARCHAR2(1) NOT NULL | 
DSCACHESCHEMA_PB
 N=NO Y=YES  | 
| 9 | HTMLAREA | Long Character | CLOB | HTML Area |