PSARCH_IDROLENAMEDP_CONFIGVIEWPrompt Table: DP_CONFIGVIEWS
DP_FIELDIDPrompt Table: DP_VWFLDSE19_VW
DP_KEYCRITERIA1=Character
2=Numeric
<=<
<==<=
<>=<>
===
>=>
>==>=
BTWN=BETWEEN
IN=IN
LIKE=LIKE
NBTN=NOT BETWEEN
NLIK=NOT LIKE
NOTI=NOT IN
DPA_ROLESECLINE(SQL Table) |
Index Back |
|---|---|
DP Archive RecordOnline Table: DP_ROLESECLINES |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PSARCH_ID |
Character(8) | VARCHAR2(8) NOT NULL | Archive ID (see PSARCHTEMPLATE). |
| 2 | ROLENAME |
Character(30) | VARCHAR2(30) NOT NULL | The name of a Role in the Role Definition Table (see PSROLEDEFN). |
| 3 | DP_CONFIGVIEW |
Character(20) | VARCHAR2(20) NOT NULL |
DP_CONFIGVIEW
Prompt Table: DP_CONFIGVIEWS |
| 4 | DP_FIELDID |
Character(24) | VARCHAR2(24) NOT NULL |
DP_FIELDID
Prompt Table: DP_VWFLDSE19_VW |
| 5 | DP_KEYCRITERIA |
Character(100) | VARCHAR2(100) NOT NULL | DP_KEYCRITERIA |
| 6 | DP_FIELDTYPE | Character(1) | VARCHAR2(1) NOT NULL |
DP_FIELDTYPE
1=Character 2=Numeric |
| 7 | 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 |