ASSTN_NAMESEQ_NUMFIELDNAME<=Less Than
<==Less Than or Equal To
<>=Not Equal To
==Equal To
>=Greater Than
>==Greater Than or Equal To
AP_ASSTNDTL_CRT(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ASSTN_NAME |
Character(30) | VARCHAR2(30) NOT NULL | Association Name |
| 2 | SEQ_NUM |
Number(3,0) | SMALLINT NOT NULL | Sequence |
| 3 | FIELDNAME |
Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 4 | OPERATION | Character(3) | VARCHAR2(3) NOT NULL |
Arithmetic Operation
<=Less Than <==Less Than or Equal To <>=Not Equal To ==Equal To >=Greater Than >==Greater Than or Equal To |
| 5 | FIELDVALUE | Character(4) | VARCHAR2(4) NOT NULL | Field Value |