RSF_ROLE_CD_A_V

(SQL View)
 Index Back

Role Code Table

Table contains the various role codes and their descriptions.

SELECT R.ROLE_CD , R.DESCR , R.DESCR254 , %subrec(RB_AUDIT_SBR , R) FROM PS_RSF_ROLE_CD_TBL R WHERE STATUS = 'A'

  • Related Language Record: RSF_ROLE_CD_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 ROLE_CD Character(4) VARCHAR2(4) NOT NULL Sales User Role Code
    0001=Manager
    0002=Administrator
    0003=Consultant
    0004=Legal
    0005=Other
    0006=Liaison
    0007=Partner
    0007=Partner
    0008=Sales Rep
    0009=Team Leader
    0010=Technical Sales
    0011=Technical
    0012=Training
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
    4 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.
    5 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.
    6 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.
    7 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.
    8 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.
    9 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time