HRS_PERSON_IDHRS_PROFILE_SEQHRS_ACK_TYPEAPPL=Job Application
REG=Candidate Registration
DTTM_STAMPDefault Value: %datetime
HRS_APP_AC_M_VW(SQL View) |
Index Back |
|---|---|
Job Application AcknowledgmentJob Application Acknowledgement |
| SELECT PROF.HRS_PERSON_ID , PROF.HRS_PROFILE_SEQ , 'APPL' , ( SELECT MAX(ACK.DTTM_STAMP) FROM PS_HRS_APPL_ACK ACK WHERE PROF.HRS_PERSON_ID = ACK.HRS_PERSON_ID AND PROF.HRS_PROFILE_SEQ = ACK.HRS_PROFILE_SEQ ), RCMN.HRS_JOB_OPENING_ID, RCMN.STATUS_CODE FROM PS_HRS_APP_PROFILE PROF,PS_HRS_RCMNT RCMN WHERE PROF.HRS_PERSON_ID = RCMN.HRS_PERSON_ID AND PROF.HRS_PROFILE_SEQ = RCMN.HRS_PROFILE_SEQ AND EXISTS ( SELECT 'X' FROM PS_HRS_APPL_ACK APP_ACK WHERE PROF.HRS_PERSON_ID = APP_ACK.HRS_PERSON_ID AND PROF.HRS_PROFILE_SEQ = APP_ACK.HRS_PROFILE_SEQ ) AND EXISTS ( SELECT 'X' FROM PS_HRS_RCMNT RCMNT WHERE PROF.HRS_PERSON_ID = RCMNT.HRS_PERSON_ID AND PROF.HRS_PROFILE_SEQ = RCMNT.HRS_PROFILE_SEQ AND RCMNT.HRS_LOGICAL_DELETE = 'N') |
| # | 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 |
| 5 | HRS_JOB_OPENING_ID | Number(15,0) | DECIMAL(15) NOT NULL | Job Opening Clone |
| 6 | STATUS_CODE | Character(3) | VARCHAR2(3) NOT NULL | Identifies a status. |