PERS_DTA_MSK_VW (SQL View)	Index Back
EE Personal Data PERSONAL_DATA is one of the core records in the database. Use it to record personal and demographic data about an employee or applicant including name, address, birthdate, and ethnic group. You can create only one PERSONAL_DATA record per person.

PERS_DTA_MSK_VW

(SQL View)

EE Personal Data

PERSONAL_DATA is one of the core records in the database. Use it to record personal and demographic data about an employee or applicant including name, address, birthdate, and ethnic group. You can create only one PERSONAL_DATA record per person.

SELECT B.OPRCLASS ,A.EMPLID ,A.BIRTHDATE ,CASE WHEN B.MASK_CFG_DOB='1' THEN '**/**/****' WHEN B.MASK_CFG_DOB='2' THEN TO_CHAR(A.BIRTHDATE , 'MM/DD') ELSE TO_CHAR(A.BIRTHDATE , 'MM/DD/YYYY') END ,B.MASK_CFG_DOB FROM PS_PERSON A , PS_PERS_MSK_CFG B

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRCLASS Character(30) VARCHAR2(30) NOT NULL Operator Class

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

3 BIRTHDATE Date(10) DATE Date of Birth

4 BIRTHDATE_MSK Character(10) VARCHAR2(10) NOT NULL Date of Birth

5 MASK_CFG_DOB Character(2) VARCHAR2(2) NOT NULL Mask Birthdate
1=Mask entire field
2=Display partial date
3=Display entire field

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRCLASS	Character(30)	VARCHAR2(30) NOT NULL	Operator Class
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Default Value: NEW
3	BIRTHDATE	Date(10)	DATE	Date of Birth
4	BIRTHDATE_MSK	Character(10)	VARCHAR2(10) NOT NULL	Date of Birth
5	MASK_CFG_DOB	Character(2)	VARCHAR2(2) NOT NULL	Mask Birthdate 1=Mask entire field 2=Display partial date 3=Display entire field