HRS_CE_JOPRF_I(SQL View) |
Index Back |
|---|---|
Emp SS Job OpeningsJob openings that match Employee's selected Person, Job, or Interest List profiles Interface table |
| SELECT ' ' , ' ' , 0 , 0 , ' ' , 0 , ' ' , ' ' , ' ' , %DateNull , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' FROM PS_HRSINSTALLATION |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | HRS_MY_PROF_TYP | Character(1) | VARCHAR2(1) NOT NULL |
Source Profile Type
I=Interest Profile J=Job Profile P=Person Profile |
| 2 | JPM_PROFILE_ID | Character(12) | VARCHAR2(12) NOT NULL | The id, autoassigned or user assigned of the profile. This id is used to group items and other related material together into one coherent profile. |
| 3 | HRS_JOB_OPENING_ID | Number(15,0) | DECIMAL(15) NOT NULL | Job Opening Clone |
| 4 | HRS_JO_PST_SEQ | Number(3,0) | SMALLINT NOT NULL |
Job opening posting sequence
Prompt Table: HRS_JO_PST_I |
| 5 | POSTING_TITLE | Character(200) | VARCHAR2(200) NOT NULL | Job posting title |
| 6 | SRCH_SCORE | Number(4,0) | SMALLINT NOT NULL | Search Score |
| 7 | 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 |
| 8 | LOCATION_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Location Description |
| 9 | HRS_JOB_FAMILY | Character(30) | VARCHAR2(30) NOT NULL | Job family description |
| 10 | OPEN_DT | Date(10) | DATE | Created |
| 11 | HRS_SCH_IMAGE1 | Image Reference(30) | VARCHAR2(30) | Hot Job |
| 12 | HRS_SAVE_JOB_BTN | Character(1) | VARCHAR2(1) NOT NULL | Save Job button |
| 13 | HRS_APPLY_PB | Character(1) | VARCHAR2(1) NOT NULL | Apply |
| 14 | JOB_FAMILY | Character(6) | VARCHAR2(6) NOT NULL | Job Family |
| 15 | HRS_JOB_FUNC_DESCR | Character(30) | VARCHAR2(30) NOT NULL | job function discription |
| 16 | HRS_BU_DESCR | Character(30) | VARCHAR2(30) NOT NULL | candidate gateway business unit description |