RULE_IDPMT_CRITERIA_IDPMT_RULE_FIELD_IDPrompt Table: PMT_SEC_FLD_VW
01=(
02=((
03=(((
04=((((
<=Less Than
==Equals
>=Greater Than
IN=In
01=)
02=))
03=)))
04=))))
1=AND
2=OR
PMT_CRITERIA(SQL Table) |
Index Back |
|---|---|
Payment CriteriaRule Criteria that contains the field and operations for those fields. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RULE_ID |
Character(20) | VARCHAR2(20) NOT NULL | Rule ID |
| 2 | PMT_CRITERIA_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Unique Identifier for Rule Criteria |
| 3 | PMT_RULE_FIELD_ID |
Character(18) | VARCHAR2(18) NOT NULL |
Unique identifier for a field referenced in a rule.
Prompt Table: PMT_SEC_FLD_VW |
| 4 | OPEN_BRCKT | Character(2) | VARCHAR2(2) NOT NULL |
Represents SQL parentheses syntax for purposes of precedence when the user is creating node specific data
01=( 02=(( 03=((( 04=(((( |
| 5 | CRITERIA_OP | Character(3) | VARCHAR2(3) NOT NULL |
Type of operation for a given criteria
<=Less Than ==Equals >=Greater Than IN=In |
| 6 | VALUE_TR | Character(254) | VARCHAR2(254) NOT NULL | VALUE_TR field for Treausry sub-system. We have used this field to replace VALUE filed. |
| 7 | CLOSE_BRCKT | Character(2) | VARCHAR2(2) NOT NULL |
Represents SQL parentheses syntax for purposes of precedence when the user is creating node specific dat
01=) 02=)) 03=))) 04=)))) |
| 8 | AND_OR | Character(1) | VARCHAR2(1) NOT NULL |
Operator
1=AND 2=OR |