EMPLIDBOND_IDBOND_OWNER_IDBOND_OTH_REG_TYPEB=Beneficiary
C=Co-Owner
N=No Other Bond Registrant
BOND_OTH_REG_IDBOND_LOG_SEQEFFSEQGVT_BOND_DISBUR(SQL Table) |
Index Back |
|---|---|
Log of Bond Puchase Dates |
| # | 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 Nbr |
| 7 | EFFSEQ |
Number(3,0) | SMALLINT NOT NULL | Effective Sequence |
| 8 | BOND_PURCH_UNITS | Number(3,0) | SMALLINT NOT NULL | Bond Purchase Units |
| 9 | BOND_PURCH_DT | Date(10) | DATE | Bond Purchased Date |