EMPLIDDefault Value: NEW
Default Value: %datetime
HR_SRCH_NIDDTTM(SQL View) |
Index Back |
|---|---|
SES: LASTUPDDTTM from NIDSES: LASTUPDDTTM from NID |
| SELECT EMPLID ,MAX(LASTUPDDTTM) FROM PS_HR_SRCH_PERSNID GROUP BY EMPLID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Default Value: NEW |
| 2 | LASTUPDDTTM | DateTime(26) | TIMESTAMP NOT NULL |
Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
Default Value: %datetime |