GPUS_NRP_BN1_VW

(SQL View)
 Index Back

Bond Processing Data

Bond Processing Data

SELECT EMPLID ,EMPL_RCD ,GPUS_BND_ID ,GPUS_BND_NUM ,BEGIN_DT ,END_DT ,PRC_ORDER ,CURRENCY_CD ,GPUS_BND_AMT ,GPUS_BND_GOAL_AMT ,GPUS_BND_OWNER_T ,GPUS_BND_DEP_BEN ,GPUS_BND_OTH_REG_T ,GPUS_BND_REG ,GPUS_BND_OTH_BEN ,ADDRESS_TYPE ,SAME_ADDRESS_EMPL ,COUNTRY ,ADDRESS1 ,ADDRESS2 ,ADDRESS3 ,ADDRESS4 ,CITY ,NUM1 ,NUM2 ,HOUSE_TYPE ,ADDR_FIELD1 ,ADDR_FIELD2 ,ADDR_FIELD3 ,COUNTY ,STATE ,POSTAL ,GEO_CODE ,IN_CITY_LIMIT ,FREQUENCY_OPTN ,FREQUENCY_ID ,GCTL_CND_OPTN ,PIN_GCTL_NUM + 50000000 ,ARR_PYBK_AMT_OPTN ,ENTRY_TYPE_ARR_AMT ,PIN_ARR_AMT_NUM + 50000000 ,ARR_PYBK_AMT FROM PS_GPUS_BND_DATA

  • Parent record: GPUS_BND_ASSIGN

    • # 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 GPUS_BND_ID Character(12) VARCHAR2(12) NOT NULL Savings Bond ID

    Prompt Table: GPUS_BND_TBL

    4 GPUS_BND_NUM Number(3,0) SMALLINT NOT NULL Bond Number
    5 BEGIN_DT Date(10) DATE NOT NULL Begin Date
    6 END_DT Date(10) DATE end date
    7 PRC_ORDER Number(3,0) SMALLINT NOT NULL Process Order
    8 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    9 GPUS_BND_AMT Number(12,2) DECIMAL(11,2) NOT NULL Bond Amount
    10 GPUS_BND_GOAL_AMT Number(12,2) DECIMAL(11,2) NOT NULL Bond Goal Amount
    11 GPUS_BND_OWNER_T Character(2) VARCHAR2(2) NOT NULL Bond Owner Type.
    10=Employee
    20=Beneficiary
    30=Dependent

    Default Value: 10

    12 GPUS_BND_DEP_BEN Character(2) VARCHAR2(2) NOT NULL Bond Dependent Beneficiary

    Prompt Table: DEPENDENT_BENEF

    13 GPUS_BND_OTH_REG_T Character(2) VARCHAR2(2) NOT NULL Bond Other Registrant Type
    10=None
    20=Co-Owner
    30=Beneficiary

    Default Value: 10

    14 GPUS_BND_REG Character(2) VARCHAR2(2) NOT NULL Bond Registrant.
    10=Employee
    20=Beneficiary
    30=Dependent

    Default Value: 10

    15 GPUS_BND_OTH_BEN Character(2) VARCHAR2(2) NOT NULL Bond Other Registrant Beneficiary

    Prompt Table: DEPENDENT_BENEF

    16 ADDRESS_TYPE Character(4) VARCHAR2(4) NOT NULL Address Type

    Prompt Table: PERSON_ADDRESS

    17 SAME_ADDRESS_EMPL Character(1) VARCHAR2(1) NOT NULL Same Address as Employee

    Y/N Table Edit

    18 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Prompt Table: COUNTRY_TBL

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

    Prompt Table: STATE_TBL

    32 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
    33 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code
    34 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit

    Y/N Table Edit

    35 FREQUENCY_OPTN Character(2) VARCHAR2(2) NOT NULL Frequency Option
    CP=Use Calendar Period Frequency
    ED=Use Element Frequency
    SP=Use Specified Frequency

    Default Value: ED

    36 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.

    Prompt Table: FREQUENCY_TBL

    37 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

    Default Value: E

    38 PIN_GCTL_NUM Number(8,0) INTEGER NOT NULL Generation Control Number

    Prompt Table: GP_PIN_GC0_VW

    39 ARR_PYBK_AMT_OPTN Character(1) VARCHAR2(1) NOT NULL Payback Option
    A=Use Specified Amount
    E=Use Element Payback Amount
    N=No Limit

    Default Value: E

    40 ENTRY_TYPE_ARR_AMT Character(3) VARCHAR2(3) NOT NULL entry type array amount

    Prompt Table: GP_ENT_APYBK_VW

    41 PIN_ARR_AMT_NUM Number(8,0) INTEGER NOT NULL Arrears Amount element number

    Prompt Table: %GP_EDIT_FLD6

    42 ARR_PYBK_AMT Number(19,6) DECIMAL(18,6) NOT NULL Maximum Arrears Payback Amount