HR_VT_JC_VW(SQL View) |
Index Back |
|---|---|
SP360 Job Code Search View |
| SELECT JC.SETID , JC.JOBCODE , JC.EFFDT , JC.DESCR , JC.KEY_JOBCODE , JC.GVT_OCC_SERIES , JC.GVT_OFFICIAL_DESCR , JC.JOB_FAMILY , JC.SAL_ADMIN_PLAN , JC.GRADE , JC.STEP , JC.JOB_FUNCTION , JC.STD_HOURS , JC.STD_HRS_FREQUENCY , JC.REG_TEMP FROM PS_JOBCODE_TBL JC WHERE JC.EFF_STATUS = 'A' |
| # | 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 NOT NULL |
Effective Date
Default Value: %date |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | KEY_JOBCODE | Character(1) | VARCHAR2(1) NOT NULL |
Key Job Code
N=No Y=Yes |
| 6 | GVT_OCC_SERIES | Character(4) | VARCHAR2(4) NOT NULL | Occupational Series |
| 7 | GVT_OFFICIAL_DESCR | Character(70) | VARCHAR2(70) NOT NULL | Official Position Title |
| 8 | JOB_FAMILY | Character(6) | VARCHAR2(6) NOT NULL | Job Family |
| 9 | SAL_ADMIN_PLAN | Character(4) | VARCHAR2(4) NOT NULL |
Salary Administration Plan
Prompt Table: %SAL_PLN_PRMPT2 |
| 10 | GRADE | Character(3) | VARCHAR2(3) NOT NULL |
Salary Grade
Prompt Table: %SAL_GRD_PRMPT2 |
| 11 | STEP | Number(2,0) | SMALLINT NOT NULL |
Step
Prompt Table: %SAL_STP_PRMPT2 |
| 12 | JOB_FUNCTION | Character(3) | VARCHAR2(3) NOT NULL |
Job Function Code
Prompt Table: JOBFUNCTION_TBL |
| 13 | STD_HOURS | Number(7,2) | DECIMAL(6,2) NOT NULL |
Standard Hours
Default Value: OPR_DEF_TBL_HR.STD_HRS_DEFAULT |
| 14 | 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 |
| 15 | REG_TEMP | Character(1) | VARCHAR2(1) NOT NULL |
Regular/Temporary
R=Regular T=Temporary |