SAE_PERSON_VW (SQL View)	Index Back
SAIP person view

SAE_PERSON_VW

(SQL View)

SAIP person view

SELECT PERSON.EMPLID , PERSON.BIRTHDATE , PERSON.BIRTHPLACE , PERSON.BIRTHCOUNTRY , PERSON.BIRTHSTATE , PERSON.DT_OF_DEATH , PERSON.LAST_CHILD_UPDDTM , 'C' FROM %Table(PERSON) PERSON

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

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

5 BIRTHSTATE Character(6) VARCHAR2(6) NOT NULL Birth State

6 DT_OF_DEATH Date(10) DATE Date of Death

7 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.

8 SAE_MODE Character(1) VARCHAR2(1) NOT NULL Operation Mode
A=Add
C=Change
D=Delete

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
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
5	BIRTHSTATE	Character(6)	VARCHAR2(6) NOT NULL	Birth State
6	DT_OF_DEATH	Date(10)	DATE	Date of Death
7	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.
8	SAE_MODE	Character(1)	VARCHAR2(1) NOT NULL	Operation Mode A=Add C=Change D=Delete