PTBR_ETYPE_PVW(SQL View) |
Index Back |
---|---|
Active Element Type |
SELECT PTBR_ETYPE_ID , DESCR FROM %Table(PTBR_ETYPE) WHERE ACTIVE_FLAG = 'A' AND PTBR_ETYPE_ID NOT IN ('COMPANYINFO') |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | PTBR_ETYPE_ID | Character(30) | VARCHAR2(30) NOT NULL | Element Type |
2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |