HRS_RCM_EODI_VW(SQL View) |
Index Back |
|---|---|
External Scheduler Status View |
| SELECT A.HRS_PERSON_ID , A.HRS_RCMNT_ID , A.HRS_RCM_INT_ID , C.EODI_APT_STATUS FROM PS_HRS_RCM_INT A , PS_HRS_RCMNT B , PS_EODI_APT_GROUP C WHERE A.HRS_PERSON_ID = B.HRS_PERSON_ID AND A.HRS_RCMNT_ID = B.HRS_RCMNT_ID AND A.EODI_APT_GROUP = C.EODI_APT_GROUP AND B.EODI_TRANS_ID = C.EODI_APT_TRANS_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  HRS_PERSON_ID |
Number(15,0) | DECIMAL(15) NOT NULL |
Person Id
Prompt Table: HRS_APPLICANT_I |
| 2 | HRS_RCMNT_ID |
Number(15,0) | DECIMAL(15) NOT NULL |
App Tracking Recruitment ID
Default Value: 999999999999999 Prompt Table: HRS_RCMNT |
| 3 | HRS_RCM_INT_ID |
Number(15,0) | DECIMAL(15) NOT NULL |
Recruitment Interview ID
Default Value: 999999999999999 |
| 4 | EODI_APT_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Apt Status
A=Awaiting Responses C=Canceled H=On Hold - Do Not Schedule I=Initial - Not Visible Q=Queued For Scheduling S=Scheduled X=Queued For Canceling |