GVT_TSP_VOUCHER

(SQL Table)
Index Back

GVT TSP Voucher Table

  • Parent Record Of GVT_TSP_VCH_DET
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

    Default Value: INSTALLATION.COMPANY

    Prompt Table: COMPANY_TBL

    2 GVT_TSP_SEQ_YR Number(2,0) SMALLINT NOT NULL TSP Voucher Number

    Default Value: GVT_INTRFC_INFO.GVT_TSP_SEQ_YR

    3 GVT_TSP_SEQ_NO Number(4,0) SMALLINT NOT NULL Voucher Seq No

    Default Value: 1

    4 PAY_BEGIN_DT Date(10) DATE Pay Period Begin Date
    5 PAY_END_DT Date(10) DATE Pay Period End Date
    6 CHECK_DT Date(10) DATE Check date.
    7 GVT_TSP_PAY_SUB Character(1) VARCHAR2(1) NOT NULL Routine Pay Submission?

    Y/N Table Edit

    Default Value: N

    8 GVT_TSP_EFT_DEP Character(1) VARCHAR2(1) NOT NULL GVT TSP EFT Deposit Indicator

    Y/N Table Edit

    Default Value: N

    9 GVT_TSP_MEDIA_TYPE Character(1) VARCHAR2(1) NOT NULL GVT TSP Media Type
    D=Diskette
    E=Electronic Submission
    F=Form(s) TSP-5
    M=Magnetic Tape
    W=Web-based application

    Default Value: E

    10 GVT_TSP_REEL_NO Character(8) VARCHAR2(8) NOT NULL Reel Number
    11 GVT_TSP_REEL_DT Date(10) DATE Reel Created
    12 GVT_TSP_REEL_BKUP Character(8) VARCHAR2(8) NOT NULL Backup (if applicable)
    13 GVT_TSP_REEL_BU_DT Date(10) DATE Date Backup Created
    14 GVT_TSP_DATA_RECS Number(9,0) DECIMAL(9) NOT NULL Employee Data Records
    15 GVT_TSP_PYMNT_RECS Number(9,0) DECIMAL(9) NOT NULL TSP Current Payment record count.
    16 GVT_TSP_LATE_RECS Number(9,0) DECIMAL(9) NOT NULL TSP Late Payment record count.
    17 GVT_TSP_NEG_RECS Number(9,0) DECIMAL(9) NOT NULL TSP Negative Adjustment record count.
    18 GVT_TSP_VERSION Character(1) VARCHAR2(1) NOT NULL TSP Submission Version
    N=Post 5/1/2000 System Submssion
    O=Pre 5/1/2000 System Submission
    R=Post 07-May-2012 TSP/ROTH

    Default Value: R

    19 GVT_ROTH_PYMNT_REC Number(9,0) DECIMAL(9) NOT NULL Number of ROTH current payment records on TSP file.
    20 GVT_ROTH_LATE_RECS Number(9,0) DECIMAL(9) NOT NULL Number of ROTH late payment records on TSP file.
    21 GVT_ROTH_NEG_RECS Number(9,0) DECIMAL(9) NOT NULL Number of ROTH negative adjustment records on TSP file.