ROLENAMEDP_POLICYSETDP_FIELDIDPrompt Table: DP_IPFLDSEL7_VW
DP_KEYCRITERIAPrompt Table: %EDITTABLE2
1=Character
2=Numeric
<=<
<==<=
<>=<>
===
>=>
>==>=
BTWN=BETWEEN
IN=IN
LIKE=LIKE
NBTN=NOT BETWEEN
NLIK=NOT LIKE
NOTI=NOT IN
DP_ROLESECPLNES(SQL Table) |
Index Back |
|---|---|
DP_ROLESECPLNES |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ROLENAME |
Character(30) | VARCHAR2(30) NOT NULL | The name of a Role in the Role Definition Table (see PSROLEDEFN). |
| 2 | DP_POLICYSET |
Character(10) | VARCHAR2(10) NOT NULL | DP_POLICYSET |
| 3 | DP_FIELDID |
Character(24) | VARCHAR2(24) NOT NULL |
DP_FIELDID
Prompt Table: DP_IPFLDSEL7_VW |
| 4 | DP_KEYCRITERIA |
Character(100) | VARCHAR2(100) NOT NULL |
DP_KEYCRITERIA
Prompt Table: %EDITTABLE2 |
| 5 | DP_FIELDTYPE | Character(1) | VARCHAR2(1) NOT NULL |
DP_FIELDTYPE
1=Character 2=Numeric |
| 6 | DP_SELECT_OPERATOR | Character(4) | VARCHAR2(4) NOT NULL |
Field selection operator
<=< <==<= <>=<> === >=> >==>= BTWN=BETWEEN IN=IN LIKE=LIKE NBTN=NOT BETWEEN NLIK=NOT LIKE NOTI=NOT IN |