GPUS_GRNEFT_VW

(SQL View)
 Index Back

Garnishment EFT View

Garnishment Electronic Fund Transfer View

SELECT DISTINCT A.EMPLID , A.EMPL_RCD , A.PIN_NUM , A.RECIPIENT_TAG , A.EFFDT , A.GPUS_GRN_CASEID , B.GPUS_ID , C.GPUS_FIPS , D.GPUS_STATE , E.SOVR_VAL_NUM FROM PS_GPUS_GRNCASE_VW A , PS_GPUS_GRNID_VW B , PS_GPUS_GRNFIPS_VW C , PS_GPUS_GRNST_VW D , PS_GPUS_GRNTYPE_VW E WHERE A.EMPLID = B.EMPLID AND A.EMPL_RCD = B.EMPL_RCD AND A.PIN_NUM = B.PIN_NUM AND A.RECIPIENT_TAG = B.RECIPIENT_TAG AND A.EMPLID = C.EMPLID AND A.EMPL_RCD = C.EMPL_RCD AND A.PIN_NUM = C.PIN_NUM AND A.RECIPIENT_TAG = C.RECIPIENT_TAG AND A.EMPLID = D.EMPLID AND A.EMPL_RCD = D.EMPL_RCD AND A.PIN_NUM = D.PIN_NUM AND A.RECIPIENT_TAG = D.RECIPIENT_TAG AND A.EMPLID = E.EMPLID AND A.EMPL_RCD = E.EMPL_RCD AND A.PIN_NUM = E.PIN_NUM AND A.RECIPIENT_TAG = E.RECIPIENT_TAG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
3 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
4 RECIPIENT_TAG Number(3,0) SMALLINT NOT NULL Used to identify recipients for E/D, PI
5 EFFDT Date(10) DATE Effective Date

Default Value: %date

6 GPUS_GRN_CASEID Character(25) VARCHAR2(25) NOT NULL Case Identification Number
7 GPUS_ID Character(25) VARCHAR2(25) NOT NULL ID Field
8 GPUS_FIPS Character(25) VARCHAR2(25) NOT NULL FIPS Code
9 GPUS_STATE Character(25) VARCHAR2(25) NOT NULL State
10 SOVR_VAL_NUM Signed Number(20,6) DECIMAL(18,6) NOT NULL Supporting Element Numeric Value