EODI_CON_REC_VW(SQL View) |
Index Back |
---|---|
Dynamic Record Prompt View |
SELECT A.RECNAME , A.RECDESCR FROM PSRECDEFN A , PSRECFIELD B WHERE A.RECNAME = B.RECNAME AND B.FIELDNAME = 'EODI_CON_SBR' AND A.RECNAME <> 'EODI_CON' AND A.RECNAME <> 'EODI_DYN_CONTEX' |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | EODI_RECNAME | Character(15) | VARCHAR2(15) NOT NULL | Recname |
2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |