RECNAMEIDRCFLD_VW(SQL View) |
Index Back |
|---|---|
Record Names ViewA selection of all records (record type 0) from the PSRECDEFN record. |
| SELECT DISTINCT A.RECNAME FROM PS_ID_DEL_RCFLD_VW A WHERE (A.RECNAME NOT LIKE 'AUDIT%' AND A.RECNAME NOT LIKE 'UPG%' AND RECNAME NOT LIKE '%AET' ) OR (A.FIELDNAME = 'COMMON_ID' AND A.RECNAME NOT LIKE 'AUDIT%' AND A.RECNAME NOT LIKE 'UPG%') OR (A.EDITTABLE IN ('PERSON','TRN_CRS_INSTRCT','PERS_DTA_EMP_VW','PERSON_NAME', 'REVIEWER_NM_VW', 'WORKER_PROMPT') AND A.FIELDNAME <> 'EMPLID') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RECNAME |
Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |