RUN_CNTL_IDLI_MATCHING_IDSEQ_NUMSEQUENCEY/N Table Edit
Default Value: N
RB_MATCHING_VW(SQL View) |
Index Back |
|---|---|
Cache table for Matching SQLThis table is populated at Run Time with Match SQLs to be executed during the Data Import Process. |
| SELECT RUN_CNTL_ID , LI_MATCHING_ID , SEQ_NUM , SEQUENCE , SQL_STMT_254 , START_DTTM , END_DTTM , RB_IMPT_MODIFIED FROM PS_RB_MATCHING_SQL WHERE SEQUENCE = 1 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 2 | LI_MATCHING_ID |
Character(31) | VARCHAR2(31) NOT NULL | matching spec id |
| 3 | SEQ_NUM |
Number(3,0) | SMALLINT NOT NULL | Sequence |
| 4 | SEQUENCE |
Number(3,0) | SMALLINT NOT NULL | Sequence |
| 5 | SQL_STMT_254 | Character(254) | VARCHAR2(254) NOT NULL | An internal work field that contains SQL text that is to be utilized in treasury application p |
| 6 | START_DTTM | DateTime(26) | TIMESTAMP | start date time |
| 7 | END_DTTM | DateTime(26) | TIMESTAMP | end date time |
| 8 | RB_IMPT_MODIFIED | Character(1) | VARCHAR2(1) NOT NULL |
Indicate a Data Import Matching Statement was modified or not
Y/N Table Edit Default Value: N |