JPM_JP_GRP_TYPEJPM_JP_GROUPJPM_GRP_SEQAND=AND
WHER=WHERE
Default Value: AND
Prompt Table: JPM_GPBLD_FL_VW
<=less than
<==less than or equal to
==equal to
>=greater than
>==greater than or equal to
BL=is blank
BN=is not blank
LK=like
NL=not like
JPM_GRP_FILTER(SQL Table) |
Index Back |
|---|---|
Group Build Filter CriteriaThe criter used to build a group defined from the Profile Group Page. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | JPM_JP_GRP_TYPE |
Character(12) | VARCHAR2(12) NOT NULL | Group type to which a JPM profile group belongs |
| 2 | JPM_JP_GROUP |
Character(12) | VARCHAR2(12) NOT NULL | ID of the Profile Group to which a JPM profile belongs |
| 3 | JPM_GRP_SEQ |
Number(3,0) | SMALLINT NOT NULL | Filter Sequence |
| 4 | JPM_GRP_CONDITN | Character(4) | VARCHAR2(4) NOT NULL |
Search Condition
AND=AND WHER=WHERE Default Value: AND |
| 5 | JPM_GRP_FIELD | Character(18) | VARCHAR2(18) NOT NULL |
Field Name
Prompt Table: JPM_GPBLD_FL_VW |
| 6 | JPM_GRP_OPER | Character(2) | VARCHAR2(2) NOT NULL |
Operator
<=less than <==less than or equal to ==equal to >=greater than >==greater than or equal to BL=is blank BN=is not blank LK=like NL=not like |
| 7 | JPM_GRP_VALUE | Character(30) | VARCHAR2(30) NOT NULL | Value |