GPUS_FEDLEVY_VW

(SQL View)
Index Back

View for FEDERAL LEVY

View For Federal Levy USA

SELECT A.PIN_MBR_NUM ,C.DESCR FROM PS_GP_ACM_MBR A , PS_GP_PIN B , PS_GP_PIN C WHERE A.PIN_NUM = B.PIN_NUM AND A.PIN_MBR_NUM = C.PIN_NUM AND B.PIN_CODE = 'GRN AC FLVYSETUP N USA'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
2 DESCR Character(30) VARCHAR2(30) NOT NULL Description