ADP_PAYGROUP_VW(SQL View) |
Index Back |
|---|---|
ADP Paygroup ViewUsed for ADP Connection to map PeopleSoft Company/Paygroup |
| SELECT A.COMPANY , A.PAYGROUP , A.PAY_FREQUENCY , DESCRSHORT , DESCR FROM PS_PAYGROUP_TBL A WHERE A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_PAYGROUP_TBL B WHERE B.EFFDT <= %CurrentDateIn AND A.COMPANY = B.COMPANY AND A.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 | PAY_FREQUENCY | Character(5) | VARCHAR2(5) NOT NULL |
Pay Frequency
A=Annual B=Biweekly D=Daily M=Monthly Q=Quarterly S=Semimonthly W=Weekly |
| 4 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |