SDK_PERS_DATA

index back

SDK Personal Data

SDK Personal Data

  • Parent record of SDK_BUS_EXP_PER
  • PeopleSoft Field NameField TypeColumn TypeDescription
    SDK_EMPLIDCharacter(11)VARCHAR2(11) NOT NULLSDK Employee ID

    Default: NEW

    SDK_NAMECharacter(50)VARCHAR2(50) NOT NULLSDK Name
    SDK_LAST_NAME_SRCHCharacter(30)VARCHAR2(30) NOT NULLSDK Last Name Search
    SDK_FIRST_NAME_SRCCharacter(30)VARCHAR2(30) NOT NULLSDK First Name Search
    SDK_PER_STATUSCharacter(1)VARCHAR2(1) NOT NULLSDK Personnel Status
    A=Applicant
    E=Employee
    N=Non Employee
    SDK_ORIG_HIRE_DTDate(10)DATESDK Original Hire Date
    SDK_SEXCharacter(1)VARCHAR2(1) NOT NULLSDK Sex
    F=Female
    M=Male
    U=Unknown
    SDK_BIRTHDATEDate(10)DATESDK Birthday
    SDK_BAS_DATA_CHGCharacter(1)VARCHAR2(1) NOT NULLSDK Basic Data Change

    Y/N Table Edit

    Default: N

    SDK_PER_TYPECharacter(1)VARCHAR2(1) NOT NULLSDK Person Type
    A=Applicant
    C=Cobra Participant
    L=Time & Labor Contractor
    P=Pension Payee
    SDK_NATIONAL_IDCharacter(15)VARCHAR2(15) NOT NULLSDK National ID
    SDK_SSNCharacter(9)VARCHAR2(9) NOT NULLSDK Social Security Number
    SDK_SIN_GERCharacter(12)VARCHAR2(12) NOT NULLSDK Social Insurance Number (Germany)
    SDK_SINCharacter(9)VARCHAR2(9) NOT NULLSDK Social Insurance Number
    SDK_SSN_FRACharacter(13)VARCHAR2(13) NOT NULLSDK Social Security Number (France)
    SDK_NAT_INS_CDCharacter(9)VARCHAR2(9) NOT NULLSDK National Insurance Number
    SYNCIDNumber(10,0)DECIMAL(10) NOT NULLThe 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_SYNCTIMESTAMPDateTime(26)TIMESTAMPSDK Synchronization Timestamp
    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19