SELY/N Table Edit
Default Value: N
RECNAMEFIELDNAMEIN_ITM_CH_SL_VW(SQL View) |
Index Back |
|---|
| SELECT 'N' , A.RECNAME , A.FIELDNAME FROM PSRECFIELDALL A WHERE NOT EXISTS ( SELECT 'X' FROM PSRECFLDKEYVW B WHERE A.RECNAME = B.RECNAME AND A.FIELDNAME = B.FIELDNAME) AND NOT EXISTS( SELECT 'X' FROM PSRECFIELDALL D WHERE D.RECNAME = 'IN_ITM_EXCE_WRK' AND D.FIELDNAME = A.FIELDNAME) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SEL |
Character(1) | VARCHAR2(1) NOT NULL |
Select
Y/N Table Edit Default Value: N |
| 2 | RECNAME |
Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |
| 3 | FIELDNAME |
Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |