PERSONAL_DT_AET

(SQL Table)
 Index Back

Personal Data SnapShot 1

Record is used to create the PERSONAL_DATA view - use for reporting only. This record is updated using the message PERSON_BASIC_SYNC. Phone used is the Preferred Phone. Email used is the Preferred Email. Address used is the HOME address. Other Address used is the MAIL address.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 ADDRESS_TYPE Character(4) VARCHAR2(4) NOT NULL Address Type
3 ADDRESS_TYPE_OTH Character(4) VARCHAR2(4) NOT NULL Address Type
4 PHONE_FLG Character(1) VARCHAR2(1) NOT NULL Flag to determine whether to include the Phone Data

Y/N Table Edit

Default Value: Y

5 SMOKER_FLG Character(1) VARCHAR2(1) NOT NULL Flag to determine whether to include the Phone Data

Y/N Table Edit

Default Value: Y

6 COUNTRY_FLG Character(1) VARCHAR2(1) NOT NULL Flag to determine whether to include the installed country extension fields

Y/N Table Edit

Default Value: Y

7 USF_FLG Character(1) VARCHAR2(1) NOT NULL Flag to determine whether to include the US Federal fields

Y/N Table Edit

Default Value: N

8 SA_FLG Character(1) VARCHAR2(1) NOT NULL Flag to determine whether to include the Phone Data

Y/N Table Edit

Default Value: N

9 US Character(1) VARCHAR2(1) NOT NULL USA - United States
10 CAN Character(1) VARCHAR2(1) NOT NULL CAN - Canada
11 ESP Character(1) VARCHAR2(1) NOT NULL ESP - Spain
12 GER Character(1) VARCHAR2(1) NOT NULL DEU - Germany
13 JPN Character(1) VARCHAR2(1) NOT NULL JPN - Japan
14 ITA Character(1) VARCHAR2(1) NOT NULL Italian HR Functionality/ Person name/ Name
15 FRA Character(1) VARCHAR2(1) NOT NULL FRA - France
16 AE_TEST_FLAG Character(1) VARCHAR2(1) NOT NULL Test Flag