HRS_DUPREC_ID(SQL View) |
Index Back |
|---|
| SELECT A.RECNAME FROM PS_HRS_DUP_RECS A WHERE NOT EXISTS ( SELECT 'X' FROM PS_HRS_DUPREC_EFF A1 WHERE A1.RECNAME = A.RECNAME) AND NOT EXISTS ( SELECT 'X' FROM PS_HRS_DUPREC_DT B1 WHERE B1.RECNAME = A.RECNAME) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |