PSDSSECMAPMAIN

(SQL Table)
Index Back

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 DSSECMAPID Character(50) VARCHAR2(50) NOT NULL Security Map Name
2 STATUS 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

Prompt Table: PSDSDIR
Set Control Field: PSDIRID

4 SEL_YN Character(1) VARCHAR2(1) NOT NULL Selected Yes/No Flag
N=No
Y=Yes

Y/N Table Edit

Default Value: N

5 DSCNCTDN Character(254) VARCHAR2(254) NOT NULL LDAP Connect DN

Prompt Table: DSCONNECTID_VW

6 DSSRCHSCOPE Character(4) VARCHAR2(4) NOT NULL LDAP Search Parms - 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