GM_PERS_DATA

(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.

  • Parent record: PERSONAL_DATA

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    3 AMERICAN_INDIAN Character(1) VARCHAR2(1) NOT NULL American Indian/Alaska Native

    Y/N Table Edit

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

    Y/N Table Edit

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

    Y/N Table Edit

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

    Y/N Table Edit

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

    Y/N Table Edit

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

    Y/N Table Edit

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

    Y/N Table Edit

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

    Y/N Table Edit

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

    Y/N Table Edit

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

    Y/N Table Edit

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

    Y/N Table Edit

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

    Y/N Table Edit

    17 PRE_AWARD_ADMIN Character(1) VARCHAR2(1) NOT NULL Pre Award Administrator

    Y/N Table Edit

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

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

    Default Value: REG