GPJP_EFIL_TAO(SQL Table) |
Index Back |
|---|---|
GP/Japan Year-End ReportingThis table is loaded by a YEA Ap Engine process and is used for year-end reporting. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 3 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
| 4 | DATE_YEAR_VAL |
Number(4,0) | SMALLINT NOT NULL | Date Year Value |
| 5 | CAL_RUN_ID | Character(18) | VARCHAR2(18) NOT NULL | Calendar Run Id |
| 6 | GPJP_TAX_ESTAB | Character(15) | VARCHAR2(15) NOT NULL | Salary Payer Reference Number |
| 7 | GPJP_RPT_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
YEA e-file type
Default Value: 315 |
| 8 | GPJP_TAX_REF_NO1 | Character(10) | VARCHAR2(10) NOT NULL | Tax Reference number 1 |
| 9 | GPJP_HEAD_BRANCH | Character(5) | VARCHAR2(5) NOT NULL | The code to tell if it's the records of HQ or branches |
| 10 | GPJP_YEA_FLADDR1 | Character(120) | VARCHAR2(120) NOT NULL | Tax Establishment Address. |
| 11 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 12 | PHONE | Character(24) | VARCHAR2(24) NOT NULL | Telephone |
| 13 | GPJP_TAX_REF_NO2 | Character(10) | VARCHAR2(10) NOT NULL | Tax Reference number 2 |
| 14 | GPJP_YEA_FLADDR2 | Character(120) | VARCHAR2(120) NOT NULL | Employee Address Concatenated. |
| 15 | DESCR1 | Character(30) | VARCHAR2(30) NOT NULL | Descr |
| 16 | GPJP_YEA_AMEND | Character(1) | VARCHAR2(1) NOT NULL | YEA Amendment flag |
| 17 | GPJP_OBJYEAR_ERA | Character(2) | VARCHAR2(2) NOT NULL | Object Year in Era |
| 18 | GPJP_YEA_FLADDR | Character(120) | VARCHAR2(120) NOT NULL | Used in Year End Adjustment feature for Global Payroll Japan. |
| 19 | GPJP_ABROAD1 | Character(1) | VARCHAR2(1) NOT NULL | Living abroad |
| 20 | NAME_FORMAL | Character(60) | VARCHAR2(60) NOT NULL | Formal Name - name formatted for Formal Display by COuntry. Normally used in Correspondence. |
| 21 | DESCR2 | Character(30) | VARCHAR2(30) NOT NULL | Descr2 |
| 22 | GPJP_PYMT_TYPE | Character(20) | VARCHAR2(20) NOT NULL | YEA Payment type |
| 23 | GPJP_IT_EARNS | Number(19,6) | DECIMAL(18,6) NOT NULL | Amount Of Earnings. |
| 24 | GPJP_UNPAID_AMT | Number(19,6) | DECIMAL(18,6) NOT NULL | YEA unpaid amount |
| 25 | GPJP_YEA_INCAFT | Number(19,6) | DECIMAL(18,6) NOT NULL | Income After Deductions |
| 26 | GPJP_YEA_YEADED | Number(19,6) | DECIMAL(18,6) NOT NULL | Total Amount Of Income Deductions. |
| 27 | GPJP_IT_INCTAX | Number(19,6) | DECIMAL(18,6) NOT NULL | Amount Of Withholding Tax. |
| 28 | GPJP_UNCOL_TAX | Number(19,6) | DECIMAL(18,6) NOT NULL | YEA uncollected tax |
| 29 | GPJP_YEA_DEDSPO | Character(1) | VARCHAR2(1) NOT NULL | Deductible Spouse. |
| 30 | GPJP_YEA_DEDELS | Character(1) | VARCHAR2(1) NOT NULL | Deductible Elderly Spouse. |
| 31 | GPJP_YEA_SPSDED | Number(19,6) | DECIMAL(18,6) NOT NULL | Year-End Adjustment |
| 32 | GPJP_YEA_DEPSPC | Number(2,0) | SMALLINT NOT NULL | Year-End Adjustment |
| 33 | GPJP_DEPSPC_OTSU | Number(2,0) | SMALLINT NOT NULL | Year-End Adjustment |
| 34 | GPJP_YEA_DEPELD | Number(2,0) | SMALLINT NOT NULL | Year-End Adjustment |
| 35 | GPJP_YEA_LIVELD | Number(2,0) | SMALLINT NOT NULL | Year-End Adjustment |
| 36 | GPJP_DEPELD_OTSU | Number(2,0) | SMALLINT NOT NULL | Year-End Adjustment |
| 37 | GPJP_YEA_DEPOTH | Number(2,0) | SMALLINT NOT NULL | Year-End Adjustment |
| 38 | GPJP_DEPOTH_OTSU | Number(2,0) | SMALLINT NOT NULL | Year-End Adjustment |
| 39 | GPJP_YEA_DISSPC | Number(2,0) | SMALLINT NOT NULL | Year-End Adjustment |
| 40 | GPJP_YEA_DISLIV | Number(2,0) | SMALLINT NOT NULL | Year-End Adjustment |
| 41 | GPJP_YEA_DISOTH | Number(2,0) | SMALLINT NOT NULL | Year-End Adjustment |
| 42 | GPJP_SC_PREM | Number(19,6) | DECIMAL(18,6) NOT NULL | SI by Reporting + Mutual Aid |
| 43 | GPJP_YEA_MUTAID | Number(19,6) | DECIMAL(18,6) NOT NULL | Mutual Aid Fund Deduction |
| 44 | GPJP_YEA_LIFPRE | Number(19,6) | DECIMAL(18,6) NOT NULL | Year-End Adjustment |
| 45 | GPJP_YEA_NONLIF | Number(19,6) | DECIMAL(18,6) NOT NULL | Year-End Adjustment |
| 46 | GPJP_YEA_HOUSE | Number(19,6) | DECIMAL(18,6) NOT NULL | Year-End Adjustment |
| 47 | GPJP_YEA_PENPRE | Number(19,6) | DECIMAL(18,6) NOT NULL | Year-End Adjustment |
| 48 | GPJP_YEA_SPSINC | Number(19,6) | DECIMAL(18,6) NOT NULL | Year-End Adjustment |
| 49 | GPJP_YEA_LTNONL | Number(19,6) | DECIMAL(18,6) NOT NULL | Year-End Adjustment |
| 50 | GPJP_YEA_BDTERA | Character(1) | VARCHAR2(1) NOT NULL | Era Of Birth. |
| 51 | GPJP_CHRDT_YY1 | Character(2) | VARCHAR2(2) NOT NULL | Year in Era |
| 52 | GPJP_CHRDT_MM1 | Character(2) | VARCHAR2(2) NOT NULL | Month |
| 53 | GPJP_CHRDT_DD1 | Character(2) | VARCHAR2(2) NOT NULL | Date |
| 54 | GPJP_YEA_HUSBND | Character(1) | VARCHAR2(1) NOT NULL | Have a Husband. |
| 55 | GPJP_YEA_MINOR | Number(1,0) | SMALLINT NOT NULL | Minor. |
| 56 | GPJP_YEA_OTSU | Character(1) | VARCHAR2(1) NOT NULL | OTSU Tax Type. |
| 57 | GPJP_YEA_DISFL1 | Character(1) | VARCHAR2(1) NOT NULL | Special Disabled ( employee ). |
| 58 | GPJP_YEA_DISFL2 | Character(1) | VARCHAR2(1) NOT NULL | Disability ( Others ). |
| 59 | GPJP_YEA_ELD | Character(1) | VARCHAR2(1) NOT NULL | Elderly. |
| 60 | GPJP_YEA_WIDOW | Character(1) | VARCHAR2(1) NOT NULL | Widow. |
| 61 | GPJP_YEA_WDWER | Character(1) | VARCHAR2(1) NOT NULL | Widower. |
| 62 | GPJP_YEA_WRKSTD | Character(1) | VARCHAR2(1) NOT NULL | Working Student. |
| 63 | GPJP_YEA_TRMDTH | Character(1) | VARCHAR2(1) NOT NULL | Terminated by Death |
| 64 | GPJP_DISASTER_VICT | Character(1) | VARCHAR2(1) NOT NULL | Disaster Victim |
| 65 | GPJP_YEA_FORGN | Character(1) | VARCHAR2(1) NOT NULL | Foreigner |
| 66 | GPJP_YEA_HIRMID | Number(1,0) | SMALLINT NOT NULL | Hired/Terminated Mid-Year. |
| 67 | GPJP_CHRDT_YY2 | Character(2) | VARCHAR2(2) NOT NULL | Year in Era |
| 68 | GPJP_CHRDT_MM2 | Character(2) | VARCHAR2(2) NOT NULL | Month |
| 69 | GPJP_CHRDT_DD2 | Character(2) | VARCHAR2(2) NOT NULL | Date |
| 70 | GPJP_YEA_FLADDR3 | Character(120) | VARCHAR2(120) NOT NULL | Tax Establishment Address. |
| 71 | GPJP_ABROAD2 | Character(1) | VARCHAR2(1) NOT NULL | Living abroad |
| 72 | EMPLOYER | Character(30) | VARCHAR2(30) NOT NULL | Employer |
| 73 | GPJP_YEA_PRIGRS | Number(19,6) | DECIMAL(18,6) NOT NULL | Year-End Adjustment |
| 74 | GPJP_YEA_PRITAX | Number(19,6) | DECIMAL(18,6) NOT NULL | Year-End Adjustment |
| 75 | GPJP_YEA_PRISI | Number(19,6) | DECIMAL(18,6) NOT NULL | Year-End Adjustment |
| 76 | GPJP_DISASTR_GRACE | Character(10) | VARCHAR2(10) NOT NULL | Grace of Withholding Tax |
| 77 | GPJP_CHRDT_YY3 | Character(2) | VARCHAR2(2) NOT NULL | Year in Era |
| 78 | GPJP_CHRDT_MM3 | Character(2) | VARCHAR2(2) NOT NULL | Month |
| 79 | GPJP_CHRDT_DD3 | Character(2) | VARCHAR2(2) NOT NULL | Date |
| 80 | GPJP_CHRDT_YY4 | Character(2) | VARCHAR2(2) NOT NULL | Year in Era |
| 81 | GPJP_CHRDT_MM4 | Character(2) | VARCHAR2(2) NOT NULL | Month |
| 82 | GPJP_CHRDT_DD4 | Character(2) | VARCHAR2(2) NOT NULL | Date |
| 83 | GPJP_NO_HOUSE_LOAN | Number(1,0) | SMALLINT NOT NULL | YEA - Number of housing loans applicable for housing loan deduction |
| 84 | GPJP_YEA_HOUSE2 | Number(19,6) | DECIMAL(18,6) NOT NULL | Year-End Adjustment. Deductible Housing loan effective from Jan 2007 Legislative Change. |
| 85 | GPJP_APP_CLASS1 | Character(2) | VARCHAR2(2) NOT NULL |
Applied class of first housing loan
01=Normal housing loan 02=Long-term quality housing loan 03=Specific repair work 04=Victim of Northern JPN quake |
| 86 | GPJP_PAYABLE_LOAN1 | Number(19,6) | DECIMAL(18,6) NOT NULL | Loan payable at year end |
| 87 | GPJP_CHRDT_YY5 | Character(2) | VARCHAR2(2) NOT NULL | Year in Era |
| 88 | GPJP_CHRDT_MM5 | Character(2) | VARCHAR2(2) NOT NULL | Month |
| 89 | GPJP_CHRDT_DD5 | Character(2) | VARCHAR2(2) NOT NULL | Date |
| 90 | GPJP_APP_CLASS2 | Character(2) | VARCHAR2(2) NOT NULL |
Applied class of second housing loan
01=Normal housing loan 02=Long-term quality housing loan 03=Specific repair work 04=Victim of Northern JPN quake |
| 91 | GPJP_PAYABLE_LOAN2 | Number(19,6) | DECIMAL(18,6) NOT NULL | Loan payable at year end |
| 92 | GPJP_YEA_SUMM | Long Character | CLOB | YEA summary - variable length |
| 93 | GPJP_YEA_LIFPREAC1 | Number(19,6) | DECIMAL(18,6) NOT NULL | Year-End Adjustment |
| 94 | GPJP_YEA_LIFPREAC | Number(19,6) | DECIMAL(18,6) NOT NULL | Year-End Adjustment |
| 95 | GPJP_YEA_CARPRE | Number(19,6) | DECIMAL(18,6) NOT NULL | Year-End Adjustment |
| 96 | GPJP_YEA_PENPRE1 | Number(19,6) | DECIMAL(18,6) NOT NULL | Year-End Adjustment |
| 97 | GPJP_YEA_DEPJUV | Number(2,0) | SMALLINT NOT NULL | Number of Juvenile Dependents |
| 98 | GPJP_GEN_COLLECT | Number(1,0) | SMALLINT NOT NULL | General collecting |
| 99 | GPJP_FULL_TIME | Number(1,0) | SMALLINT NOT NULL | Full-time-worker for business proprietor with blue declaration card |
| 100 | GPJP_TAX_IMMUNE | Number(1,0) | SMALLINT NOT NULL | Immune under tax convention |
| 101 | NAME_AC | Character(50) | VARCHAR2(50) NOT NULL | Alternate Character Name |
| 102 | MUNICIPAL_CD_JPN | Character(6) | VARCHAR2(6) NOT NULL | Japanese Municipal Code |
| 103 | GPJP_IH_SPEC_CLC | Character(12) | VARCHAR2(12) NOT NULL | Used in Inhabitant Tax Data for GP/Japan. |
| 104 | GPJP_EFILE_SUMMARY | Character(254) | VARCHAR2(254) NOT NULL | E-File Summary |