PSDSSECMAPMAIN(SQL Table) | 
Index Back | 
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description | 
|---|---|---|---|---|
| 1 | Character(50) | VARCHAR2(50) NOT NULL | Security Map Name | |
| 2 | Character(1) | VARCHAR2(1) NOT NULL | 
Status Indicator
 A=Active I=Inactive Default Value: A  | 
|
| 3 | DSDIRID | Character(50) | VARCHAR2(50) NOT NULL | Directory ID | 
| 4 | SEL_YN | Character(1) | VARCHAR2(1) NOT NULL | 
Selected? (yes/No)
 N=No Y=Yes Y/N Table Edit Default Value: N  | 
| 5 | DSCNCTDN | Character(254) | VARCHAR2(254) NOT NULL | 
Distinguished Name
 Prompt Table: DSCONNECTID_VW  | 
| 6 | DSSRCHSCOPE | Character(4) | VARCHAR2(4) NOT NULL | 
Search Scope
 BASE=Base Entry ONE=One Level SUB=Subtree Default Value: SUB  | 
| 7 | LDAPSRCHBASE | Character(254) | VARCHAR2(254) NOT NULL | LDAP Search Parms - Base | 
| 8 | DSNAMEAT | Character(100) | VARCHAR2(100) NOT NULL | 
LDAP Attribute Name
 Prompt Table: DSATTRIB_VW  | 
| 9 | DIRCONTYPE | Character(1) | VARCHAR2(1) NOT NULL | 
LDAP Connection Type
 D=Distinguished Name S=Search  | 
| 10 | USE_SSL | Character(1) | VARCHAR2(1) NOT NULL | 
Use Secure Socket Layer
 Y/N Table Edit  |