HRS_PERSON_IDHRS_PROFILE_SEQAPPL=Job Application
REG=Candidate Registration
DTTM_STAMPDefault Value: %datetime
HRS_REG_ACK_VW(SQL View) |
Index Back |
|---|---|
Registration AcknowledgementCandidate Registration Acknowledgement |
| select HRS_PERSON_ID , 0 , 'REG' , MAX(DTTM_STAMP) from PS_HRS_APP_REG_ACK group by HRS_PERSON_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | HRS_PERSON_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Person Id |
| 2 | HRS_PROFILE_SEQ |
Number(3,0) | SMALLINT NOT NULL | Profile sequece |
| 3 | HRS_ACK_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Acknowledgement
APPL=Job Application REG=Candidate Registration |
| 4 | DTTM_STAMP |
DateTime(26) | TIMESTAMP |
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 |