PROCESS_INSTANCEEMPLID10=Between 16 and 29 or Over 70
20=Studying abroad
30=Disabled
40=Payment of 380000 yen or above
GPJP_DP_EFL_TBL(SQL Table) |
Index Back |
|---|---|
staging record used in Efilestaging record used for efile report japan, fetching dependent required data |
| # | 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 | 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. |
| 4 | GPJP_NTNLID | Character(150) | VARCHAR2(150) NOT NULL | USED IN EFILE |
| 5 | GPJP_NM_KA_DEP1 | Character(30) | VARCHAR2(30) NOT NULL | Formal Name - name formatted for Formal Display by COuntry. Normally used in Correspondence. |
| 6 | GPJP_NM_KJ_DEP1 | Character(30) | VARCHAR2(30) NOT NULL | Formal Name - name formatted for Formal Display by COuntry. Normally used in Correspondence. |
| 7 | GPJP_NON_RSDT_FLG1 | Character(2) | VARCHAR2(2) NOT NULL | kin flag used in efile |
| 8 | GPJP_PERS_NBR1 | Character(13) | VARCHAR2(13) NOT NULL | This field stores the My Number of each employee and dependent. |
| 9 | GPJP_NM_KA_DEP2 | Character(30) | VARCHAR2(30) NOT NULL | Formal Name - name formatted for Formal Display by COuntry. Normally used in Correspondence. |
| 10 | GPJP_NM_KJ_DEP2 | Character(30) | VARCHAR2(30) NOT NULL | Formal Name - name formatted for Formal Display by COuntry. Normally used in Correspondence. |
| 11 | GPJP_NON_RSDT_FLG2 | Character(2) | VARCHAR2(2) NOT NULL | non-resident kin flag used in efile |
| 12 | GPJP_PERS_NBR2 | Character(13) | VARCHAR2(13) NOT NULL | This field stores the My Number of each employee and dependent. |
| 13 | GPJP_NM_KA_DEP3 | Character(30) | VARCHAR2(30) NOT NULL | Formal Name - name formatted for Formal Display by COuntry. Normally used in Correspondence. |
| 14 | GPJP_NM_KJ_DEP3 | Character(30) | VARCHAR2(30) NOT NULL | Formal Name - name formatted for Formal Display by COuntry. Normally used in Correspondence. |
| 15 | GPJP_NON_RSDT_FLG3 | Character(2) | VARCHAR2(2) NOT NULL | kin flag used in efile |
| 16 | GPJP_PERS_NBR3 | Character(13) | VARCHAR2(13) NOT NULL | This field stores the My Number of each employee and dependent. |
| 17 | GPJP_NM_KA_DEP4 | Character(30) | VARCHAR2(30) NOT NULL | Formal Name - name formatted for Formal Display by COuntry. Normally used in Correspondence. |
| 18 | GPJP_NM_KJ_DEP4 | Character(30) | VARCHAR2(30) NOT NULL | Formal Name - name formatted for Formal Display by COuntry. Normally used in Correspondence. |
| 19 | GPJP_NON_RSDT_FLG4 | Character(2) | VARCHAR2(2) NOT NULL | kin flag used in efile |
| 20 | GPJP_PERS_NBR4 | Character(13) | VARCHAR2(13) NOT NULL | This field stores the My Number of each employee and dependent. |
| 21 | GPJP_NM_KA_JDEP1 | Character(30) | VARCHAR2(30) NOT NULL | Formal Name - name formatted for Formal Display by COuntry. Normally used in Correspondence. |
| 22 | GPJP_NM_KJ_JDEP1 | Character(30) | VARCHAR2(30) NOT NULL | Formal Name - name formatted for Formal Display by COuntry. Normally used in Correspondence. |
| 23 | GPJP_NON_RST_JFLG1 | Character(2) | VARCHAR2(2) NOT NULL | kin flag used in efile |
| 24 | GPJP_JPERS_NBR1 | Character(13) | VARCHAR2(13) NOT NULL | This field stores the My Number of each employee and dependent. |
| 25 | GPJP_NM_KA_JDEP2 | Character(30) | VARCHAR2(30) NOT NULL | Formal Name - name formatted for Formal Display by COuntry. Normally used in Correspondence. |
| 26 | GPJP_NM_KJ_JDEP2 | Character(30) | VARCHAR2(30) NOT NULL | Formal Name - name formatted for Formal Display by COuntry. Normally used in Correspondence. |
| 27 | GPJP_NON_RST_JFLG2 | Character(2) | VARCHAR2(2) NOT NULL | kin flag used in efile |
| 28 | GPJP_JPERS_NBR2 | Character(13) | VARCHAR2(13) NOT NULL | This field stores the My Number of each employee and dependent. |
| 29 | GPJP_NM_KA_JDEP3 | Character(30) | VARCHAR2(30) NOT NULL | Formal Name - name formatted for Formal Display by COuntry. Normally used in Correspondence. |
| 30 | GPJP_NM_KJ_JDEP3 | Character(30) | VARCHAR2(30) NOT NULL | Formal Name - name formatted for Formal Display by COuntry. Normally used in Correspondence. |
| 31 | GPJP_NON_RST_JFLG3 | Character(2) | VARCHAR2(2) NOT NULL | kin flag used in efile |
| 32 | GPJP_JPERS_NBR3 | Character(13) | VARCHAR2(13) NOT NULL | This field stores the My Number of each employee and dependent. |
| 33 | GPJP_NM_KA_JDEP4 | Character(30) | VARCHAR2(30) NOT NULL | Formal Name - name formatted for Formal Display by COuntry. Normally used in Correspondence. |
| 34 | GPJP_NM_KJ_JDEP4 | Character(30) | VARCHAR2(30) NOT NULL | Formal Name - name formatted for Formal Display by COuntry. Normally used in Correspondence. |
| 35 | GPJP_NON_RST_JFLG4 | Character(2) | VARCHAR2(2) NOT NULL | kin flag used in efile |
| 36 | GPJP_JPERS_NBR4 | Character(13) | VARCHAR2(13) NOT NULL | This field stores the My Number of each employee and dependent. |
| 37 | GPJP_NM_KA_DP_SP | Character(30) | VARCHAR2(30) NOT NULL | Formal Name - name formatted for Formal Display by COuntry. Normally used in Correspondence. |
| 38 | GPJP_NM_KJ_DP_SP | Character(30) | VARCHAR2(30) NOT NULL | Formal Name - name formatted for Formal Display by COuntry. Normally used in Correspondence. |
| 39 | GPJP_NON_RST_SP | Character(2) | VARCHAR2(2) NOT NULL | kin flag used in efile |
| 40 | GPJP_PERS_NR_SP | Character(13) | VARCHAR2(13) NOT NULL | This field stores the My Number of each employee and dependent. |
| 41 | GPJP_COMMENTS1 | Character(100) | VARCHAR2(100) NOT NULL | EFILE USAGE |
| 42 | GPJP_COMMENTS2 | Character(100) | VARCHAR2(100) NOT NULL | EFILE USAGE |
| 43 | GPJP_COMMENTS | Character(254) | VARCHAR2(254) NOT NULL | EFILE USAGE |
| 44 | GPJP_DEP_DETAILS | Long Character(2400) | CLOB | EFILE USAGE |
| 45 | GPJP_DEP_DETAILS_1 | Long Character(2400) | CLOB | EFILE USAGE |
| 46 | GPJP_NID_DEP_JPN | Long Character(600) | VARCHAR2(600) | EFILE USAGE |
| 47 | GPJP_NON_RSDT_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Non-Resident Type
10=Between 16 and 29 or Over 70 20=Studying abroad 30=Disabled 40=Payment of 380000 yen or above |
| 48 | GPJP_NON_RSDT_TYP1 | Character(2) | VARCHAR2(2) NOT NULL | Non-Resident Type |
| 49 | GPJP_NON_RSDT_TYP2 | Character(2) | VARCHAR2(2) NOT NULL | Non-Resident Type |
| 50 | GPJP_NON_RSDT_TYP3 | Character(2) | VARCHAR2(2) NOT NULL | Non-Resident Type |
| 51 | GPJP_NON_RSDT_TYP4 | Character(2) | VARCHAR2(2) NOT NULL | Non-Resident Type |