GPUS_BNDDED_EXT

(SQL Table)
Index Back

Bond Deduction Data Extract

Bond Deduction Data Extract created via GP Generate Report Data

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
3 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
4 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group
5 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id
6 CAL_ID Character(18) VARCHAR2(18) NOT NULL calendar id
7 ORIG_CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Original Calendar Group ID
8 RSLT_SEG_NUM Number(4,0) SMALLINT NOT NULL Result Segment Number
9 GP_RPT_KEY Character(22) VARCHAR2(22) NOT NULL Output Result Key
10 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
11 GPUS_BND_ID Character(12) VARCHAR2(12) NOT NULL Savings Bond ID
12 GPUS_BND_NUM_CHAR Character(12) VARCHAR2(12) NOT NULL Bond Number in character format
13 INSTANCE Number(3,0) SMALLINT NOT NULL Instance Number
14 PAYMENT_DT Date(10) DATE Payment Date
15 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
16 GPUS_BND_PURCH_UNI Number(3,0) SMALLINT NOT NULL Bond Purchase Units
17 GPUS_BND_PURCH_AMT Number(12,2) DECIMAL(11,2) NOT NULL Bond Purchase Amount
18 GPUS_BND_AMT_S Signed Number(13,2) DECIMAL(11,2) NOT NULL Bond Amount (Signed)
19 GPUS_BND_BAL_AMT_S Signed Number(20,6) DECIMAL(18,6) NOT NULL Bond Balance Amount
20 CALC_ADJ_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Adjustment Value
21 SEG_BGN_DT Date(10) DATE Payee Process Segment's Begin Date
22 SEG_END_DT Date(10) DATE Payee Process Segment's End Date
23 SLICE_END_DT Date(10) DATE Element Slice End Date
24 ED_ASSIGN_INSTANCE Number(3,0) SMALLINT NOT NULL Earn/Ded Assignment Instance
25 CALC_RSLT_SRC Character(1) VARCHAR2(1) NOT NULL Source of Amount or Calculated Result
A=Assigned via Element
E=Earn Ded Assignment
F=Post Formula
N=Not Applicable
P=Positive Input
R=Rule Definition