GPUS_NRP_BN1_AD

(SQL Table)
Index Back

Bond Processing Data

Bond Processing Data

  • Parent record: GPUS_BND_ASSIGN
  • # 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 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    3 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
    4 GPUS_BND_ID Character(12) VARCHAR2(12) NOT NULL Savings Bond ID
    5 GPUS_BND_NUM Number(3,0) SMALLINT NOT NULL Bond Number
    6 BEGIN_DT Date(10) DATE Begin Date
    7 END_DT Date(10) DATE end date
    8 PRC_ORDER Number(3,0) SMALLINT NOT NULL Process Order
    9 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    10 GPUS_BND_AMT Number(12,2) DECIMAL(11,2) NOT NULL Bond Amount
    11 GPUS_BND_GOAL_AMT Number(12,2) DECIMAL(11,2) NOT NULL Bond Goal Amount
    12 GPUS_BND_OWNER_T Character(2) VARCHAR2(2) NOT NULL Bond Owner Type.
    10=Employee
    20=Beneficiary
    30=Dependent
    13 GPUS_BND_DEP_BEN Character(2) VARCHAR2(2) NOT NULL Bond Dependent Beneficiary
    14 GPUS_BND_OTH_REG_T Character(2) VARCHAR2(2) NOT NULL Bond Other Registrant Type
    10=None
    20=Co-Owner
    30=Beneficiary
    15 GPUS_BND_REG Character(2) VARCHAR2(2) NOT NULL Bond Registrant.
    10=Employee
    20=Beneficiary
    30=Dependent
    16 GPUS_BND_OTH_BEN Character(2) VARCHAR2(2) NOT NULL Bond Other Registrant Beneficiary
    17 ADDRESS_TYPE Character(4) VARCHAR2(4) NOT NULL Address Type
    18 SAME_ADDRESS_EMPL Character(1) VARCHAR2(1) NOT NULL Same Address as Employee
    19 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
    20 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
    21 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
    22 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
    23 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
    24 CITY Character(30) VARCHAR2(30) NOT NULL City
    25 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1
    26 NUM2 Character(6) VARCHAR2(6) NOT NULL Number 2
    27 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
    AB=House Boat Reference
    WW=House Trailer Reference
    28 ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1
    29 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2
    30 ADDR_FIELD3 Character(4) VARCHAR2(4) NOT NULL Address Field 3
    31 COUNTY Character(30) VARCHAR2(30) NOT NULL County
    32 STATE Character(6) VARCHAR2(6) NOT NULL State
    33 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
    34 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code
    35 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit
    36 FREQUENCY_OPTN Character(2) VARCHAR2(2) NOT NULL Frequency Option
    CP=Use Calendar Period Frequency
    ED=Use Element Frequency
    SP=Use Specified Frequency
    37 FREQUENCY_ID Character(5) VARCHAR2(5) NOT NULL Defines a frequency and a set of parameters used for frequency conversion. Typically, these frequencies reflect how often an event occurs. Some examples are compensation frequency and pay frequency.
    38 GCTL_CND_OPTN Character(1) VARCHAR2(1) NOT NULL Generation Control Options
    E=Use Element Generation Control
    N=No Generation Control
    S=Specified Generation Control
    39 PIN_GCTL_NUM Number(8,0) INTEGER NOT NULL Generation Control Number
    40 ARR_PYBK_AMT_OPTN Character(1) VARCHAR2(1) NOT NULL Payback Option
    A=Use Specified Amount
    E=Use Element Payback Amount
    N=No Limit
    41 ENTRY_TYPE_ARR_AMT Character(3) VARCHAR2(3) NOT NULL entry type array amount
    42 PIN_ARR_AMT_NUM Number(8,0) INTEGER NOT NULL Arrears Amount element number
    43 ARR_PYBK_AMT Number(19,6) DECIMAL(18,6) NOT NULL Maximum Arrears Payback Amount