SDK_PERS_DATA

index back

SDK Personal Data

SDK Personal Data

  • Parent record of SDK_BUS_EXP_PER
  • PeopleSoft Field Name Field Type Column Type Description
    SDK_EMPLID Character(11) VARCHAR2(11) NOT NULL SDK Employee ID

    Default: NEW

    SDK_NAME Character(50) VARCHAR2(50) NOT NULL SDK Name
    SDK_LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL SDK Last Name Search
    SDK_FIRST_NAME_SRC Character(30) VARCHAR2(30) NOT NULL SDK First Name Search
    SDK_PER_STATUS Character(1) VARCHAR2(1) NOT NULL SDK Personnel Status
    A=Applicant
    E=Employee
    N=Non Employee
    SDK_ORIG_HIRE_DT Date(10) DATE SDK Original Hire Date
    SDK_SEX Character(1) VARCHAR2(1) NOT NULL SDK Sex
    F=Female
    M=Male
    U=Unknown
    SDK_BIRTHDATE Date(10) DATE SDK Birthday
    SDK_BAS_DATA_CHG Character(1) VARCHAR2(1) NOT NULL SDK Basic Data Change

    Y/N Table Edit

    Default: N

    SDK_PER_TYPE Character(1) VARCHAR2(1) NOT NULL SDK Person Type
    A=Applicant
    C=Cobra Participant
    L=Time & Labor Contractor
    P=Pension Payee
    SDK_NATIONAL_ID Character(15) VARCHAR2(15) NOT NULL SDK National ID
    SDK_SSN Character(9) VARCHAR2(9) NOT NULL SDK Social Security Number
    SDK_SIN_GER Character(12) VARCHAR2(12) NOT NULL SDK Social Insurance Number (Germany)
    SDK_SIN Character(9) VARCHAR2(9) NOT NULL SDK Social Insurance Number
    SDK_SSN_FRA Character(13) VARCHAR2(13) NOT NULL SDK Social Security Number (France)
    SDK_NAT_INS_CD Character(9) VARCHAR2(9) NOT NULL SDK National Insurance Number
    SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
    SDK_SYNCTIMESTAMP DateTime(26) TIMESTAMP SDK Synchronization Timestamp
    index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
    PTRef generated on 09-JUN-19