SD_RECNAMEFS_SD_SRCH_VW(SQL View) |
Index Back |
|---|
| SELECT A.SD_RECNAME , A.BASE_RECNAME , A.RECNAME , B.RECNAME_SAVED_SRCH RECNAME1 , C.RECNAME_SAVED_SRCH RECNAME2 FROM PS_FS_SD_REC A , PS_FS_SD_BASE B , PS_FS_SD_STORE C WHERE A.BASE_RECNAME = B.BASE_RECNAME AND A.RECNAME = C.RECNAME |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SD_RECNAME |
Character(15) | VARCHAR2(15) NOT NULL | Supplementa Data Record |
| 2 | BASE_RECNAME | Character(15) | VARCHAR2(15) NOT NULL | Base record that enabled for the supplemental data. |
| 3 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |
| 4 | RECNAME_1 | Character(15) | VARCHAR2(15) NOT NULL | Record 1 Name |
| 5 | RECNAME_2 | Character(15) | VARCHAR2(15) NOT NULL | Record 2 Name |