GPUS_NRP_GRN_VW

(SQL View)
 Index Back

Garnishment View

Garnishment View

SELECT GPUS_GRN_ID , EMPLID , GPUS_RLAWSRC , GPUS_PIN_PROFM_NUM + 50000000 , GPUS_PIN_LMCAL_NUM + 50000000 , GPUS_PIN_LMCF_NUM + 50000000 , GPUS_PIN_LMPF_NUM + 50000000 ,GPUS_GRN_STATUS ,GPUS_GRN_TYPE ,GPUS_GRN_SUBTYPE ,GPUS_PRIORITY ,GPUS_EST_DT ,GPUS_REC_DT ,GPUS_REC_TM , GPUS_RES_DT , GPUS_RES_TM , GPUS_REC_DTTM , GPUS_RES_DTTM , GPUS_AGENCYNM , GPUS_ATTRNYNM , COUNTRY , ADDRESS1 , ADDRESS2 , ADDRESS3 , ADDRESS4 , CITY , NUM1 , NUM2 , HOUSE_TYPE , ADDR_FIELD1 , ADDR_FIELD2 , ADDR_FIELD3 , COUNTY , STATE , POSTAL , GEO_CODE , IN_CITY_LIMIT , CONTACT_NAME , PHONE , EMAILID , GPUS_REMARKS , GPUS_RULEID , GPUS_PRLAWSRC , GPUS_AUTOSTDFLAG , GPUS_STARTDT , GPUS_DED_STARTDT , GPUS_ENDDT , GPUS_STOPDAYS , GPUS_CALDAYSFLAG , GPUS_GRN_LMAMT , CURRENCY_CD , GPUS_GRN_BAL , GPUS_LMFREQ , GPUS_LMCF_FREQ , GPUS_LMPF_FREQ , GPUS_PAY_FEEIND , GPUS_COMP_FEEIND , RECIPIENT_ID , GPUS_GRN_ANLMT_AMT , DATA_TYPE_CD FROM PS_GPUS_GRN

  • Related Language Record: GPUS_GRN_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 GPUS_GRN_ID Character(16) VARCHAR2(16) NOT NULL GPUS_GARNID
    2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    3 GPUS_RLAWSRC Character(6) VARCHAR2(6) NOT NULL GPUS_LAWSRC

    Prompt Table: GPUS_STATE_VW

    4 GPUS_PIN_PROFM_NUM Number(8,0) INTEGER NOT NULL Proration Formula PIN Number

    Prompt Table: GPUS_GRN_PRO_VW

    5 GPUS_PIN_LMCAL_NUM Number(8,0) INTEGER NOT NULL Limit Calculation Formula PIN Number

    Prompt Table: GPUS_LCAL_VW

    6 GPUS_PIN_LMCF_NUM Number(8,0) INTEGER NOT NULL Company Fee Limit Formula PIN Number

    Prompt Table: GPUS_LCF_VW

    7 GPUS_PIN_LMPF_NUM Number(8,0) INTEGER NOT NULL Recipient Fee Limit Formula PIN Number

    Prompt Table: GPUS_LPF_VW

    8 GPUS_GRN_STATUS Character(2) VARCHAR2(2) NOT NULL Garnishment Status
    10=Active
    30=Suspended
    40=Rejected
    50=Completed

    Default Value: 10

    9 GPUS_GRN_TYPE Character(4) VARCHAR2(4) NOT NULL GPUS_GARNTYPE
    10=Child Support
    20=Dependent Support
    30=Spousal Support
    40=Tax Levy
    50=Creditor Garnishment
    60=Student Loan
    70=Chapter 13 Bankruptcy
    80=AWG - Wage Garnishment
    90=Wage Assignment

    Default Value: 10

    10 GPUS_GRN_SUBTYPE Character(2) VARCHAR2(2) NOT NULL GPUS_SUBTYPE
    10=Current
    20=Arrears

    Default Value: 10

    11 GPUS_PRIORITY Number(4,0) SMALLINT NOT NULL GPUS_PRIORITY
    12 GPUS_EST_DT Date(10) DATE Date Established
    13 GPUS_REC_DT Date(10) DATE NOT NULL Received Date
    14 GPUS_REC_TM Time(15) TIMESTAMP Received Time
    15 GPUS_RES_DT Date(10) DATE Response Date
    16 GPUS_RES_TM Time(15) TIMESTAMP Response Time
    17 GPUS_REC_DTTM DateTime(26) TIMESTAMP GPUS_RECDTTM

    Default Value: %Datetime

    18 GPUS_RES_DTTM DateTime(26) TIMESTAMP Response Date

    Default Value: %Datetime

    19 GPUS_AGENCYNM Character(60) VARCHAR2(60) NOT NULL Agency Name
    20 GPUS_ATTRNYNM Character(50) VARCHAR2(50) NOT NULL Attroney Name
    21 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Prompt Table: COUNTRY_TBL

    22 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
    23 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
    24 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
    25 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
    26 CITY Character(30) VARCHAR2(30) NOT NULL City
    27 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1
    28 NUM2 Character(6) VARCHAR2(6) NOT NULL Number 2
    29 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
    AB=House Boat Reference
    WW=House Trailer Reference
    30 ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1
    31 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2
    32 ADDR_FIELD3 Character(4) VARCHAR2(4) NOT NULL Address Field 3
    33 COUNTY Character(30) VARCHAR2(30) NOT NULL County
    34 STATE Character(6) VARCHAR2(6) NOT NULL State

    Prompt Table: STATE_TBL

    35 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
    36 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code
    37 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit

    Y/N Table Edit

    38 CONTACT_NAME Character(50) VARCHAR2(50) NOT NULL Contact Name
    39 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone
    40 EMAILID Character(70) VARCHAR2(70) NOT NULL A user's E-mail address
    41 GPUS_REMARKS Long Character CLOB GPUS_REMARKS
    42 GPUS_RULEID Character(30) VARCHAR2(30) NOT NULL GPUS_RULEID

    Prompt Table: GPUS_GRN_RUL_VW

    43 GPUS_PRLAWSRC Character(6) VARCHAR2(6) NOT NULL GPUS_LAWSRC

    Prompt Table: GPUS_STATE_VW

    44 GPUS_AUTOSTDFLAG Character(1) VARCHAR2(1) NOT NULL GPUS_CALDAYSFLAG
    N=No
    Y=Yes
    45 GPUS_STARTDT Date(10) DATE GPUS_STARTDT

    Default Value: %Date

    46 GPUS_DED_STARTDT Date(10) DATE GPUS_STARTDT

    Default Value: %Date

    47 GPUS_ENDDT Date(10) DATE GPUS_ENDDT
    48 GPUS_STOPDAYS Number(3,0) SMALLINT NOT NULL GPUS_STOPDAYS
    49 GPUS_CALDAYSFLAG Character(1) VARCHAR2(1) NOT NULL GPUS_CALDAYSFLAG
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

    50 GPUS_GRN_LMAMT Number(19,6) DECIMAL(18,6) NOT NULL GPUS_GARNLIMITAMT
    51 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    52 GPUS_GRN_BAL Number(19,6) DECIMAL(18,6) NOT NULL GPUS_GARNBAL
    53 GPUS_LMFREQ Character(2) VARCHAR2(2) NOT NULL GPUS_LIMITFREQ
    10=Weekly
    20=Biweekly
    30=Semi-Monthly
    40=Monthly

    Default Value: 10

    54 GPUS_LMCF_FREQ Character(2) VARCHAR2(2) NOT NULL GPUS_LIMITCFEEFREQ
    10=Weekly
    20=Biweekly
    30=Semi-Monthly
    40=Monthly

    Default Value: 10

    55 GPUS_LMPF_FREQ Character(2) VARCHAR2(2) NOT NULL GPUS_LIMITPFEEFREQ
    10=Weekly
    20=Biweekly
    30=Semi-Monthly
    40=Monthly

    Default Value: 10

    56 GPUS_PAY_FEEIND Character(1) VARCHAR2(1) NOT NULL GPUS_PAYFEEIND
    N=No
    Y=Yes

    Default Value: N

    57 GPUS_COMP_FEEIND Character(1) VARCHAR2(1) NOT NULL GPUS_COMPFEEIND
    N=No
    Y=Yes

    Default Value: N

    58 RECIPIENT_ID Character(8) VARCHAR2(8) NOT NULL Payment recipient ID

    Prompt Table: RECIPIENT

    59 GPUS_GRN_ANLMT_AMT Number(19,6) DECIMAL(18,6) NOT NULL Annual Limit Amount for Garnishments
    60 DATA_TYPE_CD Character(1) VARCHAR2(1) NOT NULL Data Type Code
    N=Customer Data
    S=Sample Data
    Y=System Data