SETIDFA_FEE_CODESEQ_NUMPrompt Table: FA_AGGFIELD_VW
<=<
<==<=
<>=<>
===
>=>
>==>=
B=Begins With
C=Contains
E=Ends With
NB=Doesn't Begins With
NC=Doesn't Contains
NE=Doesn't Ends With
FA_FEE_CD_SQL(SQL Table) |
Index Back |
|---|---|
Fee Analysis SQLSQL Statements to build the Fee Analysis SQL. Sh |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | FA_FEE_CODE |
Character(20) | VARCHAR2(20) NOT NULL | Fee code mapped to Bank Fee code used for Fee Analysis. |
| 3 | SEQ_NUM |
Number(3,0) | SMALLINT NOT NULL | Sequence |
| 4 | FA_SQL_AGGREGATE | Character(18) | VARCHAR2(18) NOT NULL |
This is the field that we do aggregate on when building the sql.
Prompt Table: FA_AGGFIELD_VW |
| 5 | COMP_OPERATOR | Character(2) | VARCHAR2(2) NOT NULL |
Represents SQL field comparison syntax when the user is creating node specific data selection criteria
<=< <==<= <>=<> === >=> >==>= B=Begins With C=Contains E=Ends With NB=Doesn't Begins With NC=Doesn't Contains NE=Doesn't Ends With |
| 6 | FIELD_VALUE_STR | Character(30) | VARCHAR2(30) NOT NULL | An accounting template field designated to support the substitution of desired character field values du |