HRS_JOB_OPENING_IDASOF_DATEEFFSEQA=Active
I=Inactive
A=Award Category
E=Employee Eligibility
H=Hot Job
HRS_HJ_HISTD_VW(SQL View) |
Index Back |
|---|---|
Hot Job HistoryHot Job History |
| SELECT HRS_JOB_OPENING_ID , EFFDT , EFFSEQ , EFF_STATUS , RULE_TYPE_ER , RULE_ID_ER FROM PS_HRS_JO_HJ_HIST |
| # | 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 | ASOF_DATE |
Date(10) | DATE | This field is used all over campus solutions to hold the value of an as of date to be used in different processing. |
| 3 | EFFSEQ |
Number(3,0) | SMALLINT NOT NULL | Effective Sequence |
| 4 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |
| 5 | RULE_TYPE_ER | Character(1) | VARCHAR2(1) NOT NULL |
ERP Rule Type
A=Award Category E=Employee Eligibility H=Hot Job |
| 6 | RULE_ID_ER | Character(12) | VARCHAR2(12) NOT NULL | Rule ID |