GPUS_TX_RPT_VW

(SQL View)
 Index Back

Tax Report Type View

Contains the PIN and the user key position of elements that have variable element "TAX VR TAX RPT TYPE" as a user key. The KEYPOSN field holds the value of the user key that is defined with variable "TAX VR TAX RPT TYPE", i.e. if user key 3 contains the variable, then KEYPOSN has the value of 3.

SELECT AC.PIN_NUM ,1 FROM PS_GP_ACCUMULATOR AC WHERE AC.PIN_USER_KEY1_NUM = ( SELECT PIN1.PIN_NUM FROM PS_GP_PIN PIN1 WHERE PIN1.PIN_CODE = 'TAX VR RPT TYPE USA') UNION SELECT AC.PIN_NUM ,2 FROM PS_GP_ACCUMULATOR AC WHERE AC.PIN_USER_KEY2_NUM = ( SELECT PIN1.PIN_NUM FROM PS_GP_PIN PIN1 WHERE PIN1.PIN_CODE = 'TAX VR RPT TYPE USA') UNION SELECT AC.PIN_NUM ,3 FROM PS_GP_ACCUMULATOR AC WHERE AC.PIN_USER_KEY3_NUM = ( SELECT PIN1.PIN_NUM FROM PS_GP_PIN PIN1 WHERE PIN1.PIN_CODE = 'TAX VR RPT TYPE USA') UNION SELECT AC.PIN_NUM ,4 FROM PS_GP_ACCUMULATOR AC WHERE AC.PIN_USER_KEY4_NUM = ( SELECT PIN1.PIN_NUM FROM PS_GP_PIN PIN1 WHERE PIN1.PIN_CODE = 'TAX VR RPT TYPE USA') UNION SELECT AC.PIN_NUM ,5 FROM PS_GP_ACCUMULATOR AC WHERE AC.PIN_USER_KEY5_NUM = ( SELECT PIN1.PIN_NUM FROM PS_GP_PIN PIN1 WHERE PIN1.PIN_CODE = 'TAX VR RPT TYPE USA') UNION SELECT AC.PIN_NUM ,6 FROM PS_GP_ACCUMULATOR AC WHERE AC.PIN_USER_KEY6_NUM = ( SELECT PIN1.PIN_NUM FROM PS_GP_PIN PIN1 WHERE PIN1.PIN_CODE = 'TAX VR RPT TYPE USA')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
2 KEYPOSN Number(3,0) SMALLINT NOT NULL Key Position