GPUS_NRP_GRN_AD

(SQL Table)
 Index Back

GPUS_GARNISH

GPUS_GARNISH

  • Related Language Record: GPUS_NRP_GRL_AD

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 GP_PKG_ID Character(10) VARCHAR2(10) NOT NULL Field used for element packaging
    2 GPUS_GRN_ID Character(16) VARCHAR2(16) NOT NULL GPUS_GARNID
    3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    4 GPUS_RLAWSRC Character(6) VARCHAR2(6) NOT NULL GPUS_LAWSRC
    5 GPUS_PIN_PROFM_NUM Number(8,0) INTEGER NOT NULL Proration Formula PIN Number
    6 GPUS_PIN_LMCAL_NUM Number(8,0) INTEGER NOT NULL Limit Calculation Formula PIN Number
    7 GPUS_PIN_LMCF_NUM Number(8,0) INTEGER NOT NULL Company Fee Limit Formula PIN Number
    8 GPUS_PIN_LMPF_NUM Number(8,0) INTEGER NOT NULL Recipient Fee Limit Formula PIN Number
    9 GPUS_GRN_STATUS Character(2) VARCHAR2(2) NOT NULL Garnishment Status
    10=Active
    30=Suspended
    40=Rejected
    50=Completed
    10 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
    11 GPUS_GRN_SUBTYPE Character(2) VARCHAR2(2) NOT NULL GPUS_SUBTYPE
    10=Current
    20=Arrears
    12 GPUS_PRIORITY Number(4,0) SMALLINT NOT NULL GPUS_PRIORITY
    13 GPUS_EST_DT Date(10) DATE Date Established
    14 GPUS_REC_DT Date(10) DATE Received Date
    15 GPUS_REC_TM Time(15) TIMESTAMP Received Time
    16 GPUS_RES_DT Date(10) DATE Response Date
    17 GPUS_RES_TM Time(15) TIMESTAMP Response Time
    18 GPUS_REC_DTTM DateTime(26) TIMESTAMP GPUS_RECDTTM
    19 GPUS_RES_DTTM DateTime(26) TIMESTAMP Response Date
    20 GPUS_AGENCYNM Character(60) VARCHAR2(60) NOT NULL Agency Name
    21 GPUS_ATTRNYNM Character(50) VARCHAR2(50) NOT NULL Attroney Name
    22 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
    23 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
    24 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
    25 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
    26 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
    27 CITY Character(30) VARCHAR2(30) NOT NULL City
    28 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1
    29 NUM2 Character(6) VARCHAR2(6) NOT NULL Number 2
    30 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
    AB=House Boat Reference
    WW=House Trailer Reference
    31 ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1
    32 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2
    33 ADDR_FIELD3 Character(4) VARCHAR2(4) NOT NULL Address Field 3
    34 COUNTY Character(30) VARCHAR2(30) NOT NULL County
    35 STATE Character(6) VARCHAR2(6) NOT NULL State
    36 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
    37 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code
    38 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit
    39 CONTACT_NAME Character(50) VARCHAR2(50) NOT NULL Contact Name
    40 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone
    41 EMAILID Character(70) VARCHAR2(70) NOT NULL A user's E-mail address
    42 GPUS_REMARKS Long Character CLOB GPUS_REMARKS
    43 GPUS_RULEID Character(30) VARCHAR2(30) NOT NULL GPUS_RULEID
    44 GPUS_PRLAWSRC Character(6) VARCHAR2(6) NOT NULL GPUS_LAWSRC
    45 GPUS_AUTOSTDFLAG Character(1) VARCHAR2(1) NOT NULL GPUS_CALDAYSFLAG
    N=No
    Y=Yes
    46 GPUS_STARTDT Date(10) DATE GPUS_STARTDT
    47 GPUS_DED_STARTDT Date(10) DATE GPUS_STARTDT
    48 GPUS_ENDDT Date(10) DATE GPUS_ENDDT
    49 GPUS_STOPDAYS Number(3,0) SMALLINT NOT NULL GPUS_STOPDAYS
    50 GPUS_CALDAYSFLAG Character(1) VARCHAR2(1) NOT NULL GPUS_CALDAYSFLAG
    N=No
    Y=Yes
    51 GPUS_GRN_LMAMT Number(19,6) DECIMAL(18,6) NOT NULL GPUS_GARNLIMITAMT
    52 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    53 GPUS_GRN_BAL Number(19,6) DECIMAL(18,6) NOT NULL GPUS_GARNBAL
    54 GPUS_LMFREQ Character(2) VARCHAR2(2) NOT NULL GPUS_LIMITFREQ
    10=Weekly
    20=Biweekly
    30=Semi-Monthly
    40=Monthly
    55 GPUS_LMCF_FREQ Character(2) VARCHAR2(2) NOT NULL GPUS_LIMITCFEEFREQ
    10=Weekly
    20=Biweekly
    30=Semi-Monthly
    40=Monthly
    56 GPUS_LMPF_FREQ Character(2) VARCHAR2(2) NOT NULL GPUS_LIMITPFEEFREQ
    10=Weekly
    20=Biweekly
    30=Semi-Monthly
    40=Monthly
    57 GPUS_PAY_FEEIND Character(1) VARCHAR2(1) NOT NULL GPUS_PAYFEEIND
    N=No
    Y=Yes
    58 GPUS_COMP_FEEIND Character(1) VARCHAR2(1) NOT NULL GPUS_COMPFEEIND
    N=No
    Y=Yes
    59 RECIPIENT_ID Character(8) VARCHAR2(8) NOT NULL Payment recipient ID
    60 GPUS_GRN_ANLMT_AMT Number(19,6) DECIMAL(18,6) NOT NULL Annual Limit Amount for Garnishments
    61 DATA_TYPE_CD Character(1) VARCHAR2(1) NOT NULL Data Type Code
    N=Customer Data
    S=Sample Data
    Y=System Data