HRS_APP_INACT_I(SQL View) |
Index Back |
---|---|
Inactive ApplicantsDetermines inactive applicants which are then candidates for archival or deletion. |
SELECT AP.HRS_PERSON_ID FROM %Table(HRS_APPLICANT_I) AP , %Table(HRS_AGNT_PROF ) AG , %Table(HRS_INST) I WHERE AP.HRS_PERSON_ID = AG.HRS_PERSON_ID AND %DateAdd(AG.LAST_UPDATE_DATE, I.ER_PRF_ACTV_DAYS) <= %CurrentDateIn AND NOT EXISTS ( SELECT 'X' FROM %Table(HRS_APP_PRFVR_I) PV WHERE PV.HRS_PERSON_ID = AP.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 |