HCR_PERSON_I (SQL View)	Index Back
Interface VW for Person PERSON one of the core records in the database. It contains one row for every Person (EMPLID) in the system. It is the Parent record or PERS_DATA_EFFDT, EMPLOYMENT etc.

HCR_PERSON_I

(SQL View)

Interface VW for Person

PERSON one of the core records in the database. It contains one row for every Person (EMPLID) in the system. It is the Parent record or PERS_DATA_EFFDT, EMPLOYMENT etc.

SELECT A.EMPLID ,A.BIRTHDATE ,A.BIRTHPLACE ,A.BIRTHCOUNTRY ,A.BIRTHSTATE ,A.DT_OF_DEATH FROM PS_PERSON A

Parent Record Of SCC_ADDR_H SCC_NAMES_H SCC_NAMES_L1_H

# 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

#	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