GPMX_STC_TAX_VW

(SQL View)
Index Back

Special State Taxes Concep VW

Special State Taxes Concepts for Mexico Country Extension.

SELECT DISTINCT A.COUNTRY , A.STATE , A.EFFDT , A.PIN_NUM , B.CAL_RUN_ID , B.GP_PAYGROUP , A.ENTRY_TYPE_ELEM FROM PS_GPMX_ST_TAXES_C A , PS_GP_CAL_RUN_DTL B WHERE A.EFFDT = ( SELECT MAX(A_ED.EFFDT) FROM PS_GPMX_ST_TAXES_C A_ED WHERE A.COUNTRY = A_ED.COUNTRY AND A.STATE = A_ED.STATE AND A_ED.EFFDT <= B.PRD_END_DT) AND B.CALC_TYPE = 'P' AND A.COUNTRY = B.COUNTRY

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
2 STATE Character(6) VARCHAR2(6) NOT NULL State

Prompt Table: GPMX_STATE_VW

3 EFFDT Date(10) DATE NOT NULL Effective Date

Default Value: %date

4 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number

Prompt Table: %GP_EDIT_FLD7

5 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id
6 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group
7 ENTRY_TYPE_ELEM Character(3) VARCHAR2(3) NOT NULL entry type element

Prompt Table: GP_ENT_E_D_VW