FT_DEP_PERSON (SQL Table)	Index Back
PERSON record This record holes the Person information of Employee Dependents

FT_DEP_PERSON

(SQL Table)

PERSON record

This record holes the Person information of Employee Dependents

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Default Value: NEW

2 BIRTHDATE Date(10) DATE Date of Birth

3 BIRTHPLACE Character(30) VARCHAR2(30) NOT NULL Birth Location

4 BIRTHCOUNTRY Character(3) VARCHAR2(3) NOT NULL Birth Country
Prompt Table: COUNTRY_TBL

5 BIRTHSTATE Character(6) VARCHAR2(6) NOT NULL Birth State
Prompt Table: BIRTHSTATE_VW

6 DT_OF_DEATH Date(10) DATE Date of Death

7 EMPLID2 Character(11) VARCHAR2(11) NOT NULL Field is referenced in state record used by Cobra Upgrade.

8 DEPENDENT_BENEF Character(2) VARCHAR2(2) NOT NULL Dependent Benefit
01=default

9 CONTACT_NAME Character(50) VARCHAR2(50) NOT NULL Contact Name

10 NUMROWS Number(15,0) DECIMAL(15) NOT NULL Number of Rows fetched.

11 LAST_CHILD_UPDDTM DateTime(26) TIMESTAMP Used to indicate the last update to any data belonging to this logical object. For PER_ORG_ASGN - this means any update to its children in JOB_DATA that do not have their own date. For PERSON - this means any update to its children in PERSONAL_DATA that do not have their own date.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Default Value: NEW
2	BIRTHDATE	Date(10)	DATE	Date of Birth
3	BIRTHPLACE	Character(30)	VARCHAR2(30) NOT NULL	Birth Location
4	BIRTHCOUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Birth Country Prompt Table: COUNTRY_TBL
5	BIRTHSTATE	Character(6)	VARCHAR2(6) NOT NULL	Birth State Prompt Table: BIRTHSTATE_VW
6	DT_OF_DEATH	Date(10)	DATE	Date of Death
7	EMPLID2	Character(11)	VARCHAR2(11) NOT NULL	Field is referenced in state record used by Cobra Upgrade.
8	DEPENDENT_BENEF	Character(2)	VARCHAR2(2) NOT NULL	Dependent Benefit 01=default
9	CONTACT_NAME	Character(50)	VARCHAR2(50) NOT NULL	Contact Name
10	NUMROWS	Number(15,0)	DECIMAL(15) NOT NULL	Number of Rows fetched.
11	LAST_CHILD_UPDDTM	DateTime(26)	TIMESTAMP	Used to indicate the last update to any data belonging to this logical object. For PER_ORG_ASGN - this means any update to its children in JOB_DATA that do not have their own date. For PERSON - this means any update to its children in PERSONAL_DATA that do not have their own date.