RUN_CNTL_IDRECNAMEFILE_NUMBERROW_NUMBERLI_STG_RECNUMRB_MATCH_CNT_T(SQL Table) |
Index Back |
|---|---|
Temp table for Match countsTemp table for Match counts during Data Import |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 2 | RECNAME |
Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |
| 3 | FILE_NUMBER |
Number(3,0) | SMALLINT NOT NULL | File Number |
| 4 | ROW_NUMBER |
Number(10,0) | DECIMAL(10) NOT NULL | Row Number |
| 5 | LI_STG_RECNUM |
Number(15,0) | DECIMAL(15) NOT NULL | a unique tag for each stage row |
| 6 | LI_MATCH_COUNT | Number(10,0) | DECIMAL(10) NOT NULL | Match Count |