BOND_LOG(SQL Table) |
Index Back |
|---|---|
EE Bond Activity by Bond IDThe BOND_LOG record is created during payroll confirmation and tracks U.S. Savings Bond related activities such as employee payroll deductions and bond purchases. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERSON |
| 2 | BOND_ID |
Character(3) | VARCHAR2(3) NOT NULL |
Savings Bond ID
Prompt Table: BOND_TBL |
| 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 | 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 |
| 8 | REVERSED | Character(1) | VARCHAR2(1) NOT NULL |
Reversed
Y/N Table Edit |
| 9 | FORM_ID | Character(6) | VARCHAR2(6) NOT NULL | Form Identification |
| 10 | PAYCHECK_NBR | Number(15,0) | DECIMAL(15) NOT NULL | Paycheck number. |
| 11 | CHECK_DT | Date(10) | DATE NOT NULL | Check date. |
| 12 | BOND_COLLECT_AMT | Signed Number(9,2) | DECIMAL(7,2) NOT NULL | Bond Collection Amount |
| 13 | BOND_DISBURSE_AMT | Number(8,2) | DECIMAL(7,2) NOT NULL | Bond Disbursement Amount |
| 14 | BOND_PURCH_UNITS | Number(3,0) | SMALLINT NOT NULL | Bond Purchase Units |
| 15 | BOND_ACCUM_AMT | Signed Number(9,2) | DECIMAL(7,2) NOT NULL | Bond Accumulated Amount |
| 16 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL | Company |
| 17 | PAYGROUP | Character(3) | VARCHAR2(3) NOT NULL | Pay Group |
| 18 | PAY_END_DT | Date(10) | DATE | Pay Period End Date |
| 19 | OFF_CYCLE | Character(1) | VARCHAR2(1) NOT NULL | Off Cycle ? |
| 20 | AP_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
AP Status
S=Sent to AP X=Extracted |