PTSF_PKGROOT_VW(SQL View) |
Index Back |
---|---|
App Class Roots |
SELECT DISTINCT A.packageroot , B.descr FROM PSAPPCLASSDEFN A , PSPACKAGEDEFN B WHERE A.packageroot = B.packageroot AND A.packageroot = B.packageid |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | PACKAGEROOT | Character(30) | VARCHAR2(30) NOT NULL | Root Package ID |
2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |