RB_MATCH_CRIT_S

(SQL Table)
Index Back

matching criteria details

details for matching criteria

# 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 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
5 CR_OPEN_BRCT Character(2) VARCHAR2(2) NOT NULL Open bracket type for rule specifications
01=(
02=((
03=(((
04=((((
6 CR_AND_OR Character(2) VARCHAR2(2) NOT NULL Open bracket type for rule specifications
01=AND
02=OR

Default Value: 01

7 LI_TEMPLATE_ID Character(31) VARCHAR2(31) NOT NULL template identifier
8 LI_TREE_SEQ Number(3,0) SMALLINT NOT NULL in what position is this tree element?
9 LI_TGT_FIELDNAME Character(30) VARCHAR2(30) NOT NULL Target Field Name
10 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
11 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
12 CR_CLOSE_BRCT Character(2) VARCHAR2(2) NOT NULL Open bracket type for rule specifications
01=)
02=))
03=)))
04=))))
13 LI_UNIQUE_ID Character(31) VARCHAR2(31) NOT NULL Unique_Id