PERSNL_FERPA_VW

(SQL View)
 Index Back

FERPA Personal Data View

This is a view of Personal Data fields used in FERPA processing. 01/23/2004 - Person Model Change Before SQL SELECT A.EMPLID ,A.PER_STATUS ,A.MAR_STATUS ,A.BIRTHDATE ,A.BIRTHPLACE ,A.SEX FROM PS_PERSONAL_DATA A

SELECT A.EMPLID , 'N' , B.MAR_STATUS , A.BIRTHDATE , A.BIRTHPLACE , B.SEX , 'N' , 'N' , 'N' , P.SCC_BIRTH_GENDER ,P.SCC_GENDER_ID ,P.SCC_GENDER_ID_OTH ,P.SCC_SEXUAL_ORT ,P.SCC_SEXUAL_ORT_OTH ,P.SCC_PRONOUNS ,P.SCC_PRONOUNS_OTH ,P.SCC_BIO_ATTRB_1 ,P.SCC_BIO_ATTRB_2 ,P.SCC_BIO_ATTRB_3 ,P.SCC_BIO_ATTRB_4 ,P.SCC_BIO_ATTRB_5 ,P.SCC_BIO_ATTRB_6 ,P.SCC_BIO_ATTRB_7 ,P.SCC_BIO_ATTRB_8 ,P.SCC_BIO_ATTRB_9 , U.Military_Status , R.Religious_pref FROM PS_HCR_PERSON_I A , PS_HCR_PER_PDE_I B LEFT OUTER JOIN PS_SCC_PERS_BIO_VW p ON b.emplid=p.emplid LEFT OUTER JOIN PS_SCC_PERS_USA_VW u ON b.emplid=u.emplid LEFT OUTER JOIN PS_RELIGIOUS_PREF r ON b.emplid=r.emplid WHERE A.EMPLID = B.EMPLID AND %EffdtCheck(HCR_PER_PDE_I B1, B, %CurrentDateIn)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 PER_STATUS Character(1) VARCHAR2(1) NOT NULL Personnel Status
E=Employee
N=Non-Employee
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
4 BIRTHDATE Date(10) DATE Date of Birth
5 BIRTHPLACE Character(30) VARCHAR2(30) NOT NULL Birth Location
6 SEX Character(1) VARCHAR2(1) NOT NULL Gender
F=Female
M=Male
U=Unknown
X=Indeterminate/Intersex/Unspec
7 PER_ORG_CWR Character(1) VARCHAR2(1) NOT NULL Indicates that a person has a contingent worker relationship to the organization.

Y/N Table Edit

8 PER_ORG_EMP Character(1) VARCHAR2(1) NOT NULL Indicates if a Person has an Employee relationship to the organization.

Y/N Table Edit

9 PER_ORG_POI Character(1) VARCHAR2(1) NOT NULL Funclib_HR_CORE field to store basic functions for PER_ORG POI

Y/N Table Edit

10 SCC_BIRTH_GENDER Character(1) VARCHAR2(1) NOT NULL Birth Gender
F=Female
M=Male
N=Not Applicable
P=Prefer not to say
U=Unknown
X=Intersex
11 SCC_GENDER_ID Character(2) VARCHAR2(2) NOT NULL Gender Identity
OT=Other
PN=Prefer not to say
UN=Unknown
12 SCC_GENDER_ID_OTH Character(120) VARCHAR2(120) NOT NULL Other Gender Identity
13 SCC_SEXUAL_ORT Character(2) VARCHAR2(2) NOT NULL Sexual Orientation
OT=Other
PN=Prefer not to say
UN=Unknown
14 SCC_SEXUAL_ORT_OTH Character(120) VARCHAR2(120) NOT NULL Other Sexual Orientation
15 SCC_PRONOUNS Character(2) VARCHAR2(2) NOT NULL Preferred Pronouns
OT=Other
PN=Prefer not to say
UN=Unknown
16 SCC_PRONOUNS_OTH Character(120) VARCHAR2(120) NOT NULL Other Preferred Pronouns
17 SCC_BIO_ATTRB_1 Character(2) VARCHAR2(2) NOT NULL Biographical Attribute 1
UN=Unknown
18 SCC_BIO_ATTRB_2 Character(2) VARCHAR2(2) NOT NULL Biographical Attribute 2
UN=Unknown
19 SCC_BIO_ATTRB_3 Character(2) VARCHAR2(2) NOT NULL Biographical Attribute 3
UN=Unknown
20 SCC_BIO_ATTRB_4 Character(2) VARCHAR2(2) NOT NULL Biographical Attribute 4
UN=Unknown
21 SCC_BIO_ATTRB_5 Character(2) VARCHAR2(2) NOT NULL Biographical Attribute 5
UN=Unknown
22 SCC_BIO_ATTRB_6 Character(2) VARCHAR2(2) NOT NULL Biographical Attribute 6
UN=Unknown
23 SCC_BIO_ATTRB_7 Character(2) VARCHAR2(2) NOT NULL Biographical Attribute 7
UN=Unknown
24 SCC_BIO_ATTRB_8 Character(2) VARCHAR2(2) NOT NULL Biographical Attribute 8
UN=Unknown
25 SCC_BIO_ATTRB_9 Character(2) VARCHAR2(2) NOT NULL Biographical Attribute 9
UN=Unknown
26 MILITARY_STATUS Character(1) VARCHAR2(1) NOT NULL Veteran Status / Military Status
1=Not indicated
2=No Military Service
3=Veteran of the Vietnam Era
4=Active Duty/Campaign Badge Vet
4=Other Protected Veteran
5=Active Reserve
6=Inactive Reserve
7=Retired Military
8=Veteran (VA Ineligible)
9=Vietnam & Active Duty Vet
9=Vietnam & Other Protected Vet
A=Armed Forces Service Medal Vet
B=Pre-Vietnam-Era Veteran
C=Separated/Srvc Medal/Active
C=Separated/Srvc Medal/Other Vet
D=Protected, Not Classified
N=Not a Vietnam-Era Veteran
O=Service Medal & Active Duty
O=Service Medal & Other Vet
P=Post-Vietnam-Era Veteran
R=Recently Separated Veteran
S=Separated & Service Medal Vet
T=Separated & Active Duty Vet
T=Separated & Other Vet
V=Vietnam-Era Veteran
X=Not a Veteran
X=Not a Veteran
Z=Not a Protected Veteran
27 RELIGIOUS_PREF Character(4) VARCHAR2(4) NOT NULL Religious Preference