RB_MATCH_CRIT(SQL Table) |
Index Back |
---|---|
matching criteriaDefines the logical criterion under which a match field is included |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | LI_MATCHING_ID | Character(31) | VARCHAR2(31) NOT NULL | matching spec id |
2 | EFFDT | Date(10) | DATE |
Effective Date
Default Value: %date |
3 | CRITERIA_SEQ | Number(3,0) | SMALLINT NOT NULL | sequence nbr for match criteria |
4 | CR_AND_OR | Character(2) | VARCHAR2(2) NOT NULL |
Open bracket type for rule specifications
01=AND 02=OR |