DP_ROLESEC_AET

(SQL Table)
Index Back

Role Security State Record

Role Security State Record

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
3 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
4 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
5 FIELDTYPE Number(2,0) SMALLINT NOT NULL Field Type (from PSST0101 Ref.)
6 FIELDCOUNT Number(4,0) SMALLINT NOT NULL Field Count
7 ROLENAME Character(30) VARCHAR2(30) NOT NULL The name of a Role in the Role Definition Table (see PSROLEDEFN).
8 WHERE_CLAUSE_LONG Long Character(4000) CLOB Where Clause
9 WHERE_CLAUSE1 Character(254) VARCHAR2(254) NOT NULL Where Clause
10 WHERE_CLAUSE2 Character(254) VARCHAR2(254) NOT NULL Where Clause
11 DP_CONFIGVIEW Character(20) VARCHAR2(20) NOT NULL DP_CONFIGVIEW