BUSINESS_UNITPOSITION_NBRLANGUAGE_CDEFFDTDefault Value: %date
HRS_POS_RJ_LNG(SQL View) |
Index Back |
|---|---|
Position Data ViewRelated Language view for HRS_POS_RP. Built on the Profile Relationship table and Position data table, in order to retrieve the Position data corresponding to Non-person 'JOB' profiles with Jobcode as Profile Identity. |
| SELECT B.BUSINESS_UNIT ,A.POSITION_NBR ,A.LANGUAGE_CD ,A.EFFDT ,A.DESCR ,A.DESCRSHORT FROM PS_POSN_DATA_LANG A , PS_POSITION_DATA B , PS_JPM_JP_X_RLAT C WHERE A.POSITION_NBR = B.POSITION_NBR AND A.EFFDT = B.EFFDT AND B.JOBCODE = %Substring(C.JPM_RLAT_KEY1,1,6) AND C.JPM_RLAT_NAME = 'JOB_CODE' AND %EffdtCheck(JPM_JP_X_RLAT D,C,%currentdatein) AND %EffdtCheck(POSN_DATA_LANG E,A,%currentdatein) AND %EffdtCheck(POSITION_DATA F,B,%currentdatein) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | POSITION_NBR |
Character(8) | VARCHAR2(8) NOT NULL | Position Number |
| 3 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 4 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 6 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |