RB_MATCH_CRIT_S(SQL Table) |
Index Back |
---|---|
matching criteria detailsdetails 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 |