EOEP_APPCD_USED(SQL View) |
Index Back |
---|---|
Application codes usedApplication codes used on arbitration plan |
SELECT DISTINCT a.setid , a.eoep_app_cd , b.descr FROM PS_EOEP_ARB_PLAN a , ps_eoep_app_code b WHERE a.eoep_app_cd = b.eoep_app_cd AND b.eoep_parent_app = ' ' |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | SETID | Character(5) | VARCHAR2(5) NOT NULL | This field is used to store the value of SetID on various setup tables. |
2 | EOEP_APP_CD | Character(4) | VARCHAR2(4) NOT NULL | Transaction Code |
3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |