CSB_REG_DENOM

(SQL Table)
Index Back

CSB Registrant Denominations

Canada Savings Bonds records Denominations selected by each registrant per CSB Series.

  • Parent record: CSB_REGISTRANT
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PERSON

    2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
    3 EFFDT Date(10) DATE NOT NULL Effective Date
    4 CSB_SERIES_CD Character(3) VARCHAR2(3) NOT NULL CSB Series Code

    Prompt Table: CSB_SERIES_TBL

    5 DEPENDENT_BENEF Character(2) VARCHAR2(2) NOT NULL Dependent Benefit
    01=default

    Prompt Table: DEPENDENT_VW

    6 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number
    7 CSB_DENOM Number(6,0) INTEGER NOT NULL CSB Denomination

    Prompt Table: CSB_DENOM_TBL

    8 CSB_QTY Number(3,0) SMALLINT NOT NULL CSB Quantity
    9 DED_ADDL_AMT Number(11,2) DECIMAL(10,2) NOT NULL Deduction Flat/Addl Amount
    10 GOAL_AMT Signed Number(12,2) DECIMAL(10,2) NOT NULL Goal Amount