GPNZ_NRP_GR2_VW

(SQL View)
 Index Back

Garnishment Details - NZL

GP NZL - Garnishment Details record

SELECT EMPLID , EMPL_RCD , PIN_NUM + 50000000 , EFFDT , GPNZ_GARN_TYPE , GPNZ_PROC_STATUS , CONTACT_NAME , GPNZ_ORDER_REF_NO , GPNZ_RCVD_DTTM , GPNZ_RSP_REQ_DTTM , COMMENTS , COUNTRY_CODE , PHONE , GPNZ_FEES FROM PS_GPNZ_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

Prompt Table: GPNZ_DED_SRCH

4 EFFDT Date(10) DATE NOT NULL Effective Date

Default Value: %DATE

5 GPNZ_GARN_TYPE Character(2) VARCHAR2(2) NOT NULL GP NZL - Garnishment type
10=Assignment
20=Bankruptcy
30=Child Support
40=Dependant
50=Tax Levy
60=Writ
6 GPNZ_PROC_STATUS Character(2) VARCHAR2(2) NOT NULL GP NZL - 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 GPNZ_ORDER_REF_NO Character(25) VARCHAR2(25) NOT NULL Garnishment Order Reference Number
9 GPNZ_RCVD_DTTM DateTime(26) TIMESTAMP GP NZL - Garnishment Received date and time.
10 GPNZ_RSP_REQ_DTTM DateTime(26) TIMESTAMP GP NZL - 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 GPNZ_FEES Signed Number(20,6) DECIMAL(18,6) NOT NULL GP NZL - Garnishement fees