RB_MATCH_CRIT

(SQL Table)
Index Back

matching criteria

Defines 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