COMPANYGPES_TAX_LOCATIONGPES_YEARGPES_EXPT_RP_VW(SQL View) |
Index Back |
|---|---|
Expatriate Report DataExpatriate employees report data |
| SELECT A.COMPANY ,A.GPES_TAX_LOCATION ,A.GPES_YEAR ,A.GPES_MONTH ,A.GPES_FISCAL_KEY ,A.GPES_FISCAL_SUBKEY ,A.GPES_TAX_PCT , COUNT (DISTINCT A.EMPLID) , SUM (A.GPES_SALARY_INCOME+ A.GPES_SAL_INC_ADJ) , SUM (A.GPES_SALARY_WITHLD+ A.GPES_SAL_WITH_ADJ) FROM PS_GPES_EXPT_RSLT A WHERE %Sql(GPES_TX_MAX_VER_REV_NUM, PS_GPES_EXPT_RSLT, A) GROUP BY A.COMPANY ,A.GPES_TAX_LOCATION ,A.GPES_YEAR, A.GPES_MONTH ,A.GPES_FISCAL_KEY ,A.GPES_FISCAL_SUBKEY, A.GPES_TAX_PCT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | COMPANY |
Character(3) | VARCHAR2(3) NOT NULL | Company |
| 2 | GPES_TAX_LOCATION |
Character(5) | VARCHAR2(5) NOT NULL | Fiscal Territory. This field is used to populate the GP Write Array, which is used to generate the Tax Reports. |
| 3 | GPES_YEAR |
Number(4,0) | SMALLINT NOT NULL | Year |
| 4 | GPES_MONTH | Number(2,0) | SMALLINT NOT NULL | Month |
| 5 | GPES_FISCAL_KEY | Character(2) | VARCHAR2(2) NOT NULL | Fiscal key. Used to identify the earnings. |
| 6 | GPES_FISCAL_SUBKEY | Character(2) | VARCHAR2(2) NOT NULL | Fiscal sub-key. Used to identify the earnings. |
| 7 | GPES_TAX_PCT | Number(6,2) | DECIMAL(5,2) NOT NULL | Withholding percentage calculated. This field is used to populate the GP Write Array, which is used to generate the Tax Reports. |
| 8 | GPES_EE_COUNT | Number(6,0) | INTEGER NOT NULL | Number of Employees |
| 9 | GPES_SALARY_INCOME | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Salary Income. |
| 10 | GPES_SALARY_WITHLD | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Salary Withholding. |