SCC_SM_PDE_I (SQL View)	Index Back
Personal fields for Ext S/M Personal data fields used to define the External Search/Match response message

SCC_SM_PDE_I

(SQL View)

Personal fields for Ext S/M

Personal data fields used to define the External Search/Match response message

SELECT 'P' ,' ' ,A.EMPLID ,A.EFFDT ,A.MAR_STATUS ,A.MAR_STATUS_DT ,A.SEX ,A.HIGHEST_EDUC_LVL ,A.FT_STUDENT ,A.LANG_CD ,A.ALTER_EMPLID FROM PS_HCR_PER_PDE_I A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SM_TYPE Character(1) VARCHAR2(1) NOT NULL Search Match Type: This field identifies the domain of core data to be searched.
A=Applicant
O=Organization
P=Person

2 SCC_UID Character(100) VARCHAR2(100) NOT NULL Universal Hub ID

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

4 EFFDT Date(10) DATE Effective Date

5 MAR_STATUS Character(1) VARCHAR2(1) NOT NULL Marital Status
C=Common-Law
D=Divorced
E=Separated
H=Head of Household
L=DissDeclLost Civil Partner
M=Married
P=Civil Partnership
S=Single
T=Surviving Civil Partner
U=Unknown
V=Dissolved Civil Partnership
W=Widowed

6 MAR_STATUS_DT Date(10) DATE This is the date that the employee's Marital status is/was effective. /* Marital Status date is stored redundantly on PERS_DATA_EFFDT for two reasons. 1. To allow the date to be entered prior to the first PERS_DATA_EFFDT so that the actual date for the marital status on the hire row can be entered. This is the only time that the field is enterable by the user. 2. To allow for easier reporting on the data via SQR and Crystal. This is denormalizing the PERS_DATA_EFFDT record, but the number of requests for this redundancy coupled with the need for #1, has provided the justification for denormalizing this information and taking on the added maintenance. */

7 SEX Character(1) VARCHAR2(1) NOT NULL Gender
F=Female
M=Male
U=Unknown
X=Indeterminate/Intersex/Unspec

8 HIGHEST_EDUC_LVL Character(2) VARCHAR2(2) NOT NULL Highest Education Level

9 FT_STUDENT Character(1) VARCHAR2(1) NOT NULL Full-Time Student
Y/N Table Edit

10 LANG_CD Character(3) VARCHAR2(3) NOT NULL Language Code
CFR=Canadian French
DAN=Danish
DUT=Dutch
ENG=English
ESP=Spanish
FRA=French
GER=German
GRK=Greek
INE=International English
ITA=Italian
JPN=Japanese
KOR=Korean
POR=Portuguese
SVE=Swedish
THA=Thai
ZHS=Simplified Chinese
ZHT=Traditional Chinese

11 ALTER_EMPLID Character(11) VARCHAR2(11) NOT NULL Alternate Employee ID

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SM_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Search Match Type: This field identifies the domain of core data to be searched. A=Applicant O=Organization P=Person
2	SCC_UID	Character(100)	VARCHAR2(100) NOT NULL	Universal Hub ID
3	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
4	EFFDT	Date(10)	DATE	Effective Date
5	MAR_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Marital Status C=Common-Law D=Divorced E=Separated H=Head of Household L=DissDeclLost Civil Partner M=Married P=Civil Partnership S=Single T=Surviving Civil Partner U=Unknown V=Dissolved Civil Partnership W=Widowed
6	MAR_STATUS_DT	Date(10)	DATE	This is the date that the employee's Marital status is/was effective. /* Marital Status date is stored redundantly on PERS_DATA_EFFDT for two reasons. 1. To allow the date to be entered prior to the first PERS_DATA_EFFDT so that the actual date for the marital status on the hire row can be entered. This is the only time that the field is enterable by the user. 2. To allow for easier reporting on the data via SQR and Crystal. This is denormalizing the PERS_DATA_EFFDT record, but the number of requests for this redundancy coupled with the need for #1, has provided the justification for denormalizing this information and taking on the added maintenance. */
7	SEX	Character(1)	VARCHAR2(1) NOT NULL	Gender F=Female M=Male U=Unknown X=Indeterminate/Intersex/Unspec
8	HIGHEST_EDUC_LVL	Character(2)	VARCHAR2(2) NOT NULL	Highest Education Level
9	FT_STUDENT	Character(1)	VARCHAR2(1) NOT NULL	Full-Time Student Y/N Table Edit
10	LANG_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code CFR=Canadian French DAN=Danish DUT=Dutch ENG=English ESP=Spanish FRA=French GER=German GRK=Greek INE=International English ITA=Italian JPN=Japanese KOR=Korean POR=Portuguese SVE=Swedish THA=Thai ZHS=Simplified Chinese ZHT=Traditional Chinese
11	ALTER_EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Alternate Employee ID