SCRTY_KEY1PAYGROUPLANGUAGE_CDSEC_PAYGROUP_LN(SQL View) |
Index Back |
|---|---|
Paygroups View |
| SELECT A.COMPANY ,A.PAYGROUP , L.LANGUAGE_CD ,L.DESCR FROM PS_PAYGROUP_TBL A , PS_PAYGROUP_LANG L 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) AND A.COMPANY = L.COMPANY AND A.PAYGROUP = L.PAYGROUP AND A.EFFDT = L.EFFDT |
| # | 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 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |