RECNAMEPrompt Table: EOTR_PT_TBL_VW
EOTR_PT_TBL_VW(SQL View) |
Index Back |
|---|---|
PeopleTools TablesView for tables contained in PPLTOOLS project |
| SELECT RECNAME FROM PSRECDEFN A WHERE RECTYPE = 0 AND EXISTS ( SELECT 'X' FROM PSPROJECTITEM B WHERE B.PROJECTNAME = 'PPLTOOLS' AND B.OBJECTTYPE = 0 AND B.OBJECTID1 = 1 AND A.RECNAME = B.OBJECTVALUE1 AND B.OBJECTVALUE1 NOT IN('SETID_TBL','SET_CNTRL_REC','SET_CNTRL_GROUP','SET_CNTRL_TBL', 'SET_CNTRL_TREE','REC_GROUP_REC','REC_GROUP_TBL')) AND RECNAME NOT IN ('PM_PS_REC', 'PM_PS_REC_WHERE', 'PM_PS_RECUP_WHE', 'PM_PS_DMO_REC', 'PM_PS_DMO_WHERE', 'PM_PS_TSTTBLS', 'PM_PS_TSTWHERE', 'PM_PS_TST_REC', 'PM_PS_TST_WHERE', 'PM_PS_SAAS_REC', 'PM_PS_SAS_WHERE', 'PM_PS_ADS_REC', 'PM_PS_ADS_WHERE') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RECNAME |
Character(15) | VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
Prompt Table: EOTR_PT_TBL_VW |