BUSINESS_UNITPOSITION_NBREFFDTDefault Value: %date
A=Active
I=Inactive
HRS_POS_RJ(SQL View) |
Index Back |
|---|---|
Position Data View rellangView 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 A.BUSINESS_UNIT ,A.POSITION_NBR ,A.EFFDT ,A.EFF_STATUS ,A.DESCR ,A.DESCRSHORT ,A.JOBCODE ,B.JPM_PROFILE_ID FROM PS_POSITION_DATA A , PS_JPM_JP_X_RLAT B WHERE A.JOBCODE = %Substring(B.JPM_RLAT_KEY1,1,6) AND B.JPM_RLAT_NAME = 'JOB_CODE' AND %EffdtCheck(JPM_JP_X_RLAT C,B,%currentdatein) AND %EffdtCheck(POSITION_DATA D,A,%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 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 4 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 6 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 7 | JOBCODE | Character(6) | VARCHAR2(6) NOT NULL | Job Code |
| 8 | JOB_PROFILE_ID | Character(12) | VARCHAR2(12) NOT NULL | Job Profile ID |