GPAU_NRP_GRN_VW

(SQL View)
 Index Back

Garnishment Details - AUS

GP AUS - Garnishment Details record

SELECT EMPLID ,EMPL_RCD ,PIN_NUM + 50000000 ,EFFDT ,GPAU_GARN_TYPE ,GPAU_PROC_STATUS ,CONTACT_NAME ,GPAU_ORDER_REF_NO ,GPAU_RCVD_DT_TM ,GPAU_RSP_REQ_DT_TM ,COMMENTS ,COUNTRY_CODE ,PHONE ,GPAU_FEES FROM PS_GPAU_GARN_DTLS

# 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 EFFDT Date(10) DATE NOT NULL Effective Date
5 GPAU_GARN_TYPE Character(2) VARCHAR2(2) NOT NULL GP Australia - Garnishment type
10=Assignment
20=Bankruptcy
30=Child Support
40=Dependant
50=Tax Levy
60=Writ
6 GPAU_PROC_STATUS Character(2) VARCHAR2(2) NOT NULL GP Australia - Garnishment Processing Status
10=Approved
20=Completed
30=Rejected
40=Received
50=Suspended
7 CONTACT_NAME Character(50) VARCHAR2(50) NOT NULL Contact Name
8 GPAU_ORDER_REF_NO Character(25) VARCHAR2(25) NOT NULL Garnishment Order Reference Number
9 GPAU_RCVD_DT_TM DateTime(26) TIMESTAMP GP Australia - Garnishment Received date and time.
10 GPAU_RSP_REQ_DT_TM DateTime(26) TIMESTAMP GP Australia - Garnishment Response required date and time.
11 COMMENTS Long Character CLOB Comment
12 COUNTRY_CODE Character(3) VARCHAR2(3) NOT NULL Country Code
13 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone
14 GPAU_FEES Signed Number(20,6) DECIMAL(18,6) NOT NULL GP Australia - Garnishement fees