SCRTY_KEY1PAYGROUPSEC_PAYGROUP_VW(SQL View) |
Index Back |
|---|---|
Paygroups View |
| SELECT COMPANY ,PAYGROUP ,DESCR FROM PS_PAYGROUP_TBL A WHERE A.EFFDT = ( SELECT MAX(EFFDT) FROM PS_PAYGROUP_TBL B WHERE A.COMPANY = B.COMPANY AND A.PAYGROUP = B.PAYGROUP AND B.EFFDT <= %CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SCRTY_KEY1 |
Character(20) | VARCHAR2(20) NOT NULL | Contains the value of the field used for row level security for Job access - setid. |
| 2 | PAYGROUP |
Character(3) | VARCHAR2(3) NOT NULL | Pay Group |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |