GPUS_GRNTYP_VW

(SQL View)
 Index Back

Garnishment Types

Valid Garnishment Type values in numeric format

SELECT %Sql(HR_CHARTOINT,%COALESCE(%TrimSubstr(FIELDVALUE,1,4),'0')) , XLATLONGNAME FROM PSXLATITEM A WHERE FIELDNAME = 'GPUS_GRN_TYPE' AND EFF_STATUS = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 GPUS_GRN_TYPE_NUM Number(4,0) SMALLINT NOT NULL Garnishment Type in numeric format
2 DESCR Character(30) VARCHAR2(30) NOT NULL Description