Prompt Table: PSRECDEFN
EOEW_LU_FLDNAMEEOEW_LUFLST_VW(SQL View) |
Index Back |
|---|---|
PSRECFIELDS (tables and views)This View is used to retrieve fields available for tables and views. |
| SELECT B.RECNAME , B.FIELDNAME FROM PSRECDEFN A , PSRECFIELD B WHERE A.RECNAME = B.RECNAME AND A.RECTYPE IN (0,1) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EOEW_LU_RECNAME | Character(15) | VARCHAR2(15) NOT NULL |
Look up record name
Prompt Table: PSRECDEFN |
| 2 | EOEW_LU_FLDNAME |
Character(18) | VARCHAR2(18) NOT NULL | Look Up Field Name |