DSUSRPRFLMAP

index back

  • Parent record of PSDSUSERPRFL
  • PeopleSoft Field NameField TypeColumn TypeDescription
    DSUSRMAPIDCharacter(50)VARCHAR2(50) NOT NULLUser Profile Map
    DSSECMAPIDCharacter(50)VARCHAR2(50) NOT NULLSecurity Map Name

    Prompt Table: PSDSSECMAPID_VW

    STATUSCharacter(1)VARCHAR2(1) NOT NULLStatus Indicator
    A=Active
    I=Inactive
    DSDIRIDCharacter(50)VARCHAR2(50) NOT NULLDirectory ID
    DSNAMEOCCharacter(50)VARCHAR2(50) NOT NULLDirectory Object Class
    USERIDATTRIBCharacter(56)VARCHAR2(56) NOT NULLLDAP User ID Attribute

    Prompt Table: PSDSOCATTR_VW2
    Set Control Field: DSNAMEAT

    SYMBOLICIDCharacter(8)VARCHAR2(8) NOT NULLThe foreign key linking the PSOPRDEFN table to PSACCESSPRFL

    Prompt Table: PSACCESSPRFL
    Set Control Field: SYMBOLICID

    DEFLANGCDCBCharacter(1)VARCHAR2(1) NOT NULLDEFLANGCDCB
    N=NO
    Y=YES

    Default: Y

    LANGUAGE_CDCharacter(3)VARCHAR2(3) NOT NULLLanguage Code translate values

    Default: ENG

    LANGUAGECDATTRIBCharacter(56)VARCHAR2(56) NOT NULLLDAP Language Code Attribute

    Prompt Table: PSDSOCATTR_VW2

    OPRALIASTYPECharacter(3)VARCHAR2(3) NOT NULLUser ID Type

    Default: NON

    Prompt Table: PSUSERTYPEVW
    Set Control Field: DESCR

    IDTYPEATTRIBCharacter(56)VARCHAR2(56) NOT NULLLDAP ID Type Attribute

    Default: None

    Prompt Table: PSDSOCATTR_VW2

    ROLENAMECharacter(30)VARCHAR2(30) NOT NULLThe name of a Role in the Role Definition Table (see PSROLEDEFN).

    Prompt Table: PSROLEDEFN_SRCH
    Set Control Field: ROLENAME

    DEFAULTROLECharacter(1)VARCHAR2(1) NOT NULLUse default Role

    Y/N Table Edit

    ROLEATTRIBCharacter(30)VARCHAR2(30) NOT NULLThe name of a Role in the Role Definition Table

    Prompt Table: PSDSOCATTR_VW2

    USEIMPORTGRPSCBCharacter(1)VARCHAR2(1) NOT NULLUSEIMPORTGRPSCB
    N=NO
    Y=Yes

    Default: N

    USERDSCRCBCharacter(1)VARCHAR2(1) NOT NULLLDAP User Description Checkbox
    N=User Description Check Box
    Y=User Description Check Box

    Default: N

    DESCRATTRIBCharacter(56)VARCHAR2(56) NOT NULLLDAP Attribute for Description

    Prompt Table: PSDSOCATTR_VW2

    EMAILCBCharacter(1)VARCHAR2(1) NOT NULLLDAP Email Checkbox
    N=Email Check Box
    Y=Email Check Box

    Default: N

    EMAILATTRIBCharacter(56)VARCHAR2(56) NOT NULLLDAP Email Attribute

    Prompt Table: PSDSOCATTR_VW2

    CURRENCYCBCharacter(1)VARCHAR2(1) NOT NULLCurrency Checkbox
    N=Currency Code Check Box
    Y=Currency Code Check Box

    Default: N

    CURRENCYATTRIBCharacter(56)VARCHAR2(56) NOT NULLLDAP Attribute for Currency Code

    Prompt Table: PSDSOCATTR_VW2

    HOMEPAGECBCharacter(1)VARCHAR2(1) NOT NULLLDAP Homepage Checkbox
    N=Home Page Check Box
    Y=Home Page Check Box

    Default: N

    HOMEPAGEATTRIBCharacter(56)VARCHAR2(56) NOT NULLLDAP Homepage Attribute

    Prompt Table: PSDSOCATTR_VW2

    PRCSPROFILECBCharacter(1)VARCHAR2(1) NOT NULLLDAP Process Profile Checkbox
    N=Process Profile Check Box
    Y=Process Profile Check Box

    Default: N

    PRCSPROFILEATTRIBCharacter(56)VARCHAR2(56) NOT NULLLDAP Process Profile Attribute

    Prompt Table: PSDSOCATTR_VW2

    PRIMARYCBCharacter(1)VARCHAR2(1) NOT NULLLDAP Primary Permissions List Checkbox
    N=Primary Class Check Box
    Y=Primary Class Check Box

    Default: N

    PRIMARYATTRIBCharacter(56)VARCHAR2(56) NOT NULLLDAP Primary Permissions List Attribute

    Prompt Table: PSDSOCATTR_VW2

    ROWSECCLSCBCharacter(1)VARCHAR2(1) NOT NULLLDAP Row Level Security Class Checkbox
    N=Row Sec Check Box
    Y=Row Sec Check Box

    Default: N

    ROWSECCLSATTRIBCharacter(56)VARCHAR2(56) NOT NULLLDAP Row Security Class Attribute

    Prompt Table: PSDSOCATTR_VW2

    WRKLSTUSERCBCharacter(1)VARCHAR2(1) NOT NULLLDAP Work List Checkbox
    N=WorkList User
    Y=WorkList User

    Default: N

    FORMSUSERCBCharacter(1)VARCHAR2(1) NOT NULLLDAP Form User Checkbox
    N=Forms User
    Y=Forms User

    Default: N

    EMAILUSERCBCharacter(1)VARCHAR2(1) NOT NULLLDAP Email User Checkbox
    N=Email User
    Y=Email User

    Default: N

    REASSIGNCBCharacter(1)VARCHAR2(1) NOT NULLLDAP Reassign Work Checkbox
    N=Reassign Work
    Y=Reassign Work

    Default: N

    FORMIDCBCharacter(1)VARCHAR2(1) NOT NULLLDAP Form ID Checkbox
    N=Form ID
    Y=Form ID

    Default: N

    SUPRUSERIDCBCharacter(1)VARCHAR2(1) NOT NULLLDAP Super User ID Checkbox
    N=Supervisiong User ID
    Y=Supervisiong User ID

    Default: N

    WORKLISTATTRIBCharacter(56)VARCHAR2(56) NOT NULLLDAP Work List Attribute

    Prompt Table: PSDSOCATTR_VW2

    FORMSUSERATTRIBCharacter(56)VARCHAR2(56) NOT NULLLDAP Form User Attribute

    Prompt Table: PSDSOCATTR_VW2

    EMAILUSERATTRIBCharacter(56)VARCHAR2(56) NOT NULLLDAP Email User Attribute

    Prompt Table: PSDSOCATTR_VW2

    REASSIGNWORKATTRIBCharacter(56)VARCHAR2(56) NOT NULLLDAP Reassign Work Attribute

    Prompt Table: PSDSOCATTR_VW2

    FORMIDATTRIBCharacter(56)VARCHAR2(56) NOT NULLLDAP Form ID Attribute

    Prompt Table: PSDSOCATTR_VW2

    SUPRUSERIDATTRIBCharacter(56)VARCHAR2(56) NOT NULLLDAP Super User ID Attribute

    Prompt Table: PSDSOCATTR_VW2

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