GP_PKG_APPLY_VW(SQL View) |
Index Back |
---|---|
Package Apply ViewThis view selects those packages that exist in the database. Both Version and Regular rule packages can be selected. |
SELECT GP_PKG_ID , GP_VERSION_IND , DESCR FROM PS_GP_PKG_DFN |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | GP_PKG_ID | Character(10) | VARCHAR2(10) NOT NULL | Field used for element packaging |
2 | GP_VERSION_IND | Character(1) | VARCHAR2(1) NOT NULL |
Indicates whether version-based.
N=Regular Rule Package Y=Version Rule Package |
3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |