GM_XML_PERS_VW

(SQL View)
 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.

SELECT A.EMPLID , A.AMERICAN_INDIAN , A.ASIAN , A.BLACK , A.ETHNICITY , A.NATIVE_HAWAIIAN , A.NOT_APPLICABLE , A.WHITE , A.SOURCE_SYSTEM , A.DIS_HEARING , A.DIS_VISION , A.DIS_MOB_ORTH , A.DIS_OTHER , A.DIS_NONE , A.DIS_DONT_PROVIDE , %subrec(PERS_DTGM_SBR, A) FROM PS_GM_PERS_DATA A WHERE A.EFFDT = ( SELECT MAX(A1.EFFDT) FROM PS_GM_PERS_DATA A1 WHERE A1.EMPLID = A.EMPLID AND A1.EFFDT <= %CurrentDateIn)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 AMERICAN_INDIAN Character(1) VARCHAR2(1) NOT NULL American Indian/Alaska Native

Y/N Table Edit

3 ASIAN Character(1) VARCHAR2(1) NOT NULL Asian

Y/N Table Edit

4 BLACK Character(1) VARCHAR2(1) NOT NULL Black/African American

Y/N Table Edit

5 ETHNICITY Character(1) VARCHAR2(1) NOT NULL Ethnicity
1=Hispanic or Latino
2=Not Hispanic or Latino
E=Do Not Wish To Provide
6 NATIVE_HAWAIIAN Character(1) VARCHAR2(1) NOT NULL Native Hawaiian/Pacific Island

Y/N Table Edit

7 NOT_APPLICABLE Character(1) VARCHAR2(1) NOT NULL Not Applicable

Y/N Table Edit

8 WHITE Character(1) VARCHAR2(1) NOT NULL White

Y/N Table Edit

9 SOURCE_SYSTEM Character(3) VARCHAR2(3) NOT NULL Source System
CCR=CCR
EBL=eBill Contact Maintenance
FED=FED
PEN=Pension Customer
10 DIS_HEARING Character(1) VARCHAR2(1) NOT NULL Hearing

Y/N Table Edit

11 DIS_VISION Character(1) VARCHAR2(1) NOT NULL Vision

Y/N Table Edit

12 DIS_MOB_ORTH Character(1) VARCHAR2(1) NOT NULL Mobility/Orthopedic Impairment

Y/N Table Edit

13 DIS_OTHER Character(1) VARCHAR2(1) NOT NULL Other

Y/N Table Edit

14 DIS_NONE Character(1) VARCHAR2(1) NOT NULL None

Y/N Table Edit

15 DIS_DONT_PROVIDE Character(1) VARCHAR2(1) NOT NULL Do Not Wish to Provide

Y/N Table Edit

16 PROF_ELIG_IND Character(1) VARCHAR2(1) NOT NULL Elig Principal Investigator

Y/N Table Edit

Default Value: N

17 ADMIN_ELIG_IND Character(1) VARCHAR2(1) NOT NULL Post Award Administrator

Y/N Table Edit

Default Value: N

18 GM_WF_ELIGIBLE Character(1) VARCHAR2(1) NOT NULL Workflow Eligible

Y/N Table Edit

19 CONFLICT_IND Character(1) VARCHAR2(1) NOT NULL Conflict of Interest

Y/N Table Edit

Default Value: N

20 CONFLICT_CERT_DT Date(10) DATE Confilict of Interest Cert DT
21 HOWARD_HUGHES_IND Character(1) VARCHAR2(1) NOT NULL Howard Hughes Member

Y/N Table Edit

Default Value: N

22 FRINGE_RATE_TYPE Character(3) VARCHAR2(3) NOT NULL Fringe Rate Type
FAC=Faculty
OTH=Other
REG=Regular
TMP=Temporary

Default Value: REG