GPES_TX_RSED_VW(SQL View) |
Index Back |
---|---|
Tax Results VW Economical DataEconomical Data Tax Results VW |
SELECT EMPLID , CAL_RUN_ID , EMPL_RCD , GP_PAYGROUP , CAL_ID , ORIG_CAL_RUN_ID , RSLT_SEG_NUM , EFFDT , RSLT_VER_NUM , RSLT_REV_NUM , GPES_TAX_BASE , GPES_TAX_INC_IRREG , GPES_SS_CT_EE , GPES_TAX_REDUCTION , GPES_GARN_SPOUSE , GPES_GARN_CHILDREN FROM PS_GPES_TAX_RSLT |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
2 | CAL_RUN_ID | Character(18) | VARCHAR2(18) NOT NULL | Calendar Run Id |
3 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Record |
4 | GP_PAYGROUP | Character(10) | VARCHAR2(10) NOT NULL | Global Payroll pay group |
5 | CAL_ID | Character(18) | VARCHAR2(18) NOT NULL | calendar id |
6 | ORIG_CAL_RUN_ID | Character(18) | VARCHAR2(18) NOT NULL | Original Calendar Group ID |
7 | RSLT_SEG_NUM | Number(4,0) | SMALLINT NOT NULL | Result Segment Number |
8 | EFFDT | Date(10) | DATE |
Effective Date
Default Value: %date |
9 | RSLT_VER_NUM | Number(4,0) | SMALLINT NOT NULL | Result Version Number |
10 | RSLT_REV_NUM | Number(4,0) | SMALLINT NOT NULL | Result Revision Number |
11 | GPES_TAX_BASE | Number(11,2) | DECIMAL(10,2) NOT NULL | Taxable base. This field is used to populate the GP Write Array, which is used to generate the Tax Reports. |
12 | GPES_TAX_INC_IRREG | Number(14,2) | DECIMAL(13,2) NOT NULL | Taxable base. This field is used to populate the GP Write Array, which is used to generate the Tax Reports. |
13 | GPES_SS_CT_EE | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Employee Social Security contribution |
14 | GPES_TAX_REDUCTION | Number(14,2) | DECIMAL(13,2) NOT NULL | Tax Reduction. |
15 | GPES_GARN_SPOUSE | Number(16,2) | DECIMAL(15,2) NOT NULL | Amount paid by the payee in concept of garnishment for spouse alimony. |
16 | GPES_GARN_CHILDREN | Number(16,2) | DECIMAL(15,2) NOT NULL | Amount paid by the payee in concept of garnishment for children alimony. |