DSUSRPRFLMAP

index back

  • Parent record of PSDSUSERPRFL
  • PeopleSoft Field Name Field Type Column Type Description
    DSUSRMAPID Character(50) VARCHAR2(50) NOT NULL User Profile Map
    DSSECMAPID Character(50) VARCHAR2(50) NOT NULL Security Map Name

    Prompt Table: PSDSSECMAPID_VW

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

    Prompt Table: PSDSOCATTR_VW2
    Set Control Field: DSNAMEAT

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

    Prompt Table: PSACCESSPRFL
    Set Control Field: SYMBOLICID

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

    Default: Y

    LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code translate values

    Default: ENG

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

    Prompt Table: PSDSOCATTR_VW2

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

    Default: NON

    Prompt Table: PSUSERTYPEVW
    Set Control Field: DESCR

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

    Default: None

    Prompt Table: PSDSOCATTR_VW2

    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

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

    Y/N Table Edit

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

    Prompt Table: PSDSOCATTR_VW2

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

    Default: N

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

    Default: N

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

    Prompt Table: PSDSOCATTR_VW2

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

    Default: N

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

    Prompt Table: PSDSOCATTR_VW2

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

    Default: N

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

    Prompt Table: PSDSOCATTR_VW2

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

    Default: N

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

    Prompt Table: PSDSOCATTR_VW2

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

    Default: N

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

    Prompt Table: PSDSOCATTR_VW2

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

    Default: N

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

    Prompt Table: PSDSOCATTR_VW2

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

    Default: N

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

    Prompt Table: PSDSOCATTR_VW2

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

    Default: N

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

    Default: N

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

    Default: N

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

    Default: N

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

    Default: N

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

    Default: N

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

    Prompt Table: PSDSOCATTR_VW2

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

    Prompt Table: PSDSOCATTR_VW2

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

    Prompt Table: PSDSOCATTR_VW2

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

    Prompt Table: PSDSOCATTR_VW2

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

    Prompt Table: PSDSOCATTR_VW2

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

    Prompt Table: PSDSOCATTR_VW2

    index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
    PTRef generated on 09-JUN-19