COMPANYDefault Value: INSTALLATION.COMPANY
Prompt Table: GVT_INTRFC_INFO
EMPLIDPrompt Table: GVT_TSP_ADJ_VW
EMPL_RCDEFFDTDefault Value: %date
N=Not Ready to Process
P=Processed
R=Ready to Process
Default Value: R
GVT_TSP_PROC_VW(SQL View) |
Index Back |
|---|---|
TSP Processed Adjustments |
| SELECT COMPANY , EMPLID , EMPL_RCD , EFFDT , PAYGROUP , GVT_TSP_SEQ_YR , GVT_TSP_SEQ_NO , GVT_TSP_AC_ADJ , GVT_TSP_AM_ADJ , GVT_TSP_EC_ADJ , GVT_TSP_UPD_IND FROM PS_GVT_TSP_ADJUST WHERE GVT_TSP_UPD_IND = 'P' |
| # | 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
Prompt Table: GVT_TSP_ADJ_VW |
| 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 |