GPES_TAX_FLX_VW(SQL View) |
Index Back |
|---|---|
Adjust Tax Estimation VW ESPAdjust Tax Estimation VW ESP |
| SELECT B.SETID ,B.LABOR_AGREEMENT ,B.EFFDT ,A.PIN_NUM ,D.EFF_STATUS ,A.PIN_NUM_2 ,C.FREQ_ANNUAL_FACTOR ,C.FREQUENCY_TYPE FROM PS_GPES_TAX_FLXERN A ,PS_GPES_TAX_FLXLBR B ,PS_FREQUENCY_TBL C ,PS_GPES_TAX_FLXSET D WHERE A.GPES_TAX_FLX_ID=B.GPES_TAX_FLX_ID AND A.GPES_TAX_FLX_ID=D.GPES_TAX_FLX_ID AND A.EFFDT=B.EFFDT AND A.EFFDT=D.EFFDT AND A.FREQUENCY_ID=C.FREQUENCY_ID AND C.EFFDT =( SELECT MAX(X.EFFDT) FROM PS_FREQUENCY_TBL X WHERE X.EFFDT<=A.EFFDT AND X.FREQUENCY_ID=C.FREQUENCY_ID) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | LABOR_AGREEMENT | Character(6) | VARCHAR2(6) NOT NULL | Labor Agreement |
| 3 | EFFDT | Date(10) | DATE | Effective Date |
| 4 | PIN_NUM | Number(8,0) | INTEGER NOT NULL | PIN Number |
| 5 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |
| 6 | PIN_NUM_2 | Number(8,0) | INTEGER NOT NULL | Pin Number 2 |
| 7 | FREQ_ANNUAL_FACTOR | Number(12,7) | DECIMAL(11,7) NOT NULL | Specifies the factor used for annualization/deannualization in a frequency conversion. The Frequency Annualization Factor is expressed in times per year. |
| 8 | FREQUENCY_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Indicates the type of a frequency ID.
A=Annual B=Biweekly C=Contract D=Daily F=Every Four Weeks H=Hourly M=Monthly Q=Quarterly S=Semimonthly W=Weekly |