PERS_DATA_EFFDT

(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

    Default Value: NEW

    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    3 UPDATE_PERS_DATA Character(1) VARCHAR2(1) NOT NULL Update Personal Data

    Y/N Table Edit

    Default Value: N

    4 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Prompt Table: COUNTRY_TBL

    5 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
    6 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
    7 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
    8 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
    9 CITY Character(30) VARCHAR2(30) NOT NULL City
    10 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1
    11 NUM2 Character(6) VARCHAR2(6) NOT NULL Number 2
    12 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
    AB=House Boat
    WW=Trailer
    13 ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1
    14 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2
    15 ADDR_FIELD3 Character(4) VARCHAR2(4) NOT NULL Address Field 3
    16 COUNTY Character(30) VARCHAR2(30) NOT NULL County
    17 STATE Character(6) VARCHAR2(6) NOT NULL State

    Prompt Table: %EDIT_STATE

    18 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
    19 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code
    20 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit

    Y/N Table Edit

    21 COUNTRY_OTHER Character(3) VARCHAR2(3) NOT NULL Country field for ADDR_OTR_SBR and DERIVED_ADDR_OT

    Prompt Table: COUNTRY_TBL

    22 ADDRESS1_OTHER Character(55) VARCHAR2(55) NOT NULL Address 1 Other
    23 ADDRESS2_OTHER Character(55) VARCHAR2(55) NOT NULL Address 2 Other
    24 ADDRESS3_OTHER Character(55) VARCHAR2(55) NOT NULL Address 3 Other
    25 ADDRESS4_OTHER Character(55) VARCHAR2(55) NOT NULL Address 4 Other
    26 CITY_OTHER Character(30) VARCHAR2(30) NOT NULL City Other
    27 COUNTY_OTHER Character(30) VARCHAR2(30) NOT NULL County Other
    28 STATE_OTHER Character(6) VARCHAR2(6) NOT NULL State Other

    Prompt Table: %EDIT_STATE_OTH

    29 POSTAL_OTHER Character(12) VARCHAR2(12) NOT NULL Postal Other
    30 NUM1_OTHER Character(6) VARCHAR2(6) NOT NULL Number 1 Other
    31 NUM2_OTHER Character(6) VARCHAR2(6) NOT NULL Number 2 Other
    32 HOUSE_TYPE_OTHER Character(2) VARCHAR2(2) NOT NULL House Type Other
    AB=House Boat Reference
    WW=House Trailer Reference
    33 ADDR_FIELD1_OTHER Character(2) VARCHAR2(2) NOT NULL Address Field 1 Other
    34 ADDR_FIELD2_OTHER Character(4) VARCHAR2(4) NOT NULL Address Field 2 Other
    35 ADDR_FIELD3_OTHER Character(4) VARCHAR2(4) NOT NULL Address Field 3 Other
    36 IN_CITY_LMT_OTHER Character(1) VARCHAR2(1) NOT NULL In City Limit Other
    37 GEO_CODE_OTHER Character(11) VARCHAR2(11) NOT NULL Geo Code Other
    38 MAR_STATUS Character(1) VARCHAR2(1) NOT NULL Marital Status
    C=Common-Law
    D=Divorced
    E=Separated
    H=Head of Household
    M=Married
    S=Single
    U=Unknown
    W=Widowed

    Default Value: S

    39 SMOKER Character(1) VARCHAR2(1) NOT NULL Smoker

    Default Value: N

    40 COUNTRY_NM_FORMAT Character(3) VARCHAR2(3) NOT NULL Format for Country

    Prompt Table: COUNTRY_TBL

    41 NAME Character(50) VARCHAR2(50) NOT NULL Name
    42 NAME_INITIALS Character(6) VARCHAR2(6) NOT NULL Name Initials
    43 NAME_PREFIX Character(4) VARCHAR2(4) NOT NULL Name Prefix
    1=Mr.
    2=Mrs.
    3=Ms.

    Prompt Table: NAME_PREFIX_TBL

    44 NAME_SUFFIX Character(15) VARCHAR2(15) NOT NULL Name Suffix

    Prompt Table: NAME_SUFFIX_TBL

    45 NAME_ROYAL_PREFIX Character(15) VARCHAR2(15) NOT NULL Name Royal Prefix
    46 NAME_ROYAL_SUFFIX Character(15) VARCHAR2(15) NOT NULL Name Royal Suffix
    47 NAME_TITLE Character(30) VARCHAR2(30) NOT NULL Title
    48 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name
    49 FIRST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL First Name
    50 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
    51 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
    52 MIDDLE_NAME Character(30) VARCHAR2(30) NOT NULL Middle Name
    53 SECOND_LAST_NAME Character(30) VARCHAR2(30) NOT NULL Second Last Name
    54 SECOND_LAST_SRCH Character(30) VARCHAR2(30) NOT NULL Second Name
    55 NAME_AC Character(50) VARCHAR2(50) NOT NULL Alternate Character Name
    56 PREF_FIRST_NAME Character(30) VARCHAR2(30) NOT NULL Preferred First Name
    57 ADDRESS1_AC Character(55) VARCHAR2(55) NOT NULL Alternate Character Address 1
    58 ADDRESS2_AC Character(55) VARCHAR2(55) NOT NULL Alternate Character Address 2
    59 ADDRESS3_AC Character(55) VARCHAR2(55) NOT NULL Alternate Character Address 3
    60 CITY_AC Character(30) VARCHAR2(30) NOT NULL Alternate Character City
    61 NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Display Name
    62 NAME_FORMAL Character(60) VARCHAR2(60) NOT NULL Name Formal
    63 PRONOUN Character(2) VARCHAR2(2) NOT NULL Pronoun
    64 PREF_MIDDLE_NAME Character(30) VARCHAR2(30) NOT NULL Preferred Middle Name
    65 PREF_LAST_NAME Character(30) VARCHAR2(30) NOT NULL Preferred Last Name
    66 KNOWN_FIRST_NAME Character(30) VARCHAR2(30) NOT NULL Known First Name
    67 KNOWN_MIDDLE_NAME Character(30) VARCHAR2(30) NOT NULL Known Middle Name
    68 KNOWN_LAST_NAME Character(30) VARCHAR2(30) NOT NULL Known Last Name
    69 KNOWN_NAME Character(50) VARCHAR2(50) NOT NULL Known Name
    70 NAME_DISPLAY_SRCH Character(50) VARCHAR2(50) NOT NULL Uppercase version of Name to improve performance on searches.
    71 NAME_FORMAL_SRCH Character(60) VARCHAR2(60) NOT NULL Uppercase version of formal name to improve performance on searches.
    72 MIDDLE_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Middle Name uppercase search field.
    73 PREF_FIRST_NM_SRCH Character(30) VARCHAR2(30) NOT NULL Preferred First Name Search.
    74 PREF_MIDL_NM_SRCH Character(30) VARCHAR2(30) NOT NULL Uppercase version of preferred middle name to improve performance on searches.
    75 PREF_LAST_NM_SRCH Character(30) VARCHAR2(30) NOT NULL Uppercase version of preferred last name to improve performance on searches.
    76 PREF_NAME_PREFIX Character(4) VARCHAR2(4) NOT NULL Preferred Name Prefix
    77 PREF_NAME_SUFFIX Character(15) VARCHAR2(15) NOT NULL Preferred Name Suffix
    78 PREF_NAME_TITLE Character(30) VARCHAR2(30) NOT NULL Preferred Name Title
    79 PREF_SEC_LAST_NAME Character(30) VARCHAR2(30) NOT NULL Preferred Second Last Name
    80 PREF_LAST_SEC_SRCH Character(30) VARCHAR2(30) NOT NULL Uppercase version of preferred second last name to improve performance on searches.
    81 PARTNER_LAST_NAME Character(30) VARCHAR2(30) NOT NULL The Partner Last Name is being used by the Netherlands for the employee name formatting, where a person can choose to use the partners last name as their prefered last name.
    82 PARTN_LAST_NM_SRCH Character(30) VARCHAR2(30) NOT NULL Uppercase version of partner last name to improve performance on searches.
    83 PARTNER_ROY_PREFIX Character(15) VARCHAR2(15) NOT NULL The Partner Royal Prefix is being used by the Netherlands for the employee name formatting, where a person can choose to use the partners last name and prefix as their prefered last name.