PERSON_MSK_VW (SQL View)	Index Back
PERSON DDA mask view This is a view of the PERSON record that masks the BIRTHDATE search result field depending on the DDA setting for the operator's permission list.

PERSON_MSK_VW

(SQL View)

PERSON DDA mask view

This is a view of the PERSON record that masks the BIRTHDATE search result field depending on the DDA setting for the operator's permission list.

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 , A.BIRTHPLACE , A.BIRTHCOUNTRY , A.BIRTHSTATE , A.DT_OF_DEATH , C.CAMPUS_ID , C.FERPA , C.VA_BENEFIT , C.PLACE_OF_DEATH , C.DEATH_CERTIF_NBR FROM PS_HCR_PERSON_I A , PS_PERS_MSK_CFG B , PS_PERSON_SA C WHERE A.EMPLID = C.EMPLID

# 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 BIRTHPLACE Character(30) VARCHAR2(30) NOT NULL Birth Location

6 BIRTHCOUNTRY Character(3) VARCHAR2(3) NOT NULL Birth Country
Prompt Table: COUNTRY_TBL

7 BIRTHSTATE Character(6) VARCHAR2(6) NOT NULL Birth State
Prompt Table: BIRTHSTATE_VW

8 DT_OF_DEATH Date(10) DATE Date of Death

9 CAMPUS_ID Character(16) VARCHAR2(16) NOT NULL Campus ID

10 FERPA Character(1) VARCHAR2(1) NOT NULL FERPA

11 VA_BENEFIT Character(1) VARCHAR2(1) NOT NULL VA Benefit

12 PLACE_OF_DEATH Character(30) VARCHAR2(30) NOT NULL Place of Death

13 DEATH_CERTIF_NBR Character(10) VARCHAR2(10) NOT NULL Death Certificate Nbr

#	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	BIRTHPLACE	Character(30)	VARCHAR2(30) NOT NULL	Birth Location
6	BIRTHCOUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Birth Country Prompt Table: COUNTRY_TBL
7	BIRTHSTATE	Character(6)	VARCHAR2(6) NOT NULL	Birth State Prompt Table: BIRTHSTATE_VW
8	DT_OF_DEATH	Date(10)	DATE	Date of Death
9	CAMPUS_ID	Character(16)	VARCHAR2(16) NOT NULL	Campus ID
10	FERPA	Character(1)	VARCHAR2(1) NOT NULL	FERPA
11	VA_BENEFIT	Character(1)	VARCHAR2(1) NOT NULL	VA Benefit
12	PLACE_OF_DEATH	Character(30)	VARCHAR2(30) NOT NULL	Place of Death
13	DEATH_CERTIF_NBR	Character(10)	VARCHAR2(10) NOT NULL	Death Certificate Nbr