RECNAMEEDR_REC_VW(SQL View) |
Index Back |
|---|---|
OTBI TFLT Rec ViewOTBI Tree Flattener prompt view |
| SELECT RECNAME FROM PSRECDEFN A WHERE (RECTYPE = 0 OR RECTYPE = 1) AND EXISTS ( SELECT 'X' FROM PSRECFIELDDB X WHERE A.RECNAME = X.RECNAME AND X.FIELDNAME = 'EFFDT' ) AND EXISTS ( SELECT 'X' FROM PSRECFIELDDB X2 WHERE A.RECNAME = X2.RECNAME AND X2.FIELDNAME = 'INEFFDT') AND NOT EXISTS ( SELECT 'X' FROM PSRECFIELDDB X2 WHERE A.RECNAME = X2.RECNAME AND X2.FIELDNAME = 'TREE_NAME') AND NOT EXISTS ( SELECT 'X' FROM PS_EDR_DEFN_TBL X3 WHERE A.RECNAME = X3.EDR_RECNAME ) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RECNAME |
Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |