T4_COMPANYPAYGROUPLANGUAGE_CDPAYGROUPSFVWLNG(SQL View) |
Index Back |
|---|---|
Rellng-PAYGROUPSFVWLNGPAYGROUPSFVWLNG is the related language recordfor the record PAYGROUP_SF_VW |
| SELECT a.company ,a.paygroup ,c.language_cd ,c.descr FROM PS_PAYGROUP_TBL a ,PS_PAYGROUP_LANG c WHERE a.COMPANY=c.COMPANY AND a.PAYGROUP=c.PAYGROUP AND a.effdt=c.effdt AND a.effdt = ( SELECT MAX(b.effdt) FROM PS_PAYGROUP_TBL b WHERE a.company = b.company AND a.paygroup = b.paygroup AND b.effdt <= %CurrentDateIn AND b.eff_status = 'A') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | T4_COMPANY |
Character(3) | VARCHAR2(3) NOT NULL | T4 Company |
| 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 |