PTPPB_PAGELET_IDWCS_ECM_PGLT_VW(SQL View) |
Index Back |
|---|---|
Compensation Chart PageletsLists pagelets available for use in the Manager Self Service pages within compensation. |
| SELECT PTPPB_PAGELET_ID , DESCR , DESCR254 , PTPPB_OPENTXT , PTPPB_CLOSETXT , PTPPB_PERSTXT FROM PS_PTPPB_PAGELET WHERE OBJECTOWNERID = 'HWCS' AND PTPPB_PGLT_CATG_ID = 'COMPENSATION' AND PTPPB_DATATYPE_ID = 'ROWSET' AND PTPPB_DISPFRMT_ID = 'CHART' AND PTPPB_EMBEDDABLE = 'Y' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PTPPB_PAGELET_ID |
Character(30) | VARCHAR2(30) NOT NULL | Pagelet ID |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 3 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |
| 4 | PTPPB_OPENTXT | Character(254) | VARCHAR2(254) NOT NULL | Opening Text |
| 5 | PTPPB_CLOSETXT | Character(254) | VARCHAR2(254) NOT NULL | Closing Text |
| 6 | PTPPB_PERSTXT | Character(254) | VARCHAR2(254) NOT NULL | Text |