EFFDTDefault Value: %date
C=Contingent Workforce
E=External Posting
I=Internal Posting
L=Labor Office
R=Recruitment
HRS_BIP_JPST_VW(SQL View) |
Index Back |
|---|---|
Used in XMLP report for Job OXMLP report Print Job Opening Job Postings |
| SELECT A.HRS_JOB_OPENING_ID , A.HRS_JO_PST_SEQ , A.HRS_SEQ_NUM , B.EFFDT , HRS_JO_PST_TYPE , ' ' , A.HRS_SOURCE_ID , B.HRS_SOURCE_DESCR , A.HRS_JO_PST_OPN_DT , ' ' , A.HRS_JO_PST_CLS_DT , ' ' FROM PS_HRS_JO_PST_DST A LEFT OUTER JOIN PS_HRS_SRC_PST_I1 B ON(A.HRS_SOURCE_ID = B.HRS_SOURCE_ID) |
| # | 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 | HRS_JO_PST_SEQ | Number(3,0) | SMALLINT NOT NULL | Job opening posting sequence |
| 3 | HRS_SEQ_NUM | Number(3,0) | SMALLINT NOT NULL | Sequence Number |
| 4 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 5 | HRS_JO_PST_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Job Opening Posting Type
C=Contingent Workforce E=External Posting I=Internal Posting L=Labor Office R=Recruitment |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 7 | HRS_SOURCE_ID | Number(15,0) | DECIMAL(15) NOT NULL | Source ID |
| 8 | HRS_SOURCE_DESCR | Character(254) | VARCHAR2(254) NOT NULL | Description of the Source |
| 9 | HRS_JO_PST_OPN_DT | Date(10) | DATE | Job opening posting open date |
| 10 | HRS_PSTDT_STR | Character(15) | VARCHAR2(15) NOT NULL | Used in XMLP report for Job Opening |
| 11 | HRS_JO_PST_CLS_DT | Date(10) | DATE | Job opening post close date |
| 12 | HRS_RMVDT_STR | Character(15) | VARCHAR2(15) NOT NULL | Used in XMLP report for Job Opening |