HR_VT_POSLNG_VW(SQL View) |
Index Back |
|---|---|
SP360 Position 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 pos.POSITION_NBR , pos.EFFDT , lang.LANGUAGE_CD , lang.DESCR , pos.DESCR , pos.BUSINESS_UNIT , pos.KEY_POSITION , pos.JOBCODE , pos.COMPANY , pos.DEPTID , pos.LOCATION , pos.STD_HOURS , pos.STD_HRS_FREQUENCY , pos.REG_TEMP , pos.SAL_ADMIN_PLAN , pos.GRADE , pos.STEP , pos.REPORTS_TO , pos.REPORT_DOTTED_LINE FROM PS_POSN_DATA_LANG lang , PS_POSITION_DATA pos WHERE pos.EFF_STATUS = 'A' AND lang.POSITION_NBR = pos.POSITION_NBR AND lang.EFFDT = ( SELECT MAX(l.EFFDT) FROM PS_POSN_DATA_LANG l WHERE lang.POSITION_NBR = l.POSITION_NBR AND lang.LANGUAGE_CD = l.LANGUAGE_CD AND l.EFFDT <= pos.EFFDT) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  POSITION_NBR |
Character(8) | VARCHAR2(8) NOT NULL |
Position Number
Default Value: 00000000 |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | DESCR30 | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 6 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 7 | KEY_POSITION | Character(1) | VARCHAR2(1) NOT NULL |
Key Position
N=No Y=Yes Y/N Table Edit Default Value: N |
| 8 | JOBCODE | Character(6) | VARCHAR2(6) NOT NULL | Job Code |
| 9 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL | Company |
| 10 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL |
Department
Prompt Table: DEPT_TBL |
| 11 | LOCATION | Character(10) | VARCHAR2(10) NOT NULL |
Location Code
Prompt Table: LOCATION_TBL |
| 12 | STD_HOURS | Number(7,2) | DECIMAL(6,2) NOT NULL | Standard Hours |
| 13 | STD_HRS_FREQUENCY | Character(5) | VARCHAR2(5) NOT NULL |
Standard Work Period
Prompt Table: STDHRS_FREQ_VW |
| 14 | REG_TEMP | Character(1) | VARCHAR2(1) NOT NULL |
Regular/Temporary
R=Regular T=Temporary Default Value: JOBCODE_TBL.REG_TEMP |
| 15 | SAL_ADMIN_PLAN | Character(4) | VARCHAR2(4) NOT NULL |
Salary Administration Plan
Prompt Table: %EDITTABLE |
| 16 | GRADE | Character(3) | VARCHAR2(3) NOT NULL |
Salary Grade
Prompt Table: %EDITTABLE2 |
| 17 | STEP | Number(2,0) | SMALLINT NOT NULL |
Step
Prompt Table: %EDITTABLE3 |
| 18 | REPORTS_TO | Character(8) | VARCHAR2(8) NOT NULL |
Reports To Position Number
Prompt Table: POSITION_DATA |
| 19 | REPORT_DOTTED_LINE | Character(8) | VARCHAR2(8) NOT NULL |
Dotted-Line Report
Prompt Table: POSITION_DATA |