GPJP_IT_DEP_TAX(SQL Table) |
Index Back |
---|---|
Contains an EE's dependent taxThis record should contain one record for each of an employee's dependents. |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
2 | DEPENDENT_BENEF | Character(2) | VARCHAR2(2) NOT NULL |
Dependent Benefit
01=default |
3 | EFFDT | Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
4 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL |
Empl Record
Prompt Table: %GP_EDIT_FLD1 |
5 | GPJP_IT_SUBJ_DED | Character(1) | VARCHAR2(1) NOT NULL |
Dependent Subjected to Deduction Flag
Y/N Table Edit Default Value: N |
6 | GPJP_PARENT_LWP | Character(1) | VARCHAR2(1) NOT NULL |
Parent Living with Payee
Y/N Table Edit Default Value: N |
7 | GPJP_IT_DEPDIS | Character(2) | VARCHAR2(2) NOT NULL |
Used in Dependent Tax Data.
10=No Disability 20=Disabled 30=Special Disability 40=Living with Special Disabled Default Value: 10 |
8 | GPJP_DEP_JOB | Character(20) | VARCHAR2(20) NOT NULL | Dependent Job used in GPJP_IT_DEP_TAX |
9 | GPJP_DEP_INC | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Dependent Annual Income |
10 | GPJP_NO_RSDNT_RLTV | Character(1) | VARCHAR2(1) NOT NULL |
Non-Resident Relative indicator
Y/N Table Edit Default Value: N |
11 | GPJP_FCT_UNFY_LVNG | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | The fact unifying a living |
12 | GPJP_DEP_RCHAN | Character(50) | VARCHAR2(50) NOT NULL | Reason of change |
13 | GPJP_DIS_DESCR | Character(50) | VARCHAR2(50) NOT NULL | Disability Description |
14 | GPJP_DIS_RCHAN | Character(50) | VARCHAR2(50) NOT NULL | Reason of Disability Change |
15 | GPJP_INC_AMT_DED | Character(1) | VARCHAR2(1) NOT NULL |
Subject to Income Amount Deduction
N=No Y=Yes Y/N Table Edit Default Value: N |
16 | 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 |
17 | GPJP_EST_ANNUL_INC | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Estimated annual income excluding retirement allowance amount |
18 | GPJP_RETIR_ALLWNCE | Character(1) | VARCHAR2(1) NOT NULL |
Has Retiremet Allowance
N=No Y=Yes |