BOND_TMP_VW

(SQL View)
 Index Back

EE Bond Temp View

This view is used to refund bonds. It is referenced as a hidden scroll on the GVT_BOND_TMP_WRK panel and in BOND_SPEC_DATA.EMPLID SavePostChange PeopleCode.

SELECT EMPLID , BOND_ID , BOND_OWNER_ID , BOND_OTH_REG_TYPE , BOND_OTH_REG_ID , BOND_LOG_SEQ , BOND_LOG_STATUS FROM PS_BOND_LOG A WHERE BOND_LOG_STATUS IN ('N','S','R','D') AND BOND_LOG_SEQ = ( SELECT MAX(BOND_LOG_SEQ) FROM PS_BOND_LOG WHERE EMPLID = A.EMPLID AND BOND_ID = A.BOND_ID AND BOND_OWNER_ID = A.BOND_OWNER_ID AND BOND_OTH_REG_TYPE = A.BOND_OTH_REG_TYPE AND BOND_OTH_REG_ID = A.BOND_OTH_REG_ID)

  • Parent record: PERSON

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 BOND_ID Character(3) VARCHAR2(3) NOT NULL Savings Bond ID
    3 BOND_OWNER_ID Character(2) VARCHAR2(2) NOT NULL Bond Owner ID
    4 BOND_OTH_REG_TYPE Character(1) VARCHAR2(1) NOT NULL Bond Other Registrant Type
    B=Beneficiary
    C=Co-Owner
    N=No Other Bond Registrant
    5 BOND_OTH_REG_ID Character(2) VARCHAR2(2) NOT NULL Bond Other Registrant ID
    6 BOND_LOG_SEQ Number(3,0) SMALLINT NOT NULL Bond Activity Seq #
    7 BOND_LOG_STATUS Character(1) VARCHAR2(1) NOT NULL Bond Activity Status
    D=Funds Disbursed
    F=Refunded Balance
    N=Funds Not Ready to Disburse
    R=Funds Ready to Disburse
    S=Suspended Due To Annual Limit
    T=Transferred Balance