EOEW_TAR_OBJEOEW_RECDEFN_VW(SQL View) |
Index Back |
|---|---|
Record definition view |
| SELECT RECNAME , RECDESCR , CASE WHEN SQLTABLENAME = ' ' THEN 'PS_' %Concat RECNAME ELSE SQLTABLENAME END FROM PSRECDEFN WHERE RECTYPE IN (0,1) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EOEW_TAR_OBJ |
Character(15) | VARCHAR2(15) NOT NULL | Target Object |
| 2 | RECDESCR | Character(30) | VARCHAR2(30) NOT NULL | Record Description |
| 3 | EOEW_SRCTABLE | Character(80) | VARCHAR2(80) NOT NULL | Source Record Name |