GPJP_REL_MAP (SQL Table)	Index Back
Mapping Table for Relationship This table is used when the system converts dependent's relationship into gender dependent ones (For example, from 'Parent' to 'Father' or 'Mother').

GPJP_REL_MAP

(SQL Table)

Mapping Table for Relationship

This table is used when the system converts dependent's relationship into gender dependent ones (For example, from 'Parent' to 'Father' or 'Mother').

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 GPJP_RELATIONSHIP Character(2) VARCHAR2(2) NOT NULL Relationships for Japan used in Reports and Dependent Tax data.

2 RELATIONSHIP Character(2) VARCHAR2(2) NOT NULL Relationship to Employee

3 SEX Character(1) VARCHAR2(1) NOT NULL Gender
F=Female
M=Male
U=Unknown

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	GPJP_RELATIONSHIP	Character(2)	VARCHAR2(2) NOT NULL	Relationships for Japan used in Reports and Dependent Tax data.
2	RELATIONSHIP	Character(2)	VARCHAR2(2) NOT NULL	Relationship to Employee
3	SEX	Character(1)	VARCHAR2(1) NOT NULL	Gender F=Female M=Male U=Unknown