HR_VT_JCLNG_VW(SQL View) |
Index Back |
|---|---|
SP360 Job Code Srch Lang ViewNote: This is not a true related language record because it contains additional fields not leveraged by PeopleSoft related language technology. This record is used in PeopleCode as a union to get related language records for SP360 searches. |
| SELECT J.SETID , J.JOBCODE , L.LANGUAGE_CD , J.EFFDT , L.DESCR , J.DESCR , J.KEY_JOBCODE , J.GVT_OCC_SERIES , J.GVT_OFFICIAL_DESCR , J.JOB_FAMILY , J.SAL_ADMIN_PLAN , J.GRADE , J.STEP , J.JOB_FUNCTION , J.STD_HOURS , J.STD_HRS_FREQUENCY , J.REG_TEMP FROM PS_JOBCODE_TBL J , PS_JOBCODE_LANG L WHERE J.EFF_STATUS = 'A' AND J.SETID = L.SETID AND J.JOBCODE = L.JOBCODE AND L.EFFDT = ( SELECT MAX(L1.EFFDT) FROM PS_JOBCODE_LANG L1 WHERE L1.SETID = L.SETID AND L1.JOBCODE = L.JOBCODE AND L1.LANGUAGE_CD = L.LANGUAGE_CD AND L1.EFFDT <= J.EFFDT) |
| # | 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 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 4 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 6 | DESCR30 | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 7 | KEY_JOBCODE | Character(1) | VARCHAR2(1) NOT NULL |
Key Job Code
N=No Y=Yes |
| 8 | GVT_OCC_SERIES | Character(4) | VARCHAR2(4) NOT NULL | Occupational Series |
| 9 | GVT_OFFICIAL_DESCR | Character(70) | VARCHAR2(70) NOT NULL | Official Position Title |
| 10 | JOB_FAMILY | Character(6) | VARCHAR2(6) NOT NULL | Job Family |
| 11 | SAL_ADMIN_PLAN | Character(4) | VARCHAR2(4) NOT NULL |
Salary Administration Plan
Prompt Table: %SAL_PLN_PRMPT2 |
| 12 | GRADE | Character(3) | VARCHAR2(3) NOT NULL |
Salary Grade
Prompt Table: %SAL_GRD_PRMPT2 |
| 13 | STEP | Number(2,0) | SMALLINT NOT NULL |
Step
Prompt Table: %SAL_STP_PRMPT2 |
| 14 | JOB_FUNCTION | Character(3) | VARCHAR2(3) NOT NULL |
Job Function Code
Prompt Table: JOBFUNCTION_TBL |
| 15 | STD_HOURS | Number(7,2) | DECIMAL(6,2) NOT NULL |
Standard Hours
Default Value: OPR_DEF_TBL_HR.STD_HRS_DEFAULT |
| 16 | STD_HRS_FREQUENCY | Character(5) | VARCHAR2(5) NOT NULL |
Standard Work Period
Default Value: OPR_DEF_TBL_HR.STD_HRS_FREQUENCY Prompt Table: STDHRS_FREQ_VW |
| 17 | REG_TEMP | Character(1) | VARCHAR2(1) NOT NULL |
Regular/Temporary
R=Regular T=Temporary |