EMPLIDDefault Value: PER_ORG_ASGN.EMPLID
Prompt Table: PER_ORG_ASGN
EMPL_RCDEFFDTDefault Value: %date
EFFSEQA=Active
I=Inactive
Default Value: A
HRS_JOB_I(SQL View) |
Index Back |
|---|---|
EE Job History Interf ViewEmployee Job History Interface View |
| SELECT A.EMPLID , A.EMPL_RCD , A.EFFDT , A.EFFSEQ , A.HR_STATUS FROM PS_HCR_JOB_I A |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Default Value: PER_ORG_ASGN.EMPLID Prompt Table: PER_ORG_ASGN |
| 2 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
| 3 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 4 | EFFSEQ |
Number(3,0) | SMALLINT NOT NULL | Effective Sequence |
| 5 | HR_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
HR Status
A=Active I=Inactive Default Value: A |