POSITION_NBRDefault Value: 0
EFFDTDefault Value: %date
Default Value: OPR_DEF_TBL_HR.BUSINESS_UNIT
Prompt Table: BUS_UNIT_TBL_HR
A=Approved
P=Proposed
R=Frozen
Default Value: A
LMS_POS_NOMX_VW(SQL View) |
Index Back |
|---|---|
LMS JobCode w/o Mx Position VwLMS_POS_NOMX_VW is a view on Position Data for JobCodes having no Matrix rate codes. |
| SELECT P.POSITION_NBR , P.EFFDT , P.DESCR , P.DESCRSHORT , P.BUSINESS_UNIT , P.POSN_STATUS FROM PS_POSITION_DATA P , PS_JBCDCMP_NOMX_V V WHERE P.EFF_STATUS = 'A' AND P.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_POSITION_DATA B WHERE B.POSITION_NBR = P.POSITION_NBR AND B.EFFDT <= %CurrentDateIn) AND P.JOBCODE = V.JOBCODE AND V.EFFDT = ( SELECT MAX(W.EFFDT) FROM PS_JBCDCMP_NOMX_V W WHERE W.SETID = V.SETID AND W.JOBCODE = V.JOBCODE AND W.COMP_RATECD = V.COMP_RATECD AND W.EFFDT <= P.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 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 5 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_HR.BUSINESS_UNIT Prompt Table: BUS_UNIT_TBL_HR |
| 6 | POSN_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Position Status
A=Approved P=Proposed R=Frozen Default Value: A |