GVT_TSP_VOUCHER(SQL Table) |
Index Back |
---|---|
GVT TSP Voucher Table |
# | 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. |