PERS_DATA_EFFDT (SQL Table)	Index Back
Effective Dated Personal Data PERS_DATA_EFFDT is one of the core records in the database. Use it to record effective dated personal data about an employee or applicant including name and address.

PERS_DATA_EFFDT

(SQL Table)

Effective Dated Personal Data

PERS_DATA_EFFDT is one of the core records in the database. Use it to record effective dated personal data about an employee or applicant including name and address.

Parent record: PERSON

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

3 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
Default Value: U

4 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. */

5 REG_REGION Character(5) VARCHAR2(5) NOT NULL Regulatory Region
Prompt Table: REG_GENDERID_VW

6 SEX Character(1) VARCHAR2(1) NOT NULL Gender
F=Female
M=Male
U=Unknown
Default Value: U

7 BIRTH_SEX Character(2) VARCHAR2(2) NOT NULL Birth Sex
Prompt Table: BIRTH_SEX_DTL

8 PRONOUN Character(2) VARCHAR2(2) NOT NULL Gender Pronoun
Prompt Table: GENDER_PRON_DTL

9 SEXUAL_ORIENTATION Character(2) VARCHAR2(2) NOT NULL Sexual Orientation
Prompt Table: GENDER_ORNT_DTL

10 GENDER_IDENTITY Character(2) VARCHAR2(2) NOT NULL Gender Identity
Prompt Table: GENDER_IDNT_DTL

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

12 FT_STUDENT Character(1) VARCHAR2(1) NOT NULL Full-Time Student
Y/N Table Edit
Default Value: N

13 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

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

15 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
Default Value: %datetime

16 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Default Value: NEW
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
3	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 Default Value: U
4	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. */
5	REG_REGION	Character(5)	VARCHAR2(5) NOT NULL	Regulatory Region Prompt Table: REG_GENDERID_VW
6	SEX	Character(1)	VARCHAR2(1) NOT NULL	Gender F=Female M=Male U=Unknown Default Value: U
7	BIRTH_SEX	Character(2)	VARCHAR2(2) NOT NULL	Birth Sex Prompt Table: BIRTH_SEX_DTL
8	PRONOUN	Character(2)	VARCHAR2(2) NOT NULL	Gender Pronoun Prompt Table: GENDER_PRON_DTL
9	SEXUAL_ORIENTATION	Character(2)	VARCHAR2(2) NOT NULL	Sexual Orientation Prompt Table: GENDER_ORNT_DTL
10	GENDER_IDENTITY	Character(2)	VARCHAR2(2) NOT NULL	Gender Identity Prompt Table: GENDER_IDNT_DTL
11	HIGHEST_EDUC_LVL	Character(2)	VARCHAR2(2) NOT NULL	Highest Education Level
12	FT_STUDENT	Character(1)	VARCHAR2(1) NOT NULL	Full-Time Student Y/N Table Edit Default Value: N
13	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
14	ALTER_EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Alternate Employee ID
15	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. Default Value: %datetime
16	LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.