GPJP_EFLE_20_VW

(SQL View)
 Index Back

GP/Japan Year-End Reporting

This table is loaded by a YEA Ap Engine process and is used for year-end reporting.

SELECT PROCESS_INSTANCE ,EMPLID ,EMPL_RCD ,DATE_YEAR_VAL ,CAL_RUN_ID ,GPJP_TAX_ESTAB ,GPJP_RPT_TYPE ,GPJP_TAX_REF_NO1 ,GPJP_HEAD_BRANCH ,GPJP_YEA_FLADDR1 ,DESCR ,PHONE ,GPJP_TAX_REF_NO2 ,GPJP_YEA_FLADDR2 ,DESCR1 ,GPJP_YEA_AMEND ,GPJP_OBJYEAR_ERA ,GPJP_YEA_FLADDR ,GPJP_ABROAD1 ,NAME_FORMAL ,DESCR2 ,GPJP_PYMT_TYPE ,GPJP_IT_EARNS ,GPJP_UNPAID_AMT ,GPJP_YEA_INCAFT ,GPJP_YEA_YEADED ,GPJP_IT_INCTAX ,GPJP_UNCOL_TAX ,GPJP_YEA_DEDSPO ,GPJP_YEA_DEDELS ,CASE WHEN GPJP_YEA_SPSDED = 0 THEN GPJP_YEA_SDED ELSE GPJP_YEA_SPSDED END ,GPJP_YEA_DEPSPC ,GPJP_DEPSPC_OTSU ,GPJP_YEA_DEPELD ,GPJP_YEA_LIVELD ,GPJP_DEPELD_OTSU ,GPJP_YEA_DEPOTH ,GPJP_DEPOTH_OTSU ,GPJP_YEA_DISSPC ,GPJP_YEA_DISLIV ,GPJP_YEA_DISOTH ,GPJP_SC_PREM ,GPJP_YEA_MUTAID ,GPJP_YEA_LIFPRE ,GPJP_YEA_NONLIF ,GPJP_YEA_HOUSE ,GPJP_YEA_PENPRE ,GPJP_YEA_SPSINC ,GPJP_YEA_LTNONL ,GPJP_YEA_BDTERA ,GPJP_CHRDT_YY1 ,GPJP_CHRDT_MM1 ,GPJP_CHRDT_DD1 ,GPJP_YEA_HUSBND ,GPJP_YEA_MINOR ,GPJP_YEA_OTSU ,GPJP_YEA_DISFL1 ,GPJP_YEA_DISFL2 ,GPJP_YEA_ELD ,GPJP_YEA_WIDOW ,GPJP_YEA_WDWER ,GPJP_YEA_WRKSTD ,GPJP_YEA_TRMDTH ,GPJP_DISASTER_VICT ,GPJP_YEA_FORGN ,GPJP_YEA_HIRMID ,GPJP_CHRDT_YY2 ,GPJP_CHRDT_MM2 ,GPJP_CHRDT_DD2 ,GPJP_YEA_FLADDR3 ,GPJP_ABROAD2 ,EMPLOYER ,GPJP_YEA_PRIGRS ,GPJP_YEA_PRITAX ,GPJP_YEA_PRISI ,GPJP_DISASTR_GRACE ,GPJP_CHRDT_YY3 ,GPJP_CHRDT_MM3 ,GPJP_CHRDT_DD3 ,GPJP_CHRDT_YY4 ,GPJP_CHRDT_MM4 ,GPJP_CHRDT_DD4 ,GPJP_NO_HOUSE_LOAN ,GPJP_YEA_HOUSE2 ,GPJP_APP_CLASS1 ,GPJP_PAYABLE_LOAN1 ,GPJP_CHRDT_YY5 ,GPJP_CHRDT_MM5 ,GPJP_CHRDT_DD5 ,GPJP_APP_CLASS2 ,GPJP_PAYABLE_LOAN2 ,GPJP_YEA_SUMM ,GPJP_YEA_LIFPREAC1 ,GPJP_YEA_LIFPREAC ,GPJP_YEA_CARPRE ,GPJP_YEA_PENPRE1 ,GPJP_YEA_DEPJUV ,GPJP_EFILE_SUMMARY , GPJP_YEA_NATPEN , GPJP_YEA_DEP_NRSD , GPJP_CORP_NUM_JPN , GPJP_NTNLID , GPJP_NM_KA_DP_SP , GPJP_NM_KJ_DP_SP , GPJP_NON_RST_SP , GPJP_PERS_NR_SP , GPJP_NM_KA_DEP1 , GPJP_NM_KJ_DEP1 , GPJP_NON_RSDT_FLG1 ,CASE WHEN GPJP_NON_RSDT_TYP1 <> ' ' THEN GPJP_NON_RSDT_TYP1 ELSE '00' END , GPJP_PERS_NBR1 , GPJP_NM_KA_DEP2 , GPJP_NM_KJ_DEP2 , GPJP_NON_RSDT_FLG2 ,CASE WHEN GPJP_NON_RSDT_TYP2 <> ' ' THEN GPJP_NON_RSDT_TYP2 ELSE '00' END , GPJP_PERS_NBR2 , GPJP_NM_KA_DEP3 , GPJP_NM_KJ_DEP3 , GPJP_NON_RSDT_FLG3 ,CASE WHEN GPJP_NON_RSDT_TYP3 <> ' ' THEN GPJP_NON_RSDT_TYP3 ELSE '00' END , GPJP_PERS_NBR3 , GPJP_NM_KA_DEP4 , GPJP_NM_KJ_DEP4 , GPJP_NON_RSDT_FLG4 ,CASE WHEN GPJP_NON_RSDT_TYP4 <> ' ' THEN GPJP_NON_RSDT_TYP4 ELSE '00' END , GPJP_PERS_NBR4 , GPJP_NM_KA_JDEP1 , GPJP_NM_KJ_JDEP1 , GPJP_NON_RST_JFLG1 , GPJP_NM_KA_JDEP2 , GPJP_NM_KJ_JDEP2 , GPJP_NON_RST_JFLG2 , GPJP_NM_KA_JDEP3 , GPJP_NM_KJ_JDEP3 , GPJP_NON_RST_JFLG3 , GPJP_NM_KA_JDEP4 , GPJP_NM_KJ_JDEP4 , GPJP_NON_RST_JFLG4 , GPJP_COMMENTS1 , GPJP_YEA_TOT11 , GPJP_YEA_TOT10 , GPJP_YEA_TOT11_C FROM PS_GPJP_EFIL_TAO

  • Parent record: PERSON

    • # 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 Record
    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 Disaster Grace
    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=01 Normal housing loan
    02=02 Long-term housing loan
    03=03 Specific repair work
    04=04 Victim of North JPN quake
    11=11 General (Spec Acquisition)
    12=12 Long-term(Spec Acquisition)
    13=13 Spec Repair work (Spec Acq)
    21=21 General (SS Acqisition)
    22=22 Long-term (SS Acquisition)
    24=24 North JPN quake (SS Acq)
    31=31 General (SSS Acquisition)
    32=32 Long-term (SSS Acquisition)
    34=34 North JPN quake (SSS Acq)
    41=41 General (Spec Resi House)
    42=42 Long-term (Spec Cert House)
    44=44 North JPN quake (Spec Resi)
    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=01 Normal housing loan
    02=02 Long-term housing loan
    03=03 Specific repair work
    04=04 Victim of North JPN quake
    11=11 General (Spec Acquisition)
    12=12 Long-term(Spec Acquisition)
    13=13 Spec Repair work (Spec Acq)
    21=21 General (SS Acqisition)
    22=22 Long-term (SS Acquisition)
    24=24 North JPN quake (SS Acq)
    31=31 General (SSS Acquisition)
    32=32 Long-term (SSS Acquisition)
    34=34 North JPN quake (SSS Acq)
    41=41 General (Spec Resi House)
    42=42 Long-term (Spec Cert House)
    44=44 North JPN quake (Spec Resi)
    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_EFILE_SUMMARY Character(254) VARCHAR2(254) NOT NULL E-File Summary
    99 GPJP_YEA_NATPEN Number(19,6) DECIMAL(18,6) NOT NULL National Insurance Premium
    100 GPJP_YEA_DEP_NRSD Number(2,0) SMALLINT NOT NULL Year-End Adjustment
    101 GPJP_CORP_NUM_JPN Number(13,0) DECIMAL(13) NOT NULL This field stores the Corporate Number of Japan Tax Establishments, SI establishments and LI establishments.
    102 GPJP_NTNLID Character(150) VARCHAR2(150) NOT NULL USED IN EFILE
    103 GPJP_NM_KA_DP_SP Character(30) VARCHAR2(30) NOT NULL Formal Name - name formatted for Formal Display by COuntry. Normally used in Correspondence.
    104 GPJP_NM_KJ_DP_SP Character(30) VARCHAR2(30) NOT NULL Formal Name - name formatted for Formal Display by COuntry. Normally used in Correspondence.
    105 GPJP_NON_RST_SP Character(2) VARCHAR2(2) NOT NULL kin flag used in efile
    106 GPJP_PERS_NR_SP Character(13) VARCHAR2(13) NOT NULL This field stores the My Number of each employee and dependent.
    107 GPJP_NM_KA_DEP1 Character(30) VARCHAR2(30) NOT NULL Formal Name - name formatted for Formal Display by COuntry. Normally used in Correspondence.
    108 GPJP_NM_KJ_DEP1 Character(30) VARCHAR2(30) NOT NULL Formal Name - name formatted for Formal Display by COuntry. Normally used in Correspondence.
    109 GPJP_NON_RSDT_FLG1 Character(2) VARCHAR2(2) NOT NULL kin flag used in efile
    110 GPJP_NON_RSDT_TYP1 Character(2) VARCHAR2(2) NOT NULL Non-Resident Type
    111 GPJP_PERS_NBR1 Character(13) VARCHAR2(13) NOT NULL This field stores the My Number of each employee and dependent.
    112 GPJP_NM_KA_DEP2 Character(30) VARCHAR2(30) NOT NULL Formal Name - name formatted for Formal Display by COuntry. Normally used in Correspondence.
    113 GPJP_NM_KJ_DEP2 Character(30) VARCHAR2(30) NOT NULL Formal Name - name formatted for Formal Display by COuntry. Normally used in Correspondence.
    114 GPJP_NON_RSDT_FLG2 Character(2) VARCHAR2(2) NOT NULL non-resident kin flag used in efile
    115 GPJP_NON_RSDT_TYP2 Character(2) VARCHAR2(2) NOT NULL Non-Resident Type
    116 GPJP_PERS_NBR2 Character(13) VARCHAR2(13) NOT NULL This field stores the My Number of each employee and dependent.
    117 GPJP_NM_KA_DEP3 Character(30) VARCHAR2(30) NOT NULL Formal Name - name formatted for Formal Display by COuntry. Normally used in Correspondence.
    118 GPJP_NM_KJ_DEP3 Character(30) VARCHAR2(30) NOT NULL Formal Name - name formatted for Formal Display by COuntry. Normally used in Correspondence.
    119 GPJP_NON_RSDT_FLG3 Character(2) VARCHAR2(2) NOT NULL kin flag used in efile
    120 GPJP_NON_RSDT_TYP3 Character(2) VARCHAR2(2) NOT NULL Non-Resident Type
    121 GPJP_PERS_NBR3 Character(13) VARCHAR2(13) NOT NULL This field stores the My Number of each employee and dependent.
    122 GPJP_NM_KA_DEP4 Character(30) VARCHAR2(30) NOT NULL Formal Name - name formatted for Formal Display by COuntry. Normally used in Correspondence.
    123 GPJP_NM_KJ_DEP4 Character(30) VARCHAR2(30) NOT NULL Formal Name - name formatted for Formal Display by COuntry. Normally used in Correspondence.
    124 GPJP_NON_RSDT_FLG4 Character(2) VARCHAR2(2) NOT NULL kin flag used in efile
    125 GPJP_NON_RSDT_TYP4 Character(2) VARCHAR2(2) NOT NULL Non-Resident Type
    126 GPJP_PERS_NBR4 Character(13) VARCHAR2(13) NOT NULL This field stores the My Number of each employee and dependent.
    127 GPJP_NM_KA_JDEP1 Character(30) VARCHAR2(30) NOT NULL Formal Name - name formatted for Formal Display by COuntry. Normally used in Correspondence.
    128 GPJP_NM_KJ_JDEP1 Character(30) VARCHAR2(30) NOT NULL Formal Name - name formatted for Formal Display by COuntry. Normally used in Correspondence.
    129 GPJP_NON_RST_JFLG1 Character(2) VARCHAR2(2) NOT NULL kin flag used in efile
    130 GPJP_NM_KA_JDEP2 Character(30) VARCHAR2(30) NOT NULL Formal Name - name formatted for Formal Display by COuntry. Normally used in Correspondence.
    131 GPJP_NM_KJ_JDEP2 Character(30) VARCHAR2(30) NOT NULL Formal Name - name formatted for Formal Display by COuntry. Normally used in Correspondence.
    132 GPJP_NON_RST_JFLG2 Character(2) VARCHAR2(2) NOT NULL kin flag used in efile
    133 GPJP_NM_KA_JDEP3 Character(30) VARCHAR2(30) NOT NULL Formal Name - name formatted for Formal Display by COuntry. Normally used in Correspondence.
    134 GPJP_NM_KJ_JDEP3 Character(30) VARCHAR2(30) NOT NULL Formal Name - name formatted for Formal Display by COuntry. Normally used in Correspondence.
    135 GPJP_NON_RST_JFLG3 Character(2) VARCHAR2(2) NOT NULL kin flag used in efile
    136 GPJP_NM_KA_JDEP4 Character(30) VARCHAR2(30) NOT NULL Formal Name - name formatted for Formal Display by COuntry. Normally used in Correspondence.
    137 GPJP_NM_KJ_JDEP4 Character(30) VARCHAR2(30) NOT NULL Formal Name - name formatted for Formal Display by COuntry. Normally used in Correspondence.
    138 GPJP_NON_RST_JFLG4 Character(2) VARCHAR2(2) NOT NULL kin flag used in efile
    139 GPJP_COMMENTS1 Character(100) VARCHAR2(100) NOT NULL EFILE USAGE
    140 GPJP_YEA_TOT11 Signed Number(20,6) DECIMAL(18,6) NOT NULL Total field used in YEA Self Service feature
    141 GPJP_YEA_TOT10 Signed Number(20,6) DECIMAL(18,6) NOT NULL Total field used in YEA Self Service feature
    142 GPJP_YEA_TOT11_C Character(20) VARCHAR2(20) NOT NULL Total field used in YEA Self Service feature