SDK_EMPLIDDefault Value: NEW
A=Applicant
E=Employee
N=Non Employee
F=Female
M=Male
U=Unknown
Y/N Table Edit
Default Value: N
A=Applicant
C=Cobra Participant
L=Time & Labor Contractor
P=Pension Payee
SDK_PERS_DATA(SQL Table) |
Index Back |
|---|---|
SDK Personal DataSDK Personal Data |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SDK_EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
SDK Employee ID
Default Value: NEW |
| 2 | SDK_NAME | Character(50) | VARCHAR2(50) NOT NULL | SDK Name |
| 3 | SDK_LAST_NAME_SRCH | Character(30) | VARCHAR2(30) NOT NULL | SDK Last Name Search |
| 4 | SDK_FIRST_NAME_SRC | Character(30) | VARCHAR2(30) NOT NULL | SDK First Name Search |
| 5 | SDK_PER_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
SDK Personnel Status
A=Applicant E=Employee N=Non Employee |
| 6 | SDK_ORIG_HIRE_DT | Date(10) | DATE | SDK Original Hire Date |
| 7 | SDK_SEX | Character(1) | VARCHAR2(1) NOT NULL |
SDK Sex
F=Female M=Male U=Unknown |
| 8 | SDK_BIRTHDATE | Date(10) | DATE | SDK Birthday |
| 9 | SDK_BAS_DATA_CHG | Character(1) | VARCHAR2(1) NOT NULL |
SDK Basic Data Change
Y/N Table Edit Default Value: N |
| 10 | SDK_PER_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
SDK Person Type
A=Applicant C=Cobra Participant L=Time & Labor Contractor P=Pension Payee |
| 11 | SDK_NATIONAL_ID | Character(15) | VARCHAR2(15) NOT NULL | SDK National ID |
| 12 | SDK_SSN | Character(9) | VARCHAR2(9) NOT NULL | SDK Social Security Number |
| 13 | SDK_SIN_GER | Character(12) | VARCHAR2(12) NOT NULL | SDK Social Insurance Number (Germany) |
| 14 | SDK_SIN | Character(9) | VARCHAR2(9) NOT NULL | SDK Social Insurance Number |
| 15 | SDK_SSN_FRA | Character(13) | VARCHAR2(13) NOT NULL | SDK Social Security Number (France) |
| 16 | SDK_NAT_INS_CD | Character(9) | VARCHAR2(9) NOT NULL | SDK National Insurance Number |
| 17 | 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. |
| 18 | SDK_SYNCTIMESTAMP | DateTime(26) | TIMESTAMP | SDK Synchronization Timestamp |