SECTION_IDGPAU_WGEA_SE_VW(SQL View) |
Index Back |
|---|---|
WGEA Remuneration configuratioWGEA Remuneration configuration Search record |
| SELECT a.SECTION_ID ,a.DESCR100 FROM PS_GPAU_WGEA_SECTN a WHERE a.effdt = ( SELECT MAX(b.effdt) FROM PS_GPAU_WGEA_SECTN b WHERE b.section_id = a.section_id AND b.effdt <= %CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SECTION_ID |
Character(10) | VARCHAR2(10) NOT NULL | Section ID for sections in the rule. |
| 2 | DESCR100 | Character(100) | VARCHAR2(100) NOT NULL | Length 100 Description |