RSEC_MEMBERDEFN

(SQL Table)
 Index Back

Membership Definition

Membership definition to be used to related to a Security Key.

  • Related Language Record: RSEC_MEMBER_LNG

  • Parent Record Of RSEC_MLKPARTNER RSEC_ML_CUST RSEC_ML_PARTNER RSEC_ML_PART_C RSEC_ML_PERSON RSEC_ML_ROLE

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 RSEC_MEMBER_ID Character(30) VARCHAR2(30) NOT NULL Security Membership ID for application security membership definition.
    2 RSEC_OBJECT_ID Character(30) VARCHAR2(30) NOT NULL Security Object ID used for defining application security objects.

    Prompt Table: RSEC_MEM_OBJ_VW

    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 DESCRLONG Long Character CLOB Long Description
    5 STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
    A=Active
    I=Inactive

    Default Value: A

    6 RSEC_ALLOW_REUSE Character(1) VARCHAR2(1) NOT NULL Allow reuse of a security domain is determined using this flag.

    Y/N Table Edit

    Default Value: Y

    7 RSEC_DOMAIN_SIZE Character(4) VARCHAR2(4) NOT NULL This field is used for CRM application security to define the domain type as 'Dynamic' or 'Static'.
    0001=All
    0002=Multiple Members
    0003=Single Member

    Default Value: 0002

    8 RSEC_DOMAIN_TYPE Character(4) VARCHAR2(4) NOT NULL This field is used for CRM application security to define the domain type as 'Dynamic' or 'Static'.
    0001=Dynamic
    0002=Static

    Default Value: 0001

    9 RSEC_LIST_BUILD_DT DateTime(26) TIMESTAMP Last refresh date of membership and view lists.
    10 RSEC_LIST_COUNT Number(15,0) DECIMAL(15) NOT NULL This field is used to store the count of all the list members in a security list table. The security list tables can be either membership or view privilege list tables.
    11 RSEC_SYSTEM_MAINT Character(1) VARCHAR2(1) NOT NULL Application security, system maintained record is identified using this field.

    Y/N Table Edit

    Default Value: N

    12 SQLID Character(30) VARCHAR2(30) NOT NULL SQL Object Identifier. This column has different meanings depending upon value of SQLTYPE
  • SQLTYPE = 0: SQL object name
  • SQLTYPE = 1: Application Engine Step Identifier
  • SQLTYPE = 2: RECNAME
  • SQLTYPE = 6: Application Engine XSLT (XML definition)
    • 13 SQLTYPE Character(1) VARCHAR2(1) NOT NULL SQL Object type
  • 0=SQL Object referenced from elsewhere
  • 1=Application Engine Step
  • 2=SQL View
  • 5=Queries for DDDAUDIT and SYSAUDIT
  • 6= Application Engine Step XSLT

    Default Value: 0

    • 14 LAST_USED_CRITERIA Character(254) VARCHAR2(254) NOT NULL Last Used Filter Criteria
    15 RSEC_MAINT_OWNER Character(1) VARCHAR2(1) NOT NULL Field used to determine owner data information.
    0=PeopleSoft
    1=PeopleSoft / Customer Modified
    2=Customer
    3=PeopleSoft Sample Data

    Default Value: 2

    16 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.
    17 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.
    18 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.
    19 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.
    20 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
    21 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time