COMPANYDefault Value: INSTALLATION.COMPANY
Prompt Table: GVT_INTRFC_INFO
EMPLIDEMPL_RCDEFFDTDefault Value: %date
N=Not Ready to Process
P=Processed
R=Ready to Process
Default Value: R
GVT_TSP_ADJUST(SQL Table) |
Index Back |
|---|---|
TSP Adjustment - Late Payment |
| # | 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: GVT_INTRFC_INFO |
| 2 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 3 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
| 4 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 5 | PAYGROUP | Character(3) | VARCHAR2(3) NOT NULL | Pay Group |
| 6 | GVT_TSP_SEQ_YR | Number(2,0) | SMALLINT NOT NULL | TSP Voucher Number |
| 7 | GVT_TSP_SEQ_NO | Number(4,0) | SMALLINT NOT NULL | Voucher Seq No |
| 8 | GVT_TSP_AC_ADJ | Number(8,2) | DECIMAL(7,2) NOT NULL | Agency Contribution for Thrift Savings Plan (TSP) adjustment. |
| 9 | GVT_TSP_AM_ADJ | Number(8,2) | DECIMAL(7,2) NOT NULL | Agency Matching contribtion for Thrift Savings Plan (TSP) adjustment. |
| 10 | GVT_TSP_EC_ADJ | Number(8,2) | DECIMAL(7,2) NOT NULL | Employee Contribution for Thrift Savings Plan (TSP) adjustment. |
| 11 | GVT_TSP_UPD_IND | Character(1) | VARCHAR2(1) NOT NULL |
TSP Status
N=Not Ready to Process P=Processed R=Ready to Process Default Value: R |
| 12 | GVT_ROTH_AM_ADJ | Number(8,2) | DECIMAL(7,2) NOT NULL | Agency Matching contribtion for ROTH adjustment. |
| 13 | GVT_ROTH_EC_ADJ | Number(8,2) | DECIMAL(7,2) NOT NULL | Employee Contribution for ROTH adjustment. |