DSUSRPRFLMAP

(SQL Table)
 Index Back

  • Parent Record Of PSDSUSERPRFL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 DSUSRMAPID Character(50) VARCHAR2(50) NOT NULL User Profile Map
    2 DSSECMAPID Character(50) VARCHAR2(50) NOT NULL Security Map Name

    Prompt Table: PSDSSECMAPID_VW

    3 STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
    A=Active
    I=Inactive
    4 DSDIRID Character(50) VARCHAR2(50) NOT NULL Directory ID
    5 DSNAMEOC Character(50) VARCHAR2(50) NOT NULL Directory Object Class
    6 USERIDATTRIB Character(56) VARCHAR2(56) NOT NULL LDAP User ID Attribute

    Prompt Table: PSDSOCATTR_VW2
    Set Control Field: DSNAMEAT

    7 SYMBOLICID Character(8) VARCHAR2(8) NOT NULL The foreign key linking the PSOPRDEFN table to PSACCESSPRFL

    Prompt Table: PSACCESSPROFILE
    Set Control Field: SYMBOLICID

    8 DEFLANGCDCB Character(1) VARCHAR2(1) NOT NULL DEFLANGCDCB
    N=NO
    Y=YES

    Default Value: Y

    9 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

    Default Value: ENG

    10 LANGUAGECDATTRIB Character(56) VARCHAR2(56) NOT NULL LDAP Language Code Attribute

    Prompt Table: PSDSOCATTR_VW2

    11 OPRALIASTYPE Character(3) VARCHAR2(3) NOT NULL User ID Type

    Default Value: NON

    Prompt Table: PSUSERTYPEVW
    Set Control Field: DESCR

    12 IDTYPEATTRIB Character(56) VARCHAR2(56) NOT NULL LDAP ID Type Attribute

    Default Value: None

    Prompt Table: PSDSOCATTR_VW2

    13 ROLENAME Character(30) VARCHAR2(30) NOT NULL The name of a Role in the Role Definition Table (see PSROLEDEFN).

    Prompt Table: PSROLEDEFN_SRCH
    Set Control Field: ROLENAME

    14 DEFAULTROLE Character(1) VARCHAR2(1) NOT NULL Use default Role

    Y/N Table Edit

    15 ROLEATTRIB Character(30) VARCHAR2(30) NOT NULL The name of a Role in the Role Definition Table

    Prompt Table: PSDSOCATTR_VW2

    16 USEIMPORTGRPSCB Character(1) VARCHAR2(1) NOT NULL USEIMPORTGRPSCB
    N=NO
    Y=Yes

    Default Value: N

    17 USERDSCRCB Character(1) VARCHAR2(1) NOT NULL LDAP User Description Checkbox
    N=User Description Check Box
    Y=User Description Check Box

    Default Value: N

    18 DESCRATTRIB Character(56) VARCHAR2(56) NOT NULL LDAP Attribute for Description

    Prompt Table: PSDSOCATTR_VW2

    19 EMAILCB Character(1) VARCHAR2(1) NOT NULL LDAP Email Checkbox
    N=Email Check Box
    Y=Email Check Box

    Default Value: N

    20 EMAILATTRIB Character(56) VARCHAR2(56) NOT NULL LDAP Email Attribute

    Prompt Table: PSDSOCATTR_VW2

    21 CURRENCYCB Character(1) VARCHAR2(1) NOT NULL Currency Checkbox
    N=Currency Code Check Box
    Y=Currency Code Check Box

    Default Value: N

    22 CURRENCYATTRIB Character(56) VARCHAR2(56) NOT NULL LDAP Attribute for Currency Code

    Prompt Table: PSDSOCATTR_VW2

    23 HOMEPAGECB Character(1) VARCHAR2(1) NOT NULL LDAP Homepage Checkbox
    N=Home Page Check Box
    Y=Home Page Check Box

    Default Value: N

    24 HOMEPAGEATTRIB Character(56) VARCHAR2(56) NOT NULL LDAP Homepage Attribute

    Prompt Table: PSDSOCATTR_VW2

    25 PRCSPROFILECB Character(1) VARCHAR2(1) NOT NULL LDAP Process Profile Checkbox
    N=Process Profile Check Box
    Y=Process Profile Check Box

    Default Value: N

    26 PRCSPROFILEATTRIB Character(56) VARCHAR2(56) NOT NULL LDAP Process Profile Attribute

    Prompt Table: PSDSOCATTR_VW2

    27 PRIMARYCB Character(1) VARCHAR2(1) NOT NULL LDAP Primary Permissions List Checkbox
    N=Primary Class Check Box
    Y=Primary Class Check Box

    Default Value: N

    28 PRIMARYATTRIB Character(56) VARCHAR2(56) NOT NULL LDAP Primary Permissions List Attribute

    Prompt Table: PSDSOCATTR_VW2

    29 ROWSECCLSCB Character(1) VARCHAR2(1) NOT NULL LDAP Row Level Security Class Checkbox
    N=Row Sec Check Box
    Y=Row Sec Check Box

    Default Value: N

    30 ROWSECCLSATTRIB Character(56) VARCHAR2(56) NOT NULL LDAP Row Security Class Attribute

    Prompt Table: PSDSOCATTR_VW2

    31 WRKLSTUSERCB Character(1) VARCHAR2(1) NOT NULL LDAP Work List Checkbox
    N=WorkList User
    Y=WorkList User

    Default Value: N

    32 FORMSUSERCB Character(1) VARCHAR2(1) NOT NULL LDAP Form User Checkbox
    N=Forms User
    Y=Forms User

    Default Value: N

    33 EMAILUSERCB Character(1) VARCHAR2(1) NOT NULL LDAP Email User Checkbox
    N=Email User
    Y=Email User

    Default Value: N

    34 REASSIGNCB Character(1) VARCHAR2(1) NOT NULL LDAP Reassign Work Checkbox
    N=Reassign Work
    Y=Reassign Work

    Default Value: N

    35 FORMIDCB Character(1) VARCHAR2(1) NOT NULL LDAP Form ID Checkbox
    N=Form ID
    Y=Form ID

    Default Value: N

    36 SUPRUSERIDCB Character(1) VARCHAR2(1) NOT NULL LDAP Super User ID Checkbox
    N=Supervisiong User ID
    Y=Supervisiong User ID

    Default Value: N

    37 WORKLISTATTRIB Character(56) VARCHAR2(56) NOT NULL LDAP Work List Attribute

    Prompt Table: PSDSOCATTR_VW2

    38 FORMSUSERATTRIB Character(56) VARCHAR2(56) NOT NULL LDAP Form User Attribute

    Prompt Table: PSDSOCATTR_VW2

    39 EMAILUSERATTRIB Character(56) VARCHAR2(56) NOT NULL LDAP Email User Attribute

    Prompt Table: PSDSOCATTR_VW2

    40 REASSIGNWORKATTRIB Character(56) VARCHAR2(56) NOT NULL LDAP Reassign Work Attribute

    Prompt Table: PSDSOCATTR_VW2

    41 FORMIDATTRIB Character(56) VARCHAR2(56) NOT NULL LDAP Form ID Attribute

    Prompt Table: PSDSOCATTR_VW2

    42 SUPRUSERIDATTRIB Character(56) VARCHAR2(56) NOT NULL LDAP Super User ID Attribute

    Prompt Table: PSDSOCATTR_VW2