GPUS_BND_WA

(SQL Table)
Index Back

Bond Processing Writable Array

Bond Processing Writable Array

# 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 Rcd Nbr
3 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id
4 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group
5 CAL_ID Character(18) VARCHAR2(18) NOT NULL calendar id
6 ORIG_CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Original Calendar Group ID
7 RSLT_SEG_NUM Number(4,0) SMALLINT NOT NULL Result Segment Number
8 GPUS_BND_ID Character(12) VARCHAR2(12) NOT NULL Savings Bond ID
9 INSTANCE Number(3,0) SMALLINT NOT NULL Instance Number
10 EFFDT Date(10) DATE NOT NULL Effective Date
11 GPUS_BND_LOG_STAT Character(2) VARCHAR2(2) NOT NULL Bond Activity Log Status
10=Ready to Purchase
20=Purchased
30=Not Ready to Purchase
40=Deduction
50=Purchase

Default Value: 10

12 GPUS_BND_NUM Number(3,0) SMALLINT NOT NULL Bond Number
13 GPUS_BND_PURCH_UNI Number(3,0) SMALLINT NOT NULL Bond Purchase Units
14 GPUS_BND_PURCH_AMT Number(12,2) DECIMAL(11,2) NOT NULL Bond Purchase Amount
15 GPUS_BND_AMT Number(12,2) DECIMAL(11,2) NOT NULL Bond Amount
16 GPUS_BND_BAL_AMT Number(19,6) DECIMAL(18,6) NOT NULL Bond Balance Amount
17 SEG_BGN_DT Date(10) DATE Payee Process Segment's Begin Date
18 SEG_END_DT Date(10) DATE Payee Process Segment's End Date