HRS_JOB_OPENING_IDHRS_JO_PST_SEQHRS_JO_PST_TYPEC=Contingent Workforce
E=External Posting
I=Internal Posting
L=Labor Office
R=Recruitment
HRS_JO_RQMT_SEQHRS_JOBCTENT_VW(SQL View) |
Index Back |
|---|---|
Job Opening ContentsGet searchable Job Opening content items. Used to build Job Content search index. |
| SELECT A.HRS_JOB_OPENING_ID , A.HRS_JO_PST_SEQ , A.HRS_JO_PST_TYPE , B.HRS_JO_RQMT_SEQ , B.JPM_CAT_TYPE , B.JPM_CAT_ITEM_ID , B.PROPERTYNAME , B.HRS_JOB_REQMT FROM PS_HRS_JO_PST_DST A , PS_HRS_STG_JOBCTNT B WHERE A.HRS_JOB_OPENING_ID = B.HRS_JOB_OPENING_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_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 |
| 4 | HRS_JO_RQMT_SEQ |
Number(3,0) | SMALLINT NOT NULL | Job opening requirement sequence |
| 5 | JPM_CAT_TYPE | Character(12) | VARCHAR2(12) NOT NULL | The name of the type of items that will be used in a Catalog and or in a Profile. |
| 6 | JPM_CAT_ITEM_ID | Character(12) | VARCHAR2(12) NOT NULL | Catalog Item Id. Identifies a unique catalog item defintion within a catalog type. |
| 7 | PROPERTYNAME | Character(30) | VARCHAR2(30) NOT NULL | Property Name |
| 8 | HRS_JOB_REQMT | Character(30) | VARCHAR2(30) NOT NULL | Job requirement |