EMPLIDA=Add
C=Change
D=Delete
SAE_PERSON_EXT(SQL Table) |
Index Back |
|---|---|
SAIP Person extension recordrecord will be used to track the changes (create, update and deletes) to the person information |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | SAE_MODE | Character(1) | VARCHAR2(1) NOT NULL |
Operation Mode
A=Add C=Change D=Delete |
| 3 | SAE_EVENT_DT | DateTime(26) | TIMESTAMP | Event Driven Timestamp |
| 4 | SAE_PREF_EVENT_DT | DateTime(26) | TIMESTAMP | Event Driven Timestamp |