RECLIST_16_VW(SQL View) |
Index Back |
|---|---|
Records with more than 16 keys |
| SELECT DISTINCT A.RECNAME FROM PSRECFIELDDB A , PSRECDEFN C WHERE A.RECNAME = C.RECNAME AND 16 < ( SELECT COUNT (*) FROM PSRECFIELDDB B WHERE %Round((B.USEEDIT / 2),0) * ( 2) <> B.USEEDIT AND A.RECNAME = B.RECNAME) AND C.RECTYPE IN (0,3) AND A.RECNAME NOT LIKE '%_SBR' AND A.RECNAME NOT LIKE '%_AET' AND A.RECNAME NOT LIKE '%_TMP%' AND A.RECNAME NOT LIKE '%_WRK%' AND A.RECNAME NOT LIKE '%WK%' AND A.RECNAME NOT LIKE '%_TAO%' AND A.RECNAME NOT LIKE '%_TEO%' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |