COMPANYPAYGROUPEFFDTDefault Value: %date
UPG_FLSA_VW1(SQL View) |
Index Back |
|---|---|
Upgrade FLSA VW1Upgrade FLSA VW1 |
| SELECT DISTINCT B.COMPANY , B.PAYGROUP , B.EFFDT FROM PS_PAYGROUP_TBL B WHERE B.FLSA_REQUIRED = 'Y' AND B.EFF_STATUS= 'A' AND B.PAY_FREQUENCY IN ('W','B') AND B.EFFDT = ( SELECT MIN(EFFDT) FROM PS_PAYGROUP_TBL BB WHERE BB.FLSA_REQUIRED = 'Y' AND BB.EFF_STATUS= 'A' AND BB.PAY_FREQUENCY IN ('W','B') AND BB.COMPANY = B.COMPANY AND BB.PAYGROUP =B.PAYGROUP) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | COMPANY |
Character(3) | VARCHAR2(3) NOT NULL | Company |
| 2 | PAYGROUP |
Character(3) | VARCHAR2(3) NOT NULL | Pay Group |
| 3 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |