HR_PG_POSDT_LVW(SQL View) |
Index Back |
---|---|
Related Lang-Position DataPOSN_DATA_LANG is the language record related to POSITION_DATA. A related language record enables text fields on a table to be translated into various languages for use in other countries. |
SELECT A.POSITION_NBR ,B.LANGUAGE_CD ,B.EFFDT ,B.DESCR ,B.DESCRSHORT ,( SELECT DISTINCT(ACTRSN.DESCR) FROM PS_ACTN_RSN_LANG ACTRSN WHERE Actrsn.Action=A.Action AND ACTRSN.ACTION_REASON = A.ACTION_REASON AND ACTRSN.EFFDT = ( SELECT MAX(EFFDT) FROM PS_ACTN_RSN_LANG ACTRSN1 WHERE ACTRSN.ACTION = ACTRSN1.ACTION AND ACTRSN.ACTION_REASON = ACTRSN1.ACTION_REASON AND ACTRSN1.EFFDT <= %CurrentDateIn)) ACTION_REASN_DESCR ,( SELECT DISTINCT(COMP.DESCR) FROM PS_COMPNY_TBL_LANG COMP WHERE COMP.COMPANY=A.COMPANY AND COMP.EFFDT = ( SELECT MAX(EFFDT) FROM PS_COMPNY_TBL_LANG COMP1 WHERE COMP.COMPANY = COMP1.COMPANY AND COMP1.EFFDT <= %CurrentDateIn)) COMPANY_DESCR ,( SELECT DISTINCT(DEPT.DESCR) FROM PS_DEPT_TBL_LANG DEPT WHERE DEPT.DEPTID=A.DEPTID AND DEPT.SETID = ( SELECT SETID FROM PS_SET_CNTRL_TBL WHERE SETCNTRLVALUE = A.BUSINESS_UNIT) AND DEPT.EFFDT = ( SELECT MAX(EFFDT) FROM PS_DEPT_TBL_LANG DEPT1 WHERE DEPT.DEPTID = DEPT1.DEPTID AND DEPT1.EFFDT <= %CurrentDateIn)) DEPT_DESCR ,( SELECT UT.DESCR FROM PS_UNION_TBL_LANG UT WHERE UT.UNION_CD = A.UNION_CD AND UT.EFFDT = ( SELECT MAX(EFFDT) FROM PS_UNION_TBL_LANG UT1 WHERE UT.UNION_CD = UT1.UNION_CD AND UT.EFFDT <= %CurrentDateIn) ) UNION_CODE_DESCR ,( SELECT DISTINCT(LOC.DESCR) FROM PS_LOCATION_LANG LOC WHERE LOC.LOCATION=A.LOCATION AND LOC.SETID = ( SELECT SETID FROM PS_SET_CNTRL_TBL WHERE SETCNTRLVALUE = A.BUSINESS_UNIT) AND LOC.EFFDT = ( SELECT MAX(EFFDT) FROM PS_LOCATION_LANG LOC1 WHERE LOC.LOCATION = LOC1.LOCATION AND LOC1.EFFDT <= %CurrentDateIn)) Location_Descr, ( SELECT DISTINCT(JOBCD.DESCR) FROM PS_JOBCODE_LANG JOBCD WHERE JOBCD.JOBCODE=A.JOBCODE AND JOBCD.SETID = ( SELECT SETID FROM PS_SET_CNTRL_TBL WHERE SETCNTRLVALUE = A.BUSINESS_UNIT) AND JOBCD.EFFDT = ( SELECT MAX(JOBCD1.EFFDT) FROM PS_JOBCODE_LANG JOBCD1 WHERE JOBCD.JOBCODE = JOBCD1.JOBCODE AND JOBCD1.EFFDT <= %CurrentDateIn)) JOBCODE_DESCR FROM PS_POSITION_DATA A, PS_POSN_DATA_LANG B WHERE A.EFFDT = ( SELECT MAX(C.EffDt) FROM PS_POSN_DATA_LANG C WHERE C.Position_Nbr = A.Position_Nbr AND C.Effdt <= %CurrentDateIn) AND A.Position_Nbr = B.Position_Nbr AND A.EFFDT = B.EFFDT |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | POSITION_NBR | Character(8) | VARCHAR2(8) NOT NULL |
Position Number
Default Value: 0 |
2 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
3 | EFFDT | Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
5 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
6 | ACTION_REASN_DESCR | Character(50) | VARCHAR2(50) NOT NULL | Action Reason Description |
7 | COMPANY_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Company Descr |
8 | DEPT_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Department Description |
9 | UNION_CODE_DESCR | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
10 | LOCATION_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Location Description |
11 | JOBCODE_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Job Code Description |