EMPLIDGPUS_CAL_YEARGPUS_TAXFORM_BOXGPUS_YE_TXBX_V1(SQL View) |
Index Back |
|---|---|
Tax Box ViewTax Box View for the Year End Reports |
| SELECT DISTINCT B.EMPLID ,B.GPUS_CAL_YEAR , A.GPUS_TAXFORM_BOX , A.DESCR FROM PS_GPUS_YE_TXBOX A , PS_GPUS_YE_AMOUNTS B WHERE A.GPUS_TAXFORM_ID = B.GPUS_TAXFORM_ID AND (A.EFFDT <= %DateIn(%NumToChar(B.GPUS_CAL_YEAR) %Concat '-12-31')) AND (A.EFFDT >= %DateIn(%NumToChar(B.GPUS_CAL_YEAR) %Concat '-01-01')) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | GPUS_CAL_YEAR |
Number(4,0) | SMALLINT NOT NULL | Calendar Year |
| 3 | GPUS_TAXFORM_BOX |
Character(4) | VARCHAR2(4) NOT NULL | Tax Form Box |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |