HRS_JOB_OPENING_IDOPRIDEFFDTDefault Value: %date
PTAFPRCS_IDPTAFPATH_IDPTAFSTAGE_NBRPTAFSTEP_NBRPTAFTHREAD_IDLANGUAGE_CDHRS_JO_PEND_LNG(SQL View) |
Index Back |
|---|---|
Job Opening Pending ApprovalsJob Opening Pending Approvals |
| SELECT X.HRS_JOB_OPENING_ID , U.OPRID , S.EFFDT , S.PTAFPRCS_ID , S.PTAFPATH_ID , S.PTAFSTAGE_NBR ,S.PTAFSTEP_NBR ,S.PTAFTHREAD_ID , R.LANGUAGE_CD , R.POSTING_TITLE FROM PS_HRS_OPNAPR_XREF X , PS_HRS_STEPINST_I S , PS_HRS_USERINST_I U , PS_HRS_JO_LN_I R WHERE X.PTAFTHREAD_ID = S.PTAFTHREAD_ID AND X.PTAFPRCS_ID = S.PTAFPRCS_ID AND R.HRS_JOB_OPENING_ID = X.HRS_JOB_OPENING_ID AND X.PTAFPARENT_THREAD = ( SELECT MAX(Y.PTAFPARENT_THREAD) FROM PS_HRS_OPNAPR_XREF Y WHERE X.HRS_JOB_OPENING_ID = Y.HRS_JOB_OPENING_ID AND Y.PTAFTHREAD_STATUS <> 'T' ) AND U.PTAFSTEP_STATUS ='P' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | HRS_JOB_OPENING_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Job Opening Clone |
| 2 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 3 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 4 | PTAFPRCS_ID |
Character(30) | VARCHAR2(30) NOT NULL | Approval Process ID |
| 5 | PTAFPATH_ID |
Character(30) | VARCHAR2(30) NOT NULL | Approval Path ID |
| 6 | PTAFSTAGE_NBR |
Number(3,0) | SMALLINT NOT NULL | Stage Number |
| 7 | PTAFSTEP_NBR |
Number(6,2) | DECIMAL(5,2) NOT NULL | Sequence number of step in its path |
| 8 | PTAFTHREAD_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Thread ID |
| 9 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 10 | POSTING_TITLE | Character(200) | VARCHAR2(200) NOT NULL | Job posting title |