SETIDJOBCODEEFFDTDefault Value: %date
A=Active
I=Inactive
N=Not Applicable
P=Primary Job
S=Secondary Job
TRW_JOB_VW(SQL View) |
Index Back |
|---|---|
Employee Job TitleGets employee job title from the Job Code table. |
| SELECT JC.SETID , JC.JOBCODE , JC.EFFDT , JC.EFF_STATUS , JC.DESCR , JB.EMPLID , JB.EMPL_RCD , JB.EFFDT , JB.EFFSEQ , JB.JOB_INDICATOR , JB.SETID_JOBCODE FROM PS_JOBCODE_TBL JC , PS_JOB JB WHERE JC.JOBCODE = JB.JOBCODE AND JC.SETID = JB.SETID_JOBCODE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | JOBCODE |
Character(6) | VARCHAR2(6) NOT NULL | Job Code |
| 3 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 4 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 6 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 7 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 8 | JOB_EFFDT | Date(10) | DATE | Job Effective Date |
| 9 | EFFSEQ | Number(3,0) | SMALLINT NOT NULL | Effective Sequence |
| 10 | JOB_INDICATOR | Character(1) | VARCHAR2(1) NOT NULL |
This Indicator is used on JOB to specify which employment record is considered to be the primary one for an employee.
In case of Multiple Jobs per Employee, this property is being used to make a conscious decision in related features where only 1 Employment Record per Employee needs to be returned.
N=Not Applicable P=Primary Job S=Secondary Job |
| 11 | SETID_JOBCODE | Character(5) | VARCHAR2(5) NOT NULL | Job Code Set ID |